DBA組下不同成員登入ORACLE的情況

楊奇龍發表於2011-04-13
DBA組下不同成員登入ORACLE的情況,報錯的問題。
將admin 使用者加入oracle 使用者組。
root@r01c05011.yh.com # usermod -g oinstall admin
root@r01c05011.yh.com # usermod -g dba admin    
root@r01c05011.yh.com # su - admin
admin@r01c05011.yh.com:/home/admin>sqlplus /nolog       
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
查詢metalink發現是ORACLE 10g R2的一個BUG,版本號為4516865。下載補丁,並解壓。
oracle@r01c05011.yh.com # unzip p4516865_10201_Linux-x86-64.zip
Archive:  p4516865_10201_Linux-x86-64.zip
   creating: 4516865/
   creating: 4516865/files/
   creating: 4516865/files/install/
  inflating: 4516865/files/install/restrict.lst  
  inflating: 4516865/files/install/changePerm.sh  
   creating: 4516865/etc/
   creating: 4516865/etc/config/
  inflating: 4516865/etc/config/inventory  
  inflating: 4516865/etc/config/actions  
   creating: 4516865/etc/xml/
  inflating: 4516865/etc/xml/GenericActions.xml  
  inflating: 4516865/etc/xml/ShiphomeDirectoryStructure.xml  
  inflating: 4516865/README.txt
 
oracle@r01c05011.yh.com:/home/4516865/files>cd install
oracle@r01c05011.yh.com:/home/4516865/files/install>ls
changePerm.sh  restrict.lst
oracle@r01c05011.yh.aliyun.com:/home/4516865/files/install>ll
total 24
-rw-r--r-- 1 oracle oinstall 11401 Apr 13 17:59 changePerm.sh
-rw-r--r-- 1 oracle oinstall  8746 Apr 13 17:59 restrict.lst
oracle@r01c05011.yh.com:/home/4516865/files/install>chmod 755 changePerm.sh
oracle@r01c05011.yh.com:/home/4516865/files/install>chmod 644 restrict.lst
oracle@r01c05011.yh.com:/home/4516865/files/install>ls -l
total 24
-rwxr-xr-x 1 oracle oinstall 11401 Apr 13 17:59 changePerm.sh
-rw-r--r-- 1 oracle oinstall  8746 Apr 13 17:59 restrict.lst
oracle@r01c05011.yh.com:/home/4516865/files/install>./changePerm.sh
Cannot find file /opt/oracle/products/10.2.0/install/restrict.lst.
Please ensure that this file exists in the same directory as this shell script.
將install目錄下的changePerm.sh和restrict.lst這兩個檔案解壓到$ORACLE_HOME/install資料夾下。
oracle@r01c05011.yh.com:/home/4516865/files/install>cp changePerm.sh $ORACLE_HOME/install
oracle@r01c05011.yh.com:/home/4516865/files/install>cp restrict.lst  $ORACLE_HOME/install
oracle@r01c05011.yh.com:/home/4516865/files/install>cd $ORACLE_HOME/install             
oracle@r01c05011.yh.com:/opt/oracle/products/10.2.0/install>ll
total 252
drwxrwx--- 2 oracle oinstall   4096 Apr 13 15:43 chainedInstall
-rwxr-xr-x 1 oracle oinstall  11401 Apr 13 18:09 changePerm.sh
-rw-r----- 1 oracle oinstall      0 Apr 13 15:43 createseed1.sh
-rw-r----- 1 oracle oinstall      0 Apr 13 15:43 createseed.sh
-rw-r----- 1 oracle oinstall    974 Apr 13 15:43 envVars.properties
drwxrwx--- 2 oracle oinstall   4096 Apr 13 15:43 jlib
-rw-r----- 1 oracle oinstall 179464 Apr 13 15:43 make.log
-rwxr-xr-x 1 oracle oinstall      0 Apr 13 15:43 oratab
-rw-r----- 1 oracle oinstall     33 Apr 13 15:43 portlist.ini
-rw-r----- 1 oracle oinstall    254 Apr 13 15:43 readme.txt
-rw-r--r-- 1 oracle oinstall   8746 Apr 13 18:09 restrict.lst
-rwxr-xr-x 1 oracle oinstall    816 Apr 13 15:43 rootdeletenode.sh
-rw-r----- 1 oracle oinstall   9638 Apr 13 15:43 rootlocaladd
-rw-r----- 1 oracle oinstall      0 Apr 13 15:43 seed.log
-rw-r----- 1 oracle oinstall   2800 Apr 13 15:43 templocal
drwxrwx--- 2 oracle oinstall   4096 Apr 13 15:43 unix
drwxrwx--- 2 oracle oinstall   4096 Apr 13 15:43 utl
再次執行指令碼changePerm.sh   
oracle@r01c05011.yh.com:/opt/oracle/products/10.2.0/install>./changePerm.sh            
-------------------------------------------------------------------------------
Disclaimer: The purpose of this script. is to relax permissions on some of the
files in the database Oracle Home so that all clients can access them.
Please note that Oracle Corporation recommends using the most restrictive file
permissions as possible for your given implementation.  Running this script
should be done only after considering all security ramifications.
-------------------------------------------------------------------------------
Do you wish to continue (y/n) [n]: y
Finished running the script. successfully
Please see /tmp/changePerm_err.log for errors and /tmp/changePerm.log for the log of events
看到此,說明成功完成補丁。
dba組中另一個使用者admin 再次使用sqlplus 驗證
admin@r01c05011.yh.com:/home/admin>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 13 18:13:05 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL>  
至此,問題解決了。。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-692441/,如需轉載,請註明出處,否則將追究法律責任。

相關文章