【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 2014-07-02 21:06:58
分類： Oracle
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝
1.1 簡介
1.1.1 ASMLib
1.1.2 什麼是 udev
1.1.3 Why ASMLIB and why not
1.2 在 RHEL 6.4 上安裝 Oracle 11gR2 + ASM --使用udev
1.2.1 檢查硬體
1.2.2 安裝軟體包檢查
1.2.3 修改主機名
1.2.4 網絡配置
1.2.5 磁盤準備
1.2.6 配置目錄、使用者等
1.2.7 使用udev管理磁盤
1.2.8 系統核心參數修改
1.2.9 為 Linux 系統配置本地 YUM 源
1.2.10 安裝grid
1.2.11 使用netmgr建立監聽
1.2.12 開始搭建 Oracle 資料庫
1.2.13 使用 netmgr 建立監聽--Oracle使用者不需要建立
1.2.14 使用 dbca 建立資料庫
1.2.15 配置ORACLE自動啟動
1.2.16 驗證
1.3 啟動crs
1.4 報錯：
1.4.1 Oracle 11gR2 RAC ohasd failed to start 解決方法
1.4.2 CRS-4639: Could not contact Oracle High Availability Services
1.4.3 ORA-29701: unable to connect to Cluster Synchronization Service
1.4.4 asm 執行個體無法加載diskgroups，ORA-15110: no diskgroups mounted
1.4.5 在啟動DB時報錯ORA-27154 ORA-27300 ORA-27301 ORA-27302
1.4.6 ORA-29786: SIHA attribute GET failed
1.4.7 11gR2手動建立ASM執行個體ORA-29786錯誤解決方法
1.4.8 ORACLE dbca 找不到asm disks
1.4.9 ora-15077，ASM磁盤組不能挂載
Readme
看到群上還有人糾結ASM的安裝，我很痛心，不過想想自己當時安裝的時候花了将近一周的時間才安裝好，主要是白天上班，又沒有網絡，是以隻好晚上安裝了，自己開始安裝的時候是11.2.0.1.0，這個版本安裝有很多bug，雖然安裝成功了但是很痛苦，後來參加OCP教育訓練，老師給了11.2.0.3.0版本，安裝的時候很順利，沒有報錯了。
第一次安裝的時候，涉及到ASMlib，udev神馬的一堆，學習Oracle沒有好的導師痛苦呀，最後經過大量百度，自己摸索才把這一推問題解決了。大家看這篇博文的時候注意文檔的層次結構，很郁悶，發表博文不能很好的把文章結構發出來。。。文章最後收錄了一些安裝過程中可能會出現的一些問題，供大家參考，如果有什麼意見請大家留言或加QQ，謝謝大家的來訪。
-
簡介
-
ASMLib
-
在Red Hat Enterprise Linux (RHEL)6以前，Oracle均是使用ASMLib這個核心支援庫配置ASM。ASMLIB是一種基于Linux module，專門為Oracle Automatic Storage Management特性設計的核心支援庫(kernel support library)。但是，在2011年5月，甲骨文發表了一份Oracle資料庫ASMLib的聲明，聲明中稱甲骨文将不再提供Red Hat Enterprise Linux (RHEL)6的ASMLib和相關更新。
甲骨文在這份聲明中表示，ASMLib更新将通過Unbreakable Linux Network (ULN)來釋出，并僅對Oracle Linux客戶開放。ULN雖然為甲骨文和紅帽的客戶服務，但如果客戶想要使用ASMlib，就必須使用Oracle的kernel來替換掉紅帽的。
這份聲明詳見Oracle Metalink文檔:
Oracle ASMLib Software Update Policy for Red Hat Enterprise Linux Supported by Red Hat [ID 1089399.1]
Software Update Policy for ASMLib running on future releases of Red Hat Enterprise Linux Red Hat Enterprise Linux 6 (RHEL6)For RHEL6 or Oracle Linux 6, Oracle will only provide ASMLib software and updates when configuredUnbreakable Enterprise Kernel (UEK). Oracle will not provide ASMLib packages for kernels distributedby Red Hat as part of RHEL 6 or the Red Hat compatible kernel in Oracle Linux 6. ASMLib updates will be delivered via Unbreakable Linux Network(ULN) which is available to customers with Oracle Linux support. ULN works with both Oracle Linux or Red Hat Linux installations, but ASMlib usage will require replacing any Red Hat kernel with UEK
是以，在Red Hat Enterprise Linux (RHEL)6上使用ASMLib已不再現實，另外ASMLib也有一定的缺點，詳見文檔說明：
http://www.oracledatabase12g.com/archives/why-asmlib-and-why-not.html
是以，目前在Red Hat Enterprise Linux (RHEL)6上使用Oracle+ASM，已不再使用ASMLib，而是采用udev裝置檔案來配置ASM。
-
什麼是 udev
udev 是Linux2.6 核心裡的一個功能，它替代了原來的devfs，成為目前Linux 預設的裝置管理工具。udev 以守護程序的形式運作，通過偵聽核心發出來的uevent 來管理/dev目錄下的裝置檔案。不像之前的裝置管理工具，udev 在使用者空間(user space) 運作，而不在核心空間(kernel space) 運作。
-
Why ASMLIB and why not?
ASMLIB是一種基于Linux module，專門為Oracle Automatic Storage Management特性設計的核心支援庫(kernel support library)。
長久以來我們對ASMLIB的認識并不全面，這裡我們來具體了解一下使用ASMLIB的優缺點。
理論上我們可以從ASMLIB API中得到的以下益處:
- 總是使用direct,async IO
- 解決了永久性裝置名的問題，即便在重新開機後裝置名已經改變的情況下
- 解決了檔案權限、擁有者的問題
- 減少了I/O期間從使用者模式到核心模式的上下文切換，進而可能降低cpu使用率
- 減少了檔案句柄的使用量
- ASMLIB API提供了傳遞如I/O優先級等元資訊到儲存設備的可能
雖然從理論上我們可以從ASMLIB中得到性能收益，但實踐過程中這種優勢是幾乎可以忽略的，沒有任何性能報告顯示ASMLIB對比Linux上原生态的udev裝置管理服務有任何性能上的優勢。在Oracle官方論壇上有一篇讨論ASMLIB性能收益的文章，你可以從中看到"asmlib wouldn't necessarily give you much of an io performance benefit, it's mainly for ease of management as it will find/discover the right devices for you, the io effect of asmlib is large the same as doing async io to raw devices."的評論，實際上使用ASMLIB和直接使用裸裝置(raw device)在性能上沒有什麼差别。
ASMLIB可能帶來的缺點:
- 對于多路徑裝置(multipathing)需要在/etc/sysconfig/oracleasm-_dev_oracleasm配置檔案中設定ORACLEASM_SCANORDER及ORACLEASM_SCANEXCLUDE，以便ASMLIB能找到正确的裝置檔案，具體可以參考Metalink Note
- 因為ASM INSTANCE使用ASMLIB提供的asm disk，是以增加了額外的層面
- 每次Linux Kernel更新，都需要替換新的ASMLIB包
- 增加了因人為錯誤造成當機downtime的可能
- 使用ASMLIB意味着要花費更多時間去建立和維護
- 因為ASMLIB的存在，可能引入更多的bug，這是我們最不想看到的
- 使用ASMLIB建立的disk，其disk header并不會和普通的asm disk header有什麼不同，僅僅是在頭部多出了ASMLIB的屬性空間。
結論:我個人的觀點是盡可能不要使用ASMLIB，當然這不是DBA個人所能決定的事情。另一方面這取決于個人習慣，在rhel 4的早期發行版本中沒有提供udev這樣的裝置管理服務，這導緻在rhel 4中大量的ASM+RAC組合的系統使用ASMLIB , 經網友指出udev 作為kernel 2.6的新特性被引入，在rhel4的初始版本中就已經加入了udev綁定服務，但是在rhel4時代實際udev的使用并不廣泛(In Linux 2.6, a new feature was introduced to simplify device management and hot plug capabilities. This feature is called udev and is a standard package in RHEL4 or OracleEnterprise Linux 4 (OEL4) as well as Novell's SLES9 and SLES10.)。如果是在RHEL/OEL 5中那麼你已經有充分的理由利用udev而放棄ASMLIB。
Reference:ASMLIB Performance vs UdevRAC+ASM 3 years in production Stories to shareHow To Setup ASM & ASMLIB On Native Linux Multipath Mapper disks? [ID 602952.1]ASMLib and Linux block devices
-
在 RHEL 6.4 上安裝 Oracle 11gR2 + ASM --使用udev
實驗環境：
OS: Oracle Linux Server release 6.4 x64 或 RHEL6.4
Database: Oracle Database 11gR2 x64 (11.2.0.1.0)
VMware: VMware Workstation 10.0.0 build-812388
軟體：
- xmanager-passive
- XSHELL
-
檢查硬體
在正式安裝開始前，請先檢查你的軟硬體條件是否滿足安裝需要。
硬體上可以使用指令檢視記憶體情況和 CPU 特性：
#more /proc/meminfo
#more /proc/cpuinfo
其中記憶體的要求是不低于 1G
下面的不是必須的，可選使用
#df –k /dev/shm 檢查共享記憶體
#df –k /tmp 檢查臨時磁盤空間
#more /proc/version 檢查作業系統版本
#uname –r 檢查核心版本
記憶體
# grep MemTotal /proc/meminfo
交換空間
# grep SwapTotal /proc/meminfo
磁盤空間
# df -ah
# free
#free -m
Minimum: 1 GB of RAM
Recommended: 2 GB of RAM or more
?
To determine the RAM size, enter the following command:
# grep MemTotal /proc/meminfo
swap檢查
Between 1 GB and 2 GB 1.5 times the size of the RAM
Between 2 GB and 16 GB Equal to the size of the RAM
More than 16 GB 16 GB
# grep SwapTotal /proc/meminfo
To determine the available RAM and swap space, enter the following command:
# free -m
?The following tables describe the disk space requirements for software files and data files for each installation type on Linux x86:
Installation Type Requirement for Software Files (GB)
Enterprise Edition 3.95
Standard Edition 3.88
Installation Type Disk Space for Data Files (GB)
Enterprise Edition 1.7
Standard Edition 1.5
[root@yutian ~]# cat /proc/version
Linux version 2.6.18-164.el5 ([email protected]) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-46)) #1 SMP Tue Aug 18 15:51:54 EDT 2009
[root@yutian ~]# lsb_release -id
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 5.4 (Tikanga)
[root@yutian ~]#
-
安裝軟體包檢查
可以統一檢查：
rpm -q binutils \
compat-libstdc++-33 \
elfutils-libelf \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
ksh \
libaio \
libaio-devel \
libgomp \
libgcc \
libstdc++ \
libstdc++-devel \
make \
sysstat \
unixODBC \
unixODBC-devel \
numactl-devel
我們可以看到沒有安裝過的包會已is not installed 出現：
[[email protected]_lhr ~]# rpm -q binutils \
> compat-libstdc++-33 \
> elfutils-libelf \
> gcc \
> gcc-c++ \
> glibc \
> glibc-common \
> glibc-devel \
> glibc-headers \
> ksh \
> libaio \
> libaio-devel \
> libgomp \
> libgcc \
> libstdc++ \
> libstdc++-devel \
> make \
> sysstat \
> unixODBC \
> unixODBC-devel \
> numactl-devel
binutils-2.20.51.0.2-5.36.el6.x86_64
compat-libstdc++-33-3.2.3-69.el6.x86_64
compat-libstdc++-33-3.2.3-69.el6.i686
elfutils-libelf-0.152-1.el6.x86_64
gcc-4.4.7-4.el6.x86_64
gcc-c++-4.4.7-4.el6.x86_64
glibc-2.12-1.132.el6.x86_64
glibc-common-2.12-1.132.el6.x86_64
glibc-devel-2.12-1.132.el6.x86_64
glibc-headers-2.12-1.132.el6.x86_64
package ksh is not installed
libaio-0.3.107-10.el6.x86_64
libaio-devel-0.3.107-10.el6.x86_64
libaio-devel-0.3.107-10.el6.i686
libgomp-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.x86_64
libstdc++-4.4.7-4.el6.x86_64
libstdc++-devel-4.4.7-4.el6.x86_64
libstdc++-devel-4.4.7-4.el6.i686
make-3.81-20.el6.x86_64
sysstat-9.0.4-22.el6.x86_64
unixODBC-2.2.14-12.el6_3.x86_64
unixODBC-2.2.14-12.el6_3.i686
unixODBC-devel-2.2.14-12.el6_3.i686
unixODBC-devel-2.2.14-12.el6_3.x86_64
package numactl-devel is not installed
[[email protected]_lhr ~]#
如果部分包不存在
可以批量更新安裝，但如果依賴關系缺失，可能需要多執行兩遍
或者手工調整
-
-
檢查下列包是否安裝，若未安裝則要先安裝：
rpm -qa | grep binutils-
rpm -qa | grep compat-libstdc++-
rpm -qa | grep elfutils-libelf-
rpm -qa | grep elfutils-libelf-devel-
rpm -qa | grep glibc-
rpm -qa | grep glibc-common-
rpm -qa | grep glibc-devel-
rpm -qa | grep gcc-
rpm -qa | grep gcc-c++-
rpm -qa | grep libaio-
rpm -qa | grep libaio-devel-
rpm -qa | grep libgcc-
rpm -qa | grep libstdc++-
rpm -qa | grep libstdc++-devel-
rpm -qa | grep make-
rpm -qa | grep sysstat-
rpm -qa | grep unixODBC-
rpm -qa | grep unixODBC-devel-
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
gcc-4.1.1-52
gcc-c++-4.1.1-52
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
# rpm -qa | grep make gcc glibc compat openmotif21 setarch 等等
建議你用 rpm –q packagename 逐個檢查，因為是官方要求，是以為了不在安裝時出現不必要的麻煩，還是确認都全部安裝為好。
雖然我是全新安裝的系統也存在 3 個包沒安裝：Libaio-devel numactl-devel sysstat
挂載 Linux 5 CD光牒，查找包的完整路徑名稱：
[[email protected] ~]# mkdir /media/cdrom ; mount /dev/cdrom /media/cdrom
[[email protected] ~]# ll /media/cdrom/Server/ |grep libaio-devel
[[email protected] ~]# ll /media/cdrom/Server/ |grep numactl-devel
[[email protected] ~]# ll /media/cdrom/Server/ |grep sysstat
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 安裝 RPM 包：
[[email protected] ~]# rpm -ivh /media/cdrom/Server/libaio-devel-0.3.106-3.2.i386.rpm
[[email protected] ~]# rpm -ivh /media/cdrom/Server/numactl-devel-0.9.8-7.el5.i386.rpm
[[email protected] ~]# rpm -ivh /media/cdrom/Server/sysstat-7.0.2-3.el5.i386.rpm
rpm -ivh compat-libstdc++-33-3.2.3-69.el6.i686.rpm --force --nodeps
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 [[email protected] RHEL_6.5 x86_64 Disc 1]# pwd
/media/RHEL_6.5 x86_64 Disc 1
[[email protected] RHEL_6.5 x86_64 Disc 1]#
另外，為了支援 ODBC 建議順便安裝下面兩個包：
unixODBC-2.2.11 (32 bit) or later
unixODBC-devel-2.2.11 (32 bit) or later
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
修改主機名
永久生效：
[[email protected] /]# vim /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=zijuan
HOSTNAME=zijuan表示主機設定為zijuan.
注意：修改主機名後，需要重新開機系統後生效，或者切換個使用者然後切換回來就OK
檢視/etc/hosts檔案中必須包含a fully qualified name for the server
[[email protected] lhr]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.128.131 rhel6_linux_asm
[[email protected] lhr]# hostname
localhost.localdomain
[[email protected] lhr]# hostname rhel6.5_linux
[[email protected] lhr]# hostname
rhel6_linux_asm
修改/etc/hosts檔案
[[email protected] ~]#vim/etc/hosts
127.0.0.1 localhost.localdomainlocalhost
::1 localhost6.localdomain6localhost6
192.168.137.112 oracle.domain.comoracle
注意将主機名對應到真實ip位址，否則oracle有可能将監聽程式僅僅建立在127.0.0.1上
-
網絡配置
-
磁盤準備
這裡我們準備5塊硬碟
1塊硬碟安裝作業系統
234塊用于實作ASM 存儲資料
5塊硬碟用于存儲FRA
-
添加磁盤
1.2. 新增硬體 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 1.3. 添加第一塊硬碟 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 1.4. 建立新的虛拟磁盤 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 1.5. 選擇磁盤類型 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 1.6. 設定磁盤大小 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 1.7. 完成 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 1.8.
添加第二、三、四、五 塊磁盤：重複步驟 1~7
1.9.
這裡5塊磁盤添加完畢後，為了避免後邊再重新開機一次，可以先把後邊需要的一個步驟做了，就是找到虛拟機的配置檔案，在最後添加一行 disk.EnableUUID="TRUE"，這裡注意修改檔案的時候一定要在關機的狀态下修改該參數檔案。 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
對磁盤進行分區
磁盤添加完成後，啟動虛拟機，作為 root 使用者登入系統，格式化新添加的兩塊磁盤。
[[email protected] share]# fdisk -l | grep "Disk /dev/sd"
Disk /dev/sde: 10.7 GB, 10737418240 bytes
Disk /dev/sdd: 10.7 GB, 10737418240 bytes
Disk /dev/sda: 53.7 GB, 53687091200 bytes
Disk /dev/sdb: 10.7 GB, 10737418240 bytes
Disk /dev/sdc: 10.7 GB, 10737418240 bytes
磁盤分區完成後，檢視所有磁盤情況。 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 注意這裡隻做磁盤的分區，并不做磁盤的格式化和挂載 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
配置目錄、使用者等
-
配置使用者及使用者組
利用 /usr/sbin/groupadd 指令
------這裡Oracle使用者可能已經安裝過的，沒有影響：
代碼：
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
groupadd asmoper
groupadd asmdba
--添加使用者到組
useradd -g oinstall -G dba,asmdba,oper,asmadmin oracle
useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid
--修改密碼
passwd oracle
passwd grid
echo oracle | passwd --stdin lhr
echo grid | passwd --stdin lhr
---檢視屬主
[[email protected]_linux_asm ~]# id oracle
uid=501(oracle) gid=502(dba) groups=502(dba),501(oinstall),504(asmadmin),506(asmdba)
[[email protected]_linux_asm ~]# id grid
uid=502(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),505(asmoper),506(asmdba)
[[email protected]_linux_asm ~]#
-
建立目錄并且配置 grid 和 oracle 使用者的配置檔案
代碼：
--root使用者下：
mkdir -p /u01/app/oracle
mkdir -p /u01/app/grid
mkdir -p /u01/app/grid/11.2.0
chown -R grid:oinstall /u01/app/grid --把/u01/app/grid 的所有者改為grid
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
--------Oracle User----切換到Oracle使用者下------
[[email protected]_linux_asm ~]# su - oracle
[[email protected]_linux_asm ~]$ vi ~/.bash_profile
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$PATH:$ORACLE_HOME/bin
--------Grid User-----切換到grid使用者下-----
cd /home/grid
vim .bash_profile
export ORACLE_SID=+ASM
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/grid/11.2.0
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
umask 022
[[email protected] ~]$ source .bash_profile
-
使用udev管理磁盤
-
配置 udev 綁定的 scsi_id
注意以下兩點：
首先切換到root使用者下：
5.1. 不同的作業系統，scsi_id 指令的位置不同。
[[email protected] ~]# cat /etc/issue
Oracle Linux Server release 6.4
Kernel \r on an \m
[[email protected] ~]# which scsi_id
/sbin/scsi_id
[[email protected] ~]#
5.2. 編輯 /etc/scsi_id.config 檔案，如果該檔案不存在，則建立該檔案并添加如下行：
[[email protected] ~]# vi /etc/scsi_id.config
options=--whitelisted --replace-whitespace
[[email protected] ~]#
5.3. 如果是使用 VMware 虛拟機，直接輸入 scsi_id 指令可能無法擷取 id，需修改 VMware 檔案參數，這一步如果在添加磁盤的時候做過這一步的話就可以跳過了，直接擷取uuid即可
[[email protected] ~]# scsi_id --whitelisted --replace-whitespace --device=/dev/sdb
[[email protected] ~]# scsi_id --whitelisted --replace-whitespace --device=/dev/sdc
D:\VMs\Oracle Database 11gR2\Oracle Database 11gR2.vmx
使用文本編輯器編輯該檔案，在尾部新增一行參數：
disk.EnableUUID="TRUE"
儲存檔案，重新啟動虛拟機。這裡注意修改檔案的時候一定要在關機的狀态下修改，或者 scsi_id -g -u /dev/sdc 來獲得uuid，-g -u參數在rhel6以後已經不用了
[[email protected] share]# scsi_id --whitelisted --replace-whitespace --device=/dev/sdb
36000c29fbe57659626ee89b4fba07616
[[email protected] share]# scsi_id --whitelisted --replace-whitespace --device=/dev/sdc
36000c29384cde894e087e5f0fcaa80f4
[[email protected] share]# scsi_id --whitelisted --replace-whitespace --device=/dev/sdd
36000c29022aee23728231ed9b1f9743d
[[email protected] share]# scsi_id --whitelisted --replace-whitespace --device=/dev/sde
36000c2938f431664218d1d2632ff1352
-
建立并配置 udev rules 檔案
[[email protected] ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29fe0fc917d7e9982742a28ce7c", NAME="asm-diskb", OWNER="grid",GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c293ffc0900fd932348de4b6baf8", NAME="asm-diskc", OWNER="grid",GROUP="asmadmin", MODE="0660"
根據步驟 5 擷取的 ID 修改 RESULT 值
這裡需要注意，一個KERNEL就是一行，不能換行的，我之前就是犯了這個錯誤的
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 添加4塊硬碟：
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29346c1344ffb26f0e5603d519e", NAME="asm-diskb", OWNER="grid",GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c29d08ee059a345571054517cd03", NAME="asm-diskc", OWNER="grid",GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c295037a910bfb765af8f400aa07", NAME="asm-diskd", OWNER="grid",GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="36000c2982bda048f642acd3c429ec983", NAME="asm-diske", OWNER="grid",GROUP="asmadmin", MODE="0660"
注意：這裡的GROUP="asmadmin", 最好修改成 GROUP="asmdba"，不然最後可能用dbca建立資料庫執行個體的時候找不見磁盤組。 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
添加完成後，重新開機 udev，不同 Linux 發行版本重新開機方式不一樣。
該步驟慢一點，大約可能需要30秒左右吧，等等等等。。。。。。
[[email protected] ~]# start_udev
Starting udev: [ OK ]
[[email protected] ~]#
-
檢視綁定的 asm，如果此時還是看不到 asm disk，請重新開機作業系統後再檢視。
[[email protected] ~]# ll /dev/asm*
brw-rw---- 1 grid asmadmin 8, 17 Oct 17 14:26 /dev/asm-diskb
brw-rw---- 1 grid asmadmin 8, 33 Oct 17 14:26 /dev/asm-diskc
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
系統核心參數修改
-
編輯 /etc/security/limits.conf 檔案，在檔案尾部添加如下内容：
-
[[email protected] ~]# tail -8 /etc/security/limits.conf
# add by lhr for oracle and grid on 2014-05-02
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
編輯 /etc/pam.d/login 檔案，在檔案尾部添加如下内容：
[[email protected] ~]# tail -1 /etc/pam.d/login
session required pam_limis.so
[[email protected] ~]#
-
編輯 /etc/profile 檔案，設定 shell 限制，在檔案尾部添加如下内容：
[[email protected] ~]# tail -9 /etc/profile
if [ /$USER = "oracle" ] || [ /$USER = "grid" ]; then
if [ /$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
-
/etc/sysctl.conf
Configuring Kernel Parameters for Linux
vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
生效
# /sbin/sysctl -p
-
安裝grid
-
通過 ZMODEM 上傳檔案 linux.x64_11gR2_grid.zip 至grid使用者家目錄 /home/grid/
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 [[email protected] ~]# ll /home/grid/
total 1028228
-rw-r--r-- 1 root root 1052897657 Oct 16 13:22 linux.x64_11gR2_grid.zip
[[email protected] ~]#
-
解壓檔案
[[email protected] grid]# unzip linux.x64_11gR2_grid.zip
[[email protected] grid]# ll
total 1028232
drwxr-xr-x 8 root root 4096 Aug 21 2009 grid
-rw-r--r-- 1 root root 1052897657 Oct 16 13:22 linux.x64_11gR2_grid.zip
[[email protected] grid]#
-
作為 grid 使用者登入系統，執行安裝程式。
- 日志
安裝過程中的日志生成位址：
/u01/app/oraInventory/logs/installActions2014-06-14_10-32-53PM.log
16.1. 檢查安裝腳本是否具有可執行權限
[[email protected] grid]$ id
uid=501(grid) gid=500(oinstall) groups=500(oinstall),501(dba),503(asmadmin),504(asmoper),505(asmdba)
[[email protected] grid]$ ll runInstaller
-rwxr-xr-x 1 root root 3227 Aug 15 2009 runInstaller
[[email protected] grid]$
如果無可執行權限，執行以下指令進行授權：
[[email protected] ~]# chown -R grid:oinstall /home/grid/grid/
[[email protected] ~]# ll /home/grid/grid/runInstaller
-rwxr-xr-x 1 grid oinstall 3227 Aug 15 2009 /home/grid/grid/runInstaller
[[email protected] ~]#
16.2. 執行安裝腳本 /home/grid/grid/runInstaller
首先打開Xmanager - Passive 軟體， 然後在 Xshell 會話設定如下：
[[email protected]_linux_asm grid]$ clear
[[email protected]_linux_asm grid]$ export DISPLAY=192.168.1.100:0.0 ---這裡的ip位址就是本機的ip位址(ipconfig)
[[email protected]_linux_asm grid]$ xhost +
access control disabled, clients can connect from any host
[[email protected]_linux_asm grid]$ ls
doc install response rpm runcluvfy.sh runInstaller sshsetup stage welcome.html
[[email protected]_linux_asm grid]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 31642 MB Passed
Checking swap space: must be greater than 150 MB. Actual 383 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-04-29_10-53-18PM. Please wait ...[[email protected]_linux_asm grid]$
截圖如下：
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 17. 安裝過程
[[email protected] ~]$ /home/grid/grid/runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 38826 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-10-17_03-31-41PM. Please wait ...[[email protected] ~]$
17.1.
17.2. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 17.3. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 17.4. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 17.5. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 17.6.
17.6.1. 檢查安裝條件
17.6.2. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 執行修複腳本：
[[email protected] ~]# /tmp/CVU_11.2.0.1.0_grid/runfixup.sh
Response file being used is :/tmp/CVU_11.2.0.1.0_grid/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.1.0_grid/fixup.enable
Log file location: /tmp/CVU_11.2.0.1.0_grid/orarun.log
Setting Kernel Parameters...
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
17.6.3. 安裝缺失軟體包
# yum install -y package_name
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 這些軟體包其實已安裝，隻不過因為 Oracle Linux 6.4 自帶的軟體包版本高于檢查版本，是以檢查不通過，忽略即可。
Oracle Linux 6.4 的安裝CD光牒中無 pdksh 軟體包，安裝 ksh 軟體包即可。
# yum install -y ksh
因為沒有 NTP 時鐘伺服器，是以 NTP 檢查不通過，忽略即可。
17.6.4.
17.7. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 17.8. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 17.9. 安裝時間較長，請耐心等待。 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 - 最後的執行腳本步驟
安裝過程中會彈出對話框，提示你以 root 身份執行兩個腳本：
[[email protected] ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[[email protected] ~]# /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]: -- 輸入回車
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user: -- 單執行個體安裝需執行以下腳本
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
To configure Grid Infrastructure for a Cluster perform the following steps:
1. Provide values for Grid Infrastructure configuration parameters in the file - /u01/app/11.2.0/grid/crs/install/crsconfig_params. For details on how to do this, see the installation guide.
2. Run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl
To update inventory properties for Grid Infrastructure, perform the following
steps. If a pre-11.2 home is already configured, execute the following:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=false ORACLE_HOME=pre-11.2_Home
Always execute the following to register the current home:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=true ORACLE_HOME=11.2_Home.
If either home is shared, provide the additional argument -cfs.
截圖如下：
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 下邊按照要求執行腳本：
[[email protected] ~]# /u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
2013-10-17 16:18:19: Checking for super user privileges
2013-10-17 16:18:19: User has super user privileges
2013-10-17 16:18:19: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
/u01/app/11.2.0/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory -- 報錯
Failed to create keys in the OLR, rc = 32512, 32512
OLR configuration failed
[[email protected] ~]#
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 解決報錯：
17.9.1. 檢查作業系統中 libcap.so 是否已安裝
如果是 64 位系統，i686 和 x86_64 都要安裝。
# yum install -y libcap*.i686
# yum install -y libcap*.x86_64
[[email protected] ~]# rpm -qa | grep libcap
libcap-ng-0.6.4-3.el6_0.1.i686
libcap-2.16-5.5.el6.x86_64
libcap-devel-2.16-5.5.el6.x86_64
libcap-devel-2.16-5.5.el6.i686
libcap-ng-0.6.4-3.el6_0.1.x86_64
libcap-2.16-5.5.el6.i686
libcap-ng-devel-0.6.4-3.el6_0.1.i686
libcap-ng-devel-0.6.4-3.el6_0.1.x86_64
[[email protected] ~]#
17.9.2. 檢查 libcap.so 檔案
[[email protected] ~]# ll /lib64/libcap.so*
lrwxrwxrwx 1 root root 11 Oct 17 16:28 /lib64/libcap.so -> libcap.so.2
lrwxrwxrwx. 1 root root 14 Oct 16 15:22 /lib64/libcap.so.2 -> libcap.so.2.16
-rwxr-xr-x 1 root root 19016 Oct 13 2011 /lib64/libcap.so.2.16
[[email protected] ~]#
17.9.3.
[[email protected] ~]# ln -s /lib64/libcap.so.2.16 /lib64/libcap.so.1
[[email protected] ~]#ln -s /lib64/libcap.so.2 /lib64/libcap.so
[[email protected] ~]# ll /lib64/libcap.so*
lrwxrwxrwx 1 root root 11 Oct 17 16:28 /lib64/libcap.so -> libcap.so.2
lrwxrwxrwx 1 root root 21 Oct 17 17:01 /lib64/libcap.so.1 -> /lib64/libcap.so.2.16
lrwxrwxrwx. 1 root root 14 Oct 16 15:22 /lib64/libcap.so.2 -> libcap.so.2.16
-rwxr-xr-x 1 root root 19016 Oct 13 2011 /lib64/libcap.so.2.16
[[email protected] ~]#
17.9.4. 重新執行 /u01/app/11.2.0/grid/root.sh 腳本
[[email protected] ~]# /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y -- 輸入 y 覆寫安裝
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y -- 輸入 y 覆寫安裝
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y -- 輸入 y 覆寫安裝
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
To configure Grid Infrastructure for a Cluster perform the following steps:
1. Provide values for Grid Infrastructure configuration parameters in the file - /u01/app/11.2.0/grid/crs/install/crsconfig_params. For details on how to do this, see the installation guide.
2. Run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl
To update inventory properties for Grid Infrastructure, perform the following
steps. If a pre-11.2 home is already configured, execute the following:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=false ORACLE_HOME=pre-11.2_Home
Always execute the following to register the current home:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=true ORACLE_HOME=11.2_Home.
If either home is shared, provide the additional argument -cfs.
[[email protected] ~]# /u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
2013-10-17 17:04:58: Checking for super user privileges
2013-10-17 17:04:58: User has super user privileges
2013-10-17 17:04:58: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Improper Oracle Clusterware configuration found on this host
Deconfigure the existing cluster configuration before starting -- 報錯
to configure a new Clusterware
run '/u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig'
to configure existing failed configuration and then rerun root.sh
17.9.5. 解決步驟 4) 中的錯誤
[[email protected] ~]# /u01/app/11.2.0/grid/crs/install/roothas.pl -verbose -delete -force
2013-10-17 18:25:15: Checking for super user privileges
2013-10-17 18:25:15: User has super user privileges
2013-10-17 18:25:15: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Delete failed, or completed with errors.
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
/u01/app/11.2.0/grid/bin/acfsdriverstate: line 51: /lib/acfstoolsdriver.sh: No such file or directory
/u01/app/11.2.0/grid/bin/acfsdriverstate: line 51: exec: /lib/acfstoolsdriver.sh: cannot execute: No such file or directory
Successfully deconfigured Oracle Restart stack
[[email protected] ~]#
17.9.6. 重新執行 /u01/app/11.2.0/grid/root.sh 腳本
[[email protected] ~]# /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
To configure Grid Infrastructure for a Cluster perform the following steps:
1. Provide values for Grid Infrastructure configuration parameters in the file - /u01/app/11.2.0/grid/crs/install/crsconfig_params. For details on how to do this, see the installation guide.
2. Run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl
To update inventory properties for Grid Infrastructure, perform the following
steps. If a pre-11.2 home is already configured, execute the following:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=false ORACLE_HOME=pre-11.2_Home
Always execute the following to register the current home:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=true ORACLE_HOME=11.2_Home.
If either home is shared, provide the additional argument -cfs.
[[email protected] ~]# /u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
2013-10-17 18:27:55: Checking for super user privileges
2013-10-17 18:27:55: User has super user privileges
2013-10-17 18:27:55: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
CRS-4664: Node localhost successfully pinned.
Adding daemon to inittab
CRS-4124: Oracle High Availability Services startup failed. -- 報錯
CRS-4000: Command Start failed, or completed with errors.
ohasd failed to start: Inappropriate ioctl for device
ohasd failed to start: Inappropriate ioctl for device at /u01/app/11.2.0/grid/crs/install/roothas.pl line 296.
[[email protected] ~]#
這是 11.0.2.1 的一個 BUG，如果安裝11.2.0.3的話就不存在這個問題
17.9.7. 解決 BUG
17.9.7.1. 復原 /u01/app/11.2.0/grid/root.sh 産生的操作
[[email protected] ~]# /u01/app/11.2.0/grid/crs/install/roothas.pl -verbose -delete -force
2013-10-17 18:45:42: Checking for super user privileges
2013-10-17 18:45:42: User has super user privileges
2013-10-17 18:45:42: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Delete failed, or completed with errors.
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
/u01/app/11.2.0/grid/bin/acfsdriverstate: line 51: /lib/acfstoolsdriver.sh: No such file or directory
/u01/app/11.2.0/grid/bin/acfsdriverstate: line 51: exec: /lib/acfstoolsdriver.sh: cannot execute: No such file or directory
Successfully deconfigured Oracle Restart stack
[[email protected] ~]#
17.9.7.2. 在執行 root.sh 腳本出現 Adding daemon to inittab 時，以 root 身份立即執行下面的指令：
# /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/nullbs=1024 count=1
如果出現 /bin/dd: opening `/var/tmp/.oracle/npohasd': No such file or directory，說明檔案還沒有生成，繼續執行，直到能執行為止。
同時開兩個 SSH 會話進行下面兩步操作
[[email protected] ~]# /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/nullbs=1024 count=1
/bin/dd: opening `/var/tmp/.oracle/npohasd': No such file or directory
[[email protected] ~]# /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/nullbs=1024 count=1
[[email protected] ~]# /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
To configure Grid Infrastructure for a Cluster perform the following steps:
1. Provide values for Grid Infrastructure configuration parameters in the file - /u01/app/11.2.0/grid/crs/install/crsconfig_params. For details on how to do this, see the installation guide.
2. Run the following command as the root user:
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl
To update inventory properties for Grid Infrastructure, perform the following
steps. If a pre-11.2 home is already configured, execute the following:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=false ORACLE_HOME=pre-11.2_Home
Always execute the following to register the current home:
11.2_Home/oui/bin/runInstaller -updateNodeList -silent -local CRS=true ORACLE_HOME=11.2_Home.
If either home is shared, provide the additional argument -cfs.
[[email protected] ~]# /u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/roothas.pl
2013-10-17 18:55:45: Checking for super user privileges
2013-10-17 18:55:45: User has super user privileges
2013-10-17 18:55:45: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
CRS-4664: Node localhost successfully pinned.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
ADVM/ACFS is not supported on redhat-release-server-6Server-6.4.0.4.0.1.el6.x86_64
localhost 2013/10/17 18:56:11 /u01/app/11.2.0/grid/cdata/localhost/backup_20131017_185611.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[[email protected] ~]#
17.10. 結束 Grid 安裝
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 - 11.2.0.3.0 root腳本
新版本就不會報錯的
[[email protected]_lhr oraInventory]# /u01/app/grid/11.2.0/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/grid/11.2.0
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/grid/11.2.0/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node rhel6_lhr successfully pinned.
Adding Clusterware entries to upstart
rhel6_lhr 2014/06/14 22:42:26 /u01/app/grid/11.2.0/cdata/rhel6_lhr/backup_20140614_224226.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
-
利用asmca建立磁盤組
[[email protected]_lhr ~]$ export DISPLAY=192.168.1.100:0.0
[[email protected]_lhr ~]$ xhost +
以 grid 使用者執行 asmca 指令
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 這裡利用asmca建立磁盤組的時候需要ASM執行個體啟動才能配置，我們點選yes後報錯： 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 檢視日志來解決，或者利用指令行來啟動asm執行個體：
18.1.
SYS Password -- sys
ASMSNMP Password -- asmsnmp
18.2. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 Step 1. 給磁盤組命名
Step 2. 選擇備援方式
High: 為每個配置設定單元建立三個副本（是以至少需要三個磁盤）
Normal: 單鏡像（預設）
External: 不會鏡像，假定底層存在一個 LVM 并且它正在執行認為适當的任何一種 RAID 級别。
Step 3. 添加磁盤挂載位置
Step 4. 輸入磁盤挂載位置和名稱
18.3.
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 這裡我隻建立了兩個磁盤，一個磁盤組，沒有建立 FRA 區域。如果你建立了 3 個或者 3 個以上磁盤，可以留一部分給後面的 FRA 使用（什麼是FRA? 就是閃回區）。
18.4. 點選 Create ASM 建立 Disk Group
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 如果點選yes後報如下的錯誤，則說明前邊的Oracle Grid Infrastructure沒有配置好，需要重新配置： 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 配置好Oracle Grid Infrastructure 後，重新點選 Create ASM 建立 Disk Group 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 稍等一會後(其實大約需要1分鐘吧)： 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 18.5. Disk Group 建立完成，退出。 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
使用netmgr建立監聽
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
通過 grid 使用者執行 crs_stat -t 檢查 ASM 是否安裝好，如下所示表示搭建 OK。
[[email protected]st ~]$ crs_stat -t
Name Type Target State Host
------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE localhost
ora.asm ora.asm.type ONLINE ONLINE localhost
ora.cssd ora.cssd.type ONLINE ONLINE localhost
ora.diskmon ora....on.type ONLINE ONLINE localhost
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 [[email protected] ~]$
[[email protected]_linux_asm ~]$ echo $ORACLE_SID
+ASM
[[email protected]_linux_asm ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 28 23:07:24 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> select name,total_mb from v$asm_diskgroup;
NAME TOTAL_MB
------------------------------ ----------
DATA 20480
SQL> select name,group_number,file_number,alias_index,alias_directory,system_created from v$asm_alias;
-
開始搭建 Oracle 資料庫
如果系統之前搭建過ORACLE資料庫的話就可以不用再搭建資料庫了，隻需要重新建立一個執行個體即可。。。。。
20.1. 作為 oracle 使用者登入系統，将安裝包上傳到 Oracle 家目錄。
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.2. 解壓兩個壓縮包
[[email protected] ~]$ ll linux*
-rw-r--r-- 1 oracle oinstall 1239269270 Apr 18 20:44 linux.x64_11gR2_database_1of2.zip
-rw-r--r-- 1 oracle oinstall 1111416131 Apr 18 20:47 linux.x64_11gR2_database_2of2.zip
[[email protected] ~]$ unzip linux.x64_11gR2_database_1of2.zip && unzip linux.x64_11gR2_database_2of2.zip
20.3. 執行 runInstaller
[[email protected] ~]$ /home/oracle/database/runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 30971 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4088 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-10-17_08-01-38PM. Please wait ...[[email protected] ~]$
20.4.
20.5. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.6. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.7.
這裡選擇字元集的時候最好把簡體中文安裝上，不然後邊安裝OEM後，網頁浏覽可能出現會亂碼
20.8. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.9. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.10. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.11. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.12. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 20.13. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 安裝時間較長，請耐心等待。 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 安裝快結束時，會彈出視窗，提示你以 root 身份執行一個腳本。 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 [[email protected] ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[[email protected] ~]#
20.14. 結束安裝
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
檢查 $ORACLE_HOME/bin/oracle檔案的所屬組
這一步不是必須的，如果在後邊使用dbca建立資料庫的時候選不到磁盤組的時候就傳回來做這一步吧。。。
在RAC或者ORACLE RESTART中，oracle可執行檔案的所屬組是asmadmin。
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 [[email protected] bin]# chown oracle:asmadmin oracle
[[email protected] bin]# ls -l oracle
-rwxr-x--x 1 oracle asmadmin 232399473 Apr 19 07:04 oracle
[[email protected] bin]# chmod +s oracle
[[email protected] bin]# ls -l oracle
-rwsr-s--x 1 oracle asmadmin 232399473 Apr 19 07:04 oracle
-
使用 netmgr 建立監聽--Oracle使用者不需要建立
需配置好環境變量，否則會出現找不到指令的情況。
該步驟即建立監聽檔案，也可以從其它地方拷貝過來，或者自己建立檔案：/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
[[email protected]_linux_asm grid]$ netmgr
21.1.
21.2. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 21.3. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 21.4. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 21.5. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 21.6.
點選 File --> Save Network Configuration
然後退出，執行完後在以下路徑有檔案：
[[email protected]_linux_asm admin]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[[email protected]_linux_asm admin]$ ll
total 8
drwxr-xr-x. 2 oracle dba 4096 Apr 28 23:24 samples
-rw-r--r--. 1 oracle dba 187 May 7 2007 shrept.lst
[[email protected]_linux_asm admin]$ netmgr
[[email protected]_linux_asm admin]$ ll
total 12
-rw-r--r--. 1 oracle dba 475 Apr 28 23:47 listener.ora
drwxr-xr-x. 2 oracle dba 4096 Apr 28 23:24 samples
-rw-r--r--. 1 oracle dba 187 May 7 2007 shrept.lst
[[email protected]_linux_asm admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orclasm)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orclasm)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel_linux_asm)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/oracle
-
使用 dbca 建立資料庫
27.2. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.3. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.4. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.5. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.6. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.7. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.8.
這裡如果啟用閃回區和歸檔的話，就選擇fra磁盤組，不啟用的話可以不選擇
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.9. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.10. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.11. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.12. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 27.13. 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 安裝過程中可以檢視日志：
[[email protected]_linux_asm ~]# cd /u01/app/grid/cfgtoollogs/dbca/oralasm2/
[[email protected]_linux_asm oralasm2]# tail -f trace.log
。。。。。。。
Datafile
'+DATA/oralasm2/datafile/system.256.845998107',
'+DATA/oralasm2/datafile/sysaux.257.845998109',
'+DATA/oralasm2/datafile/undotbs1.258.845998109',
'+DATA/oralasm2/datafile/users.259.845998109'
[Thread-151] [ 2014-04-27 15:29:49.328 CST ] [CloneDBCreationStep.executeImpl:419] Length of OriginalRedoLogsGrNames=3
[Thread-151] [ 2014-04-27 15:29:49.330 CST ] [CloneDBCreationStep.executeImpl:427] 0th redoLogText = GROUP 1 SIZE 51200K
[Thread-151] [ 2014-04-27 15:29:49.331 CST ] [CloneDBCreationStep.executeImpl:427] 1th redoLogText = GROUP 2 SIZE 51200K
[Thread-151] [ 2014-04-27 15:29:49.331 CST ] [CloneDBCreationStep.executeImpl:427] 2th redoLogText = GROUP 3 SIZE 51200K
[Thread-151] [ 2014-04-27 15:29:49.332 CST ] [CloneDBCreationStep.executeImpl:448] createCTLSql=Create controlfile reuse set database "oralasm2"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'+DATA/oralasm2/datafile/system.256.845998107',
'+DATA/oralasm2/datafile/sysaux.257.845998109',
'+DATA/oralasm2/datafile/undotbs1.258.845998109',
'+DATA/oralasm2/datafile/users.259.845998109'
LOGFILE GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
GROUP 3 SIZE 51200K RESETLOGS;
[Thread-151] [ 2014-04-27 15:29:55.330 CST ] [CloneDBCreationStep.executeImpl:460] calling zerodbid
[Thread-151] [ 2014-04-27 15:30:02.332 CST ] [CloneDBCreationStep.executeImpl:470] Shutdown database
[Thread-151] [ 2014-04-27 15:30:02.334 CST ] [CloneDBCreationStep.executeImpl:492] Startup ......nomount......
[Thread-151] [ 2014-04-27 15:30:04.131 CST ] [CloneDBCreationStep.executeImpl:500] deleting dummy control file from v$controlfile: +DATA/oralasm2/controlfile/current.260.845998195
[Thread-151] [ 2014-04-27 15:30:08.881 CST ] [CloneDBCreationStep.executeImpl:511] Enabling restricted session.
[Thread-151] [ 2014-04-27 15:30:11.028 CST ] [CloneDBCreationStep.executeImpl:513] alter database "oralasm2" open resetlogs;
[Thread-151] [ 2014-04-27 15:30:29.193 CST ] [CloneDBCreationStep.executeImpl:521] Removing existing services from sourcedb seeddata
[Thread-151] [ 2014-04-27 15:30:30.025 CST ] [CloneDBCreationStep.executeImpl:526] Renaming globale_name
[Thread-151] [ 2014-04-27 15:30:30.163 CST ] [CloneDBCreationStep.executeImpl:542] control file from v$controlfile: +DATA/oralasm2/controlfile/current.260.845998209
[Thread-151] [ 2014-04-27 15:30:30.164 CST ] [CloneDBCreationStep.executeImpl:557] controlfiles("+DATA/oralasm2/controlfile/current.260.845998209")
[Thread-151] [ 2014-04-27 15:30:30.186 CST ] [CloneDBCreationStep.executeImpl:601] Temp file to be added:=+DATA/{DB_UNIQUE_NAME}/temp01.dbf
[Thread-151] [ 2014-04-27 15:30:30.187 CST ] [CloneDBCreationStep.executeImpl:602] Temp file size in KB:=20480
[Thread-151] [ 2014-04-27 15:30:31.603 CST ] [CloneDBCreationStep.executeImpl:632] Establish USERS as the default permanent tablespace of the database
[Thread-151] [ 2014-04-27 15:30:31.704 CST ] [TemplateManager.isInstallTemplate:2300] Selected Template by user:=General Purpose
[Thread-151] [ 2014-04-27 15:30:31.704 CST ] [TemplateManager.isInstallTemplate:2307] The Message Id to be searched:=GENERAL_PURPOSE
。。。。。。。。。
27.14.
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 -
- 至此，基于 ASM 的 Oracle Database 11g 環境搭建完畢。
-
關閉防火牆--不然用戶端可能連接配接不上
service iptables stop
[[email protected]_lhr ~]# service iptables stop
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Flushing firewall rules: [ OK ]
iptables: Unloading modules: [ OK ]
[[email protected]_lhr ~]#
-
是否有tnsnames.ora 生成
檢查 /u01/app/oracle/product/11.2.0/dbhome_1/network/ 下是否有 tnsnames.ora,如果沒有就生成以為檔案吧：
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
orclasm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.134)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclasm)
)
)
-
配置ORACLE自動啟動
-
編輯/etc/oratab
[[email protected] ~]$ vi /etc/oratab
orcl:/u01/app/oracle/product/11.2.0/db_1:Y
-
ROOT使用者建立/etc/init.d/dbora
[[email protected] ~]# cat /etc/init.d/dbora
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
#ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
#ORA_HOME=/u01/app/oracle/product/11.1.0/db_1
ORA_HOME=/u01/app/oracle/product/11.2.0/db_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
touch /var/lock/subsys/dbora
;;
'stop')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
rm -f /var/lock/subsys/dbora
;;
esac
-
加入啟動項
[[email protected] ~]# chmod 750 /etc/init.d/dbora
[[email protected] ~]# chkconfig --add dbora
-
驗證
[[email protected] ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 17 21:37:22 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> select * from v$version;
BANNER
--------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------
+DATA/orcl/datafile/users.259.829084507
+DATA/orcl/datafile/undotbs1.258.829084505
+DATA/orcl/datafile/sysaux.257.829084505
+DATA/orcl/datafile/system.256.829084505
+DATA/orcl/datafile/example.265.829084649
SQL>select name,total_mb,state from v$asm_diskgroup;
select name,group_number,file_number,alias_index,alias_directory,system_created from v$asm_alias;
# su – grid$ crsctl check has$ crsctl check css$ crsctl check evm$ crs_stat –t –v$ ocrcheck
# su – oracle$ sqlplus / as sysdbaSQL> select name from v$datafile 2 union all 3 select name from v$controlfile 4 union all 5 select member from v$logfile;
檢查高可用性伺服器的狀态[[email protected] ~]$ crsctl check hasCRS-4638: Oracle High Availability Services is online[[email protected] ~]$ crsctl check cssCRS-4529: Cluster Synchronization Services is online[[email protected] ~]$ crsctl check evmCRS-4533: Event Manager is online
[[email protected] ~]$ crs_stat -tName Type Target State Host ————————————————————ora.CRS.dg ora….up.type ONLINE ONLINE restart ora….ER.lsnr ora….er.type ONLINE ONLINE restart ora.asm ora.asm.type ONLINE ONLINE restart ora.cssd ora.cssd.type ONLINE ONLINE restart ora.diskmon ora….on.type OFFLINE OFFLINE ora.evmd ora.evm.type ONLINE ONLINE restart ora.ons ora.ons.type OFFLINE OFFLINE
[[email protected] ~]$ ps -ef | grep asmgrid 16058 1 0 19:56 ? 00:00:00 asm_pmon_+ASMgrid 16060 1 0 19:56 ? 00:00:00 asm_psp0_+ASMgrid 16062 1 0 19:56 ? 00:00:00 asm_vktm_+ASMgrid 16066 1 0 19:56 ? 00:00:00 asm_gen0_+ASMgrid 16068 1 0 19:56 ? 00:00:00 asm_diag_+ASMgrid 16070 1 0 19:56 ? 00:00:00 asm_dia0_+ASMgrid 16072 1 0 19:56 ? 00:00:00 asm_mman_+ASMgrid 16074 1 0 19:56 ? 00:00:00 asm_dbw0_+ASMgrid 16076 1 0 19:56 ? 00:00:00 asm_lgwr_+ASMgrid 16078 1 0 19:56 ? 00:00:00 asm_ckpt_+ASMgrid 16080 1 0 19:56 ? 00:00:00 asm_smon_+ASMgrid 16082 1 0 19:56 ? 00:00:00 asm_rbal_+ASMgrid 16084 1 0 19:56 ? 00:00:00 asm_gmon_+ASMgrid 16086 1 0 19:56 ? 00:00:00 asm_mmon_+ASMgrid 16088 1 0 19:56 ? 00:00:00 asm_mmnl_+ASMgrid 16188 16152 0 19:59 pts/1 00:00:00 grep asm
# cat /etc/oracle/ocr.lococrconfig_loc=/u01/app/11.2.0/grid/cdata/localhost/local.ocrlocal_only=TRUE
# /u01/app/11.2.0/grid/bin/ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 152 Available space (kbytes) : 261968 ID : 1179492779 Device/File Name : /u01/app/11.2.0/grid/cdata/localhost/local.ocr Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
[[email protected] ~]$ crs_stat -t -vName Type R/RA F/FT Target State Host ———————————————————————-ora.ARCH.dg ora….up.type 0/5 0/ ONLINE ONLINE restart ora.CRS.dg ora….up.type 0/5 0/ ONLINE ONLINE restart ora.DATA.dg ora….up.type 0/5 0/ ONLINE ONLINE restart ora….ER.lsnr ora….er.type 0/5 0/ ONLINE ONLINE restart ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE restart ora.cssd ora.cssd.type 0/5 0/5 ONLINE ONLINE restart ora.diskmon ora….on.type 0/10 0/5 OFFLINE OFFLINE ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE restart ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE ora.restart.db ora….se.type 0/2 0/1 ONLINE ONLINE restart
SQL> select name from v$datafile 2 union all 3 select name from v$controlfile 4 union all 5 select member from v$logfile;
NAME——————————————————————————–+DATA/restart/datafile/system.260.790288571+DATA/restart/datafile/sysaux.261.790288633+DATA/restart/datafile/undotbs1.262.790288683+DATA/restart/datafile/users.264.790288715+DATA/restart/controlfile/current.256.790288547+DATA/restart/onlinelog/group_1.257.790288549+DATA/restart/onlinelog/group_2.258.790288555+DATA/restart/onlinelog/group_3.259.790288561
8 rows selected.
SQL>SQL> archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/archOldest online log sequence 36Current log sequence 38
不是歸檔模式運作，現在手動開啟
SQL> create pfile='/u01/pfile-0802.bak' from spfile;
File created.
SQL> alter system set log_archive_dest_1='LOCATION=+ARCH';
System altered.
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.
SQL> startup mountORACLE instance started.
Total System Global Area 839282688 bytesFixed Size 2233000 bytesVariable Size 528485720 bytesDatabase Buffers 306184192 bytesRedo Buffers 2379776 bytesDatabase mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination +ARCHOldest online log sequence 36Next log sequence to archive 38Current log sequence 38
SQL> select name from v$archived_log;
no rows selected
SQL> alter system switch logfile;
System altered.
SQL> select name from v$archived_log;
NAME——————————————————————————–+ARCH/restart/archivelog/2012_08_02/thread_1_seq_38.256.790292467
以監聽為例用srvctl 關閉啟動測試：[[email protected] ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): restart[[email protected] ~]$ srvctl stop listener[[email protected] ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is not running
[[email protected] ~]$ srvctl start listener[[email protected] ~]$ crs_stat -t -vName Type R/RA F/FT Target State Host ———————————————————————-ora.ARCH.dg ora….up.type 0/5 0/ ONLINE ONLINE restart ora.CRS.dg ora….up.type 0/5 0/ ONLINE ONLINE restart ora.DATA.dg ora….up.type 0/5 0/ ONLINE ONLINE restart ora….ER.lsnr ora….er.type 0/5 0/ ONLINE ONLINE restart ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE restart ora.cssd ora.cssd.type 0/5 0/5 ONLINE ONLINE restart ora.diskmon ora….on.type 0/10 0/5 OFFLINE OFFLINE ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE restart ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE ora.restart.db ora….se.type 0/2 0/1 ONLINE ONLINE restart
再測試kill監聽程序，看能否自動起來。
[[email protected] ~]$ ps -ef | grep lsnrgrid 28139 1 0 21:43 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inheritgrid 28325 28251 0 21:46 pts/1 00:00:00 grep lsnr
[[email protected] ~]$ kill -9 28139
過幾秒鐘後他就起來，因為這中間有監控程序的時間段
[[email protected] ~]$ ps -ef | grep lsnrgrid 28455 1 0 21:47 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inheritgrid 28469 28251 0 21:47 pts/1 00:00:00 grep lsnr
好，最後測試硬性重新開機之後看ORACLE能不能自動起來# reboot
系統起來稍等之後：[[email protected] bin]# ./crs_stat -tName Type Target State Host ————————————————————ora.ARCH.dg ora….up.type ONLINE ONLINE restart ora.CRS.dg ora….up.type ONLINE ONLINE restart ora.DATA.dg ora….up.type ONLINE ONLINE restart ora….ER.lsnr ora….er.type ONLINE ONLINE restart ora.asm ora.asm.type ONLINE ONLINE restart ora.cssd ora.cssd.type ONLINE ONLINE restart ora.diskmon ora….on.type OFFLINE OFFLINE ora.evmd ora.evm.type ONLINE ONLINE restart ora.ons ora.ons.type OFFLINE OFFLINE ora.restart.db ora….se.type ONLINE ONLINE restart
-
啟動crs
[[email protected] install]# /u01/app/grid/11.2.0/crs/install/roothas.pl -deconfig -force -verbose
[[email protected] grid]#/u01/app/grid/11.2.0/root.sh
----同時執行
/u01/app/grid/11.2.0/perl/bin/perl -I/u01/app/grid/11.2.0/perl/lib -I/u01/app/grid/11.2.0/crs/install /u01/app/grid/11.2.0/crs/install/roothas.pl
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
---grid使用者下啟動
crs_start -all
crs_start -t
crsctl check css
crsctl check has
-
一些報錯解決方案：
-
Oracle 11gR2 RAC ohasd failed to start 解決方法
-
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
ohasd failed to start: Inappropriate ioctl for device
ohasd failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443.
第一次安裝11gR2 RAC的時候就遇到了這個11.0.2.1的經典問題，上網一查才知道這是個bug，解決辦法也很簡單，
就是在執行root.sh之前執行以下指令
/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
如果出現
/bin/dd: opening`/var/tmp/.oracle/npohasd': No such file or directory
的時候檔案還沒生成就繼續執行，直到能執行為止，一般出現Adding daemon to inittab這條資訊的時候執行dd指令。
另外還有一種解決方法就是更改檔案權限
chown root:oinstall /var/tmp/.oracle/npohasd
重新執行root.sh之前别忘了删除配置：/u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force-verbose
-
CRS-4639: Could not contact Oracle High Availability Services
在啟動asm執行個體的時候報如下錯誤：
[[email protected] ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 12 18:14:13 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startupORA-01078: failure in processing system parametersORA-29701: unable to connect to Cluster Synchronization Service
然後用crsctl check css檢查的時候報如下錯誤：
[[email protected] ~]$ crsctl check cssCRS-4639: Could not contact Oracle High Availability ServicesCRS-4000: Command Check failed, or completed with errors.
解決CRS-4639: Could not contact Oracle High Availability Services過程如下：
[[email protected] grid]# cd /u01/app/11.2.0/grid/crs/install[[email protected] install]# ./roothas.pl -deconfig -force -verbose2013-09-12 19:25:05: Checking for super user privileges2013-09-12 19:25:05: User has super user privileges2013-09-12 19:25:05: Parsing the host nameUsing configuration parameter file: ./crsconfig_paramsCRS-4639: Could not contact Oracle High Availability ServicesCRS-4000: Command Stop failed, or completed with errors.CRS-4639: Could not contact Oracle High Availability ServicesCRS-4000: Command Delete failed, or completed with errors.Failure at scls_scr_getval with code 1Internal Error Information: Category: -2 Operation: opendir Location: scrsearch1 Other: cant open scr home dir scls_scr_getval System Dependent Information: 2
CRS-4544: Unable to connect to OHASCRS-4000: Command Stop failed, or completed with errors.ACFS-9200: SupportedSuccessfully deconfigured Oracle Restart stack
[[email protected] install]# cd /u01/app/11.2.0/grid/[[email protected] grid]# ./root.shRunning Oracle 11g root.sh script...
The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ...The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ...The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.2013-09-12 19:27:31: Checking for super user privileges2013-09-12 19:27:31: User has super user privileges2013-09-12 19:27:31: Parsing the host nameUsing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsLOCAL ADD MODE Creating OCR keys for user 'grid', privgrp 'oinstall'..Operation successful.CRS-4664: Node b1 successfully pinned.Adding daemon to inittabCRS-4123: Oracle High Availability Services has been started.ohasd is starting
b1 2013/09/12 19:29:12 /u01/app/11.2.0/grid/cdata/b1/backup_20130912_192912.olrSuccessfully configured Oracle Grid Infrastructure for a Standalone ServerUpdating inventory properties for clusterwareStarting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 4094 MB PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /u01/app/oraInventory'UpdateNodeList' was successful.
[[email protected] ~]$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora.cssd ora.cssd.type OFFLINE OFFLINE ora.diskmon ora....on.type OFFLINE OFFLINE [[email protected] ~]$ crs_start -allAttempting to start `ora.diskmon` on member `b1`Attempting to start `ora.cssd` on member `b1`Start of `ora.diskmon` on member `b1` succeeded.Start of `ora.cssd` on member `b1` succeeded.
[[email protected] ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 12 19:34:50 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startupASM instance started
Total System Global Area 283930624 bytesFixed Size 2212656 bytesVariable Size 256552144 bytesASM Cache 25165824 bytesASM diskgroups mountedASM diskgroups volume enabled
-
ORA-29701: unable to connect to Cluster Synchronization Service
-
asm 執行個體無法加載diskgroups，ORA-15110: no diskgroups mounted
今天安裝oracle11g R2的grid，裝完之後發現無法加載diskgroups，報錯如下：
SQL> startupORA-00099: warning: no parameter file specified for ASM instanceASM instance started
Total System Global Area 283930624 bytesFixed Size 2225792 bytesVariable Size 256539008 bytesASM Cache 25165824 bytesORA-15110: no diskgroups mounted
(1)分析認為是由于ORA-00099引起，無法找到diskgroup。
（2）在網上搜尋得到asm參數檔案的配置格式如下：
asm_diskstring='/dev/oracleasm/disks/DISK*'
asm_diskgroups='DATA'asm_power_limit=1diagnostic_dest='/opt/oracle'instance_type='asm'large_pool_size=12Mremote_login_passwordfile='EXCLUSIVE'
生成檔案：$ORACLE_HOME/dbs/init+ASM.ora
注意asm_diskstring中必須包含"*"才能正确加載，否則報下面錯誤
SQL> startupASM instance started
Total System Global Area 283930624 bytesFixed Size 2225792 bytesVariable Size 256539008 bytesASM Cache 25165824 bytesORA-15032: not all alterations performedORA-15017: diskgroup "DATA" cannot be mountedORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
（3）儲存設定到spfile
SQL> create spfile from pfile;create spfile from pfile*ERROR at line 1:ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]lsts[0]]
産生這個問題的原因為ORACLE認為ASM執行個體是手工建立的，并沒有注冊這個資源,那麼首先增加ASM資源
需要使用下面指令注冊asm，在grid使用者下執行：
srvctl add asm -l LISTENER -d '/dev/oracleasm/disks/DISK*'
然後重新執行指令：
SQL> create spfile from pfile;
File created.
（4）關閉asm執行個體後重新啟動，成功加載：
SQL> startupASM instance started
Total System Global Area 283930624 bytesFixed Size 2225792 bytesVariable Size 256539008 bytesASM Cache 25165824 bytesASM diskgroups mountedASM diskgroups volume enabled
-
在啟動DB時報錯ORA-27154 ORA-27300 ORA-27301 ORA-27302
在啟動DB時報錯ORA-27154 ORA-27300 ORA-27301 ORA-27302
這個錯誤是核心參數設定的問題，測試過程如下。[[email protected] ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.5.0 - Production on Sat Feb 4 23:47:02 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startupORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on deviceORA-27302: failure occurred at: sskgpsemsperSQL>
[[email protected] ~]# /sbin/sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 2net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 4294967295kernel.shmall = 268435456fs.aio-max-nr = 1048576fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586kernel.sem = 25032000100128注意上面的最後一個參數kernel.sem = 25032000100128這個值看似很正常的，實際上是有問題的，我測試了修改為下面正常的值後OK，它值與值之間有空格标記的[[email protected] ~]# vi /etc/sysctl.conf[[email protected] ~]# /sbin/sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 2net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1kernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 4294967295kernel.shmall = 268435456fs.aio-max-nr = 1048576fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586kernel.sem = 250 32000 100 128[[email protected] ~]#來看下是否可以正常啟動資料庫了。[[email protected] ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.5.0 - Production on Sun Feb 5 00:00:39 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 167772160 bytesFixed Size 1272600 bytesVariable Size 62915816 bytesDatabase Buffers 100663296 bytesRedo Buffers 2920448 bytesDatabase mounted.Database opened.SQL>
-
ORA-29786: SIHA attribute GET failed
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE
ORA-29786: SIHA attribute GET failed with error [Attribute 'ASM_DISKSTRING' sts[200] lsts[0]]
如果使用asmca建立的asm執行個體，asm會自動注冊到crs,手動建立asm執行個體需要注冊
[10:18:03 oracle(grid)@test ~]$ sql
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 10:18:04 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
10:18:05 idle> show parameter name
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_unique_name string +ASM
instance_name string +ASM
lock_name_space string
service_names string +ASM
10:18:14 idle> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200] lsts[0]]
Elapsed: 00:00:00.17
10:19:06 idle> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[10:19:12 oracle(grid)@test ~]$ srvctl add asm -l LISTENER -p /oracle/product/11.2.0/grid/dbs/init+ASM.ora -d 'ASMDISK*'
PRCR-1001 : Resource ora.LISTENER.lsnr does not exist
[10:20:19 oracle(grid)@rmdgl ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.cssd ora.cssd.type ONLINE ONLINE rmdgl
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE rmdgl
ora.ons ora.ons.type OFFLINE OFFLINE
[10:20:35 oracle(grid)@test~]$ srvctl add asm -p /u01/app/11.2.0/grid/dbs/spfile+ASM.ora -d 'ASMDISK*'
[10:20:56 oracle(grid)@rmdgl ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.asm ora.asm.type OFFLINE OFFLINE
ora.cssd ora.cssd.type ONLINE ONLINE rmdgl
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE rmdgl
ora.ons ora.ons.type OFFLINE OFFLINE
[10:20:58 oracle(grid)@test ~]$ cd /u01/app/11.2.0/grid/dbs/
[10:21:21 oracle(grid)@test dbs]$ ll
total 20
-rw-rw---- 1 oracle oinstall 1257 Sep 5 02:34 ab_+ASM.dat
-rw-rw---- 1 oracle oinstall 1544 Sep 5 02:34 hc_+ASM.dat
-rw-r----- 1 oracle oinstall 169 Aug 30 13:49 init+ASM.ora
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 oracle oinstall 2560 Aug 30 13:50 orapw+ASM
[10:21:22 oracle(grid)@test dbs]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.asm ora.asm.type OFFLINE OFFLINE
ora.cssd ora.cssd.type ONLINE ONLINE rmdgl
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE rmdgl
ora.ons ora.ons.type OFFLINE OFFLINE
[10:21:40 oracle(grid)@rmdgl dbs]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.asm ora.asm.type OFFLINE OFFLINE
ora.cssd ora.cssd.type ONLINE ONLINE rmdgl
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE rmdgl
ora.ons ora.ons.type OFFLINE OFFLINE
[10:23:16 oracle(grid)@rmdgl dbs]$ srvctl start asm
[10:23:20 oracle(grid)@rmdgl dbs]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.asm ora.asm.type ONLINE ONLINE rmdgl
ora.cssd ora.cssd.type ONLINE ONLINE rmdgl
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE rmdgl
ora.ons ora.ons.type OFFLINE OFFLINE
[11:13:50 oracle(grid)@test dbs]$ sql
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 11:14:39 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
11:14:39 idle> create spfile from pfile;
File created.
Elapsed: 00:00:00.24
Elapsed: 00:00:00.26
-
11gR2手動建立ASM執行個體ORA-29786錯誤解決方法
從11gR2開始，使用圖形化方式安裝Grid Infrastructure和使用ASMCA工具建立ASM執行個體都強制使用磁盤組作為ASM執行個體參數檔案的存儲方式。如果想将ASM參數檔案存放到本地磁盤檔案系統中，隻能手動建立ASM執行個體。手動建立ASM執行個體，在執行CRETAE SPFILE FROM PFILE将PFILE轉換成SPFILE的時候收到如下報錯：SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]下面是METALINK的解決方案：ORA-29786: SIHA attribute GET failed with Error If 11gR2 ASM instance is created manually [ID 976075.1] 修改時間:2011-8-11
類型:PROBLEM 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 狀态:PUBLISHED 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 優先級:3
In this Document Symptoms Changes Cause Solution
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 Symptoms
After creating an initial parameter file init+ASM.ora manually and starting an ASM instance, certain ASM commands fails with ORA-29786 in sqlplus:
sqlplus / as sysasmSQL> create spfile='$ORACLE_HOME/spfile+ASM.ora' from pfile='$ORACLE_HOME/dbs/init+ASM.ora';create spfile='$ORACLE_HOME/spfile+ASM.ora' from pfile='$ORACLE_HOME/dbs/init+ASM.ora'*ERROR at line 1:ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]lsts[0]]
SQL> create diskgroup dg1 normal redundancy disk '/opt/oracle/oradata/nobilldb/DG1_dev0' disk '/opt/oracle/oradata/nobilldb/DG1_dev1';Diskgroup created.SQL> drop diskgroup dg1;drop diskgroup dg1*ERROR at line 1:ORA-15039: diskgroup not droppedORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]lsts[0]]
Better option to create ASM instance is to run asmca in GUI/Silent mode.
Changes
Starting with 11gR2, ASM instance is a resoure in CRS repository also in single instance installations. Hence, it must be registered to OCR before doing certain operations like create/drop diskgroup, create pfile/spfile, etc.
Cause
ASM instance is created and started manually but it is not registered to cluster repository.
Solution
If ASM instance is created manually, add ASM instance to CRS repository with srvctl add asm:
srvctl add asm -l LISTENER -p /oracle/product/11.2.0/grid/dbs/init+ASM.ora -d '/dev/sdc*'srvctl add asm -h -- will give the options
根據文章提示，執行以下指令：# pwd
/u01/app/11.2.0/grid/bin
# ./srvctl add asm -h
Adds an ASM configuration to be managed by Oracle Restart.
Usage: srvctl add asm [-l ] [-p ] [-d ]
-l Listener name
-p Server parameter file path
-d ASM diskgroup discovery string
-h Print usage
# su - grid $ ./srvctl add asm -l LISTENER -p /u01/app/11.2.0/grid/dbs/spfile+ASM.ora -d '/dev/rhdisk*'
注意：以上的srvctl add asm指令必須用grid使用者執行，不能用root使用者執行，詳情參考文章《11gR2手動建立的ASM執行個體無法被Clusterware管理的問題的解決》http://space.itpub.net/?uid-23135684-action-viewspace-itemid-743090
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 10 11:12:53 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-27038: created file already exists
Additional information: 1
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
$ cd $ORACLE_HOME/dbs
$ ls
ab_+ASM.dat hc_+ASM.dat init+ASM.ora init.ora spfile+ASM.ora
執行srvctl add asm指令會自動為ASM執行個體添加SPFILE參數檔案。
$ strings spfile*
/M?
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 10 11:13:21 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL>
SQL> startup nomount
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2220800 bytes
Variable Size 256544000 bytes
ASM Cache 25165824 bytes
SQL> show parameter spfile
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
spfile string
/u01/app/11.2.0/grid/dbs/spfil
e+ASM.ora
--end--
-
ORACLE dbca 找不到asm disks
2012-04-11 14:44:03
ORACLE dbca 找不到asm disks
oracle版本: 11.2.0.1.0
grid 版本: 11.2
前面的安裝基本都一步一步都走過來了,當然走的不是那麼的平坦.還好有百度google的鼎力相助終于是裝好了.
問題現象:dbca 到第6步的時候 "Database file location ",
選擇 Storage Type :Automatic Storage management
然後 Databse Area : DATA(建立的asm disk group的名稱)
如下圖:
【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝【ASM】Oracle ASM + 11gR2 + RHEL6.5 安裝 點選下一步系統提示: 無法找到指定的磁盤組.
錯誤判斷:
1 執行: /usr/sbin/oracleasm scandisks
/usr/sbin/oracleasm listdisks
結果正常,而且listdisk可以正常的将磁盤組可顯示出來.
2 切換到 grid 帳戶 ,執行資料查詢
sqlplus /nolog
conn /as sysdba
select name from v$asm_disks
也可以查得到.
3 使用者組判斷
id oracle
發現oracle沒能在asmdba組裡面,問題在此.
解決問題
執行 usermod -G oinstall -g dba,asmdba oracle
再次選擇,asm 磁盤組出來了.
後記
其實在我的最開始的建立使用者及組的腳本裡面是将oracle 加入到了asmdba中的,但是建立的腳本受了系統自帶腳本orarun的影響.
oracle 11g dbca 找不到asm diskgroup的解決辦法
oracle 11g dbca 找不到asm diskgroup的解決辦法
昨天在家裡的本本虛拟機裡配置11G R2 RAC時，GI安裝正常，db soft 安裝正常，檢視資源asm 磁盤也正常，GI是用的GRID 使用者及用ASMLIB配置的ASM DISKGROUP.但到最後一步用ORACLE使用者DBCA建庫時，在儲存選擇ASM，無法找到ASMDISKGROUP？
家裡沒法上網隻能自己猜一下，嘗試用GRID 使用者運作DBCA，當然目的隻是嘗試到選擇存儲時會不會發現ASM DISKGROUP,開始會因為環境變量問題報錯忽略，當到選擇存儲時發現正常的發現了先前用ASMCA建立的ASM磁盤組，取消安裝，開始排查錯誤。
指令 id oracle檢視了ORACLE的使用者組，發現有oinstall,asmdba,dba再檢視 id grid發現grid的使用者組要比ORACLE使用者多出一個asmadmin的使用者組然後再檢視ASM裝置的使用者組ls -l /dev/oracleasm/diskstotal 0brw-rw—- 1 grid asmadmin 8, 33 Nov 4 15:35 CRDATAbrw-rw—- 1 grid asmadmin 8, 49 Nov 4 15:35 DBDATA
是以你可以修改ASM裝置的組為asmdba,也可以給ORACLE使用者加到asmadmin,我選擇第二個usermod -a -G asmadmin oracle
或者：chown grid:asmdba /dev/asm*
還有就是去檢查一下$GRID_HOME/bin/oracle執行檔案的權限是不是下面[[email protected] bin]$ ll oracle-rwsr-s–x 1 grid oinstall 152462814 Apr 10 19:51 oracle
我記的當時好像是沒有s而是x，如果沒有執行下面的指令chmod +s oracles對于執行檔案是suid,就是告之以檔案所有者的身份運作。
執行完上面一系列的排查後，在ORACLE使用者的DBCA中終于發現了ASM DISKGROUP.
1. Incorrect permission setting for oracle user2. ASM instance was not started or diskgroups are not mounted.3. The diskgroup resources are not online.4. The permission setting for the asm devices are incorrect.5. The oracle executable under /bin has incorrect permission settings.6. the file system for grid home was mounted with option 'nosuid'.
Related Posts:
-
- No related posts found!
安裝RAC或者Oracle Restart時GI(Grid Infrastructure)和RDBMS安裝順序颠倒導緻dbca無法識别ASM磁盤組問題解決
最近和一朋友做這樣的測試，在安裝RAC或者Oracle Restart的時候如果先安裝RDBMS Software，後安裝GI(Grid Infrastructure)，會不會影響資料庫的使用或者會不會影響建立資料庫。我們懷着這樣的疑問在測試環境裡進行了實驗。RDBMS Software安裝和GI的安裝都很順利，通過asmca也建立了後續存放資料檔案和用于閃回恢複區的ASM磁盤組。本以為很順利進行下去，但dbca建庫的時候遇到了問題，到選擇存儲方式的時候無法識别asm磁盤組。如下圖：
提醒：大家要相信如果安裝順序是正确的，那麼在這個步驟中肯定是能夠看到大家建立好的ASM磁盤組資訊的。
那分析下常見的找不到ASM磁盤組的原因：1）grid家目錄或者其子目錄權限錯誤2）asm磁盤的權限錯誤3）asm執行個體未啟動或者asm磁盤組沒有mount上4）asm磁盤組資源沒有線上5）oracle使用者的權限錯誤6）oracle($ORACLE_HOME/bin)可執行檔案的權限錯誤
OK，那我就按照上面的分析結果進行逐一排查：1）gi家目錄或者其子目錄權限錯誤
[[email protected] ~]# ls -ld /u02/app/11.2.0/grid/
drwxr-x--- 66 root oinstall 4096 Apr 19 01:36 /u02/app/11.2.0/grid/
我先簡單檢視了GI的家目錄權限，這是正常的。這裡想要提醒大家，有些DBA有意無意中看到這樣的目錄權限，發現所屬主是root，以為出了問題，理所應當地通過指令去更改，如果隻更改該目錄權限問題也不大，回退方法很簡單，但一旦加上-R參數遞歸方式把子目錄、子檔案的權限一并更改，那故障就發生了。是以，大家在操作的時候不要盲目去做沒有把握的事情，掌握每個操作後面的原理以及其帶來的後果，以至于充分準備好回退方法。
在這裡我很清楚地知道沒有做過修改權限的操作，是以初步認為是這個環節沒有問題，是以pass。
2）asm磁盤的權限錯誤我是通過ASMLib驅動建立的asm磁盤，通過下面指令檢視：
[[email protected] ~]# ls -l /dev/oracleasm/disks/t
otal 0brw-rw---- 1 grid asmadmin 8, 17 Apr 19 01:22 ASMDISK1
brw-rw---- 1 grid asmadmin 8, 33 Apr 19 01:22 ASMDISK2
brw-rw---- 1 grid asmadmin 8, 49 Apr 19 01:22 ASMDISK3
如果發現權限不對，通過如下指令修改：
[[email protected] ~]# oracleasm configure -I 或者[[email protected] ~]# /etc/init.d/oracleasm configure
修改之後檢視：[[email protected] ~]# oracleasm configureORACLEASM_ENABLED=trueORACLEASM_UID=grid
ORACLEASM_GID=asmadmin
ORACLEASM_SCANBOOT=trueORACLEASM_SCANORDER=""ORACLEASM_SCANEXCLUDE=""
3）asm執行個體未啟動或者asm磁盤組沒有mount上4）asm磁盤組資源沒有線上通過檢視資源情況可以判斷有沒有3和4提到的問題
[[email protected] ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg
ONLINE ONLINE khm5
ora.FLASH.dg
ONLINE ONLINE khm5
ora.GRID.dg
ONLINE ONLINE khm5
ora.LISTENER.lsnr
ONLINE ONLINE khm5
ora.asm ONLINE ONLINE khm5 Started
ora.ons
OFFLINE OFFLINE khm5
--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.cssd
1 ONLINE ONLINE khm5
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE khm5
5）oracle使用者的權限錯誤
[[email protected] ~]# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1300(dba),1301(oper),1201(asmdba)
oracle使用者需要加入到asmdba組，如果發現沒有加入，進行如下操作：
[[email protected] ~]# gpasswd -a oracle asmdba
Adding user oracle to group asmdba
6）oracle($ORACLE_HOME/bin)可執行檔案的權限錯誤
[[email protected] ~]# su - oracle
[[email protected] ~]$ cd $ORACLE_HOME/bin
[[email protected] bin]$ ls -l oracle
-rwsr-s--x 1 oracle oinstall 232399473 Apr 19 07:04 oracle
好，到這裡我們發現問題了，oracle可執行檔案的權限不正确。在RAC或者ORACLE RESTART中，oracle可執行檔案的所屬組是asmadmin。
如下方式進行修改：
[[email protected] ~]# cd /u02/app/oracle/product/11.2.0/dbhome_1/bin/
[[email protected] bin]# chown oracle:asmadmin oracle
[[email protected] bin]# ls -l oracle
-rwxr-x--x 1 oracle asmadmin 232399473 Apr 19 07:04 oracle
[[email protected] bin]# chmod +s oracle
[[email protected] bin]# ls -l oracle
-rwsr-s--x 1 oracle asmadmin 232399473 Apr 19 07:04 oracle
修改完後問題解決，我們能夠看到ASM磁盤組資訊了。
-
ora-15077，ASM磁盤組不能挂載
一、現象分析：1、資料庫和執行個體服務無法啟動，如下：[[email protected] ~]$ crs_stat -tName Type Target State Host------------------------------------------------------------ora.....CRM.cs application ONLINE OFFLINE rac1ora....cl1.srv application ONLINE OFFLINE rac1ora.orcl.db application ONLINE OFFLINE rac2ora....l1.inst application ONLINE OFFLINE rac1ora....l2.inst application ONLINE OFFLINE rac2ora....SM1.asm application ONLINE ONLINE rac1ora....C1.lsnr application ONLINE ONLINE rac1ora.rac1.gsd application ONLINE ONLINE rac1ora.rac1.ons application ONLINE ONLINE rac1ora.rac1.vip application ONLINE ONLINE rac1ora....SM2.asm application ONLINE ONLINE rac2ora....C2.lsnr application ONLINE ONLINE rac2ora.rac2.gsd application ONLINE ONLINE rac2ora.rac2.ons application ONLINE ONLINE rac2ora.rac2.vip application ONLINE ONLINE rac22、單獨啟動某個應用服務依然啟不起來3、用sqlplus啟動執行個體，如下：[[email protected]]$ export ORACLE_SID=devdb1SQL> startup;ORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.oraORA-15077: could not locate ASM instance serving a required diskgroup可以看出diskgroup沒有mount,是以先把diskgroup mount
也可做下面的測試，同樣也會報磁盤組沒挂載：[[email protected] bdump]$ export ORACLE_SID=+ASM1[[email protected] bdump]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 22 17:59:39 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> shutdown immediate;ORA-15100: invalid or missing diskgroup name
ASM instance shutdownSQL> startup;ASM instance started
Total System Global Area 92274688 bytesFixed Size 1217884 bytesVariable Size 65890980 bytesASM Cache 25165824 bytesORA-15110: no diskgroups mounted
二、解決辦法：1、首先挂載ASM磁盤組[[email protected] bdump]$ export ORACLE_SID=+ASM1[[email protected] bdump]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 22 17:59:39 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining optionsSQL> select name,state from v$asm_diskgroup;
NAME STATE------------------------------ -----------RECOVERYDEST DISMOUNTEDDG1 DISMOUNTED
SQL> alter diskgroup RECOVERYDEST mount;
Diskgroup altered.
SQL> alter diskgroup DG1 mount;
Diskgroup altered.
SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options
2、啟動資料庫執行個體[[email protected] bdump]$ export ORACLE_SID=devdb1[[email protected] bdump]$ sqlplus / as sysdbaSQL> startup;ORACLE instance started.
Total System Global Area 264241152 bytesFixed Size 1218868 bytesVariable Size 109053644 bytesDatabase Buffers 150994944 bytesRedo Buffers 2973696 bytesDatabase mounted.database open.
三、原因：發現可能是因為oracle使用者下的.bashrc檔案中$ORACLE_SID環境變量與實際建庫的資料庫名不一緻所至,是以在資料庫啟動時會找不到環境變量對應的執行個體名.bashrc中是orcl1[[email protected]~]cat .bashrc.....export ORACLE_SID=orcl1.....
而實作的執行個體名是devdb1是以修改.bashrc中的ORACLE_SID=devdb1
版權聲明：本文為CSDN部落客「weixin_33991418」的原創文章，遵循CC 4.0 BY-SA版權協定，轉載請附上原文出處連結及本聲明。
原文連結：https://blog.csdn.net/weixin_33991418/article/details/91913974