Home » RDBMS Server » Networking and Gateways » Curious pb with Net8
Curious pb with Net8 [message #66472] Thu, 27 June 2002 03:55 Go to next message
Mat
Messages: 22
Registered: November 2001
Junior Member
Hi,

I have got a strange pb on a linux box with Oracle
8.1.6:
I have configured my tnsnames.ora to connect to 2
databases : DB1 and DB2. The problem is whatever I
use connect john/doe@DB1 or connect john/doe@DB2 I am
always connected to DB1.
When I check with lsnrctl services, I see one
connexion to DB1 and one connexion to DB2 !!!
Did anyone see this pb yet ?
Pb solved... [message #66474 is a reply to message #66472] Fri, 28 June 2002 02:40 Go to previous messageGo to next message
Math
Messages: 1
Registered: June 2002
Junior Member
The listener.ora was not at the right place
and TNS_ADMIN was not set.
Oracle seemed to start the listener anyway -
with a default conf file (I didn't see that
in the Oracle doc!) - but the listener didn't
run correctly.
Moving the listener.ora in
$ORACLE_HOME/network/admin has solved this
pb.
Sorry :-|
Re: Curious pb with Net8 [message #66477 is a reply to message #66472] Sun, 30 June 2002 12:09 Go to previous message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
HAI,

PLEASE CHECK YOUR TNSNAMES.ORA FILE.I.E CHECK THE HOST NAME.

K.SREENIVASAN
Previous Topic: Database link
Next Topic: TNS using hostname VS ip address
Goto Forum:
  


Current Time: Thu Mar 28 16:39:49 CDT 2024