| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12545 Error...
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)
(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.Received on Mon Jun 04 2001 - 23:09:57 CDT
> 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
> >
 |
 |