OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed

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

2 Responses to “How to get the OS of the database server”

  1. stbu Says:

    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.

  2. TFox Says:

    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.

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question