Re: dbms_utility.port_string alternative or enhancement

Please explain *why* you need this (and which platforms you need).. It seems somewhat counter-intuitive given all the effort Oracle has made to try to isolate the Oracle user/program from the underlying platform, and the explanation might help determine some feasible alternatives.

Have you looked at SYS_CONTEXT?
http://docs.oracle.com/database/121/SQLRF/functions199.htm#SQLRF06117

Anything in V$TRANSPORTABLE_PLATFORM?
http://docs.oracle.com/database/121/REFRN/GUID-3A1B045A-4358-496F-8527-D4FDE67E388F.htm#REFRN30293

/Hans

On 05/07/2016 2:40 PM, Luis Santos wrote:
> We can get some info about our Oracle DBMS host platform using old and
> good *dbms_utility.port_string*.
>
> *[11g]> select dbms_utility.port_string from dual;*
> *
> *
> *PORT_STRING*
> *-------------------------------------------------------------------------------*
> *x86_64/Linux 2.4.xx*
> *
> *
> *
> *
> *[11g]> select dbms_utility.port_string from dual;*
> *
> *
> *PORT_STRING*
> *---------------------------------------------------------------------------*
> *IBM AIX64/RS6000 V4 - 8.1.0*
>
> /
> /
> /​/Is there a way to get this information is more structured way? For
> example, on Linux Systems, we can get detailed and structures info
> about OS using lsb_release:
> /
> /
> /
> /
>
> *[oracle_at_vasco P01CT1 /home/oracle]$ lsb_release -a*
> *LSB Version: 1.3*
> *Distributor ID: RedHatEnterpriseAS*
> *Description: Red Hat Enterprise Linux AS release 4 (Nahant)*
> *Release: 4*
> *Codename: Nahant*
> ​
>
>
> /
> /
> /--/
> /Att/
> /Luis Santos
>
> /
> /
> /

--
http://www.freelists.org/webpage/oracle-l