Re: ORA-12545 Error...

12154 means 'Can't find the service name in tnsnames.ora' 12514 means 'The service name in the connect descriptor doesn't match the service name on the server' This is the service_name parameter defined in init.ora (as you are using 8i syntax in listener.ora, you don't define it there, which is recommended).
Verify the service_name from init.ora against the service_name in the connect descriptor (so connect_data = (service_name=.....)) They don't match.
Also make sure to verify sqlnet.ora on both sides especially names.default_domain and names.default_zone Usually the host name should be the *real* host name of the system, your 'experiments' with aliasing it might betray you have a shitty network config.

Hth,

Sybrand Bakker, Oracle DBA

"Diviner" <diviner_at_hknet.com> wrote in message news:3B1711F6.53C290C5_at_hknet.com...
> I tried to modified the listener.ora on server side. I got success to
 connect
> it
> by several time. But I don't know why, after a day, it has error again! My
> listener.ora like this:
> # LISTENER.ORA Network Configuration File:
> c:\oracle\ora81\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = cpnt2ksrv2)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = c:\oracle\ora81)
> (PROGRAM = extproc)
> )
> )
>
> I can ping "cpnt2ksrv2" from server side ITSELF, the result is correct. I
> have also
> changed HOST to a host name which can ping from client side, but still not
> work.
> (for example, I set "prj1" host name in HOSTS file on both server and
 client
> side
> to point to the server IP and then change the HOST parameter in
 listener.ora
> to "prj1"
> and restart the listener service).
>
> My "tnsnames.ora" like this:
> # TNSNAMES.ORA Network Configuration File:
> D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> PRJ1.CYBERPROJECT.NET =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = prj1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = prj1.cyberproject.net)
> )
> )
>
> On try and error stage(connect Server from Client by SQLPLUS for many and
> many times),
> I strange to say that why meet the error for just 3 times:
> "TNS-12514 TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor"
>
> I have no make any changes on anything. I keep in try SQLPLUS and then I
 got
> the old error
> again(at lease this error may be more properly):
> "ORA-12545: Connect failed because target host or object does not exist"
>
> Now, I still get rid for this ORA-12545 error. Would you tell me more
 about
> this and
> the trouble-shooting approach?
>
> Thank you very much.
>
> --
> 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:32:27 CDT