Redhat7.3安裝了grid和oracle,安裝完成后沒問題,如下圖,可以正常shutdown immediate以及startup,連接資料庫也沒問題。
對root操作時,啟動關閉都很流暢:
[root@dbserver hz]# srvctl stop db -d tdr
[root@dbserver hz]# srvctl start db -d tdr
[root@dbserver hz]# crs_stat -t
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.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE dbserver
ora.ons ora.ons.type OFFLINE OFFLINE
ora.tdr.db ora....se.type ONLINE ONLINE dbserver
問題來了
但是重啟虛擬機后就出現問題了,我是先對oracle操作shutdown immediate,然后對root操作reboot。
系統起來之后所有命令都出了問題,百度各種辦法也沒有解決,請前輩們指教一二。
[root@dbserver hz]# ll /dev/sd*
brw-rw---- 1 root disk 8, 0 Apr 7 23:14 /dev/sda
brw-rw---- 1 root disk 8, 1 Apr 7 23:14 /dev/sda1
brw-rw---- 1 root disk 8, 2 Apr 7 23:14 /dev/sda2
brw-rw---- 1 grid asmadmin 8, 16 Apr 7 23:14 /dev/sdb
brw-rw---- 1 grid asmadmin 8, 32 Apr 7 23:14 /dev/sdc
[root@dbserver hz]# srvctl start db -d tdr
PRCD-1027 : Failed to retrieve database tdr
PRCR-1115 : Failed to find entities of type resource that match filters ((NAME == ora.tdr.db) && (TYPE == ora.database.type)) and contain attributes VERSION,ORACLE_HOME,DATABASE_TYPE
Cannot communicate with crsd
[root@dbserver hz]# crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.
對oracle操作startup時:
SQL> startup;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG01/tdr/spfiletdr.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG01/tdr/spfiletdr.ora
ORA-29701: unable to connect to Cluster Synchronization Service
對grid操作時:
[grid@dbserver ~]$ asmcmd
Connected to an idle instance.
sh: /u01/app/oracle/product/11.2.0/dbhome_1/bin/clsecho: No such file or directory
ASMCMD> lsdg
Can't exec "/u01/app/oracle/product/11.2.0/dbhome_1/bin/clsecho": No such file or directory at /u01/app/oracle/product/11.2.0/dbhome_1/lib/asmcmdshare.pm line 494, <STDIN> line 1.
Use of uninitialized value $buf in string ne at /u01/app/oracle/product/11.2.0/dbhome_1/lib/asmcmdshare.pm line 498, <STDIN> line 1.
ASMCMD>
以上,請問各位大神這是哪里出了致命問題,請指教。會不會是我的外掛磁盤sdb和sdc沒有做磁區?sdb是安裝GRID,sdb是資料庫用的DG01。
[root@dbserver hz]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 40G 0 disk
sda1 8:1 0 1G 0 part /boot
sda2 8:2 0 39G 0 part
rhel-root 253:0 0 35G 0 lvm /
rhel-swap 253:1 0 4G 0 lvm [SWAP]
sdb 8:16 0 10G 0 disk
sdc 8:32 0 10G 0 disk
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/273386.html
標籤:基礎和管理
下一篇:兩個表連接后,各選一列相加