BR0301E SQL error -1033

    Hi All,

    I am installing EHP6 on windows server(64bit) and oracle 11 but i am facing following error in create database statistics phase please suggest me.

    SAPINST log:

    Output of C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2 is written to the logfile brconnect.log.

    WARNING 2013-11-03 20:07:44.094

    Execution of the command “C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2” finished with return code 3. Output:

    BR0801I BRCONNECT 7.20 (17)

    BR0805I Start of BRCONNECT processing: cemlmsad.sta 2013-11-03 20.07.15

    BR0484I BRCONNECT log file: C:\oracle\DEV\sapcheck\cemlmsad.sta

    BR0280I BRCONNECT time stamp: 2013-11-03 20.07.43

    BR0301E SQL error -1033 at location db_connect-2, SQL statement:

    ‘CONNECT /’

    ORA-01033: ORACLE initialization or shutdown in progress

    BR0310E Connect to database instance DEV failed

    BR0280I BRCONNECT time stamp: 2013-11-03 20.07.43

    BR0301E SQL error -1033 at location db_connect-2, SQL statement:

    ‘CONNECT /’

    ORA-01033: ORACLE initialization or shutdown in progress

    BR0310E Connect to database instance DEV failed

    BR0806I End of BRCONNECT processing: cemlmsad.sta 2013-11-03 20.07.43

    BR0280I BRCONNECT time stamp: 2013-11-03 20.07.43

    BR0804I BRCONNECT terminated with errors

    ERROR 2013-11-03 20:07:44.219

    CJS-30023  Process call ‘C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2’ exits with error code 3. For details see log file(s) brconnect.log.

    ERROR 2013-11-03 20:07:47.250

    FCO-00011  The step createOracleStatisticsABAP with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_ORA|ind|ind|ind|ind|0|0|NW_ORA_Statistics_Create|ind|ind|ind|ind|0|0|createOracleStatisticsABAP was executed with status ERROR ( Last error reported by the step: Process call ‘C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2’ exits with error code 3. For details see log file(s) brconnect.log.).

    BRCONNECT log:

    BR0801I BRCONNECT 7.20 (17)

    BR0805I Start of BRCONNECT processing: cemlmsad.sta 2013-11-03 20.07.15

    BR0484I BRCONNECT log file: C:\oracle\DEV\sapcheck\cemlmsad.sta

    BR0280I BRCONNECT time stamp: 2013-11-03 20.07.43

    BR0301E SQL error -1033 at location db_connect-2, SQL statement:

    ‘CONNECT /’

    ORA-01033: ORACLE initialization or shutdown in progress

    BR0310E Connect to database instance DEV failed

    BR0280I BRCONNECT time stamp: 2013-11-03 20.07.43

    BR0301E SQL error -1033 at location db_connect-2, SQL statement:

    ‘CONNECT /’

    ORA-01033: ORACLE initialization or shutdown in progress

    BR0310E Connect to database instance DEV failed

    BR0806I End of BRCONNECT processing: cemlmsad.sta 2013-11-03 20.07.43

    BR0280I BRCONNECT time stamp: 2013-11-03 20.07.43

    BR0804I BRCONNECT terminated with errors

    When i am trying to start database i am facing below error.

    SQL> startup

    ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

    ORACLE instance started.

    Total System Global Area  208805888 bytes

    Fixed Size                  2253696 bytes

    Variable Size             117443712 bytes

    Database Buffers           83886080 bytes

    Redo Buffers                5222400 bytes

    Database mounted.

    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

    SQL> alter database open RESETLOGS

      2  ;

    alter database open RESETLOGS

    *

    ERROR at line 1:

    ORA-01245: offline file 1 will be lost if RESETLOGS is done

    ORA-01110: data file 1: ‘C:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1’

    regards

    ksreddy

    Hi All,I am installing EHP6 on windows server(64bit) and oracle 11 but i am facing following error in create database statistics phase please suggest me.SAPINST log:Output of C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2 is written to the logfile brconnect.log.WARNING 2013-11-03 20:07:44.094Execution of the command "C:\usr\sap\DEV\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2" finished with return code 3. Output: BR0801I BRCONNECT 7.20 (17)BR0805I Start of BRCONNECT processing: cemlmsad.sta 2013-11-03 20.07.15BR0484I BRCONNECT log file: C:\oracle\DEV\sapcheck\cemlmsad.staBR0280I BRCONNECT time stamp: 2013-11-03 20.07.43BR0301E SQL error -1033 at location db_connect-2, SQL statement:'CONNECT…

    BR0301E SQL error -1033

    Very Helpfull

    User Rating: Be the first one !
    Supporter Asked on November 2, 2016 in enhancement packages.
    Add Comment
    1 Answer(s)

      Hello

      First : Collecting the statistics using brconnect can be done only when the database is up and running.

      Second: Your database is in mount status. It looks like you have restored an online back of a database. If yes have you recovered the database ?

      if not then  you will have to do that.

      or recovery you will need to apply the offline redo logs.

      You need to recover the database as follows.

      recover database using backup controlfile until cancel;

      You need to specify the offline redologs with the location.

      Once the recovery has been completed you may open the database with the resetlogs option.

       

      Regards

      RB

      Add Comment

        Hello

        First : Collecting the statistics using brconnect can be done only when the database is up and running.

        Second: Your database is in mount status. It looks like you have restored an online back of a database. If yes have you recovered the database ?

        if not then  you will have to do that.

        or recovery you will need to apply the offline redo logs.

        You need to recover the database as follows.

        recover database using backup controlfile until cancel;

        You need to specify the offline redologs with the location.

        Once the recovery has been completed you may open the database with the resetlogs option.

         

        Regards

        RB

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.