Re: Connect to wrong database using SQL net!

Hello

Is your two databases running on same server. If so check

services in control panal which one is running (TNS Listener 8 or just Listener). Onlly one will run.

Go to Start -> run-> LSNRCTL-> you will get DOS scrren. Type for status

it will give you the services running (Basically SID's), if you didn't see any one

then manually edit the file in Oracle_home->Net80->Admin-> lISTENER.ORA file THEN EDIT ACCORDINGLY Add SID

    (SID_DESC =
      (SID_NAME = PROD)
    )
    (SID_DESC =
      (SID_NAME = DEVT) But be carefull editing this file. As a safer side copy listener file to a temp directory before you do any thing with this file. Even if any thing goes wrong you can put it back and start.

Also check youe sqlnet about hoststring whethere you are pointing to correct database

All the best

Eswar

In article <7d6v0b$r30$1_at_nnrp1.dejanews.com>,   yngm_at_my-dejanews.com wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 25 1999 - 21:55:15 CST