Display the Database Version and Server Operating System Name


Display the Database Version and Server Operating System Name

—————————————————————————–

The following query gives the version of the Oracle Database.

SELECT banner FROM v$version;

Example:-

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 – Prod

PL/SQL Release 10.2.0.2.0 – Production

CORE 10.2.0.2.0 Production

TNS for Linux: Version 10.2.0.2.0 – Production

NLSRTL Version 10.2.0.2.0 – Production

From above information, we can say this is 10g Database and Server Operating system is Linux.

The following query can be used to get the version of the Server Operating system.

BEGIN

dbms_output.put_line('Port String: '||dbms_utility.port_string);

END;

Example:-

Port String: Linuxi386/Linux-2.0.34-8.1.0

From the above information, we can say this is Linux Operating system and version is 2.0.34-8.1.0

Note:- If you are login into the server with some ID then you can also know the name and version of the Server Operating system directly by typing

> uname

via Oracle Apps Training: Display the Database Version and Server Operating System Name.

2 thoughts on “Display the Database Version and Server Operating System Name

Want to give some comment to author ( Shivmohan Purohit )

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