Configuration changes accomplished by the MIT Oracle 11g installer

The MIT Oracle 11gR2 installer is a silent wrapper which a.) Creates a sqlnet.ora file, including a dynamically generated crypto seed, b.) adds ldap.ora and sqlnet.ora to the machine and c.) runs the standard Oracle 11gR2 installer, installing the Administrator client. The Oracle installer checks for certain prerequisites before installing, such as operating system version and maximum path length. If these prerequisites are not met, the installer will not complete.

Listed below are the configuration changes accomplished by the MIT Oracle 11g installer.

Create the TNSNAMES.ORA file:

1. Find and concatenate any TNSNAMES.ORA files the user might have in other client versions
   homes into one TNSNAMES.ORA file
2. Put the file in the following directory
   C:\oracle\product\11.2.0\client\network\admin

Configure the SQLNET.ORA file:

1. Create the SQLNET.ORA file with the following entries:
   

   #
   #
   # Date:  < today's date >
   # What:  sqlnet.ora
   #
   #
    
   AUTOMATIC_IPC = OFF
   SQLNET.EXPIRE_TIME = 10     # Make this value 10 for a server and 0 for a client
   TRACE_LEVEL_CLIENT = OFF    # Turn on tracing when there is a problem
   TRACE_LEVEL_SERVER = OFF
   
   NAMES.DIRECTORY_PATH = (LDAP,TNSNAMES)
    
   SQLNET.AUTHENTICATION_SERVICES=(NONE,BEQ)
    
   SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUESTED
   SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED
    
   SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(MD5)
   SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(MD5)
    
   SQLNET.ENCRYPTION_CLIENT=REQUESTED
   SQLNET.ENCRYPTION_SERVER=REQUIRED
     
   

   
   

2. Add in the SQLNET.CRYPTO_SEED parameter with manually generated crypto seed at the end of the file.
   The seed must be exactly 64 chars long and should contain upper and lower case letters, numbers and special characters. For example:
   SQLNET.CRYPTO_SEED = 'DnVJV10qtsD7fS17hM/O0e^dx7YP8Db8xgN%JV60zZz09hWiiCq&yYt3l2Ja^M76'

Configure the LDAP.ORA file

1. Create the LDAP.ORA file with the following entries:
   Note: The DIRECTORY_SERVERS entry must specify both the tnsnames.mit.edu and noid server as noid is the backup LDAP server for tnsnames.mit.edu
   

   DIRECTORY_SERVERS= (tnsnames.mit.edu:389:636,noid:4032:4031)
   DEFAULT_ADMIN_CONTEXT = "dc=mit,dc=edu"
   DIRECTORY_SERVER_TYPE = OID
   
   

   
   

2. Put the file in the following directory
   C:\oracle\product\11.2.0\client\network\admin