Re: 2 Instances on NT server

here is a copy of the listner.ora i believe the SID is in there as u said

any other ideas???

James Lorenzen wrote:

> You also need to configure your listner on the server to "see" both
> instances. This is the "listner.ora" file in "%ORACLE_HOME%\network\admin".
> The missing SID needs to be added to the SID list.
>
> You may confirm what the listner is monitoring by going to the commnad
> prompt and entering "lsnrctl services", this command will display the
> services that are being monitored on that server.
>
> After changing the listner.ora file, you will need to reload the listner
> ("lsnrctl reload") or bounce the listner.
>
> HTH
> James
>
> "James Higgins" <jhiggins_at_conway-ward.com> wrote in message
> news:3A968D23.2148451_at_conway-ward.com...
> > I have 2 db instances loaded on an NT server. On the server i can connect
 to
> > both with sqlplus.
> > on the client i can connect to only 1 of the instances. i have 1 listener
> > for both instances. i copied server side tns and sql .ora's to all my
 client
> > side directories (as i have 2 oracle homes) and this doesnt work getting
> > the follownig error consitantly ORA- 12545 connect failed because target
> > host or object does not exist. changed host name in tns to ip address of
 host
> > and still get same error have done a tnsping from client and connects
 ok....
> >
> > is this an NT thing or a SQLNET thing ?????
> >
> > any assitance would by helpful.
> > -----------these files are in the server and client----------
> > # SQLNET.ORA Network Configuration File:
> > F:\Apps\Server_Apps\oracle\ora81\network\admin\sqlnet.ora
> > # Generated by Oracle configuration tools.
> >
> > NAMES.DEFAULT_DOMAIN = cwi
> >
> > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> >
> > NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
> >
> > # TNSNAMES.ORA Network Configuration File:
> > F:\Apps\Server_Apps\oracle\ora81\network\admin\tnsnames.ora
> > # Generated by Oracle configuration tools.
> >
> > DEV.CWI =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = cw_server_1)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = dev.cwi)
> > )
> > )
> > TEST.CWI =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = cw_server_1)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = test.cwi)
> > )
> > )
> >
> > EXTPROC_CONNECTION_DATA.CWI =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > )
> > (CONNECT_DATA =
> > (SID = PLSExtProc)
> > (PRESENTATION = RO)
> > )
> > )
Received on Fri Feb 23 2001 - 11:21:51 CST