How to connect to a specific SID using sqlplus under Unix

A very easy way to connect to a specific SID (other than the default one) using sqlplus, is to make this SID “temporarily” the default SID.
Just change ORACLE_SID environment variable to the required SID name:
export ORACLE_SID=sid_name
Then connect using sqlplus to the default SID:
sqlplus / as sysdba
It may not be the ideal way, but it’s “simple and stupid” as  SoCRaT says 🙂

This entry was posted in Uncategorized and tagged . Bookmark the permalink.

1 Response to How to connect to a specific SID using sqlplus under Unix

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s