Oracle Database Experts

Here’s Charles Kim’s Oracle Database 11g New Features presentation at the Dallas Oracle User Group (DOUG) on May 2008.

By Charles Kim, Oracle ACE

Here’s Charles Kim’s Oracle Database 11g New Features presentation at the Suncoast Oracle User Group (SOUG) in Tampa, Florida.

Presentation Date – March 2008 by Charles Kim

Linux 64-bit Requirements for Red Hat 5 for Oracle Database 11g Release 2
(Also includes Asianux Server 3, Oracle Enterprise Linux 5,)

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2
libstdc++-devel
make-3.81
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-2.2.11
unixODBC-devel-2.2.11
unixODBC-devel-2.2.11 (32 bit)

The following list of RPMs are required to successfully install Oracle Database 11g Release 1 on Red Hat:

binutils-2.15.92.0.2-18
compat-libstdc++-33.2.3-47.3
elfutils-libelf-0.97-5
elfutils-libelf-devel-0.97-5
glibc-2.3.9.4-2.19
glibc-common-2.3.9.4-2.19
glibc-devel-2.3.9.4-2.19
gcc-3.4.5-2
gcc-c++-3.4.5-2
libaio-devel-0.3.105-2
libaio-0.3.105-2
libgcc-3.4.5
libstdc++-3.4.5-2
libstdc++-devel-3.4.5-2
make-3.80-5
sysstat-5.0.5
unixODBC-2.2.11
unixODBC-devel-2.2.11

Let’s look at invisible indexes. For our demonstration purposes, create a table called books based on the book_id which has an auto-generated PK and other basic columns: name, author, ISBN.

  </span></span>

create table books (book_id number,

name varchar2(255),

author varchar2(255),

isbn varchar2(255));

insert into books

(book_id, name, author, isbn) values (2,'RMAN Recipes','Darl Kuhn','1590598512');

insert into books

(book_id, name, author, isbn) values (1,'Oracle ASM','Nitin Vengurlekar','0071496076');

insert into books

(book_id, name, author, isbn) values (3,'Oracle 11g New Features','Charles Kim','1590599101');

Now, let’s create the invisible index:

create index BOOK_ISBN_INVISIBLE_IDX on books(isbn) invisible;

By querying user_indexes, you can see that the new index is invisible.
1* select index_name,VISIBILITY

from user_indexes

where index_name=’BOOK_ISBN_INVISIBLE_IDX’

SQL> /

INDEX_NAME VISIBILIT

—————————— ———

BOOK_ISBN_INVISIBLE_IDX INVISIBLE

You must set the initialization parameter, optimizer_use_invisible_indexes = TRUE to take adavantage of invisible indexes.

Technorati : Posted by Charles Kim @ DBAExpert.com

The upgrade process to 11gR1 is the same process as upgrading from 10.2.0.1 to 10.2.0.3. The steps for the upgrade process is:

Shutdown CRS

The following steps are optional:

• Modify /etc/inittab and comment out last three lines
• init q

$ORA_CRS_HOME/bin/crsctl stop crs

Execute pre-update script from the unzipped software/clusterware/upgrade directory
./preupdate.sh -crshome $ORA_CRS_HOME -crsuser oracrs

Install new software binaries on all the RAC nodes
./runInstaller

From $ORA_CRS_HOME/install directory
./rootupgrade

Check upgrade status by querying activeversion of the CRS
crsctl query crs activeversion

Here are the additional RPM requirement to upgrade from Oracle Database 10g to Oracle Database 11g. Using up2date, you can easily install or update these RPMs.

[root@rac01 rpm]# up2date elfutils-libelf-devel

Fetching Obsoletes list for channel: el4_i386_latest…

Fetching rpm headers…
########################################

Name Version Rel
———————————————————-
elfutils-libelf-devel 0.97.1 5 i386

Testing package set / solving RPM inter-dependencies…
########################################
elfutils-libelf-0.97.1-5.i3 ########################## Done.
elfutils-libelf-devel-0.97. ########################## Done.
elfutils-0.97.1-5.i386.rpm: ########################## Done.
Preparing ########################################### [100%]

Installing…
1:elfutils-libelf ########################################### [100%]
2:elfutils ########################################### [100%]
3:elfutils-libelf-devel ########################################### [100%]
The following packages were added to your selection to satisfy dependencies:

Name Version Release
————————————————————–
elfutils-libelf 0.97.1 5
elfutils 0.97.1 5

[root@rac01 rpm]# up2date libaio-devel

Fetching Obsoletes list for channel: el4_i386_latest…

Fetching rpm headers…
########################################

Name Version Rel
———————————————————-
libaio-devel 0.3.105 2 i386

Testing package set / solving RPM inter-dependencies…
########################################
libaio-devel-0.3.105-2.i386 ########################## Done.
Preparing ########################################### [100%]

Installing…
1:libaio-devel ########################################### [100%]
[root@rac01 rpm]# up2date unixODBC

Fetching Obsoletes list for channel: el4_i386_latest…

Fetching rpm headers…
########################################

Name Version Rel
———————————————————-
unixODBC 2.2.11 1.RHEL4.1 i386

Testing package set / solving RPM inter-dependencies…
########################################
unixODBC-2.2.11-1.RHEL4.1.i ########################## Done.
Preparing ########################################### [100%]

Installing…
1:unixODBC ########################################### [100%]
[root@rac01 rpm]# up2date unixODBC-devel

Fetching Obsoletes list for channel: el4_i386_latest…

Fetching rpm headers…
########################################

Name Version Rel
———————————————————-
unixODBC-devel 2.2.11 1.RHEL4.1 i386

Testing package set / solving RPM inter-dependencies…
########################################
unixODBC-devel-2.2.11-1.RHE ########################## Done.
Preparing ########################################### [100%]

Installing…
1:unixODBC-devel ########################################### [100%]

Technorati : Oracle Database 11g

Posted by Charles Kim @ DBAExpert.com