Upgrade of database (10.2.0.5 to 11.2.0.3) terminating with error ora 3113 - end of communication channel

[Former Member]

hi,

My enviroment is ERP 6.0 Ehp0/Oracle 10.2.0.5/AIX 6.1. I'm upgrading the database to 11.2.0.3. using dbua. The steps below are to  be peformed

1. Performing Pre Upgrade
2. Upgrading of Oracle Server
3. Performing post Upgrade
4. Running Custom Scripts
5. Upgrading Time zone

At the end of step 2. the database is shutdown with error "03113 -end of communication channel" hence the remainder of the steps (3 to 5) have not been executed via the GUI (see attached log & screen shots  for clarifications)

Kindly advice on how to completed completed the remainder of the steps for  a succesful database upgrade

dbua.txt.zip

[Reagan · Accepted solution]

Hello

Problem with missing APAR's on AIX

Check this SAP note : 1678268  - ORA-03113 on shutdown

Also make sure you have the APAR's mentioned here are installed.

Authorized Problem Analysis Reports (APARs) for AIX 6L:

If you are using the minimum operating system TL level for AIX 6L listed above, then install all AIX 6L 6.1 Authorized Problem Analysis Reports (APARs) for AIX 6.1 TL 02 SP1, and the following AIX fixes:

• IZ41855
• IZ51456
• IZ52319
• IZ97457
• IZ89165

Regards

RB

[Former Member · Accepted solution]

Hi,

I restored backup before upgrade and started the upgrade process afresh. It went on well without a hitch.

Thanks all

[Former Member]

hi,

after installation you changed env variable for oracle or not...? just follow below step & after that again start upgrade process

Change your .dbenv_<hostname>.csh or .dbenv_<hostname>.sh in the home

directory of <sid>adm user as follows:

Changes for csh:

================

    1. Search in .dbenv*csh for the following lines:

    if ( $USER != $ORASID ) then

      set _f=/sapmnt/<SID>/profile/DEFAULT.PFL

      set _t=/oracle/<DBSID>/112_<BIT>/bin/sqlplus

    2. Insert the following new line:

      set _o=/oracle/<DBSID>112_<BIT>/oracore

    3. Go to the following line:

    setenv TNS_ADMIN /oracle/<DBSID>/112_<BIT>/network/admin

    4. Remove the next line:

    setenv ORACLE_HOME `echo $ORA_NLS33 | awk -F_ '{printf("%s_",$1)}

    5. Insert the following new lines:

    if ( -r "$_o" ) then

    setenv ORACLE_HOME /oracle/<DBSID>/112_<BIT>

    else

    setenv ORACLE_HOME `echo $ORA_NLS33 | awk -F_ '{printf("%s_",$1)}

    fi

    endif

Changes for sh:

===============

    1. Search in .dbenv*.sh for the following lines:

    if [ $USER != $ORASID ]; then

      _f=/sapmnt/<SID>/profile/DEFAULT.PFL

      _t=/oracle/<DBSID>/112_<BIT>/bin/sqlplus

    2. Insert the following new line

      _o=/oracle/<DBSID>/112_<BIT>/oracore

    3. Go to the following line:

        TNS_ADMIN=@ORACLE_HOME@/network/admin

    4. Remove the next line

        ORACLE_HOME=`echo $ORA_NLS33 | awk -F_ '{printf("%s_",$1)} {printf("%2.2s",$2)}'`

    5. Insert the following new lines

        if [ -r "$_o" ]; then

          ORACLE_HOME=/oracle/< DBSID>/112_<BIT>

        else

          ORACLE_HOME=`echo $ORA_NLS33 | awk -F_ '{printf("%s_",$1)}

    {printf("%2.2s",$2)}'`

        fi

[Former Member]

I  think you not set ORACLE_HOME_TGT at run time please set try it.

[Former Member]

Hi,

Please check the below note if your OS is affected.

1678268  - ORA-03113 on shutdown

Please post the alert log as asked earlier. If issues in alert log.Please check this.

1888448  - ORA-16038 during startup

Thanks

Rishi Abrol

[Former Member]

Check alert.log file for any errors. And check space on filesystem level.