This discussion is archived
10 Replies Latest reply: Nov 26, 2012 12:57 PM by 791081 RSS

oracle 11g client / oracle 10g express edition in one computer

457084 Newbie
Currently Being Moderated
Hi All,
I already have Oracle 11g Client installed in my computer. I wanted to Install Oracle 10g Express Edition in the same computer. So that I shall work with that even when I am not in the network. My Question is : Will installing both of 11g Client and 10g XE will cause conflict in my computer or is it ok to install both. Any suggestion/information is appreciated.
Regards,
RRR
  • 1. Re: oracle 11g client / oracle 10g express edition in one computer
    AndyPol Expert
    Currently Being Moderated
    No problem install XE and 11g on the same machine/system. You have to remember about tnsnames.ora files in XE and 11g homes have to be identical.
  • 2. Re: oracle 11g client / oracle 10g express edition in one computer
    Paul M. Oracle ACE
    Currently Being Moderated
    tnsnames.ora files in XE and 11g homes have to be identical.
    Even better having only one tnsnames.ora and use TNS_ADMIN environment variable.

    On one test machine I have 7 different Oracle products : should I have 7 tnsnames.ora ?
  • 3. Re: oracle 11g client / oracle 10g express edition in one computer
    457084 Newbie
    Currently Being Moderated
    What do you mean by using TNS_ADMIN environment? Can you please shed more light on that?
    Regards,
    RRR
  • 4. Re: oracle 11g client / oracle 10g express edition in one computer
    AndyPol Expert
    Currently Being Moderated
    If you work on WINDOWS OS

    You can run comand in cmd SET TNS_ADMIN=c:\path_to_your_tnsnames.ora_files

    If you need to set this env. variable permanently then,
    Try setting the TNS_ADMIN variable as a system environment variable.
    Go to my computer -> right click ->properties ->Advanced ->Click on Enviroment Variable -> Add
  • 5. Re: oracle 11g client / oracle 10g express edition in one computer
    Paul M. Oracle ACE
    Currently Being Moderated
    What do you mean by using TNS_ADMIN environment?
    Did you read the link ?
  • 6. Re: oracle 11g client / oracle 10g express edition in one computer
    457084 Newbie
    Currently Being Moderated
    I installed oracle xe. While connecting I am getting ORA-12154 Error.
  • 7. Re: oracle 11g client / oracle 10g express edition in one computer
    Paul M. Oracle ACE
    Currently Being Moderated
    What are you trying to do exactly ? please be specific.
  • 8. Re: oracle 11g client / oracle 10g express edition in one computer
    457084 Newbie
    Currently Being Moderated
    I already have a oracle 11g client installed in my machine. but i will be able to connect to this only when i am in the network. Say if i am not in network, i still wanted to connect to some database to connect my forms. So I tried installing Oracle 10g Express Edition so that i can connect to that when i am not in the network. After installing I tried connecting to the express edition saying user/password@xe. When i tried doing that i am getting the above error.
  • 9. Re: oracle 11g client / oracle 10g express edition in one computer
    hans forbrich Oracle ACE Director
    Currently Being Moderated
    Your Express Edition needs to be installed to use the LOOPBACK Adapter. Other than that, it'll work.

    Microsoft has a KB article describing how to install it. There are probably around 500 threads describing that in the category Database forums (one level up).

    A mild amount of search in internet or in forums for 'loopback adapter and XE' will also provide detailed instructions as well. (I know - I've written dozens.)
  • 10. Re: oracle 11g client / oracle 10g express edition in one computer
    791081 Newbie
    Currently Being Moderated
    Hi,

    i have installed oracle oraclient11g_home1, want to know the changes in tnsnames.ora.

    below tnsnames.ora file got created after installation. I dont know
    CONNECT_DATA=
              (SID=<oracle_sid>)
              [ (GLOBAL_NAME=<global_database_name>) ]


    -----------
    <alias>= [ (DESCRIPTION_LIST =  # Optional depending on whether u have
                        # one or more descriptions
                        # If there is just one description, unnecessary ]
         (DESCRIPTION=
         [ (SDU=2048) ]     # Optional, defaults to 2048
                        # Can take values between 512 and 32K
         [ (ADDRESS_LIST=    # Optional depending on whether u have
                        # one or more addresses
                        # If there is just one address, unnecessary ]
         (ADDRESS=
              [ (COMMUNITY=<community_name>) ]
              (PROTOCOL=tcp)
              (HOST=<hostname>)
              (PORT=<portnumber (1521 is a standard port used)>)
         )
         [ (ADDRESS=
              (PROTOCOL=ipc)
              (KEY=<ipckey (PNPKEY is a standard key used)>)     
              )
         ]
         [ (ADDRESS=
              [ (COMMUNITY=<community_name>) ]
              (PROTOCOL=decnet)
              (NODE=<nodename>)
              (OBJECT=<objectname>)
              )
         ]
    ... # More addresses
         [ ) ] # Optional depending on whether ADDRESS_LIST is used or not
         [ (CONNECT_DATA=
              (SID=<oracle_sid>)
              [ (GLOBAL_NAME=<global_database_name>) ]
         )
         ]
         [ (SOURCE_ROUTE=yes) ]
         )
         (DESCRIPTION=
         [ (SDU=2048) ]     # Optional, defaults to 2048
                        # Can take values between 512 and 32K
         [ (ADDRESS_LIST= ]     # Optional depending on whether u have more
                        # than one address or not
                        # If there is just one address, unnecessary
         (ADDRESS
              [ (COMMUNITY=<community_name>) ]
              (PROTOCOL=tcp)
              (HOST=<>)
              (PORT=<1521>)
         )
         [ (ADDRESS=
              (PROTOCOL=ipc)
              (KEY=<ipckey (PNPKEY is a standard key used)>)
         )
         ]
         ...           # More addresses
         [ ) ]           # Optional depending on whether ADDRESS_LIST
                        # is being used
         [ (CONNECT_DATA=
              (SID=<oracle_sid>)
              [ (GLOBAL_NAME=<global_database_name>) ]
         )
         ]
         [ (SOURCE_ROUTE=yes) ]
         )
         [ (CONNECT_DATA=
         (SID=<oracle_sid>)
         [ (GLOBAL_NAME=<global_database_name>) ]
         )
         ]
         ... # More descriptions
         [ ) ]     # Optional depending on whether DESCRIPTION_LIST is used or not

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points