[ORACLE] ORA-12547: TNS:lost contact

증상 : 뭔가 작업하다가 꼬였는지 oracle 계정에서는 sqlplus 를 통해 user 접속이 잘되는데 다른 계정으로는 접속이 안되는 현상

$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 20 14:07:18 2023
Version 19.3.0.0.0

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

Enter user-name: scott
Enter password: 
ERROR:
ORA-12547: TNS:lost contact

 

추측 원인 : tuxedo 설치한다고 oracle_home 에 있던 여러 파일들 그룹권한을 수정하다가 발생한거 같다.

 

 

해결 방법 : oracle 계정으로 sysdba 접속해서 oracle 내리고 relink all 명령 수행한 후 oracle 다시 올렸더니 성공

$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 20 14:07:42 2023
Version 19.3.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.3.0.0.0

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

$ relink all
writing relink log to: /u01/app/oracle/product/19.0.0/dbhome_1/install/relinkActions2023-01-20_02-08-37PM.log

$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 20 14:09:52 2023
Version 19.3.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 2449469680 bytes
Fixed Size                  9138416 bytes
Variable Size             587202560 bytes
Database Buffers         1828716544 bytes
Redo Buffers               24412160 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0