Managing Multiple ORACLE_HOMES 11g db and 10g developer windows 7
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Managing Multiple ORACLE_HOMES 11g db and 10g developer windows 7

  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Managing Multiple ORACLE_HOMES 11g db and 10g developer windows 7

    Hi!I have installed Oracle 11gR2 with ORACLE_HOME=D:\app\product\11.2.0\dbhome_1 and Oracle 10g Developer with ORACLE_HOME=D:\DevSuiteHome2 on Windows 7

    However,I cannot work with both homes simultaneously.If I set ORACLE_HOME for the 10g Developer then I cannot log in to db as it gives me error Can't initialize OCI. Error -1 when logging in from Toad or error the procedure entry point longjmp could not be located in dynamic link library orauts.dll when logging through sqlplus on cmd prompt.Yet if I set ORACLE_HOME for db then I cannot launch Forms builder as I get error frm-18103 failed to initialize the development environment.

    How can I setup ORACLE_HOME so that I can work with both Developer and database at the same time?

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    You should set the ORACLE_HOME, LD_LIBRARY_PATH and TNS_ADMIN to point to 11gR2 with the %ORACLE_HOME%\bin directory at the front of the PATH. I don't think that SQL DEveloper needs the environment variables.

    Code:
    ORACLE_HOME=D:\app\product\11.2.0\dbhome_1
    LD_LIBRARY_PATH=D:\app\product\11.2.0\dbhome_1\lib
    TNS_ADMIN=D:\app\product\11.2.0\dbhome_1\network\ADMIN
    PATH=D:\app\product\11.2.0\dbhome_1\bin;%PATH%
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width