Sen,
The instance that you are pointing to from sql worksheet
is already mounted. To understand more clearly what
is happening I would:
- Log into the server where the database is to reside.
- Ensure that your ORACLE_SID is pointing to the correct
database that you are creating. echo $ORACLE_SID
- You should have already created an init.ora for the
this database which should reside in the ORACLE_HOME/dbs
directory ( or a link in ORACLE_HOME/dbs pointing to another location
).
- Enter into SVRMGRL
- Perform CONNECT INTERNAL & STARTUP NOMOUNT
( if your init.ora has problems you will see them now ).
- Now perform your create command. Database will be
opened if this completes successfully.
- Now run ORACLE_HOME/rdbms/admin/catalog & catproc
- Other odds and ends; add an entry to ORATAB to automatically
start the database, add an entry for the service in tnsnames.ora and
listener.ora
- Change the SYSTEM password from MANAGER & change the SYS
password from CHANGE_ON_INSTALL
- Back up the database or risk performing steps 1-9 again.
Also, you need a minimum of two log files, one being used, and one ready
to use.
Phil Cook
Received on Sat Mar 14 1998 - 00:00:00 CST