Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 db instances on 1 NT server can't connect to one from 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)
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:tse89topcua02f6o5opj8rui5m7c4mit0d_at_4ax.com...
> On Wed, 21 Feb 2001 18:57:18 GMT, "James Higgins"
> <jhiggins_at_conway-ward.com> wrote:
>
> >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. chaned host name in tns to ip address of host and
> >still get same error is this an NT thing or a SQLNET thing ?????
> >
> >any assitance would by helpful.
> >
> sqlnet, which can't be resolved without looking at the affected ora
> files.
>
> >