Translate this Page


Sometimes at the first installation, we don’t care about the size of UNDO Tablespace. We just create it with maximum extensible unlimited size. So there’s one big data file with a big I/O since write-read process only on that file. This article I wrote for give you a solution how to replace an UNDO Tablespace with a big datafile with a new UNDO Tablespace with several tiny datafiles.

  1. Check the UNDO setting in the database :
  2. SQL> show parameter undo
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- --------------------
    undo_management                      string      AUTO
    undo_retention                       integer     10800
    undo_tablespace                      string      UNDOTBS1

    Continue reading »


How To Create Physical Standby Database – Oracle10g
Primary :

  • Host : primsvr
  • ORACLE_SID : orcl
  • service names : primdb

Standby :

  • Host : stbysvr
  • ORACLE_SID : orcl
  • service names : stbydb

Steps to configure Oracle Data Guard :

Continue reading »


In Oracle DB World, sometime we need an interface to connect From Oracle DB to MySQL DB. Oracle have Heterogenous Service ODBC to help us to do this task. In this posting, I am using Linux Redhat, Oracle DB 10g and MySQL 4. Let’s play :

Part I: Setting up the ODBC driver
1. copy file mysql-connector-odbc-3.51.12-1.i586.rpm to Oracle DB server

2. install odbc for mysql.

rpm -i mysql-connector-odbc-3.51.12-1.i586.rpm

3. Edit the file /etc/odbc.ini
Add the Data Source of MySQL DB that we want to connect. I create data source named “trans”.

[ODBC Data Sources]
mysql = MyODBC 3.51 Driver DSN

Driver = /usr/lib/
Description = mysql connection to test
PORT = 3306
USER = root
Password = password
Database = Transaksi_DB

Continue reading »


This posting contains the issue that I got during the migration Oracle DB and Apps EBS  as we post in trilogy of migration part I, II and III. And how to solve the problem, hope this can help you.

Ø      FRM-92150 WEB Client Version too New

SOLUTION (NOTE: 788151.1) :

Cross check the version of forms server used from the forms server installed .  Use the cmd

f60gen|grep Forms|grep Version

The output is  Forms 6.0 (Form Compiler) Version 6.0.8.xx, if not same, re-apply patch for developer6i_patch19. And assure the user already have permission. After that relink the “fnd” module.

In the java console ( or JInitiator console ) check the version. You should have the same version. Continue reading »


Continue from previous posting.

Step-by-Step Migrate Database and Applications

1. Migrate Database of Oracle EBS

After upgrade the database of Oracle EBS to 10g Release 2, migration process will be more easier than if the database version still in 9i. The supported way to accomplish this prior to Oracle Database 10g Release 2 was to export the data from the database on the old platform, create a new database on the new platform, and import the data into the new database. This process could take a number of days for a large database. Oracle Database 10g provides two additional methods of migration a database to a new platform. Oracle Database 10g Release 2 introduced Transportable Database (TDB), which is used to reduce the amount of time and effort required to migrate a database between platforms that share the same endian format (byte ordering). Oracle Database 10g Release 1 introduced cross platform transportable tablespaces (XTTS), which allows data files to be moved between platforms of different endian format. XTTS is an enhancement to the transportable tablespace (TTS) feature introduced in Oracle8i. TTS was originally released as a method to move a subset of one database into another, such as plugging parts of an OLTP database into a data warehouse on the same platform. With the cross-platform enhancement, XTTS can plug data files into a database on a different platform, including those that are using a different endian format. XTTS may reduce platform migration time by moving all user tablespaces from a source database to an empty target database running on a platform that uses a different endian format. With the XTTS feature, Tablespaces plugged into the empty target database by copying the data files to the target database, converting them to the target system endian format, then importing the object metadata into the target database. Continue reading »


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 

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 »

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 »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha