Solved

Oracle 11g startup issue after Linux VM restore

Posted on 2014-11-11
15
396 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
[X]
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
  • 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
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…

617 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