nexus wrote:
>
> Hello all,
>
> Here's my problem:
>
> 2 db instances on 1 SOlaris machine,
> ORACLE_SID has been exported to the db I wish to connect to.
> listener.ora and tnsnames and sqlnet.ora are in /var/opt/oracle (as symlinks
> to $ORACLE_BASE/network/admin/...)
>
> when typing the full login (i.e: user/login_at_dbsid) I get in with both DBs
> when simply typing sqlplus, I get a prompt but I can log in (not even with
> system/manager) I get a ORACLE not available message.
>
> Can someone help?
This message is correct. What is your Oracle environment when trying to
connect in the second manner (env | grep ORA)? Yu will need to set your
ORACLE_SID (among other environment vars).
--
Ron Reidy
Oracle DBA
Received on Thu Aug 29 2002 - 06:10:07 CDT
