10 Replies Latest reply: Nov 26, 2012 2:57 PM by user9974866 RSS

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

    457084
      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
          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.
            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
              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
                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.
                  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
                    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.
                      What are you trying to do exactly ? please be specific.
                      • 8. Re: oracle 11g client / oracle 10g express edition in one computer
                        457084
                        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
                          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
                            user9974866
                            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