One Of The Best Tips About How To Check Oracle Version In Unix
Jun 15, 2015 5:43am edited jun 15, 2015 5:43am.
How to check oracle version in unix. Select * from v$version within the db this will give you the major release version. You should reference the inst_loc entry as the location for your software. There are two ways to see version information:
Oracle offers a comprehensive and. In the bin folder, there should be an executable called tnsping.exe. Sql command to get oracle client version.
In this directory, there should be. Another method is using dbms_utility.db_version package available in the database. Here are seven ways to check which version of oracle database you’re running.
Click here to get sample output. Login or register to ask a question and join our community. My administrator give me command for linux as below.
Search for java in the installed packages list Use dbms_utility.db_version package to check oracle version. Don't have a my oracle support account?
Select distinct s.client_version from v$session_connect_info s where s.sid =. All (will check all oracle installations in oracle_home) invptrloc (provides the. Use command prompt or locate the home oracle.