Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Satish Ahirkar on Jul 29 at 1:16 AM Thanks Ricardo and Gerado,
I rename the file "lck" because the file status was locked and corrupt so i
create a new folder "lck".
After rename run the command "STARTUP MOUNT' but getting same error.
SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 7867006976 bytes
Fixed Size 2270552 bytes
Variable Size 3976202920 bytes
Database Buffers 3875536896 bytes
Redo Buffers 12996608 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted.
Now the Alert log file error is.....
"Wed Jul 29 07:55:57 2015
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'H:\ORACLE\ECP\SAPDATA1\CNTRL\CNTRLECP.DBF'
ORA-27048: skgfifi: file header information is invalid
OSD-04001: invalid logical block size
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'K:\ORACLE\ECP\ORIGLOGB\CNTRL\CNTRLECP.DBF'
ORA-27048: skgfifi: file header information is invalid
OSD-04001: invalid logical block size
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'K:\ORACLE\ECP\ORIGLOGA\CNTRL\CNTRLECP.DBF'
ORA-27048: skgfifi: file header information is invalid
OSD-04001: invalid logical block size
Wed Jul 29 07:55:57 2015
Sweep [inc][91580]: completed
Sweep [inc][91579]: completed
Sweep [inc][91578]: completed
Sweep [inc][91577]: completed
Sweep [inc][91576]: completed
Sweep [inc][91575]: completed
Sweep [inc2][91580]: completed
Sweep [inc2][91579]: completed
Sweep [inc2][91578]: completed
Sweep [inc2][91577]: completed
Sweep [inc2][91576]: completed
Sweep [inc2][91575]: completed
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thanks & Regards,
Satish
| | | ---------------Original Message---------------
From: Gerardo Navarrete
Sent: Tuesday, July 28, 2015 11:25 AM
Subject: ORA-01507: Database Not Mounted Sapmmc Not Starting
Hi Satish.
Try with:
sqlplus "/ as sysdba"
The messaje will be: "connected to an idle instance".
If not, run the command in this secuency
1.- STARTUP MOUNT;
2.- ALTER DATABASE OPEN;
With this generate the control file, now shutdown the data base and start again.
1.- SHUTDOWN IMMEDIATE or SHUTDOWN FORCE
Regards. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
