Java SE Installation for ORMB

Installing software into a directory that include spaces in the path name (e.g. C:\Program Files\) might cause issues for some vendor applications.

Purpose

To install the Java SE JDK 1.8 as a prerequisite for deploying ORMB 2.5.0.1.

Download Java

Download required JDK 1.8 binary (  jdk-8u112-windows-x64.exe )  here.

Install Java

It is strongly advised to choose an installation directory that does not include spaces in the path name (e.g., do NOT install in C:\Program Files\). Some software will throw exceptions that depend on the value of JAVA_HOME, which either includes a space,or defines as “C:\Progra~1\”. 

  • Run  jdk-8u112-windows-x64.exe.
  • Change the installation directory to a path with no spaces in it, such as D:\jdk1.8.
  • All other installation defaults are accepted.
  • When the installer gets to the stage of installing the J2SE Runtime Environment, it is fine to accept the default, e.g., C:\Program Files\Java.
  • Add Java’s bin directory (e.g.,  D:\jdk1.8\bin) to your PATH environment.
  • Set JAVA_HOME (  e.g., D:\jdk1.8 ).

How to Open PDBs Automatically After CDB Opened

To open pdbs automatically, for 12.1.0.1, write a database startup trigger. for 12.1.0.2 onwards, open pdbs first, then save the pdbs state.

1) For 12.1.0.1, create a trigger to startup PDBs while CBD is up running.

CREATE OR REPLACE TRIGGER auto_open_pdbs 
  AFTER STARTUP ON DATABASE 
BEGIN 
   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; 
END auto_open_pdbs;
/

2) For 12.1.0.2 onwards including 12.1.0.2, 12.2.0.1, 18c, 19c,and 20c ….

Run below command to open pluggable database, and save the state of PDBs.

ALTER PLUGGABLE DATABASE pdb1 OPEN;
ALTER PLUGGABLE DATABASE pdb1 SAVE STATE;

Check the saved state of containers :

SELECT con_name, instance_name, state FROM dba_pdb_saved_states;

CON_NAME             INSTANCE_NAME        STATE
-------------------- -------------------- --------------
PDB1                 cdb1                 OPEN

SELECT name, open_mode FROM v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           READ WRITE

Shutdown and startup database, the PDB starts up automatically.

shutdown immediate;
startup;

SELECT name, open_mode FROM v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           READ WRITE