Re: Oracle9i and CREATE DATABASE

I suppose your confusion arises from the fact that 'connect sys/haslo as sysdba' works, and you therefore believe that the password file has been read and understood -and then it bombs out on you!

So, try the following:

connect kgdfjdhfgouebfdgdjgjdfg/jdfksdjfdfjskfdsjfksf as sysdba

I reckon it will work (but I might be wrong). If it does, it means you have O/S authentication enabled (nothing wrong with that if so), and the initial 'connect sys/haslo...' is being ignored as much as the gibberish above would be.

Which would mean that you don't have a problem of one minute Oracle understanding the password file, and another not, but that it *never* understands it. You get connected, and get your instance because O/S authentication has kicked in. But when the init.ora says to use the EXCLUSIVE password file, sparks fly.

The simplest fix, if the above connect works, would be to set remote_login_passwordfile to NONE, and proceed to create your database.

The alternative is to delete the existing password file, make sure the Windows account you're using is not a member of the ORA_DBA group (otherwise O/S authentication will kick in and you won't be able to tell if the password file is working or not), and then use the orapwd command line tool to create a brand new password file.

The syntax should be evident if you do 'orapwd /?' at the command line.

Regards
HJR "Jacek Hachuła" <jhachula_at_polsnack.pl> wrote in message news:b7dtqd$5uj$1_at_news.polbox.pl...
> 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 - 05:55:14 CDT