Saturday, December 12, 2020

Pluggable database open and save

# check sga_max_size --size  

# if sga less than 3000m then increase it between 4000-5000m

  SHOW PARAMETER SGA;

  ALTER SYSTEM SET MEMORY_TARGET =5000M SCOPE=SPFILE      

# now shutdown, start & check  

SHUT IMMEDIATE  

STATUP

# check sga_max_size --size

SHOW PARAMETER SGA;

# check pluggable database 

select name,open_mode from v$pdbs;

# if it is mounted then open it 

ALTER PLUGGABLE DATABASE ORCLPDB OPEN;

# orclpdb is pluggable database this command for running database then pluggable database will start automatically

ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE;







No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...