I am listing here 55 articles which I write and are published on the different Oracle Technology Network (OTN), different Oracle User Group (OUG) and ToadWorld. OTN Spanish Oracle Cloud: Creación de Configuración Oracle RAC en Cloud Oracle Cloud: Creando base de datos en la nube en base a “backup” existente (Parte I) Oracle Cloud: […]
All posts by Skant Gupta
Release Upgrade from 18.3 to 18.5 by applying RU
Database 18c Patch As of the Release date (16-Jan-2019), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Then afterwards, it was available for on-premise as well. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must use the OPatch utility version 12.2.0.1.14 or later to apply this patch. Oracle […]
Manual upgrading Oracle database 11gR2 to 19c
Manual upgrading Oracle database 11gR2 to 19c If you want to know how we upgrade an 11.2.0.4 database to 19.0.0.0.0 using DBUA, click here. This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1, 18c to 19.0.0.0.0 manually. Manually upgrading to 19c There are many DBAs who don’t want to follow the recommended […]
Oracle Autonomous Database CookBook
Written by Oracle Certified Master Skant Gupta and Oracle Certified Professional Mohit Sharma are diligently planned to direct the readers about the usage of Oracle Autonomous Database. The primary target audience is Oracle DBAs and Oracle Cloud DBA’s. This book has been diligently planned for all levels of DBA experts. Coming right from the real-world […]
Creating Object Store Credentials in Autonomous Transaction Processing (ATP)
In this post, you use the ADMIN user schema. You store the Auth Token created in the previous post along with the username, as a credential under an ADMIN schema. Connect to ADMIN user using SQL Developer. Use the create_credential procedure of the DBMS_CLOUD package to store the object store credentials in your ADMIN schema. Set the […]
Stopping/Starting your Autonomous Data Warehouse Cloud (ADWC) instance
In this post, we are going to stop & start the ADWC database on OCI. We assume that you must have OCI account with valid credentials and compartments. Stopping your ADWC instance Go to the Cloud Console you used during the provisioning exercise and open the Instances screen. Click the Instance Name (SKANTADWC). Click Stop. […]
Monitoring your ADWC instance
In this post, you will use the service console to monitor your ADWC instance. As ADWC only accepts secure connections to the database, you need to download a wallet file containing your credentials first. The wallet is downloaded from the ADWCservice console. On the Instances page, find your database and click “Service Console” in the actions […]
Loading a Data from csv into ADWC
In this post, you will load data from a csv file into ADWC. Note: we already have table.csv for our testing. Now, we open the SQL Developer and connect with NEWADW connection which is already save in SQL Developer. SQL Developer ADWC Right-click “Tables,” and then click “Import Data.” Click “Browse” and locate the channels.csv […]
Creating an Oracle Cloud Infrastructure (OCI) Object Storage Bucket
In this post, you will create a storage bucket using Oracle Cloud Infrastructure (OCI) Object Storage. We assume that you must have OCI account with valid credentials and compartments. Launch the web browser and Log into your assigned OCI account. Expand the Hamburger menu and select “Object Storage” or alternatively, click on “Object Storage” on […]
Connecting to the Autonomous Data Warehouse Cloud (ADWC) Database Using SQL Developer
In this post, you will connect to the ADWC database instance using SQL Developer. As ADWConly accepts secure connections to the database, you need to download a wallet file containing your credentials first. The wallet is downloaded from the ADWC service console. On the Instances page, find your database and click “Service Console” in the actions […]