Automatic PDB Opening in your Multitenant Container Oracle Database

1.. login as SYSDBA to root container 1.1 Execute show pdbs and check status of pdbs show pdbs 2.. start your any of pluggable database. alter pluggable database PDB1 open; or alter pluggable database all open; 2.1 Check the status of PDB1. i.e execute show pdbs 3.. Save the current state of your PDBs. i.e … Continue reading Automatic PDB Opening in your Multitenant Container Oracle Database

Starting up your Multitenant Containerized Oracle Database

1.. SHUTDOWN: - Oracle Database is not running 2.. NOMOUNT: - Instance is started Note:- The instance is started exactly the same way as for non-CDB database, using a STARTUP NOMOUNT and doing so need to be connected to the CDB root as SYSDBA to start the instance up. 3.. MOUNT: - Control files are … Continue reading Starting up your Multitenant Containerized Oracle Database

Undo Modes in 12.2.X Multitenant Oracle Databases – Local and Shared Modes

From 12cR2 onwards, the local Undo was introduced. When local undo is enabled, each container has its own undo tablespace for every instance in which it is open. When local undo is disabled, there is one undo tablespace for the entire CDB.The Undo mode, whether it’s local or shared, is the property of the entire … Continue reading Undo Modes in 12.2.X Multitenant Oracle Databases – Local and Shared Modes

Few scripts for Your Oracle Database …..

SQL> select sum(bytes)/1024/1024/1024 "SIZE_GB_TOTAL" from dba_data_files; SIZE_GB_TOTAL 2671.33588 SQL> select sum(bytes)/1024/1024/1024 "SIZE_GB_ACTUAL" from dba_segments; SIZE_GB_ACTUAL 2084.6367 SQL> select sum(bytes)/1024/1024/1024 "SIZE_GB_FREE" from dba_free_space; SIZE_GB_FREE 585.972672 Note :- dba_free_space:- describes the free extents in all tablespaces in the database. dba_segments :- describes the storage allocated for all segments in the database. dba_data_files :- describes database files which … Continue reading Few scripts for Your Oracle Database …..

Workflow Background Process Concurrent Program

Workflow Background Process is a concurrent program which runs for processing deferred activities, timed out activities, and stuck processes using the parameters given. The background engine executes all activities that satisfy the given arguments at the time that the background engine is invoked. Workflow Background Process is run with the help of Workflow Background Engine … Continue reading Workflow Background Process Concurrent Program

Using Java Web Start with Oracle E-Business Suite

Java Web Start is a browser-independent architecture for deploying Java technology-based applications to the client desktop. With Java Web Start users can launch a Java application by clicking a link in a web page where the link points to a Java Network Launch Protocol (JNLP) file and instructs Java Web Start software to download, cache … Continue reading Using Java Web Start with Oracle E-Business Suite

Oracle E-Business Suite Technology Code level Checker Patch 17537119

This patch provides two scripts, referred as ETCC, which helps to ensure that required database and middle tier bugfixes are installed for Oracle E-Business Suite Release 12.2 system. The scripts are as follows:- checkDBpatch.sh (checkDBpatch.cmd on Windows):- This is the Database EBS Technology Codelevel Checker (DB-ETCC), which determines if all the needed bugfixes exist in … Continue reading Oracle E-Business Suite Technology Code level Checker Patch 17537119

Oracle E-Business Suite R12.2.X file System Layout

Oracle E-Business Suite R12.2.X uses dual file system to support online patching for e.g fs1 ( as Prodcution file system)fs2 ( as copy of prodcution file system)fs_ne ( as non-editioned file system) Note :- At given time one file system act as run file edition where as anoter file system act as patch file edition … Continue reading Oracle E-Business Suite R12.2.X file System Layout

Clearing and Compiling JSP file manually in Oracle E-Business Suite R12

1.. login to application server and shutdown application services 2.. Naviagate to COMMON_TOP as cd $COMMON_TOP 2.1.. Do ls -al and remove the _pages directory 2.2.. mkdir _pages Note :- You can also take a backup of this file also 3.. Now navigate to either navigate to $FND_TOP/patch/115/bin or use given below scripts to compile … Continue reading Clearing and Compiling JSP file manually in Oracle E-Business Suite R12

Dual file system in Oracle E-Business Suite R12.2.X

Oracle E-Business Suite R12.2.X uses a dual file system and non-editioned file system. Where at given time one file system is designated as run and other is designated as patch file system. To determine which file system you are currently on you can use echo $FILE_EDITION as well.   Whereas run file system fs1 is … Continue reading Dual file system in Oracle E-Business Suite R12.2.X