Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to connect to DB with alias name for localhost

Rajneesh S-OracleOct 29 2020 — edited Oct 29 2020

Hello All,
I have oracle 12c DB installed on my localhost (local laptop) and able to connect to DB through sqldeveloper with hostname as "localhost" or ip as "127.0.0.1".
However when I tried to connect to this DB through hostname (example, "XYZ-IN.in.oracle.com") , I am hetting below error:
image.pngI need to connect to a DB in my local laptop through another server in same network.
So that time I will need to give hostname "XYZ-IN.in.oracle.com" at TNS ora file of that server and hosts file of that server.
Hence wanted to check if I can connect with hostname "XYZ-IN.in.oracle.com" localy first before updating tnsora file and hosts file at server.
This alias for localhost , I got from "ipconfig /all " command at command line so I believe it is correct name only.
However one observation-
when I do "ping localhost" or "ping 127.0.0.1", I get proper respoonse like below:
image.pnghowever if I do "ping XYZ-IN.in.oracle.com" then response is like below:
Is that mean- localhost alias "XYZ-IN.in.oracle.com" is not correct?
But that is the only alias I got from "ipconfig /all" command:
image.pngKindly advise.
Thanks,
Rajneesh

This post has been answered by Billy Verreynne on Oct 31 2020
Jump to Answer
Comments
Post Details
Added on Oct 29 2020
6 comments
2,196 views