Re: ORA-12545 Error...

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

> > >