Solved

Installing Oracle Forms 6i on Windows ME------HELP!!!!!!!

Posted on 2001-06-27
18
1,701 Views
Last Modified: 2007-11-27
I installed sql plus on my Windows ME computer with no problems.  However when I installed Forms, I encountered a lengthy error message saying something about a directory/or drive (?) missing.  The install completed otherwise successfully, but when I tried to start my database, I got an error message stating it couldn't attach to Oracle 8i.  I have read that this is a common problem with installing Oracle on Windows ME.  Any help you can provide would be highly appreciated.
0
Comment
Question by:dawnb
  • 7
  • 5
  • 3
  • +2
18 Comments
 
LVL 47

Expert Comment

by:schwertner
ID: 6233973
We (the Experts) will appreciate if you post the numbers and the full texts of the error messages you get facing problems. It is not clear what happend in your instalation. I guess two reasons:
1. Forms 6/6i is designed to be used only under Windows NT 4/2000.
2. The general issue is to fail to establish connection between Forms and Oracle Serer (there is indication that you face this issue). To avoid this, please, read the following:



You can use the "Oracle Net 8 assistant", "Oracle Net 8 Easy config" to see if you have the appropriate entry to the server in the local tnsnames.ora file (find it!). I mean that one in the Forms&Reports home, not that one in the Oracle_Home.
Under local I mean the file tnsnames.ora  in your application, not at the Oracle Server - this is a common mistake.

You have to have there an entry like:

REKS816.RILA.us =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bigbluenew.rila.us)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = REKS816)
     )
  )

It is a bad practice, but you can add such entry using simple text editor. But before that make a copy of tnsnames.ora in order to restore it if you do not succeed.

After that go to "control panel" and run "services".
Look at your Oracle_Home_TNSlistener80 process. Stop it! Start it again!

If you work on Unix find the relevant processes and notions of the Unix OS.

Two common areas of misconfiguration are responsible for these log-in errors:

(1) Erroneous entries in the TNSNAMES.ORA file, and  
(2) An erroneous default domain setting in the SQLNET.ORA file

A successful client log-in requires that:

1. The database is running.
2. The listener on the host machine is running and is configured correctly.
3. The network is correctly routing TCP/IP packets.
4. The client machine has TCP/IP installed correctly.
5. The client machine has SQL*Net installed correctly.
6. The TNSNAMES.ORA entry for that connection has the correct information.
7. The SQLNET.ORA file is configured correctly.

This solution covers common SQL*Net misconfiguration issues on the client side, and assumes that all
other necessary aspects of the connection are correctly configured and operating properly.

Please refer to the attached files for configuration information.

######################################################

The TNSNAMES.ORA file

The log-in dialog box of the client asks for a connect
string to identify the database in which the client account is located.
The TNSNAMES.ORA file is then searched for this connect string, and the actual  
connect information is found.

Below is a sample TNSNAMES.ORA entry for connecting to a machine named  
"oas.this.com" in DNS. The connection is via TCP/IP to port 1521, and  
the SID of the database containing the server is V732.

oas =  
  (description=  
     (address=(protocol=tcp)(host=oas.this.com)(port=1521))  
     (connect_data=(sid=V732))  
  )  
 
Note: the parentheses are extremely important - omitted or extraneous  
parentheses will result in an invalid entry. On the other hand, white space,
such as tabs, spaces, or newlines, are ignored.

The "host=" entry shown above implies DNS availability; if DNS is not
available, the IP address number may be substituted.


The SQLNET.ORA file:

Before being searched for in the TNSNAMES.ORA file, the connect string  
supplied in the log-in dialog box may be modified if the NAMES.DEFAULT_DOMAIN
variable has a value.

During login, the connect string is parsed to determine whether or not it is
fully-qualified, i.e. that it has full domain information. If it does not, and
the NAMES.DEFAULT_DOMAIN variable is set, then that value is appended to the  
connect string.  

For example, using a connect string "conn" and a NAMES.DEFAULT_DOMAIN  
setting of "oas.this.com" will result in a final connect string of  
"conn.oas.this.com". It is this final value "conn.oas.this.com" that will be  
searched for in the TNSNAMES.ORA file; thus, your entry in the TNSNAMES.ORA
file should start with

conn.oas.this.com =  


Using the TNSPING utility to test connect strings:

To test whether or not a connect string is valid, the utility TNSPING is
provided in the $ORACLE_HOME\bin directory. Run TNSPING with the connect
string you wish to test.  

Example 1:

D:\ORAWIN95\BIN>tnsping test

TNS Ping Utility for 32-bit Windows: Version 2.3.3.0.0 - Production on 02-JUN-
97 18:39:09

Copyright (c) Oracle Corporation 1995.  All rights reserved.

Attempting to contact  
(ADDRESS=(COMMUNITY=tcp.oas.this.com)(PROTOCOL=TCP)(Host=
conn.oas.this.com)(Port=1521))
OK (170 msec)

<end example>


From this result, we see that the connect string "test" resolves correctly to
an entry in the TNSNAMES.ORA file to valid connect information for an Oracle  
database.

On the other hand, the following is a test of an invalid connect string:


Example 2:

D:\ORAWIN95\BIN>tnsping notgood

TNS Ping Utility for 32-bit Windows: Version 2.3.3.0.0 - Production on 04-JUN-
97 09:13:32

Copyright (c) Oracle Corporation 1995.  All rights reserved.

TNS-03505: Failed to resolve name

<end example>

Using TNSPING as a test ensures that your TNSNAMES.ORA entry syntax is
correct, and that there is a listener on the host machine listening for
requests for that port.


~~~~~     ~~~~~     ~~~~~     ~~~~~     ~~~~~     ~~~~~     ~~~~~     ~~~~~     ~~~~~     ~~~~~

What follows here are several common problem descriptions & their solutions.


Problem Description:
====================
       You receive an ORA-12162 "TNS:service name is incorrectly
specified" when attempting a Sqlplus (804)/Net8 login with the following
syntax:
       sqlplus <userid>@<alias>
Enter password: <password>

Problem Explanation:
====================
Due to a parsing error with Sqlplus (8.0.4 only) the connect descriptor
is not beeing read properly.

Parsing error does not occur using other utilities, ie. tnsping,
svrmgrl or other versions of Sqlplus.
Using the tnsping utility you are able to resolve the connect string
and verify a listener process is responding.

For example:

[Alpha]> tnsping N804

TNS Ping Utility for Solaris: Version 8.0.4.0.0 - Production on 15-AUG-99 08:03:
04

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=Alpha)(Port=1521))
OK (60 msec)



Solution Description:
=====================
Try using a full command line syntax for Sqlplus to avoid this parsing
problem.  For example, at the command prompt use the following syntax:

         sqlplus system/manager@N804

Versus the previous syntax where you were prompted for the password:

       sqlplus system@N804
Enter password: manager    <password is not visible when using this syntax>


If you are able to connect with using the full line syntax, you are
running into Base Bug:611696 for Sqlplus Version 8.0.4.  This bug is fixed in Sqlplus
release 8.0.5, and serveral backports are available, depending on you platform.


Problem Description
-------------------

TNSPING works fine but connecting via SQL*PLUS fails with an ORA-12545. Normally this indicates some

syntax issue with the TNSNAMES.ORA which is not the cause.

Turn on client tracing in the sqlnet.ora file TRACE_CLIENT_LEVEL = 16

nscall: connecting...
nsc2addr: entry
nttbnd2addr: entry
nttbnd2addr: port resolved to 2929
nttbnd2addr: looking up IP addr for host: tcp2.oas.this.com
nttbnd2addr:  *** hostname lookup failure! ***
nttbnd2addr: exit

The problem in this case the tnsnames.ora, sqlnet.ora and hosts file had the following entries that
caused the the
lookup of the IP addr to fail when resolving the address in the host file.

TNSNAMES.ORA
~~~~~~~~~~~~~
HOST = 196.6.122.28 or tcp2

Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(Host=196.6.122.28)(Port=1521))(ADDRESS=(PROTOCOL=TCP)

SQLNET.ORA
~~~~~~~~~~~
names.default_domain = oas.this.com
name.default_zone = oas.this.com

HOST File (WINNT/system32/hosts)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
196.6.122.28     tcp2.oas.this.com


Solution Description
--------------------

To correct the problem ensure the following:

TNSNAMES.ORA
~~~~~~~~~~~~
HOST = tcp2.oas.this.com

SQLNET.ORA
~~~~~~~~~~
names.default_domain = oas.this.com
name.default_zone = oas.this.com

HOSTS File
~~~~~~~~~~
196.6.122.28     oas.this.com

Explanation
-----------
The Calling address in the tnsnames.ora and host file has a different domain_name then in the sqlnet.ora
thus
causing ORA-12545.


Problem Description
-------------------

The connection is refused. You know that the user exists and the password is
correct and the database is up.

You cannot connect from sql*plus on the client to your database. You get
the following error message;

ORA-12705 Invalid or unknown NLS parameter value specified.

Solution Description
--------------------

Check your NLS_LANG settings.
The value entered is incorrect or there is a typo error.
For example, the NLS_LANG value for the United States English should be:

NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
You do the following:

Create domain user accounts on Windows NT using Windows scripting, Enterprise
Administrator, or a third party administration tool.

Problem
=========
Certain users cannot authenticate successfully with any Oracle OLAP client
product, such as Express Spreadsheet Add-in (XSA), Express Admininstrator, or
Express Analyzer (OEA), but can authenticate successfully using the Express
Connection Utility if they do the following:

-  Open the Express Connection Utility.

-  Select Options...Set Domain Identity, and enter the User ID, Domain, and
Password.

-  Select Options...Set Authentication Level, and choose Connect.

-  Select File...Open, choose Connect to remote Express Server 5 or 6, and
enter the following information:

Object UUID:    <Your OES UUID>
Transport:      ncacn_ip_tcp
Host:           <Your host name>

Solution summary
================
In User Manager for Domains, check the Profile for the failing user and make
sure the Home Directory does not have a UNC address specified in the "Local
path:" field.
       
Authentication failure can occur if Oracle Express Server is not able to get a
valid Home Directory.  This can occur if, in the Windows NT User Environment
Profile, Home Directory groupbox, the "Local path:" option is chosen, but a UNC
path is referenced in the field, e.g.:

\\Servername\Sharename.

Only a local path on the machine is valid for this field.

You can check this by doing the following:

-  Login to the Domain Controller as an Administrator.

-  Run the User Manager for Domains utility in the Administrative Tools.

-  Double-click on a failing user to open the User Properties dialog box.

-  Click on the Profile button.

If the "Local path:" option is selected in the Home Directory groupbox,  a UNC
path such as \\Servername\Sharename is not valid.

Normally, if you select the "Local path:" option and try to enter a UNC path,
you will get an error message as follows:

\\Servername\Sharename is an invalid path name.  Please enter a valid path name.

If you are using Windows scripting or an administration tool such as Enterprise
Administrator to create user accouts, it may be possible to create a user
profile with an invalid UNC path in the "Local path:" field.
0
 
LVL 9

Expert Comment

by:ornicar
ID: 6237812
I am curious to know if Forms works on ME. After being installed, mine crashed at several places, and I moved to Win 2000. Just listening...

Dawnb, In order to have Forms connect to the database, be sure to copy tnsnames.ora, listener.ora and sqlnet.ora in the Forms' home respective directories as well.

0
 

Expert Comment

by:bek
ID: 6239064
Ornicar, I am having the same problem.  Everyone says Forms will NOT work on Windows ME.  I have yet to find anyone that has successfully made it work.

Can you be more specific about "Forms' home respective directories"?  Are you referring to the bin directory?

-Brian
0
 
LVL 9

Expert Comment

by:ornicar
ID: 6239584
No, I mean any .ora file in:

/network/admin
/NET80/TNSAPI
/NETWORK/ADMIN

must be the same, so if you have two Oracle homes, have the same copy of the file in both. Usually there is one for the database, one for forms.
I cannot tell exactly which file go in which... There is even a HKLM/Software/oracle registry key called TNS_ADMIN in which you specify a common directory.

<< I have yet to find anyone that has successfully made it work.>>  Not me! Maybe dawnbe?

Dawnbe. For a start, can you paste us your tnsname.ora, sqlnet.ora and listener.ora?
0
 

Author Comment

by:dawnb
ID: 6241504
The files were in several different directories.  I wasn't sure which you wanted to see, so I included all of them.  I included the directory I found each in as well:


# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:c:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

I found the following in the file:
C:\Oracle\Ora81\NETWORK\ADMIN\SAMPLE\TNSNAMES.ORA


# This file contains the syntax information for
# the entries to be put in any tnsnames.ora file
# The entries in this file are need based.
# There are no defaults for entries in this file
# that Sqlnet/Net3 use that need to be overridden
#
# Typically you could have two tnsnames.ora files
# in the system, one that is set for the entire system
# and is called the system tnsnames.ora file, and a
# second file that is used by each user locally so that
# he can override the definitions dictated by the system
# tnsnames.ora file.

# The entries in tnsnames.ora are an alternative to using
# the names server with the onames adapter.
# They are a collection of aliases for the addresses that
# the listener(s) is(are) listening for a database or
# several databases.

# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.

<alias>= [ (DESCRIPTION_LIST =  # Optional depending on whether u have
                        # one or more descriptions
                        # If there is just one description, unnecessary ]
        (DESCRIPTION=
          [ (SDU=2048) ]      # Optional, defaults to 2048
                        # Can take values between 512 and 32K
          [ (ADDRESS_LIST=    # Optional depending on whether u have
                        # one or more addresses
                        # If there is just one address, unnecessary ]
            (ADDRESS=
            [ (COMMUNITY=<community_name>) ]
            (PROTOCOL=tcp)
            (HOST=<hostname>)
            (PORT=<portnumber (1521 is a standard port used)>)
            )
            [ (ADDRESS=
              (PROTOCOL=ipc)
              (KEY=<ipckey (PNPKEY is a standard key used)>)      
            )
            ]
            [ (ADDRESS=
              [ (COMMUNITY=<community_name>) ]
              (PROTOCOL=decnet)
              (NODE=<nodename>)
              (OBJECT=<objectname>)
            )
            ]
              ... # More addresses
          [ ) ] # Optional depending on whether ADDRESS_LIST is used or not
          [ (CONNECT_DATA=
            (SID=<oracle_sid>)
            [ (GLOBAL_NAME=<global_database_name>) ]
            )
          ]
          [ (SOURCE_ROUTE=yes) ]  
        )
        (DESCRIPTION=    
          [ (SDU=2048) ]      # Optional, defaults to 2048
                        # Can take values between 512 and 32K
          [ (ADDRESS_LIST= ]      # Optional depending on whether u have more
                        # than one address or not
                        # If there is just one address, unnecessary
            (ADDRESS
            [ (COMMUNITY=<community_name>) ]
            (PROTOCOL=tcp)
            (HOST=<hostname>)
            (PORT=<portnumber (1521 is a standard port used)>)
            )
            [ (ADDRESS=
              (PROTOCOL=ipc)
              (KEY=<ipckey (PNPKEY is a standard key used)>)
               )
            ]
            ...             # More addresses
          [ ) ]             # Optional depending on whether ADDRESS_LIST  
                        # is being used
          [ (CONNECT_DATA=
            (SID=<oracle_sid>)
            [ (GLOBAL_NAME=<global_database_name>) ]
            )
          ]
          [ (SOURCE_ROUTE=yes) ]
        )
        [ (CONNECT_DATA=
            (SID=<oracle_sid>)
            [ (GLOBAL_NAME=<global_database_name>) ]
          )
        ]
        ...   # More descriptions
      [ ) ]      # Optional depending on whether DESCRIPTION_LIST is used or not



I found this in the file:
C:\class\NET80\ADMIN\TNSNAMES.ORA


Beq-local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = beq.world)
          (PROTOCOL = BEQ)
          (PROGRAM = oracle73)
          (ARGV0 = oracle73ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Example1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = Production1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = SID1)
    )
  )
