Friday, May 18, 2012

Adding swapfile on linux

Sometimes in the course of a system's existence you find that the swap partition you set up at install-time just isn't enough anymore. Maybe you're upgrading your system to RedHat 7.1 from a version of RedHat that used less swap in relation to physical RAM. Perhaps you're running Oracle. Or maybe you're adding more memory and would like to increase swap space accordingly.
Our machine srv-2 is swapping like mad and we just can't take it down right now to add more RAM. So to keep the machine from running out of memory entirely and freezing, we'll add 128 MB more swap space by creating a swap file.
First we check out the memory usage:

Command compress tar.gz

TAR.GZ

To create a tar.gz archive from a given folder you can use the following command
 tar -zcvf tar-archive-name.tar.gz source-folder-name
This will compress the contents of source-folder-name to a tar.gz archive named tar-archive-name.tar.gz
To extract a tar.gz compressed archive you can use the following command
tar -zxvf tar-archive-name.tar.gz
tar -czvf /u02/StageR12_64bit.tar.gz StageR12 1>list.log 0>error.log &



How to change hostname in Linux

  • Edit file /etc/sysconfig/network using your favourite editor. In my case is nano. So i’ll enter nano /etc/sysconfig/network
  • Look for HOSTNAME=xxxxxx
  • Change the xxxx to the name you wish to set for your computer. (ex: HOSTNAME=techiecorner.com)
  • Save the file and restart the xinetd service. (ex: type service xinetd restart in your shell)
  • Done! You have just changed your hostname in Linux platform

Thursday, May 17, 2012

11g Standby database creation without any RMAN backups


Quick steps to set up a 11g Standby database with Active Data Guard using the Active Duplication feature available in 11g where we can create a standby database without having to take a backup on the primary database. Datafiles are copied over the network.
Primary machine – OATU036
Standby machine – DROU036
Database Name – SID1O
TNS alias for Primary – sid1o_fc
TNS alias for standby – sid1o_js
Enable force logging on the Primary database
SQL> alter database force logging;
Database altered.
Create the Standby log files on the Primary database
Copy the password file from the $ORACLE_HOME/dbs directory on primary server to $ORACLE_HOME/dbs on the standby server
Update listener.ora on Standby machine

11g Passwords can be case sensitive


In 11g – Passwords are case sensitive but this can be controlled by an init.ora parameter -
SQL> show parameter SEC_CASE_SENSITIVE_LOGON ;
NAME TYPE VALUE
———————————— ———– ——————————
sec_case_sensitive_logon boolean TRUE
SQL> create user arjun identified by ARJUN; – Password in Upper Case.
User created.
SQL> grant create session to arjun;
Grant succeeded.
SQL> conn arjun/arjun; – Tried to connect with lower case password – FAILS.
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> exit


How to clone the Oracle database software


This note describes the process of cloning an Oracle Home - in this case we are cloning a 11g Release 2 Oracle Home from source machine devastator to target machine vixen.

On source (devastator)

ORACLE_HOME location is : /u01/app/oracle/product/11.2.0/dbhome_1

Go to directory on source machine one level higher and tar the db_home1 directory and all sub-directories


devastator:$ pwd

devastator:$ /u01/app/oracle/product/11.2.0  

devastator:$ tar -cvf 11gr2.tar dbhome_1

Rubah ip addres linux

Merubah IP Address dengan permanent
1. Ketikkan ’vi(spasi) /etc/sysconfig/network-scripts/ifcgf(spasi)eth0’
2. Lalu ubah IP Address , Netmask dan Broadcast sesuai dengan IP yang akan anda pakai.
3. Lalu restart “service network restart” enter
4. Lalu cek IP dengan mengetikan ‘ifconfig’

Kata-kata nya dalem banget

Yang indah hanya sementara,
Yang abadi adalah kenangan,
Yang ikhlas hanya dari hati,
Yang tulus hanya dari sanubari,
Tidak mudah mencari yang hilang,
Tidak mudah mengejar impian,
Namun yang lebih susah mempertahankan yang ada Karena walaupun tergenggam bisa terlepas juga Ingatlah pada pepatah, "Jika kamu tidak memiliki apa yang kamu
sukai, maka sukailah apa yang kamu miliki saat ini" Belajar menerima apa adanya dan berpikir positif....
Hidup bagaikan mimpi, seindah apapun begitu bangun semuanya sirna tak berbekas
Rumah mewah bagai istana,harta ,benda yang tak terhitung, kedudukan,dan jabatan yang luar biasa,
namun...
Ketika nafas terakhir tiba, sebatang jarum pun tak bisa dibawa pergi.
Sehelai benang pun tak bisa dimiliki
Apalagi yang mau diperebutkan
Apalagi yang mau disombongkan
Maka jalanilah hidup ini dengan keinsafan nurani
Jangan terlalu perhitungan
Jangan hanya mau menang sendiri
Jangan suka sakiti sesama apalagi terhadap mereka yang berjasa bagi kita
Belajarlah tiada hari tanpa kasih
Selalu berlapang dada dan mengalah
Hidup ceria, bebas leluasa...
Tak ada yang tak bisa diikhlaskan....
Tak ada sakit hati yang tak bisa dimaafkan
Tak ada dendam yang tak bisa terhapus..
Insya Allah..

Galau versi bruno mars-it will rain

if you ever leave me, baby,
leave some morphine at my door
cause it would take a whole lot of medication
to realize what we used to have,
we don't have it anymore.

there's no religion that could save me
no matter how long my knees are on the floor
so keep in mind all the sacrifices i'm making
will keep you by my side
and keep you from walking out the door.

cause there'll be no sunlight
if i lose you, baby
there'll be no clear skies
if i lose you, baby
just like the clouds
my eyes will do the same if you walk away
everyday, it'll rain, rain, rain

i'll never be your mother's favorite
your daddy can't even look me in the eye
oooo if i was in their shoes, i'd be doing the same thing
saying there goes my little girl
walkin' with that troublesome guy

but they're just afraid of something they can't understand
oooo but little darling watch me change their minds
yea for you i'll try i'll try i'll try i'll try
i'll pick up these broken pieces 'til i'm bleeding
if that'll make you mine

cause there'll be no sunlight
if i lose you, baby
there'll be no clear skies
if i lose you, baby
just like the clouds
my eyes will do the same if you walk away
everyday, it will rain, rain, rain

oh don't just say, goodbye
don't just say, goodbye
i'll pick up these broken pieces stil i'm bleeding
if that'll make it right

cause there'll be no sunlight
if i lose you, baby
and there'll be no clear skies
if i lose you, baby
and just like the clouds
my eyes will do the same if you walk away
everyday, it'll rain, rain, rain