Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Error running SQLPLUS after changing $ORACLE_BASE
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 Fri Mar 30 2001 - 10:04:10 CST
![]() |
![]() |