Boosting Business Agility Oracle E-Business Suite (EBS) with Oracle Database Cloud Service (DBCS)
Note: The minimum database version required for Oracle Database Cloud Service (DBCS) integration with Oracle E-Business Suite (EBS) R12.2.x is Oracle Database 19c Only.
Oracle DBCS is a fully managed, scalable, and secure database service provided by Oracle its cloud-based service that makes it easy to deploy and manage Oracle databases in the cloud. With DBCS, you can provision new databases in minutes and scale up or down as needed without having to worry about capacity planning or managing complex infrastructure. In today's data-driven world, businesses are constantly striving for agility and scalability to meet evolving demands.
DBCS Will Auto Manage :
*Automated Backup and Recovery *Automated Patching and Upgrades (for Database Only ) *Automatic Storage Management *Automated Performance Tuning *Automatic SQL Plan Management *Automatic Indexing *Query Optimization *In-Memory Caching
DBCS accelerates data processing and improves response times. This translates into faster application performance, increased productivity, and improved customer experiences.
If you're ready to take your data management to the next level, it's time to explore the benefits of Oracle DBCS. Embrace the power of the cloud and propel your organization towards a more agile and efficient future. Experience the transformative potential of DBCS and unlock the true value of your data.
Here -i is the DB home id, -h is the help option, -j is the JSON option
[root]# dbcli describe-dbhome -i 52850389-228d-4397-bbe6-102fda65922b
DB Home details
ID: 112850389-228d-4397-bbe6-102fda65933b
Name: OraDB12102_home1
Version: 12.1.0.2
Home Location: /u01/app/oracle/product/12.1.0.2/dbhome_1 Created: June 29, 2020 4:36:31 AM UTC
How to list Db homes
dbcli list-dbhomes [-h] [-j]
Here -h is the help option, -j is the JSON option
[root]# dbcli list-dbhomes ID Name DB Version Home Location ------------------------------------ ----------------- ---------- ------------------------------------------ b727bf80-c99e-4846-ac1f-28a81a725df6 OraDB12102_home1 12.1.0.2 /u01/app/orauser/product/12.1.0.2/dbhome_1 January 19, 2017 10:03:31 AM PST January 19, 2017
How to create a new Oracle Home
dbcli create-dbhome --version 12.1.0.2.180417
Job details
ID: f9c48b8d-c00a-433d-8846-969290af4e81
Description: Database Home OraDB12201_home2 creation with version :12.1.0.2.180417
Status: Created
Created: Sep 20, 2020 8:16:53 PM UTC
Message: Create Database Home
To verify the status of Database Software Installation. You can describe the job using
dbcli describe-job -i
dbcli describe-job -i f9c48b8d-c00a-433d-8846-969290af4e81
Job details
ID: f9c48b8d-c00a-433d-8846-969290af4e81
Description: Database Home OraDB12201_home2 creation with version :12.2.0.1.180417
Status: Success
Created: Sep 20, 2020 8:16:53 PM UTC
Message: Create Database Home
After successful completion, you can execute dbcli list-dbhomes to verify the ORACLE HOME location
Job details ID: 493e703b-46ef-4a3f-909d-bbd123469bea Description: DB Home Patching: Home Id is e1877dac-a69a-40a1-b65a-d5e190e671e6 Status: Running Created: January 19, 2017 10:03:21 AM PST Message:
How to list jobs with dbcli
dbcli list-jobs
TDE Commands
The following commands are available to manage TDE-related items (backup reports, keys, and wallets):
The following commands are to perform administrative actions on the DB system:
dbadmcli manage diagcollect dbadmcli power dbadmcli power disk status dbadmcli show controller dbadmcli show disk dbadmcli show diskgroup dbadmcli show env_hw (environment type and hardware version) (environment type and hardware version) dbadmcli show fs (file system details) (file system details) dbadmcli show storage dbadmcli stordiag
Database Commands(The dbcli create-database command is available on bare metal DB systems only)
The following commands are available to manage databases:
Recovery Manager (RMAN) supports binary compression using one of the following compression levels: HIGH, MEDIUM, BASIC, and LOW. The recommended level for cloud backups is MEDIUM.
CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’; CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO COMPRESSED BACKUPSET; CONFIGURE COMPRESSION ALGORITHM ‘MEDIUM’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE; CONFIGURE DEVICE TYPE ‘SBT_TAPE’ PARALLELISM 4 BACKUP TYPE TO BACKUPSET; CONFIGURE DEVICE TYPE ‘SBT_TAPE’ BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
RMAN> run { allocate channel c1 TYPE ‘SBT_TAPE’ PARMS ‘SBT_LIBRARY=/u01/app/oracle/product/12.2.0.1/db_1/lib/libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0.1/db_1/dbs/opcdbwr.ora)’; backup current controlfile; backup as compressed backupset full database; sql ‘alter system archive log current’; backup archivelog all; }
allocated channel: c1 channel c1: SID=48 device type=SBT_TAPE channel c1: Oracle Database Backup Service Library VER=19.0.0.1 Starting backup at 22-JUL-20 channel c1: starting compressed full datafile backup set channel c1: specifying datafile(s) in backup set including current control file in backup set channel c1: starting piece 1 at 22-JUL-20 channel c1: finished piece 1 at 22-JUL-20 piece handle=08v5vemf_1_1 tag=TAG20200722T193855 comment=API Version 2.0,MMS Version 19.0.0.1 channel c1: backup set complete, elapsed time: 00:00:08 Finished backup at 22-JUL-20 Starting backup at 22-JUL-20 channel c1: starting compressed full datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/oradbwr/system01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/oradbwr/sysaux01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/oradbwr/undotbs01.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/oradbwr/users01.dbf channel c1: starting piece 1 at 22-JUL-20 channel c1: finished piece 1 at 22-JUL-20 piece handle=09v5vemo_1_1 tag=TAG20200722T193904 comment=API Version 2.0,MMS Version 19.0.0.1 channel c1: backup set complete, elapsed time: 00:05:45 Finished backup at 22-JUL-20
Starting Control File and SPFILE Autobackup at 22-JUL-20 piece handle=c-1473061046-20200722-00 comment=API Version 2.0,MMS Version 19.0.0.1 Finished Control File and SPFILE Autobackup at 22-JUL-20
sql statement: alter system archive log current
Starting backup at 22-JUL-20 current log archived channel c1: starting compressed archived log backup set channel c1: specifying archived log(s) in backup set input archived log thread=1 sequence=1 RECID=1 STAMP=1046252355 input archived log thread=1 sequence=2 RECID=2 STAMP=1046301412 input archived log thread=1 sequence=3 RECID=3 STAMP=1046461507 input archived log thread=1 sequence=4 RECID=4 STAMP=1046461507 channel c1: starting piece 1 at 22-JUL-20 channel c1: finished piece 1 at 22-JUL-20 piece handle=0bv5vf23_1_1 tag=TAG20200722T194507 comment=API Version 2.0,MMS Version 19.0.0.1 channel c1: backup set complete, elapsed time: 00:01:53 Finished backup at 22-JUL-20
Starting Control File and SPFILE Autobackup at 22-JUL-20 piece handle=c-1473061046-20200722-01 comment=API Version 2.0,MMS Version 19.0.0.1 Finished Control File and SPFILE Autobackup at 22-JUL-20 released channel: c1