Example2.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = spx.world)
          (PROTOCOL = SPX)
          (Service = Server_lsnr)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Example3.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = nmp.world)
          (PROTOCOL = NMP)
          (Server = FinanceServer1)
          (Pipe = ORAPIPE)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )




I'm pretty sure this is the exact same as the previous...but I found it in the file:
C:\class\NET80\ADMIN\SAMPLE\TNSNAMES.ORA



Beq-local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = beq.world)
          (PROTOCOL = BEQ)
          (PROGRAM = oracle73)
          (ARGV0 = oracle73ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Example1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = Production1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = SID1)
    )
  )
Example2.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = spx.world)
          (PROTOCOL = SPX)
          (Service = Server_lsnr)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Example3.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = nmp.world)
          (PROTOCOL = NMP)
          (Server = FinanceServer1)
          (Pipe = ORAPIPE)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )


I found this in the file:
C:\class\NET80\TNSAPI\TNSNAMES.ORA

Beq-local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = beq.world)
          (PROTOCOL = BEQ)
          (PROGRAM = oracle80)
          (ARGV0 = oracle80ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
tftp.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = hostname)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = tftp)
    )
  )
sfinger.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = hostname)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = sfinger)
    )
  )



I found this file under sqlnet.log

***********************************************************************
Fatal NI connect error 12538, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\ORACLE\ORA81\BIN\OSTART.EXE)(HOST=BHVSN01)(USER=default))))

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
  Time: 27-JUN-01 22:48:42
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12538
    TNS-12538: Message 12538 not found; No message file for product=NETWORK, facility=TNS
    ns secondary err code: 12560
    nt main err code: 508
    TNS-00508: Message 508 not found; No message file for product=NETWORK, facility=TNS
    nt secondary err code: 0
    nt OS err code: 0


***********************************************************************
Fatal NI connect error 12538, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\ORACLE\ORA81\BIN\OSTART.EXE)(HOST=BHVSN01)(USER=default))))

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
  Time: 27-JUN-01 22:48:42
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12538
    TNS-12538: Message 12538 not found; No message file for product=NETWORK, facility=TNS
    ns secondary err code: 12560
    nt main err code: 508
    TNS-00508: Message 508 not found; No message file for product=NETWORK, facility=TNS
    nt secondary err code: 0
    nt OS err code: 0


***********************************************************************
Fatal NI connect error 12538, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\ORACLE\ORA81\BIN\OSTART.EXE)(HOST=BHVSN01)(USER=default))))

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
  Time: 27-JUN-01 23:02:33
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12538
    TNS-12538: Message 12538 not found; No message file for product=NETWORK, facility=TNS
    ns secondary err code: 12560
    nt main err code: 508
    TNS-00508: Message 508 not found; No message file for product=NETWORK, facility=TNS
    nt secondary err code: 0
    nt OS err code: 0


***********************************************************************
Fatal NI connect error 12538, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\ORACLE\ORA81\BIN\OSTART.EXE)(HOST=BHVSN01)(USER=default))))

  VERSION INFORMATION:
      TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
  Time: 27-JUN-01 23:02:33
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12538
    TNS-12538: Message 12538 not found; No message file for product=NETWORK, facility=TNS
    ns secondary err code: 12560
    nt main err code: 508
    TNS-00508: Message 508 not found; No message file for product=NETWORK, facility=TNS
    nt secondary err code: 0
    nt OS err code: 0

This was in the file:
C:\Oracle\Ora81\NETWORK\ADMIN\SAMPLE\SQLNET.ORA

# copyright (c) 1996 by the Oracle Corporation
#
# NAME
#   sqlnet.ora
# FUNCTION
#   Oracle Network Client startup parameter file example
# NOTES
#   This file contains examples and instructions for defining all
#   Oracle Network Client parameters. It should be possible to read
#   this file and setup a Client by uncommenting parameter definitions
#   and substituting values. The comments should provide enough
#   explanation to enable a reasonable user to manage his TNS connections
#   without having to resort to 'real' documentation.
# SECTIONS
#   ONames Client
#   Namesctl
#   Native Naming Adpaters
#   ...
# MODIFIED
#    jtran      03/24/98 - add radius configuration
#    skanjila   06/06/97 - Correct default for Automatic_IPC
#    eminer     05/15/97 - Add the relevant onrsd parameters.
#    asriniva   04/23/97 - Merge with version from doc
#    ggilchri   03/31/97 - mods
#    bvasudev   02/07/97 - Change sqlnet.authentication_services documentation
#    bvasudev   11/25/96 - Merge sqlnet.ora transport related parameters
#    asriniva   11/12/96 - Revise with new OSS parameters.
#    asriniva   11/05/96 - Add ANO parameters.
# ____________________________________________________________________

# - ONames Client ----------------------------------------------------
#
#names.default_domain = world
#
#Syntax:  domain-name
#Default: NULL
#
# Indicates the domain from which the client most often requests names. When
# this parameter is set the default domain name (for example, US.ACME), the
# domain name will be automatically appended to any unqualified name in an
# ONAmes request (query, register, deregister, etc). Any name which contains
# an unescaped dot ('.') will not have the default domain appended. Simple
# names may be qualified with a trailing dot (for example 'rootserver.').
#
#
#names.initial_retry_timeout = 30
#
#Syntax:  1-600 seconds
#Default: 15 (OSD)
#
# Determines how long a client will wait for a response from a Names Server
# before reiterating the request to the next server in the preferred_servers
# list.
#
#
#names.max_open_connections = 3
#
#Syntax:  3-64
#Default: ADDRS in preferred_servers
#
# Determines how many connections an ONames client may have open at one time.
# Clients will ordinarily keep connections to servers open once they are
# established until the operation (or session in namesctl) is complete. A
# connection will be opened whenever needed, and if the maximum would be
# exceeded the least recently used connection will be closed.
#
#
#names.message_pool_start_size = 10
#
#Syntax:  3-256
#Default: 10
#
# Determines the initial number of messages allocated in the client's message
# pool. This pool provides the client with pre-allocated messages to be used
# for requests to ONames servers. Messages which are in the pool and unused
# may be reused. If a message is needed and no free messages are available in
# the pool more will be allocated.
#
#
#names.preferred_servers = (address_list =
#  (address=(protocol=ipc)(key=n23))
#  (address=(protocol=tcp)(host=nineva)(port=1383))
#  (address=(protocol=tcp)(host=cicada)(port=1575))
# )
#
#Syntax:  ADDR_LIST
#Default: Well-Known (OSD)
#
# Specifies a list of ONames servers in the client's region; requests will be
# sent to each ADDRESS in the list until a response is recieved, or the list
# (and number of retries) is exhausted.
#
# Addresses of the following form specify that messages to the ONames server
# should use Oracle Remote Operations (RPC):
#
#     (description =
#       (address=(protocol=tcp)(host=nineva)(port=1383))
#       (connect_data=(rpc=on))
#     )
#
#
#
#names.request_retries = 2
#
#Syntax:  1-5
#Default: 1
#
# Specifies the number of times the client should try each server in the list
# of preferred_servers before allowing the operation to fail.
#
#
#names.directory_path
#
#Syntax:  <adapter-name>
#Default: TNSNAMES,ONAMES,HOSTNAME
#
# Sets the (ordered) list of naming adaptors to use in resolving a name.
# The default is as shown for 3.0.2 of sqlnet onwards. The default was
# (TNSNAMES, ONAMES) before that. The value can be presented without
# parentheses if only a single entry is being specified. The parameter is
# recognized from version 2.3.2 of sqlnet onward. Acceptable values include:
#  TNSNAMES -- tnsnames.ora lookup
#  ONAMES   -- Oracle Names
#  HOSTNAME -- use the hostname (or an alias of the hostname)
#  NIS      -- NIS (also known as "yp")
#  CDS      -- OSF DCE's Cell Directory Service
#  NDS      -- Novell's Netware Directory Service
#
# - Client Cache (ONRSD) ---------------------------------------------
names.addresses = (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))

Syntax:  ADDR
Default: (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))

 Address on which the client cache listens (is available to clients).
 Any valid TNS address is allowed. The default should be used if at
 all possible; clients have this entry hardwired as the first line
 of their server-list file (sdns.ora). If the address is set to a
 non-default value the client's preferred_servers parameter should
 be set to include the client-cache address first.


names.authority_required = False

Syntax:  T/F
Default: False

 Determines whether system querys (for the root etc) require Authoritative
 answers.


names.auto_refresh_expire = 259200

Syntax:  Number of seconds, 60-1209600
Default: 259200

 This is the amount of time (in seconds) the server will cache the addresses
 of servers listed in server-list file (sdns.ora). When this time expires the
 server will issue another query to the servers in those regions to refresh
 the data.


names.auto_refresh_retry = 180

Syntax:  Number of seconds, 60-3600
Default: sec.      180

 This set how often the server will retry when the auto_refresh query fails.


names.cache_checkpoint_file = cache.ckp

Syntax:  filename
Default: $ORACLE_HOME/network/names/ckpcch.ora

 Specifies the name of the operating system file to which the Names Server
 writes its foreign data cache.


names.cache_checkpoint_interval = 7200

Syntax:  Number of seconds, 10-259200
Default: 0 (off)

 Indicates the interval at which a Names Server writes a checkpoint of its
 data cache to the checkpoint file.


names.default_forwarders=
 (FORWARDER_LIST=
    (FORWARDER=
       (NAME= rootserv1.world)
       (ADDRESS=(PROTOCOL=tcp)(PORT=42100)(HOST=roothost))))

Syntax:  Name-Value/address_list
Default: NULL

 A list (in NV form) of the addresses of other servers which should be used to
 forward querys while in default_forwarder (slave) mode. NAME is the global
 names for the server to which forwards whould be directed, and ADDRESS is its
 address.


names.default_forwarders_only = True

Syntax:  T/F
Default: False

 When set to true this server will use the servers listed in default_forwarders
 to forward all operations which involve data in foreign regions. Otherwise it
 will use the servers defined in the server-list file (sdns.ora) in addition
 to any defined in the default_forwarders parameter.


names.log_directory = /oracle/network/log

Syntax:  directory
Default: $ORACLE_HOME/network/log

 Indicates the name of the directory where the log file for Names Server
 operational events are written.


names.log_file = names.log

Syntax:  filename
Default: names.log

 The name of the output file to which Names Server operational events are
 written.

names.log_stats_interval = 3600

Syntax:  Number of seconds, 10-ub4max
Default: sec.      0 (off)

Specifies the number of seconds between statistical entries in log file.

names.log_unique = False

Syntax:  T/F
Default: False

 If set to true the server will guarantee that the log file will have a unique
 name which will not overwrite any existing files (note that log files are
 appended to, so log information will not be lost if log_unique is not true).

names.max_open_connections = 10

Syntax:  3-64
Default: 10

 Specifies the number of connections that the Names Server can have open at any
 given time. The value is generated as the value 10 or the sum of one
 connection for listening, five for clients, plus one for each foreign domain
 defined in the local administrative region, whichever is greater. Any
 operation which requires the server to open a network connection will use
 an already open connection if it is available, or will open a connection
 if not. Higher settings will save time and cost network resources; lower
 settings save network resources, cost time.


names.max_reforwards = 2

