on 08-17-2015 11:45 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.