sqlnet.ora

oracle9i的绿色版的客户端,支持oracle10g.无需安装,配合pl/sql developer使用,非常方便,使用方法见里面的说明.

# names.ora:names.server_password
#
# - Native Naming Adpaters -------------------------------------------
#
#names.dce.prefix = /.:/subsys/oracle/names
#
#Syntax:  DCE cell name
#Default: /.:/subsys/oracle/names
#
#Specifies the DCE cell (prefix) to use for name lookup.
#
#
#names.nds.name_context = personnel.acme
#
#Syntax:  NDS name
#Default: (OSD?)
#
# Specifies the default NDS name context in which to look for the name to
# be resolved.
#
#
#names.nis.meta_map # NA
#
# Syntax:  filename
# Default: sqlnet.maps
#
# Specifies the file to be used to map NIS attributes to an NIS mapname.
# Currently unused.

# - Oracle Advanced Security Authentication Adapters ----------------

#sqlnet.authentication_services
#
# Syntax: A single value or a list from {beq, none, all, kerberos5,
#	  cybersafe, radius}
# Default: NONE
#
# Enables one or more authentication services.  If
# Oracle Advanced Security has been installed with Kerberos5
# support, using (beq, kerberos5) would enable authentication via
# Kerberos.
#
#sqlnet.authentication_services=(beq, kerberos5)
 
##
## Parmeters used with Kerberos adapter.
##

#sqlnet.kerberos5_cc_name
#
# Syntax: Any valid pathname.
# Default: /tmp/krb5cc_<uid>
#
# The Kerberos credential cache pathname.
#
#sqlnet.kerberos5_cc_name=/tmp/mycc

#sqlnet.kerberos5_clockskew
#
# Syntax: Any positive integer.
# Default: 300
#
# The acceptable difference in the number of seconds between when a
# credential was sent and when it was received.
#
#sqlnet.kerberos5_clockskew=600

#sqlnet.kerberos5_conf
#
# Syntax: Any valid pathname.
# Default: /krb5/krb.conf
#
# The Kerberos configuration pathname.
#
#sqlnet.kerberos5_conf=/tmp/mykrb.conf

#sqlnet.kerberos5_realms
#
# Syntax: Any valid pathname
# Default: /krb5/krb.realms
#
# The Kerberos host name to realm translation file.
#
#sqlnet.kerberos5_realms=/tmp/mykrb.realms

#sqlnet.kerberos5_keytab
#
# Syntax: Any valid pathname.
# Default: /etc/v5srvtab
#
# The Kerberos secret key file.
#
#sqlnet.kerberos5_keytab=/tmp/myv5srvtab

#sqlnet.authentication_kerberos5_service
#
# Syntax: Any string.
# Default: A default is not provided.
#
# The Kerberos service name.
#
#sqlnet.authentication_kerberos5_service=acme

##
## Parmeters used with CyberSAFE adapter.
##

#sqlnet.authentication_gssapi_service
#
# Syntax: A correctly formatted service principal string.
# Default: A default is not provided.
#
# The CyberSAFE service principal
#
#sqlnet.authentication_gssapi_service=acme/[e-mail]

##
## Parameters used with Radius adapter
##
 
# Need to specify the location of the Radius server
#sqlnet.radius_authentication = localhost

# Need to specify the port address of the Radius server
#sqlnet.radius_authentication_port = 1654

# If your radius server support accounting, you can enable it
#sqlnet.radius_accounting = off

# Turn on/off challenge response
#sqlnet.radius_challenge_response = off

# Keyword to request a challenge from Radius server.  
# If you use activcard, enter activcard

# If you use something else, enter challenge
#sqlnet.radius_challenge_keyword = challenge

# Enter the name of the client interface you want to use for challenge response
#sqlnet.radius_authentication_interface = DefaultRadiusInterface

# Where is the secret file locate
#sqlnet.radius_secret = $ORACLE_HOME/security/radius.key
 

# - Oracle Advanced Security Network Security -------------------------

