If you have two databases on the same server, how to connect in SQL*Plus?
----------
C:\>set ORACLE_SID=orcl
C:\>echo %oracle_sid%
orcl
C:\>SQLPLUS /NOLOG
SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 30 12:26:08 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> show user;
USER is "SYS"
SQL>
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
ORCL
SQL>
C:\>set ORACLE_SID=orcl1
C:\>echo %oracle_sid%
orcl1
C:\>SQLPLUS /NOLOG
SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 30 12:26:08 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> show user;
USER is "SYS"
SQL>
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
ORCL1
SQL>
Comments
Post a Comment