-
1. Re: Connecting remote DB without TNS file or oracle client
Yes you can.
Are you able to ping the host name from your machine ?
Make sure that you are using the correct port number , SIS/SERVICE NAME.
Cheers
AJ
-
2. Re: Connecting remote DB without TNS file or oracle client
Thank you Johny, Yes I am able to ping the machine and also correct port & sid, but no luck
-
3. Re: Connecting remote DB without TNS file or oracle client
hmm.. Where is this DB installed ? Is the listener up and running ?
Can you check the below thread and the suggestions mentioned in that ?
IO Error Establishing connection Network Adapter Could not
Cheer
AJ
-
4. Re: Connecting remote DB without TNS file or oracle client
Yes, other people are able to connect, db is remotely installed
-
5. Re: Connecting remote DB without TNS file or oracle client
Are they using SQL Developer ? Is there any IP restriction to connect to the DB?
-
6. Re: Connecting remote DB without TNS file or oracle client
No, they are suing Toad and using TNS string
-
7. Re: Connecting remote DB without TNS file or oracle client
Just to test, can you try to sue the same TNS file and see whether you are able to connect ?
Choose the connection type as TNS.
CHeers
AJ
-
8. Re: Connecting remote DB without TNS file or oracle client
ok, but I don't have oracle client or any kind of db set up in my machine, will it work to put tns fine somewhere in my local machine?
-
9. Re: Connecting remote DB without TNS file or oracle client
Yes, you don't need oracle client.
Just paste the TNS file somewhere and specify that in
Tools--> Prefereces --> Database -->Advanced --> TNSNames Directory.
Refer the below link for more details
http://www.thatjeffsmith.com/archive/2014/06/on-sql-developer-and-tnsnames-ora/
Cheers
AJ
P.S: Please mark the helpful and correct answers if it is
-
10. Re: Connecting remote DB without TNS file or oracle client
No luck, same error, SQL developer is able to display tns names
-
11. Re: Connecting remote DB without TNS file or oracle client
I think there is something else which is restricting the connection from your machine.
Are you able to unzip SQLdeveloper in one of the machines which connects to DB currently and see what happens ?
Is there any firewall in your machine ?
Cheers
AJ
-
12. Re: Connecting remote DB without TNS file or oracle client
Semantic end protection is installed in my machine, is it causing issues?
-
13. Re: Connecting remote DB without TNS file or oracle client
Not Really Sure. can you try disabling that?
-
14. Re: Connecting remote DB without TNS file or oracle client
I tried but I not able to switch off that. But I did a ping to the server, will it be a problem?
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.