Syntax:  1-15
Default: 2

 The maximum number of times the server will attempt to forward a certain
 operation.


names.message_pool_start_size = 24

Syntax:  3-256
Default: 10

 Determines the initial number of messages allocated in the server's message
 pool. This pool provides the server with pre-allocated messages to be used
 for incoming or outgoing messages (forwards). Messages which are in the pool
 and unused may be reused. If a message is needed and no free messages are
 available in the pool more will be allocated.


names.no_modify_requests = False

Syntax:  T/F
Default: False

 If set to true, the server will refuse any operations which modify the
 data in its region (it will still save foreign info in the cache which is
 returned from foreign querys).


names.password = 625926683431AA55

Syntax:  encrypted string
Default: NULL

 If set the server will require that the user provide a password in his
 namesctl session (either with sqlnet.ora:namesctl.server_password or 'set
 password') in order to do 'sensitive' operations, like stop, restart, reload.
 This parameter is generally set in encrypted form, so it can not be set
 manually.

names.reset_stats_interval = 3600

Syntax:  10-ub4max
Default: 0 (off)

 Specifies the number of seconds during which the statistics collected by the
 Names Servers should accumulate. At the frequency specified, they are reset
 to zero. The default value of 0 means never reset statistics.


names.trace_directory = /oracle/network/trace

Syntax:  directory
Default: $ORACLE_HOME/network/trace

 Indicates the name of the directory to which trace files from a Names Server
 trace session are written.


names.trace_file = names.trc

Syntax:  filename
Default: names.trc

 Indicates the name of the output file from a Names Server trace session.


names.trace_func # NA

Syntax:  T/F
Default: False

 Internal mechanism to control tracing by function name.


names.trace_level = ADMIN

Syntax:  T/F
Default: False

Syntax:  {OFF,USER,ADMIN,0-16}
Default: OFF (0)

 Indicates the level at which the Names Server is to be traced.
 Available Values:
      0 or OFF - No trace output
      4 or USER - User trace information
      10 or ADMIN - Administration trace information
      16 or SUPPORT - WorldWide Customer Support trace information


names.trace_mask = (200,201,202,203,205,206,207)

Syntax:  list of numbers
Default: NULL

 Internal mechanism to control trace behavior.


names.trace_unique = True

Syntax:  T/F
Default: False

 Indicates whether each trace file has a unique name, allowing multiple trace
 files to coexist. If the value is set to ON, a process identifier is appended
 to the name of each trace file generated.


# - Namesctl ---------------------------------------------------------
#
#namesctl.trace_directory = /oracle/network/trace
#
#Syntax:  directory
#Default: $ON/trace
#
# Indicates the name of the directory to which trace files from a namesctl
# trace session are written.
#
#
#namesctl.trace_file = namesctl.trc
#
#Syntax:  filename
#Default: namesctl.trc
#
# Indicates the name of the output file from a namesctl trace session.
#
#
#namesctl.trace_func # NA
#
#Syntax:  word list
#Default: NULL
#
# Internal mechanism to control tracing by function name.
#
#
#namesctl.trace_level = ADMIN
#
#Syntax:  {OFF,USER,ADMIN,0-16}
#Default: OFF (0)
#
# Indicates the level at which the namesctl is to be traced.
# Available Values:
#      0 or OFF - No trace output
#      4 or USER - User trace information
#      10 or ADMIN - Administration trace information
#      16 or SUPPORT - WorldWide Customer Support trace information
#
#
#namesctl.trace_mask # NA
#
#Syntax:  number list
#Default: NULL
#
# Internal mechanism to control trace behavior.
#
#
#namesctl.trace_unique = True
#
#Syntax:  T/F
#Default: False
#
# Indicates whether each trace file has a unique name, allowing multiple trace
# files to coexist. If the value is set to ON, a process identifier is appended
# to the name of each trace file generated.
#
#
#namesctl.no_initial_server = False
#
#Syntax:  T/F
#Default: False
#
# If set to TRUE namesctl will suppress any error messages when namesctl is
# unable to connect to a default names server.
#
#
#namesctl.internal_use = True
#
#Syntax:  T/F
#Default: False
#
# If set to true namesctl will enable a set of internal undocumented commands.
# All internal commands are preceded by an underscore ('_') in order to
# distinguish them as internal. Without going into details, the commands
# enabled are:
#
#     _add_data              _create_name           _delete_name          
#     _full_status           _ireplace_data         _newttl_name          
#     _pause                 _remove_data           _rename_name          
#     _replace_data          _start                 _walk*                
#
# There are also a set of names server variables which may be set when
# namesctl is in internal mode:
#
#     _authority_required             _auto_refresh*                  
#     _cache_checkpoint_interval      _cache_dump                    
#     _default_autorefresh_expire     _default_autorefresh_retry      
#     _default_forwarders_only        _forwarding_desired            
#     _max_reforwards                 _modify_ops_enabled            
#     _next_cache_checkpoint          _next_cache_flush              
#     _next_stat_log                  _next_stat_reset                
#     _reload                         _request_delay                  
#     _restart                        _shutdown                      
#
#
#namesctl.noconfirm = True
#
#Syntax:  T/F
#Default: False
#
# When set to TRUE namesctl will suppress the confirmation prompt when
# sensitive operations (stop, restart, reload) are requested. This is
# quite helpful when using namesctl scripts.
#
#
#namesctl.server_password = mangler
#
#Syntax:  string
#Default: NULL
#
# Automatically sets the password for the names server in order to perform
# sensitive operations (stop, restart, reload). The password may also be
# set manually during a namesctl session using 'set password'.
#
#
#namesctl.internal_encrypt_password = False
#
#Syntax:  T/F
#Default: True
#
# When set to TRUE namesctl will not encrypt the password when it is sent to
# the names server. This would enable an unencrypted password to be set in
# names.ora:names.server_password
#
# - Native Naming Adpaters -------------------------------------------
#
#names.dce.prefix = /.:/subsys/oracle/names
#
#Syntax:  DCE cell name
#Default: /.:/subsys/oracle/names
#
#Specifies the DCE cell (prefix) to use for name lookup.
#
#
#names.nds.name_context = personnel.acme
#
#Syntax:  NDS name
#Default: (OSD?)
#
# Specifies the default NDS name context in which to look for the name to
# be resolved.
#
#
#names.nis.meta_map # NA
#
# Syntax:  filename
# Default: sqlnet.maps
#
# Specifies the file to be used to map NIS attributes to an NIS mapname.
# Currently unused.

# - Advanced Networking Option Authentication Adapters ----------------

#sqlnet.authentication_services
#
# Syntax: A single value or a list from {beq, none, all, kerberos5,
#        cybersafe, securid, identitx}
# Default: NONE
#
# Enables one or more authentication services.  To enable
# authentication via the Oracle Security Server, use (beq, oss).  If
# the Advanced Networking Option has been installed with Kerberos5
# support, using (beq, kerberos5) would enable authentication via
# Kerberos.
#
#sqlnet.authentication_services=(beq, oss)
 
##
## Parmeters used with Kerberos adapter.
##

#sqlnet.kerberos5_cc_name
#
# Syntax: Any valid pathname.
# Default: /tmp/krb5cc_<uid>
#
# The Kerberos credential cache pathname.
#
#sqlnet.kerberos5_cc_name=/tmp/mycc

#sqlnet.kerberos5_clockskew
#
# Syntax: Any positive integer.
# Default: 300
#
# The acceptable difference in the number of seconds between when a
# credential was sent and when it was received.
#
#sqlnet.kerberos5_clockskew=600

#sqlnet.kerberos5_conf
#
# Syntax: Any valid pathname.
# Default: /krb5/krb.conf
#
# The Kerberos configuration pathname.
#
#sqlnet.kerberos5_conf=/tmp/mykrb.conf

#sqlnet.kerberos5_realms
#
# Syntax: Any valid pathname
# Default: /krb5/krb.realms
#
# The Kerberos host name to realm translation file.
#
#sqlnet.kerberos5_realms=/tmp/mykrb.realms

#sqlnet.kerberos5_keytab
#
# Syntax: Any valid pathname.
# Default: /etc/v5srvtab
#
# The Kerberos secret key file.
#
#sqlnet.kerberos5_keytab=/tmp/myv5srvtab

#sqlnet.authentication_kerberos5_service
#
# Syntax: Any string.
# Default: A default is not provided.
#
# The Kerberos service name.
#
#sqlnet.authentication_kerberos5_service=acme

##
## Parmeters used with CyberSAFE adapter.
##

#sqlnet.authentication_gssapi_service
#
# Syntax: A correctly formatted service principal string.
# Default: A default is not provided.
#
# The CyberSAFE service principal
#
#sqlnet.authentication_gssapi_service=acme/asriniva.us.oracle.com@US.ORACLE.COM
 
##
## Parmeters used with Identix adapter.
##

#sqlnet.identix_fingerprint_method
#
# Syntax: Must be oracle.
# Default: A default is not provided.
#
# The Identix authentication server method
#
#sqlnet.identix_fingerprint_method=oracle

#sqlnet.identix_fingerprint_database
#
# Syntax: Any string.
# Default: A default is not provided.
#
# The Identix authentication server TNS alias
#
#sqlnet.identix_fingerprint_database=ofm

#sqlnet.identix_fingerprint_database_user
#
# Syntax: Any string
# Default: A default is not provided.
#
# The Identix authentication service well known username.
#
#sqlnet.identix_fingerprint_database_user=ofm_client

#sqlnet.identix_fingerprint_database_password
#
# Syntax: Any string
# Default: A default is not provided.
#
# The Identix authentication service well known password.
#
#sqlnet.identix_fingerprint_database_password=ofm_client

# - Advanced Networking Option - Radius Adapter
# Need to specify the location of the Radius server
#sqlnet.radius_authentication = localhost

# Need to specify the port address of the Radius server
#sqlnet.radius_authentication_port = 1654

# If your radius server support accounting, you can enable it
#sqlnet.radius_accounting = off

# Turn on/off challenge response
#sqlnet.radius_challenge_response = off

# Keyword to request a challenge from Radius server.  
# If you use activcard, enter activcard

# If you use something else, enter challenge
#sqlnet.radius_challenge_keyword = challenge

# Enter the name of the client interface you want to use for challenge response
#sqlnet.radius_authentication_interface = DefaultRadiusInterface

# Where is the secret file locate
#sqlnet.radius_secret = $ORACLE_HOME/security/radius.key
 

# - Advanced Networking Option Network Security -------------------------

#sqlnet.crypto_checksum_client
#sqlnet.crypto_checksum_server
#sqlnet.encryption_client
#sqlnet.encryption_server
#
# These four parameters are used to specify whether a service (e.g.
# crypto-checksumming or encryption) should be active:
#
# Each of the above parameters defaults to ACCEPTED.
#
# Each of the above parameters can have one of four possible values:
#
# value            meaning
#
# ACCEPTED      The service will be active if the other side of the
#            connection specifies "REQUESTED" or REQUIRED" and
#            there is a compatible algorithm available on the other
#            side; it will be inactive otherwise.
#
# REJECTED      The service must not be active, and the connection
#            will fail if the other side specifies "REQUIRED".
#
# REQUESTED      The service will be active if the other side specifies
#            "ACCEPTED", "REQUESTED", or "REQUIRED" and there is a
#            compatible algorithm available on the other side; it
#            will be inactive otherwise.
#
# REQUIRED      The service must be active, and the connection will
#            fail if the other side specifies "REJECTED" or if there
#            is no compatible algorithm on the other side.
#
#sqlnet.crypto_checksum_types_client
#sqlnet.crypto_checksum_types_server
#sqlnet.encryption_types_client
#sqlnet.encryption_types_server
#
# These parameters control which algorithms will be made available for
# each service on each end of a connection:
#
# The value of each of these parameters can be either a parenthesized
# list of algorithm names separated by commas or a single algorithm
# name.
#
# Encryption types can be: RC4_40, RC4_56, RC4_128, DES, DES40
#
# Encryption defaults to all the algorithms.
#
# Crypto checksum types can be: MD5
#
# Crypto checksum defaults to MD5.
#
#sqlnet.crypto_seed ="4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf"
#sqlnet.crypto_checksum_server = required
#sqlnet.encryption_server = required

# - Oracle Security Server ---------------------------------------------

#oss.source.my_wallet
#
# Syntax: A properly formatted NLNV list.
# Default: Platform specific.  Unix: $HOME/oracle/oss
#
# The method for retrieving and storing my identity.  
#
#oss.source.my_wallet
#   =(source
#       =(method=file)
#        (method_data=/dve/asriniva/oss/wallet)
#     )

#oss.source.location
#
# Syntax: A properly formatted NLNV list.
# Default: Oracle method, oracle_security_service/oracle_security_service@oss
#
# The method for retrieving encrypted private keys.
#
#oss.source.location
#   =(source
#       =(method=oracle)
#        (method_data=
#           (sqlnet_address=andreoss)
#        )
#    )

# - Sqlnet(v2.x) and Net3.0 Client ------------------------------------------

#
# In the following descriptions, the term "client program" could mean
# either sqlplus, svrmgrl or any other OCI programs written by users
#
###########################
#trace_level_client = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the client program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#      4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#      16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since:  v2.0
#
###############################################
#trace_directory_client = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network/trace  ($ORACLE_HOME=/oracle at customer
#         site)
#
#Purpose: Indicates the name of the directory to which trace files from
#         the client execution are written.
#
#Supported since: v2.0
#
###################################################
#trace_file_client =  /oracle/network/trace/cli.trc
###################################################
#
#Possible values: Any valid file name
#Default:        $ORACLE_HOME/network/trace/cli.trc ($ORACLE_HOME =
#              /oracle at customer site)
#
#Purpose: Indicates the name of the file to which the execution trace
#         of the client is written to.
#
#Supported since: v2.0
#
###########################
#trace_unique_client = ON
###########################
#
#Possible values: {ON, OFF}
#Default: OFF
#
#Purpose: Used to make each client trace file have a unique name to
#        prevent each trace file from being overwritten by successive
#        runs of the client program
#
#Supported since: v2.0
#
###########################################
#log_directory_client = /oracle/network/log
###########################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/log  ($ORACLE_HOME = /oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which the client log file
#        is written to.
#
#
#Supported since: v2.0
#
################
#log_file_client = /oracle/network/log/sqlnet.log
################
#
#Possible values: This is a default value, u cannot change this
#Default: $ORACLE_HOME/network/log/sqlnet.log  ($ORACLE_HOME=/oracle in
#         customer site)
#
#Purpose: Indicates the name of the log file from a client program
#
#Supported since: v2.0
#
#############################################
#log_directory_server = /oracle/network/trace
#############################################
#
#Possible values: Any valid diretcory path with write permission
#Default: $ORACLE_HOME/network/trace ( $ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which log files from the
#         server are written
#
#Supported since:  v2.0
#
###############################################
#trace_directory_server = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network_trace ( $ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which trace files from
#         the server are written
#
#Supported since:  v2.0
#
#######################################################
#trace_file_server = /orace/network/trace/svr_<pid>.trc
#######################################################
#
#Possible values: Any valid filename
#Default: $ORACLE_HOME/network/trace/svr_<pid>.trc where <pid? stands for
#         the process id of the server on UNIX systems
#
#Purpose: Indicates the name of the file to which the execution trace of
#         the server program is written to.
#
#Supported since: v2.0
#
###########################
#trace_level_server = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since: v2.0
#
##########################
#use_dedicated_server = ON
##########################
#
#Possible values: {OFF,ON}
#Default:         OFF
#
#Purpose: Forces the listener to spawn a dedicated server process for
#        sessions from this client program.
#
#Supported since: v2.0
#
################
#use_cman = TRUE
################
#
#Possible values: {TRUE, FALSE}
#Default:        FALSE
#
#Purpose:
#
#Supported since: v3.0
#
################################################
#tnsping.trace_directory = /oracle/network/trace
################################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/trace ($ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the directory to which the execution trace from
#        the tnsping program is to be written to.
#
#Supported since: v2.0
#
############################
#tnsping.trace_level = ADMIN    
############################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#
#Supported since: v2.0
#
########################
#sqlnet.expire_time = 10
########################
#
#Possible values: 0-any valid positive integer! (in minutes)
#Default: 0 minutes
#Recommended value: 10 minutes
#
#Purpose: Indicates the time interval to send a probe to verify the
#        client session is alive (this is used to reclaim watseful
#        resources on a dead client)
#
#Supported since: v2.1
#
#######################################
#sqlnet.client_registration = <unique_id>
#######################################
#
#Possible values:
#Default:     OFF
#
#Purpose: Sets a unique identifier for the client machine. This
#        identifier is then passed to the listener with any connection
#        request and will be included in the Audit Trail. The identifier
#        can be any alphanumeric string up to 128 characters long.
#
#Supported since: v2.3.2
#
######################
#bequeath_detach = YES
######################
#
#Possible values: {YES,NO}
#Default:         NO
#
#Purpose: Turns off signal handling on UNIX systems. If signal handling
#        were not turned off and if client programs written by users make
#        use of signal handling they could interfere with Sqlnet/Net3.
#
#Supported since: v2.3.3
#
####################
#automatic_ipc = OFF
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: Force a session to use or not to use IPC addresses on the
#        client's node.
#
#Supported since: v2.0
#
####################
#disable_oob = ON
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: If the underlying transport protocol (TCP, DECnet,...) does
#         not support Out-of-band breaks, then disable out-of-band
#        breaks
#
#Supported since: v2.0
#



File:
C:\class\NET80\ADMIN\SQLNET.ORA

# copyright (c) 1996 by the Oracle Corporation
#
# NAME
#   sqlnet.ora
# FUNCTION
#   Oracle Network Client startup parameter file example
# NOTES
#   This file contains examples and instructions for defining all
#   Oracle Network Client parameters. It should be possible to read
#   this file and setup a Client by uncommenting parameter definitions
#   and substituting values. The comments should provide enough
#   explanation to enable a reasonable user to manage his TNS connections
#   without having to resort to 'real' documentation.
# SECTIONS
#   ONames Client
#   Namesctl
#   Native Naming Adpaters
#   ...
# MODIFIED
#    skanjila   06/06/97 - Correct default for Automatic_IPC
#    eminer     05/15/97 - Add the relevant onrsd parameters.
#    asriniva   04/23/97 - Merge with version from doc
#    ggilchri   03/31/97 - mods
#    bvasudev   02/07/97 - Change sqlnet.authentication_services documentation
#    bvasudev   11/25/96 - Merge sqlnet.ora transport related parameters
#    asriniva   11/12/96 - Revise with new OSS parameters.
#    asriniva   11/05/96 - Add ANO parameters.
# ____________________________________________________________________

# - ONames Client ----------------------------------------------------
#
#names.default_domain = world
#
#Syntax:  domain-name
#Default: NULL
#
# Indicates the domain from which the client most often requests names. When
# this parameter is set the default domain name (for example, US.ACME), the
# domain name will be automatically appended to any unqualified name in an
# ONAmes request (query, register, deregister, etc). Any name which contains
# an unescaped dot ('.') will not have the default domain appended. Simple
# names may be qualified with a trailing dot (for example 'rootserver.').
#
#
#names.initial_retry_timeout = 30
#
#Syntax:  1-600 seconds
#Default: 15 (OSD)
#
# Determines how long a client will wait for a response from a Names Server
# before reiterating the request to the next server in the preferred_servers
# list.
#
#
#names.max_open_connections = 3
#
#Syntax:  3-64
#Default: ADDRS in preferred_servers
#
# Determines how many connections an ONames client may have open at one time.
# Clients will ordinarily keep connections to servers open once they are
# established until the operation (or session in namesctl) is complete. A
# connection will be opened whenever needed, and if the maximum would be
# exceeded the least recently used connection will be closed.
#
#
#names.message_pool_start_size = 10
#
#Syntax:  3-256
#Default: 10
#
# Determines the initial number of messages allocated in the client's message
# pool. This pool provides the client with pre-allocated messages to be used
# for requests to ONames servers. Messages which are in the pool and unused
# may be reused. If a message is needed and no free messages are available in
# the pool more will be allocated.
#
#
#names.preferred_servers = (address_list =
#  (address=(protocol=ipc)(key=n23))
#  (address=(protocol=tcp)(host=nineva)(port=1383))
#  (address=(protocol=tcp)(host=cicada)(port=1575))
# )
#
#Syntax:  ADDR_LIST
#Default: Well-Known (OSD)
#
# Specifies a list of ONames servers in the client's region; requests will be
# sent to each ADDRESS in the list until a response is recieved, or the list
# (and number of retries) is exhausted.
#
# Addresses of the following form specify that messages to the ONames server
# should use Oracle Remote Operations (RPC):
#
#     (description =
#       (address=(protocol=tcp)(host=nineva)(port=1383))
#       (connect_data=(rpc=on))
#     )
#
#
#
#names.request_retries = 2
#
#Syntax:  1-5
#Default: 1
#
# Specifies the number of times the client should try each server in the list
# of preferred_servers before allowing the operation to fail.
#
#
#names.directory_path
#
#Syntax:  <adapter-name>
#Default: TNSNAMES,ONAMES,HOSTNAME
#
# Sets the (ordered) list of naming adaptors to use in resolving a name.
# The default is as shown for 3.0.2 of sqlnet onwards. The default was
# (TNSNAMES, ONAMES) before that. The value can be presented without
# parentheses if only a single entry is being specified. The parameter is
# recognized from version 2.3.2 of sqlnet onward. Acceptable values include:
#  TNSNAMES -- tnsnames.ora lookup
#  ONAMES   -- Oracle Names
#  HOSTNAME -- use the hostname (or an alias of the hostname)
#  NIS      -- NIS (also known as "yp")
#  CDS      -- OSF DCE's Cell Directory Service
#  NDS      -- Novell's Netware Directory Service
#
# - Client Cache (ONRSD) ---------------------------------------------
names.addresses = (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))

