Oracle Connection [message #470175] |
Mon, 09 August 2010 04:36 |
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 |
ThomasG
Messages: 3212 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 #470229 is a reply to message #470210] |
Mon, 09 August 2010 06:26 |
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 |
ThomasG
Messages: 3212 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 #474819 is a reply to message #470293] |
Thu, 09 September 2010 03:26 |
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 |
|
Michel Cadot
Messages: 68732 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
I have a troubleshooting problem with my car...will you please give me the suggestion for this????
|
|
|