cancel
Showing results for 
Search instead for 
Did you mean: 

Can not execute catsbp.sql - SBP Post installation

former_member199849
Participant
0 Kudos

I am applying SBP SAP_112025_201204 to Oracle 11.2.0.2, this is the first time that I am applying SBP to my Oracle, I have followed all the instructions of the README.html but for posinstallation I got this error

Instructions.

Connect to the database as SYSDBA using SQL*Plus and run the catsbp.sql script as follows:

cd $ORACLE_HOME/rdbms/admin 
sqlplus / as sysdba
SQL> @?/sapbundle/SAP_112025_201204/catsbp.sql SQL> quit 

Error:

orasid> cd $ORACLE_HOME/rdbms/admin
orasid> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri May 4 03:23:44 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @$ORACLE_HOME/sapbundle/SAP_112025_201204/catsbp.sql
  dbms_system.get_env( 'ORACLE_BASE', oracle_base );
  *
ERROR at line 13:
ORA-06550: line 13, column 3:
PLS-00201: identifier 'DBMS_SYSTEM.GET_ENV' must be declared
ORA-06550: line 13, column 3:
PL/SQL: Statement ignored
ORA-06550: line 14, column 3:
PLS-00201: identifier 'DBMS_SYSTEM.GET_ENV' must be declared
ORA-06550: line 14, column 3:
PL/SQL: Statement ignored
ORA-06550: line 16, column 5:
PLS-00201: identifier 'RAISE_APPLICATION_ERROR' must be declared
ORA-06550: line 16, column 5:
PL/SQL: Statement ignored
ORA-06550: line 19, column 5:
PLS-00201: identifier 'RAISE_APPLICATION_ERROR' must be declared
ORA-06550: line 19, column 5:
PL/SQL: Statement ignored


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Do you have any idea?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

To be sure you check that you completed the upgrade successfully?

former_member199849
Participant
0 Kudos

Yes, My SBP installation finished succesfully, orkun do you have skyp account o gmail account?

Also I have a doub becuase in the SBP guide says:

3.5 Executing Post-Installation Instructions

If you have more than one database instance associated with the Oracle Home that you are updating, you must execute the post-installation instructions below for each database instance. However, this does not hold for the multiple instances of a RAC system: Execute the post-installation instructions on one instance of the RAC system only.

Connect to the database as SYSDBA using SQL*Plus and run the catsbp.sql script as follows:

$ cd $ORACLE_HOME/rdbms/admin  $ sqlplus / as sysdba  SQL> @?/sapbundle/SAP_112025_201204/catsbp.sql  SQL> quit  

The script evaluates the log files generated by all intermediate steps for unkown errors. If it detects such errors, refer to the log files for more information, resolve the errors and, depending on the error cause, re-start the script.

The script may furthermore perform some checks on whether additional post-installation actions are required depending on the state of the database.

I guess that the lines in bold in my case it doesn' apply, because my system only have one database instance. I am consufed If I have to execute post installation scripts

Former Member
0 Kudos

Hi Andy,

>> If you have more than one database instance associated with the Oracle Home that you are updating, you must execute the post-installation instructions below for each database instance.

It means that you need to execute the script for each instance. For example you have 2 different database on the same host. So you should execute this script on two databases, separately. If you have one instance, you should execute the script on the one database instance, also.

Best regards,

Orkun Gedik

former_member199849
Participant
0 Kudos

Hi

This thread is related to http://scn.sap.com/thread/3170232
The cause of why I couldn't execute this scrip if because control file was no created (There was no database created), so I ignore this script, an restart my sap installation and works.

alert log:
Fri May 04 11:57:16 2012
MMON started with pid=15, OS id=26131
ORACLE_BASE from environment = /oracle
Fri May 04 11:57:16 2012
MMNL started with pid=16, OS id=26133
Fri May 04 11:57:16 2012
ALTER DATABASE   MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/SID/sapdata1/cntrl/cntrlPTP.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/SID/origlogB/cntrl/cntrlPTP.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/SID/origlogA/cntrl/cntrlPTP.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE   MOUNT...

Somelese told me that catsbp.sql compiles all objects from database, but in my case my database was not yet created,

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Andy,

Check the note 1431793 - Oracle 11.2.0: Upgrade Scripts and try to execute the statement, below;

./dbua.sap.sh -catsbp yes

Best regards,

Orkun Gedik