Re: Cannot connect to Oracle 10g database

On Apr 23, 1:42 am, sybrandb <sybra..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

May be ignorant but not lazy. I tried by myself for two days but could not get anywhere.

Regards.
Raj Received on Wed Apr 30 2008 - 13:49:51 CDT