DBA组下不同成员登录ORACLE的情况
2023-09-14 08:57:30 时间
将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
至此,问题解决了。。
DBA组下不同成员登录ORACLE的情况,报错的问题。将admin 用户加入oracle 用户组。root@r01c05011.yh.com # usermod -g oinstall adminroot@r01c05011.
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
至此,问题解决了。。
DBA组下不同成员登录ORACLE的情况,报错的问题。将admin 用户加入oracle 用户组。root@r01c05011.yh.com # usermod -g oinstall adminroot@r01c05011.
相关文章
- 登录解锁Oracle远程登录本地计算机(本地计算机的oracle)
- Oracle OEM远程登录指南。(oracle登陆oem)
- Oracle系统登陆:使用Sys账户(oracle以sys登录)
- 处理Oracle中实现日期循环处理方法(oracle日期循环)
- 破解Oracle挑战:修改登录口令(oracle登录口令)
- 使用Oracle 加密函数保护数据安全(oracle加密函数)
- 探究Oracle触发器的类型(oracle触发器类型)
- 深入理解Oracle数据库中的触发器类型(oracle触发器类型)
- 利用Oracle触发器实现自动化处理(oracle触发器类型)
- Oracle 登录密码长度最佳实践(oracle密码长度)
- 与口令Oracle登录:正确的用户名和口令(oracle登录名)
- Oracle关系运算打开新技术之门(oracle 关系运算)
- 高效率实施Oracle数据库备份策略的DBA(dba备份oracle)
- Com登录Oracle实现数据库连接的桥梁(com登陆oracle)
- 挑战极限DOS登录到Oracle(dos登录到oracle)
- 解决Oracle代理登录失败的措施(oracle代理登录失败)
- 数据在Oracle中查询昨天数据的技巧(oracle中查询昨天)
- Oracle中查找最大值的方法简介(oracle中查找最大值)
- 深入解析Oracle R12的安装过程(oracle r12安装)
- Oracle DBA语句驱动业务功能(oracle dba语句)
- Oracle DBA 该去何处(oracle dba消失)
- Oracle从0到1,打造高效数据库管理系统(oracle 0 到1)