Syntax:  ADDR
Default: (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))

 Address on which the client cache listens (is available to clients).
 Any valid TNS address is allowed. The default should be used if at
 all possible; clients have this entry hardwired as the first line
 of their server-list file (sdns.ora). If the address is set to a
 non-default value the client's preferred_servers parameter should
 be set to include the client-cache address first.


names.authority_required = False

Syntax:  T/F
Default: False

 Determines whether system querys (for the root etc) require Authoritative
 answers.


names.auto_refresh_expire = 259200

Syntax:  Number of seconds, 60-1209600
Default: 259200

 This is the amount of time (in seconds) the server will cache the addresses
 of servers listed in server-list file (sdns.ora). When this time expires the
 server will issue another query to the servers in those regions to refresh
 the data.


names.auto_refresh_retry = 180

Syntax:  Number of seconds, 60-3600
Default: sec.      180

 This set how often the server will retry when the auto_refresh query fails.


names.cache_checkpoint_file = cache.ckp

Syntax:  filename
Default: $ORACLE_HOME/network/names/ckpcch.ora

 Specifies the name of the operating system file to which the Names Server
 writes its foreign data cache.


names.cache_checkpoint_interval = 7200

Syntax:  Number of seconds, 10-259200
Default: 0 (off)

 Indicates the interval at which a Names Server writes a checkpoint of its
 data cache to the checkpoint file.


names.default_forwarders=
 (FORWARDER_LIST=
    (FORWARDER=
       (NAME= rootserv1.world)
       (ADDRESS=(PROTOCOL=tcp)(PORT=42100)(HOST=roothost))))

Syntax:  Name-Value/address_list
Default: NULL

 A list (in NV form) of the addresses of other servers which should be used to
 forward querys while in default_forwarder (slave) mode. NAME is the global
 names for the server to which forwards whould be directed, and ADDRESS is its
 address.


names.default_forwarders_only = True

Syntax:  T/F
Default: False

 When set to true this server will use the servers listed in default_forwarders
 to forward all operations which involve data in foreign regions. Otherwise it
 will use the servers defined in the server-list file (sdns.ora) in addition
 to any defined in the default_forwarders parameter.


names.log_directory = /oracle/network/log

Syntax:  directory
Default: $ORACLE_HOME/network/log

 Indicates the name of the directory where the log file for Names Server
 operational events are written.


names.log_file = names.log

Syntax:  filename
Default: names.log

 The name of the output file to which Names Server operational events are
 written.

names.log_stats_interval = 3600

Syntax:  Number of seconds, 10-ub4max
Default: sec.      0 (off)

Specifies the number of seconds between statistical entries in log file.

names.log_unique = False

Syntax:  T/F
Default: False

 If set to true the server will guarantee that the log file will have a unique
 name which will not overwrite any existing files (note that log files are
 appended to, so log information will not be lost if log_unique is not true).

names.max_open_connections = 10

Syntax:  3-64
Default: 10

 Specifies the number of connections that the Names Server can have open at any
 given time. The value is generated as the value 10 or the sum of one
 connection for listening, five for clients, plus one for each foreign domain
 defined in the local administrative region, whichever is greater. Any
 operation which requires the server to open a network connection will use
 an already open connection if it is available, or will open a connection
 if not. Higher settings will save time and cost network resources; lower
 settings save network resources, cost time.


names.max_reforwards = 2

Syntax:  1-15
Default: 2

 The maximum number of times the server will attempt to forward a certain
 operation.


names.message_pool_start_size = 24

Syntax:  3-256
Default: 10

 Determines the initial number of messages allocated in the server's message
 pool. This pool provides the server with pre-allocated messages to be used
 for incoming or outgoing messages (forwards). Messages which are in the pool
 and unused may be reused. If a message is needed and no free messages are
 available in the pool more will be allocated.


names.no_modify_requests = False

Syntax:  T/F
Default: False

 If set to true, the server will refuse any operations which modify the
 data in its region (it will still save foreign info in the cache which is
 returned from foreign querys).


names.password = 625926683431AA55

