12

How can I find the active values of SQLNET.ORA parameters on the server?

I know how to find the SQLNET.ORA file but there's no guarantee the values in that file are actively used. Parameter changes may require restarting the listener and sometimes even restarting the database. For debugging I want a way to be 100% certain how the parameters are set, without restarting anything.

This is similar to this question, but I am looking for any method to find the current values. It doesn't have to be a SQL query.

Here's what I've tried so far that leads me to believe it's impossible:

  1. Tracing does not generate that data.
  2. There does not appear to be anything in the data dictionary.
  3. There's no information in the manual or support.oracle.com.
  4. Offered a bounty but no takers. (But I'll offer and award another bounty if anyone can answer this.)
Improve this question
8
  • I don't know. But if one starts a program with TRACE_SQL_SERVER=SUPPORT in sqlnet.ora one can try to find out something about the sqlnet properties.
    – miracle173
    Aug 15, 2014 at 19:34
  • @miracle173 Setting TRACE_LEVEL_SERVER=support does take effect right away, but the trace files don't appear to have information about the parameters.
    – Jon Heller
    Aug 15, 2014 at 20:43
  • I dont think there is a way using SQL, excep for wallet location perhaps.
    – Raj
    Aug 18, 2014 at 20:18
  • 1
    I don't know of any way, you can log a SR and ask Oracle support. But I doubt they will tell you. My understanding is these are not persisted but accessed during listener start-up and client authentication.
    – Raj
    Aug 19, 2014 at 11:44
  • 1
    I understand, still my guess is those are only read at listener start-up/reload and during client session authentication. Why? because lsof command doesn't show this file is being used by any process. These parameters are not exposed as environment variables for the process (I checked that).
    – Raj
    Aug 19, 2014 at 16:01

1 Answer 1

Reset to default
1

Parameters set in the sqlnet.ora file are not exposed in any data dictionary table. You can't write a SQL query to find them.

Source: https://community.oracle.com/thread/2550107?start=0&tstart=0

Improve this answer
1
  • 2
    A query would be nice but I am explicitly looking for any method. However, the methods listed in that source will not work. Just reading the sqlnet.ora file is not sufficient for multiple reasons.
    – Jon Heller
    Oct 28, 2014 at 22:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.