Re: newbie create database command help needed

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