monarch_ilhan
asked on
I can not start RAC instances of Oracle RAC database
Hi Experts,
I have a big problem. Recently we have taken a responsibility of a new system which db is oracle 10g and RAC is configured (Windows 2003 Servers). But when I execute i see that nodes status are not running. But instances are up and i can connect them within sqlplus.
C:\oracle\product\crs\bin> srvctl status database -d vis
Instance vis1 is not running on node kdbsrv1
Instance vis2 is not running on node kdbsrv2
when I run srvctl start the output is like below,
C:\oracle\product\crs\bin> srvctl start database -d vis
PRKP-1001 : Error starting instance vis1 on node kdbsrv1
CRS-0215: ora.VIS.vis1.inst source could not started.
PRKP-1001 : Error starting instance vis2 on node kdbsrv2
CRS-0215: ora.VIS.vis2.inst source could not started
I did lots of thing.
srvctl remove instance / add instance (nothing changed)
srvctl modify database -p <SPFILE>-s open (nothing changed)
srvctl stop / start database .. many times but no help
can you please share your experiences with me. I am not expert on RAC serives but i must bring it online asap..
Thanks in advance for your supports
I have a big problem. Recently we have taken a responsibility of a new system which db is oracle 10g and RAC is configured (Windows 2003 Servers). But when I execute i see that nodes status are not running. But instances are up and i can connect them within sqlplus.
C:\oracle\product\crs\bin>
Instance vis1 is not running on node kdbsrv1
Instance vis2 is not running on node kdbsrv2
when I run srvctl start the output is like below,
C:\oracle\product\crs\bin>
PRKP-1001 : Error starting instance vis1 on node kdbsrv1
CRS-0215: ora.VIS.vis1.inst source could not started.
PRKP-1001 : Error starting instance vis2 on node kdbsrv2
CRS-0215: ora.VIS.vis2.inst source could not started
I did lots of thing.
srvctl remove instance / add instance (nothing changed)
srvctl modify database -p <SPFILE>-s open (nothing changed)
srvctl stop / start database .. many times but no help
can you please share your experiences with me. I am not expert on RAC serives but i must bring it online asap..
Thanks in advance for your supports
crs_stat -t output was like this.
ora.VIS.db application ONLINE OFFLINE
ora....s1.inst application ONLINE OFFLINE
ora....s2.inst application ONLINE OFFLINE
ora....V1.lsnr application ONLINE ONLINE kdbsrv1
ora....rv1.gsd application ONLINE ONLINE kdbsrv1
ora....rv1.ons application ONLINE ONLINE kdbsrv1
ora....rv1.vip application ONLINE ONLINE kdbsrv1
ora....V2.lsnr application ONLINE ONLINE kdbsrv2
ora....rv2.gsd application ONLINE ONLINE kdbsrv2
ora....rv2.ons application ONLINE ONLINE kdbsrv2
ora....rv2.vip application ONLINE ONLINE kdbsrv2
i run crs_stop -all
then it changed as below
ora.VIS.db application ONLINE OFFLINE
ora....s1.inst application OFFLINE OFFLINE
ora....s2.inst application OFFLINE OFFLINE
ora....V1.lsnr application OFFLINE OFFLINE
ora....rv1.gsd application OFFLINE OFFLINE
ora....rv1.ons application OFFLINE OFFLINE
ora....rv1.vip application OFFLINE OFFLINE
ora....V2.lsnr application OFFLINE OFFLINE
ora....rv2.gsd application OFFLINE OFFLINE
ora....rv2.ons application OFFLINE OFFLINE
ora....rv2.vip application OFFLINE OFFLINE
C:\oracle\product\crs\bin>crs_start -all
Attempting to start `ora.kdbsrv1.vip` on member `kdbsrv1`
Start of `ora.kdbsrv1.vip` on member `kdbsrv1` succeeded.
Attempting to start `ora.kdbsrv2.vip` on member `kdbsrv2`
Start of `ora.kdbsrv2.vip` on member `kdbsrv2` succeeded.
Attempting to start `ora.kdbsrv1.gsd` on member `kdbsrv1`
Start of `ora.kdbsrv1.gsd` on member `kdbsrv1` succeeded.
Attempting to start `ora.kdbsrv2.gsd` on member `kdbsrv2`
Start of `ora.kdbsrv2.gsd` on member `kdbsrv2` succeeded.
Attempting to start `ora.kdbsrv1.ons` on member `kdbsrv1`
Start of `ora.kdbsrv1.ons` on member `kdbsrv1` succeeded.
Attempting to start `ora.kdbsrv2.ons` on member `kdbsrv2`
Start of `ora.kdbsrv2.ons` on member `kdbsrv2` succeeded.
Attempting to start `ora.kdbsrv1.LISTENER_KDBSRV1.lsnr` on member `kdbsrv1`
Start of `ora.kdbsrv1.LISTENER_KDBSRV1.lsnr` on member `kdbsrv1` succeeded.
Attempting to start `ora.kdbsrv2.LISTENER_KDBSRV2.lsnr` on member `kdbsrv2`
Start of `ora.kdbsrv2.LISTENER_KDBSRV2.lsnr` on member `kdbsrv2` succeeded.
Attempting to start `ora.VIS.db` on member `kdbsrv1`
Start of `ora.VIS.db` on member `kdbsrv1` failed.
Attempting to start `ora.VIS.db` on member `kdbsrv2`
Start of `ora.VIS.db` on member `kdbsrv2` failed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.