Syntax:  encrypted string
Default: NULL

 If set the server will require that the user provide a password in his
 namesctl session (either with sqlnet.ora:namesctl.server_password or 'set
 password') in order to do 'sensitive' operations, like stop, restart, reload.
 This parameter is generally set in encrypted form, so it can not be set
 manually.

names.reset_stats_interval = 3600

Syntax:  10-ub4max
Default: 0 (off)

 Specifies the number of seconds during which the statistics collected by the
 Names Servers should accumulate. At the frequency specified, they are reset
 to zero. The default value of 0 means never reset statistics.


names.trace_directory = /oracle/network/trace

Syntax:  directory
Default: $ORACLE_HOME/network/trace

 Indicates the name of the directory to which trace files from a Names Server
 trace session are written.


names.trace_file = names.trc

Syntax:  filename
Default: names.trc

 Indicates the name of the output file from a Names Server trace session.


names.trace_func # NA

Syntax:  T/F
Default: False

 Internal mechanism to control tracing by function name.


names.trace_level = ADMIN

Syntax:  T/F
Default: False

Syntax:  {OFF,USER,ADMIN,0-16}
Default: OFF (0)

 Indicates the level at which the Names Server is to be traced.
 Available Values:
      0 or OFF - No trace output
      4 or USER - User trace information
      10 or ADMIN - Administration trace information
      16 or SUPPORT - WorldWide Customer Support trace information


names.trace_mask = (200,201,202,203,205,206,207)

Syntax:  list of numbers
Default: NULL

 Internal mechanism to control trace behavior.


names.trace_unique = True

Syntax:  T/F
Default: False

 Indicates whether each trace file has a unique name, allowing multiple trace
 files to coexist. If the value is set to ON, a process identifier is appended
 to the name of each trace file generated.


# - Namesctl ---------------------------------------------------------
#
#namesctl.trace_directory = /oracle/network/trace
#
#Syntax:  directory
#Default: $ON/trace
#
# Indicates the name of the directory to which trace files from a namesctl
# trace session are written.
#
#
#namesctl.trace_file = namesctl.trc
#
#Syntax:  filename
#Default: namesctl.trc
#
# Indicates the name of the output file from a namesctl trace session.
#
#
#namesctl.trace_func # NA
#
#Syntax:  word list
#Default: NULL
#
# Internal mechanism to control tracing by function name.
#
#
#namesctl.trace_level = ADMIN
#
#Syntax:  {OFF,USER,ADMIN,0-16}
#Default: OFF (0)
#
# Indicates the level at which the namesctl is to be traced.
# Available Values:
#      0 or OFF - No trace output
#      4 or USER - User trace information
#      10 or ADMIN - Administration trace information
#      16 or SUPPORT - WorldWide Customer Support trace information
#
#
#namesctl.trace_mask # NA
#
#Syntax:  number list
#Default: NULL
#
# Internal mechanism to control trace behavior.
#
#
#namesctl.trace_unique = True
#
#Syntax:  T/F
#Default: False
#
# Indicates whether each trace file has a unique name, allowing multiple trace
# files to coexist. If the value is set to ON, a process identifier is appended
# to the name of each trace file generated.
#
#
#namesctl.no_initial_server = False
#
#Syntax:  T/F
#Default: False
#
# If set to TRUE namesctl will suppress any error messages when namesctl is
# unable to connect to a default names server.
#
#
#namesctl.internal_use = True
#
#Syntax:  T/F
#Default: False
#
# If set to true namesctl will enable a set of internal undocumented commands.
# All internal commands are preceded by an underscore ('_') in order to
# distinguish them as internal. Without going into details, the commands
# enabled are:
#
#     _add_data              _create_name           _delete_name          
#     _full_status           _ireplace_data         _newttl_name          
#     _pause                 _remove_data           _rename_name          
#     _replace_data          _start                 _walk*                
#
# There are also a set of names server variables which may be set when
# namesctl is in internal mode:
#
#     _authority_required             _auto_refresh*                  
#     _cache_checkpoint_interval      _cache_dump                    
#     _default_autorefresh_expire     _default_autorefresh_retry      
#     _default_forwarders_only        _forwarding_desired            
#     _max_reforwards                 _modify_ops_enabled            
#     _next_cache_checkpoint          _next_cache_flush              
#     _next_stat_log                  _next_stat_reset                
#     _reload                         _request_delay                  
#     _restart                        _shutdown                      
#
#
#namesctl.noconfirm = True
#
#Syntax:  T/F
#Default: False
#
# When set to TRUE namesctl will suppress the confirmation prompt when
# sensitive operations (stop, restart, reload) are requested. This is
# quite helpful when using namesctl scripts.
#
#
#namesctl.server_password = mangler
#
#Syntax:  string
#Default: NULL
#
# Automatically sets the password for the names server in order to perform
# sensitive operations (stop, restart, reload). The password may also be
# set manually during a namesctl session using 'set password'.
#
#
#namesctl.internal_encrypt_password = False
#
#Syntax:  T/F
#Default: True
#
# When set to TRUE namesctl will not encrypt the password when it is sent to
# the names server. This would enable an unencrypted password to be set in
# names.ora:names.server_password
#
# - Native Naming Adpaters -------------------------------------------
#
#names.dce.prefix = /.:/subsys/oracle/names
#
#Syntax:  DCE cell name
#Default: /.:/subsys/oracle/names
#
#Specifies the DCE cell (prefix) to use for name lookup.
#
#
#names.nds.name_context = personnel.acme
#
#Syntax:  NDS name
#Default: (OSD?)
#
# Specifies the default NDS name context in which to look for the name to
# be resolved.
#
#
#names.nis.meta_map # NA
#
# Syntax:  filename
# Default: sqlnet.maps
#
# Specifies the file to be used to map NIS attributes to an NIS mapname.
# Currently unused.

# - Advanced Networking Option Authentication Adapters ----------------

#sqlnet.authentication_services
#
# Syntax: A single value or a list from {beq, none, all, kerberos5,
#        cybersafe, securid, identitx}
# Default: NONE
#
# Enables one or more authentication services.  To enable
# authentication via the Oracle Security Server, use (beq, oss).  If
# the Advanced Networking Option has been installed with Kerberos5
# support, using (beq, kerberos5) would enable authentication via
# Kerberos.
#
#sqlnet.authentication_services=(beq, oss)
 
##
## Parmeters used with Kerberos adapter.
##

#sqlnet.kerberos5_cc_name
#
# Syntax: Any valid pathname.
# Default: /tmp/krb5cc_<uid>
#
# The Kerberos credential cache pathname.
#
#sqlnet.kerberos5_cc_name=/tmp/mycc

#sqlnet.kerberos5_clockskew
#
# Syntax: Any positive integer.
# Default: 300
#
# The acceptable difference in the number of seconds between when a
# credential was sent and when it was received.
#
#sqlnet.kerberos5_clockskew=600

#sqlnet.kerberos5_conf
#
# Syntax: Any valid pathname.
# Default: /krb5/krb.conf
#
# The Kerberos configuration pathname.
#
#sqlnet.kerberos5_conf=/tmp/mykrb.conf

#sqlnet.kerberos5_realms
#
# Syntax: Any valid pathname
# Default: /krb5/krb.realms
#
# The Kerberos host name to realm translation file.
#
#sqlnet.kerberos5_realms=/tmp/mykrb.realms

#sqlnet.kerberos5_keytab
#
# Syntax: Any valid pathname.
# Default: /etc/v5srvtab
#
# The Kerberos secret key file.
#
#sqlnet.kerberos5_keytab=/tmp/myv5srvtab

#sqlnet.authentication_kerberos5_service
#
# Syntax: Any string.
# Default: A default is not provided.
#
# The Kerberos service name.
#
#sqlnet.authentication_kerberos5_service=acme

##
## Parmeters used with CyberSAFE adapter.
##

#sqlnet.authentication_gssapi_service
#
# Syntax: A correctly formatted service principal string.
# Default: A default is not provided.
#
# The CyberSAFE service principal
#
#sqlnet.authentication_gssapi_service=acme/asriniva.us.oracle.com@US.ORACLE.COM
 
##
## Parmeters used with Identix adapter.
##

#sqlnet.identix_fingerprint_method
#
# Syntax: Must be oracle.
# Default: A default is not provided.
#
# The Identix authentication server method
#
#sqlnet.identix_fingerprint_method=oracle

#sqlnet.identix_fingerprint_database
#
# Syntax: Any string.
# Default: A default is not provided.
#
# The Identix authentication server TNS alias
#
#sqlnet.identix_fingerprint_database=ofm

#sqlnet.identix_fingerprint_database_user
#
# Syntax: Any string
# Default: A default is not provided.
#
# The Identix authentication service well known username.
#
#sqlnet.identix_fingerprint_database_user=ofm_client

#sqlnet.identix_fingerprint_database_password
#
# Syntax: Any string
# Default: A default is not provided.
#
# The Identix authentication service well known password.
#
#sqlnet.identix_fingerprint_database_password=ofm_client

# - Advanced Networking Option Network Security -------------------------

#sqlnet.crypto_checksum_client
#sqlnet.crypto_checksum_server
#sqlnet.encryption_client
#sqlnet.encryption_server
#
# These four parameters are used to specify whether a service (e.g.
# crypto-checksumming or encryption) should be active:
#
# Each of the above parameters defaults to ACCEPTED.
#
# Each of the above parameters can have one of four possible values:
#
# value            meaning
#
# ACCEPTED      The service will be active if the other side of the
#            connection specifies "REQUESTED" or REQUIRED" and
#            there is a compatible algorithm available on the other
#            side; it will be inactive otherwise.
#
# REJECTED      The service must not be active, and the connection
#            will fail if the other side specifies "REQUIRED".
#
# REQUESTED      The service will be active if the other side specifies
#            "ACCEPTED", "REQUESTED", or "REQUIRED" and there is a
#            compatible algorithm available on the other side; it
#            will be inactive otherwise.
#
# REQUIRED      The service must be active, and the connection will
#            fail if the other side specifies "REJECTED" or if there
#            is no compatible algorithm on the other side.
#
#sqlnet.crypto_checksum_types_client
#sqlnet.crypto_checksum_types_server
#sqlnet.encryption_types_client
#sqlnet.encryption_types_server
#
# These parameters control which algorithms will be made available for
# each service on each end of a connection:
#
# The value of each of these parameters can be either a parenthesized
# list of algorithm names separated by commas or a single algorithm
# name.
#
# Encryption types can be: RC4_40, RC4_56, RC4_128, DES, DES40
#
# Encryption defaults to all the algorithms.
#
# Crypto checksum types can be: MD5
#
# Crypto checksum defaults to MD5.
#
#sqlnet.crypto_seed ="4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf"
#sqlnet.crypto_checksum_server = required
#sqlnet.encryption_server = required

# - Oracle Security Server ---------------------------------------------

#oss.source.my_wallet
#
# Syntax: A properly formatted NLNV list.
# Default: Platform specific.  Unix: $HOME/oracle/oss
#
# The method for retrieving and storing my identity.  
#
#oss.source.my_wallet
#   =(source
#       =(method=file)
#        (method_data=/dve/asriniva/oss/wallet)
#     )

#oss.source.location
#
# Syntax: A properly formatted NLNV list.
# Default: Oracle method, oracle_security_service/oracle_security_service@oss
#
# The method for retrieving encrypted private keys.
#
#oss.source.location
#   =(source
#       =(method=oracle)
#        (method_data=
#           (sqlnet_address=andreoss)
#        )
#    )

# - Sqlnet(v2.x) and Net3.0 Client ------------------------------------------

#
# In the following descriptions, the term "client program" could mean
# either sqlplus, svrmgrl or any other OCI programs written by users
#
###########################
#trace_level_client = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the client program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#      4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#      16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since:  v2.0
#
###############################################
#trace_directory_client = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network/trace  ($ORACLE_HOME=/oracle at customer
#         site)
#
#Purpose: Indicates the name of the directory to which trace files from
#         the client execution are written.
#
#Supported since: v2.0
#
###################################################
#trace_file_client =  /oracle/network/trace/cli.trc
###################################################
#
#Possible values: Any valid file name
#Default:        $ORACLE_HOME/network/trace/cli.trc ($ORACLE_HOME =
#              /oracle at customer site)
#
#Purpose: Indicates the name of the file to which the execution trace
#         of the client is written to.
#
#Supported since: v2.0
#
###########################
#trace_unique_client = ON
###########################
#
#Possible values: {ON, OFF}
#Default: OFF
#
#Purpose: Used to make each client trace file have a unique name to
#        prevent each trace file from being overwritten by successive
#        runs of the client program
#
#Supported since: v2.0
#
###########################################
#log_directory_client = /oracle/network/log
###########################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/log  ($ORACLE_HOME = /oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which the client log file
#        is written to.
#
#
#Supported since: v2.0
#
################
#log_file_client = /oracle/network/log/sqlnet.log
################
#
#Possible values: This is a default value, u cannot change this
#Default: $ORACLE_HOME/network/log/sqlnet.log  ($ORACLE_HOME=/oracle in
#         customer site)
#
#Purpose: Indicates the name of the log file from a client program
#
#Supported since: v2.0
#
#############################################
#log_directory_server = /oracle/network/trace
#############################################
#
#Possible values: Any valid diretcory path with write permission
#Default: $ORACLE_HOME/network/trace ( $ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which log files from the
#         server are written
#
#Supported since:  v2.0
#
###############################################
#trace_directory_server = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network_trace ( $ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which trace files from
#         the server are written
#
#Supported since:  v2.0
#
#######################################################
#trace_file_server = /orace/network/trace/svr_<pid>.trc
#######################################################
#
#Possible values: Any valid filename
#Default: $ORACLE_HOME/network/trace/svr_<pid>.trc where <pid? stands for
#         the process id of the server on UNIX systems
#
#Purpose: Indicates the name of the file to which the execution trace of
#         the server program is written to.
#
#Supported since: v2.0
#
###########################
#trace_level_server = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since: v2.0
#
##########################
#use_dedicated_server = ON
##########################
#
#Possible values: {OFF,ON}
#Default:         OFF
#
#Purpose: Forces the listener to spawn a dedicated server process for
#        sessions from this client program.
#
#Supported since: v2.0
#
################
#use_cman = TRUE
################
#
#Possible values: {TRUE, FALSE}
#Default:        FALSE
#
#Purpose:
#
#Supported since: v3.0
#
################################################
#tnsping.trace_directory = /oracle/network/trace
################################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/trace ($ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the directory to which the execution trace from
#        the tnsping program is to be written to.
#
#Supported since: v2.0
#
############################
#tnsping.trace_level = ADMIN    
############################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#
#Supported since: v2.0
#
########################
#sqlnet.expire_time = 10
########################
#
#Possible values: 0-any valid positive integer! (in minutes)
#Default: 0 minutes
#Recommended value: 10 minutes
#
#Purpose: Indicates the time interval to send a probe to verify the
#        client session is alive (this is used to reclaim watseful
#        resources on a dead client)
#
#Supported since: v2.1
#
#######################################
#sqlnet.client_registration = <unique_id>
#######################################
#
#Possible values:
#Default:     OFF
#
#Purpose: Sets a unique identifier for the client machine. This
#        identifier is then passed to the listener with any connection
#        request and will be included in the Audit Trail. The identifier
#        can be any alphanumeric string up to 128 characters long.
#
#Supported since: v2.3.2
#
######################
#bequeath_detach = YES
######################
#
#Possible values: {YES,NO}
#Default:         NO
#
#Purpose: Turns off signal handling on UNIX systems. If signal handling
#        were not turned off and if client programs written by users make
#        use of signal handling they could interfere with Sqlnet/Net3.
#
#Supported since: v2.3.3
#
####################
#automatic_ipc = OFF
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: Force a session to use or not to use IPC addresses on the
#        client's node.
#
#Supported since: v2.0
#
####################
#disable_oob = ON
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: If the underlying transport protocol (TCP, DECnet,...) does
#         not support Out-of-band breaks, then disable out-of-band
#        breaks
#
#Supported since: v2.0
#


File:
C:\class\NET80\ADMIN\SAMPLE\SQLNET.ORA

# copyright (c) 1996 by the Oracle Corporation
#
# NAME
#   sqlnet.ora
# FUNCTION
#   Oracle Network Client startup parameter file example
# NOTES
#   This file contains examples and instructions for defining all
#   Oracle Network Client parameters. It should be possible to read
#   this file and setup a Client by uncommenting parameter definitions
#   and substituting values. The comments should provide enough
#   explanation to enable a reasonable user to manage his TNS connections
#   without having to resort to 'real' documentation.
# SECTIONS
#   ONames Client
#   Namesctl
#   Native Naming Adpaters
#   ...
# MODIFIED
#    skanjila   06/06/97 - Correct default for Automatic_IPC
#    eminer     05/15/97 - Add the relevant onrsd parameters.
#    asriniva   04/23/97 - Merge with version from doc
#    ggilchri   03/31/97 - mods
#    bvasudev   02/07/97 - Change sqlnet.authentication_services documentation
#    bvasudev   11/25/96 - Merge sqlnet.ora transport related parameters
#    asriniva   11/12/96 - Revise with new OSS parameters.
#    asriniva   11/05/96 - Add ANO parameters.
# ____________________________________________________________________

# - ONames Client ----------------------------------------------------
#
#names.default_domain = world
#
#Syntax:  domain-name
#Default: NULL
#
# Indicates the domain from which the client most often requests names. When
# this parameter is set the default domain name (for example, US.ACME), the
# domain name will be automatically appended to any unqualified name in an
# ONAmes request (query, register, deregister, etc). Any name which contains
# an unescaped dot ('.') will not have the default domain appended. Simple
# names may be qualified with a trailing dot (for example 'rootserver.').
#
#
#names.initial_retry_timeout = 30
#
#Syntax:  1-600 seconds
#Default: 15 (OSD)
#
# Determines how long a client will wait for a response from a Names Server
# before reiterating the request to the next server in the preferred_servers
# list.
#
#
#names.max_open_connections = 3
#
#Syntax:  3-64
#Default: ADDRS in preferred_servers
#
# Determines how many connections an ONames client may have open at one time.
# Clients will ordinarily keep connections to servers open once they are
# established until the operation (or session in namesctl) is complete. A
# connection will be opened whenever needed, and if the maximum would be
# exceeded the least recently used connection will be closed.
#
#
#names.message_pool_start_size = 10
#
#Syntax:  3-256
#Default: 10
#
# Determines the initial number of messages allocated in the client's message
# pool. This pool provides the client with pre-allocated messages to be used
# for requests to ONames servers. Messages which are in the pool and unused
# may be reused. If a message is needed and no free messages are available in
# the pool more will be allocated.
#
#
#names.preferred_servers = (address_list =
#  (address=(protocol=ipc)(key=n23))
#  (address=(protocol=tcp)(host=nineva)(port=1383))
#  (address=(protocol=tcp)(host=cicada)(port=1575))
# )
#
#Syntax:  ADDR_LIST
#Default: Well-Known (OSD)
#
# Specifies a list of ONames servers in the client's region; requests will be
# sent to each ADDRESS in the list until a response is recieved, or the list
# (and number of retries) is exhausted.
#
# Addresses of the following form specify that messages to the ONames server
# should use Oracle Remote Operations (RPC):
#
#     (description =
#       (address=(protocol=tcp)(host=nineva)(port=1383))
#       (connect_data=(rpc=on))
#     )
#
#
#
#names.request_retries = 2
#
#Syntax:  1-5
#Default: 1
#
# Specifies the number of times the client should try each server in the list
# of preferred_servers before allowing the operation to fail.
#
#
#names.directory_path
#
#Syntax:  <adapter-name>
#Default: TNSNAMES,ONAMES,HOSTNAME
#
# Sets the (ordered) list of naming adaptors to use in resolving a name.
# The default is as shown for 3.0.2 of sqlnet onwards. The default was
# (TNSNAMES, ONAMES) before that. The value can be presented without
# parentheses if only a single entry is being specified. The parameter is
# recognized from version 2.3.2 of sqlnet onward. Acceptable values include:
#  TNSNAMES -- tnsnames.ora lookup
#  ONAMES   -- Oracle Names
#  HOSTNAME -- use the hostname (or an alias of the hostname)
#  NIS      -- NIS (also known as "yp")
#  CDS      -- OSF DCE's Cell Directory Service
#  NDS      -- Novell's Netware Directory Service
#
# - Client Cache (ONRSD) ---------------------------------------------
names.addresses = (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))

