OraQA

How to get the OS of the database server

February 3rd, 2006 By Eddie Awad

To get the operating system information of the server where the Oracle database lives use dbms_utility.port_string:

From XE (installed on Win XP PC):

HR@XE> select dbms_utility.port_string from dual;

PORT_STRING
--------------------
IBMPC/WIN_NT-8.1.0

It looks like Microsoft Windows XP Pro OS is recognized as IBMPC/WIN_NT.

Other examples:

SQL> select dbms_utility.port_string from dual;

PORT_STRING
------------------------------
DEC Alpha OSF/1, r1.1-8.1.0

SQL> select dbms_utility.port_string from dual;

PORT_STRING
------------------------------
Linuxi386/Linux-2.0.34-8.1.0

Filed under Administration, SQL. Follow any responses to this entry through this RSS 2.0 feed.

stbu Says:
February 8th, 2006 at 11:50 am

You may also use

SQL> SELECT platform_name FROM v$database

PLATFORM_NAME
------------------------------
Microsoft Windows IA (32-bit)

Well, at least it’s working with Oracle XE.

TFox Says:
February 22nd, 2006 at 6:33 pm
FYI, platform_name is not a valid column in the v$database view in 8i and 9i installations. It appears dbms_utility.port_string is available in all versions.

You must be logged in to post a comment.