Search code examples
oracle-databasemacossqlplushostname

SQLPlus is throwing client hostname issue ORA-24454, whereas I can telnet to hostname successfully

I'm trying to connect to the oracle database via sqlplus hosted on a remote instance using command like this sqlplus user@hostname.com:port/SchemaName. And on typing password it throws weird client host issue. See the screenshot below.

The question is which host name its expecting me to put inside /etc/hosts?

enter image description here

Whereas I can telnet successfully to same instance without any issues. By the way I'm on MacOS 10.15.7.

enter image description here

Oracle clients were installed using this link. Can be seen from the screenshot below.

enter image description here

The installation was moved to the appropriate folder.

enter image description here

The $PATH was also exported to ~/.bash_profile file

enter image description here

Solution

  • I was able to resolve this issue by the solution mentioned on this link.

    Using hostname command I was able to find host name of my machine, which was required to make a successful connection to the Oracle.

    The screenshot below explains the process

    enter image description here

    The hostname entry looks like below

    enter image description here