Technical Articles

Technical Oracle Articles

Tips to install Oracle 11gr2 RAC on AIX (6.1/7.1)

AIX is an Unix environment basically, same to HP-Unix, and, if you have a plan to install Oracle RAC, you need to pay attention. I note some tips in this article to help.

1. Checking Operating System Packages

# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat \
bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte \
xlC.aix61.rte

If not, install on AIX source by smity. It's easy, but remember, some packaged requires your IBM's account to download.

Create RAID hardware on Sun Sparc T5-2

In previous article, I described the task list of configuration software raid on Solaris. And here, I brief the task list of configuration hardware raid on Sun Sparc model T.

Ofcoruse, the first step is connection to the server with serial console cable, assume the new server.
Remember:

data bit = 8
baud rate = 9600

Recommend tool: Sercure CRT, Putty.

Solaris 10 - Create software RAID 1

I worked on Unix many years ago, however, Solaris, AIX and HP-Unix are the platforms I often did with. I'm DBA, but there are not any System Administrator in my company, and I .. do the System's business at all.

Before ZFS becomes popular, UFS was always the best choice for Solaris, especially in M's series, example: Sun M-3000, M-4000, M-5000 ...etc. The M series does not support Hardware Raid, but only software, and this article do the brief of creating the software raid in. It's one of task list before configuration and installation Oracle in Solaris 10.

Some tips on installation Oracle 11gr2 on RHEL6

There are some tips when I finished the installation Oracle 11gr2 on RHEL6.
Full documents exits in Oracle documents library, so you can read them first

1. Install the requirement pacakges

[root@spsdev ~]#yum install local compat-libstdc++-33*
[root@spsdev ~]#yum install local libaio-devel-0.*
[root@spsdev ~]#yum install local pdksh-5.*
[root@spsdev ~]#yum install local unixODBC-devel-2.*
[root@spsdev ~]#yum install local sysstat-7.*

Migration ASM, the ARC diskgroup to the new storage

I'm new on Orafaq, this is my first blog. Thank you Sir John Watson promoted and supported me, and I'm sorry, I usually wrote bad English language.

Transporting tablespace from 32 to 64 bit using RMAN

Performing a 32 bit to 64 bit migration using the Transportable Database RMAN feature

This note describes the procedure used to perform a 32 bit to 64 bit conversion of an 11.2.0.3 database on the Linux platform.

The RMAN CONVERT DATABASE command is used to automate the movement of an entire database from one platform (the source platform) to another (the destination platform).

This is provided that the source and destination platforms are of the same endian format.

For example between Linux X86 32 bit and Linux X86 64 bit.

Note the following:

What is DB Time? Where has it gone?

DB Time is the time spent by the database server executing user calls. What is this composed of? CPU time, waiting time, and IO time.

Controlling Administrator Access with Oracle Database Vault “Separation of Duty”

This paper provides best practices for rapid deployment of Oracle Database Vault protections to
secure sensitive application data inside the database. Oracle Database Vault enables you to restrict administrative access to an Oracle
database. This helps you address the most difficult security problems remaining
today: protecting against insider threats, meeting regulatory compliance
requirements, and enforcing separation of duty. It covers the following main topics:

Hash join anti vs Nested loop join anti

This post shows you details about a specific case where 'hash anti join' is defeated by 'nested loop anti join'.
The initial problem came to light in a very large BW system running on Oracle 11.2.0.4 when several BW loads (making use of older data in the BW system) reported missing dimension ids in the dimension tables.

Software Review - Stellar Phoenix Oracle Database Recovery Software

The demand of Oracle database is very high and because of high demand, its security becomes the most concerned part of its users. Backup is the initial process you can do for your database security. However, at times, taking backup is also not sufficient and issues like backup file corruption, database damage due to virus, etc. takes place and data loss occurs. Therefore it's always better to have a utility to repair your damaged or corrupt Oracle Database Files and reconstruct its objects.

Pages

Subscribe to RSS - Technical Articles