What Operating System is my database running on?

You can use the dbms_utility.port_string function to determine on what hardware platform, operating system and TWO TASK PROTOCOL version your Oracle database is running on.

The specification for this function follows:

FUNCTION DBMS_UTILITY.PORT_STRING RETURN VARCHAR2;

Here are some examples:

SQL> SELECT dbms_utility.port_string FROM dual;

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

SQL> VAR portstr VARCHAR2(100)
SQL> EXEC :portstr := dbms_utility.port_string;

PL/SQL procedure successfully completed.

SQL> PRINT portstr

PORTSTR
--------------------------------------------------------------------------------
IBMPC/WIN_NT-8.1.0

In the above example the platform is IBMPC, the OS is WIN_NT and the Two Task protocol version is 8.1.0.

Other reported port string values:

• VAX/VMX-7.1.0.0
• DEC Alpha OSF/1, r1.1-8.1.0
• SVR4-be-64bit-8.1.0
• SVR4-be-7.0.0
• Linuxi386/Linux-2.0.34-8.1.0
• IBMPC/WIN_NT-8.1.0
• IBMPC/WIN_NT-7.3.3

Also see http://www.orafaq.com/scripts/sql/ver.txt