9 Replies Latest reply: Dec 19, 2012 4:27 AM by Mkirtley-Oracle RSS

    Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535

    979067
      Oracle 11g r2- 64bits
      Oracle Transparent Gateway - 64bits


      Oracle > C:\app\admsetape\product\11.2.0\dbhome_1
      Oracle Database Gateway for MS SQL Server (11.2.0.1.0) > C:\product\11.2.0\tg_1



      ****************************************************************************
      *Configuration of file Listener.ora [gateway] >* : C:\product\11.2.0\tg_1\NETWORK\ADMIN

      ****************************************************************************
      SID_LIST_LISTENERMSSQL =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = dg4msql)
      (ORACLE_HOME = C:\product\11.2.0\tg_1)
      (PROGRAM = dg4msql)
      )
      )

      LISTENERMSSQL =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM.BR)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      )
      )






      *******************************************************************************************
      *Configuration of file Tnsnames.ora [oracle] >* : C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN

      *******************************************************************************************

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM.BR)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.SETAPE.COM.BR)
      )
      )


      dg4msql=
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.SETAPE.COM.BR)(PORT = 1522))
      (CONNECT_DATA =
      (SID=dg4msql)
      )
      (HS=OK)
      )


      ************************************************************************
      *Configuration of file initdg4msql.ora [Gateway] >* : C:\product\11.2.0\tg_1\dg4msql\admin

      *************************************************************************
      # This is a customized agent init file that contains the HS parameters
      # that are needed for the Database Gateway for Microsoft SQL Server

      #
      # HS init parameters
      #
      HS_FDS_CONNECT_INFO=S015145.SETAPE.COM.BR//Teste
      HS_FDS_TRACE_LEVEL=OFF
      HS_FDS_RECOVERY_ACCOUNT=RECOVER
      HS_FDS_RECOVERY_PWD=RECOVER




      *********************
      Test file Tnsnames.ora

      *********************

      TNSPING ORCL

      Microsoft Windows [versão 6.1.7601]
      Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

      C:\Users\admsetape.SETAPE>TNSPING ORCL

      TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2
      012 12:02:19

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

      Arquivos de parÔmetros usados:
      C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora


      Usado o adaptador TNSNAMES para resolver o apelido
      Tentativa de contatar (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.
      SETAPE.COM.BR)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
      = orcl.SETAPE.COM.BR)))
      OK (0 ms)

      C:\Users\admsetape.SETAPE>


      TNSPING dg4msql

      Microsoft Windows [versão 6.1.7601]
      Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

      C:\Users\admsetape.SETAPE>TNSPING ORCL

      TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2
      012 12:02:19

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

      Arquivos de parÔmetros usados:
      C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora


      Usado o adaptador TNSNAMES para resolver o apelido
      Tentativa de contatar (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.
      SETAPE.COM.BR)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
      = orcl.SETAPE.COM.BR)))
      OK (0 ms)

      C:\Users\admsetape.SETAPE>




      Microsoft Windows [versão 6.1.7601]
      Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

      C:\Users\admsetape.SETAPE>sqlplus / as sysdba

      SQL*Plus: Release 11.2.0.1.0 Production on Ter Dez 18 12:06:15 2012

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


      ********************************
      Test DBLINK >

      create public database link DBLINK
      connect to SA identified by admsetape
      * using 'dg4msql'*

      *******************************

      Conected :
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

      SQL> SELECT
      2 * FROM x@DBLINK;
      * FROM x@DBLINK
      *
      ERRO na linha 2:
      ORA-28545: erro diagnosticado pelo Net8 ao conectar com um agente
      Unable to retrieve text of NETWORK/NCR message 65535
      ORA-02063: precedendo 2 lines a partir de DBLINK



      SQL>
        • 1. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
          Mkirtley-Oracle
          Hi,
          Your configuration files look okay but are you able to run a successful -

          tnsping dg4msql

          You have shown a tnsping for ORCL but not dg4msql.

          The ORA-28545 error can have different causes.
          For the database link you need to use double quotes round the user and password because SQL*Server is case sensitive, so it should be -

          create public database link DBLINK connect to "SA" identified by "admsetape" using 'dg4msql' ;

          and make sure the user and password are in the same case as on SQL*Server.
          If the listener is starting a gateway process then can you set up gateway denbug tracing - change -

          HS_FDS_TRACE_LEVEL=OFF

          to

          HS_FDS_TRACE_LEVEL=255

          and run a select from a new SQLPLUS session, then end the session.
          the trace file will be in C:\product\11.2.0\tg_1\dg4msql\trace.
          Post the trace file.

          Regards,
          Mike
          • 2. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
            979067
            Hello, thanks for reply.


            The tnsping of dg4msql is listed as follows:

            Microsoft Windows [versão 6.1.7601]
            Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

            C:\Users\admsetape.SETAPE>tnsping dg4msql

            TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2
            012 12:57:35

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

            Arquivos de parÔmetros usados:
            C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora


            Usado o adaptador TNSNAMES para resolver o apelido
            Tentativa de contatar (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = S015145.
            SETAPE.COM.BR)(PORT = 1522)) (CONNECT_DATA = (SID=dg4msql)) (HS=OK))
            OK (10 ms)

            C:\Users\admsetape.SETAPE>



            ----

            Trace: I can not open the trace, says it is corrupted.

            I performed the requested change, the return remains the same:

            ORA-28545: error diagnosed by Net8 when connecting to an agent
            Unable to retrieve text of NETWORK/NCR message 65535



            I have no idea what might be causing it.
            • 3. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
              Mkirtley-Oracle
              Hi,
              Thanks for making the changes and confirming the tnsping works.
              We need to go through some checks to try and find why the problem is happening.

              1. I have seen corrupted gateway trace files before. Can you confirm you installed the 64-bit DG4MSQL software and not the 32-bit version ? How are you trying to open the trace file and what is the name of the file ?

              2. Can you check the log for the gateway listener LISTENERMSSQL or post here. For the dg4msql connection it will either say something like 'Establish rc=0' or give an error message.

              3. From a command line can you stop and start the LISTENERMSSQL listener and post the output here ?

              4. From a command line go to the directory -

              C:\product\11.2.0\tg_1\bin

              and run the executable -

              dg4msql

              Does it run successfully ?

              Regards,
              Mike
              • 4. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
                979067
                *1. I have seen corrupted gateway trace files before. Can you confirm you installed the 64-bit DG4MSQL software and not the 32-bit version ? How are you trying to open the trace file and what is the name of the file ?*

                I confirm, yes, is x64. On documentation show: Oracle Database Gateway 11g release2(11.2) for M.W x64 (64-bit).
                The name of trace is [dg4msql_agt_12232.trc] i'm trying by the [SQL Server Profile]

                @edit
                I visualized dates, and no trace is being generated with the current date


                *2. Can you check the log for the gateway listener LISTENERMSSQL or post here. For the dg4msql connection it will either say something like 'Establish rc=0' or give an error message.*

                Not exists file of log on the folder: C:\product\11.2.0\tg_1\NETWORK\log

                Is this ?


                *3-From a command line can you stop and start the LISTENERMSSQL listener and post the output here ?*

                Microsoft Windows [versão 6.1.7601]
                Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

                C:\Users\admsetape.SETAPE>lsnrctl stop LISTENERMSSQL

                LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2012 13:42
                :37

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

                TNS-01101: Could not find the name

                But the service is active in: Windows> Services.


                *4. From a command line go to the directory* -


                C:\Users\admsetape.SETAPE>cd c:\

                c:\>cd product\11.2.0\tg_1\bin

                c:\product\11.2.0\tg_1\BIN>dg4msql


                Oracle Corporation --- TERÃA-FEIRA DEZ 18 2012 13:46:58.078

                Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with
                Oracle Database Gateway for MSSQL



                c:\product\11.2.0\tg_1\BIN>


                C:\Users\admsetape.SETAPE>


                ********

                I'm sorry I do not have familiarity with Oracle, but I need this link. And also thank you for your the help.

                Edited by: Everton. on 18/12/2012 08:13
                • 5. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
                  Mkirtley-Oracle
                  Hi,
                  If you cannot find the LISTENERMSSQL listener then make sure the gateway ORACLE_HOME/bin directory is in the path before any other Oracle installs.
                  On my system the listner log is in the directory -

                  Log messages written to C:\product\11.2.0\tg_3\diag\tnslsnr\mkirtley-uk\listener\alert\log.xml

                  so you should be able to find the equivalent on your system. Or if you get the listener stopped and started the messages detail where the files are located.

                  Regards,
                  Mike
                  • 6. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
                    979067
                    *1. How are you trying to open the trace file and what is the name of the file ?*

                    Mon Dec 17 13:52:39 2012
                    Create Relation ADR_CONTROL
                    Create Relation ADR_INVALIDATION
                    Create Relation INC_METER_IMPT_DEF
                    Create Relation INC_METER_PK_IMPTS
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_4792_7868.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=4792
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    17-DEZ-2012 13:52:42 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=admsetape))(COMMAND=status)(ARGUMENTS=64)(SERVICE=MSSQL)(VERSION=186646784)) * status * 0
                    Mon Dec 17 13:55:04 2012
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_10048_7960.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=10048
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Mon Dec 17 14:10:34 2012
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_8480_9988.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=8480
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Mon Dec 17 14:18:49 2012
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_6776_4000.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=6776
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Mon Dec 17 14:28:10 2012
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_6396_6052.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=6396
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Mon Dec 17 14:42:16 2012
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_3700_10224.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=3700
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Mon Dec 17 15:52:07 2012
                    17-DEZ-2012 15:52:07 * ping * 0
                    Mon Dec 17 15:52:56 2012
                    17-DEZ-2012 15:52:56 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=59795)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    17-DEZ-2012 15:52:56 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=59796)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Mon Dec 17 15:53:53 2012
                    17-DEZ-2012 15:53:53 * ping * 0
                    Mon Dec 17 16:01:53 2012
                    17-DEZ-2012 16:01:53 * ping * 0
                    17-DEZ-2012 16:02:01 * ping * 0
                    Mon Dec 17 16:02:15 2012
                    17-DEZ-2012 16:02:15 * ping * 0
                    Mon Dec 17 16:19:18 2012
                    17-DEZ-2012 16:19:18 * ping * 0
                    Tue Dec 18 09:42:49 2012
                    18-DEZ-2012 09:42:49 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=58384)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 09:42:49 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.66)(PORT=58385)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 09:42:49 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=58386)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 09:42:49 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.66)(PORT=58387)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 10:09:45 2012
                    18-DEZ-2012 10:09:45 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60524)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:09:45 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=60525)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:09:45 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60526)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:09:45 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=60527)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 10:12:02 2012
                    18-DEZ-2012 10:12:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60675)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:12:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=60676)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:12:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60677)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:12:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=60678)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 10:12:14 2012
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_8528_12984.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=8528
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Tue Dec 18 10:12:29 2012
                    18-DEZ-2012 10:12:29 * ping * 0
                    18-DEZ-2012 10:12:35 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60729)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:12:35 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=60730)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:12:36 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60731)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:12:36 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=60732)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 10:25:38 2012
                    18-DEZ-2012 10:25:38 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=61685)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:25:38 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=61686)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:25:38 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=61687)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:25:38 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=61688)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 10:53:39 2012
                    18-DEZ-2012 10:53:39 * ping * 0
                    Tue Dec 18 10:56:54 2012
                    18-DEZ-2012 10:56:54 * ping * 0
                    Tue Dec 18 10:57:07 2012
                    18-DEZ-2012 10:57:07 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=63574)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:57:07 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=63575)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:57:07 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=63576)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:57:07 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=63577)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 10:58:21 2012
                    18-DEZ-2012 10:58:21 * ping * 0
                    18-DEZ-2012 10:58:25 * ping * 0
                    Tue Dec 18 10:58:51 2012
                    18-DEZ-2012 10:58:51 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=63711)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:58:51 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=63712)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:58:51 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=63713)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 10:58:51 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=63714)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 11:25:51 2012
                    O arquivo de parâmetros do sistema é C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
                    Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\alert\log.xml
                    Informações de rastreamento gravadas para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\mssql\trace\ora_8908_14104.trc
                    O nível de rastreamento atualmente é 0

                    Iniciado com pid=8908
                    Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                    Listener completed notification to CRS on start

                    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Tue Dec 18 11:27:04 2012
                    18-DEZ-2012 11:27:04 * ping * 0
                    Tue Dec 18 11:27:33 2012
                    18-DEZ-2012 11:27:33 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=50380)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:27:33 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=50381)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:27:33 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=50382)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:27:33 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=50383)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:27:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=50397)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:27:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=50398)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:27:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=50399)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:27:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=50400)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 11:35:57 2012
                    18-DEZ-2012 11:35:57 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=50917)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:35:57 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=50918)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:35:57 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=50919)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:35:57 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=50920)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 11:58:20 2012
                    18-DEZ-2012 11:58:20 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=52404)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 11:58:20 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=52405)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 12:03:01 2012
                    18-DEZ-2012 12:03:01 * ping * 0
                    Tue Dec 18 12:04:31 2012
                    18-DEZ-2012 12:04:31 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=52743)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 12:04:31 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=52744)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 12:05:50 2012
                    18-DEZ-2012 12:05:50 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=52816)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 12:05:50 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=52817)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 12:06:29 2012
                    18-DEZ-2012 12:06:29 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=52850)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 12:06:29 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=52851)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 12:52:16 2012
                    18-DEZ-2012 12:52:16 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=55366)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 12:52:16 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=55367)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 12:52:16 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=55368)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 12:52:16 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=55369)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 12:57:35 2012
                    18-DEZ-2012 12:57:35 * ping * 0
                    Tue Dec 18 13:00:11 2012
                    18-DEZ-2012 13:00:11 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=55908)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 13:00:11 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=55909)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 13:03:05 2012
                    18-DEZ-2012 13:03:05 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=56141)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    18-DEZ-2012 13:03:05 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=56142)) * establish * dg4msql * 12505
                    TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                    Tue Dec 18 13:05:02 2012
                    18-DEZ-2012 13:05:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=56239)) * establish * dg4msql * 12505
                    • 7. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
                      979067
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:05:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=56240)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:05:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=56241)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:05:02 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=56242)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      Tue Dec 18 13:09:31 2012
                      18-DEZ-2012 13:09:31 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=56561)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:09:31 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.117)(PORT=56562)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      Tue Dec 18 13:57:03 2012
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60197)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::3400:3291:3f57:fdbd%13)(PORT=60198)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.66)(PORT=60199)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2001:0:9d38:6ab8:3400:3291:3f57:fdbd)(PORT=60200)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=60202)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::3400:3291:3f57:fdbd%13)(PORT=60203)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.66)(PORT=60204)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 13:57:03 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2001:0:9d38:6ab8:3400:3291:3f57:fdbd)(PORT=60205)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      Tue Dec 18 14:12:42 2012
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=61572)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::3400:3291:3f57:fdbd%13)(PORT=61573)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.66)(PORT=61574)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2001:0:9d38:6ab8:3400:3291:3f57:fdbd)(PORT=61575)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=61577)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::3400:3291:3f57:fdbd%13)(PORT=61578)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.66)(PORT=61579)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 14:12:42 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=S015145)(USER=admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2001:0:9d38:6ab8:3400:3291:3f57:fdbd)(PORT=61580)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      Tue Dec 18 15:19:16 2012
                      18-DEZ-2012 15:19:16 * ping * 0
                      Tue Dec 18 15:21:50 2012
                      18-DEZ-2012 15:21:50 * ping * 0
                      Tue Dec 18 15:24:25 2012
                      18-DEZ-2012 15:24:25 * ping * 0
                      Tue Dec 18 15:24:47 2012
                      18-DEZ-2012 15:24:47 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::b54e:aa8b:625a:3974%12)(PORT=50456)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 15:24:47 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::3040:16ee:3f57:fd86%13)(PORT=50457)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 15:24:47 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.121)(PORT=50458)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      18-DEZ-2012 15:24:47 * (CONNECT_DATA=(SID=dg4msql)(CID=(PROGRAM=)(HOST=SETAPE\S015145)(USER=SETAPE\admsetape))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2001:0:9d38:953c:3040:16ee:3f57:fd86)(PORT=50459)) * establish * dg4msql * 12505
                      TNS-12505: TNS:listener is not aware about the SID currently informed in connect descriptor
                      Tue Dec 18 15:34:26 2012
                      Não há mais atendimento em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                      Listener completed notification to CRS on stop
                      18-DEZ-2012 15:34:26 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=admsetape))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listenermssql)(VERSION=186646784)) * stop * 0


                      *3-From a command line can you stop and start the LISTENERMSSQL listener and post the output here ?*

                      STOP

                      Microsoft Windows [versão 6.1.7601]
                      Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

                      C:\Users\admsetape.SETAPE>LSNRCTL STOP LISTENERMSSQL

                      LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2012 15:56
                      :07

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

                      Estabelecendo conexÒo com (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=S015145.SETA
                      PE.COM.BR)(PORT=1522)))
                      The command was executed successfully

                      C:\Users\admsetape.SETAPE>



                      START

                      C:\Users\admsetape.SETAPE>LSNRCTL START LISTENERMSSQL

                      LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2012 15:56
                      :35

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

                      Starting tnslsnr: loading...

                      TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
                      O arquivo de parÔmetros do sistema Ú C:\app\admsetape\product\11.2.0\dbhome_1\NE
                      TWORK\ADMIN\listener.ora
                      Mensagem de log gravada para c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\listene
                      rmssql\alert\log.xml
                      Atendendo em: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(P
                      ORT=1522)))

                      Estabelecendo conexÒo com (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=S015145.SETA
                      PE.COM.BR)(PORT=1522)))
                      STATUS do LISTENER
                      ------------------------
                      Apelido LISTENERMSSQL
                      VersÒo TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                      ction
                      Data Inicial 18-DEZ-2012 15:56:38
                      Funcionamento 0 dias 0 hr. 0 min. 3 seg
                      NÝvel de Anßlise off
                      Seguranþa ON: Local OS Authentication
                      SNMP OFF
                      Arq. ParÔm. Listn. C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\lis
                      tener.ora
                      Arq. Log Listener c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\listenermssql\a
                      lert\log.xml
                      Resumo de Atendimento...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)))
                      Resumo de Serviþos...
                      O serviþo "dg4msql" tem 1 instÔncia(s).
                      InstÔncia "dg4msql", status UNKNOWN, tem 1 handler(s) para este serviþo...
                      O comando foi executado com Ûxito

                      C:\Users\admsetape.SETAPE>

                      STATUS

                      C:\Users\admsetape.SETAPE>lsnrctl status LISTENERMSSQL

                      LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-DEZ-2012 16
                      :15

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

                      Estabelecendo conexÒo com (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=S015145.S
                      PE.COM.BR)(PORT=1522)))
                      STATUS do LISTENER
                      ------------------------
                      Apelido LISTENERMSSQL
                      VersÒo TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Pr
                      ction
                      Data Inicial 18-DEZ-2012 15:56:38
                      Funcionamento 0 dias 0 hr. 9 min. 39 seg
                      NÝvel de Anßlise off
                      Seguranþa ON: Local OS Authentication
                      SNMP OFF
                      Arq. ParÔm. Listn. C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\
                      tener.ora
                      Arq. Log Listener c:\product\11.2.0\tg_1\diag\tnslsnr\S015145\listenermssq
                      lert\log.xml
                      Resumo de Atendimento...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=S015145.SETAPE.COM.BR)(PORT=1522)
                      Resumo de Serviþos...
                      O serviþo "dg4msql" tem 1 instÔncia(s).
                      InstÔncia "dg4msql", status UNKNOWN, tem 1 handler(s) para este serviþo...
                      O comando foi executado com Ûxito

                      C:\Users\admsetape.SETAPE>
                      • 9. Re: Oracle>SQLServ: ORA-28545 Unable to retrieve text of NETWORK/NCR msg: 65535
                        Mkirtley-Oracle
                        Everton,
                        The information shows thatthe LISTENERMSSQL is being started using the parameter file C:\app\admsetape\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora but it should be using the file C:\app\admsetape\product\11.2.0\tg_1\NETWORK\ADMIN\listener.ora.

                        Could you do the following -

                        1. Remove refernces to the gateway in the listener.ora in dbhome_1\NETWORK\ADMIN\listener.ora

                        2. Check if you have set the variable ORACLE_HOME. This is not recommended for Oracle on Windows and can cause problems such as this.

                        3. From a command line type -
                        set ORACLE_HOME
                        if it returns -
                        Environment variable ORACLE_HOME not defined
                        then it has not been set, otherwise issue -
                        set ORACLE_HOME=
                        and then confirm it has been unset -
                        set ORACLE_HOME
                        4. Check the PATH tomake sure the gateway ORACLE_HOME is first, then stop and start the listener LISTENERMSSQL. It should start with the parameter file -
                        C:\app\admsetape\product\11.2.0\tg_1\NETWORK\ADMIN\listener.ora.

                        Regards,
                        Mike