Re: instance

From: DA Morgan <>
Date: Fri, 22 Feb 2008 20:16:17 -0800
Message-ID: <>

nick wrote:
> When you use the sql*plus connect command, how does sql*plus know
> which instance to connect you to? Does this depend on the value of the
> ORACLE_SID variable?

Depends on what you specify as a connect string.

If none then ORACLE_SID. Otherwise the mapping in your TNSNAMES.ORA.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Feb 22 2008 - 22:16:17 CST

Original text of this message