Multiple Oracle Home Issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Multiple Oracle Home Issues

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Multiple Oracle Home Issues

    Hello
    I Have Oracle 10gR2 in /u10/oracle/BASE/product/10.2.0.1 with 1 database.
    I now installed Oracle 11gR2 in /u10/oracle/BASE/product/11.2.0.1 and during the Installation of RDBMS, i selected the option to install sample database 'orcl'.

    The DBCA failed with an Error message ' ORA-12560: TNS:Protocol Adapter Error'.

    I changed my .profile to reflect the new Oracle Home before 11g Installation.
    here is how my .profile looks like.

    ORACLE_BASE=/u10/oracle/BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0.1
    ORACLE_SID=orcl
    LD_LIBRARY_PATH=$ORACLE_HOME/lib32
    LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
    PS1='[$USER:$PWD]'
    PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/bin:/usr/sbin/:/bin:/usr/ccs/bin:/usr/ucb:/etc:/usr/openwin/bin:/usr/local/bin:.:./admin
    export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH TNS_ADMIN NLS_LANG EDITOR


    Anyhelp is greatly appreciated. This is the First time, i am installating multiple Oracle Versions on a single Box in Solaris.

    Thanks
    Ron

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    tns_admin?

    What about TNS_ADMIN?
    Temporarily remove it.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    I removed TNS_ADMIN inside .profile , logged out and in and started DBCA. I still get the same error message. Here is my new .profile

    ORACLE_BASE=/u10/oracle/BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0.1
    ORACLE_SID=orcl
    LD_LIBRARY_PATH=$ORACLE_HOME/lib32
    LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
    PS1='[$USER:$PWD]'
    PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/bin:/usr/sbin/:/bin:/usr/ccs/bin:/usr/ucb:/etc:/usr/openwin/bin:/usr/local/bin:.:./admin
    export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH NLS_LANG EDITOR

    Thanks
    Ron

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    Why don't you set TNS_ADMIN to point to the right directory?
    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