Home » RDBMS Server » Server Administration » How to know if my oracle DB is on premise or cloud (Oracle 12.2+)
How to know if my oracle DB is on premise or cloud [message #689841] Fri, 17 May 2024 03:52 Go to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Not long ago it was easy to determine if your DB is on premise or on cloud: their banners (from v$VERSION) were different.
Now Entreprise and Standard original editions can be on premise or on cloud so we can no more determine in which environment we are just looking at the banner.

Starting with 21c, V$PDBS contains a CLOUD_IDENTITY column which is not null if you are on cloud.

So my question, in 12.2 to 19c, how to know, using SQL, if my oracle DB is on premise or cloud?

Bonus: how to know if it is OCI (Oracle Cloud Infrastructure) or ACE (Authorized Cloud Environment) or even neither (and unsupported)?

Re: How to know if my oracle DB is on premise or cloud [message #689842 is a reply to message #689841] Fri, 17 May 2024 04:07 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
On ExaCC you can check for "EE Extreme Perf Release".
Re: How to know if my oracle DB is on premise or cloud [message #689843 is a reply to message #689842] Fri, 17 May 2024 05:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the reply.

This is what I mean by "their banners (from v$VERSION) were different", all editions with "Perf" in the banner are in OCI and other ones were necessarily on premise which is no more the case now.

Re: How to know if my oracle DB is on premise or cloud [message #689856 is a reply to message #689843] Fri, 24 May 2024 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I posted my question on AskTOM and got some answers from Connor McDonald:
https://asktom.oracle.com/ords/asktom.search?tag=how-to-know-if-my-oracle-db-is-on-premise-or-cloud

The following page from Sinan Petrus Toma gives a more complete answer:
https://database-heartbeat.com/2021/08/31/isautonomous/



Re: How to know if my oracle DB is on premise or cloud [message #689864 is a reply to message #689856] Fri, 24 May 2024 10:46 Go to previous messageGo to next message
John Watson
Messages: 8938
Registered: January 2010
Location: Global Village
Senior Member
The problem with the AskTOM answer is that it doesn't answer the question. It tells you if you are an Autonomous database, it doesn't help if you are (for example) an OCI DB System database.

There must be a way. Oracle himself certainly detects it is a cloud platform, and indeed which one.  This article,
Creating More Than 3 PDBs Raises ORA-65011 Error In Enterprise Edition When On Public Cloud (Doc ID 2815338.1)
makes it clear (though it references the wrong error, it should ora-65010, not 65011). If you get an ora-65010, setting "_cdb_disable_pdb_limit" = TRUE gets around it.

This article,
https://www.dbi-services.com/blog/oracle-disables-your-multitenant-option-when-you-run-on-ec2/
describes using strace to find the function call that does it, apparently it is kgcs_clouddb_provider_detect
Re: How to know if my oracle DB is on premise or cloud [message #689867 is a reply to message #689864] Fri, 24 May 2024 13:16 Go to previous message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Interesting article, will study this more.

Previous Topic: Traditional auditing: how to query existing audits?
Goto Forum:
  


Current Time: Sun Jun 23 20:37:16 CDT 2024