Как узнать версию oracle linux
Перейти к содержимому

Как узнать версию oracle linux

  • автор:

Oracle Linux: How to Find out Linux Version Information (Doc ID 207296.1)

Oracle Cloud Infrastructure — Version N/A and later
Linux OS — Version Oracle Linux 4.4 to Oracle Linux 5.9 with Unbreakable Enterprise Kernel [2.6.39] [Release OL4U4 to OL5U9]
Linux Itanium
Linux x86-64
Linux x86
Linux ItaniumLinux x86-64

This note guides how to find such information on the Linux server.

Solution

To view full details, sign in with your My Oracle Support account.

Don’t have a My Oracle Support account? Click to get started!

In this Document

Goal
Solution
How to find out Linux release information
How to find out which Linux kernel version
How to find out what version of Glibc libraries
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. � Oracle | Contact and Chat | Support | Communities | Connect with us | Facebook | Twitter | Linked In | Legal Notices | Terms of Use

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
  • Facebook
  • Twitter
  • Buffer

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.

Lynis Enterprise screenshot to help with system hardening

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."

Benefits:

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

Enjoy the articles!

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

7 Ways to Check your Oracle Version

Here are seven ways to check which version of Oracle Database you’re running.

  • The V$VERSION view.
  • The V$INSTANCE view.
  • The PRODUCT_COMPONENT_VERSION view.
  • The SQL Developer GUI.
  • The SQLcl tool.
  • The SQL*Plus tool.
  • The DBMS_DB_VERSION package.

The V$VERSION View

The V$VERSION view returns the version and component level information.

Other columns include BANNER , BANNER_LEGACY , and CON_ID , but the BANNER_FULL column returns everything we need.

The V$INSTANCE View

If you have the appropriate permissions, you can use the V$INSTANCE view to return just the version.

The PRODUCT_COMPONENT_VERSION View

Another option is the PRODUCT_COMPONENT_VERSION data dictionary view.

The SQL Developer GUI

If you’re using the SQL Developer GUI, and you don’t want to run the above views (or can’t remember their names), you can navigate to the applicable data dictionary report in the Reports pane.

To do this, under the Reports pane, go to Data Dictionary Reports > About Your Database > Version Banner.

Clicking on Version Banner opens a prompt where you need to select the connection:

Screenshot of SQL Developer with the Select Connection prompt

Select the appropriate connection and click OK.

This opens a new tab with the version information:

Screenshot of the version information

The SQLcl Tool

SQLcl is a command line interface for working with Oracle Database. When you use SQLcl to connect to an Oracle instance, the release and version are displayed.

The first thing returned when connecting via SQLcl is the SQLcl release number. However, once it connects, it then returns the Oracle Database release and version information.

Here, I connected using the username hr and password oracle . The sql command is the name of the executable SQLcl file, its folder of which I’ve previously added to my PATH variable. If you haven’t added it to your PATH, you may need to include the full path.

Of course, once you’ve connected with SQLcl, you can also use any of the other methods on this page to get the Oracle Database version.

The SQL*Plus Tool

If you don’t have SQLcl, you could try SQL*Plus.

Oracle SQL*Plus is a command line tool that is installed with every Oracle Database Server or Client installation. It’s been around since 1985 (a lot longer than SQLcl). It displays the same information that SQLcl displays when connecting to Oracle Database.

The DBMS_DB_VERSION Package

Another option is the DBMS_DB_VERSION package. We can return the VERSION constant and also the RELEASE constant if required.

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.

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

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.

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.

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.

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *