listener confusion

[Quoted] We had Oracle installed on a Sun cpu named Sun1 with ip xxx.xxx.xxx.2. We transferred the database to a new High Availability machine with 2 computers which we renamed the common name to Sun1 and changed the ip to the old machines ip xxx.xxx.xxx.2. The old machine was renamed to Sun2 and its ip was changed to xxx.xxx.xxx.3. Our main database is now running on Sun1 and the listener is turned only on Sun1. When we turn on a test database on Sun2 which has had its sid and database renamed, users that log onto the live database at Sun1 get logged into the test database on Sun2 even though the names are different, the ip addresses are different, the sids are different and the database names are different. No symbolic names are used either in listener.ora or tnsnames.ora. There are only hard coded ip addresses. Why is the live listener logging users into the test system? Any help would be appreciated.

David Received on Wed Jun 10 1998 - 00:00:00 CEST