Previous Table of Contents Next


Listing 21.3. sqlnet.ora file from database server.

################
# Filename......: sqlnet.ora
# Name..........: TCP.world
# Date..........: 11-MAR-98 09:46:48
################
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
SQLNET.CRYPTO_SEED = “-1241587199-1241552483”

Listing 21.4. Listener.ora file from database server.

#
# Listener.ora
# Version O96JUN23
# server1
#

SQLNET.AUTHENTICATION_SERVICES = (NONE)

USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= prod.world)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= prod)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= test.world)
        ) 
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= test)
        )
        (ADDRESS =
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = server1)
          (Port = 1521)
        )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER=(SID_LIST=
  (SID_DESC=(SID_NAME=prod)
     (oracle_home=/u01/oracle/8.0.4))
  (SID_DESC=(SID_NAME=test)
     (oracle_home=/u01/oracle/8.0.4))) 

Listing 21.5. snmp_ro.ora file from database server.

snmp.visibleservices = (LISTENER, prod.world, test.world)
snmp.shortname.LISTENER = LISTENER
snmp.longname.LISTENER = LISTENER_server1
snmp.configfile.LISTENER = /etc/listener.ora
snmp.SID.prod.world = prod
snmp.oraclehome.prod.world = /u01/oracle/8.0.4
snmp.address.prod.world = (DESCRIPTION =(ADDRESS_LIST =(ADDRESS =
(COMMUNITY = TCP.world)
                          (PROTOCOL = TCP)(Host = server1)(Port = 1521)))
                          (CONNECT_DATA =(SID = prod)(GLOBAL_NAME =
prod.world)))
snmp.SID.test.world = test
snmp.oraclehome.test.world = /u01/oracle/8.0.4
snmp.address.test.world = (DESCRIPTION =(ADDRESS_LIST =(ADDRESS =
(COMMUNITY = TCP.world)
                          (PROTOCOL = TCP)(Host = server1)(Port = 1521)))
                          (CONNECT_DATA =(SID = test)(GLOBAL_NAME =
test.world)))
ifile = /fin101201/oracle/7.3.4/network/admin/snmp_rw.ora

Listing 21.6. snmp_rw file from database server.

snmp.contact.LISTENER = “”
snmp.index.LISTENER = 1
snmp.contact.prod.world = “”
snmp.index.prod.world = 2
snmp.connect.prod.world.password = sams_oem
snmp.contact.test.world = “”
snmp.index.test.world = 3
snmp.connect.test.world.password = sams_oem

Listing 21.7. tnsnames.ora file from console workstation.

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 01-APR-1998 12.39.46 PM
# Generated by Enterprise Manager
################
prod.world=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (COMMUNITY =
NMP.world)(PROTOCOL = NMP)
         (SERVER = SERVER1)(PIPE = ORAPIPE))(ADDRESS = (PROTOCOL =
TCP)(Host = SERVER1)
          (Port = 1521))(ADDRESS = (PROTOCOL = TCP)(Host = SERVER1)(Port
= 1526))
          (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
          (ADDRESS = (PROTOCOL = SPX)(Service = SERVER1_lsnr)))
          (CONNECT_DATA=(SID=PROD)(SERVER=DEDICATED)))
test.world=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (COMMUNITY =
NMP.world)(PROTOCOL = NMP)
         (SERVER = SERVER1)(PIPE = ORAPIPE))(ADDRESS = (PROTOCOL =
TCP)(Host = SERVER1)
          (Port = 1521))(ADDRESS = (PROTOCOL = TCP)(Host = SERVER1)(Port
= 1526))
          (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1 521))
          (ADDRESS = (PROTOCOL = SPX)(Service = SERVER1_lsnr)))
          (CONNECT_DATA=(SID=TEST)(SERVER=DEDICATED)))
oemrep.world=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY =
tcp.world)
             (PROTOCOL = TCP) (Host = server2) (Port = 1521))
             (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host =
server2)
             (Port = 1526))) (CONNECT_DATA = (SID = oemrep))) 

Listing 21.8. sqlnet.ora file from console workstation.

TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world

Summary

This chapter has provided installation and configuration instructions, as well as examples of working configuration files. It has also shown how Enterprise Manager has evolved to support Oracle8.

As you have seen, Oracle Enterprise Manager can offer great assistance in monitoring and administrating your organization’s servers and databases. As you progress through the other chapters in this book, experiment with whichever Enterprise Manager tool is appropriate for that topic and compare the steps you would perform with this tool to any command-line processes shown in the examples. You will find that there are still some tasks that you will continue to perform from a command line or a script, but there are many others that are performed more quickly and easily with Enterprise Manager.


Previous Table of Contents Next