বুধবার, ১৭ নভেম্বর, ২০২১

Database with ASM

 

yum -y install oracle-database-server-12cR2-preinstall

yum -y install oracleasm*

yum -y install kmod-oracleasm*

 

groupadd -g 54327 asmdba

groupadd -g 54328 asmoper

groupadd -g 54329 asmadmin

 

usermod -a -G asmdba oracle

 

useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid

 

passwd oracle

passwe grid

 

 

oracleasm configure -i

oracleasm init

 

init 0 (For restart)

 

oracleasm createdisk CRS1 /dev/sdb1

oracleasm createdisk DATA1 /dev/sdb2

oracleasm createdisk FRA1 /dev/sdb3

 

Creating directory for oracle database installation

mkdir -p /u01/app/oracle

mkdir -p /u01/app/oracle/product/12.2.0/db_home

chown -R oracle:oinstall /u01

 

Creating directory for grid installation

mkdir -p /u01/app/grid

mkdir -p /u01/app/grid/12.2.0/db_home

chown -R grid:oinstall /u01/app/grid

chmod -R 775 /u01

 

Grid bash_profile

 

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

ORACLE_SID=+ASM; export ORACLE_SID

ORACLE_BASE=/u01/app/grid; export ORACLE_BASE

ORACLE_HOME=/u01/app/grid/12.2.0/db_home; export ORACLE_HOME

ORACLE_TERM=xterm; export ORACLE_TERM

JAVA_HOME=/usr/bin/java; export JAVA_HOME

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

 

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/local/bin

export PATH

 

umask 022

 

 

. .bash_profile

 

 

cd $ORACLE_HOME

unzip linuxx64_12201_grid_home.zip

 

 

./gridSetup.sh

 

 

 

bash profile for database

 

 

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

ORACLE_HOSTNAME=alamin; export ORACLE_HOSTNAME

ORACLE_SID=orcl; export ORACLE_SID

ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_home; export ORACLE_HOME

ORACLE_TERM=xterm; export ORACLE_TERM

 

JAVA_HOME=/usr/bin/java; export JAVA_HOME

NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/local/bin

export PATH

 

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

export LD_LIBRARY_PATH

 

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

export CLASSPATH

 

TEMP=/tmp ;export TMP

TMPDIR=$tmp ; export TMPDIR

 

umask 022

মঙ্গলবার, ৯ নভেম্বর, ২০২১

Apex

 Application name=

&APP_USER. (in static)

APEX_CUSTOM_AUTH.GET_USER; (in PL/SQL)

APEX_APPLICATION.g_user; (in PL/SQL)

 

 Page ID=

v('APP_PAGE_ID')

APEX_APPLICATION.g_flow_step_id; (in PL/SQL)

APEX_APPLICATION.g_flow_owner; (in PL/SQL)

v('OWNER') (in PL/SQL)



Caused by: java.lang.OutOfMemoryError: Java heap space

export JAVA_OPTIONS=-Xmx512M 

JRE_MEMORY_OPTIONS=-mx128m