Category Archives for Database

Oracle Exadata Storage

Oracle Exadata Storage Server The HP Oracle Exadata Storage Server is a storage product highly optimized for use with the Oracle database. Exadata is a combination of software and hardware used to store and access the Oracle database. It provides database aware storage services, such as the ability to offload database processing from the database […]

Read More

HugePages and Oracle RAC

 HugePages and Oracle RAC HugePages is a feature integrated into the Linux kernel with release 2.6. This feature basically provides the alternative to the 4K page size providing bigger pages. HugePage sizes vary from 2MB to 256MB based on kernel version and H/W architecture.  Why HugePages Should Be Used on RAC with 64-bit Linux? Very […]

Read More

Install Oracle Enterprise Linux 5.2 on VMware server 2.0

This is part II of series Installing Oracle Database (10g/11g) on Oracle Enterprise Linux 5.2 using Vmware Server 2.0. For part I – Download VMware, Oracle Enterprise Linux and creating Virtual Machine on Windows  Click Here In last post we started Virtual Machine using Green Arrow button, once Virtual Machine (Linux) is Up start console by clicking on Console […]

Read More

How to check Oracle Replication status / health check

Introduction: In the first post Here, we have seen all the procedure to make the Oracle 9i Replication between 2 sites. It is always easy to build the things, but it is more difficult to maintain the things. For Oracle Replication, there might be different problems, especially because of the connectivity between the replicated sites. We […]

Read More

Upgrade Oracle Database 10g to 11g R1 (11.1.X)

This post covers step by step upgrade of Oracle Database from version 10g (10.2.0.1) to 11g R1 (11.1.0.6) on Unix. You can use this document (with few additional steps mentioned in upgrade guide) to upgrade from 9i or for database on Windows Operating System. . Important points before you start 11g upgrade 1. Read Chapter […]

Read More

Listener Security – Important Tips

Turn on Logging In order to know, which listener commands were executing, one should enable the logging by the following: LSNRCTL> set log_directory  …/log LSNRCTL> set log_file Listener_<sid name>.log LSNRCTL> set log_status on LSNRCTL> save_config Set the Listener Password Setting Listener Password is strongly recommended in order to prevent the distinct attacks. There are two […]

Read More

OEM DBConsole startup issues on 10g R2 database for 11i/R12

On one of our cloned 11i Instance, I faced issues while trying to start Database Control (aka Enterprise Manager Console) using “emctl start dbconsole“. This post covers issues and resolution (Issues mentioned here are specific to particular Database and Operating System Version) . Instance Details Operating System : Solaris Sparc 64 Bit Database : Oracle […]

Read More

RAC Basics : CRS, Voting Disk, OCR, Cache Fusion ….

Oracle Clusterware (Cluster Ready Services in 10g/ Cluster Manager in 9i) – provides infrastructure that binds multiple nodes that then operate as single server. Clusterware monitors all components like instances and listeners. There are two important components in Oracle clusterware, Voting Disk and OCR (Oracle Cluster Registry). . Voting Disk – is file that resides […]

Read More

Explain Plan In Oracle

One of the most usefull tool which require for both DBAs and Developers to use it effectively to avoid the performance problem of Custom Code specailly in ERP database as well as any database. We should make best use of it.  An execution plan is a list of steps that Oracle will follow in order to execute a SQL […]

Read More

Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting

Objective: This paper is related to the Multi Master Replication setup, testing and troubleshooting. Introduction: In this Multi Master Replication testing two machines are being used. There will be two databases on the two different machines i.e. a) Master1 (Master definition Site) This site will be used for the administration of the Replication setup. b) […]

Read More
Not found