Shulou(Shulou.com)05/31 Report--

The editor will share with you the sample analysis of sqlnet.ora in the database. I hope you will get something after reading this article. Let's discuss it together.

First, examples

1. SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME)

The client will first look for the orcl record in the tnsnames.ora file. If there is no corresponding record, try to take orcl as a host name, resolve its ip address through the network, and then connect to the instance of GLOBAL_DBNAME=orcl on this ip. Of course, here orcl is not a host name.

2. NAMES.DIRECTORY_PATH= (TNSNAMES)

The client will only look up orcl records from tnsnames.ora.

Second, commonly used parameters

1 、 BEQUEATH_DETACH

The switch that controls the signal handling in the unix system is no by default, that is, signal handling is turned on.

2 、 DEFAULT_SDU_SIZE

Specify the size of session data unit (SDU) in bytes. It is recommended to set this parameter on both client and server to ensure that the same SDU size is used when linking. If the values configured on client and server do not match, smaller ones will be used.

3 、 LOG_DIRECTORY_CLIENT/LOG_DIRECTORY_SERVER

Specify the location of the client / server log log file

4 、 NAMES.DEFAULT_DOMAIN

Set the domain where the client resolves the name

5 、 NAMES.DIRECTORY_PATH

Specifies the order of client name parsing methods. The default is NAMES.DIRECTORY_PATH= (tnsnames, onames, hostname).

A) tnsnames

B) ldap (dictionary server)

C) hostname/ezconnect

D) cds (in distributed environment)

E) nis (Network Information Service (NIS)

6 、 SQLNET_ALLOWED_LOGON_VERSIONS

Specify the version of SQLNET_ALLOWED_LOGON_VERSIONS= that runs the linked oracle (10meme 9je 8)

7 、 SQLNET.AUTHENTICATION_SERVICES

Specify to start one or more authentication services

8 、 SQLNET.INBOUND_CONNECT_TIMEOUT

Specifies the timeout for which the client does not have a successful link. After the timeout, the oracle will break the link and report an error.

9 、 SSL_VERSION

Specify the version of the ssl link

10 、 TCP.EXCLUDED_NODES

Specify nodes that are not allowed to access oracle, and can use hostname or IP address

11 、 TCP.INVITED_NODES

Specifies the client that is allowed to access db, which has a higher priority than TCP.EXCLUDED_NODES.

12 、 TCP.VALIDNODE_CHECKING

Use this parameter to enable the above two parameters.

13 、 TNSPING.TRACE_DIRECTORY

Use this parameter to specify the directory of the tnsping trace file, which defaults to the $ORACLE_HOME/network/trace directory

After reading this article, I believe you have some understanding of "sample Analysis of sqlnet.ora in the Database". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.