Skip to content
Tags

What version of Oracle is installed?

10/03/2011

It may seem like a strange thing for a DBA to have to find out as the assumption may be that the DBA already knows or can recall all the instances and version numbers installed instantly from memory, but if one needed to find out the version of Oracle and any installed options, this may be helpful.

  • Open a session on the Solaris server (use Telnet or Putty).
  • Connect to SQLPLUS – sqlplus / as sysdba.
  • The information will be displayed, for example:
sqlplus connection

sqlplus connection

We can see that Oracle 10gR2 Enterprise Edition is installed with the Partitioning, OLAP and Data Mining options.

Alternatively, one could use a tool such as Toad or SQL Developer.

  • Connect to the database using Toad.
  • Type SELECT * FROM v$version; (v$version is one of the many system views).
  • Execute the SQL statement.
  • View the results either in Output or Grid:
Toad v$version

Toad v$version

The SELECT * FROM v$version; statement can of course be run from SQLPLUS to view the same information.

Advertisements

From → Oracle

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: