Enabling sql trace in OC4J & system wide

http://rreddy.blogspot.com/2006/09/enabling-sql-trace-in-oc4j.html

Select SID,SERIAL#,USERNAME,STATUS from v$session;

::Session level tracing::

exec dbms_system.set_ev( 375,501,10046,12.' ');
execute sys.dbms_system.set_ev(375,501, 10046, 12, '');
execute sys.dbms_system.set_ev(375,501, 10046, 0, '');

::System Wide SQL Tracing::

alter system set events '10046 trace name context forever,level 12';
alter system set events '10046 trace name context off';

For SYSTEM WIDE use this url:

http://www.orafaq.com/wiki/SQL_Trace

How to use TAR for backup [Oracle_Home]

NAME
tar - The GNU version of the tar archiving utility

SYNOPSIS
tar [ - ] A --catenate --concatenate | c --create | d --diff --compare
| --delete | r --append | t --list | u --update | x --extract --get [
options ] pathname [ pathname ... ]

DESCRIPTION
This manual page documents the GNU version of tar , an archiving pro-
gram designed to store and extract files from an archive file known as
a tarfile. A tarfile may be made on a tape drive, however, it is also
common to write a tarfile to a normal file. The first argument to tar
must be one of the options: Acdrtux, followed by any optional func-
tions. The final arguments to tar are the names of the files or direc-
tories which should be archived. The use of a directory name always
implies that the subdirectories below should be included in the
archive.

EXAMPLES
tar -xvvf foo.tar
extract foo.tar

tar -xvvzf foo.tar.gz
extract gzipped foo.tar.gz

tar -cvvf foo.tar foo/
tar contents of folder foo in foo.tar

For more:
http://unixhelp.ed.ac.uk/CGI/man-cgi?tar

Create users.ldif using script for ocs.

i=102
while [ $i -lt 503 ]
do
echo "dn: cn=user$i,cn=Users,dc=idc,dc=oracle,dc=com" >> r.ldif
echo "objectclass: top" >> r.ldif
echo "objectclass: person" >> r.ldif
echo "objectclass: inetorgperson" >> r.ldif
echo "objectclass: organizationalperson" >> r.ldif
echo "objectclass: orcluser" >> r.ldif
echo "objectclass: orcluserv2" >> r.ldif
echo "cn: user$i" >> r.ldif
echo "givenname:" user$i >> r.ldif
echo "sn: user$i" >> r.ldif
echo "mail: user$i@bde.idc.oracle.com" >> r.ldif
echo "uid: user$i" >> r.ldif
echo "userpassword: welcome1" >> r.ldif
echo >> r.ldif
i=`expr $i + 1`
done