| 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?
|
|
|
|
| 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
|
|
|
|
|
|
| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
