control.sql

[former_member429372]

Hi,

When I try to create control.sql & control.trc from the existing system. I get following error. Pls guide to sort this issue.

os.name = Windows 2003

os.arch = x86

os.version = 5.2

sun.cpu.endian = little

sun.arch.data.model = 32

sun.cpu.isalist = pentium i486 i386

file.encoding = Cp1252

file.separator = \

path.separator = ;

line.separator = CR/LF

user.name = gtpadm

user.home = C:\Documents and Settings\gtpadm

user.dir = P:\

user.language = en

user.country = US

java.version = 1.4.2_13

java.vendor = Sun Microsystems Inc.

java.vendor.url = http://java.sun.com/

java.vm.version = 1.4.2_13-b06

java.vm.vendor = Sun Microsystems Inc.

java.vm.name = Java HotSpot(TM) Client VM

java.vm.info = mixed mode

java.compiler =

java.class.version = 48.0

java.home = C:\Program Files (x86)\Java\j2re1.4.2_13

java.ext.dirs = C:\Program Files (x86)\Java\j2re1.4.2_13\lib\ext

java.class.path = .\.;.\orabrcopy.jar;E:\oracle\GTP\102\jdbc\lib\classes12.jar

java.library.path = C:\Program Files (x86)\Java\j2re1.4.2_13\bin;.;C:\WINDOWS\system32;C:\WINDOWS;E:\oracle\GTP\102\bin;C:\Perl\bin\;C:\Perl\bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;;E:\usr\sap\GTP\sys\exe\run;E:\oracle\GTP\102\bin;E:\usr\sap\GTP\SYS\exe\uc\NTAMD64;E:\usr\sap\GTP\SYS\exe\nuc\NTAMD64

java.io.tmpdir = C:\WINDOWS\TEMP\1\

Required system resources are missing or not available:

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

E:\oracle\GTP\102\BIN\ocijdbc10.dll: %1 is not a valid Win32 application.

Regards

SK

[stefan_koehler · Accepted solution]

Hello Dinesh,

which application is that?

You can create a trace of the control file very easily via SQL*Plus

shell> sqlplus / as sysdba
SQL> alter database backup controlfile to trace;

Regards

Stefan

[former_member429372 · Accepted solution]

Hi Stefan,

This is as per the installation procedure of homogenous system copy using backup/ restore method, Generating control file structure from source system. Pls revert

Regards

Dinesh

[former_member204746 · Accepted solution]

you do not need a JAVA application to do this. Are you using R3COPY?