Oracle linux show version

how to find the Oracle database version

Many times question is being asked about how to find the Oracle database version and version of various Oracle utilities in Linux, Solaris, AIX, and Windows. Let’s check out how is the oracle database version defined and How to find the Oracle database version

Oracle Database Versions

• Oracle has released various versions of the Oracle database starting in 1979. They release Oracle 8i in 1998 where “i” stand for the internet.
• They release Oracle 10g in 2003 where “g” stands for grid.
• Then they release Oracle 12c in 2013 where “c” stands for the cloud.
• After that, they continued year-wise starting in 2018. So 2018 was 18c Release, 2019 was 19c Release, and so on.
• The latest version right now is 21c released in 2021. They are terming some versions as innovation releases and some as Long term releases.
• Innovation releases have shorter support periods ie. 2 years and long-term releases have 7-8 year support periods. So businesses can choose the release accordingly.
• Right Now, 19c is the long-term release, and 18c,20c, and 21c are innovation releases. The next long-term release will 23c

how to check oracle database version in Linux or any OS/how to check oracle version in linux

We can easily check the version using any of these three methods. You need to source the environment and then they can use any of these methods

SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Prod
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for 32-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

or
you could use opatch also

$ORACLE_HOME/OPatch/opatch lsinventory

select version from v$instance;

How to find client sqlplus version in use

sqlplus -v
SQL*Plus: Release 10.1.0.5.0 - Production

How to find the version of expdp

expdp
Export: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44

How to find the version of the nid utility

$nid DBNEWID: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44

How to find the version of exp

$exp Export: Release 11.2.0.4.0 - Production on Saturday, 11 October, 2015 0:22:44

How to find the version of rman

how to check oracle version in sql developer

• In SQL Developer, click the Reports tab on the left, near the Connections navigator. (If this tab is not visible, click View, then Reports.)
• In the Reports navigator, expand Data Dictionary Reports.
• Under Data Dictionary Reports, expand About Your Database.
• Under About Your Database, click Version Banner.

how to check oracle client version in linux

We can simply do these to find it

sqlplus -v 
SQL*Plus: Release 10.1.0.5.0 - Production

Some Explanation about Version

Major Database Release Number	The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.
Database Maintenance Release Number	The second digit represents a maintenance release level. Some new features may also be included.
Application Server Release Number	The third digit reflects the release level of the Oracle Application Server (OracleAS).
Component-Specific Release Number	The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases.
Platform-Specific Release Number	The fifth digit identifies a platform-specific release. Usually, this is a patch set. When different platforms require the equivalent patch set, this digit will be the same across the affected platforms.

Also reads
Oracle database cloning: Check this page for Oracle database cloning which is an important role of an Oracle DBA. See steps by steps instructions with an explanation
DBMS_REDEFINITION : Online table redefinition allows for modification of the table structure definition without significantly affecting the availability of the table.
CPU vs Core Vs Socket: Find out what is CPU vs Core Vs Socket, difference and how to find them in windows using the different commands in an easy manner,
clone database from cold backup: This post consists of step by step detailed instructions to clone the oracle database using the cold backup database cloning method
dbms_metadata.get_ddl materialized view: Check out how to get table definition in oracle, oracle show index definition, get ddl of a materialized view in oracle, get the query of a view in oracle
opatch version command : check out this post on How to check the opatch version or opatch version command, apply the patch(opatch apply), Upgrade, opatch lsinventory

Recommended Courses

The following are some of the recommended courses you can buy if you want to get a step further

Given below are the links to some of the courses

Oracle DBA 11g/12c – Database Administration for Junior DBA : This course is good for the people who are starting as Junior DBA or aspire to be Oracle DBA. This will provide a good understanding of backup & recovery and General administration tasks
Oracle Database: Oracle 12C R2 RAC Administration : This course covers the installation, administration of Oracle RAC. A good course for Oracle DBA who want to upgrade his skills for Oracle RAC
Oracle Data Guard: Database Administration for Oracle 12C R2 : This course covers the installation, administration of Oracle Dataguard. A good course for Oracle DBA who want to upgrade his skills for Oracle Dataguard

Источник

