In Oracle : What Database, OS version I use ?

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Maintenance Tasks

-> What Database, OS version I use ?

 

 What Database, OS version I use ?

 

 

1. What is the current version/ maintenance release of the database I use?

2. How could I interpret the Oracle version digits?

3. How could I know if my database is 32-bit or 64-bit version?

4. How could I know if my OS is 32-bit or 64-bit version?

5. What UNIX-type Operating System I use?

6. Which is the last Oracle database patch set available for a particular major version ?

1. What is the current version/ maintenance release of the database I use?

 

To check the Oracle database version from the SQL*Plus prompt, you can issue following sql:

SELECT banner FROM v$version
WHERE banner LIKE ‘Oracle%’;

Or
SELECT version
FROM product_component_version
WHERE product LIKE ‘Oracle%’;

 

 

2. How could I interpret the Oracle version digits?

 

Example: Oracle version 10.2.0.3.1

 

1st Digit: “10” is a major version database number. This is a major new edition of the software, which usually contains significant new functionalities.

2nd Digit: “2” is the database maintenance release number. The maintenance release number increases when bug fixes or new features to existing programs become available.

3rd Digit: “0” is the patch set number. A patch release contains fixes for serious bugs that cannot wait until the next maintenance release.

4th/ 5th Digit: “3.1” identifies a release level specific to a component/OS. This is used to identify a particular emergency patch release of a software product on that operating system.

 


 

3. How could I know if my database is 32-bit or 64-bit version?

 

From the sqlplus prompt you can run :
SELECT banner FROM v$version;

One line will tell you if the database is 32-bit or 64-bit.
Example:
“TNS for 32-bit Windows: Version 10.2.0.3.0 - Production” means that the database is 32-bit. 

On Unix/Solaris/Linux:
cd $ORACLE_HOME/bin
file oracl*


This will display the file type of your oracle binaries. If you are running 64-bit binaries, the output should look like this:
oracle: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped
oracleO: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped


If your binaries are 32-bit, the output will look like this:
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

 

 

4. How could I know if my OS is 32-bit or 64-bit version?

 

On Solaris:
From the command line (as root or not) run this command:

$ /usr/bin/isainfo -kv

If your OS is 64-bit, you will see output like:
64-bit sparcv9 kernel modules

If your OS is 32-bit, you will get this output:
32-bit sparc kernel modules

On Linux, use uname –a
$ uname -a
Linux linux2 2.6.9-22.ELsmp #1 SMP Sat Oct 8 19:11:43 CDT 2005 i686 i686 i386 GNU/Linux

That means 32-bit.

A 64-bit would be 
Linux linux2 2.6.9-22.ELsmp #1 SMP Sat Oct 8 19:11:43 CDT 2005 x86_64 x86_64 x86_64 GNU/Linux

On HP-UX
$ getconf KERNEL_BITS
64

On Microsoft Windows Server 2003
1. Click Start, click Run, type sysdm.cpl, and then click OK. 
2. Click the General tab. The operating system appears as follows:

For a 64-bit version operating system: Microsoft Windows Server 2003 Enterprise x64 Edition appears under System. 
For a 32-bit version operating system: Microsoft Windows Server 2003 Enterprise Edition appears under System. 

 

 

5. What UNIX-type Operating System I use ?

 

$ uname -a
SunOS hostname 5.8 Generic_117350-41 sun4u sparc SUNW,Sun-Fire


In this case is the OS is Sun Solaris SPARC version 8. 

 

 

6. Which is the last Oracle database patch set available for a particular major version ?

 

a) Login to Metalink: https://support.oracle.com/CSP/ui/flash.html


b) Find the Document ID 730365.1 :  Oracle Database Upgrade Path Reference List 

 

 

In-Oracle.com  -> Oracle DBA -> Oracle Maintenance Tasks

-> What Database, OS version I use ?

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.