Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in Linux by (18.4k points)
The subject says it all: Is there a better way to determine this exact version of the oracle client I'm running? Our clients are all running on Windows.

I found one suggestion to run a tnsping utility, without using the parameters, which display the version and information. Is there any better way to achieve it?

Does a client install put the information in any sort of text file?

1 Answer

0 votes
by (36.8k points)

You can use a v$session_connect_info view against a current session ID (SID from the USERENV namespace in SYS_CONTEXT).

e.g.

SELECT

  DISTINCT

  s.client_version

FROM

  v$session_connect_info s

WHERE

  s.sid = SYS_CONTEXT('USERENV', 'SID');

Want to be a Linux expert? Come and join this Linux course

Do check out the video below

 

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 18, 2020 in Linux by blackindya (18.4k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...