ORA-01033: ORACLE initialization or shutdown in progress

[DieterLorenz]

Hello together,

I got this problem, if I schedule a dba job in db13. From the Commandline it works fine.

17.08.2015    11:26:20    BR0280I BRARCHIVE time stamp: 2015-08-17 11.26.21

17.08.2015    11:26:20    BR0301W SQL error -1033 at location BrDbConnect-2, SQL statement:

17.08.2015    11:26:20    'CONNECT /'

17.08.2015    11:26:20    ORA-01033: ORACLE initialization or shutdown in progress

17.08.2015    11:26:20    BR0310W Connect to database instance P11 failed

I think is is a problem with the ops$ User but I did not find a note special for the ORA-01033 error that gives a solution to the ops$ problem.

If I use sqlplus / as a sidadm I get the same error.

If I have a look at the ops$ user table:

select * from "OPS$XXXADM".SAPUSER;

get

USERID

--------------------------------------------------------------------------------

PASSWD

--------------------------------------------------------------------------------

SAPSR3-CRYPT

aösldfhlakjhasoö83ru9phasekjahlskdj

[DieterLorenz · Accepted solution]

The problem was the environment variable in the sidadm home drive. The .dbenv.sh and .dbenv.csh which contains the ORACLE_HOME was set to /oracle/P11/112_64/ and right is /oracle/P11/11264/. Check also the .dbenv_hostname.csh and .dbenv_hostname.sh.