Check the count of sql baselines to be exported:- select count(*) from dba_sql_plan_baselines; 725 Create a user with which the base should be exported:- create user sqbl identified by “#####”;…
Read Moreyum localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm Loaded plugins: langpacks, ulninfo Examining oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-18c-1.0-1.el7.x86_64 Marking oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm to be installed Resolving Dependencies –> Running transaction check —> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 will be installed –> Processing…
Read MoreSnapshot Carousel This is a repository for periodic point-in-time copies of a PDB. The Snapshot Carousel is ideally suited to development environments that typically require multiple copies of databases at different…
Read MoreOracle Database 18c introduces the concept of a private temporary table—a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup. In…
Read MoreThe new password file location enables you to mount one shared read-only Oracle Home on different systems, making deployment for complex architectures more reliable and simpler. In other words, a…
Read MoreOracle 18c – Complete checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1.x.x to 18.x.x.x (Doc ID 2422161.1) Oracle DB 18c – Complete Checklist for Manual Upgrades to…
Read MoreThe default location for the Oracle Database 18c password file is now ORACLE_BASE instead of ORACLE_HOME/dbs. This change enables you to use Oracle Home as a static repository for database…
Read MoreIn past versions of Oracle whenever a database administrator needed to cancel a SQL query, the session that was running the SQL had to be killed. This meant the session…
Read MoreIntroduction : The Goldengate Manager is the first process that needs to be setup in the replication configuration. This process must be running on the source and the target system.…
Read MoreError while upgrading the database from 11.2.0.4 to 19.3.0.0:- REASON: ERRORS FOUND: During Upgrade FILENAME: /u01/app/oracle/product/19c/cfgtoollogs/test19C/upgrade20200127132925/catupgrd0.log AT LINE NUMBER: 801192 —————————————————— Identifier CATJAVA 20-01-27 02:09:14 SCRIPT = [/u01/app/oracle/product/19c/rdbms/admin/initjms.sql] ERROR =…
Read More