Re: ORA-12545 Error...

Allows the I(nter)P(rocess)C(ommunication) protocol to be used.

Hth,

Sybrand Bakker, Oracle DBA

"Diviner" <diviner_at_hknet.com> wrote in message news:3B161AF9.F3851B67_at_hknet.com...
> Thank you very much. The problem is fixed. You are right. My
> LISTENER.ORA is missing the following statement:
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> Would you briefly explain what this statement does?
>
> --
> Best regards,
> Diviner.
>
>
> > On Thu, 31 May 2001 16:21:45 +0800, Diviner <diviner_at_hknet.com> wrote:
> >
> > >I am using Oracle8i 8.1.7 for NT and running on Windows 2000 Server,
> > >NT4 Workstation for client machine and has a connection problem.
> > >Hope someone can help me.
> > >
> > >The main problem is this error:
> > > "ORA-12545: Connect failed because target host or object does not
> > >exist"
> > >when I try to connect Oracle Server from client machine.
> > >
> > >Let me state my situation point by point:
> > >- Oracle server is started up and work normally.
> > >- Oracle client on the same machine(server machine) work well by
> > >sqlplus.
> > > e.g.: sqlplus scott/tiger_at_prj1 (follow by successful connection)
> > >- Oracle client on the other machine(client machine) can tnsping on
 both
> > >
> > > alias and service_name successfully.
> > >- ORA-12545 error occur when I use sqlplus to connect Oracle server
 from
> > >
> > > client machine.
> > >
> > >Thank you very much.
> >
> > tnsping *only* guarantees there is a listener running on the host
> > you're trying to connect to.
> > There must be a mismatch between tnsnames.ora (on the client) and
> > listener.ora on the server.
> > It works on the server because you have ORACLE_SID set, and use IPC
> > automatically.
> >
> > Check the tnsnames.ora on the client.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
>
Received on Fri Jun 01 2001 - 01:26:44 CDT