Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to create new instance ?
Hi there
I'm new to the more advanced Oracle setups.
We are running Oracle 7.3.2 on a Solaris 2.5.1/Ultra 2, but are in need of a second instance of our db for development purposes.
I've tried to use the script's shipped with Oracle:
/opt/app/oracle/admin/<sid>/create/crdb<sid>.sql
/opt/app/oracle/admin/<sid>/create/crdb2<sid>.sql
/opt/app/oracle/admin/<sid>/pfile/init<sid>.ora
/opt/app/oracle/admin/<sid>/pfile/config<sid>.ora
(of course I had to create a new set of files and modify them)
..it seems to work, the instance can be started, but it's not created
properly.
Eg. all the packages and other system tables are missing.
What do i need to do ??
Regards, Tom Received on Wed Mar 05 1997 - 00:00:00 CST