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

DBA組下不同成員登入ORACLE的情況，報錯的問題。

将admin 使用者加入oracle 使用者組。

[email protected] # usermod -g oinstall admin

[email protected] # usermod -g dba admin    

[email protected] # su - admin

[email protected]:/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。下載下傳更新檔，并解壓。

[email protected] # 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

[email protected]:/home/4516865/files>cd install

[email protected]:/home/4516865/files/install>ls

changePerm.sh  restrict.lst

[email protected]:/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

[email protected]:/home/4516865/files/install>chmod 755 changePerm.sh

[email protected]:/home/4516865/files/install>chmod 644 restrict.lst

[email protected]:/home/4516865/files/install>ls -l

-rwxr-xr-x 1 oracle oinstall 11401 Apr 13 17:59 changePerm.sh

[email protected]:/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檔案夾下。

[email protected]:/home/4516865/files/install>cp changePerm.sh $ORACLE_HOME/install

[email protected]:/home/4516865/files/install>cp restrict.lst  $ORACLE_HOME/install

[email protected]:/home/4516865/files/install>cd $ORACLE_HOME/install             

[email protected]:/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   

[email protected]:/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 驗證

[email protected]:/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>  

至此，問題解決了。。