![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
SQL> startup ORACLE instance started. Total System Global Area 96468992 bytes Fixed Size 1278688 bytes Variable Size 88083744 bytes Database Buffers 4194304 bytes Redo Buffers 2912256 bytes ORA-00205: error in identifying control file, check alert log for more info SQL> SHOW PARAMETERS control_files NAME TYPE VALUE ----------- control_files string /opt/oracle/102/dbs/ora_contro l1, /opt/oracle/102/dbs/ora_co ntrol2 SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files' / 2 3 4 VALUE /opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2 SQL |
#3
| |||
| |||
|
|
"happy" <ehabaziz2... (AT) gmail (DOT) com> a écrit dans le message de news: d169f24c-ed69-4a52-85bb-e30016582... (AT) 32g2000vbe (DOT) googlegroups.com... | SQL> startup | ORACLE instance started. | | Total System Global Area 96468992 bytes | Fixed Size 1278688 bytes | Variable Size 88083744 bytes | Database Buffers 4194304 bytes | Redo Buffers 2912256 bytes | ORA-00205: error in identifying control file, check alert log for more | info | | SQL> SHOW PARAMETERS control_files | | NAME TYPE VALUE | ----------- control_files string /opt/oracle/102/dbs/ora_contro | l1, /opt/oracle/102/dbs/ora_co | ntrol2 | SQL> SELECT VALUE | FROM V$PARAMETER | WHERE NAME = 'control_files' | / | 2 3 4 | VALUE | /opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2 | | SQL "check alert log for more info" Regards Michel |
#4
| |||
| |||
|
|
Please explain more . |
#5
| |||
| |||
|
|
SQL> startup ORACLE instance started. Total System Global Area 96468992 bytes Fixed Size 1278688 bytes Variable Size 88083744 bytes Database Buffers 4194304 bytes Redo Buffers 2912256 bytes ORA-00205: error in identifying control file, check alert log for more info SQL> SHOW PARAMETERS control_files NAME TYPE VALUE ----------- control_files string /opt/oracle/102/dbs/ora_contro l1, /opt/oracle/102/dbs/ora_co ntrol2 SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files' / 2 3 4 VALUE /opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2 SQL |
#6
| |||
| |||
|
|
SQL> startup ORACLE instance started. Total System Global Area 96468992 bytes Fixed Size 1278688 bytes Variable Size 88083744 bytes Database Buffers 4194304 bytes Redo Buffers 2912256 bytes ORA-00205: error in identifying control file, check alert log for more info SQL> SHOW PARAMETERS control_files NAME TYPE VALUE ----------- control_files string /opt/oracle/102/dbs/ora_contro l1, /opt/oracle/102/dbs/ora_co ntrol2 SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files' / 2 3 4 VALUE /opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2 SQL |
#7
| |||
| |||
|
|
SQL> startup ORACLE instance started. Total System Global Area 96468992 bytes Fixed Size 1278688 bytes Variable Size 88083744 bytes Database Buffers 4194304 bytes Redo Buffers 2912256 bytes ORA-00205: error in identifying control file, check alert log for more info SQL> SHOW PARAMETERS control_files NAME TYPE VALUE ----------- control_files string /opt/oracle/102/dbs/ora_contro l1, /opt/oracle/102/dbs/ora_co ntrol2 SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files' / 2 3 4 VALUE /opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2 SQL |
![]() |
| Thread Tools | |
| Display Modes | |
| |