Menu de navegação

[souzaParticipante]

TNS:Conexão Fechada

Alguém já viu uso

[DanielBParticipante]

desde que que ferramenta?
que version?

Symptoms
* Tnsping Net Service Name fails with TNS-12537: TNS:connection closed
* Sqlplus connection errors out with Ora-12537

• Connection to the Database locally(Bequeath Connection) as well with Net Service Name works fine.

• If trying to connect to the Apps database from client machine.

• Consistently reproducing on the client machines.

Cause
* In the Sqlnet.ora file the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to some specific IP’s of the Client Machine.

• If trying to connect to the Apps database, by default, with Oracle Apps Installation the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to Server Machines IP or Hostname.

Solution
* You can disable these parameters in the Sqlnet.ora

• Or add the client machines ip address in the TCP.INVITEDNODES list.

[souzaParticipante]

O que tenho que mudar no SQLNET.ORA e onde localizo o INVITENODES ?

Desde já obrigado

[DanielBParticipante]

To activate Validnode checking, the following parameter must be entered in
PROTOCOL.ORA:

    protocol.validnode_checking = yes 

For example, for the TCP/IP protocol, the parameter would be:

    tcp.validnode_checking = yes 

For the DECnet protocol, the parameter would be:

    decnet.validnode_checking = yes 

The default is for Validnode checking to be off.

The access list for Validnode checking can take two forms: an invited_nodes
list and an excluded_nodes list. The two lists are mutually exclusive. If both
are present, the invited_nodes list takes precedence over the excluded_nodes
list.

Sample Access List

The following is a sample access list in PROTOCOL.ORA for the TCP/IP protocol:

    tcp.invited_nodes = (drummer.us.com, 
                        139.185.5.73, 
                        139.185.5.111) 

This list grants access to the three nodes listed, and excludes all others.

An alternative way of limiting connection requests is to exclude specific
nodes. The following list provides access to all nodes except those listed:

    tcp.excluded_nodes = (drummer.us.com, 
                         139.185.5.73, 
                         139.185.5.111) 

Note: Not all protocols and operating systems support Validnode Verification.
See the operating system-specific documentation for your platform for further
details.

[souzaParticipante]

Esse protocol.ora seria o sqlnet.ora ?

[DanielBParticipante]

protocol. ora es un archivo que debe ir en $ORACLE_HOME/network/admin

[souzaParticipante]

Tem apenas LISTENER.ORA TNSNAMES.ORA e uma pasta SAMPLES.

[DanielBParticipante]

es otro archivo que se debe crear con ese nombre y en ese directorio o carpeta

[Autor]

Posts