mrong
asked on
Oracle 11g startup issue after Linux VM restore
Guest OS Oracle Linux 4/5/6(64-bit).
I restored the VM with a commercial backup/restore agent but unable to startup the database. Please see error message below.
SQL> select status from v$instance;
select status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/MySID/spfileMySID.o ra'
ORA-17503: ksfdopn: 2 Failed to open file +DATA/MySID/spfileMySID.or a
ORA-29701: unable to connect to cluster synchronization service
I restored the VM with a commercial backup/restore agent but unable to startup the database. Please see error message below.
SQL> select status from v$instance;
select status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/MySID/spfileMySID.o
ORA-17503: ksfdopn: 2 Failed to open file +DATA/MySID/spfileMySID.or
ORA-29701: unable to connect to cluster synchronization service
ASKER
The listener must be started before starting the database,right?
yes, but your errors aren't listener errors, they are cluster and asm errors
ASKER
tried lsnrctl status
got connecting to (ADDRESS=(PROTOCOL=tcp) (HOST=)(PORT=1521)
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
In the tnsnames.ora and listener.ora the HOST are set to the host name.
got connecting to (ADDRESS=(PROTOCOL=tcp) (HOST=)(PORT=1521)
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
In the tnsnames.ora and listener.ora the HOST are set to the host name.
lsnrctl start
but your previous errors point to other issues
but your previous errors point to other issues
ASKER
How to reset ASM?
You cannot reset anything. You need to restore Oracle from RMAN backup. Storage cloning/backups could only work with completely shut down oracle DB provided they properly include all oracle data and temporary files of same moment.
ASKER
There is no data imported in my database. Now my problem is to start ASM instance.
Maybe I need to rebuild the database?
Thanks.
Maybe I need to rebuild the database?
Thanks.
>>> ORA-29701: unable to connect to cluster synchronization service
Has this been addressed yet?
crsctl check cluster -all
Has this been addressed yet?
crsctl check cluster -all
ASKER
I tried the following
[oracle@db01 ~] $ crsctl check cluster
bash: crsctl: command not found
[oracle@db01 ~] $ crsctl check cluster
bash: crsctl: command not found
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
From linux->Application->System Tools->Disk Utility, I can see DATA1,DATA2, FRA1 are not mounted.
Can I mount it back?
Thanks.
Can I mount it back?
Thanks.
you tell us, can you?
my guess is no because your clusterware isn't running. Or if it is, we don't know because we don't have any status info on it.
my guess is no because your clusterware isn't running. Or if it is, we don't know because we don't have any status info on it.
ASKER
how to set my path to include the grid control home's bin directory?
I think you should bring your system admin and dba in to help you navigate through your system setup.
Is your clusterware started?