Translate this Page

Fah

How To Configure Multipath in Linux

 Linux  No Responses »
Dec 052012
 

When we used redundant SAN Switch to present the same LUN, Linux will recognize 1 LUN become 2. In the example we can see the size of /dev/sdb as same as /dev/sde (8069.5 GB) and /dev/sdc as same as /dev/sdd (5763.9 GB), actually we only created 2 LUN in the storage:

# fdisk -l

Disk /dev/sdb: 8069.5 GB, 8069496176640 bytes
255 heads, 63 sectors/track, 981060 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

Disk /dev/sdb doesn't contain a valid partition table

Disk /dev/sdc: 5763.9 GB, 5763927244800 bytes
255 heads, 63 sectors/track, 700757 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

Disk /dev/sdc doesn't contain a valid partition table

Disk /dev/sdd: 8069.5 GB, 8069496176640 bytes
255 heads, 63 sectors/track, 981060 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

Disk /dev/sdd doesn't contain a valid partition table

Disk /dev/sde: 5763.9 GB, 5763927244800 bytes
255 heads, 63 sectors/track, 700757 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

To unity the different path, we can used “multipath”‘

Continue reading »

 Posted by at 3:45 am  Tagged with:

How to replace UNDO Tablespace

 Oracle, Working note  No Responses »
Jun 132011
 

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 »

 Posted by at 7:24 am  Tagged with: , ,

How To Create Physical Standby Database – Oracle10g

 Oracle  No Responses »
Apr 122011
 

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 »

 Posted by at 6:20 am  Tagged with: , ,

HOW TO Purge vCenter’s SQL Server Transaction Log

 SQL Server, Working note  1 Response »
Jan 172011
 

In SQL Server, every transaction (Insert, Delete, Update, etc) will put in Transaction Log File. This file need for recovery. That’s why, before we purge transaction log, we should doing Full Backup of the database first.

  • Check the Free Space of the vCenter Server

Check Free Space

Continue reading »

 Posted by at 6:54 am

HOW TO give root’s privilege to other user

 Unix, Working note  3 Responses »
Aug 112010
 

If we want to give root’s privilege to other users on LINUX:

1. edit /etc/sudoers

In this scenario, user opr1 will have privilege to manage cups.  Edit the file, put the parameter :

opr1    ALL=/etc/init.d/cups

2.  From the user that get the privilege, they have to add command  `sudo`

 $ sudo /etc/init.d/cups restart
 Posted by at 3:51 am  Tagged with: ,

HOW TO Setup HSODBC Interface

 Oracle, Working note  No Responses »
Jul 292010
 

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

[trans]
Driver = /usr/lib/libmyodbc3.so
Description = mysql connection to test
SERVER = 172.16.11.213
PORT = 3306
USER = root
Password = password
Database = Transaksi_DB
OPTION = 3
SOCKET =

Continue reading »

 Posted by at 2:14 am  Tagged with: , , ,

HOW TO Create Filesystem and ImportVG on IBM-AIX

 Unix, Working note  No Responses »
Jul 132010
 

In this posting, we will learn how to create Filesystem on IBM AIX. If we have a cluster system, then we need to create the same filesystem definition in all servers that used in cluster system. For this reason, we only exportvg in a server and import it to another servers.
0. Scan your new LUN/Disk

Continue reading »

 Posted by at 9:34 am  Tagged with: , ,

HOW TO reset Admin’s Password in Oracle Application Express

 Working note  6 Responses »
Jul 022010
 

In this posting, we learn how to reset Admin’s Password in Oracle Application Express (APEX).

1. Collect the information of the FLOWS% schema

$ sqlplus '/as sysdba'
SQL> select username,password,account_status from dba_users
2 where username like 'FLOW%';
 USERNAME          PASSWORD             ACCOUNT_STATUS
----------------   ------------------   ----------------
FLOWS_020200       569054L59C7186CB     LOCKED
FLOWS_030000       240C2BE199B3DB1F     LOCKED
FLOWS_010600       EDEA2EV8EEE12B6F     LOCKED
FLOWS_FILES        4D6011I6ACC3FBF2     LOCKED

  Continue reading »

 Posted by at 9:00 am  Tagged with: ,

Troubleshooting during Migration DB and Apps

 Oracle, Working note  No Responses »
Jun 162010
 

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 »

 Posted by at 10:59 am  Tagged with: , ,

MIGRATION Oracle EBS 11.5.9 with Database 10g Part III

 Oracle, Working note  No Responses »
Jun 162010
 

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 »

 Posted by at 10:38 am  Tagged with: , ,
 Older Entries
© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha