0

Because we run multiple instances of the same application on the dev-servers, I'm trying to add the sqlnet.client_registration-parameter to the sqlnet.ora-files used by each instance. This, I hope, would help us distinguish clients by the instance-name instead of (or in addition to) hostname:

sqlnet.client_registration=MeowMeow

However, I do not see the configured strings anywhere in the V$SESSION -- is there some other place to look for the "MeowMeow" from the above example?

Improve this question
2
  • client_registration appears in the audit trail, not v$session
    – pmdba
    Sep 14, 2022 at 19:40
  • Potentially you could modify your app code to call the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure. That will allow up to a 64 byte identifier to be placed into V$SESSION. See here: docs.oracle.com/en/database/oracle/oracle-database/19/arpls/…
    – pmdba
    Sep 14, 2022 at 19:47

1 Answer 1

Reset to default
0

  1. This parameter is valid for the client, not the server. Configuring it on the server side makes no sense.

  2. The extra information is displayed in the listener log, and it does not appear in audit trail nor V$SESSION.

Improve this answer
3
  • I am talking about the client-side sqlnet.ora -- multiple application-instances talk to the same server, and I'd like to make it easier for us to distinguish the connections.
    – Mikhail T.
    Sep 15, 2022 at 2:44
  • @MikhailT. Ok, then as suggested, use DBMS_APPLICATION_INFO.SET_CLIENT_INFO.
    – Balazs Papp
    Sep 15, 2022 at 6:31
  • Not an option, unfortunately -- this is a closed-source application from an external software vendor...
    – Mikhail T.
    Sep 15, 2022 at 16:10

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.