'CONNECT system/******** AT PROF_CONN IN SYSOPER MODE'

Hi All,

I'm facing this unique Problem.

I have just finished the Oracle upgrade from 9.2.0 to 10.2.0.2.

Now, when i perform archive log /online backup i get the following message:-

BR0006I Start of offline redo log processing: adyexabz.sve 2008-06-22 13.02.35
BR0280I BRARCHIVE time stamp: 2008-06-22 13.02.36
BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:
'CONNECT system/******** AT PROF_CONN IN SYSOPER MODE'
ORA-01031: insufficient privileges
BR0303E Determination of Oracle version failed

BR0007I End of offline redo log processing: adyexabz.sve 2008-06-22 13.02.36
BR0280I BRARCHIVE time stamp: 2008-06-22 13.02.36
=======================================================

Solution:

SQL> connect sys as sysdba

Enter password:

Connected.

 

SQL> grant sysoper to system;

 

Grant succeeded.