On Tue, 22 Jun 1999 12:56:55 -0400, Xueyou Hu <xhu_at_cceb.upenn.edu>
wrote:
SID is an identifier which oracle uses in default detection of i.e.
password files
init<SID>.ora.
The SID should be unix.
The database name is a name you can give to the database. Oracle
recomends you choose db_name=SID to avoid confusion.
When you have created 2 db then there will be 2 instance running.
Check this in the services.
Then the listener should listen to and from the 2 db.
Check this by issueing the lsnrctl80 command. LSNCTL> status.
If all is right you should see 2 handllers with the SID.
With net8easy config (GUI tool) you can make a connect string (the
tnsnames.ora will be modified). Any string is possible. You need 2
distinct conect strings for each SID or db.
Connect now with sqplus system/manager_at_connectstring.
>Hello, everyone:
>
>I have created two databases on Windows NT, now I only can startup one
>database once, can you tell me how to set up service name, SID to make
>ensure receive request from client, and keep two database running at the
>same time. In Windows NT, SID acn not be longer tham fours characters,
>what is the difference between SID and db_name on Windows NT
>
>**
>Oracle 7.3
>
>**
>db_name_01: oracle
>
>db_name_02: oraexp
>
>
>
>thanks in advance.
>
>
>Sincerely,
>
>Stanley X. Hu
>
Received on Tue Jul 27 1999 - 15:50:15 CDT
