I am just trying start the oracle 817 server , but i am not sure why i am getting thise V7 error . We have a oracle734 db also running in the same server.
here is my env for 817 database . I could see 734 PATH aslo
in PATH variable
I understand now. It seems 734 binaries path overriding 817 binaries path. You can troubleshoot later your path. As work around set ORACLE_SID and go /O_H817/bin and try to trigger 817 binaries from there. you don't need to set your path if your local dir path is /O_H817/bin.
Thanks , It did work .
Could you tell me what can i do for removing 734 directories from PATH env . I did execute a new 817 profile, still 734 directories are there.
To be precise, you don't need to have the ORACLE_HOME in your path. When you set ORACLE_SID and export ORACLE ENVIRONMENT by sourcing(C shell) /by exporting(K Shell) it checks and validate oratab and picks ORACLE_HOME from there.
You see my C-shell profile and how simple it is:
<font face=courier>
apps% more .cshrc
# @(#)cshrc 1.11 89/11/29 SMI
#
setenv LD_LIBRARY_PATH /opt/SUNWspro/lib:/usr/lib:/usr/openwin/lib:/usr/dt/lib
set path=(/opt/SUNWspro/bin /bin /usr/bin /usr/openwin/bin /usr/sbin /usr/ccs/bi
n /usr/ucb /opt/SUNWspro/bin /etc .)
Here Iam setting SID for a dummy sid name 815 to have TNS_ADMIN(NET8) pointing to 815 binaries, as I have other versions running on the same box. Whenever I want to connect to xyz sid all I do is:
$set ORACLE_SID=xyz
$source /usr/bin/coraenv
I can't troubleshoot your profile as you have lot other options over there. You figure out or consult unixadmin/one who set that profile for you.
Bookmarks