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>
至此,问题解决了。。
将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>
至此,问题解决了。。