What platform is my Oracle running on?

User_3OSSM

I've been given access to an Oracle instance running somewhere but I do not have access to its underlying platform. i.e. I have a database user and the database connection information including host name, port number and SID so I can connect to the database using SQL*Plus and run my queries but I even do not know whether it is running on Windows or Linux.

I need to know:

(1) What's the platform?

(2) If Windows, does it support ODP.Net?

Assuming my database user has all the necessary privileges, what can I do? Can I run a query or are there any views that give me this sort of information?

User_6XD9J

You could try running this query but you may not have access to the view:

SELECT platform_id, platform_name FROM v$database

Alex Keh-Oracle

To answer the second question, ODP.NET supports all Oracle DB servers regardless of the OS of the DB server.

Billy Verreynne

https://community.oracle.com/tech/developers/discussion/4477114/what-platform-is-my-oracle-running-on

The database server does not care what o/s the client uses.

The database client does not care what o/s the server uses.