Re: Error running SQLPLUS after changing $ORACLE_BASE

IF you've moved homes, you should check /var/opt/oracle/oratab (or similar) and make sure the correct Oracle pathname is there. Also, check listener....

ps. symbolic links - that can't be a good idea...

"Sri" <schebrol_at_camail.harvard.edu> wrote in message news:3AC4AE7A.1438D6E2_at_camail.harvard.edu...
> We have Oracle installed under /users/oracle/.../.. . In the process of
> moving oracle
> home to some other directory, I have made a softlink /opt/oracle
> pointing to
> /users/oracle which is the $ORACLE_BASE. After modifying the .profile
> and
> other environment settings to point to /opt/oracle, I have shutdown the
> server and
> listener and started them with new settings.
>
> I am able to use svrmgrl and connect internal and select from any
> v$tables.
> But when I tried to use sqlplus uname/passwd_at_sid, sqlplus returns error
> ERROR:
> ORA-01034: ORACLE not available
>
> I am getting the same error from any client machine. I have 8.0.5
> running on
> SunSolaris. I have changed settings back to original installation
> directory in .profile,
> and restarted oracle everything is working fine. Before I move the
> oracle home,
> I would like to have server running with new softlink.
>
> Could someone pls tell me what else has to be modified to make the new
> softlink
> to ORACLE_BASE working.
>
> Thanks,
>
> Sri
>
Received on Mon Apr 02 2001 - 05:10:06 CDT