Solved

Oracle 11g startup issue after Linux VM restore

Posted on 2014-11-11
15
364 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 73

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 73

Expert Comment

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

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 73

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 61

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
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: 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 73

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 73

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 73

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 73

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
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 Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now