Re: Oracle9i and CREATE DATABASE

From: Hartmut Inerle <hinerle_at_netscape.net>
Date: Mon, 14 Apr 2003 11:47:16 +0200
Message-ID: <3E9A83A4.4030708@netscape.net>

Hello,

Try to create a password file with orapwd file=orapw<SID> entries=20 password="password of your choice".
The password stuff is wrongly documented. Since 8.1.7 the password filename has to be orapw+"ORACLE_SID".

After the creation you can set REMOTE_LOGIN_PASSWORD_FILE=EXCLUSIVE.

regards

Hartmut

Jacek Hachu³a wrote:
> Environment : Oracle 9i v.9.2.0.1, WindowsXP Prof
> Problem :
> - REMOTE_LOGIN_PASSWORDFILE set on EXCLUSIVE, after instance creation
> passwordfile "pwdchio9.ora" is created,
> - I'm connecting from sqlplus /nolog, next connect sys/haslo as sysdba,
> next startup nomount - everything is ok,
> - I'm trying to execute CREATE DATABASE statement and message is
> ORA-01092
>
> Logs are:
> Errors in file c:\oracle\admin\chio9\udump\chio9_ora_3324.trc:
> ORA-01501: unsuccesfull CREATE DATABASE
> ORA-01991: wrong passwordfile
> 'C:\Oracle\Ora9i\DATABASE\PWDchio9.ORA'
>
> *** SESSION ID:(9.1) 2003-04-14 10:24:30.000
> ORA-01501: unsuccesfull CREATE DATABASE
> ORA-01991: wrong passwordfile
> 'C:\Oracle\Ora9i\DATABASE\PWDchio9.ORA'
>
> What's wrong?
>
>
>
Received on Mon Apr 14 2003 - 04:47:16 CDT