Detecting the Oracle DBMS version
You may use the following steps to detect your oracle version:
1.
Login to the machine which hosts your Oracle database.
2.
su to your Oracle user.
3.
execute your Oracle user's .profile.
4.
cd to ORACLE_ HOME/bin.
5.
Execute the following command: /sqplus /nolog
6.
Type: connect as sysdba
7.
Provide your Oracle DBA username and password.
8.
Execute the startup command if the instance is not running.
9.
Execute the following command: select * from V$VERSION
10.
Obtain the version output..
For example:
$ ./sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Mar 15 12:56:19 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> connect as sysdba
Enter user-name: scott
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1328912 bytes
Variable Size 262387952 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> select * from V$VERSION
2 ;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Productio
NLSRTL Version 10.1.0.2.0 - Production