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

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 
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 


ERPDB1:/ERP1/PRODDB/db/tech_st/11.1.0/network/admin$ sqlplus / as sysasm

SQL*Plus: Release - Production on Wed Oct 21 14:05:14 2015

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


No comments:

Post a Comment