Problems – HP A.06.11 User Manual

Page 147

Advertising
background image

SQL>alter database open resetlogs;

Problems

Problem

Data Protector reports “12:8422” error when using Data Protector Oracle integration
after an upgrade of Oracle 8i to Oracle 9i

After Oracle 8i is upgraded to Oracle 9i, the following error is returned during the
configuration of Oracle instance or during the backup:

*RETVAL*8422

Action

Rename the Oracle 8i svrmgrl binary to something else so that Data Protector will
not find it. The Oracle upgrade process from Oracle 8i to Oracle 9i does not remove
the Oracle 8i svrmgrl binary, rather it changes its permissions. Once the svrmgrl
binary is renamed, Data Protector will use Oracle 9i sqlplus, as it should, to
complete the operations correctly.

Problem

Data Protector reports errors when calling SYS.LT_EXPORT_PKG.schema_inf_exp
during Oracle backup

The following errors are listed in the Data Protector monitor:

EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling
SYS.LT_EXPORT_PKG.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.
[Major] From: ob2rman.pl@machine "MAKI"

Time: 10/01/01 16:07:53

Export of the Recovery Catalog Database failed.

Action

Start SQL*Plus and grant the execute permission to the LT_EXPORT_PKG as follows
(make sure that the user sys has the SYSDBA privilege granted beforehand):

Integration guide for Oracle and SAP

147

Advertising