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

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...