Re: How can I create a second database on the same windows nt machine?

In article <7ksrk1$2fa$1_at_news.seicom.net>,   "Digger" <GbD_at_integrata.de> wrote:
> we use Oracle 7.3 on Windows NT.
> I want to run two databases on the same machine.
> At the moment we have installed one database using orainst.
> What must I do to create the second database and
> how can I access it?
>
> thanks for your help,
>
> Dirk Grabenhorst
>
>

Hi Dirk,
There possible methods
The 'automatic' one
copy the init<oldsid>.ora to init<newsid>.ora Edit the latter file to change any sid specific items (control_files parameter! etc)
Now use the Oracle Instance Manager in GUI mode to create a new instance. On the advanced tab you will be able to specify location and size of the system tablespace and the redo log files. Note: this used to create the database and a second thread running the standard initialization scripts, over which you have NO control. The 'manual' option
First create the init<newsid>.ora as described above. Then start a DOS session and now run ORADIM73 to create a new sid. This creates and starts new services only. Refer to the manual or technet.oracle.com for exact syntax.
Now you need to create a file with a create database statement run svrmgr23 (make sure ORACLE_SID env var or registry has the correct value)
connect internal
startup nomount
run the create database script
run %ORACLE_HOME%/rdbms73/admin/catalog.sql

                                catproc.sql
                                catexp.sql

This should be all with respect to creation Now you need to modify listener.ora and tnsnames.ora listener.ora on the server only, tnsnames.ora on all systems accessing oracle. After that restart or reload the listener.

Having done that you should be able to access both databases by sqlplus username/password_at_service_name

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 24 1999 - 07:11:55 CDT