Find in this Blog

Wednesday, April 22, 2015

\Program Files\sapinst_instdir\NW73\SBC\STANDARD\CONTROL.SQL (The system cannot find the file specified)

ERROR 2015-04-22 15:43:52.318
FCO-00141  The JVM reports an exception during execution of class ( com.sap.sdt.ins.component.ora_clone_obr.AdaptControlSqlFile ) and function executeStepClass. DIAGNOSIS: The reported error message from JVM is: java.io.FileNotFoundException: C:\Program Files\sapinst_instdir\NW73\SBC\STANDARD\CONTROL.SQL (The system cannot find the file specified)
 at java.io.FileInputStream.open(Native Method)

Solution:

May be the file got currpted or system cannot generate due to permission issue.

do the manual activities.:

open sql Console.

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Database altered.
SQL>
File location can be found in alert_SID

Copy control file details form that file and create control file and put in to

C:\Program Files\sapinst_instdir\NW73\SBC\STANDARD\

=========================================================

once its competed next error as follows:

Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 2004340736 bytes
Fixed Size      2256544 bytes
Variable Size   1006633312 bytes
Database Buffers   973078528 bytes
Redo Buffers     22372352 bytes
Database mounted.

Database altered.
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORACLE\GPQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'


ORA-01109: database not open

Solution:
Run below

SQL>recover database;
media recovery completed;
SQL>alter database open;


Some steps need to be skipped .
edit keydb.xml  seArch ERORR on CDATA



No comments:

Post a Comment

Ask Your Questions ?#