#sqlnet.crypto_checksum_client 
#sqlnet.crypto_checksum_server 
#sqlnet.encryption_client 
#sqlnet.encryption_server 
#
# These four parameters are used to specify whether a service (e.g. 
# crypto-checksumming or encryption) should be active: 
#
# Each of the above parameters defaults to REJECTED.
#
# Each of the above parameters can have one of four possible values: 
# 
# value		meaning 
#
# ACCEPTED	The service will be active if the other side of the 
#		connection specifies "REQUESTED" or REQUIRED" and 
#		there is a compatible algorithm available on the other 
#		side; it will be inactive otherwise. 
#
# REJECTED	The service must not be active, and the connection 
#		will fail if the other side specifies "REQUIRED". 
#
# REQUESTED	The service will be active if the other side specifies 
#		"ACCEPTED", "REQUESTED", or "REQUIRED" and there is a 
#		compatible algorithm available on the other side; it 
#		will be inactive otherwise. 
#
# REQUIRED	The service must be active, and the connection will 
#		fail if the other side specifies "REJECTED" or if there 
#		is no compatible algorithm on the other side. 
#
#sqlnet.crypto_checksum_types_client 
#sqlnet.crypto_checksum_types_server 
#sqlnet.encryption_types_client 
#sqlnet.encryption_types_server 
#
# These parameters control which algorithms will be made available for 
# each service on each end of a connection: 
#
# The value of each of these parameters can be either a parenthesized 
# list of algorithm names separated by commas or a single algorithm 
# name.
#
# Encryption types can be: RC4_256, 3DES168, RC4_128, 3DES112, RC4_56
#                          DES, RC4_40, DES40
#
# Encryption defaults to all the algorithms.
#
# Crypto checksum types can be: SHA1, MD5
#
# Crypto checksum defaults to all the algorithms.
#
#sqlnet.crypto_seed = <10-70 random characters, inside "" marks>
#sqlnet.crypto_checksum_server = required 
#sqlnet.encryption_server = required

# - Oracle Security Server ---------------------------------------------

#oss.source.my_wallet
#
# Syntax: A properly formatted NLNV list.
# Default: Platform specific.  Unix: $HOME/oracle/oss
#
# The method for retrieving and storing my identity.  
#
#oss.source.my_wallet
#   =(source
#       =(method=file)
#        (method_data=/dve/asriniva/oss/wallet)
#     ) 

#oss.source.location
#
# Syntax: A properly formatted NLNV list.
# Default: Oracle method, oracle_security_service/oracle_security_service@oss
#
# The method for retrieving encrypted private keys.
#
#oss.source.location
#   =(source
#       =(method=oracle) 
#        (method_data= 
#           (sqlnet_address=andreoss)
#        ) 
#    ) 

# - Sqlnet(v2.x) and Net3.0 Client ------------------------------------------

