Posts by Hariprasath Rajaram

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

Oracle Always Free cloud services

Databases Our choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage. Note:-We need choose Always free while database configuration…

Read More