Home » Developer & Programmer » Forms » Connect to Remote Database
Connect to Remote Database [message #196175] Wed, 04 October 2006 07:16 Go to next message
anilkulkarni
Messages: 22
Registered: April 2005
Junior Member
Hi,
I want to connect the Remote database server which is in different location.

Can i Connect throough Oracle client?If yes how can i connect?

Thanks in advance
Re: Connect to Remote Database [message #196178 is a reply to message #196175] Wed, 04 October 2006 07:30 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, you can (actually, you should be able to) if you configure the network access.

As you didn't mention which Oracle version and Operating system you use, from my point of view, use Net Configuration Assistant (can be found among Configuration and Migration Tools) - it should set everything up in order to enable you to connect to the remote database.
Re: Connect to Remote Database [message #196187 is a reply to message #196178] Wed, 04 October 2006 07:47 Go to previous messageGo to next message
anilkulkarni
Messages: 22
Registered: April 2005
Junior Member
I am using Oracle 8.1.7 client and server 8.1.7. here are the steps i followed to configure.
1. Open net configuration assistant
2. Local net service name configuration
3. Choosen Add
4. Choosen 8i or later database
5. Service name which is created on the remote database.
6. Protocal
7. Host name and port name (default port 1521)
8. choosen yes perform test
9. I got the error here as follows:

ORA-12541 : TNS:No listner
The test did not succeed

Let me know if I need to do any thing more on the server and the client side.

Thanks for your response.
Re: Connect to Remote Database [message #196401 is a reply to message #196187] Thu, 05 October 2006 03:54 Go to previous messageGo to next message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi
you have to check the following condition
and see what applies to your problem.

1. you should check the network.
2. you should try ip address instead of hostname
3. check the lan cards and cables on the both sides
4. check in the services if the service " Oracle tnslistner" is running.if it is not showing the status "started" then right click on the service and click start.

if these are not the problems
then you have to create the the listner again

drop the existing listner
and create another using net8 assistant or dba studio

if you have any query please reply this message.

regards

Muhammad Shahid Mughal
Re: Connect to Remote Database [message #196566 is a reply to message #196401] Fri, 06 October 2006 00:20 Go to previous messageGo to next message
anilkulkarni
Messages: 22
Registered: April 2005
Junior Member
I have checked all 4 points that you have mentioned but still i am getting the same error "TNS:no listner."

Re: Connect to Remote Database [message #196614 is a reply to message #196566] Fri, 06 October 2006 04:09 Go to previous messageGo to next message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi

if it doesn't work
please check on the client side if
firewall is on then turn it off.
i you have an antivirus which shows you firewall off but in real the firewall is on then it is necessary to uninstall that antivirus.

i suffered this problem with panada antivirus.

second try to restart your listener service in the control pannel administrative tool services

i hope now it will work.

regards

Muhammad Shahid Mughal
Re: Connect to Remote Database [message #196941 is a reply to message #196614] Mon, 09 October 2006 05:09 Go to previous messageGo to next message
anilkulkarni
Messages: 22
Registered: April 2005
Junior Member
I have done what you have said but still I am not able to connect. Even though I restarted the listner on the server I am getting the same error saying that "TNS: No listner".
I could ping that machine.

Thanks,

Anil Kulkarni

Re: Connect to Remote Database [message #196955 is a reply to message #196175] Mon, 09 October 2006 06:00 Go to previous messageGo to next message
honeyapps
Messages: 45
Registered: March 2005
Location: pune
Member
Try to start the lsnr sevice in the server,i think this will solve the problem
Ragards
honey
Re: Connect to Remote Database [message #207060 is a reply to message #196955] Mon, 04 December 2006 00:57 Go to previous message
anilkulkarni
Messages: 22
Registered: April 2005
Junior Member
I am not able to connect thru Oracle SQL client to remote database as we have fortigate firewall installed.

Do I need to set anything in the firewall as we could connect to the remote database without firewall.

please help me
Previous Topic: OLE2 and DDE package books
Next Topic: Use Application in 10g
Goto Forum:
  


Current Time: Sat Dec 10 11:11:33 CST 2016

Total time taken to generate the page: 0.04585 seconds