Oracle Net8 Configuration and Troubleshooting

By Jonathan Gennick, Hugo Toledo

SAVE_CONFIG command, saving configurations 

SAVE_CONFIG_ON_STOP parameter, modifying a listener 

SAVE_CONFIG_ON_STOP_listener_name parameter 

scalability of Oracle Names  

schema (username) 

.sdns.ora file

    manually generating 

    using discovery 

    when corrupt 

Secure Socket Layer (SSL) 

security in remote management 

SELECT (failover type) 

SEND, in STATUS column of V$DISPATCHER view 

Sequenced Packet Exchange connections  [See SPX]

server configurations 

    control parameters for 

    dead connection detection 

    external procedures for 

    installing software 

    listener address entry and 

    Listener Control utility 

    listeners 

        deleting 

        modifying 

        securing 

    multiple listeners and 

    prespawned dedicated server processes 

    process of 

    SID_LIST parameters and 

server log files 

SERVER value, in QUEUE column of a dynamic performance view 

server_name, address data for Named Pipes connections 

servers  [See also Names servers]

    configuring

        for Names servers 

        for Net8 

    LDAP directory, addressing 

    multi-threaded 

    testing connectivity 

servers (Net8) 

    trace file parameters and 

SERVERS_HIGHWATER column in the V$MTS view 

SERVERS_STARTED column in the V$MTS view 

SERVERS_TERMINATED column in the V$MTS view 

service (listener log entry field) 

service names 

    resolving 

    specifying 

service registration 

SERVICE_NAMES parameter, using listener load balancing 

SERVICES command

    multi-threaded server status, viewing 

    verifying service is registered 

Services control panel, deleting listeners 

SESSION (failover type) 

session data unit size , changing 

session uga memory value 

session-specific memory, implementing MTS 

SET (Connection Manager command) 

SET CONNECT_TIMEOUT command, changing listener parameters 

SET CURRENT_LISTENER command, starting a listener 

SET LOG_DIRECTORY command, changing listener parameters 

SET LOG_FILE command, changing listener parameters 

SET LOG_LEVEL command, changing log level 

SET LOG_STATUS command, changing listener parameters 

SET PASSWORD command

    encrypted/unencrypted passwords, establishing 

    for remote server management 

    securing listeners  2nd 

SET SAVE_CONFIG_ON_STOP command, changing listener parameters 

SET SERVER command 

    selecting a Names server 

SET STARTUP_WAITTIME command, changing listener parameters 

SET TRC_DIRECTORY command, changing listener parameters 

SET TRC_FILE command, changing listener parameters 

SET TRC_LEVEL command, changing listener parameters 

SET USE_PLUGANDPLAY command, changing listener parameters 

SGA (System Global Area) 

shared pool

    memory for implementing MTS 

shared pools

    storing UGAs 

shared server processes 

    changing the number of 

    connection limits for 

    database initialization file changes and 

    implementing multi-threaded server 

     utilizing  

SHOW ADDRESS (Connection Manager command) 

SHOW PROFILE (Connection Manager command) 

SHOW RELAY ACTIVE command, examining relays 

SHOW RELAY command, examining relays 

SHOW RULES command 

    examining access control rules 

    viewing access control rules 

SHOW_RELAY (Connection Manager command) 

SHOW_TNS_INFO profile setting 

SHUTDOWN command 

    stopping Connection Manager 

SID keywords

    connecting to a database 

    listener load balancing and 

SID_DESC parameter  2nd 

sid_identifier, in address data for Bequeath connections 

SID_LIST parameter  2nd  3rd 

    external procedure calls, supporting 

    prespawned dedicated server processes, specifying number of 

SID_LIST_listener_name parameter 

SID_NAME parameter, identifying databases 

Simple Network Management Protocol (SNMP) Agent 

.so files, installing Net8 under Unix 

software

    for client configurations 

    for servers, types of 

software layers in stacks 

solutions to common problems 

    Connection Manager and 

SORT_AREA_RETAINED_SIZE initialization parameter, implementing MTS 

source nodes, creating access rules 

SOURCE_ROUTE parameter, concentrating connections 

specifying addresses in databases 

SPX (Sequenced Packet Exchange) connections 

    Connection Manager Addresses and 

    installing Net8 

    multi-protocol support and 

SQL\\*Plus

    creating repository tables 

    testing net service names 

    Transparent Application Failover and 

