CREATE DATABASE QUESTION?

[StickyBit]

Hi folks,

I'm new to Oracle and I have question on database creation. I have used the following script to create a test database.

#!/bin/sh
ORACLE_SID=stickydb
export ORACLE_SID

/u01/app/oracle/product/8.1.7/bin/svrmgrl << EOF
spool /u01/app/oracle/admin/stickydb/create/seed.log
connect internal
startup nomount pfile = &quot;/u01/app/oracle/product/8.1.7/dbs/initstickydb.ora&quot;
CREATE DATABASE &quot;stickydb&quot;
maxdatafiles 254
maxinstances 8
maxlogfiles 32
character set US7ASCII
national character set US7ASCII
DATAFILE '/u02/oradata/stickydb/system01.dbf' SIZE 260M AUTOEXTEND ON NEXT 10240K
LOGFILE '/u02/oradata/stickydb/redo01.log' SIZE 5000K,
'/u02/oradata/stickydb/redo02.log' SIZE 5000K,
'/u02/oradata/stickydb/redo03.log' SIZE 5000K;
disconnect
spool off
exit


EOF

After the database is created the script dosen't create adhoc, arch, bdump, cdump, create, exp, pfile, udump directories in the $ORACLE_BASE/admin directory.

What am I missing in my script?

StickyBit.

 

[rcurva]

The directories that you specified are not created by the CREATE DATABASE command, It is manually created (by the DBA) to conform with OFA standards.

Robbie

&quot;The rule is, not to besiege walled cities if it can possibly be avoided&quot; -- Art of War