|
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.
More information
about this subject (
What Database & OS version I use ? ) you can get from
www.in-oracle.com
|