Re: newbie create database command help needed

Or, you could check the setting of password mode in init<sid>.ora - if it is exclusive change it to none and try again. Although I am sure SB is probably correct - I had this problem once too.

Sybrand Bakker wrote:
>
> You need to define a new sid
> (in your case vl1)
> add that sid to /var/opt/oracle/oratab
> like
> vl1:<your location of oracle home>:Y
> Last value Y|N for autostart
> either export ORACLE_SID=vl1 manually or run
> . oraenv
>
> (should be in /usr/local/bin or /opt/bin)
> The initvl1.ora needs to exist in $ORACLE_HOME/dbs
> prior to creating the database.
> Don't forget the startup nomount prior to the create database command.
>
> so
> 1 edit oratab
> 2 set ORACLE_SID and ORACLE_HOME
> 3 create initvl1.ora
> 4 svrmrgl
> 5 connect internal
> 6 startup nomount
> 7 create database as below
> 8 @$ORACLE_HOME/rdbms/catalog
> 9 @$ORACLE_HOME/rdbms/catproc
>
> This should be it.
> Pwfile problem is because of empty ORACLE_SID
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Vipul Lakhani <vipul_at_dircon.co.uk> schreef in berichtnieuws
> O_ET4.1246$Kc1.174796_at_news.dircon.co.uk...
> > Hi
> >
> > Hoping somone can help me here
> >
> > I installed oracle 8.1.5 on solrais 2.6 (Sun E250)
> >
> > I used the starter db to get people developing and now want to make an
> > additional db for testing
> >
> > so i used the create database command and got the following back .... the
> > oracle manuals mention the utility for the pass word file but
> >
> > 1 what is teh utility for
> > 2 why should i use
> > 3 the password util mentions the path name may or may not have to be
 used --
> > well does it my case
> >
> > if i sound confused then i apologise --- but i just want to noddy (so a
 lame
> > newbie) instructions on what to do next
> > eg
> > SVRMGR> CREATE DATABASE "vl1"
> > 2> NOARCHIVELOG
> > 3> /* using actual control file values */
> > 4> MAXLOGFILES 16
> > 5> MAXLOGMEMBERS 2
> > 6> MAXDATAFILES 30
> > 7> MAXINSTANCES 1
> > 8> MAXLOGHISTORY 168
> > 9> DATAFILE '/d1/system01.dbf' SIZE 175M
> > 10> LOGFILE
> > 11> GROUP 1 ('/d1/redo02.log' ) SIZE 500K,
> > 12> GROUP 2 ('/d1/redo01.log' ) SIZE 500K;
> > CREATE DATABASE "vl1"
> > *
> > ORA-01501: CREATE DATABASE failed
> > ORA-01990: error opening password file
> > '/u01/app/oracle/product/8.1.5/dbs/orapw'
> >
> >
> >
Received on Mon May 15 2000 - 00:00:00 CDT