Re: SIDs and connectivity

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Jul 2005 13:45:57 -0700
Message-ID: <1122151557.313590.67610@g43g2000cwa.googlegroups.com>

If you are on the same machine as the database then by clearning the TWO_TASK environment variable and setting the $ORACLE_SID variable you can connect as sysdba providing you are a member of the database group.

You can also set the value of TWO_TASK or provide the tnsnames.ora Service name on the connect string to connect to any available instance, local or remove, without having to worry about the setting of $ORACLE_SID however $ORACLE_HOME should be set so that the OS can find sqlplus.

sqlplus username_at_service_name

HTH -- Mark D Powell -- Received on Sat Jul 23 2005 - 15:45:57 CDT