Re: Troubles with my first create database

"Francesco" <fmarchioniNIENTESPAM_at_libero.it> wrote in message news:xQKta.95025$iy5.2936439_at_twister2.libero.it...
> Hi all,
> I'm trying to create a new database manually on WinNT.
> I have created init$ORACLE_SID.ora file
> and started up (with nomount) the database.
> Then I issue the CREATE DATABASE commands...
> everything seems going fine (control files and redo logs
> are created) but in the end I get an error
>
> ORA-01501 CREATE DATABASE FAILED
> ORA-01991 File password 'C:\oracle\ora81\database\PWDtestdb.ORA' not valid
>
> "testdb" is the db I have created with Oracle installation. So it seems
that
> it's pointing to the wrong password file. How can I direct it to the
> password
> file I have created (with orapwd utility) ?
> Thanks a lot
> Francesco

You need to make sure that ORACLE_SID is set in the DOS window where you type the create database command before you launch SQL Plus. So, at the command prompt, just type: 'set ORACLE_SID=newdb' (or whatever your new database is to be called), and then 'sqlplus /nolog' and then 'connect....' and then 'create database....'.

There are a couple of other ways of setting ORACLE_SID in Windows (the registry for one, the Oracle Home Selector for another, and the Control Panel - System - Environment tab for another). But just typing it in whenever you launch a DOS window is probably the simplest quick-fix way of doing it.

Regards
HJR Received on Tue May 06 2003 - 11:42:47 CDT