Network Configuration
The following are sample network configuration
files. The tnsnames.ora and sqlnet.ora should be located in the
/oracle/admin/snet/config directory and symbolically linked back to the
$ORACLE_HOME/network/admin directory for each $ORACLE_HOME supported.
There is no administrative advantage to relocating the listener.ora and
snmp*.ora files since they have ORACLE_HOME directories embedded and
certain functions don't follow the symbolic links.
- # listener.ora Network Configuration
File:
- #
/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
- #
- SQLNET.AUTHENTICATION_SERVICES =
(NONE)
- #
- USE_PLUG_AND_PLAY_LISTENER = OFF
- USE_CKPFILE_LISTENER = OFF
- #
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- # (ADDRESS = (PROTOCOL =
IPC)(KEY = EXTPROC))
- (ADDRESS = (PROTOCOL =
IPC)(KEY = <DBSID>))
- (ADDRESS = (PROTOCOL =
TCP)(HOST = <hostname>.<db_domain>)(PORT = 1521))
- )
- )
- #
- STARTUP_WAIT_TIME_LISTENER = 0
- CONNECT_TIMEOUT_LISTENER = 10
- LOGGING_LISTENER = OFF
- LOG_DIRECTORY_LISTENER =
/u01/app/oracle/admin/snet/log
- LOG_FILE_LISTENER = listener.log
- TRACE_LEVEL_LISTENER = OFF
- TRACE_DIRECTORY_LISTENER =
/u01/app/oracle/admin/snet/trace
- TRACE_FILE_LISTENER = listener.trc
- #
- SID_LIST_LISTENER =
- (SID_LIST =
- # (SID_DESC =
- # (SID_NAME = PLSExtProc)
- # (ORACLE_HOME =
/oracle/product/10.2.0/db_1)
- # (PROGRAM = extproc)
- # )
- (SID_DESC =
- #(GLOBAL_DBNAME = <DBSID>.<db_domain>)
- #(SID_NAME = <DBSID>)
- (SERVICE_NAME = <DBSID>.<db_domain>)
- (ORACLE_HOME =
/oracle/product/10.2.0)
- # (PRESPAWN_MAX = 50)
- # (PRESPAWN_LIST =
- # (PRESPAWN_DESC = (PROTOCOL
= TCP) (POOL_SIZE = 10) (TIMEOUT = 12))
- # )
- )
- )
- #
- #----ADDED BY TNSLSNR 14-MAR-2005
14:33:40---
- PASSWORDS_LISTENER =
B1BE1D6C11A248C5
-
#--------------------------------------------
Basic listener.ora File
- # listener.ora Network Configuration
File:
- #
/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
- #
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL =
IPC)(KEY = <DBSID>))
- (ADDRESS = (PROTOCOL =
TCP)(HOST = <hostname>.<db_domain>)(PORT = 1521))
- )
- )
- #
- STARTUP_WAIT_TIME_LISTENER = 0
- CONNECT_TIMEOUT_LISTENER = 10
- LOGGING_LISTENER = OFF
- LOG_DIRECTORY_LISTENER =
/u01/app/oracle/admin/snet/log
- LOG_FILE_LISTENER = listener.log
- TRACE_LEVEL_LISTENER = OFF
- TRACE_DIRECTORY_LISTENER =
/u01/app/oracle/admin/snet/trace
- TRACE_FILE_LISTENER = listener.trc
- #
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (SERVICE_NAME = <DBSID>.<db_domain>)
- (ORACLE_HOME =
/u01/app/oracle/product/10.2.0/db_1)
- )
- )
- #
- #----ADDED BY TNSLSNR 14-MAR-2005
14:33:40---
- PASSWORDS_LISTENER =
B1BE1D6C11A248C5
-
#--------------------------------------------
Password Protected Listener
It is recommended that the listener(s) be
password protected. This is accomplished with the "change_password"
command followed by the "set password" and "save_config" commands from
within the lsnrctl command environment:
- LSNRCTL> help change_password
- change_password [<listener_name>]:
changes the password of the listener
-
-
- LSNRCTL> change_password
- Old password:
- New password:
- Reenter new password:
- Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>.<db_domain>)(PORT=1521)))
- Password changed for LISTENER
- The command completed successfully
- LSNRCTL> set password
- Password:
- The command completed successfully
- LSNRCTL> save_config
- Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>.<db_domain>)(PORT=1521)))
- Saved LISTENER configuration
parameters.
- Listener Parameter File
/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
- Old Parameter File
/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.bak
- The command completed successfully
- LSNRCTL>
Notes:
1) Prior to 10g, all listener commands must be
issued in the format:
- LSNRCTL> set current_listener
LISTENER (optional)
- LSNRCTL> set password <unencrypted
or encrypted password>
- LSNRCTL> <command>
2) In order for the "save_config" command to run,
the listener.ora file must be located in the $ORACLE_HOME/network/admin
directory. If this file is linked somewhere else, the command will fail.
3) In Oracle 10g, OS authentication is supported
and listener commands can be issued from the database account without
needing the password.
4) dbcontrol should also be updated. In the
DEPVAR function the line "LISTENER_pwd" should be updated with the
encrypted password from the listener.ora file.
- DISABLE_OOB = ON
- TRACE_DIRECTORY_CLIENT =
/u01/app/oracle/admin/snet/trace
- LOG_DIRECTORY_CLIENT =
/u01/app/oracle/admin/snet/log
- LOG_DIRECTORY_SERVER =
/u01/app/oracle/admin/snet/log
- SQLNET.EXPIRE_TIME = 100
- NAMES.DEFAULT_DOMAIN = company.com
- NAME.DEFAULT_ZONE = company.com
- NAMES.DIRECTORY_PATH= (TNSNAMES)
- # Needed for Windows NT/2000
- # SQLNET.AUTHENTICATION_SERVICES=(NTS)
-
- USE_DEDICATED_SERVER = ON
- DISABLE_OOB=ON
- AUTOMATIC_IPC = OFF
- TRACE_LEVEL_CLIENT = OFF
- TRACE_DIRECTORY_CLIENT =
/u01/app/oracle/admin/snet/trace
- TRACE_FILE_CLIENT = sqlnet.trc
- TRACE_LEVEL_SERVER = OFF
- TRACE_DIRECTORY_SERVER =
/u01/app/oracle/admin/snet/trace
- TRACE_FILE_SERVER = sqlnet_srvr.trc
- LOG_DIRECTORY_CLIENT =
/u01/app/oracle/admin/snet/log
- LOG_FILE_CLIENT = sqlnet.log
- SQLNET.EXPIRE_TIME = 240
- #
- NAMES.DEFAULT_DOMAIN = company.com
- NAME.DEFAULT_ZONE = company.com
- NAMES.DIRECTORY_PATH = (TNSNAMES,
ONAMES)
- #
Basic sqlnet.ora File
- # sqlnet.ora Network Configuration
File: /oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
-
- NAMES.DIRECTORY_PATH= (TNSNAMES,
EZCONNECT)
- NAMES.DEFAULT_DOMAIN = company.com
- <SID> =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL =
IPC)(KEY = <SID>))
- (ADDRESS = (PROTOCOL =
TCP)(Host = <hostname>.<db_domain>)(Port = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = “<SID>.<db_domain>”)
- )
- )
-
- EXTPROC_CONNECTION_DATA =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL =
IPC)(KEY = EXTPROC))
- )
- (CONNECT_DATA =
- (SID = PLSExtProc)
- (PRESENTATION = RO)
- )
- )
-
Basic tnsnames.ora File
- # tnsnames.ora Network
Configuration File: /oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
-
- DBSID =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL =
IPC)(KEY = DBSID))
- (ADDRESS = (PROTOCOL =
TCP)(HOST = <hostname>.<db_domain>)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = DBSIG.<hostname>.<db_domain>)
- )
- )
-
