Ora_br_copy.sh execution Exception

[Former Member]

Hi,

I need to do a Homogeneous system copy.

so, I got  3 files  by ora_br_copy.sh normally.

system :  Unix 

Zip file : ORABRCOPY_3-20001410.SAR

But , I've attached below a strange logs.

svoerpprd:orasep 86> ./ora_br_copy.sh -generateFiles -targetSid SEQ -password lgcns2009 -localhost svoerpprd -listenerPort 1527
+ /usr/sap/SEP/SYS/exe/jvm/rs6000_64/sapjvm_4.1.027/sapjvm_4/bin/java -showversion -cp ./.:./orabrcopy.jar:/oracle/client/11x_64/instantclient/ojdbc14.jar com.sap.inst.lib.app.SecureStartup  com.sap.inst.orabrcopy.OraBRCopy -oracleHome /oracle/SEP/112_64 -sourceSid SEP -generateFiles -targetSid SEQ -password lgcns2009 -localhost svoerpprd -listenerPort 1527
java version "1.4.2_34"
Java(TM) 2 Runtime Environment, Standard Edition (build 4.1.027)
SAP Java Server VM (build 4.1.027 23.5-b02, Feb 27 2013 13:48:40 - 41_REL - optU - aix ppc64 - 6 - bas2:190505 (mixed mode))

java.io.IOException: A system call received a parameter that is not valid.
        at sun.nio.ch.FileChannelImpl.release0(Native Method)
        at sun.nio.ch.FileChannelImpl.implCloseChannel(FileChannelImpl.java:105)
        at java.nio.channels.spi.AbstractInterruptibleChannel.close(AbstractInterruptibleChannel.java:97)
        at java.io.FileOutputStream.close(FileOutputStream.java:308)
        at com.sap.inst.lib.app.CommandLineApp$1.run(CommandLineApp.java:263)

and   i also saw  "ora_br_copy.log" file

there is  a  starange log too.

svoerpprd:orasep 90> cat ora_br_copy.log
INFO: 2013-11-18 16:19:16
Oracle Backup/Restore Copy tool is started.

CONFIG: 2013-11-18 16:19:16
Application options:
generateFiles=
listenerPort=1527
localhost=svoerpprd
oracleHome=/oracle/SEP/112_64
password=*****
sourceSid=SEP
targetSid=SEQ

INFO: 2013-11-18 16:19:16
File '/imsi/20131118_SEQ/initSEQ.ora' is successfully generated from the source file '/oracle/SEP/112_64/dbs/initSEP.ora'.

INFO: 2013-11-18 16:19:16
Backup control file '/imsi/20131118_SEQ/CONTROL.TRC' is successfully generated.

INFO: 2013-11-18 16:19:17
Control file '/imsi/20131118_SEQ/CONTROL.SQL' is successfully generated.

INFO: 2013-11-18 16:19:17
Oracle Backup/Restore Copy tool is stopped.

I would like to know why the exception occurred .

Will anyone help me?

Thanks in Advance

[Former Member]

Hi Kim,

Try manually once..

To manually create controlfile, do this as ora<sid>:

sqlplus /nolog  connect / as sysdba;  alter database backup controlfile to trace  

Then in /oracle/<SID>/saptrace/usertrace find the latest file, there will be entry started with:

STARTUP NOMOUNT  CREATE CONTROLFILE REUSE DATABASE "IE3" NORESETLOGS  ARCHIVELOG  

and ended with:

CHARACTER SET UTF8  ;  

copy and paste those lines to another file e.g cntrl.sql

That is your controlfile-creation script.

BR,

Prabhakar

[Former Member]

The issue may alo with the script...check this work around with hostname...

Specify the hostname as in the listener.ora in the -localhost option:

./ora_br_copy.sh -generateFiles -targetSid SRT -password ****** -listenerPort 1564  -localhost xxxxxxx

BR,

Prabhakar