Re: ORA-12545 Error...

Connect problem is fixed. Because I found a good actical from Oracle Technet:

   http://technet.oracle.com/doc/windows/server.804/a55913/apc.htm

--
Best regards,
Diviner.



> Diviner wrote:

>

> > Sybrand Bakker,

> >

> > So how shall I change "PRJ1.ABC.NET" in following if I avoid

> > the seudo host name and use real IP instead? And isn't it I can

> > use ANY wording as Server Name if it is match to init.ora?

> >

> > # TNSNAMES.ORA Network Configuration File:

> > D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora

> > # Generated by Oracle configuration tools.

> > PRJ1.ABC.NET =

> >   (DESCRIPTION =

> >     (ADDRESS_LIST =

> >       (ADDRESS = (PROTOCOL = TCP)(HOST = 202.195.163.81)(PORT = 1521))

> >     )

> >     (CONNECT_DATA =

> >       (SERVICE_NAME = test)

>

> (SERVICE_NAME = edm1)   // do correction...

>

> >

> >       (SID = prj1)

> >     )

> >   )

> >

> > And my INIT.ORA change like this, does it ok?

> > db_name = "prj1"

> > db_domain = 202.195.163.81

> > instance_name = prj1

> > service_name = edm1

> >

> > Thank you very much.

> >

> > ---

> > Best regards,

> > Diviner.

>

> I still cannot connect to there. My SQLNET.ORA like this:

> NAMES.DEFAULT_DOMAIN = 203.194.162.81

>

> Does it correct? Why I still can't connect it?

>

> --

> Best regards,

> Diviner.

>

> >

> > > 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

> > > >