Re: Cannot connect to Oracle 10g database

From: sybrandb <sybrandb_at_gmail.com>
Date: Wed, 23 Apr 2008 01:42:16 -0700 (PDT)
Message-ID: <6573bbb8-46ba-4ad7-a845-803e5a69d0d8@t63g2000hsf.googlegroups.com>

On Apr 23, 2:30 am, Raj <jkama..._at_gmail.com> wrote:
> 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
>
> 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

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

Received on Wed Apr 23 2008 - 03:42:16 CDT