Translate this Page


In This Challenge, We have a Linux 32bit Server (RHEL 4) with 8GB Memory. But we can’t configure the database memory (SGA+PGA) more than 4GB.  To solve this problem then we could configure Very Large Memory (VLM) and Big SGA for Oracle RDBMS with ramfs and Hugepages.

Complete the following procedure to configure VLM on the computer:

1. Log in as a root user:

2. Edit the /etc/rc.local file and add the following entries to it to configure the computer to mount ramfs over the /dev/shm directory, whenever you start the computer: Continue reading »


When we did a cloning/recover the database with noarchivelog mode, we got the problem that some datafile need to be recover. It will be difficulty since no archivelog that can help us to recover it. Otherwise we can copy all datafiles from offline backup of the source database. But it will takes time to copy/ftp/restore especially if the database size are hundreds GB or even TB. But there is a solution to recover the database with noarchivelog mode, please check this out : 
When we did a cloning, startup nomount :           

$ sqlplus '/as sysdba' 
SQL*Plus: Release - Production on Tue Apr 13 13:54:43 2010 
Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 
Connected to an idle instance. 
SQL> startup nomount pfile=initMYDB.ora
ORACLE instance started. 
Total System Global Area 5251268608 bytes
Fixed Size 2091368 bytes
Variable Size 1040189080 bytes
Database Buffers 4194304000 bytes
Redo Buffers 14684160 bytes 

First, there are something that we need to know why Oracle Recommend to using SUN JRE/Java Plug-In (JPI) rather than Oracle Jinitiator in the future.

1- Current Oracle Jinitator built using SUN JDK 1.3.1, SUN already completed end of life process for version 1.3.1 and no plan to evolve Jinitiator into a JDK 1.4 or latest release.

2- Jinitiator is NOT supported for use on MS Vista or newer operating systems.

3- Jinitiator will NOT be supported for use with Forms releases newer than

Continue reading »


In this article, I will share how to migration Oracle 10g DB From Linux 32bit to Linux 64bit. since both Linux 32bit and Linux 64bit have same Endian format, then at this time we only change the word size.
In the source environment :
- OS : Redhat AS 4.5 32bit
- DB : Oracle Database SE

In the destination environment :
- OS : Redhat AP 5.3 64bit
- DB : Oracle Database SE Continue reading »


There are 2 methods to move the data files of the tablespace to other location.

1 . When Database is Up (for some tablespace or datafile)

To move or rename the Data File  when database is up we should take the related tablespaces (eg. TESTD) offline, at this status we can’t do DML or SELECT to all objects that stored in that tablespace.

ATTENTION: You can use this way if the datafile that need to be changed or moved is not belong to SYSTEM tablespaces, and not contain active rollback segments or temporary segments.

  • Take the Tablespace Offline
    • [oracle@levicorp ~] sqlplus ‘/as sysdba’
    • SQL > ALTER TABLEPSPACE testd OFFLINE; Continue reading »

To Extend Logical Volume :
Scenario :
Increase size of /backup to 90GB

$ df -H
 Filesystem              Size   Used  Avail Use% Mounted on
 /dev/mapper/vg00-lvol01 6.3G   187M   5.8G   4% /
 /dev/mapper/vg01-lvol02 8.3G   3.0G   5.0G  38% /archive
 /dev/mapper/vg01-lvol03  83G    11G    69G  13% /backup

Continue reading »


Sometime we need to move Temporary Files to other location. This steps will guide you how to do that easily and safety ;)

1. Login as SYSDBA
2. Check the Tempfile status

SQL> SELECT v.file#, t.file_name, v.status
 2  FROM dba_temp_files t, v$tempfile v
 3  WHERE t.file_id = v.file#;

 FILE#     FILE_NAME                 STATUS
---------- ------------------------- -------
 1         /u01/temp01.dbf           ONLINE
 2         /u02/temp02.dbf           ONLINE
 3         /u02/temp03.dbf           ONLINE

3. Make OFFLINE the tempfile that need to move Continue reading »


After we assigning some responsibilities to a user in Oracle E-Business Suite. Unfortunately when user login to the system, he can’t found the responsibilities that he want in the web navigator. This problem usually happen after upgrading or patching.

To solve this problem :

1. Set the role_end_date to null in the wf_local_user_roles.
The sql used will depend on the responsibility missing. For example for the System Administrator responsibility, type in the following:

UPDATE wf_local_user_roles
 SET role_end_date = NULL

Continue reading »


If we using Storage Area Network (SAN) with FC,  SAN can do scanning  all connected FC in the SAN Switch. From SAN storage we can get the World Wide Name (WWN) of the HBA –each HBA has unique WWN (same as MAC Address in the PC), but if there are many servers connected the FC into the same SAN Switch, might be we can get difficulties which server has particular WWN.

In this topic I only discuss how to know the WWN of the HBA in HP-UX server. Continue reading »


To monitor event in HP-UX server, first we must install and running Event Monitoring Services(EMS). After that we can use monconfig (a utility that allows a superuser to manage hardware event monitor requests for EMS).

In this working note, I will show you the example steps through creating a monitor request and sending any alerts that are greater than or equal to (>=) “Major Warnings” to an EMAIL address Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha