Cannot connect to Oracle 10g database
Raj
following errors shows up in the SQL-Plus.
ORA-12514: TNS:listener does not currently know of service requested
in connect
descriptor
The same error comes even after a day, the database had been started.
Database start fine without any errors, when it is started from
Services. The emoms.log shows the following errors.
2008-04-22 17:28:20,234 [HttpRequestHandler-24044524] ERROR
conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
Pool. ERROR = Listener refused the connection with the following
error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))
2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
eml.OMSHandshake getParameterFromDB.563 - Listener refused the
connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))
2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =
http://support-db3.actuate.com:3938/emd/main)(ERROR = INTERNAL_ERROR)
2008-04-22 17:28:20,312 [HttpRequestHandler-20677779] ERROR
conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
Pool. ERROR = Listener refused the connection with the following
error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))
2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
eml.OMSHandshake getParameterFromDB.563 - Listener refused the
connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))
2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =
http://support-db3.actuate.com:3938/emd/main)(ERROR = INTERNAL_ERROR)
What could be the problem and how to fix it?
Any help you can provide is greatly appreciated.
Thank you.
Raj
sybrandb
> 2008-04-22 17:28:20,312 [HttpRequestHandler-20677779] ERROR
> conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
> Pool. ERROR = Listener refused the connection with the following
> error:
> ORA-12514, TNS:listener does not currently know of service requested
> in connect descriptor
> The Connection descriptor used by the client was:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
> db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))
>
> 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
> eml.OMSHandshake getParameterFromDB.563 - Listener refused the
> connection with the following error:
> ORA-12514, TNS:listener does not currently know of service requested
> in connect descriptor
> The Connection descriptor used by the client was:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
> db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))
>
> 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
>
> What could be the problem and how to fix it?
>
> Any help you can provide is greatly appreciated.
>
> Thank you.
> Raj
The obvious route would have been to
- look up this error in the online documentation
- work from there
- Search Google and/or this forum for this error
You will find thousands of posts by people, who like you, don't want
to do even the most elementary: Look up the error
You will find many valid solutions.
What you should not have done is
BE LAZY, AND POST THE ERROR FOR THE UMPTEENTH TIME
AGAIN!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
--
Sybrand Bakker
Senior Oracle DBA
Noons
> From SQL PLus, I cannot connect to our Oracle 10g database. The
> following errors shows up in the SQL-Plus.
>
> ORA-12514: TNS:listener does not currently know of service requested
> in connect
> descriptor
> What could be the problem and how to fix it?
>
> Any help you can provide is greatly appreciated.
>
The problem is that the description of the service
name in your tnsnames.ora entry does not match the
service names the listener knows about.
The most common case is when for example the
SERVICE_NAME entry is set to the SID in the server,
instead of the fully qualified domain name of the
database.
Try this:
Run the following query in the server logged on as
sys or system:
select * from global_name;
then pick the resulting string and set the SERVICE_NAME
parameter in the corresponding tnsnames.ora entry in the
client to that string. Then try the connect again.
joel garry
> From SQL PLus, I cannot connect to our Oracle 10g database. The
> following errors shows up in the SQL-Plus.
>
> ORA-12514: TNS:listener does not currently know of service requested
> in connect
> descriptor
>
>
> 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
> eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =http://support-db3.actuate.com:3938/emd/main)(ERROR= INTERNAL_ERROR)
>
> What could be the problem and how to fix it?
>
> Any help you can provide is greatly appreciated.
>
> Thank you.
> Raj
You might try running lsnrctl status to see what the listener is
expecting. It is likely going to be what Noons said.
It is also possible that you are not using a protocol already set up,
if you are on the same machine as the db. Is there an @ sign in your
connect string from sqlplus? Try removing that reference, instead of
sqlplus scott/tiger@orcl10g, try sqlplus scott/tiger.
For the agent, you perhaps have the wrong oracle home or something
like that. Have you reinstalled anything, patched, or otherwise made
more than one install? Are there errors in your alert log? Have you
found every tnsnames.ora file everywhere? Do you have more than one
oracle home? You may need to simply reconfigure the agent.
Also, remember to state your version, completely, like 10.2.0.4 or
whatever select * from v$version; says.
You should be able to go into a dos box on your server and say sqlplus
"/ as sysdba" to get to sqlplus.
jg
--
@home.com is bogus.
http://translate.google.com/translate?hl=en&sl=zh-CN&u=http://www.anysql.net/tag/Oracle&sa=X&oi=translate&resnum=9&ct=result&prev=/search%3Fq%3Dshareplex%2Boracle7%2Bmine%2Bredo%2Blogs%26hl%3Den%26sa%3DG
Mladen Gogala
> ORA-12514: TNS:listener does not currently know of service requested in
> connect
> descriptor
Stop requesting and ask nicely. Contrary to the claims of certain former
inhabitant of Chicago, IL, nice word can get you quite far, especially if
you know what are you asking for.
--
Mladen Gogala
http://mgogala.freehostia.com
Raj
> Rajwrote,on my timestamp of 23/04/2008 10:30 AM:
Hello Noon,
When I try to run this SQL, I got an error saying that database is
not open
SQL> connect sys/admin@orcl10g as sysdba
Connected.
SQL> select * from global_name;
select * from global_name
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views
only
I tried to open the database using the following alter database open.
It failed with the below message:
SQL> alter database open
2 /
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMEA\STAHOP_DATA01.DBF'
I ran the lsnrctl status and got the following output:
C:\Documents and Settings\Administrator>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 30-
APR-2008 11:21
:05
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version
10.2.0.3.0 - Produ
ction
Start Date 12-APR-2008 03:11:41
Uptime 18 days 8 hr. 9 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin
\listener.o
ra
Listener Log File C:\oracle\product\10.2.0\db_1\network\log
\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=support-db3)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
Service "orcl10g" has 1 instance(s).
Instance "orcl10g", status READY, has 1 handler(s) for this
service...
Service "orcl10g_XPT" has 1 instance(s).
Instance "orcl10g", status READY, has 1 handler(s) for this
service...
Service "orcl10ga" has 1 instance(s).
Instance "orcl10ga", status READY, has 1 handler(s) for this
service...
Service "orcl10gaXDB" has 1 instance(s).
Instance "orcl10ga", status READY, has 1 handler(s) for this
service...
Service "orcl10ga_XPT" has 1 instance(s).
Instance "orcl10ga", status READY, has 1 handler(s) for this
service...
The command completed successfully
Here orcl10ga works fine but the orcl10g fails to connect from SQL
Plus with the
ORA-12514: TNS:listener does not currently know of service requested
error.
Here is my tnsnames.ora file contents:
# tnsnames.ora Network Configuration File: C:\oracle\product
\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT
= 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl10g)
)
)
AMTRAKMA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AmtrakMaximo)
)
)
UNILOG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UNILOG)
)
)
ORCL10GA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl10ga)
)
)
EDGE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EDGE)
)
)
ORCL10GUC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT
= 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl10guc)
)
)
and listener.ora # listener.ora contents
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)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT
= 1521))
)
)
Thank you for any guidance you may provide.
Regards.
Raj
Raj
>
> - Show quoted text -
May be ignorant but not lazy. I tried by myself for two days but could
not get anywhere.
Regards.
Raj
joel garry
>
> SQL> alter database open
> 2 /
> alter database open
> *
> ERROR at line 1:
> ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
> ORA-01110: data file 7:
> 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMEA\STAHOP_DATA01.DBF'
Does this file exist? Is it being locked by a virus scanner or backup
program or editor or something?
> # Generated by Oracle configuration tools.
>
> ORCL10G =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = support-db3.actuate.com)(PORT
> = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = orcl10g)
> )
> )
>
Maybe a mismatch between your hostname and your fully qualified
hostname? Try briefly renaming your listener.ora to something else
(or comment out the parts that refer to this db) and reload your
listener and let your db register itself, see if the host is different
with lsnrctl status. That is, if you can get your db open. I'm not
sure whether you've ever had it open? What does your alert log say
about that? Do you have a listener.trc file? What is the last TNS-
error in your listener.log? Are there blocking errors?
jg
--
@home.com is bogus.
Let the stupidity begin! http://www.signonsandiego.com/news/metro/20080429-1514-bn29videogam.html
gazzag
>
Er... is there a DBA handy?
HTH
-g