Linux проверить версию oracle

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 Check Oracle Database Version

In this Oracle tutorial, we will learn how to check oracle database version. Also, we will cover these topics.

• How to check Oracle Database Version in Linux
• How to check Oracle Database Version in SQL Developer
• How to check Oracle Database Version in Toad
• How to check Oracle Database Version in Windows
• How to check Oracle Database Version in Solaris

How to Check Oracle Database Version in Linux

In this section, we will learn how to check the oracle database version in Linux using the command line or Terminal.

Using the below command on a terminal of the Linux operating system we can display the current version of the current oracle database.

How to Check Oracle Database Version in SQL Developer

In this section, we will learn how to check the oracle database version in the SQL Developer tool.

• SQL Database tool is an IDE (Integreted Development Environment) that facilitiates oracle developers to write queries with Graphical User Interface (GUI).
• To check version of oracle database running on SQL developer tool ‘Navigate to Reports‘ expand ‘Data Dictionary Reports‘ inside data dictionary report expand ‘About Your Database‘ and from there click on ‘Version Banner‘.
• The moment you will click ‘Version Banner’ there will be a prompt with the version of oracle database running on the SQL developer tool.

• You can also use the query to check the version of oracle database running in SQL deverloper tool.

As you can see oracle database 19c is installed on this SQL developer tool.

How to Check Oracle Database Version in Toad

In this section, we will learn how to check the oracle database version in the toad.

• Toad is an advance database software that is used for commercial purpose mainly.
• To check the version of oracle database in toad software write the below query.

How to Check Oracle Database Version in Windows

In this section, we will learn how to check the oracle database version in Windows operating system using command prompt (cmd).

Below is the command line to check oracle database version in windows 10 operating system.

How to Check Oracle Database Version in Solaris

In this section, we will learn how to check the oracle database version in Solaris. Using the below command we can display the current version of the Oracle database running on the Solaris operating system

You may also like to read the following tutorials on oracle.

In this tutorial, we have learned how to check Oracle database version. Also, we have covered these topics.

• How to check Oracle Database Version in Linux
• How to check Oracle Database Version in SQL Developer
• How to check Oracle Database Version in Toad
• How to check Oracle Database Version in Windows
• How to check Oracle Database Version in Solaris

I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.

Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.

Источник