ORA-12514 error 2005-10-21 - By Arun Singh
Hi Trisha,
Your database is installed correctly but listener is not having any
entry for your database instance (orclg).
Check "/etc/profile.d/oracle.sh" for ORACLE_SID entry. or Try "export
ORACLE_SID=orclg" and stop/start Oracle listener i.e. "lsnrctl stop",
"lsnrctl start".
Make sure "lsnrct status" has an entry for your database instance
"orclg" i.e. "Service "orclg" has 1 instance(s). ..."
Hope this will help,
Arun
>>> On 10/21/2005 at 4:47 am, in message
<20051021114752.36018.qmail@(protected)>, Trusha
<dtrusha@(protected)> wrote:
> Hi,
> I have tried installing Oracle 10g R1 on SUSE Linux ES 9. But now
I am
> getting ORA 12514 Error while opening Enterprise Manager. Database
status
> show down. When I connect to sqlplus it says that database is up. The
error
> is
>
>
>
> SQLException
> Listener refused the connection with the following error: ORA-12514 (See ORA-12514.ora-code.com),
> 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=orclg.irma.ac.in)(POR
> T=1521)))(CONNECT_DATA=(SERVICE_NAME=orclg.irma.ac.in)))
>
>
>
> And status of lsnrctl is
>
>
>
> lsnrctl status
>
> LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 21-OCT-2005
17:05:30
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
> STATUS of the LISTENER
> -- ---- ---- ---- ------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 10.1.0.3.0 -
Production
> Start Date 21-OCT-2005 16:50:34
> Uptime 0 days 0 hr. 14 min. 55 sec
> Trace Level off
> Security ON: Local OS Authentication
> SNMP OFF
> Listener Parameter File
> /opt/oracle/product/10gR1/network/admin/listener.ora
> Listener Log File
/opt/oracle/product/10gR1/network/log/listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.11.21)(PORT=1521)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> The command completed successfully
>
> I have followed the docuement available on novell web site for
installation.
>
> Please help me solving this problem
>
> Regards
>
> Trusha
>
>
>
>
> -- ---- ---- ---- ---- ---- -----
> Yahoo! India Matrimony: Find your partner now
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
