Oracle 11.2 vs ORA_BR_COPY

[Former Member]

Hi!

After upgrading your Oracle database to 11.2 the ora_br_copy.sh doesn't work any more. Did any of you get it fixed or working?

I'm running ORACLE 11.2.0.2 + HP-UX 11.31.

cheers

[former_member263135]

I encountered a similar issue using BRCOPY (3-20001410) for a System Copy with Oracle database version 11.2

Cannot establish connection to Oracle database as user SYSTEM using URL 'jdbc:oracle:oci8:@': no ocijdbc10 in java.library.path.

And finally, I had a look on %ORACLE_HOME%\BIN and I saw that ocijdbc11.dll was present but not ocijdbc10.dll.

Then, after copying ocijdbc10.dll in the folder %ORACLE_HOME%\BIN, BRCOPY works normally.

[markus_doehr2]

> After upgrading your Oracle database to 11.2 the ora_br_copy.sh doesn't work any more. Did any of you get it fixed or working?

Is there an error message? What exactly "is not working"?

Markus

[Former Member]

Markus,

The problem is that ORABRCOPY is not prepared to run with ORACLE 11g, as fas as I could check.

Currently we have the following scripts:

Hello,

Sorry for answering so late. The problem is that ORABRCOPY is not prepared to work with ORACLE 11g, at least in HP-UX. With oracle 11g java classes availability changes.

Below you can see the scripts we use to generate the control file with ORACLE 10g and the adapted for ORACLE 11g.

Apparently classes12.jar doesn't exist in ORACLE 11g, but if you try to get it in ORACLE it's useless.

Here's the scripts I0m using in ORACLE 10g (and this was working fine) and the adapted for ORACLE 11g (the first version...).

*****ORACLE 10g

create_control.csh

#!/bin/csh

setenv LD_LIBRARY_PATH /oracle/XXX/102_64/lib32

setenv JAVA_HOME /opt/java1.5

cd /usr/local/sap/systemcopy/XXX-source

./ora_br_copy.sh -generateFiles -targetSid XXX -password xxxxxx

cp CONTROL.SQL /oracle/XXX/sapreorg

******ORACLE 11G

create_control.csh.new11

#!/bin/csh

setenv LD_LIBRARY_PATH /oracle/XXX/112_64/lib

setenv JAVA_HOME /opt/java1.5

cd /usr/local/sap/systemcopy/XXXX-source

./ora_br_copy.sh -generateFiles -targetSid XXX -password xxxxxxx

cp CONTROL.SQL /oracle/XXX/sapreorg

or

pg create_control.csh.new11

#!/bin/csh

setenv LD_LIBRARY_PATH /oracle/XX/112_64/lib:/oracle/client/92x_64/lib

setenv JAVA_HOME /opt/java1.5

cd /usr/local/sap/systemcopy/XXX-source

./ora_br_copy.sh -generateFiles -targetSid XXXX-password xxxxx

cp CONTROL.SQL /oracle/XXX/sapreorg

In ORACBRCOPY.console.log we get the following error messages:

Required system resources are missing or not available:

Error loading Oracle JDBC driver.

or

Required system resources are missing or not available:

Cannot establish connection to Oracle database as user SYSTEM using URL 'jdbc:oracle:oci8:@':

no ocijdbc9 in java.library.path.

Cheers,

[Former Member]

/oracle/SID/112_64/jdbc/lib

under this directory do you see the files

classes12.jar classes12.zip classes12dms.jar nls_charset12.jar ojdbc14.jar ojdbc14_g.jar ojdbc14dms.jar ojdbc14dms_g.jar

Also in exe directory, you need to have ojdbc.jar files and you'd able to work with ora_br-copy.

Thanks

SM

[Former Member]

HI,

Pleae check if there are any env variables defined in the script with the old DB version.

Thanks,

Deepthi