| Listener for a remote database [message #66808] |
Mon, 20 January 2003 08:57  |
Dries
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
I hope this is the right board,, otherwise redirect me please.
I'll explain my problem first :
I have an nt network, only the server (nt4) has connection to the oracle database, the clients don't.
I need to be able to access the oracle server (via odbc) from the clients without altering anything in the network configuration.
I was thinking in the direction of :
setting up a net8 listener on the ntserver listening for incoming connections from the network, and getting the data from the remote database. Setting up odbc links to that listener on the clients in the network.
But : how do i set up a listener for a remote database? I always get a : TNS name not found error.
This is quite urgent...
Thnx, in advance
|
|
|
|
| Re: Listener for a remote database [message #66871 is a reply to message #66808] |
Wed, 19 February 2003 06:26  |
Satyanaryana reddy
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
Hi
If your client & server are resides on same machine y need not go for listener.If y want your client to connect to the remote server do follow the steps as follows
at client node
create TNS service name pointing to server machine,db service/instance port number and test it.
from client node tnsping -
hope this works out
Cheers
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
