Home » SQL & PL/SQL » Client Tools » Which client version is used? (Oracle 11G, Win7)
Which client version is used? [message #672162] Thu, 04 October 2018 12:46 Go to next message
OlafCologne
Messages: 11
Registered: September 2008
Location: Cologne
Junior Member
Dear Forum Participants,

there is a possibility to read after the session has been set up,
which client version is used?

Several Oracle client versions are installed on the desktop PCs.
How can I find out which version the application is actually using?

Thank you very much.
Re: Which client version is used? [message #672163 is a reply to message #672162] Thu, 04 October 2018 12:52 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
OlafCologne wrote on Thu, 04 October 2018 10:46
Dear Forum Participants,

there is a possibility to read after the session has been set up,
which client version is used?

Several Oracle client versions are installed on the desktop PCs.
How can I find out which version the application is actually using?

Thank you very much.

Is application 3-tier?

It depends.
DB Server only know what client details are provided.
you can query V$SESSION.PROGRAM
You can query V$SESSION.CLIENT_INFO

You can't push a string & force details from the client; what ever they may be.

What will you do differently after you know the client details?

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Re: Which client version is used? [message #672164 is a reply to message #672162] Thu, 04 October 2018 14:55 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SQL> desc V$SESSION_CONNECT_INFO
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SID                                       NUMBER
 SERIAL#                                   NUMBER
 AUTHENTICATION_TYPE                       VARCHAR2(26)
 OSUSER                                    VARCHAR2(30)
 NETWORK_SERVICE_BANNER                    VARCHAR2(4000)
 CLIENT_CHARSET                            VARCHAR2(40)
 CLIENT_CONNECTION                         VARCHAR2(13)
 CLIENT_OCI_LIBRARY                        VARCHAR2(27)
 CLIENT_VERSION                            VARCHAR2(40)
 CLIENT_DRIVER                             VARCHAR2(9)
 CLIENT_LOBATTR                            VARCHAR2(23)
 CLIENT_REGID                              NUMBER
Re: Which client version is used? [message #672165 is a reply to message #672164] Thu, 04 October 2018 15:00 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

But only if the client is 11g or up.

Re: Which client version is used? [message #672650 is a reply to message #672165] Sun, 21 October 2018 14:24 Go to previous message
OlafCologne
Messages: 11
Registered: September 2008
Location: Cologne
Junior Member
Thank you for your help. With it we could solve our problem.

[Updated on: Sun, 21 October 2018 14:26]

Report message to a moderator

Previous Topic: redundant output
Next Topic: Password Expired
Goto Forum:
  


Current Time: Sat Dec 14 18:00:01 CST 2019