This discussion is archived
1 2 Previous Next 20 Replies Latest reply: May 9, 2012 10:28 PM by kgronau Go to original post RSS
  • 15. Re: Transparent Gateway for MSSQL
    933354 Newbie
    Currently Being Moderated
    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
    kgronau Guru
    Currently Being Moderated
    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:
    <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
    933354 Newbie
    Currently Being Moderated

    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
    kgronau Guru
    Currently Being Moderated
    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
    933354 Newbie
    Currently Being Moderated
    Thanks a lot!

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

  • 20. Re: Transparent Gateway for MSSQL
    kgronau Guru
    Currently Being Moderated
    Please mark this thread as answered.
1 2 Previous Next


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