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.