[Oracle] ORA-12547: TNS:lost contact
[mon@topaz source]$ export ORACLE_BASE=/u01/oracle
[mon@topaz source]$ export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
[mon@topaz source]$ export ORACLE_SID=xxxxx
[mon@topaz source]$ sqlplus / as sysdba
-bash: sqlplus: command not found
[mon@topaz source]$ $ORACLE_HOME/bin/sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 28 14:07:48 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
[oracle@topaz bin]$ ls -l oracle
-rwxrwxr-x 1 oracle oinstall 210824714 May 4 2014 oracle
[oracle@topaz bin]$
[oracle@topaz bin]$ chmod 6751 oracle
[oracle@topaz bin]$ ls -l oracle
-rwsr-s--x 1 oracle oinstall 210824714 May 4 2014 oracle
[mon@topaz source]$ export ORACLE_BASE=/u01/oracle
[mon@topaz source]$ export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
[mon@topaz source]$ export ORACLE_SID=xxxxx
[mon@topaz source]$ $ORACLE_HOME/bin/sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 28 14:10:06 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> exit
[mon@topaz source]$ export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
[mon@topaz source]$ export ORACLE_SID=xxxxx
[mon@topaz source]$ sqlplus / as sysdba
-bash: sqlplus: command not found
[mon@topaz source]$ $ORACLE_HOME/bin/sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 28 14:07:48 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
[oracle@topaz bin]$ ls -l oracle
-rwxrwxr-x 1 oracle oinstall 210824714 May 4 2014 oracle
[oracle@topaz bin]$
[oracle@topaz bin]$ chmod 6751 oracle
[oracle@topaz bin]$ ls -l oracle
-rwsr-s--x 1 oracle oinstall 210824714 May 4 2014 oracle
[mon@topaz source]$ export ORACLE_BASE=/u01/oracle
[mon@topaz source]$ export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
[mon@topaz source]$ export ORACLE_SID=xxxxx
[mon@topaz source]$ $ORACLE_HOME/bin/sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 28 14:10:06 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> exit
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2048449/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【ORACLE】ORA-12547: TNS:lost contactOracle
- 【轉載-ORACLE】ORA-12547: TNS:lost contactOracle
- Oracle案例04——TNS-12547: TNS:lost contactOracle
- ORA-12547: TNS:lost contact之oracle執行檔案許可權問題Oracle
- 【ORA-】ORA-12547: TNS:lost contact錯誤的跟蹤分析
- linux oracle建立資料庫的時候報錯ORA-12547:TNS:lost contactLinuxOracle資料庫
- 連Oracle資料庫報ORA-12547: TNS:lost contact問題處理一例Oracle資料庫
- sqlplus登入資料庫報錯ORA-12547: TNS:lost contactSQL資料庫
- 本機SQLPLUS 的時候報錯 ORA-12547: TNS: lost contactSQL
- oracle 啟動監聽報錯TNS-12547: TNS:lost contactOracle
- Oracle 11g ASM 單例項安裝 DBCA 建庫 報錯 ORA-12547: TNS:lost contactOracleASM單例
- 使用DBCA建立資料庫時,報告錯誤:ORA-12547: TNS: lost contact錯誤資料庫
- 32位系統報錯TNS-12547: TNS:lost contact
- 在Suse 12.4上安裝11.2.0.4的rac執行root.sh報錯“ORA-12547: TNS:lost contact”
- Counld not connect to ASM due to following error,ora-12547:TNS:lost comactASMErrorMac
- 【RAC】ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contactASM
- ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contact(轉載)ASM
- 新裝11GRAC遠端連線不上資料庫,報TNS-12547: TNS:lost contact故障處理資料庫
- ORA-03135: connection lost contact的解決方法
- Oracle TNS報錯大全Oracle
- Oracle TNS-12560, TNS-00530 錯誤Oracle
- grid軟體安裝目錄許可權被修改引起登陸ASM出現ORA-12547 TNSlost contactASM
- ORACLE TNS Io異常End of TNS data channel&ORA-12518Oracle
- 【轉】在linux下oracle的TNS-12537, TNS-12560, TNS-00507LinuxOracle
- CRS-4639: Could not contact Oracle High Availability ServicesOracleAI
- Oracle11g ORA-609 TNS 12537 TNS 12560Oracle
- It is the Auction House in Lost Ark
- linux lost passwordLinux
- oracle 11g tns和監聽配置Oracle
- CUUG《Oracle 監聽和TNS配置》- 筆記Oracle筆記
- Oracle備庫TNS連線失敗的分析Oracle
- 【oracle】TNS-03505: 無法解析名稱Oracle
- 【Oracle】TNS-12154 錯誤解析Oracle
- Oracle Database Fails to Start with Error ORA-12547 [ID 1307075.1]OracleDatabaseAIError
- EBS TNS-12546: TNS:permission denied+ TNS-12560: TNS:protocol adapter error+TNS-00516: Permission deProtocolAPTError
- TNS - 12516 TNS : 解決
- Oracle Database Server 'TNS Listener'遠端資料投毒漏洞OracleDatabaseServer
- 案例學習Oracle錯誤:TNS-00510(轉)Oracle