Wednesday, August 10, 2016

Connecting to SQLPLUS/ASMCMD...SP2-1503: Unable to initialize Oracle call interface/UNKNOWN OCI STATUS 1804 OCIInitialize


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

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


ASMCMD...

No comments:

Post a Comment