Home » RDBMS Server » Networking and Gateways » Oracle Connection (Windows)
Oracle Connection [message #470175] Mon, 09 August 2010 04:36 Go to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

Hi

Please Check the session
======================================================
C:\Documents and Settings\Administrator>tnsping ACE032

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-AUG-2010 15:00:17

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.195.175.32)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =
ORCL)))
OK (10 msec)

C:\Documents and Settings\Administrator>sqlplus sys/ace123@ACE032 as sysdba;

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 9 15:00:48 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:

============================================================
Please Give me this solution
Re: Oracle Connection [message #470176 is a reply to message #470175] Mon, 09 August 2010 04:39 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
oracle ~ $ oerr ORA 12514
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
// *Cause:  The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener.  This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
//  - Wait a moment and try to connect a second time.
//  - Check which services are currently known by the listener by executing:
//    lsnrctl services <listener name>
//  - Check that the SERVICE_NAME parameter in the connect descriptor of the
//    net service name used specifies a service known by the listener.
//  - If an easy connect naming connect identifier was used, check that
//    the service name specified is a service known by the listener.
//  - Check for an event in the listener.log file.
oracle ~ $

Re: Oracle Connection [message #470180 is a reply to message #470176] Mon, 09 August 2010 04:52 Go to previous messageGo to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

All Parameters are Correct
Re: Oracle Connection [message #470192 is a reply to message #470180] Mon, 09 August 2010 05:14 Go to previous messageGo to next message
John Watson
Messages: 8704
Registered: January 2010
Location: Global Village
Senior Member
Bypass the tnsnames.ora and sqlnet.ora files, and see what happens:

sqlplus sys/ace123@192.195.175.32:1521/ORCL as sysdba

if that works, you know your problem is with the listener.
Re: Oracle Connection [message #470204 is a reply to message #470192] Mon, 09 August 2010 05:46 Go to previous messageGo to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

It Doesn't work
Thanks Manish
Re: Oracle Connection [message #470210 is a reply to message #470204] Mon, 09 August 2010 05:55 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
So what's the output of
lsnrctl services <listener name>


on the SERVER?
Re: Oracle Connection [message #470229 is a reply to message #470210] Mon, 09 August 2010 06:26 Go to previous messageGo to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

Hi
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 09-AUG-2010 16:51:33

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ace51)(PORT=1521)))
Services Summary...
Service "ORCL1XDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: ACE51, pid: 3820>
(ADDRESS=(PROTOCOL=tcp)(HOST=ace51)(PORT=1047))
Service "ORCL1_XPT" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Service "ORCL_XPT" has 1 instance(s).
Instance "orcl", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orcl1" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
The command completed successfully


Thanks & Regards
Manish
Re: Oracle Connection [message #470257 is a reply to message #470229] Mon, 09 August 2010 07:46 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
maniatniit wrote on Mon, 09 August 2010 13:26

.....
Service "orcl" has 1 instance(s).
Instance "orcl", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
......


A BLOCKED status means that the instance cannot accept connections.

Have you tried re-starting the instance? Any error in the alert.log of the instance?

[Updated on: Mon, 09 August 2010 07:46]

Report message to a moderator

Re: Oracle Connection [message #470293 is a reply to message #470204] Mon, 09 August 2010 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
maniatniit wrote on Mon, 09 August 2010 12:46
It Doesn't work
Thanks Manish

It doesn't work is NOT an Oracle message.

When you post something like this, no one can help.
You MUST explain what means "it does not work" and post the COMPLETE error message if any.

Regards
Michel

Re: Oracle Connection [message #474819 is a reply to message #470293] Thu, 09 September 2010 03:26 Go to previous messageGo to next message
Jesmin
Messages: 1
Registered: September 2010
Junior Member
I have a troubleshooting problem with my wifi connection with oracle database...will you please give me the suggestion for this????
Re: Oracle Connection [message #474825 is a reply to message #474819] Thu, 09 September 2010 03:55 Go to previous message
Michel Cadot
Messages: 68166
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have a troubleshooting problem with my car...will you please give me the suggestion for this????
Previous Topic: TNS : lost contact
Next Topic: Frequent Ora-12537 Errors
Goto Forum:
  


Current Time: Sun May 22 13:04:04 CDT 2022