Re: LD_LIBRARY_PATH in multi-home environment

EdStevens wrote:
> Just started my new job, and definately hit the ground running!
>
> Platform: Solaris 5.9
>
> We just installed Oracle 10.2 EE on a server that already has 8.1.7.4
> installed. This is my first time to actually get my hands on a
> multi-home box. Seeing how oraenv is handling PATH, ORACLE_HOME and
> ORACLE_SID ok, but have a question about LD_LIBRARY_PATH. It remains
> hard-coded to
> /db01/app/oracle/product/8.1.7/lib:/db01/app/oracle/product/8.1.7/ctx/lib
>
> Anything I should do with this?
>
> This box will have one 8.1.7.4 database and a couple of 10.2 db's.
>
>
> Thanks.
>
> - Ed Stevens

Second what hpuxrac says, personally I tend to have scripts that specifically set and unset the various environment variables, nestable so that users and apps can have their correct environments, developers can have their more strange environments, and admins can do all sorts of weird things (especially setting prompts and xterm coloration to keep all the weird stuff visually separate).

I've also seen large shops that try to have every .profile standardized to a single nfs, and that inevitably is not flexible enough for the changing environments bleeding edge dba's need.

Be real careful with LD_LIBRARY_PATH and similar, there are times when you don't want to set it. (I think the 10gR2 install checks this, for example). I think SHMLIB_PATH is hp-ux specific.

chatr $ORACLE_HOME/bin/oracle can be quite informative on hp-ux, ldd is the equivalent on solaris to see what is linked in. I think it becomes more important when you do stuff like run 32-bit on 64-bit environments, it's been too long since I've done stuff like that to remember. I think the situation you have is one where you have to hard code the correct libraries or you will get the wrong ones when when you try to start up 8i. You definitely want to know the installation environment is available in case you ever need to relink. I've been amazed at the hacking some places have done to copy an install from one machine to another, rather than just installing on the new machine.

Congrats on the new job!

jg

--
@home.com is bogus.
http://optymyst.com/underwood/psykomind/strange3.html - yes, even
cannibal child molesters quote Firesign Theatre.