From Surf Wiki (app.surf) — the open knowledge base

Sqlnet.ora

In database computing, sqlnet.ora is a plain-text configuration file that contains the information (like tracing options, encryption, route of connections, external naming parameters etc.) on how both Oracle server and Oracle client have to use Oracle Net (formerly Net8 or SQL*Net) capabilities for networked database access.

Location

The sqlnet.ora file typically resides in on UNIX platforms and on Windows operating systems.

Sample file

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME) NAMES.DEFAULT_DOMAIN = ORACLE.COM TRACE_LEVEL_CLIENT = ON SQLNET.EXPIRE_TIME = 30 SQLNET.IDENTIX_FINGERPRINT_DATABASE = FINGRDB AUTOMATIC_IPC = ON SQLNET.AUTHENTICATION_SERVICES = (ALL) SQLNET.CRYPTO_CHECKSUM_CLIENT = ACCEPTED TNSPING.TRACE_DIRECTORY = /oracle/traces

Profile parameters

This section lists and describes some sqlnet.ora file parameters.

Purpose	Default	Values
Turning signal handling on or off (UNIX systems only).
Defining the session data unit size.	2048 bytes	512 to 2 Mbytes Ora12c
Defining the destination directory for the client to write the logs.	Current directory from which the executable is started	path to the directory
Defining client's log filename.	sqlnet.log	name of the file
Defining the server's log filename.	sqlnet.log	name of the file
Client checksum behaviour defining.	accepted	accepted; rejected; requested; required
Determine the crypto-checksum algorithms used by client.	all available algorithms	md5; sha1
Determine symbols to generate the cryptographic key. This parameter must not be set in CRS environments. CRS will fail to start if this value is set in CRS/Grid .		10-70 characters
Determine list of cryptographic ciphers used by SSL to encrypt the traffic.

References

"Sample Configuration Files".
"Database Net Services Reference - Profile Parameters". [[Oracle Corporation]].

Wikipedia Source

This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page.

configuration-files oracle-database

Want to explore this topic further?

Ask Mako anything about Sqlnet.ora — get instant answers, deeper analysis, and related topics.

Research with Mako

Free with your Surf account

Content sourced from Wikipedia, available under CC BY-SA 4.0.

This content may have been generated or modified by AI. CloudSurf Software LLC is not responsible for the accuracy, completeness, or reliability of AI-generated content. Always verify important information from primary sources.

Report