ORA-12537: TNS:connection closed問題解決
環境:oracle linux5.5 + oracle 11g rac
問題描述:客戶端無法連線資料庫,並報錯:ORA-12537: TNS:connection closed
lsnrctl status 監聽正常,lsnrclt stop/start 能正常啟動,嘗試連線,依然報同樣的錯,再檢視監聽日誌,沒發現明顯的錯誤資訊,然後在網上查詢到解決辦法(連結:http://blog.itpub.net/post/38575/530168):
修改$ORACLE_HOME/bin 下的oracle檔案的許可權
具體操作過程:
[oracle@rac1 ~]$ cd $ORACLE_HOME/bin/
[oracle@rac1 bin]$ ls -l oracle
-r-xr-sr-x 1 oracle asmadmin 173515905 Dec 21 16:46 oracle
[oracle@rac1 bin]$ chmod 6751 oracle
[oracle@rac1 bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmadmin 173515905 Dec 21 16:46 oracle
重新連線,OK!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/21754115/viewspace-1334151/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Oracle】ORA-12537: TNS:connection closed 問題處理Oracle
- ora-12537 TNS:connection closed的問題處理
- 解決11gR2 Rac ORA-12537: TNS:connection closed 一例
- sqlplus scott/system@ora10g報錯ORA-12537: TNS:connection closedSQL
- ssh問題:ssh_exchange_identification: Connection closed by remote hostIDEREM
- 1 Million TCP Connection 問題解決TCP
- 問題解決:TNS-12543: TNS:destination host unreachable
- 記一次解決:TNS-12518: TNS:listener could not hand off client connectionclient
- Mysql mysql lost connection to server during query 問題解決方法MySqlServer
- 解決Redis/Codis Connection with master lost(複製超時)問題RedisAST
- weblogic連線池重置(Connection reset)問題解決方案Web
- ORA-12537 TNS:連線關閉
- TNS - 12516 TNS : 解決
- 解決okhttp報java.lang.IllegalStateException: closed,java.lang.IllegalStateException: closedHTTPJavaException
- iOS Xcode, 解決“Could not insert new outlet connection”的問題。iOSXCode
- 解決「問題」,不要解決問題
- 解決問題-There appears to be trouble with your network connection. Retrying...APP
- 解決java connectionJava
- android中The connection to adb is down,問題和解決Android
- ORA-12537錯誤的解決
- TNS-12518: TNS:listener could not hand off client connectionclient
- TNS-12518 TNS listener could not hand off client connectionclient
- ORA-12537 TNS:資料庫連線錯誤資料庫
- oracle監聽啟動時報TNS-00507問題解決一例Oracle
- 解決問題
- TNS問題排查 The listener supports no services
- 發現問題,解決問題
- 解決TNS-125000
- TNS-12547 TNS-12560 TNS-00517解決辦法
- yum問題解決
- sqlitedabaseislocked問題解決SQLite
- dump 解決問題
- TNS-12547TNS-12560 TNS-00517 Linux Error: 104: Connection reset by peerLinuxError
- 客戶端連線EBS 11i VIS報ORA-12537: TNS: 連線已關閉 錯誤的解決客戶端
- 解決telnet: connect to address 127.0.0.1: Connection refused的錯誤資訊問題127.0.0.1
- GoldenGate Pump Porcess: TCP/IP error 110 (Connection timed out)的問題解決GoTCPError
- TNS-12560: TNS:protocol adapter error 錯誤解決ProtocolAPTError
- ORA-609,ORA-12537問題處理