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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
1,990 views