Home » RDBMS Server » Networking and Gateways » Oracle Database Connectivity Remotely
Oracle Database Connectivity Remotely [message #66492] Fri, 05 July 2002 04:49 Go to next message
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?
Re: Oracle Database Connectivity Remotely [message #66495 is a reply to message #66492] Sat, 06 July 2002 00:45 Go to previous messageGo to next message
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
Re: Oracle Database Connectivity Remotely [message #66497 is a reply to message #66492] Sat, 06 July 2002 18:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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).
Re: Oracle Database Connectivity Remotely [message #66502 is a reply to message #66492] Mon, 08 July 2002 04:54 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: ORACLE LAN CONNECTION
Next Topic: Listener crash during database startup
Goto Forum:
  


Current Time: Thu Mar 28 18:00:24 CDT 2024