Посмотреть версию oracle linux

How to Check Oracle Database Version?

Oracle is a relational database management system by Oracle Corporation. It is one of the most widely used databases in OLTP, Data warehouse. Oracle released a good number of versions since 1979 and the latest version is 19C which is available for on-premise as well as in the cloud.

Many of the users are still using 11g, 12c, and 18C. So Let’s fWhich version of the database you are running?

Before that let’s understand the database release number format used by Oracle.

Oracle Database Release Number Format

Internally, Oracle maintains versions as five numeric segments (XX.X.X.X.X) divided by periods. e.g for 10G version could be 10.1.0.1.0 or10.1.0.1.1.

• First numeral – Major database release number e.g 12c, 18c.
• Second numeral – Database maintenance release number.
• Third numeral – Application server release number.
• Fourth numeral – Component-specific release number.
• Fifth numeral – Platform-specific release number.

Finding out the Oracle Version?

Oracle maintains version information in V$VERSION, PRODUCT_COMPONENT_VERSION data dictionary Views, or Metadata Table. Just run a query against these views to find out the database version.

• V$VERSION – Version numbers of core library components in the Oracle Database.
• PRODUCT_COMPONENT_VERSION – Version and status information for component products

SQL query to get database version

You can run on SQL* Plus or just copy query and run on SQL Developer.

COL BANNNER FORMAT A200 COL CON_ID FORMAT 99 SELECT * FROM v$version; BANNER CON_ID -------------------------------------------------------------------------------- ------ Oracle Database 10g Enterprise Edition Release 10.1.0.1.0 - 64bit Production 0 PL/SQL Release 10.1.0.1.0 - Production 0 CORE 10.1.0.1.0 Production 0 TNS for Linux: Version 10.1.0.1.0 - Production 0 NLSRTL Version 10.1.0.1.0 - Production 0

COL PRODUCT FORMAT A50 COL VERSION FORMAT A20 COL STATUS FORMAT A40 SELECT * FROM product_component_version; PRODUCT VERSION STATUS -------------------------------------------------- -------------------- ---------------------------- NLSRTL 10.1.0.1.0 Production Oracle Database 10g Enterprise Edition 10.1.0.1.0 64bit Production PL/SQL 10.1.0.1.0 Production TNS for Linux: 10.1.0.1.0 Production

The output of the above query is 10.1.0.1.0. That means you are running 10G Version.

Use dbms_utility.Db_version package to check oracle version

Another method is using dbms_utility.Db_version package available in the database. It is PL/SQL package, so you need to run the below script to get version information.

dbms_utility.db_version returns version and compatibility information.

PL/SQL Script to get DB Version in Oracle,

DECLARE v1 VARCHAR2(100); v2 VARCHAR2(100); BEGIN dbms_utility.Db_version (v1, v2); dbms_output.Put_line('Version ' || v1); dbms_output.Put_line('Compatability ' || v2); END;

Version 19.0.0.0.0 Compatability 19.0.0

Knowing the version information is useful when you open a support request or when a patch needs to be applied. It also helps developers to understand the features available in the release.

Источник

How to see the version of Oracle Linux

Oracle Linux is based on Red Hat Enterprise Linux. At first, it may be confusing to determine what specific operating system is running. This is because both have the /etc/redhat-release file.

If that file exists, use the cat command to display the contents. Next step is to determine if there is a /etc/oracle-release file as well. If so, then you can be sure that Oracle Linux is running.

Sample output might be: Oracle Linux Server release 6.7

Other options

Next time when you are on a system and not sure what it is running, use this:

This shows you any files that might give a hint on the operating system version.

Related files

• /etc/enterprise-release (older versions of OEL)
• /etc/issue
• /etc/issue.net
• /etc/lsb-release

One more thing.

Keep learning

So you are interested in Linux security? Join the Linux Security Expert training program, a practical and lab-based training ground. For those who want to become (or stay) a Linux security expert.

Security scanning with Lynis and Lynis Enterprise

Run automated security scans and increase your defenses. Lynis is an open source security tool to perform in-depth audits. It helps with system hardening, vulnerability discovery, and compliance.

Continue reading

Livepatch: Linux kernel updates without rebooting

How to secure a Linux system

The state of Linux security in 2017

Linux security myths

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About Linux Audit

This blog is part of our mission: help individuals and companies, to scan and secure their systems. We simply love Linux security, system hardening, and questions regarding compliance.

Besides the blog, we have our security auditing tool Lynis. Open source, GPL, and free to use.

For those with enterprise needs, or want to audit multiple systems, there is an Enterprise version.

«One security solution to audit, harden, and secure your Linux/UNIX systems.»

• Perform audits within a few minutes
• Central management
• Powerful reporting
• Compliance checks (e.g. PCI DSS)
• Additional plugins and more tests

Linux and UNIX security automation

Lynis is a free and open source security scanner. It helps with testing the defenses of your Linux, macOS, and Unix systems. Typical use-cases for this software include system hardening, vulnerability scanning, and checking compliance with security standards (PCI-DSS, ISO27001, etc).

Recent Posts

Contact

This blog is part of our mission to share valuable tips about Linux security. We are reachable via @linuxaudit

Company details

CISOfy
De Klok 28,
5251 DN, Vlijmen, The Netherlands
+31-20-2260055

Источник

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

Источник