This error indicate improper set of environment variables. here is a scenario. there are other out there...
ERPDB1:/ERP1/11.1.0/ASM_1$ export ORACLE_HOME=/ERP1/11.1.0/ASM_1
ERPDB1:/ERP1/11.1.0/ASM_1$ export PATH=/ERP1/11.1.0/ASM_1/bin:$PATH
ERPDB1:/ERP1/11.1.0/ASM_1$ export ORACLE_SID=+ASM
ERPDB1:/ERP1/11.1.0/ASM_1$ sqlplus / as sysasm
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
ERPDB1:/ERP1/11.1.0/ASM_1$
Confirmed instance is up, below
ERPDB1:/ERP1/11.1.0/ASM_1$ps -ef|grep pmon
oracle 7012424 1 0 Jun 26 - 13:06 ora_pmon_PROD
oracle 8585440 1 0 Jun 26 - 8:30 asm_pmon_+ASM
Unset ORA_TZFILE that normally come with ERP DB environment variable settings.
ERPDB1:/ERP1/PRODDB/db/tech_st/11.1.0/network/admin$ echo $ORA_TZFILE
/ERP1/PRODDB/db/tech_st/11.1.0/oracore/zoneinfo/timezlrg.dat
ERPDB1:/ERP1/PRODDB/db/tech_st/11.1.0/network/admin$ unset ORA_TZFILE
ERPDB1:/ERP1/PRODDB/db/tech_st/11.1.0/network/admin$ echo $ORA_TZFILE
Hurry!
ERPDB1:/ERP1/PRODDB/db/tech_st/11.1.0/network/admin$ sqlplus / as sysasm
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Oct 21 14:05:14 2015
No comments:
Post a Comment