This discussion is archived
6 Replies Latest reply: Sep 24, 2009 4:22 AM by Sven W. RSS

Why does it login to another database spontanously?

672680 Pro
Currently Being Moderated
I got three databases created on the same machine under the single Ora9i.
And when I do below, it goes as you see.
And my question is, why it login me to PLM when I do 'connect /as sysdba'? I would expect to login GTP as well.
is it normal or it is due to wrong configuration?

Any opinions are welcomed!
C:\Documents and Settings\e501967>sqlplus system/Phoenix@GTP.CORP.STATESTR.COM

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Sep 24 11:49:03 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

SQL> l
SP2-0223: No lines in SQL buffer.
SQL> select name from v$database;

NAME
---------
GTP

SQL> disconnect
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
SQL> connect /as sysdba
Connected.
SQL> l
  1* select name from v$database
SQL> /

NAME
---------
PLM

SQL> disconnect
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
SQL> connect /@GTP.CORP.STATESTR.COM as sysdba
Connected.
SQL> l
  1* select name from v$database
SQL> /

NAME
---------
GTP

SQL>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points