Hello!
I've installed Oracle 11g SE(11.2.0.4 ) with RAC with 2 nodes on RedHat 7.1 with role separation (grid and oracle db are running under different users)
Right after installation it was working, I was able to connect to the database, create a table and see it on both RAC nodes.
But after restart of the servers I can't make it working again
Maybe someone could help me to understand what I'm doing wrong?
When I'm trying to start a database instance on the node vm-ora-05, I'm getting this:
sqlplus /nolog
01:35:22 @ :>connect / as sysdba
Connected to an idle instance.
01:35:28 SYS @ racdba1:>startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/racdba/spfileracdba.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/racdba/spfileracdba.ora
ORA-12547: TNS:lost contact
01:35:32 SYS @ racdba1:>
**********************************
Environment variables for GRID
ORACLE_HOME=/u01/app/11.2.0.4/grid
ORACLE_SID=+ASM1
Environment variables for Oracle DB
ORACLE_HOME=/u01/app/oracle/11.2.0.4/rachome1
ORACLE_SID=racdba1
**********************************
If I check status of disk groups and the file +DATA/racdba/spfileracdba.ora in asmcmd it seems to be Ok (for me at least)
[grid@+ASM1 grid]$asmcmd
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /u01/app/oracle
ASMCMD [+] > lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 5121 4725 0 4725 0 Y CRS/
MOUNTED EXTERN N 512 4096 4194304 153596 151240 0 151240 0 N DATA/
MOUNTED EXTERN N 512 4096 4194304 153596 153020 0 153020 0 N FRA/
ASMCMD [+] > ls -l +DATA/racdba/spfileracdba.ora
Type Redund Striped Time Sys Name
N spfileracdba.ora => +DATA/RACDBA/PARAMETERFILE/spfile.267.894291829
ASMCMD [+] > ls -l +DATA/RACDBA/PARAMETERFILE/spfile.267.894291829
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE NOV 03 01:00:00 Y spfile.267.894291829
**********************************
At the same time, not sure why oracleasm scandisks/listdisks don't show any disks...
[root@vm-ora-05 dimic]# /usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@vm-ora-05 dimic]# /usr/sbin/oracleasm listdisks
[root@vm-ora-05 dimic]#
**********************************
Here is the output of the crsctl stat res -t and crsctl check cluster
[grid@+ASM1 grid]$crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE vm-ora-05
ora.DATA.dg
ONLINE ONLINE vm-ora-05
ora.FRA.dg
ONLINE ONLINE vm-ora-05
ora.LISTENER.lsnr
ONLINE ONLINE vm-ora-05
ora.asm
ONLINE ONLINE vm-ora-05 Started
ora.gsd
OFFLINE OFFLINE vm-ora-05
ora.net1.network
ONLINE ONLINE vm-ora-05
ora.ons
ONLINE ONLINE vm-ora-05
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE vm-ora-05
ora.cvu
1 ONLINE ONLINE vm-ora-05
ora.oc4j
1 ONLINE ONLINE vm-ora-05
ora.racdba.db
1 ONLINE OFFLINE Instance Shutdown
2 ONLINE OFFLINE Instance Shutdown
ora.scan1.vip
1 ONLINE ONLINE vm-ora-05
ora.vm-ora-05.vip
1 ONLINE ONLINE vm-ora-05
ora.vm-ora-06.vip
1 ONLINE INTERMEDIATE vm-ora-05 FAILED OVER
[grid@+ASM1 grid]$crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@+ASM1 grid]$
Please help, this problem drives me crazy ((