環境變量多個斜杠引起ORA-12547: TNS:lost contact

原創范偉林 2022-12-01

3236

前言：

相信ORA-12547: TNS:lost contact這種問題已經是爛大街的了，但是本次的問題真是那些oracle執行文件權限，白名單，資源限制，共享內存等等之類的問題嗎？

一、環境信息

數據庫版本：19c

二、問題復現

因為某個情況，在創建或者啟動數據庫的時候設置了ORACLE_HOME環境變量，并且結尾過了一個斜杠，例如：
export ORACLE_HOME=$ORACLE_BASE/product/19.5.0/dbhome_1/；這時候你數據庫本地環境變量是設置沒有斜杠，那進行sqlplus連接則會出現ORA-12547的錯誤。

[oracle@William ]$export ORACLE_HOME=$ORACLE_BASE/product/19.5.0/dbhome_1
[oracle@William ]$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 1 17:35:19 2022
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-12547: TNS:lost contact


Enter user-name: 

[oracle@William ]$export ORACLE_HOME=$ORACLE_BASE/product/19.5.0/dbhome_1/
[oracle@William ]$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 1 17:35:09 2022
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0

Note：仔細觀看后面登陸的export環境變量結尾是有個斜杠

三、問題處理

以原本帶斜杠的環境變量登錄數據庫關掉數據庫，再設置沒有斜杠的ORACLE_HOME環境變量再啟動數據庫實例即可復原

[oracle@William ]$export ORACLE_HOME=$ORACLE_BASE/product/19.5.0/dbhome_1/
[oracle@William ]$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 1 17:57:15 2022
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0

[oracle@William ]$ export ORACLE_HOME=$ORACLE_BASE/product/19.5.0/dbhome_1
[oracle@William ]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 1 17:59:04 2022
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1048575592 bytes
Fixed Size                  9129576 bytes
Variable Size             616562688 bytes
Database Buffers          415236096 bytes
Redo Buffers                7647232 bytes
Database mounted.
Database opened.
SQL>

Note：經測試11g只會提示連接到空閑實例，并不會報ORA-12547: TNS:lost contact

所以一個良好的習慣很重要

墨力計劃