Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to create new instance ?

How to create new instance ?

From: Tom Helmer Jensen <thelmer_at_ruc.dk>
Date: 1997/03/05
Message-ID: <thelmer-0503971907380001@power-fm.ruc.dk>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US