Integrating Oracle and Data Protector

 

Troubleshooting

 

General Troubleshooting

 

Data Protector reports “12:8422” error when using Data

 

Protector Oracle integration after an upgrade of Oracle 8i to

 

Oracle 9i
Problem

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.

 

Checking Prerequisites Related to the Oracle Side

 

of the Integration on UNIX Systems

 

For more detailed information about how to perform any of the following

 

procedures, see the Oracle documentation.

 

1. Verify that you can access the Oracle target database and that

 

it is opened as follows:

 

Export <ORACLE_HOME > and <DB_NAME> as follows:

 

• if you are using an sh - like shell, enter the following commands:

 

ORACLE_HOME="<ORACLE_HOME>"

 

export ORACLE_HOME

 

DB_NAME="<DB_NAME>"

 

export DB_NAME

 

• if you are using a csh - like shell, enter the following commands:

 

setenv ORACLE_HOME "<ORACLE_HOME>"

 

setenv DB_NAME "<DB_NAME>"

Chapter 1

117