SPARC SuperCluster T4-4 Half Rack
 

PLA-Support>Eng Systems>Exadata/ODA/SSC>SPARC SuperCluster>DB: SuperCluster_EST
 

In this Document

Symptoms

Cause

Solution

Created from <SR 3-6849232128>

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Symptoms

We applied a SPARC SuperCluster bundle patch over the weekend.

During catalog apply on to the database, I got following error in spool file catbundle_DBname-timestamp.log



SQL> exec dbms_registry.set_session_namespace('SERVER')

PL/SQL procedure successfully completed.

SQL> PROMPT Processing Oracle Database Packages and Types...
Processing Oracle Database Packages and Types...
SQL> ALTER SESSION SET current_schema = sys;

Session altered.

SQL> @@rdbms/admin/catnomtt.sql
SP2-0310: unable to open file "rdbms/admin/catnomtt.sql"
SQL> @@rdbms/admin/catnomta.sql
SP2-0310: unable to open file "rdbms/admin/catnomta.sql"

At about that same time, the error “Critical fault: An access violation detected in” the RDBMS alert log was logged in the RDBMS instance alert.log.

Cause

The upgrade script did not have the correct path for the RDBMS home.
 

ORACLE_HOME was set correctly when running the script.
However, Customer was in the wrong directory (pwd = $ORACLE_HOME/rdbms/admin ) when applying the catalog sql.
 

Solution

According to the patch README:

  1. Navigate to the $ORACLE_HOME directory.

  % cd $ORACLE_HOME

  2. Connect to the database as sysdba:

  % sqlplus /nolog

  SQL> connect / as sysdba

  3. Reload the packages into the database, run the following command (make sure you have run step 1 which is mandatory for this step run):

  SQL> @rdbms/admin/catbundle.sql exa apply
 

This solution has no attachment