This discussion is archived
9 Replies Latest reply: Dec 19, 2012 2:27 AM by mkirtley-Oracle RSS

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

979067 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    *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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    *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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

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