Syntax:  ADDR
Default: (ADDRESS=(PROTOCOL=IPC)(KEY=ONAMES))

 Address on which the client cache listens (is available to clients).
 Any valid TNS address is allowed. The default should be used if at
 all possible; clients have this entry hardwired as the first line
 of their server-list file (sdns.ora). If the address is set to a
 non-default value the client's preferred_servers parameter should
 be set to include the client-cache address first.


names.authority_required = False

Syntax:  T/F
Default: False

 Determines whether system querys (for the root etc) require Authoritative
 answers.


names.auto_refresh_expire = 259200

Syntax:  Number of seconds, 60-1209600
Default: 259200

 This is the amount of time (in seconds) the server will cache the addresses
 of servers listed in server-list file (sdns.ora). When this time expires the
 server will issue another query to the servers in those regions to refresh
 the data.


names.auto_refresh_retry = 180

Syntax:  Number of seconds, 60-3600
Default: sec.      180

 This set how often the server will retry when the auto_refresh query fails.


names.cache_checkpoint_file = cache.ckp

Syntax:  filename
Default: $ORACLE_HOME/network/names/ckpcch.ora

 Specifies the name of the operating system file to which the Names Server
 writes its foreign data cache.


names.cache_checkpoint_interval = 7200

Syntax:  Number of seconds, 10-259200
Default: 0 (off)

 Indicates the interval at which a Names Server writes a checkpoint of its
 data cache to the checkpoint file.


names.default_forwarders=
 (FORWARDER_LIST=
    (FORWARDER=
       (NAME= rootserv1.world)
       (ADDRESS=(PROTOCOL=tcp)(PORT=42100)(HOST=roothost))))

Syntax:  Name-Value/address_list
Default: NULL

 A list (in NV form) of the addresses of other servers which should be used to
 forward querys while in default_forwarder (slave) mode. NAME is the global
 names for the server to which forwards whould be directed, and ADDRESS is its
 address.


names.default_forwarders_only = True

Syntax:  T/F
Default: False

 When set to true this server will use the servers listed in default_forwarders
 to forward all operations which involve data in foreign regions. Otherwise it
 will use the servers defined in the server-list file (sdns.ora) in addition
 to any defined in the default_forwarders parameter.


names.log_directory = /oracle/network/log

Syntax:  directory
Default: $ORACLE_HOME/network/log

 Indicates the name of the directory where the log file for Names Server
 operational events are written.


names.log_file = names.log

Syntax:  filename
Default: names.log

 The name of the output file to which Names Server operational events are
 written.

names.log_stats_interval = 3600

Syntax:  Number of seconds, 10-ub4max
Default: sec.      0 (off)

Specifies the number of seconds between statistical entries in log file.

names.log_unique = False

Syntax:  T/F
Default: False

 If set to true the server will guarantee that the log file will have a unique
 name which will not overwrite any existing files (note that log files are
 appended to, so log information will not be lost if log_unique is not true).

names.max_open_connections = 10

Syntax:  3-64
Default: 10

 Specifies the number of connections that the Names Server can have open at any
 given time. The value is generated as the value 10 or the sum of one
 connection for listening, five for clients, plus one for each foreign domain
 defined in the local administrative region, whichever is greater. Any
 operation which requires the server to open a network connection will use
 an already open connection if it is available, or will open a connection
 if not. Higher settings will save time and cost network resources; lower
 settings save network resources, cost time.


names.max_reforwards = 2

Syntax:  1-15
Default: 2

 The maximum number of times the server will attempt to forward a certain
 operation.


names.message_pool_start_size = 24

Syntax:  3-256
Default: 10

 Determines the initial number of messages allocated in the server's message
 pool. This pool provides the server with pre-allocated messages to be used
 for incoming or outgoing messages (forwards). Messages which are in the pool
 and unused may be reused. If a message is needed and no free messages are
 available in the pool more will be allocated.


names.no_modify_requests = False

Syntax:  T/F
Default: False

 If set to true, the server will refuse any operations which modify the
 data in its region (it will still save foreign info in the cache which is
 returned from foreign querys).


names.password = 625926683431AA55

