Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle dictionary to indicate OS and its version running for the DB

Posted on 2013-10-28
5
Medium Priority
?
319 Views
Last Modified: 2013-11-26
As captioned to see if any Oracle internal table or dictionary can tell if a DB is running in what OS and what version of that OS.
0
Comment
Question by:tindavid
  • 3
4 Comments
 
LVL 49

Accepted Solution

by:
PortletPaul earned 600 total points
ID: 39607827
you use:

select dbms_utility.port_string from dual
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39607829
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39607844
Wait...

WHY "C" ??????????????????????????????????????????????????

how could I add more to this answer?

"C" is considered a damn bad answer
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39613221
You could try the below to see if that can give you the information you are looking for :

select platform_name from v$database
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question