Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle 11g startup issue after Linux VM restore

Posted on 2014-11-11
15
380 Views
Last Modified: 2014-11-15
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.ora'
ORA-17503: ksfdopn: 2 Failed to open file +DATA/MySID/spfileMySID.ora
ORA-29701: unable to connect to cluster synchronization service
0
Comment
Question by:mrong
  • 7
  • 7
15 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 40434850
Is your ASM instance started?
Is your clusterware started?
0
 

Author Comment

by:mrong
ID: 40434859
The listener must be started before starting the database,right?
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40434892
yes, but your errors aren't listener errors, they are cluster and asm errors
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:mrong
ID: 40435498
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.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40435629
lsnrctl start

but your previous errors point to other issues
0
 

Author Comment

by:mrong
ID: 40436042
How to reset ASM?
0
 
LVL 62

Expert Comment

by:gheist
ID: 40436713
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.
0
 

Author Comment

by:mrong
ID: 40437145
There is no data imported in my database. Now my problem is to start ASM instance.
Maybe I need to rebuild the database?

Thanks.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40437330
>>> ORA-29701: unable to connect to cluster synchronization service

Has this been addressed yet?

crsctl check cluster -all
0
 

Author Comment

by:mrong
ID: 40437371
I tried the following
[oracle@db01 ~] $ crsctl check cluster
bash: crsctl: command not found
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 40437380
set your path to include your grid control home's bin directory

if your cluster ware was installed with role separated management you will need to login or su to the grid owner

also, include the "-all"
0
 

Author Comment

by:mrong
ID: 40440223
From linux->Application->System Tools->Disk Utility, I can see DATA1,DATA2, FRA1 are not mounted.
Can I mount it back?
Thanks.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40440254
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.
0
 

Author Comment

by:mrong
ID: 40440282
how to set my path to include the grid control home's bin directory?
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40440379
I think you should bring your system admin and dba in to help you navigate through your system setup.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question