Re: Error running SQLPLUS after changing $ORACLE_BASE

"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
>

Anyone using softlinks for this and similar purposes, should get their hands chopped off, now.
I once lost a database because it was believed Oracle was installed two times. That was exactly the same type of softlink you had created.

Regards,

Sybrand Bakker, Oracle DBA Received on Fri Mar 30 2001 - 12:42:54 CST