ORA-12514: TNS:listener does not currently know of service requested in connect descriptor First of all, make sure the database is started. If it is not, you'll get this message (In 10g release 2).
C:>sc query OracleServiceXE
SERVICE_NAME: OracleServiceXE
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED
(NOT_STOPPABLE,NOT_PAUSABLE,IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 1077 (0x435)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
C:>sqlplus myuser@xe
SQL*Plus: Release 10.2.0.1.0
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
If the database is running, probably the database hasn't registered yet with the listener.
This occurs when the database or listener just starts up.
Normally this problem should be solved by waiting a minute or so.
If you are using dynamic registration (using the local_listener database parameter), you can try to register the database service with the listener using the following command (from Oracle 9i onwards):
alter system register;
If this does not work or you're using static registration, make sure the SERVICE_NAME entry used in the connection string (TNSNAMES.ORA, NAMES, OID, ...) matches a valid service know by the listener.
eg.
C:>tnsping ora920
TNS Ping Utility for 32-bit Windows: Version 9.2.0.7.0 - Production
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
c:oracleora920networkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DEV01)(PORT =
2491))) (CONNECT_DATA = (SERVICE_NAME = UNKNOWN) (SERVER = DEDICATED)))
OK (20 msec)
As one can see, this is the connection information stored in a tnsnames.ora file:
ORA920.EU.DBMOTIVE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEV01)(PORT = 2491))
)
(CONNECT_DATA =
(SERVICE_NAME = UNKNOWN)
(SERVER = DEDICATED)
)
)
However, the SERVICE_NAME UNKNOWN is not known by the listener at the database server side.
In order to test the known services by a listener, we can issue following command at the database server side:
C:>lsnrctl services
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DEV01)(PORT=1521)))
Services Summary...
Service "ORA10G.eu.dbmotive.com" has 1 instance(s).
Instance "ORA10G", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "ORA920.eu.dbmotive.com" has 2 instance(s).
Instance "ORA920", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "ORA920", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Know services are ORA10G and ORA920.
Changing the SERVICE_NAME in our tnsnames.ora to a known service by the listener (ORA920.EU.DBMOTIVE.COM) solved the problem.
 Forum Messages
