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 […]
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 […]
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 […]
In this post, we are going to create ADWC database on OCI. 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 “Autonomous Data Warehouse” or alternatively, click on “Autonomous Data Warehouse” on the welcome […]
Here I would be discussing how to upgrade Oracle 11gR2 (184.108.40.206) database to Oracle 19c (220.127.116.11.0) on the same server. This upgrade process was done on Oracle Linux 7.6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to […]
To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to refresh materialized views. Oracle recommends that all materialized views (MV’s) are refreshed before upgrading the database because this will clear the MV logs and the sumdelta$ table, and make the UPGRADE process faster.
SQL> declare num_failures integer(3) :=0;
DBMS_MVIEW.REFRESH_ALL_MVIEWS(num_failures,'C','', TRUE, FALSE);
PL/SQL procedure successfully completed.
SQL> SQL> select count(1) from sumdelta$;
Stay tuned for more articles on Oracle 19c Thank you for giving your valuable […]
After installing Oracle 19c home, now we are going to create to database on-premise. Run the DBCA after setting the Oracle Home.
[oracle@oracle19c ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@oracle19c ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@oracle19c ~]$ dbca
Select Database type as Oracle Single Instance database. Provide the database name as SID. Use the default template. Check the enable archiving if you want enable archive log mode. Create a new […]
In this post, we are installing Oracle 19c binaries on OEL 7.6. First, we need to download the software then unzip it on oracle home and start runInstaller from the software location.
[root@oracle19c ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
[root@oracle19c ~]# chown -R oracle:oinstall /u01
[root@oracle19c ~]# chmod -R 775 /u01
[oracle@oracle19c ~]# ./runinstaller &
Select a “Set Up Software Only” and click next. Select on “Single instance database Installation” and click on next. Select on “Enterprise […]
The following are changes in Oracle Installation for Oracle Database release 19c. Root Scripts Automation Support for Oracle Database Installation Rapid Home Provisioning (RHP) Name Change Starting with Oracle Database 19c and Oracle Grid Infrastructure 19c, Rapid Home Provisioning is renamed to Fleet Patching and Provisioning (FPP). The following are changes in Oracle Database Data Warehousing for […]
The following are changes in Oracle Database Performance Tuning for Oracle Database Release 19c. Memoptimized Rowstore – Fast Ingest Automatic Database Diagnostic Monitor (ADDM) support for pluggable databases (PDBs) The following are changes in Oracle Database In-Memory for Oracle Database release 19. Database In-Memory wait on populate Big Data and performance enhancements for In-Memory external tables Hybrid partitioned […]