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

Auto mail attachment

<pluginParam name="mailServer">mail.***.com:25</pluginParam>

 

 

E:\DevSuiteHome_1\BIN\rwrun report=E:\DevSuiteHome_1\BIN\Buyer_Wise_Shipment_Summary_Report.RDF userid=labserp/***@dba desformat=pdf destype=mail DESNAME="masumbillah@lantaburgroup.com,ahasan@lantaburgroup.com,delowar@lantaburgroup.com,sakhawat@lantaburgroup.com" CC="mdalamin@lantaburgroup.com" from="ERP@lantaburgroup.com" SUBJECT="Shipment Status"

Form Builder 12c linux

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

export ORACLE_BASE=/u01/app/oracle

export MW_HOME=$ORACLE_BASE/product/12.2.1

export ORACLE_HOME=$MW_HOME

export WLS_HOME=$MW_HOME/wlserver

export WL_HOME=$WLS_HOME

export FR_HOME=$ORACLE_HOME

export ORACLE_INSTANCE=$DOMAIN_HOME/config/fmwconfig/components/FORMS/instances/

forms1

export FR_INST=$ORACLE_INSTANCE

export DOMAIN_HOME=$ORACLE_BASE/config/domains/mydomain

export JAVA_HOME=$ORACLE_BASE/jdk1.8.0_301

#export OHS_INST=$DOMAIN_HOME/config/fmwconfig/components/OHS/instances/ohs1

# Forms compilation

export PATH=.:$FR_HOME/bin:$FR_HOME/forms/mesg:$PATH:$ORACLE_INSTANCE/bin

export LD_LIBRARY_PATH=$FR_HOME/oracle_common/lib/amd64:$FR_HOME/lib:$FR_HOME/

oracle_common/lib:$FR_HOME/oracle_common/jdk/lib/amd64/server

#:$FR_HOME/lib/stubs

export FORMS_BUILDER_CLASSPATH=$FR_HOME/jlib/

export FORMS_PATH=/u01/app/oracle/product/12.2.1/forms

#export REPORTS_PATH=

#export TWO_TASK=ORCL

export TNS_ADMIN=$DOMAIN_HOME/config/fmwconfig/

export TERM=vt220

export ORACLE_TERM=$TERM

Random Value

 select dbms_random.value(1,10)original_value,
ceil(dbms_random.value(1,10))ceil_valie,
round(dbms_random.value(1,10))round_value,
floor(dbms_random.value(1,10))floor_value
 from dual
/

DECLARE
A NUMBER;
BEGIN
FOR I IN 1 .. 10 LOOP
DBMS_RANDOM.SEED('TEST2');
A:=ROUND(dbms_random.VALUE(1,1000),0);
DBMS_OUTPUT.PUT_LINE(A+I);
END LOOP;
END;

Connection String Dot Net

 String conString = "Data Source = localhost:1521 / orcl; User Id =labs;Password = labs;";
            OracleConnection con = new OracleConnection(conString);
            con.Open();
            
            OracleCommand cmd = new OracleCommand("insert into TEST_APEX(NAME,GENDER,CONTACT,EMAIL,CITY,COUNTRY) values('" + Name.Text+ "'," + "'" + Gender.SelectedValue + "'," + "'" + Contact.Text + "',"+"'" + Email.Text + "'," + "'" + City.Text + "'," + "'" + Country.Text + "')", con);

            cmd.ExecuteNonQuery();
            Name.Text="";
            Gender.SelectedValue = "";
            Contact.Text = "";
            Email.Text = "";
            City.Text = "";
            Country.Text = "";
            Response.Write("Employee inserted sucessfully.<br />");
            con.Close();

Manual Waiting in Loop

 begin
for i in 1 .. 1
loop
dbms_output.put_line(to_char(sysdate, 'mi:ss'));
dbms_lock.sleep(.5);
end loop;
end;
/