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

Time：11-09

I'm trying to connect to the oracle database via sqlplus hosted on a remote instance using command like this sqlplus [email protected]: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 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

CodePudding user response：

I was able to resolve this issue by the solution mentioned on this enter image description here

The hostname entry looks like below

enter image description here

Page link：https//www.codepudding.com/Enterprise/184026.html

Prev:How to insert a NULL value in PL/SQL Procedure?
Next:Why doesn't "foldLeft" work with class members in Scala?
  • Related

About Us:  Contact Us      Terms of Service       Privacy Policy

Copyright © 2010-2023，Powered By CodePudding