Tags » Oracle

SOA Community Newsletter August 2014

Dear SOA & BPM Partner Community member,

Thanks to all Fusion Middleware Summer Camps 2014 attendees. If you couldn’t attend our trainings in Lisbon please make sure you attend one of our up-coming OFM 12c trainings. 152 more words

OPN

DBMS_OUTPUT WITHOUT NEW LINE

begin
 dbms_output.put('a');
 dbms_output.put('b');
 dbms_output.put('c');
 dbms_output.new_line;
end;
/
ORACLE

ORACLE EXPIRY & LOCK CHECK SCRIPT v1.2

#!/usr/bin/ksh
#####################################################
## oracle_exp_check.sh v1.2 #########################
## Mustafa DOGANAY - 2014 ## doganay.wordpress.com ##
#####################################################

MAILTO="to@mycompany.com"
MAILCC="cc@mycompany.com"
HOST=$(hostname)

IS_LOCKED=$(grep oracle /etc/shadow | grep "*LK*"|wc -l|awk '{print $NF}')

if [ ${IS_LOCKED} -ne 0 ]
then
 echo "oracle USER IS LOCKED."  | mailx -s $HOST" CHECK MAIL" -c $MAILCC $MAILTO
 exit 1
fi

export utime=$(date +%s)
export exptime=$(grep oracle /etc/shadow | awk -F":" '{print $8}')
export daytoexp=$(expr $exptime - $utime \/ 60 \/ 60 \/ 24 )

if [[ $daytoexp -le 10 ]]
then
 echo "$daytoexp days left to expire oracle user!!" | mailx -s $HOST" CHECK MAIL" -c $MAILCC $MAILTO
fi

exit 0
Oracle

Different methods to Lock or unlock SAP users

I want to lock all the users in SAP during MTP.  I know using SU10 we can do it. Any other alternative ways to lock the users. 560 more words

Oracle

What is MapReduce? & Role of MapReduce on Bigdata(With Hadoop)

  1. Introduction
  2. Goals for this Module
  3. Outline
  4. Prerequisites
  5. MapReduce Basics
    1. Functional Programming Concepts
    2. List Processing
    3. Mapping Lists
    4. Reducing Lists
    5. Putting them Together in MapReduce
    6. An Example Application: Word Count…
  6. 7,167 more words
Oracle

listing files with the external table preprocessor in 11g

listing files with the external table preprocessor in 11g

The external table preprocessor was introduced in 11g Release 1 (patchset 11.1.0.7) and formally documented in 11g Release 2. 2,682 more words

Oracle

Lupa Password Oracle sampai ke-lock, User Expired di Oracle XE, export/import dmp

Lupa Password Oracle

ada kawan yang lupa password system di oracle XE-nya sampai akhirnya accountnya ke-lock. cara recovernya pertama itu ganti passwordnya, caranya masuk ke terminal (windows pake cmd) trus ketik… 492 more words

Linux