“ORA-12545: Connect failed because target host or object does not exist” using / as sysdba

Have a nice day!!! หาตั้งนานเจอแล้วเก็บไว้ในคลังซักหน่อย เผื่อใครเจอปัญหาเหมือนกัน ^^

"ORA-12545: Connect failed because target host or object does not exist” using / as sysdba

ORA-12545 is very common error and people use to get this quite frequently as soon as they have some mis-configuration in oracle client configuration files.

sometime back while working on a recovery issue I got this issue when I tried to connect db as “/ as sysdba” on the same host where db was running. the strange is I got this error……. this was haunting for me and I thought lot of option but nothing worked.

Solution:

After couple of troubleshootings I came to know that we are missing$ORACLE_HOME/bin/oracle file. I asked unix to restore this file. database opened and now up and running.

หรือสามารถไป copy file oracle มาจากเครื่องอื่นที่เป็น version เดียวกัน และทำการ chmod ก็จะสามารถเข้าใช้งาน sqlplus ได้ตามปกติ

52224 -rwsr-sr-x 1 oracle dba 53431665 Aug 10 11:07 oracle



To set permission on Oracle binary:

Logon as oracle

cd $ORACLE_HOME/bin

chmod 6755 oracle