control file creation error

[Former Member]

Hi,

when I am running the following command in system copy

ora_br_copy.bat -targetSid Q22 -password ****** -listenerport 1527

it is giving the below error

D:\sapora file 64 bit>"C:\Program Files (x86)\Java\j2re1.4.2_06\bin\java.exe" -showversion -cp ".;orabrcopy.jar;D:\oracle\prd\920\64\jdbc\lib\classes12.jar" com.sap.inst.orabrcopy.OraBRCopy -oracleHome "D:\oracle\prd\920\64" -sourceSid "PRD" -targetSid Q22 -password PRODUCTIONsystem@32 -listenerport 1527

java version "1.4.2_06"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_06-b03)

Java HotSpot(TM) Client VM (build 1.4.2_06-b03, mixed mode)

Required system resources are missing or not available:

Cannot establish connection to Oracle database as SYSTEM user:

java.lang.UnsatisfiedLinkError: D:\oracle\prd\920\64\bin\ocijdbc9.dll: %1 is not a valid Win32 application.

D:\sapora file 64 bit>

I am using ECC5 on windows IA64 bit with Oracle 9.2.0.6 .

the orabrcopy.sar was also from 64 bit installer .

I am running the command through sidadm user.

Pl. suggest.

[Former Member]

Hi,

I am not sure what that batch file dose. But for this specific proplem it seems your listen is not started.

But if you only motive to generate control file from a trace file, then there is specific procudure which can done.

Beklow is the overview

This is done by downloading the trace file from source system. then edit it as mentioned in document. Rename it as xyz.srl.

Then log in SQL of the target datbase and run it in.

Edited by: Hussain Sehorewala on Aug 30, 2010 6:35 PM

[Former Member]

Hi,

Try this

ora_br_copy.bat -generateFiles -targetSid Q22 -password ****** -listenerPort 1527

Regards

KVR

[Former Member]

Well i never used ora_br_copy, but as a workaround you could create the control file manually with alter database backup controlfile and adapt it yourself.

I recommend reading the official documentation: [CREATE CONTROLFILE|http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5003.htm]

This thread can give you an impression on how to create the controlfile: [how to change sid of QAS server |;

Cheers Michael