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)(PORT=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.
