View Single Post

   
  #5 (permalink)  
Old 02-25-2008, 08:19 AM
Sybrand Bakker
 
Posts: n/a
Default Re: error while manually creating database

On 23 Sep 2006 02:48:17 -0700, "radian7" <radian7@poczta.onet.pl>
wrote:

>Hi
>
>I solve this by change parameter remote_login_passwordfile from
>EXCLUSIVE to SHARED...


So Oracle won't use a password file anymore, and only SYS will have
SYSDBA privilege

You can recreate the password file by renaming the current one, and
using the dos orapwd utility

syntax orapwd file=<your file, you *have* to use the name from your
tracefile> password= entries=

--
Sybrand Bakker, Senior Oracle DBA
Reply With Quote