Neo-b wrote:Are you running sqlplus from a Windows system? If so, what version of sqlplus and what version of Windows.
I have oracle 10g and 11g installed on AIX 6.1.
Suddenly i am not able to connect to any oracle database facing the below error:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
on both oracle users Oralce 11g and Oracle 10g.
How can I investigate and fix this issue?
Edited by: Neo-b on Feb 4, 2013 4:33 PM
lsnrctl statusLSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 04-FEB-2013 16:30:24 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC3))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production Start Date 04-FEB-2013 15:26:29 Uptime 0 days 1 hr. 3 min. 55 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Parameter File /$ORACLE_HOME/network/admin/listener.ora Listener Log File /$ORACLE_HOME/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC3))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server15)(PORT=1523))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully