Bolaji80 wrote:what is ORACLE_SID value?
I am working on a new server (VM) that was cloned from a physical hardware server. Environment is Linux 4.9 and oracle is 10.2. Here is the error I am getting:
When I set the ORACLE_SID and try to startup, I get this error.
Ora 03113 end of file communication
Instance will start, database will mount but will not open.
I used rman to connect (just to check the state) but it gives this error:
Ora 01033 oracle initialization in process
I can connect to sqlplus but I can't do anything from sqlplus. Any idea what to do?
I actually did this:
connect sys/**** as sysdba
ORACLE INSTANCE STARTED
alter databse mount;
alter database archivelog;
ora 00265 instance recovery required
Any idea what I need to do?
00265, 00000, "instance recovery required, cannot set ARCHIVELOG mode" // *Cause: The database either crashed or was shutdown with the ABORT // option. Media recovery cannot be enabled because the online // logs may not be sufficient to recover the current datafiles. // *Action: Open the database and then enter the SHUTDOWN command with the // NORMAL or IMMEDIATE option.
Thanks, but what can I do at this point?
Bolaji80 wrote:Hi folks,I wonder about the correctness & validity of the resultant 'clone'.
I am working on a new server (VM) that was cloned from a physical hardware server.