7 Replies Latest reply: Jul 4, 2013 1:19 AM by yoonas RSS

    Install Oracle XE on the same machine as Oracle EE

    user541023 - oracle

      Hi all,

       

      I have a version of Oracle 11g EE installed on my pc, but I would like to check out the Oracle XE for another purpose.

      I've read that it is possible to run both on one machine, but I couldn't find more info on configuring it with the Oracle EE listener . So both versions of Oracle would work.

      When I have installed XE without any configuration Oracle EE has stopped working.(I have installed Oracle XE on a different listener port too)

      Can anyone point me to some docs/ tutorials or give me some steps to do this.


      Regards

      Harsha

        • 1. Re: Install Oracle XE on the same machine as Oracle EE
          yoonas

          Hi,

           

          You have issues with database or listener?

          Please give us more info like what error you are getting when you try to start the database

           

          Regards

          Yoonas

          • 2. Re: Install Oracle XE on the same machine as Oracle EE
            user541023 - oracle

            I am not able to login to SQl developer.It's an issue with listener.I Configured the listener.ora so as to connect to both ports(one is for EE one is for XE).I also changed the same in tnsnames.ora file.

            When i try to connect through SQL developer I get error TNS 12560:(protocol adapter error)

            lsnrctl status:

            LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-JUL-2013 16:07

            :07

             

             

            Copyright (c) 1991, 2005, Oracle.  All rights reserved.

             

             

            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

            TNS-12557: TNS:protocol adapter not loadable

            TNS-12560: TNS:protocol adapter error

              TNS-00527: Protocol Adapter not loadable

             

             

            Regards

            Harsha

            • 3. Re: Install Oracle XE on the same machine as Oracle EE
              yoonas

              post listener.ora file

               

              cd to oracle xe home/bin and start/check status of listener(start listener from xe home), then run lsnrctl status

               

              cd to oracle ee home/bin and start/check status listener(start listener from ee home), then run lsnrctl status

              • 4. Re: Install Oracle XE on the same machine as Oracle EE
                user541023 - oracle

                My listener.ora:

                SID_LIST_LISTENER =

                  (SID_LIST =

                     (SID_DESC =

                      (SID_NAME = CLRExtProc)

                      (ORACLE_HOME = C:\Database\product\11.2.0\dbhome_2)

                      (PROGRAM = extproc)

                      (ENVS = "EXTPROC_DLLS=ONLY:C:\Database\product\11.2.0\dbhome_2\bin\oracell11.dll")

                    )

                     (SID_DESC =

                      (SID_NAME = PLSExtProc)

                      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)

                      (PROGRAM = extproc)

                    )

                    (SID_DESC =

                      (SID_NAME = CLRExtProc)

                      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)

                      (PROGRAM = extproc)

                    )

                  )

                 

                 

                LISTENER_ORCL =

                  (DESCRIPTION_LIST =

                    (DESCRIPTION =

                      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

                      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

                      (ADDRESS = (PROTOCOL = TCP)(HOST = HNARISET-LAP.oradev.oraclecorp.com)(PORT = 1522))

                    )

                  )

                 

                Now My EE instance is running but not XE.There's some problem with my OracleXETNSLSNR is not running.When i tried to start it from services.msc it's giving me an error.

                MY EETNSLSNR is started and working fine

                • 5. Re: Install Oracle XE on the same machine as Oracle EE
                  yoonas

                  The posted listener.ora is from EE home i guess.

                   

                   

                  The listner file is edited manually or you used utility to modify it?

                   

                   

                   

                   

                   

                   

                  post the output of lsnrctl status (go to both(ee/xe) installation bin($ORACLE_HOME/bin) and run from there or set environment variables properly and run from command prompt

                   

                   

                   

                   

                  Check the service of XE(database) is already running (use services.msc)

                   

                   

                   

                   

                  connect to xe database using sqlplus and see if you can connect successfully. As you have more than one installation set the ORACLE_SID and ORACLE_HOME properly

                   

                   

                   

                  set ORACLE_SID=XE(this is the default for xe if yours is different change it)

                  set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\

                  sqlplus / as sysdba

                  select banner from v$VERSION ;

                  • 6. Re: Install Oracle XE on the same machine as Oracle EE
                    user541023 - oracle

                    Posted listener file is from EE  and yes I edited manually.

                    Status from EE bin(the same from XE bin):

                     

                    C:\Database\product\11.2.0\dbhome_2\BIN>lsnrctl status

                    LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 04-JUL-2013 10:50:39

                    Copyright (c) 1991, 2010, Oracle.  All rights reserved.

                     

                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

                    STATUS of the LISTENER

                    ------------------------

                    Alias                     LISTENER

                    Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production

                    Start Date                04-JUL-2013 10:34:31

                    Uptime                    0 days 0 hr. 17 min. 27 sec

                    Trace Level               off

                    Security                  ON: Local OS Authentication

                    SNMP                      OFF

                    Listener Parameter File   C:\Database\product\11.2.0\dbhome_2\network\admin\listener.ora

                    Listener Log File         c:\database\diag\tnslsnr\HNARISET-LAP\listener\alert\log.xml

                    Listening Endpoints Summary...

                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HNARISET-LAP.oradev.oraclecorp.com)

                    PORT=1521)))

                    Services Summary...

                    Service "CLRExtProc" has 1 instance(s).

                      Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...

                    Service "PLSExtProc" has 1 instance(s).

                      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

                    Service "orcl2.oradev.oraclecorp.com" has 1 instance(s).

                      Instance "orcl2", status READY, has 1 handler(s) for this service...

                    Service "orcl2XDB.oradev.oraclecorp.com" has 1 instance(s).

                      Instance "orcl2", status READY, has 1 handler(s) for this service...

                    The command completed successfully

                     

                    I am able to connect to XE by sqlplus.I am not able to start OracleXETNSLSNR from services.msc

                     

                    set ORACLE_SID=XE(this is the default for xe if yours is different change it)

                    set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\

                    sqlplus / as sysdba

                              while trying this I got the error

                    Error 6 initializing SQL*Plus

                    SP2-0667: Message file sp1<lang>.msb not found

                    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

                     

                    Error 6 initializing SQL*Plus

                    SP2-0667: Message file sp1<lang>.msb not found

                    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

                     

                    my tnsnames.ora file:

                    LISTENER_ORCL =

                      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)

                       ADDRESS = (PROTOCOL = TCP)(HOST = HNARISET-LAP.oradev.oraclecorp.com)(PORT = 1522))

                     

                     

                    ORACLR_CONNECTION_DATA =

                      (DESCRIPTION =

                        (ADDRESS_LIST =

                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                        )

                        (CONNECT_DATA =

                          (SID = CLRExtProc)

                          (PRESENTATION = RO)

                        )

                      )

                     

                     

                    ORCL =

                      (DESCRIPTION =

                        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

                        (CONNECT_DATA =

                          (SERVER = DEDICATED)

                          (SERVICE_NAME = orcl2.oradev.oraclecorp.com)

                        )

                      )

                    XE =

                      (DESCRIPTION =

                        (ADDRESS = (PROTOCOL = TCP)(HOST = HNARISET-LAP.oradev.oraclecorp.com)(PORT = 1522))

                        (CONNECT_DATA =

                          (SERVER = DEDICATED)

                          (SERVICE_NAME = XE)

                        )

                      )

                     

                     

                    EXTPROC_CONNECTION_DATA =

                      (DESCRIPTION =

                        (ADDRESS_LIST =

                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

                        )

                        (CONNECT_DATA =

                          (SID = PLSExtProc)

                          (PRESENTATION = RO)

                        )

                      )

                     

                     

                    ORACLR_CONNECTION_DATA =

                      (DESCRIPTION =

                        (ADDRESS_LIST =

                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

                        )

                        (CONNECT_DATA =

                          (SID = CLRExtProc)

                          (PRESENTATION = RO)

                        )

                      )

                     

                    Note:I am not able to ping XE service using tnsping XE(TNS-12541: TNS:no listener).I am able to tnsping ORCL(EE)

                    Please tell me why my XETNS LSNR is n't working??

                    • 7. Re: Install Oracle XE on the same machine as Oracle EE
                      yoonas

                      set PATH=C:\oraclexe\app\oracle\product\11.2.0\server\bin;%PATH%

                      set ORACLE_SID=XE

                      set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server

                       

                      sqlplus / as sysdba

                      select banner from v$version;