DBA組下不同成員登入ORACLE的情況
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>
至此,問題解決了。。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-692441/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 在沒有開啟審計的情況下定位Oracle錯誤的登入Oracle
- oracle組合索引什麼情況下生效?Oracle索引
- ORACLE MYSQL中join 欄位型別不同索引失效的情況OracleMySql型別索引
- String不同定義的情況解析
- Oracle什麼情況下需要rebuild indexOracleRebuildIndex
- iOS不同網路情況除錯iOS除錯
- 4.3.4.1 在不使用Oracle OMF的情況下建立CDBOracle
- linux下指定不同使用者登入不同目錄Linux
- 圖片無法載入的情況下的優化優化
- SSO單點登入三種情況的實現方式詳解
- Vue-router實現單頁面應用在沒有登入情況下,自動跳轉到登入頁面Vue
- Oracle其它情況的恢復Oracle
- 小組成員的github地址Github
- 在不安裝oracle客戶端的情況下,使用PLSQLOracle客戶端SQL
- ORACLE不使用工具的情況下獲取物件DDLOracle物件
- EMC 故障情況下ORACLE 救火行動(之二)Oracle
- 在ASM下增加一個日誌組成員ASM
- 給一組數,分為兩組,求差最小的情況
- 【DBA】如何快速的成為一個合格的Oracle DBA?Oracle
- oracle order by索引是否使用的情況Oracle索引
- Oracle DBA的資源和組織Oracle
- ORACLE索引被抑制情況Oracle索引
- 匯出Wireless組中的成員
- OpenSSH普通使用者無法登入的幾種情況的解決方法
- 如何成為資料庫管理員(DBA)?資料庫
- 資料泵匯入-在物件已存在的情況下執行匯入物件
- MySQL主從不同步的幾種情況總結MySql
- oracle11g在沒DNS情況下failover的配置方法OracleDNSAI
- 直接登入資料庫使用drop table tablename;會是什麼情況?資料庫
- oracle小於1的浮點轉成字元時,丟掉前面0,變成點幾的情況Oracle字元
- Oracle 查詢DB的負載情況Oracle負載
- Oracle 8x中監控sysdba角色使用者登陸情況(轉)Oracle
- Oracle 時段負載情況Oracle負載
- 檢查oracle的patch的升級情況Oracle
- 刪除日誌組成員
- oracle 11.2.0.2的組成Oracle
- 組合(巢狀)的 補充,主動呼叫其他成員 以及特殊成員巢狀
- Oracle下不知道密碼的情況下如何還原密碼Oracle密碼