Unable to proceed with Homogenous System Copy

[Former Member]

Dear Gurus,

We're performing a homogenous system copy for a dual stack SRM system.

We're encountering the following error in sapinst...

ERROR 2012-03-08 12:46:23.967

FCO-00011 The step RunControlScript with step key |NW_Doublestack_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|4|0|RunControlScript was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-01503: CREATE CONTROLFILE failed

ORA-00200: control file could not be created

ORA-00202: control file: '/oracle/SRT/origlogA/cntrl/cntlrSRT.dbf'

ORA-27038: created file already exists

Additional information: 1

ORA-01507: database not mounted

ORACLE instance shut down.

ORACLE instance started.

Total System Global Area 2399141888 bytes

Fixed Size 2098144 bytes

Variable Size 1207962656 bytes

Database Buffers 1174405120 bytes

Redo Buffers 14675968 bytes

ORA-00205: error in identifying control file, check alert log for more info

ALTER DATABASE ARCHIVELOG

*

ERROR at line 1:

ORA-01507: database not mounted

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-01507: database not mounted

ORA-01507: database not mounted

ORACLE instance shut down.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

.).

This occurs for all the control files in origlogA, origlogB and SapData1.

We're tried to remove the files and re-run, but sapisnt will just recreate them and prompt with similar error message.

Appreciate any feedback and advise for this issue.

Regards,

KS

[former_member204080]

Hi,

Please go through this

ORA-600 [KZSRSDN 1] with ORA-1503 create controlfile

[https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=205501]

Edited by: murali reddy on Mar 11, 2012 7:03 AM

[Former Member]

sapinst is launching sql statement to create control files and startup database. You will find it sapinst_instdir, name CONTROL.SQL. If you created control files in different way (for example recreating from trace - alter controlfile backup to trace) and you are able to open database. You need to adapt CONTROL.SQL file to guarantee to run on your database without error.

Best regards

Igor

[Former Member]

Hi Venkata,

I was able to proceed after I remove the files, but I hit another error.

ERROR 2012-03-09 12:51:36.744

FCO-00011 The step RunControlScript with step key |NW_Doublestack_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|4|0|RunControlScript was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

ORACLE instance started.

Total System Global Area 2399141888 bytes

Fixed Size 2098144 bytes

Variable Size 1207962656 bytes

Database Buffers 1174405120 bytes

Redo Buffers 14675968 bytes

Database mounted.

Database altered.

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

i tried to startup from sqlplus, use alter database open resetlogs; and continue, but it goes back to the issue with control.file previously.

Regards,

KS

[Former Member]

Hi,

Please let me know which procedure are you using for homogenous refresh. backup/restore or export import through sapinst.

Regards,

Venkata S Pagolu

[Former Member]

Please refer to the document which explains the DB recovery during system copy.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/aa29ee7d-0c01-0010-53ba-e680bd2e5...

[Former Member]

Hi,

Check this thread. This should resolve your issue.

[;

Regards,

Venkata S Pagolu

[Former Member]

Hi,

I can see logs where in sapinst is trying to alter database and says database is not mounted.

Can you please try checking if the oracle database and listener is started and then start the SAP.

Now try with system copy. Let the sapinst stop the SAP by itself.

Thanks

Jaianandh V

[Former Member]

Hi,

Check control file location in init<DB SID>.ora file in target system and clear all the control files in all the locations defined in the pfile/spfile.

then give a try and let me know the detailed error from alert<SID>.log if you still face issue.

Regards,

Venkata S Pagolu