Re: listener / tnsname / mystery (NT4 Oracle 7.3.4)

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Wed, 21 Jul 1999 08:22:28 GMT
Message-ID: <7n3vvu$mcn$1@nnrp1.deja.com>

Thanks for the feedback folks,

But I don't think I explained the problem.

I have 2 local databases. I want to simulate different replication methods (replication is not part of this problem). I need to be able to connect to db1 at one point in time, then to db2 later and so on.

To connect to different SIDs I am using tnsnames.ora. One alias for one db and another for the other.

Now here's the problem:

SVRMGR> connect internal_at_PINS
Password:
Connected.
SVRMGR> select * from v$database;
NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
--------- -------------------- ------------ ---------- ----------
PINS 07/13/99 09:13:04 NOARCHIVELOG 7075 7008 SVRMGR> connect internal_at_ORCL
Password:
Connected.
SVRMGR> select * from v$database;
NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
--------- -------------------- ------------ ---------- ----------
ORCL 07/08/99 15:17:08 NOARCHIVELOG 35928 35839 We can see that the alias in tnsname.ora is ok as I can connects to the database with the same name. So all is well. Then, later (and no change to tnsnames.ora or ORACLE_SID in the registry)........

SVRMGR> connect internal_at_ORCL
Password:
Connected.
SVRMGR> select * from v$database;
NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH
--------- -------------------- ------------ ---------- ----------
PINS 07/13/99 09:13:04 NOARCHIVELOG 7090 7074 This is the problem. Any ideas folks?

Regards
Tony

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 03:22:28 CDT