| when i insert a value in database then create this problem.please tell me how to solve this problem(ORA-12514) |
Hello,
Is this table a remote table? So are you inserting in a synonym or a view which is based on a table in a remote database?
Check the all_objects, all_synonyms and all_db_links data dictionary views.
|
Hello,
pls how do u create a datebase from command prompt without getting errors ,cause after shutingdown the current instance i tried starting up oracle as nomount it no gave me the following error.
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
|
Make sure your OracleServiceSID is running.
|
I have similar problem as above I have pasted the commands you have asked to execute as above
I am using OS as XP
and Oracle Database as Express edition 10g.
C:\Documents and Settings\aak>lsnrctl services
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-FEB-2008 20:08:43
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
"ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready
CLRExtProc
(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_8B8_FDCB4438.ORA))
"ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready
CLRExtProc
(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_8B8_FDCB4438.ORA))
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
The command completed successfully
TNSNAMES.ORA file content
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = USHYDASIFKHAN1.us.deloitte.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
At command promt
-------------------
Enter user-name: sys@XE/sam
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Can you help me resolving this error plz
|
What is the value of service_names?
Are you doing a local connection?
If so, you can try to access the databases like this:
set ORACLE_SID=XE
sqlplus "/ as sysdba"
show parameter service
|
Yes I am using it on a single machine OS XP
local connection only.
how can I find the service_names?
C:\Documents and Settings\aak>set ORACLE_SID=XE
C:\Documents and Settings\aak>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 5 23:03:12 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys@XE as sysdba
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor |
Can you change the tnsnames entry for XE to use localhost as a host instead of USHYDASIFKHAN1.us.deloitte.com
Can you also paste the listener.ora |
The below is the listner.ora file
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\OracleXP\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\OracleXP\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = USHYDASIFKHAN1.us.deloitte.com)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE) |
Is your database running?
Even if the OracleServiceXE is running, it can be possible that the database is not running.
If you login with an account different than "/ as sysdba" (like you do, you connect with SYS), you will get this error.
eg:
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> shutdown abort
ORACLE instance shut down.
SQL> conn
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> conn sys@xe as sysdba
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Warning: You are no longer connected to ORACLE.
SQL>
|
Hi,
I am trying to create a DSN through Control Panel>Administrative Tools...
But while testing the oracle connection, I am getting the following error-->
"ORA-12514: TNS:listener does not currently know of service requested in connect descriptor".
But I am able to connect to the oracle database and write queries directly.
Here is my contents of tnsnames.ora:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
And this is listener.ora content->
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)
Could you please guide me through...I am trying to make a JDBC connection, thats why I am creating a DSN.
Regards,
Sameer
|
Can it be that your database is not configured to use SERVICE_NAME
Try to change the SERVICE_NAME=ORCL ibnto SID=ORCL in your tnsnames.ora
|
I had a similar problem. I run XP as well with Oracle 10gR2. I tried almost everything possible to no avail. I just decided to bring my down my firewall and it resolved the problem.
U can then add port 1521 as a trusted connection so u can bring ur firewall back up after a system restart.
Send me an email if u ve further problems.
Wish u luck. |
Hi
I have been using Intools for instrumentation projects. Now I get this error( ORA 12514:listener could not resolve SERVICE_NAME). Plz give your suggestion |
| : -> 02-APR-2008 13:43:21 | New Oracle home | DbMotive | Reply |
Did you install new Oracle software on your pc?
What can happen is that a new Oracle home became the default Oracle home.
This Oracle home does not contain the correct files for name resolving, such as tnsnames.ora, sqlnet.ora and/or ldap.ora
You can use our tool Oracle Locator Express to switch between different Oracle Homes
|
I cant connect to my oracle database, i get the following message when i try connecting
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 8 16:11:57 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system@orcl/supervisor
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
What should i do?
|
| : -> 09-APR-2008 08:46:18 | Register service | DbMotive | Reply |
Try to connect / as sysdba and execute
alter system register
|
oracle client installed on winxp showning error
ORA-12514:TNS:Listener could not resolve SERVICE_NAME given in connect descriptor.
while checking on c:> prompt - c:> tnsping ora81 -- showing error message as TNS-03505:Failed to resolve name.
and checking c:> lsnrctl services -- it is saying not recognized .
plz help me solve this prob.. |
| : -> 18-APR-2008 13:22:55 | Info requested | DbMotive | Reply |
| Can you please post the tnsnames entry you are trying to connect to? |
I have W2003 server standar edition with oracle and we have 28 machines, but 2 machines don't have connection, those machines was in operation for two months but sudendly, yesterday at morning those machines didn't work, I restart the machines and I have connection with sqlplus, I really don't know what happend?
The log only shows error: ORA-12514
The others 26 are working fine. |
Entry for tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
Entry for listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
Entry for sqlnet.ora
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONNAMES)
)
When I am doing tnsping
D:\>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-MAY-2
008 17:36:06
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\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 = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (40 msec)
When I am doing lsnrctl services
D:\>lsnrctl services
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-MAY-2008 17:37
:32
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=orcl)))
Services Summary...
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
The command completed successfully
It is not showing me the instance for my service
And when I am doing this
D:\>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 14 17:38:56 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: tdcanada@orcl
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
However when I am doing just
Enter user-name: tdcanada
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
But I am not able to connect to the sqlDeveloper and connect the same to the application.In sqlDeveloper also I am getting the same error ora-12514.
I tried to restart the oracle services and Listener for so many time, I disabled my Antivirus also but for no help.
Could anyone suggest the probable problem for this. |
| : -> 15-MAY-2008 08:06:15 | listener.log file | DbMotive | Reply |
Are there any more message in the %ORACLE_HOME%/network/log/listener.log file?
If there is a problem, the message is accompanied with the underlying NT error in the listener.log file.
Can you please post the messages here? |
| : -> 15-MAY-2008 08:19:00 | Value of local_listener? | DbMotive | Reply |
What is your value of local_listener?
It seems that the automatic service registration is not taking place.
In sqlplus:
show parameter local_listener
If this is empty, set it to register itself to the listener:
alter system set local_listener='(address=(protocol=tcp)(host=localhost)(port=1521))';
Followed by
alter system register;
Now if you do a lsnrctl services again, you should be able to see the registered ORCL service and be able to connect to the database using @ORCL
|
I am on Linux OS. I am trying to connect two host machine. I want to duplicate database so want to make connection between them but I get this errors. I have attached tnsnames,listener, lsnrctl services. Kindly help me out.
SQL> connect sys/******@rxwrhs as sysdba;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Warning: You are no longer connected to ORACLE.
[oracle@bubba admin]$ tnsping rxwrhs
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:09:51
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RXWHRS)))
OK (0 msec)
[oracle@bubba admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS_1)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = bubba.rxcanada.ca)(PORT = 1523))
)
)
LISTENER_RXWRHS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = harley.rxcanada.ca)(PORT = 1521))
)
)
[oracle@bubba admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RXWRHS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RXWHRS)
)
)
RXWRHS_1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.199)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = RXWRHS_1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
[oracle@bubba admin]$ lsnrctl services
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:10:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bubba.rxcanada.ca)(PORT=1523)))
Services Summary...
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 "RXWRHS" has 1 instance(s).
Instance "RXWRHS", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "RXWRHS_1" has 1 instance(s).
Instance "RXWRHS_1", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
|
I am on Linux OS. I am trying to connect two host machine. I want to duplicate database so want to make connection between them but I get this errors. I have attached tnsnames,listener, lsnrctl services. Kindly help me out.
SQL> connect sys/******@rxwrhs as sysdba;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Warning: You are no longer connected to ORACLE.
[oracle@bubba admin]$ tnsping rxwrhs
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:09:51
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RXWHRS)))
OK (0 msec)
[oracle@bubba admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS_1)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = bubba.rxcanada.ca)(PORT = 1523))
)
)
LISTENER_RXWRHS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = harley.rxcanada.ca)(PORT = 1521))
)
)
[oracle@bubba admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RXWRHS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RXWHRS)
)
)
RXWRHS_1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.199)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = RXWRHS_1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
[oracle@bubba admin]$ lsnrctl services
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:10:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bubba.rxcanada.ca)(PORT=1523)))
Services Summary...
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 "RXWRHS" has 1 instance(s).
Instance "RXWRHS", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "RXWRHS_1" has 1 instance(s).
Instance "RXWRHS_1", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
|
I am on Linux OS. I am trying to connect two host machine. I want to duplicate database so want to make connection between them but I get this errors. I have attached tnsnames,listener, lsnrctl services. Kindly help me out.
SQL> connect sys/******@rxwrhs as sysdba;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Warning: You are no longer connected to ORACLE.
[oracle@bubba admin]$ tnsping rxwrhs
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:09:51
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RXWHRS)))
OK (0 msec)
[oracle@bubba admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS_1)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = bubba.rxcanada.ca)(PORT = 1523))
)
)
LISTENER_RXWRHS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = harley.rxcanada.ca)(PORT = 1521))
)
)
[oracle@bubba admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RXWRHS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RXWHRS)
)
)
RXWRHS_1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.199)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = RXWRHS_1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
[oracle@bubba admin]$ lsnrctl services
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:10:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bubba.rxcanada.ca)(PORT=1523)))
Services Summary...
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 "RXWRHS" has 1 instance(s).
Instance "RXWRHS", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "RXWRHS_1" has 1 instance(s).
Instance "RXWRHS_1", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
|
I am on Linux OS. I am trying to connect two host machine. I want to duplicate database so want to make connection between them but I get this errors. I have attached tnsnames,listener, lsnrctl services. Kindly help me out.
SQL> connect sys/******@rxwrhs as sysdba;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Warning: You are no longer connected to ORACLE.
[oracle@bubba admin]$ tnsping rxwrhs
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:09:51
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RXWHRS)))
OK (0 msec)
[oracle@bubba admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS)
)
(SID_DESC =
(GLOBAL_DBNAME = RXWRHS_1)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
(SID_NAME = RXWRHS_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = bubba.rxcanada.ca)(PORT = 1523))
)
)
LISTENER_RXWRHS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = harley.rxcanada.ca)(PORT = 1521))
)
)
[oracle@bubba admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RXWRHS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RXWHRS)
)
)
RXWRHS_1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.199)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = RXWRHS_1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
[oracle@bubba admin]$ lsnrctl services
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-JUN-2008 11:10:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bubba.rxcanada.ca)(PORT=1523)))
Services Summary...
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 "RXWRHS" has 1 instance(s).
Instance "RXWRHS", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "RXWRHS_1" has 1 instance(s).
Instance "RXWRHS_1", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
|
i m trying to connect to oracle 9i with developer 6i. when i connect then ora-12514 occure. please resolve this problem.
regards. |
| : -> 11-JUN-2008 10:49:32 | Change oracle home | DbMotive | Reply |
| You have to change your default oracle home, use Oracle locator express in order to do that |
HI,
PLZ SOLVE THE PROBLEM,PROBLEM IS THAT
ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor.SOON AS SOON SOLVE THE PROBLEM. |
| : -> 22-JUL-2008 10:04:24 | solve the problem of ORA-12514 | Adnan Anjum | Reply |
Assalam o Alikum all,
I have came up with a solution, there is a file "listener.ora" in network/admin/bin . Now add entry this file to register it with your db.
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
Replace your db and sid name in the above file and your service will start working insaAllah.
Regards
Adnan Anjum |
Add your message for ORA-12514
|
Home