#
# In the following descriptions, the term "client program" could mean 
# either sqlplus, svrmgrl or any other OCI programs written by users
# 
###########################
#trace_level_client = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the client program 
#         is to be traced. 
# Available Values:
#       0 or OFF - No Trace output
#	4 or USER - User trace information
# 	10 or ADMIN - Administration trace information
#	16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since:  v2.0
#
###############################################
#trace_directory_client = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network/trace  ($ORACLE_HOME=/oracle at customer 
#         site)
#
#Purpose: Indicates the name of the directory to which trace files from 
#         the client execution are written.
#
#Supported since: v2.0
#
###################################################
#trace_file_client =  /oracle/network/trace/cli.trc
###################################################
#
#Possible values: Any valid file name 
#Default:	  $ORACLE_HOME/network/trace/cli.trc ($ORACLE_HOME = 
#		  /oracle at customer site)
#
#Purpose: Indicates the name of the file to which the execution trace 
#         of the client is written to. 
#
#Supported since: v2.0
#
###########################
#trace_unique_client = ON
###########################
#
#Possible values: {ON, OFF}
#Default: OFF
#
#Purpose: Used to make each client trace file have a unique name to 
#	  prevent each trace file from being overwritten by successive 
#	  runs of the client program
#
#Supported since: v2.0
#
###########################################
#log_directory_client = /oracle/network/log
###########################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/log  ($ORACLE_HOME = /oracle at customer
#	  site)
#
#Purpose: Indicates the name of the directory to which the client log file
#	  is written to.
#
#
#Supported since: v2.0
#
################
#log_file_client = /oracle/network/log/sqlnet.log
################
#
#Possible values: This is a default value, u cannot change this
#Default: $ORACLE_HOME/network/log/sqlnet.log  ($ORACLE_HOME=/oracle in 
#         customer site)
#
#Purpose: Indicates the name of the log file from a client program
#
#Supported since: v2.0
#
#############################################
#log_directory_server = /oracle/network/trace
#############################################
#
#Possible values: Any valid diretcory path with write permission
#Default: $ORACLE_HOME/network/trace ( $ORACLE_HOME=/oracle at customer 
#	  site)
#
#Purpose: Indicates the name of the directory to which log files from the 
# 	  server are written
#
#Supported since:  v2.0
#
###############################################
#trace_directory_server = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network_trace ( $ORACLE_HOME=/oracle at customer 
#	  site)
#
#Purpose: Indicates the name of the directory to which trace files from 
#         the server are written 
#
#Supported since:  v2.0
#
#######################################################
#trace_file_server = /orace/network/trace/svr_<pid>.trc
#######################################################
#
#Possible values: Any valid filename
#Default: $ORACLE_HOME/network/trace/svr_<pid>.trc where <pid? stands for 
#         the process id of the server on UNIX systems 
#
#Purpose: Indicates the name of the file to which the execution trace of 
#         the server program is written to. 
#
#Supported since: v2.0
#
###########################
#trace_level_server = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since: v2.0
#
##########################
#use_dedicated_server = ON
##########################
#
#Possible values: {OFF,ON}
#Default: 	  OFF
#
#Purpose: Forces the listener to spawn a dedicated server process for 
#	  sessions from this client program. 
#
#Supported since: v2.0
#
################
#use_cman = TRUE
################
#
#Possible values: {TRUE, FALSE}
#Default:	  FALSE
#
#Purpose: 
#
#Supported since: v3.0
#
################################################
#tnsping.trace_directory = /oracle/network/trace
################################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/trace ($ORACLE_HOME=/oracle at customer 
#	  site)
#
#Purpose: Indicates the directory to which the execution trace from
#	  the tnsping program is to be written to.
#
#Supported since: v2.0
#
############################
#tnsping.trace_level = ADMIN    
############################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#
#Supported since: v2.0
#
########################
#sqlnet.expire_time = 10
########################
#
#Possible values: 0-any valid positive integer! (in minutes)
#Default: 0 minutes 
#Recommended value: 10 minutes
#
#Purpose: Indicates the time interval to send a probe to verify the 
#	  client session is alive (this is used to reclaim watseful 
#	  resources on a dead client)
#
#Supported since: v2.1
#
#######################################
#sqlnet.client_registration = <unique_id>
#######################################
#
#Possible values: 
#Default:     OFF 
#
#Purpose: Sets a unique identifier for the client machine. This 
#	  identifier is then passed to the listener with any connection 
#	  request and will be included in the Audit Trail. The identifier 
#	  can be any alphanumeric string up to 128 characters long.
#
#Supported since: v2.3.2
#
######################
#bequeath_detach = YES
######################
#
#Possible values: {YES,NO}
#Default:         NO
#
#Purpose: Turns off signal handling on UNIX systems. If signal handling 
#	  were not turned off and if client programs written by users make 
#	  use of signal handling they could interfere with Sqlnet/Net3. 
#
#Supported since: v2.3.3 
#
####################
#automatic_ipc = OFF
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: Force a session to use or not to use IPC addresses on the 
#	  client's node. 
#
#Supported since: v2.0
#
####################
#disable_oob = ON
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: If the underlying transport protocol (TCP, DECnet,...) does
#         not support Out-of-band breaks, then disable out-of-band
#	  breaks
#
#Supported since: v2.0
#