Report server create 12c

 ./wlst.sh
wlst> connect('weblogic','weblogic123', 'http://localhost:7001')
createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine')

 

 vi /u02/app/middleware/user_projects/domains/DEV_domain/config/fmwconfig/servers/WLS_REPORTS1/applications/reports_12.2.1/configuration/rwservlet.properties

 

   <server>rep_wls_reports_alamin</server>

   <singlesignon>yes</singlesignon>

   <inprocess>yes</inprocess>

   <webcommandaccess>L2</webcommandaccess>

 

createReportsServerInstance(instanceName='my_repsrv',machine=’AdminServerMachine')

 

 

vi /u02/app/middleware/user_projects/domains/DEV_domain/config/fmwconfig/components/ReportsServerComponent/my_repsrv/rwserver.conf

    Change:  <!--job jobType="report" engineId="rwEng" securityId="rwJaznSec"/-->

    To:      <job jobType="report" engineId="rwEng"/>

 

cd /u02/app/middleware/user_projects/domains/base_domain/bin

    ./startComponent.sh my_repsrv storeUserConfig

export DOMAIN_HOME=$ORACLE_BASE/config/domains/base_domain
mkdir -p $DOMAIN_HOME/servers/AdminServer/security
echo "username=weblogic" > $DOMAIN_HOME/servers/AdminServer/security/boot.properties
echo "password=weblogic123" >> $DOMAIN_HOME/servers/AdminServer/security/boot.properties
mkdir -p $DOMAIN_HOME/servers/WLS_FORMS/security
cp $DOMAIN_HOME/servers/AdminServer/security/boot.properties $DOMAIN_HOME/servers/WLS_FORMS/security/boot.properties
mkdir -p $DOMAIN_HOME/servers/WLS_REPORTS/security
cp $DOMAIN_HOME/servers/AdminServer/security/boot.properties $DOMAIN_HOME/servers/WLS_REPORTS/security/boot.properties
Standalone Report server 11g
./opmnctl createcomponent -adminUsername weblogic -adminHost alamin -adminPort 7004 -oracleHome /u01/app/oracle/middleware/Oracle_FRHome1 
-oracleInstance /u01/app/oracle/middleware/asinst_1 -instanceName asinst_1 -componentName rep_svr -componentType ReportsServerComponent


./opmnctl startproc ias-component=rep_svr
export MW_HOME=/u01/app/oracle/middleware
export WLS_HOME=$MW_HOME/wlserver_10.3
export WL_HOME=$WLS_HOME
export ORACLE_HOME=$MW_HOME/Oracle_FRHome1
export ORACLE_INSTANCE=$MW_HOME/asinst_1
export FR_HOME=$ORACLE_HOME
export FR_INST=$ORACLE_INSTANCE
export DOMAIN_HOME=$MW_HOME/user_projects/domains/ClassicDomain
export JAVA_HOME=/u01/app/oracle/jdk1.7.0_80
export PATH=$ORACLE_INSTANCE/bin:$ORACLE_HOME/bin:$JAVA_HOME/bin:$PATH:/usr/lib64

# Forms compilation
export PATH=.:$FR_HOME/bin:$FR_HOME/forms/mesg:$PATH:/usr/lib64
#export LD_LIBRARY_PATH=$FR_HOME/jdk/jre/lib/amd64/native_threads:$FR_HOME/jdk/jre/lib/amd64:$FR_HOME/lib:$FR_HOME/jdk/jre/lib/amd64/server
export LD_LIBRARY_PATH=/usr/lib/x86_64-linux-gnu/:$LD_LIBRARY_PATH:/usr/lib64
export FORMS_BUILDER_CLASSPATH=$FR_HOME/jlib/
export FORMS_PATH=/u01/app/oracle/middleware/Oracle_FRHome1/forms
export REPORTS_PATH=/u01/app/oracle/middleware/Oracle_FRHome1/reports
export TWO_TASK=ORCL
export TNS_ADMIN=$FR_HOME/network/admin
export TERM=vt220
export ORACLE_TERM=$TERM

# Reports server: Adjust as required to allow forms to get the reports server name
# using "tool_env.getvar('REPORTS_SERVER_NAME', v_rep_server);"
#export REPORTS_SERVER_NAME=rep_wls_reports_ol6-forms_asinst_1

Report Server Creation 11g

opmnctl deletecomponent -adminUsername weblogic -adminPasswordFile weblogic123 
-adminHost 192.168.1.8 -adminPort 7001 -oracleHome D:\Middleware\Oracle_FRHome1 
-oracleInstance D:\Middleware\asinst_1 -instanceName asinst_1 
-componentName RptSvr_WIN-RSERQU3GP5N_asinst_ -componentType ReportsServerComponent

opmnctl createcomponent -adminUsername weblogic -adminPasswordFile weblogic123 
-adminHost 192.168.1.8 -adminPort 7001 -oracleHome D:\Middleware\Oracle_FRHome1 
-oracleInstance D:\Middleware\asinst_1 -instanceName asinst_1 
-componentName report_server -componentType ReportsServerComponent

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();