SQLNET.AUTHENTICATION_GSSAPI_SERVICE parameter 

SQLNET.AUTHENTICATION_KERBEROS5_SERVICE parameter 

SQLNET.AUTHENTICATION_SERVICES parameter 

SQLNET.CLIENT_REGISTRATION parameter 

SQLNET.CRYPTO_CHECKSUM_CLIENT parameter 

SQLNET.CRYPTO_CHECKSUM_SERVER parameter 

SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT parameter 

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER parameter 

SQLNET.CRYPTO_SEED parameter 

SQLNET.ENCRYPTION_CLIENT parameter 

SQLNET.ENCRYPTION_SERVER parameter 

SQLNET.ENCRYPTION_TYPES_CLIENT parameter 

SQLNET.ENCRYPTION_TYPES_SERVER parameter 

SQLNET.EXPIRE_TIME parameter 

    detecting dead connections 

SQLNET.IDENTIX_FINGERPRINT_DATABASE_PASSWORD parameter 

SQLNET.IDENTIX_FINGERPRINT_METHOD parameter 

SQLNET.INDENTIX_FINGERPRINT_DATABASE parameter 

SQLNET.INDENTIX_FINGERPRINT_DATABASE_USER parameter 

SQLNET.KERBEROS5_CC_NAME parameter 

SQLNET.KERBEROS5_CLOCKSKEW parameter 

SQLNET.KERBEROS5_CONF parameter 

SQLNET.KERBEROS5_KEYTAB parameter 

SQLNET.KERBEROS5_REALMS parameter 

sqlnet.log (log file)  2nd 

sqlnet.ora file  2nd 

    changing Net8 settings 

    configuring

        Names servers 

        profiles 

    cycling through Names servers 

    default domains 

        defining 

    detecting dead connections 

    enabling tracing for client 

    forcing a dedicated server connection 

    keeping a standard file 

    LDAP directories

        client configurations for 

        configuring 

        naming methods , specifying 

    local naming and 

    NAMES.PREFERRED_SERVERS parameter and 

    naming methods 

        choosing 

    NDS naming and 

    net service names, defining 

    preferred Names servers, defining 

    region Names servers, creating 

    trace file parameters and  2nd 

    trace files

        parameters of 

        specifying location of 

SQLNET.RADIUS_ALTERNATE parameter 

SQLNET.RADIUS_ALTERNATE_PORT parameter 

SQLNET.RADIUS_ALTERNATE_RETRIES parameter 

SQLNET.RADIUS_ALTERNATE_TIMEOUT parameter 

SQLNET.RADIUS_AUTHENTICATION parameter 

SQLNET.RADIUS_AUTHENTICATION_INTERFACE parameter 

SQLNET.RADIUS_AUTHENTICATION_PORT parameter 

SQLNET.RADIUS_AUTHENTICATION_RETRIES parameter 

SQLNET.RADIUS_AUTHENTICATION_TIMEOUT parameter 

SQLNET.RADIUS_CHALLENGE_KEYWORD parameter 

SQLNET.RADIUS_CHALLENGE_RESPONSE parameter 

SQLNET.RADIUS_CLASSPATH parameter 

SQLNET.RADIUS_SECRET parameter 

SQLNET.RADIUS_SEND_ACCOUNTING parameter 

sqlnet.trc file (default client trace filename) 

SRC attribute, creating access control rules 

SRV attribute, creating access control rules 

SSL (Secure Socket Layer) 

SSL_CIPHER_SUITES parameter 

SSL_CLIENT_AUTHENTICATION parameter 

SSL_VERSION parameter 

stack communications 

    IIOP stacks 

    JDBC stacks 

START command

    Connection Manager and 

    starting a listener 

    using Names Control 

STARTUP_WAIT_TIME_listener_name parameter 

STARTUP_WAITTIME parameter, modifying a listener 

static services 

STATS command 

    viewing statistics of Connection Manager 

STATUS column

    users connected to dispatchers 

    V$DISPATCHER view, using 

STATUS command 

    in Names Control utility 

    viewing status of Connection Manager 

STOP command 

    Connection Manager and 

    stopping a listener 

    using Names Control 

    when saving configurations 

STOPNOW command 

    stopping Connection Manager 

Super Class Selector window, administrative context, creating 

System Global Area (SGA)