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 11.1.0.7.0 - Production on 07-MAY-2012 19:09
    +:57+

    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 11.1.0.6.2

    Oracle Interim Patch Installer version 11.1.0.6.2
    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    : 11.1.0.6.2
    OUI version       : 11.1.0.7.0
    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
    +9-13-39PM.log+

    Lsinventory Output file location : C:\product\11.1.0\tg_2\cfgtoollogs\opatch\lsi
    nv\lsinventory2012-05-07_19-13-39PM.txt

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

    Installed Top-level Products (1):

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


    Installed Products (56):

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


    There are no Interim patches installed in this Oracle Home.


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


    OPatch succeeded.



    R.
    Lukasz
  • 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:
    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
    TRACE_LEVEL_LISTENER=SUPPORT
    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:
    SID_LIST_LISTENER =
    <space>(SID_LIST =
    <space>(SID_DESC =
    <space>(SID_NAME = SQLSERVER)
    <space>(ORACLE_HOME = C:\product\11.1.0\tg_2)
    <space>(PROGRAM=dg4msql)
    <space>)
    <space>)
  • 17. Re: Transparent Gateway for MSSQL
    933354 Newbie
    Currently Being Moderated
    Hi!

    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".

    Thanks,
    Lukasz
  • 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!

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

Legend

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