How to find which version of Oracle is installed on a Linux server (In terminal) [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

I am in terminal in Redhat 5.5 and I need to find out which version of Oracle is installed. I am pretty new at Linux, but I have searched Google for a while and I can’t find what I need. I have to locate which version is installed via terminal. I found the Oracle files, but I can’t seem to find the version.

7 Answers 7

Enter in sqlplus (you’ll see the version number)

# su - oracle oracle# sqlplus 

Will give you the path where Oracle installed and path will include version number.

Connect to Oracle DB and run

select * from v$version where banner like 'oracle%'; 

First off thanks for your reply. I got into the Oracle file, and ran ls. The list of files are ‘bea emkey.ora glibc-devel-2.5-49.i386.rpm oradiag_oracle’ does one of those contain the Oracle version?

idk of previous versions, but in 11g the condition would be: «where banner like ‘Oracle%’ since the result is: Oracle Database 11g Express Edition Release 11.2.0.2.0 — 64bit Production

As the user running the Oracle Database one can also try $ORACLE_HOME/OPatch/opatch lsinventory which shows the exact version and patches installed.

For example this is a quick oneliner which should only return the version number:

$ORACLE_HOME/OPatch/opatch lsinventory | awk '/^Oracle Database/ ' 

It is remarkable hard to find out the actual patch level. lsinventory is the best approach. You might want to add -bugs_fixed. On the PSU level you can use select comments, version, bundle_series from sys.registry$history where bundle_series = ‘PSU’ order by action_time;

Login as sys user in sql*plus. Then do this query:

select * from product_component_version; 

As A.B.Cada pointed out, you can query the database itself with sqlplus for the db version. That is the easiest way to findout what is the version of the db that is actively running. If there is more than one you will have to set the oracle_sid appropriately and run the query against each instance.

You can view /etc/oratab file to see what instance and what db home is used per instance. Its possible to have multiple version of oracle installed per server as well as multiple instances. The /etc/oratab file will list all instances and db home. From with the oracle db home you can run «opatch lsinventory» to find out what exaction version of the db is installed as well as any patches applied to that db installation.

I solved this in about 1 minute by just reading the startup script (in my case /etc/init.d/oracle-xe):

At almost the beginning of the file I found:

ORACLE_HOME=[PATH_TO_INSTALLATION_INCLUDING_VERSION_NUMBER]

This was the quickest solution for me because I knew where the script was located, and that it is used for starting/restarting the server.

Of course, this relies on that the version number actually corresponds to the actual server version, which it should for a correctly installed instance.

Источник

How To Check Oracle Version In Linux

Have you ever been handed a database server that someone else used to be responsible for? Are people asking you questions about this server now? Do you need to know how to check Oracle version in Linux? If you are a sysadmin and don’t know much about Oracle then this might not be obvious. You also might not have a DBA around to ask. You might BE the DBA. If you are the DBA you really should know this but who knows maybe you have only ever worked with MySQL or Sybase and someone just recently decided that you would now have to be an Oracle admin. Whatever the reason is, we have you covered.

Here is one way to check the version of Oracle from a Linux server. You are going to want to be logged in as the user that the database runs as.

 $ORACLE_HOME/OPatch/opatch lsinventory | awk '/^Oracle Database/ ' 

You can also connect to the database and run the following SQL command:

 select * from v$version where banner like 'oracle%'; 

Assuming your Oracle user is just ‘oracle’ you can login and check the path based on your ORAHOME variable. The path will probably contain the version number.

Also, just running SQL plus should give you the version. You can also use the version option.

 su - oracle sqlplus sqlplus -version 

How To Check Oracle Version In Linux — Things to Check

You could also grep for ORACLE_HOME in your init script. This is assuming that the init script is located at this path. This will depend on your system. It also depends on your installation path matching the actual version that is installed. They should both match.

 grep ORACLE_HOME /etc/init.d/oracle-xe 

Another place to look might be inside your /etc/oratab file. This is also good if you have multiple instances of Oracle running,

You could figure it out based on the output of the ps command. You will probably see the installation path right in the output. This should contain the version number.

You can also use the inspdver command.

 $ORACLE_HOME/orainst/inspdver 

Источник