ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded – It’s typical error encountered in Oracle database. It happens when too much cursors are opened on an oracle instance. Maximum number of opened cursors…
Read MoreORA-00845: MEMORY_TARGET not supported on this system
Modify the entry in “/etc/fstab” to have persistent settings between reboot of your machine. Here shared segments are set to 3500M. tmpfs /dev/shm tmpfs size=3500M 0 0 remount it mount…
Read MoreOracle 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 Moreoracle 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 Moreoracle 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 Moreoracle 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 MoreOracle 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 Moreoracle 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 Moreoracle 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 MoreERRORMSG: 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