Tuesday, 12 March 2019

ERROR: ORA-12547: TNS:lost contact


[r1dba@INPRJ-HOTV9V01 ~]$ sqlplus /nolog

SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 11 16:04:01 2019

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

SQL> conn r1dba/*********
ERROR:
ORA-12547: TNS:lost contact


SQL> exit

[r1dba@INPRJ-HOTV9V01 ~]$ su - 12cdb
Password:
Last login: Mon Mar 11 16:01:22 IST 2019 from 10.14.255.207 on pts/3

[12cdb@INPRJ-HOTV9V01 ~]$ cd $ORACLE_HOME/bin

[12cdb@INPRJ-HOTV9V01 bin]$ ls -ltr oracle

-rwxrwxrwx. 1 12cdb oinstall 407988856 Feb 18 12:12 oracle

[12cdb@INPRJ-HOTV9V01 bin]$  chmod 6751 oracle

[12cdb@INPRJ-HOTV9V01 bin]$ exit
logout

[r1dba@INPRJ-HOTV9V01 ~]$ sqlplus /nolog

SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 11 16:07:01 2019

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

SQL> conn r1dba/*********
Connected.



For more possible reasons and solutions. 

No comments:

Post a Comment