mrculp | IT Remote


# Script Name..: restart_weblogic.ksh
# Description..: Checks if weblogic process is running, if no start it
# Author.......: Susheel Tamrakar
# Date.........: April 2016
# Version......: v.01
# Modified By..: Susheel T.
# Date Modified:
# Comments.....:

############################################################################
#set -xv
############################################################################
# Apex server -  lkcme179.kcm-p01.chp.bankofamerica.com
# lkcme179.kcm-p01.chp.bankofamerica.com = New APEX server (version 5 using weblogic 12c)
# Oracle user -         DBADMD01
# important files
# /var/opt/oracle/wls.env - contains environment variables for wls home and sample syntax
# /var/opt/oracle/start_weblogic.sh - starts weblogic server
# /var/opt/oracle/stop_weblogic.sh - stops weblogic server
# /var/opt/oracle/restart_weblogic.sh - restarts weblogic server
############################################################################
echo "##################################################################"
echo "# Welogic server process check                                    "
echo "##################################################################"
# check if weblogic process is running
if [ "$(ps -ef|grep weblogic| grep -v 'grep' |grep -v 'restart'| wc -l)" -gt 0 ] ; then
echo "Weblogic application server process is running"
echo " "
echo " "
echo " "

else
echo "Weblogic application server process is NOT running.....STARTING now and sleeping for 1 minute"
echo " "
echo " "
echo " "

/var/opt/oracle/start_weblogic.sh
sleep 1m
echo "Weblogic application server started, check process below..."
echo " "
echo " "
echo " "

echo "$(ps -ef|grep weblogic| grep -v 'grep'|grep -v 'restart')"
fi

Optimizing Performance Chpt 14

This is part of the Oracle documentation

This section deals with the SDU and why it is important to resize this to maximize performance in a situation where network performance is critical

Result Cache Oracle Article

Tuning Result Set

Result Cache Set Presentation

Result Cache Article 2

Result Cache vs. Times 10

Occasionally you may the opportunity to setup GoldenGate in a remote environment for both capture and delivery.

AirCRM

HeloTrak

You must have a login to this system in order to use it, please contact mike.culp@gmail.com in order to obtain access.

Ask Tom pipe

EXPORT AND IMPORT USING UNIX PIPES.

Sometimes, the space on disk may not be enough to hold a full export dump if uncompressed.

EXAMPLE – export schema MCULP from PROD database and import into DEV database.

To avoid space running out, unix pipes and compression can be used.
EXPORT IN PROD DATABASE

cd /u02/oradata/export

CREATE UNIX PIPE IN THIS AREA – WHERE THE EXPORT DUMP WILL BE WRITTEN TO.

mknod pipe p

CREATE PAR FILE –

parfile is mculp.par

vi mculp.par

buffer=2097152
recordlength=65535
consistent=y
owner=mculp
log=/u02/oradata/export/mculp.log
file=/u02/oradata/export/pipe

Now export schema MCULP.

1. nohup gzip -c </u02/oradata/export/pipe > /u02/oradata/export/mculp.dmp.gz &

Immediately enter next command –

2. nohup exp \’/ as sysdba\’ parfile=/u02/oradata/export/mculp.par &

Export of MCULP schema completes – compressed dump mculp.dmp.gz created.

ftp or copy the dump file mculp.dmp.gz to the DEV database box.

IMPORT IN DEV DATABASE – – Presume same directory structure exists on DEV box.

Create UNIX PIPE in area where dump is copied to in DEV box.

cd /u02/oradata/export

mknod import_pipe p

Create import parfile – called imp.par

vi imp.par

fromuser=mculp
touser=mculp
commit=y
buffer=2097152
ignore=y
file=/u02/oradata/export/import_pipe
log=/u02/oradata/export//imp_mculp.log

Enter commands –

1. nohup gzip -dc </u02/oradata/export/mculp.dmp.gz > import_pipe &

Immediately enter next command –

2. nohup imp \’/ as sysdba\’ parfile=/u02/oradata/export/imp.par

Check the logs for output of import.

cd $BACKUP_DIR
if [ ! -p $PIPE ]; then

mkfifo $PIPE
fi

echo "gzipping from $PIPE ..."
nohup gzip -c < $PIPE > ${DMPFILE}.gz &

echo "expdp started ..."
expdp $CREDENTIALS \

DIRECTORY=DP_EXP_DIR \
DUMPFILE=$PIPE \
FULL=y \
LOGFILE=$LOGFILE

Oracle Apex

Oracle Cloud

Oracle Cloud Schema Dev environment

create or replace trigger "T_HLO_ENT_TP_LOOKUP" before insert or update on "HLO_ENT_TP_LOOKUP" for each row begin if inserting and :new."HLO_ENT_TP_ID" is null then
for c1 in (select "HLO_ENT_TP_LOOKUP_SEQ".nextval nv from dual) loop
:new."HLO_ENT_TP_ID" := c1.nv; end loop; end if; end;

create or replace TRIGGER "HC_DATABASE_TRIG"
BEFORE INSERT ON MRCULP.HC_DATABASE FOR EACH ROW
BEGIN
SELECT hc_database_seq.NEXTVAL
INTO :new.db_id
FROM dual;
END;

CREATE SEQUENCE "HLO_ENT_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 5 NOCACHE NOORDER NOCYCLE NOPARTITION
/

ITRemote

Ready for Action?