OraFAQ Forum: Forms » Connect to Remote Database

Home » Developer & Programmer » Forms » Connect to Remote Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect to Remote Database [message #196175]

Wed, 04 October 2006 07:16

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

Report message to a moderator

Re: Connect to Remote Database [message #196178 is a reply to message #196175]

Wed, 04 October 2006 07:30

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Connect to Remote Database [message #196187 is a reply to message #196178]

Wed, 04 October 2006 07:47

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.

Report message to a moderator

Re: Connect to Remote Database [message #196401 is a reply to message #196187]

Thu, 05 October 2006 03:54

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

Report message to a moderator

Re: Connect to Remote Database [message #196566 is a reply to message #196401]

Fri, 06 October 2006 00:20

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."

Report message to a moderator

Re: Connect to Remote Database [message #196614 is a reply to message #196566]

Fri, 06 October 2006 04:09

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

Report message to a moderator

Re: Connect to Remote Database [message #196941 is a reply to message #196614]

Mon, 09 October 2006 05:09

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

Report message to a moderator

Re: Connect to Remote Database [message #196955 is a reply to message #196175]

Mon, 09 October 2006 06:00

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

Report message to a moderator

Re: Connect to Remote Database [message #207060 is a reply to message #196955]

Mon, 04 December 2006 00:57

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

Report message to a moderator

Previous Topic:	OLE2 and DDE package books
Next Topic:	Use Application in 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 17:05:36 CST 2025