Skip to Content
0
Former Member
May 04, 2012 at 08:23 AM

Can not execute catsbp.sql - SBP Post installation

915 Views

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?