Home > database >  The oracle database on the GRID, bosses, please help
The oracle database on the GRID, bosses, please help

Time:04-08

Redhat7.3 installed grid and oracle, no problem after the installation is complete, the following figure, can normal shutdown immediate and startup, connect to the database is also no problem,

root operation, start off smoothly:
[root @ dbserver hz] # SRVCTL stop db - d TDR
[root @ dbserver hz] # SRVCTL start the db - d TDR

[root @ dbserver hz] # crs_stat - t
The Name, Type, Target State Host
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Ora. DG01. Dg ora... Up. Type ONLINE ONLINE dbserver
Ora. GRID. Dg ora... Up. Type ONLINE ONLINE dbserver
Ora... ER. LSNR ora... Er. Type ONLINE ONLINE dbserver
Ora. Asm ora. Asm. Type ONLINE ONLINE dbserver
Ora, CSSD ora. CSSD. Type ONLINE ONLINE dbserver
Ora. Diskmon ora... On the type OFFLINE OFFLINE
Ora. Evmd ora. Evm entry. Type ONLINE ONLINE dbserver
Ora. Ons ora. Ons. Type OFFLINE OFFLINE
Ora. TDR. Db ora... Se. Type ONLINE ONLINE dbserver





But after the restart the virtual machine appears problem, I am the first to oracle shutdown immediate operation, then reboot to root operation,
System up after all ordered out of the question, various solution and no baidu, please predecessors taught a thing or two,


[root @ dbserver hz] # ll/dev/sd *
BRW - rw - 1 root disk 8, 0 Apr 7 brake in/dev/sda
BRW - rw - 1 root disk 8, 1 Apr 7 brake in/dev/sda1
BRW cd-rw root disk 8-1, 2 Apr 7 brake in/dev/sda2
BRW - rw - 1 grid asmadmin 8, 16 Apr 7 brake in/dev/SDB
BRW - rw - 1 grid asmadmin 8, 32/dev/SDC Apr 7 brake in

[root @ dbserver hz] # SRVCTL start the db - d TDR
PRCD - 1027: Failed to retrieve the database TDR
PRCR - 1115: Failed to find entities of type resource that match filters ((NAME==ora. TDR. Db) & amp; & (TYPE==ora. Database. TYPE)) and contain attributes VERSION, ORACLE_HOME, DATABASE_TYPE
Always communicate with CRSD

[root @ dbserver hz] # crs_stat - t
CRS - 0184: always communicate with the CRS daemon.


to oracle startup operation:
SQL> Startup;
ORA - 01078: a failure in processing system parameters
ORA - 01565: the error in identifying the file '+ DG01/TDR/spfiletdr ORA'
ORA - 17503:2 ksfdopn: Failed to open the file + DG01/TDR/spfiletdr ORA
ORA - 29701: unable to connect to the Cluster Synchronization Service


the grid operation:
[grid @ dbserver ~] $asmcmd
Connected to an idle instance.
Sh:/u01/app/oracle/product/11.2.0/dbhome_1/bin/clsecho: No to the file or directory
ASMCMD> LSDG
Can 't exec "/u01/app/oracle/product/11.2.0/dbhome_1/bin/clsecho" : No to the file or directory at/u01/app/oracle/product/11.2.0/dbhome_1/lib/asmcmdshare PM line 494, & lt; STDIN> Line 1.
The Use of uninitialized value $buf string in ne at/u01/app/oracle/product/11.2.0/dbhome_1/lib/asmcmdshare PM line 498, & lt; STDIN> Line 1.
ASMCMD>


above, is a great god this is where a fatal problem, please advise, will is my external disk SDB partition and SDC did not do? SDB is to install the GRID, SDB is the database using DG01,
[root @ dbserver hz] # LSBLK
The NAME MAJ: MIN RM SIZE RO TYPE MOUNTPOINT
Sda 8-0 0 0 40 g disk
Sda1 8:1 0 0 1 g part/boot
Sda2 0 39 g 0 part lo
Rhel - root 253:35 g 0 0 0 LVM/
Rhel - swap 253:1 0 4 g 0 LVM/swap
SDB he 0 0, 10 g disk
SDC now 0 0, 10 g disk