Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect to wrong database using SQL net!
Check your tnsnames.ora settings.
yngm_at_my-dejanews.com wrote in message <7d6v0b$r30$1_at_nnrp1.dejanews.com>...
>Hi, We have two databases with sid UAT and PROD which installed on NT4.0
>service with Service Pack 4. We use listener 2.3.4 to listen the two
>database. The UAT database is oracle enterprise server 8.0.5.1 and the PROD
>is 7.3.4. We connect the PROD using SQL+ 3.3.4 by use
>loginname/password_at_prod, however, we can't connect PROD.However, if we use
>username/password_at_prod where the username is the user of UAT and it can
>connect to UAT but not PROD even we use @prod i.e. we connect to the wrong
>database. Moreover, some time later, we can connect to PROD correctly, but
we
>don't know why and when? Please help! TIA.
>
>Best Regrads,
>Man
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Mar 24 1999 - 18:00:19 CST