| ORACLE NT service starting problem TNS-12514 [message #99478] |
Tue, 27 November 2001 15:56  |
F.Burgisser
Messages: 2
Registered: November 2001
|
Junior Member |
|
|
I'm using ORACLE 8.1.6 on NT5.
The service as the status "starting" every time.
I can start the database with the svrgmrl but it doesn't solve my problem because I don't want to start it manually every time.
It was working fine before.
I deleted the trace files but nothing changed.
Before this problem happen I just updated Norton Anti-virus. I think there isn't any realtion but I'm not sure. I can't figure out the problem. The configuration didn't changed.
Any ideas?
Thanks
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
| Re: ORACLE NT service starting problem TNS-12514 [message #101371 is a reply to message #99478] |
Thu, 02 September 2004 08:01  |
Lalit Kumar
Messages: 2
Registered: September 2004
|
Junior Member |
|
|
I was getting the same error. I was able to TNSPING and also connect using SQLPLUS when I did not give the HOST_STRING.
My environment is :
Windows XP Prof, Oracle Version 9.2.0.1.0. But I guess conceptualy it will be same for other versions too.
This is what I found after looking at various sites and doing many tries.
This error was coming due to mismatch in the SERVICE_NAME given in tnsnames.ora and what was registered with the listener. Actually, listener is comparing the connect SERVICE_NAME passed from client site to the one registered with it. If nothing matches, it gives TNS-12514.
To check if they are the same, do the following:
1. run "LSNRCTL services" to check the services names registered with oracle. For example if one of the database service name is "LKDW" (which could be Oracle SID for Oracle 8.xx)
2. Make sure that this is the service name (i.e. "LKDW") in tnsnames.ora if you are using Oracle 9.xx type specs or you specify SID as "LKDW" for Oracle 8 type connections. Example is given below.
Output of "lsnrctl services"----> (Note the LKDW)
--------------------------------
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fujisap)(PORT=1521)))
Services Summary...
Service "LKDW" has 1 instance(s).
Instance "LKDW", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "LKDWXDB" has 1 instance(s).
Instance "LKDW", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: FUJISAP, pid: 1136>
(ADDRESS=(PROTOCOL=tcp)(HOST=fujisap)(PORT=3875))
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:
LOCAL SERVER
The command completed successfully
LSNRCTL>
----------------------------
Output of tnsnames.ora (for Oracle 8i type connections)
---------------------------------
LKDW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = FUJISAP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lkdw)
)
)
----------------------------
OR if using oracle 8 type connection string:
----------------------------
LKDW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = FUJISAP)(PORT = 1521))
)
(CONNECT_DATA =
(SID = LKDW)
)
)
--------------------------
I was giving a different name than "LKDW" in tnsnames.ora and I was getting TNS-12514 error.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
