REDO LOG SIZES FOR ORACLE ENTERPRISE MANAGER CLOUD CONTROL 13C

REDO LOG SIZES FOR ORACLE ENTERPRISE MANAGER CLOUD CONTROL 13C


There are two types of installations

1.     Simple Installation
2.     Advanced Installation


When we select Advanced Installation, we have an option to choose whether our installation can be small or medium  or large size  installation types

we can check the size of redo log files using


select min(bytes)/(1024*1024) size_in_mb from v$log;

the oracle recommended sizes for the redo logs is as follows

For simple installation, the redo log files size should be 300 MB or greater

 300 MB size for each log file member  for small
 600 MB size or greater for Medium
 1000 MB size or greater for Large 

How to create soft link with ln command in Linux or UNIX

How to create soft link with ln command in Linux or UNIX



Syntax:
ln -s Actual-filename-completepath  soft link-filename

Create:
cd desired-directory

ln -s /u01/oracle/product/12.1.0.2.0/dbhome_1/lib/libnnz12.so libnnz12.so
 

View soft link files:
cd desired-directory

ls -lrt | grep "^l"
 

Delete soft link:
cd desired-directory
unlink
or
rm

GoldenGate : ggsci: error while loading shared libraries in 12.1.2.1.1

GoldenGate : ggsci: error while loading shared libraries

Problem:
---------

./ggsci

./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory

Solutions:

cd OGG_HOME



 ln -s /u01/oracle/product/12.1.0.2.0/dbhome_1/lib/libnnz12.so libnnz12.so

 ln -s /u01/oracle/product/12.1.0.2.0/dbhome_1/lib/libclntsh.so libclntsh.so

 ln -s /u01/oracle/product/12.1.0.2.0/dbhome_1/lib/libons.so libons.so

 ln -s /u01/oracle/product/12.1.0.2.0/dbhome_1/lib/libclntshcore.so libclntshcore.so

 ln -s /u01/oracle/product/12.1.0.2.0/dbhome_1/lib/libclntshcore.a libclntshcore.a

      

ORACLE ENTERPRISE MANAGER CLOUD CONTROL 13C INITIALIZATION PARAMETERS SETTINGS

ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_FEATURES=FALSE SCOPE=BOTH;

ALTER SYSTEM SET PROCESSES=1000 SCOPE=SPFILE;

ALTER SYSTEM SET PGA_AGGREGATE_TARGET=4G SCOPE=BOTH;

ALTER SYSTEM SET SESSION_CACHED_CURSORS=500 SCOPE=SPFILE;

ALTER SYSTEM SET SGA_MAX_SIZE=10G SCOPE=SPFILE;

ALTER SYSTEM SET SGA_TARGET=10G SCOPE=SPFILE;

ALTER SYSTEM SET SHARED_POOL_SIZE=600M SCOPE=BOTH;

ALTER DATABASE ADD LOGFILE GROUP 16  '../../../../orcl/redo16.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 17  '../../../../orcl/redo17.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 18  '../../../../orcl/redo18.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 19  '../../../../orcl/redo19.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 20  '../../../../orcl/redo20.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 21  '../../../../orcl/redo21.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 22  '../../../../orcl/redo22.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 23  '../../../../orcl/redo23.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 24  '../../../../orcl/redo24.log' SIZE  600M

ALTER DATABASE ADD LOGFILE GROUP 25  '../../../../orcl/redo25.log' SIZE  600M

ALTER DATABASE DROP LOGFILE GROUP 1

ALTER DATABASE DROP LOGFILE GROUP 2

ALTER DATABASE DROP LOGFILE GROUP 3
 

alter system register;

alter system checkpoint;

alter system switch logfile;

alter pluggable database all close immediate;

shut immediate ;

startup;

alter pluggable database all open;

alter system register;

alter system switch logfile;