OraFAQ Forum: Networking and Gateways » Oracle Database Connectivity Remotely

Home » RDBMS Server » Networking and Gateways » Oracle Database Connectivity Remotely

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

Oracle Database Connectivity Remotely [message #66492]

Fri, 05 July 2002 04:49

Shankha
Messages: 1
Registered: July 2002

Junior Member

Hello,

I have a database running on a machine which is live in the internet using a static IP.I want to connect to the machine using a dialup.

How can I do it?

Can anyone help in this matter?

Report message to a moderator

Re: Oracle Database Connectivity Remotely [message #66495 is a reply to message #66492]

Sat, 06 July 2002 00:45

K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore

Senior Member

SIR,

CONNECT THE SYSTEM WITH THE INTERNET USING MODEM.THEN EDIT YOUR TNSNAMES.ORA FILE FOR THAT DATABASE(I.E CREATE ONE TNSNAMES.ORA ENTRY FOR THAT DATABASE).THEN CONNECT THE DATABASE USING SQLPLUS.IT WILL WORKS.

K.SREENIVASAN

Report message to a moderator

Re: Oracle Database Connectivity Remotely [message #66497 is a reply to message #66492]

Sat, 06 July 2002 18:36

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can talk to your database if you can do what Sreenivasan has said.
If you dont have an oracle client installed,
then you can just telnet to the remote machine and
connect to the datbase as the local user. But you cant do any gui kind of operations ( unless u have telnet software like Hummingbird Exceed).

Report message to a moderator

Re: Oracle Database Connectivity Remotely [message #66502 is a reply to message #66492]

Mon, 08 July 2002 04:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Try to "ping" the ip address or hostname from the client(your pc).
reply should be OK.
then
Create the tnsnames.ora entries, create host_string and try 'TNSPING
<HOSTRING> ' From your PC.
for example, if
use mag/mag@highprod
to connect to the database locally or inside the network, i would test
the connection from the remote site
as ( once the tnsnames.ora entries are made)

tnsping highprod

this shoould also work fine.
Else
Check the timing response and see if it is acceptable.
If it is not, then you may need to increase the
CONNECT_TIMEOUT_<listener_name> value in the listener.ora file on the
Server. Doing this will correct the connectivity problem, but may be
masking the real problem of the physical network.

Report message to a moderator

Previous Topic:	ORACLE LAN CONNECTION
Next Topic:	Listener crash during database startup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 23:22:10 CDT 2025