Syntax:  encrypted string
Default: NULL

 If set the server will require that the user provide a password in his
 namesctl session (either with sqlnet.ora:namesctl.server_password or 'set
 password') in order to do 'sensitive' operations, like stop, restart, reload.
 This parameter is generally set in encrypted form, so it can not be set
 manually.

names.reset_stats_interval = 3600

Syntax:  10-ub4max
Default: 0 (off)

 Specifies the number of seconds during which the statistics collected by the
 Names Servers should accumulate. At the frequency specified, they are reset
 to zero. The default value of 0 means never reset statistics.


names.trace_directory = /oracle/network/trace

Syntax:  directory
Default: $ORACLE_HOME/network/trace

 Indicates the name of the directory to which trace files from a Names Server
 trace session are written.


names.trace_file = names.trc

Syntax:  filename
Default: names.trc

 Indicates the name of the output file from a Names Server trace session.


names.trace_func # NA

Syntax:  T/F
Default: False

 Internal mechanism to control tracing by function name.


names.trace_level = ADMIN

Syntax:  T/F
Default: False

Syntax:  {OFF,USER,ADMIN,0-16}
Default: OFF (0)

 Indicates the level at which the Names Server is to be traced.
 Available Values:
      0 or OFF - No trace output
      4 or USER - User trace information
      10 or ADMIN - Administration trace information
      16 or SUPPORT - WorldWide Customer Support trace information


names.trace_mask = (200,201,202,203,205,206,207)

Syntax:  list of numbers
Default: NULL

 Internal mechanism to control trace behavior.


names.trace_unique = True

Syntax:  T/F
Default: False

 Indicates whether each trace file has a unique name, allowing multiple trace
 files to coexist. If the value is set to ON, a process identifier is appended
 to the name of each trace file generated.


# - Namesctl ---------------------------------------------------------
#
#namesctl.trace_directory = /oracle/network/trace
#
#Syntax:  directory
#Default: $ON/trace
#
# Indicates the name of the directory to which trace files from a namesctl
# trace session are written.
#
#
#namesctl.trace_file = namesctl.trc
#
#Syntax:  filename
#Default: namesctl.trc
#
# Indicates the name of the output file from a namesctl trace session.
#
#
#namesctl.trace_func # NA
#
#Syntax:  word list
#Default: NULL
#
# Internal mechanism to control tracing by function name.
#
#
#namesctl.trace_level = ADMIN
#
#Syntax:  {OFF,USER,ADMIN,0-16}
#Default: OFF (0)
#
# Indicates the level at which the namesctl is to be traced.
# Available Values:
#      0 or OFF - No trace output
#      4 or USER - User trace information
#      10 or ADMIN - Administration trace information
#      16 or SUPPORT - WorldWide Customer Support trace information
#
#
#namesctl.trace_mask # NA
#
#Syntax:  number list
#Default: NULL
#
# Internal mechanism to control trace behavior.
#
#
#namesctl.trace_unique = True
#
#Syntax:  T/F
#Default: False
#
# Indicates whether each trace file has a unique name, allowing multiple trace
# files to coexist. If the value is set to ON, a process identifier is appended
# to the name of each trace file generated.
#
#
#namesctl.no_initial_server = False
#
#Syntax:  T/F
#Default: False
#
# If set to TRUE namesctl will suppress any error messages when namesctl is
# unable to connect to a default names server.
#
#
#namesctl.internal_use = True
#
#Syntax:  T/F
#Default: False
#
# If set to true namesctl will enable a set of internal undocumented commands.
# All internal commands are preceded by an underscore ('_') in order to
# distinguish them as internal. Without going into details, the commands
# enabled are:
#
#     _add_data              _create_name           _delete_name          
#     _full_status           _ireplace_data         _newttl_name          
#     _pause                 _remove_data           _rename_name          
#     _replace_data          _start                 _walk*                
#
# There are also a set of names server variables which may be set when
# namesctl is in internal mode:
#
#     _authority_required             _auto_refresh*                  
#     _cache_checkpoint_interval      _cache_dump                    
#     _default_autorefresh_expire     _default_autorefresh_retry      
#     _default_forwarders_only        _forwarding_desired            
#     _max_reforwards                 _modify_ops_enabled            
#     _next_cache_checkpoint          _next_cache_flush              
#     _next_stat_log                  _next_stat_reset                
#     _reload                         _request_delay                  
#     _restart                        _shutdown                      
#
#
#namesctl.noconfirm = True
#
#Syntax:  T/F
#Default: False
#
# When set to TRUE namesctl will suppress the confirmation prompt when
# sensitive operations (stop, restart, reload) are requested. This is
# quite helpful when using namesctl scripts.
#
#
#namesctl.server_password = mangler
#
#Syntax:  string
#Default: NULL
#
# Automatically sets the password for the names server in order to perform
# sensitive operations (stop, restart, reload). The password may also be
# set manually during a namesctl session using 'set password'.
#
#
#namesctl.internal_encrypt_password = False
#
#Syntax:  T/F
#Default: True
#
# When set to TRUE namesctl will not encrypt the password when it is sent to
# the names server. This would enable an unencrypted password to be set in
# names.ora:names.server_password
#
# - Native Naming Adpaters -------------------------------------------
#
#names.dce.prefix = /.:/subsys/oracle/names
#
#Syntax:  DCE cell name
#Default: /.:/subsys/oracle/names
#
#Specifies the DCE cell (prefix) to use for name lookup.
#
#
#names.nds.name_context = personnel.acme
#
#Syntax:  NDS name
#Default: (OSD?)
#
# Specifies the default NDS name context in which to look for the name to
# be resolved.
#
#
#names.nis.meta_map # NA
#
# Syntax:  filename
# Default: sqlnet.maps
#
# Specifies the file to be used to map NIS attributes to an NIS mapname.
# Currently unused.

# - Advanced Networking Option Authentication Adapters ----------------

#sqlnet.authentication_services
#
# Syntax: A single value or a list from {beq, none, all, kerberos5,
#        cybersafe, securid, identitx}
# Default: NONE
#
# Enables one or more authentication services.  To enable
# authentication via the Oracle Security Server, use (beq, oss).  If
# the Advanced Networking Option has been installed with Kerberos5
# support, using (beq, kerberos5) would enable authentication via
# Kerberos.
#
#sqlnet.authentication_services=(beq, oss)
 
##
## Parmeters used with Kerberos adapter.
##

#sqlnet.kerberos5_cc_name
#
# Syntax: Any valid pathname.
# Default: /tmp/krb5cc_<uid>
#
# The Kerberos credential cache pathname.
#
#sqlnet.kerberos5_cc_name=/tmp/mycc

#sqlnet.kerberos5_clockskew
#
# Syntax: Any positive integer.
# Default: 300
#
# The acceptable difference in the number of seconds between when a
# credential was sent and when it was received.
#
#sqlnet.kerberos5_clockskew=600

#sqlnet.kerberos5_conf
#
# Syntax: Any valid pathname.
# Default: /krb5/krb.conf
#
# The Kerberos configuration pathname.
#
#sqlnet.kerberos5_conf=/tmp/mykrb.conf

#sqlnet.kerberos5_realms
#
# Syntax: Any valid pathname
# Default: /krb5/krb.realms
#
# The Kerberos host name to realm translation file.
#
#sqlnet.kerberos5_realms=/tmp/mykrb.realms

#sqlnet.kerberos5_keytab
#
# Syntax: Any valid pathname.
# Default: /etc/v5srvtab
#
# The Kerberos secret key file.
#
#sqlnet.kerberos5_keytab=/tmp/myv5srvtab

#sqlnet.authentication_kerberos5_service
#
# Syntax: Any string.
# Default: A default is not provided.
#
# The Kerberos service name.
#
#sqlnet.authentication_kerberos5_service=acme

##
## Parmeters used with CyberSAFE adapter.
##

#sqlnet.authentication_gssapi_service
#
# Syntax: A correctly formatted service principal string.
# Default: A default is not provided.
#
# The CyberSAFE service principal
#
#sqlnet.authentication_gssapi_service=acme/asriniva.us.oracle.com@US.ORACLE.COM
 
##
## Parmeters used with Identix adapter.
##

#sqlnet.identix_fingerprint_method
#
# Syntax: Must be oracle.
# Default: A default is not provided.
#
# The Identix authentication server method
#
#sqlnet.identix_fingerprint_method=oracle

#sqlnet.identix_fingerprint_database
#
# Syntax: Any string.
# Default: A default is not provided.
#
# The Identix authentication server TNS alias
#
#sqlnet.identix_fingerprint_database=ofm

#sqlnet.identix_fingerprint_database_user
#
# Syntax: Any string
# Default: A default is not provided.
#
# The Identix authentication service well known username.
#
#sqlnet.identix_fingerprint_database_user=ofm_client

#sqlnet.identix_fingerprint_database_password
#
# Syntax: Any string
# Default: A default is not provided.
#
# The Identix authentication service well known password.
#
#sqlnet.identix_fingerprint_database_password=ofm_client

# - Advanced Networking Option Network Security -------------------------

#sqlnet.crypto_checksum_client
#sqlnet.crypto_checksum_server
#sqlnet.encryption_client
#sqlnet.encryption_server
#
# These four parameters are used to specify whether a service (e.g.
# crypto-checksumming or encryption) should be active:
#
# Each of the above parameters defaults to ACCEPTED.
#
# Each of the above parameters can have one of four possible values:
#
# value            meaning
#
# ACCEPTED      The service will be active if the other side of the
#            connection specifies "REQUESTED" or REQUIRED" and
#            there is a compatible algorithm available on the other
#            side; it will be inactive otherwise.
#
# REJECTED      The service must not be active, and the connection
#            will fail if the other side specifies "REQUIRED".
#
# REQUESTED      The service will be active if the other side specifies
#            "ACCEPTED", "REQUESTED", or "REQUIRED" and there is a
#            compatible algorithm available on the other side; it
#            will be inactive otherwise.
#
# REQUIRED      The service must be active, and the connection will
#            fail if the other side specifies "REJECTED" or if there
#            is no compatible algorithm on the other side.
#
#sqlnet.crypto_checksum_types_client
#sqlnet.crypto_checksum_types_server
#sqlnet.encryption_types_client
#sqlnet.encryption_types_server
#
# These parameters control which algorithms will be made available for
# each service on each end of a connection:
#
# The value of each of these parameters can be either a parenthesized
# list of algorithm names separated by commas or a single algorithm
# name.
#
# Encryption types can be: RC4_40, RC4_56, RC4_128, DES, DES40
#
# Encryption defaults to all the algorithms.
#
# Crypto checksum types can be: MD5
#
# Crypto checksum defaults to MD5.
#
#sqlnet.crypto_seed ="4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf"
#sqlnet.crypto_checksum_server = required
#sqlnet.encryption_server = required

# - Oracle Security Server ---------------------------------------------

#oss.source.my_wallet
#
# Syntax: A properly formatted NLNV list.
# Default: Platform specific.  Unix: $HOME/oracle/oss
#
# The method for retrieving and storing my identity.  
#
#oss.source.my_wallet
#   =(source
#       =(method=file)
#        (method_data=/dve/asriniva/oss/wallet)
#     )

#oss.source.location
#
# Syntax: A properly formatted NLNV list.
# Default: Oracle method, oracle_security_service/oracle_security_service@oss
#
# The method for retrieving encrypted private keys.
#
#oss.source.location
#   =(source
#       =(method=oracle)
#        (method_data=
#           (sqlnet_address=andreoss)
#        )
#    )

# - Sqlnet(v2.x) and Net3.0 Client ------------------------------------------

#
# In the following descriptions, the term "client program" could mean
# either sqlplus, svrmgrl or any other OCI programs written by users
#
###########################
#trace_level_client = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the client program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#      4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#      16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since:  v2.0
#
###############################################
#trace_directory_client = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network/trace  ($ORACLE_HOME=/oracle at customer
#         site)
#
#Purpose: Indicates the name of the directory to which trace files from
#         the client execution are written.
#
#Supported since: v2.0
#
###################################################
#trace_file_client =  /oracle/network/trace/cli.trc
###################################################
#
#Possible values: Any valid file name
#Default:        $ORACLE_HOME/network/trace/cli.trc ($ORACLE_HOME =
#              /oracle at customer site)
#
#Purpose: Indicates the name of the file to which the execution trace
#         of the client is written to.
#
#Supported since: v2.0
#
###########################
#trace_unique_client = ON
###########################
#
#Possible values: {ON, OFF}
#Default: OFF
#
#Purpose: Used to make each client trace file have a unique name to
#        prevent each trace file from being overwritten by successive
#        runs of the client program
#
#Supported since: v2.0
#
###########################################
#log_directory_client = /oracle/network/log
###########################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/log  ($ORACLE_HOME = /oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which the client log file
#        is written to.
#
#
#Supported since: v2.0
#
################
#log_file_client = /oracle/network/log/sqlnet.log
################
#
#Possible values: This is a default value, u cannot change this
#Default: $ORACLE_HOME/network/log/sqlnet.log  ($ORACLE_HOME=/oracle in
#         customer site)
#
#Purpose: Indicates the name of the log file from a client program
#
#Supported since: v2.0
#
#############################################
#log_directory_server = /oracle/network/trace
#############################################
#
#Possible values: Any valid diretcory path with write permission
#Default: $ORACLE_HOME/network/trace ( $ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which log files from the
#         server are written
#
#Supported since:  v2.0
#
###############################################
#trace_directory_server = /oracle/network/trace
###############################################
#
#Possible values: Any valid directory path with write permission
#Default: $ORACLE_HOME/network_trace ( $ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the name of the directory to which trace files from
#         the server are written
#
#Supported since:  v2.0
#
#######################################################
#trace_file_server = /orace/network/trace/svr_<pid>.trc
#######################################################
#
#Possible values: Any valid filename
#Default: $ORACLE_HOME/network/trace/svr_<pid>.trc where <pid? stands for
#         the process id of the server on UNIX systems
#
#Purpose: Indicates the name of the file to which the execution trace of
#         the server program is written to.
#
#Supported since: v2.0
#
###########################
#trace_level_server = ADMIN
###########################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#Supported since: v2.0
#
##########################
#use_dedicated_server = ON
##########################
#
#Possible values: {OFF,ON}
#Default:         OFF
#
#Purpose: Forces the listener to spawn a dedicated server process for
#        sessions from this client program.
#
#Supported since: v2.0
#
################
#use_cman = TRUE
################
#
#Possible values: {TRUE, FALSE}
#Default:        FALSE
#
#Purpose:
#
#Supported since: v3.0
#
################################################
#tnsping.trace_directory = /oracle/network/trace
################################################
#
#Possible values: Any valid directory pathname
#Default: $ORACLE_HOME/network/trace ($ORACLE_HOME=/oracle at customer
#        site)
#
#Purpose: Indicates the directory to which the execution trace from
#        the tnsping program is to be written to.
#
#Supported since: v2.0
#
############################
#tnsping.trace_level = ADMIN    
############################
#
#Possible values: {OFF,USER,ADMIN,0-16}
#Default:         OFF (0)
#
#Purpose: Indicates the level at which the server program
#         is to be traced.
# Available Values:
#       0 or OFF - No Trace output
#       4 or USER - User trace information
#       10 or ADMIN - Administration trace information
#       16 or SUPPORT - Worldwide Customer Support trace information
#
#
#Supported since: v2.0
#
########################
#sqlnet.expire_time = 10
########################
#
#Possible values: 0-any valid positive integer! (in minutes)
#Default: 0 minutes
#Recommended value: 10 minutes
#
#Purpose: Indicates the time interval to send a probe to verify the
#        client session is alive (this is used to reclaim watseful
#        resources on a dead client)
#
#Supported since: v2.1
#
#######################################
#sqlnet.client_registration = <unique_id>
#######################################
#
#Possible values:
#Default:     OFF
#
#Purpose: Sets a unique identifier for the client machine. This
#        identifier is then passed to the listener with any connection
#        request and will be included in the Audit Trail. The identifier
#        can be any alphanumeric string up to 128 characters long.
#
#Supported since: v2.3.2
#
######################
#bequeath_detach = YES
######################
#
#Possible values: {YES,NO}
#Default:         NO
#
#Purpose: Turns off signal handling on UNIX systems. If signal handling
#        were not turned off and if client programs written by users make
#        use of signal handling they could interfere with Sqlnet/Net3.
#
#Supported since: v2.3.3
#
####################
#automatic_ipc = OFF
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: Force a session to use or not to use IPC addresses on the
#        client's node.
#
#Supported since: v2.0
#
####################
#disable_oob = ON
####################
#
#Possible values: {ON,OFF}
#Default: OFF
#
#Purpose: If the underlying transport protocol (TCP, DECnet,...) does
#         not support Out-of-band breaks, then disable out-of-band
#        breaks
#
#Supported since: v2.0
#


File:
C:\Oracle\Ora81\NETWORK\ADMIN\listener.ora

# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:c:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = bhvsn01)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = bhvsn01)(PORT = 2481))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
  )


File:
C:\Oracle\Ora81\NETWORK\ADMIN\SAMPLE\LISTENER.ORA

# copyright (c) 1997 by the Oracle Corporation
#
# NAME
#   listener.ora
# FUNCTION
#   Network Listener startup parameter file example
# NOTES
#   This file contains all the parameters for listener.ora,
#   and could be used to configure the listener by uncommenting
#   and changing values.  Multiple listeners can be configured
#   in one listener.ora, so listener.ora parameters take the form
#   of SID_LIST_<lsnr>, where <lsnr> is the name of the listener
#   this parameter refers to.  All parameters and values are
#   case-insensitive.

