Re: Create 2nd instance in NT through Enterprise Manager

From: joseph Li <lijoecyn_at_netspace.net.au>
Date: 2 Jun 1998 13:13:10 GMT
Message-ID: <6l0tp6$gtt$3@otis.netspace.net.au>

Say the SID of your second instance is to be TEST. Firstly create initTEST.ora, then use the NT instance manager ( ORADIM73 ) to create the service, then CREATE DATABASE ... After that try connect to TEST using SVRMGR23 ie. From DOS prompt :- SET ORACLE_SID=TEST , SVRMGR23 , connect internal. If successful, TEST is ok. Then you can configure TNSNAMES.ora, LISTENER.ora for SQL*Net access to the instance TEST. Hope this help.

Regards

In article <6kv606$ehs$2_at_news.sas.ab.ca>, suisum_at_freenet.edmonton.ab.ca () says:
>
>Hi:
>
>I have difficulty to make the 2nd instance worked in WIN NT 4.0. I have no
>way to connect to the 2nd instance instance. The error is TSNname cannot
>be resolved, wrong SID. I'm pretty sure that the all the initxxx.ora files
>are there. The service and the database has been started properly in WIN
>NT.
>
>Also, I have no way to create a new instance through the Enterprise
>Manager - Instance Manager if I don't create the initxxx.ora before hand.
>
>--
>Best regards,
Received on Tue Jun 02 1998 - 08:13:10 CDT