unable to crate new control file

[Former Member]

Dear All,

I am going to refresh SANDBOX i want to create new control file but am am not able to create controlfile following is the mssage:

SP2-0310: unable to open file "control.sql"

Pls. guide me,

Regards,

Madhus

[Former Member · Accepted solution]

Hi ,

What command did you use to create control file? I beliwve you are using Oracle as database so please try below command in PRD ::

Alter database create controlfile to trace;

This will create a control file under saptrace which you can copy to your target system.

Thanks..

Mohit

Edited by: mohit gupta on May 5, 2011 8:33 AM

[Former Member]

Hi Madhu,

Please go through the below sapnote and also make sure to use the correct command to create the controlfile as it was mentioned in earlier reponse...

Note 539921 - Current patch set for Oracle 9.2.0

Note 1060305 - Corrections in BR*Tools Version 7.10

Note: You can try to call sqlplus from the location where you have created your contrilfile and try to open it...

Edited by: prateek_y on May 5, 2011 2:05 PM

[former_member59574]

Hi,

Make sure that user ora<sid> is authorizate to read that file, so provide authorzation.

Command you run should looks like this one

./ora_br_copy.sh -generateFiles -forceLogSwitches -targetSid TRG -password secretb -listenerPort 1527

this is only example you should change TRG, secretb and port for listener.

Best regards,

Peter Nechala