# <lsnr>
#   This parameter specifies both the name of the listener, and
#   it listening address(es). Other parameters for this listener
#   us this name in place of <lsnr>.  When not specified,
#   the name for <lsnr> defaults to "LISTENER", with the default
#   address value as shown below.
#
# LISTENER =
#  (ADDRESS_LIST=
#      (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
#      (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))      

# SID_LIST_<lsnr>
#   List of services the listener knows about and can connect
#   clients to.  There is no default.  See the Net8 Administrator's
#   Guide for more information.
#
# SID_LIST_LISTENER=
#   (SID_LIST=
#      (SID_DESC=
#                  #BEQUEATH CONFIG
#          (GLOBAL_DBNAME=salesdb.mycompany)
#          (SID_NAME=sid1)                  
#          (ORACLE_HOME=/private/app/oracle/product/8.0.3)
#                  #PRESPAWN CONFIG
#         (PRESPAWN_MAX=20)
#        (PRESPAWN_LIST=
#           (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
#         )
#        )
#       )
      
# PASSWORDS_<lsnr>
#   Specifies a password to authenticate stopping the listener.
#   Both encrypted and plain-text values can be set.  Encrypted passwords
#   can be set and stored using lsnrctl.  
#     LSNRCTL> change_password
#       Will prompt for old and new passwords, and use encryption both
#       to match the old password and to set the new one.
#     LSNRCTL> set password
#      Will prompt for the new password, for authentication with
#       the listener. The password must be set before running the next
#       command.
#     LSNRCTL> save_config
#       Will save the changed password to listener.ora. These last two
#       steps are not necessary if SAVE_CONFIG_ON_STOP_<lsnr> is ON.
#       See below.
#
# Default: NONE
#
# PASSWORDS_LISTENER = 20A22647832FB454      # "foobar"

# SAVE_CONFIG_ON_STOP_<lsnr>
#   Tells the listener to save configuration changes to listener.ora when
#   it shuts down.  Changed parameter values will be written to the file,
#   while preserving formatting and comments.
# Default: OFF
# Values: ON/OFF
#
# SAVE_CONFIG_ON_STOP_LISTENER = ON

# USE_PLUG_AND_PLAY_<lsnr>
#   Tells the listener to contact an Onames server and register itself
#   and its services with Onames.
# Values: ON/OFF
# Default: OFF
#
# USE_PLUG_AND_PLAY_LISTENER = ON

# LOG_FILE_<lsnr>
#   Sets the name of the listener's log file.  The .log extension
#   is added automatically.
# Default=<lsnr>
#
# LOG_FILE_LISTENER = lsnr

# LOG_DIRECTORY_<lsnr>
#   Sets the directory for the listener's log file.
# Default: <oracle_home>/network/log
#
# LOG_DIRECTORY_LISTENER = /private/app/oracle/product/8.0.3/network/log

# TRACE_LEVEL_<lsnr>
#   Specifies desired tracing level.
# Default: OFF
# Values: OFF/USER/ADMIN/SUPPORT/0-16
#
# TRACE_LEVEL_LISTENER = SUPPORT

# TRACE_FILE_<lsnr>
#   Sets the name of the listener's trace file. The .trc extension
#   is added automatically.
# Default: <lsnr>
#
# TRACE_FILE_LISTENER = lsnr

# TRACE_DIRECTORY_<lsnr>
#   Sets the directory for the listener's trace file.
# Default: <oracle_home>/network/trace
#
# TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace
# CONNECT_TIMEOUT_<lsnr>
#   Sets the number of seconds that the listener waits to get a
#   valid database query after it has been started.
# Default: 10
#
# CONNECT_TIMEOUT_LISTENER=10



File:
C:\class\NET80\TNSAPI\LISTENER.ORA

################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL= IPC)
          (KEY= oracle.world)
        )
        (ADDRESS=
          (PROTOCOL= IPC)
          (KEY= ORCL)
        )
        (ADDRESS=
          (COMMUNITY= TCP.world)
          (PROTOCOL= TCP)
          (Host= hostname)
          (Port= 1521)
        )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = tftp)
      (PROGRAM = tftpd)
    )
    (SID_DESC =
      (SID_NAME = sfinger)
      (PROGRAM = sfingerd)
    )
  )
PASSWORDS_LISTENER = (oracle)









0
 
LVL 9

Expert Comment

by:ornicar
ID: 6241987
Great!

Forget about the files in /SAMPLE/ directory. There are just examples.

So, you have:

C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA
C:\class\NET80\ADMIN\TNSNAMES.ORA
C:\class\NET80\TNSAPI\TNSNAMES.ORA
C:\class\NET80\ADMIN\SQLNET.ORA
C:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
C:\class\NET80\TNSAPI\LISTENER.ORA

I suppose that you installed Oracle Enterprise or Personal Oracle in the c:\oracle\ora81 directory, and forms is in the c:\class directory. Is that correct.


First, Do what I did: Copy the three files (tnsnames.ora, sqlnet.ora and listener.ora) in a safe folder and create a .bat file in order to copy the files in their locations. This way you only have to change in one place, then run the .bat file. It could be like this:

copy c:\MyOracleConfig\listener.ora C:\class\NET80\TNSAPI\.
copy c:\MyOracleConfig\listener.ora C:\Oracle\Ora81\NETWORK\ADMIN\.
copy c:\MyOracleConfig\sqlnet.ora C:\class\NET80\ADMIN\.
copy c:\MyOracleConfig\tnsnames.ora C:\ORACLE\ORA81\NETWORK\ADMIN\.
copy c:\MyOracleConfig\tnsnames.ora  C:\class\NET80\ADMIN\.
copy c:\MyOracleConfig\tnsnames.ora C:\class\NET80\TNSAPI\.

1) Check the name of your computer: Control Panel/Network/Identification
Change it if you want to give it another name.

2) Ping your computer: Start/Run/ type command, click ok
You should have something like:



D:\>ping myzuzu

Pinging myzuzu [127.0.0.1] with 32 bytes of data:

Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128
Reply from 127.0.0.1: bytes=32 time<10ms TTL=128

Ping statistics for 127.0.0.1:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum =  0ms, Average =  0ms

3) Your LISTENER.ORA should look like this:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      (PROTOCOL_STACK =
        (PRESENTATION = TTC)
        (SESSION = NS)
      )
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = YourComputerName)(PORT = 1521))
      (PROTOCOL_STACK =
        (PRESENTATION = TTC)
        (SESSION = NS)
      )
    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LESTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
  )

4) Your SQLNET.ORA:

SQLNET.EXPIRE_TIME = 0
AUTOMATIC_IPC = ON
names.directory_path = (TNSNAMES)

5) Your TNSNAMES.ORA

zuzu =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = YourComputerName)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

I choose zuzu because its easy to type on my keyboard. As this is the name you always type when connecting, choose one which is easy to type.

The SERVICE_NAME = ORCL should be changer if you specified another name during the installation. You can check the name in the very beginning of the INIT.ORA file.

6) With the .bat file, copy all these files.

7) Play with the listener to see if it works: From a command prompt, try these commands:

lsnrctl status
lsnrctl stop
lsnrctl start

See if it starts and stops with no errors. If not, review LISTENER.ORA file.

8) Update the Windows registry:
Run regedit and locate the HKLM/Software/Oracle key.
- Add a string value of name LOCAL ant its value is the name of your computer.

9) From command prompt, start the database with command:

svrmgr30

Enter the command:

connect internal

Provide the password for internal:

oracle

Start the database

startup mount orcl (or whatever name your database is)

Play a bit with it, to stop the database:

shutdown immediate

10) Run oraconct.exe
Click start/run/type oraconct

11) Now, check if you can connect with SQLPlus. First try SQLPlus 8, then try SQLPlus 3.3. If you can connect with 3.3, you are at the end of the tunnel and Forms will connect for sure.

Well, this is rather a painful job, and it may not work for the very first time. Just tell us.
0
 
LVL 9

Expert Comment

by:ornicar
ID: 6242006
Me again!

I have compared the LISTENER.ORA I gave you with the example I have in my documentation. As it is slightly different, and I can't justify the differences, Let me give here the example from my documentation.
You may prefer just modify your existing one in c:\oracle\oracle81

LISTENER =
  (ADDRESS_LIST =
    (ADDRESS =
      (PROTOCOL = TCP)
      (Host = YourComputerName)
      (Port = 1521)
    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
  (SID_LIST =
    (SID_DESC =
       (SID_NAME = ORCL)
    )
  )

For my installation, I prefered to modify the original file, why the differences.
Of course, change YourComputerName accordingly.
0
 

Author Comment

by:dawnb
ID: 6242368
Hey, thank you for the help, but I've still got some problems and questions.  I copied all those *.ora files to the directories you specified above, but got stumped when I tried the following commands:

lsnrctl status
lsnrctl stop
lsnrctl start

I received tons of errors on each one.  Apparently, my listener is not working correctly, but I'm not sure how to fix it.  Personal Oracle worked fine until I installed Forms... maybe I should reinstall?

Also, is 'zuzu' a login name? (I assumed it was, but I'm not really familiar with Oracle, so it was a guess.)

I couldn't locate the 'HKLM/Software/Oracle' key.  I did a search on the HKLM string, and found other occurences, but not this one.

When I ran 'svrmgr30', I got a 'bad command or file name'.  I generally start the database from the Windows start menu, but when I do now, I get a 'ORA-12538 Can not attach to Oracle 8i' message.

At this point I stopped.  I guess the trouble started when the HKLM registry key didn't seem to be there, but even without that, I wonder if I should reinstall?

I am considering digging up a copy of Win98 and installing it, out of desperation.

I do appreciate your help.  Do you have any other ideas?

Thanks--Dawn
0
 
LVL 9

Expert Comment

by:ornicar
ID: 6250532
If Personal was working before, revert the tnsnames.ora to the original version you had:

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
     )
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = bhvsn01)(PORT = 1521))
     )
   )
   (DESCRIPTION =
     (PROTOCOL_STACK =
       (PRESENTATION = GIOP)
       (SESSION = RAW)
     )
     (ADDRESS = (PROTOCOL = TCP)(HOST = bhvsn01)(PORT = 2481))
   )
 )

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = c:\Oracle\Ora81)
     (PROGRAM = extproc)
   )
 )

No, 'zuzu' is not the login name, its the 'Host string' you type after username and password. Choose a name at your convenience.

HKLM is a usual shortcut for HKEY_LOCAL_MACHINE.

If you start the database from the start menu, its ok, on some versions, its svrmgrl. Look for a file like svrmgr*.exe. But at this point, we have to focus on the listener first. Reinstalling Oracle will not refresh the configurations files. You can refresh the listener.ora file by running the 'Net8i Easy Configuration Assistant'.

About installing Win 98, its too early to say yes or no. The install on Win ME works. I my self had problems running the Designer and I can't guarantee that there is no problem with Forms. Win NT or 2000 would be better for sure.

Keep on.

0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 9

Expert Comment

by:ornicar
ID: 6250535
If Personal was working before, revert the tnsnames.ora to the original version you had:

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
     )
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = bhvsn01)(PORT = 1521))
     )
   )
   (DESCRIPTION =
     (PROTOCOL_STACK =
       (PRESENTATION = GIOP)
       (SESSION = RAW)
     )
     (ADDRESS = (PROTOCOL = TCP)(HOST = bhvsn01)(PORT = 2481))
   )
 )

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = c:\Oracle\Ora81)
     (PROGRAM = extproc)
   )
 )

No, 'zuzu' is not the login name, its the 'Host string' you type after username and password. Choose a name at your convenience.

HKLM is a usual shortcut for HKEY_LOCAL_MACHINE.

If you start the database from the start menu, its ok, on some versions, its svrmgrl. Look for a file like svrmgr*.exe. But at this point, we have to focus on the listener first. Reinstalling Oracle will not refresh the configurations files. You can refresh the listener.ora file by running the 'Net8i Easy Configuration Assistant'.

About installing Win 98, its too early to say yes or no. The install on Win ME works. I my self had problems running the Designer and I can't guarantee that there is no problem with Forms. Win NT or 2000 would be better for sure.

Keep on.

0
 
LVL 9

Expert Comment

by:ornicar
ID: 6250540
Sorry for the double post. Got disconnected.
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7033818
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks to all,
Moondancer - EE Moderator

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 

Expert Comment

by:bek
ID: 7035011
After many attempts, I had no success getting Oracle Forms successfully installed on ME.  I don't think it can be done.

Thanks to everyone for your responses!
0
 

Expert Comment

by:bek
ID: 7035013
Moderator, please delete this question (it seems the delete option is no longer available to me).
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 7035591
bek and dawnb -->  Only one account allowed here.  Please let us know which one you wish to keep; and please update (award/close) all open questions.  Administration will be contacting you.

200 points refunded, question closed.

Thank you,

Moondancer - EE Moderator
0
 

Expert Comment

by:bek
ID: 7036442
Moondancer,

bek is my account, which I've had for years.  dawnb belongs to my spouse.  I accidentially responded to a question she posed.  She had the Oracle problem and I've assisted her as best I could.  We both want to keep our accounts.

Thanks,
Brian (bek)
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7078208
Thanks, Brian, for confirming this.
Moondancer - EE Moderator
0
 

Expert Comment

by:bek
ID: 7078251
No problem.  Dawn hasn't been on Experts-Exchange since last summer when we took an Oracle course together.  I will tell her to awards points and close out this thread.

Thanks,
Brian
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now