on 05-04-2012 9:23 AM
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?
To be sure you check that you completed the upgrade successfully?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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
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
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.