Monday, September 19, 2016

BR0301E SQL error -1031 at location BrInitOraCreate-2

"BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT / AT PROF_CONN IN SYSOPER MODE'
ORA-01031:
insufficient privileges
BR0303E Determination of Oracle version failed
"


Solution:

1. Set the owner of brbackup and brarchive to ora<sid>:dba
2. Add user 'ora<sid>' to group oper in /etc/group file
3. Set the owner of init<sid>.sap file in $ORACLE_HOME/dbs folder to ora<sid>:dba

No comments:

Post a Comment