sqlplus on Solaris ignoring $ORACLE_SID?
Posted on 2000-03-29
This really must be an easy question, but I need an answer quickly and
don't have the time to look deeper into this, so here it is:
We used to be running Oracle 8.0.5 on Solaris 2.7. When the
environment variable $ORACLE_SID was defined, it sufficed to issue the command:
$ sqlplus USER/PWD
i.e without connect string.
now we had to upgrade Oracle to 8.1.5. and downgrade Solaris to 2.6. All
of a sudden the above command results in an error message saying that
Oracle is not available. When I add the connect string:
$ sqlplus USER/PWD@DB
all works fine.
Can anyone tell me what triviality I am overlooking? If there is no
solution I will have to modify a zillion scripts!
Thanks for any help,