Database Blog

Oracle 18c-RPM Based Installation

yum 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 More

oracle 18c new features

Snapshot 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 More

oracle 18c-Private temporary tables

Oracle 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 More

oracle 18c-Read-only Oracle Home

The 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 More

Oracle 18c-Checklist for upgrade

Oracle 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 More

oracle 18c-Password file location

The 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 More

oracle 18c-SQL Cancel

In 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 More

ERRORMSG: appsborg2.zip not found after upgrade of iAS_ORACLE_HOME in Oracle EBS R12.1.3

  Introduction : AutoConfig is a configuration tool that does the automation and the configuration of an Oracle E-Business Suite instance. The data required for configuring an Applications system is…

Read More

How to recover WebLogic Credentials

  Introduction : Oracle WebLogic Server 12c R2 is one of industry’s noteable application servers for building and deploying enterprise Java EE applications with support for all the latest features…

Read More

Steps to recover a corrupted datafile on the standby database

  Introduction : There was an issue faced recently on one of the dataguard environments. One of the file systems(/u05/PROD/) in the dataguard environment got corrupted. Any files added to…

Read More