Re: Oracle 9i 32bit and 64bit on the same server

[Arup Nanda]

Joshua,   You can have two users named "oracle" (the oracle 64-bit software owner) and "app1" (the app owner).   You will create 2 ORACLE_HOMEs, say /u01/oracle/product/9.2/64bit and /u01/oracle/product/9.2/32bit. In the .profile of the app1 owner, the ORACLE_HOME=/u01/oracle/product/9.2/32bit. When the time comes to start or shutdown the instance, you would excute   ORACLE_HOME=/u01/oracle/product/9.2/64bit ORACLE_SID=... PATH=$ORACLE_HOME/bin LD_LIBRARY_PATH=$ORACLE_HOME/lib sqlplus -s "/ as sysdba" << EOF shutdown immediate (or startup) EOF   That's it.   HTH   Arup       ----- Original Message ----- From: Joshua Becker To: Multiple recipients of list ORACLE-L Sent: Saturday, January 25, 2003 11:49 PM Subject: Oracle 9i 32bit and 64bit on the same server Hi all, I have a following problem I hope you could help me: I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version. Now we are also having an application which needs 32 bit 9i client software on the same server. The user who owns this application also needs every now and then shutdown and start the instances. How I should configure the profile of this application user. I have an oracle -account who "owns" the instances and the application user is also in dba -group. Thank you in advance, Joshua Gratis e-mail resten av livet p�: www.yahoo.se/mail Busenkelt!