1 2 Previous Next 20 Replies Latest reply: May 10, 2012 12:28 AM by Kgronau-Oracle Go to original post RSS
      • 15. Re: Transparent Gateway for MSSQL
        The whole lnsrctl output looks as follow:

        C:\>lsnrctl start

        LSNRCTL for 32-bit Windows: Version - Production on 07-MAY-2012 19:09

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

        Starting tnslsnr: please wait...

        TNS-12560: TNS:protocol adapter error
        TNS-00530: Protocol adapter error

        Opatch output below:

        C:\product\11.1.0\tg_2\OPatch>opatch lsinventory -detail
        Invoking OPatch

        Oracle Interim Patch Installer version
        Copyright (c) 2007, Oracle Corporation.  All rights reserved.

        Oracle Home       : C:\product\11.1.0\tg_2
        Central Inventory : C:\Program Files (x86)\Oracle\Inventory
        from           : n/a
        OPatch version    :
        OUI version       :
        OUI location      : C:\product\11.1.0\tg_2\oui
        Log file location : C:\product\11.1.0\tg_2\cfgtoollogs\opatch\opatch2012-05-07_1

        Lsinventory Output file location : C:\product\11.1.0\tg_2\cfgtoollogs\opatch\lsi


        Installed Top-level Products (1):

        Oracle Database Gateways                                   
        There are 1 products installed in this Oracle Home.

        Installed Products (56):

        Agent Required Support Files                               
        Assistant Common Files                                     
        Bali Share                                                 
        Buildtools Common Files                                    
        Cluster Verification Utility Common Files                  
        Enterprise Manager Minimal Integration                     
        Enterprise Manager plugin Common Files                     
        Generic Connectivity Common Files                          
        HAS Common Files                                           
        Installation Common Files                                  
        Installer SDK Component                                    
        LDAP Required Support Files                                
        Oracle Clusterware RDBMS Files                             
        Oracle Code Editor                                         
        Oracle Core Required Support Files                         
        Oracle Database Gateway for Microsoft SQL Server           
        Oracle Database Gateways                                   
        Oracle Database User Interface                             
        Oracle Database Utilities                                  
        Oracle Extended Windowing Toolkit                          
        Oracle Globalization Support                               
        Oracle Globalization Support                               
        Oracle Help For Java                                        
        Oracle Ice Browser                                          
        Oracle Internet Directory Client                           
        Oracle Java Client                                         
        Oracle JDBC/OCI Instant Client                             
        Oracle JDBC/THIN Interfaces                                
        Oracle JFC Extended Windowing Toolkit                      
        Oracle LDAP administration                                 
        Oracle Locale Builder                                      
        Oracle Net                                                 
        Oracle Net Listener                                        
        Oracle Net Required Support Files                          
        Oracle Notification Service                                
        Oracle One-Off Patch Installer                             
        Oracle RAC Required Support Files-HAS                      
        Oracle Recovery Manager                                    
        Oracle Security Developer Tools                            
        Oracle Universal Installer                                 
        Oracle Wallet Manager                                      
        Parser Generator Required Support Files                    
        Perl Interpreter                                            
        Platform Required Support Files                            
        Precompiler Required Support Files                         
        RDBMS Required Support Files                               
        RDBMS Required Support Files for Instant Client            
        Required Support Files                                     
        Secure Socket Layer                                        
        Secure Socket Layer                                        
        SQL*Plus Files for Instant Client                          
        SSL Required Support Files for InstantClient               
        Sun JDK                                                     
        XDK Required Support Files                                 
        XML Parser for Java                                        
        There are 56 products installed in this Oracle Home.

        There are no Interim patches installed in this Oracle Home.


        OPatch succeeded.

        • 16. Re: Transparent Gateway for MSSQL
          The list of installed products looks good.

          What's the word size of your Windows operating system, are you using a 32bit or 64bit operating system (sorry if I asked this information again, but I didn't find an answer in the threads above).

          Let me get back to your listener.ora - can you comment save the current file in your gateway home\network\admin and create a new listener.ora file with only this content:
          LISTENER =
          <space> (DESCRIPTION_LIST =
          <space> (DESCRIPTION =
          <space> (ADDRESS_LIST =
          <space> (ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT = 1521))
          <space> )
          <space> )
          <space> )
          ADR_BASE_LISTENER =C:\product\11.1.0\tg_2\network\trace
          and please make sure that you really have at least one <space> at the marked lines.
          Then set again the environment variables and try to start the listener.

          When it fails again, then please look into the directory C:\product\11.1.0\tg_2\network\trace - there should be a listener trace file. Best would be to upload it to a free file hoster like dropbox - posting it to the thread is also fine.

          If you were able to start the listener above, then copy again the listener SID section to your listener.ora file and make sure to have also at least one space in front of the marked lines:
          <space>(SID_LIST =
          <space>(SID_DESC =
          <space>(SID_NAME = SQLSERVER)
          <space>(ORACLE_HOME = C:\product\11.1.0\tg_2)
          • 17. Re: Transparent Gateway for MSSQL

            My windows system is a 64 bit version - it could be the reason, are they compatybile?

            I've done what you suggested and the "start" command fails again but in the "trace" folder no file has been created. I also tried after that use a Oracle Net Manager and I turned on logging and tracing right there but again during attempt of running start command no file in indicated folders has been created. I also tried to use a trace level "user" and "administrator".

            • 18. Re: Transparent Gateway for MSSQL
              Using 32bit gateway software on 64bit Windows is not supported.

              Edited by: kgronau on May 8, 2012 9:34 AM

              The first 64bit gateway software is 11.2 and this 11.2 64bit software is certified for 64bit Windows.
              • 19. Re: Transparent Gateway for MSSQL
                Thanks a lot!

                I've reinstalled the gateway and now it works perfect!
                You are invaluable!

                • 20. Re: Transparent Gateway for MSSQL
                  Please mark this thread as answered.
                  1 2 Previous Next