Archive

Archive for March, 2011

OUI complainted about a msvcr71.dll file in use

March 24, 2011 Leave a comment

Symptoms

Today, I installed Patch 10.2.0.5. Before installing, I have stopped all Oracle Services.  When attempting to install the Patchset 10.2.0.5.0 by OUI, it  complainted about a msvcr71.dll file in use.

 

Fixed

Finally, we found that the service “Distributed Transaction Coordinator” was using this file. After stopping the service as well, the installation success.

 

 

 

Advertisements
Categories: Oracle Installation

The specified nodes are not clusterable

March 24, 2011 Leave a comment

Symptoms

The installation 10g2 RAC on windows 2003 failed today.  When going to “Specify Cluster Configuration”, it has shown wrong on public node name, private node name and virtual host name. After correcting them and add the cluster nodes and clicking “Next”. The message “The specified nodes are not clusterable” is pop up.

After searching on oracle support, I found the same problem symptoms. Here is the explanation

Cause

The network configuration is incorrect.

Private NIC is listed as first NIC.

Solution

Simply changing the NICs order and setting the public NIC first.

Step for modifying this are:

  1. Open explorer
  2. Right click on my network places
  3. Select properties
  4. From Advanced menu, select Advanced settings
  5. With Adapters and bindings open, move public NIC to be first on list



After this change clean-up the cluster according to following article:

 

 

Categories: Oracle Installation

ORA-00704: bootstrap process failure

March 9, 2011 Leave a comment

Today, I upgrade a database from 11.1.06 to 11.1.0.7. When I startup with upgrade option, the message returned as below

SQL> alter database open UPGRADE;
alter database open UPGRADE
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 4060
Session ID: 170 Serial number: 5

After looking at alert.log, I found the following messages

*** 2011-03-09 17:38:41.390
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

 

Fixed

Finally, I found that the database must be mounted in exclusive mode first and alter open with upgrade. The problem was fixed as procedure below

SQL> startup nomount;
ORACLE instance started.

SQL> alter system set cluster_database=false scope=spfile;

System altered.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount exclusive
ORACLE instance started.

SQL> alter database open upgrade;

Categories: TroubleShooting

How to remove database from clusterware

March 7, 2011 Leave a comment

1. Remove database service ha_gsqs

$srvctl remove service -d gsqsprd -s ha_gsqs

ha_gsqs PREF: gsqsprd1 gsqsprd2 AVAIL:

Remove service ha_gsqs from the database gsqsprd? (y/[n]) y

$ crs_stat -t

Name           Type           Target    State     Host

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

ora.gschprd.db application    ONLINE    ONLINE    yvpdb11

ora….d1.inst application    ONLINE    ONLINE    yvpdb10

ora….d2.inst application    ONLINE    ONLINE    yvpdb11

ora….gsch.cs application    ONLINE    ONLINE    yvpdb10

ora….rd1.srv application    ONLINE    ONLINE    yvpdb10

ora….rd2.srv application    ONLINE    ONLINE    yvpdb11

ora.gsqsprd.db application    OFFLINE   OFFLINE

ora….d1.inst application    OFFLINE   OFFLINE

ora….d2.inst application    OFFLINE   OFFLINE

ora….SM1.asm application    ONLINE    ONLINE    yvpdb10

ora….10.lsnr application    ONLINE    ONLINE    yvpdb10

ora….b10.gsd application    ONLINE    ONLINE    yvpdb10

ora….b10.ons application    ONLINE    ONLINE    yvpdb10

ora….b10.vip application    ONLINE    ONLINE    yvpdb10

ora….SM2.asm application    ONLINE    ONLINE    yvpdb11

ora….11.lsnr application    ONLINE    ONLINE    yvpdb11

ora….b11.gsd application    ONLINE    ONLINE    yvpdb11

ora….b11.ons application    ONLINE    ONLINE    yvpdb11

ora….b11.vip application    ONLINE    ONLINE    yvpdb11

2. Remove database instance gsqsprd1 and gsqsprd2

$ srvctl remove instance -d gsqsprd -i gsqsprd1

Remove instance gsqsprd1 from the database gsqsprd? (y/[n]) y

$ srvctl remove instance -d gsqsprd -i gsqsprd2

Remove instance gsqsprd2 from the database gsqsprd? (y/[n]) y

$

$ crs_stat -t

Name           Type           Target    State     Host

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

ora.gschprd.db application    ONLINE    ONLINE    yvpdb11

ora….d1.inst application    ONLINE    ONLINE    yvpdb10

ora….d2.inst application    ONLINE    ONLINE    yvpdb11

ora….gsch.cs application    ONLINE    ONLINE    yvpdb10

ora….rd1.srv application    ONLINE    ONLINE    yvpdb10

ora….rd2.srv application    ONLINE    ONLINE    yvpdb11

ora.gsqsprd.db application    OFFLINE   OFFLINE

ora….SM1.asm application    ONLINE    ONLINE    yvpdb10

ora….10.lsnr application    ONLINE    ONLINE    yvpdb10

ora….b10.gsd application    ONLINE    ONLINE    yvpdb10

ora….b10.ons application    ONLINE    ONLINE    yvpdb10

ora….b10.vip application    ONLINE    ONLINE    yvpdb10

ora….SM2.asm application    ONLINE    ONLINE    yvpdb11

ora….11.lsnr application    ONLINE    ONLINE    yvpdb11

ora….b11.gsd application    ONLINE    ONLINE    yvpdb11

ora….b11.ons application    ONLINE    ONLINE    yvpdb11

ora….b11.vip application    ONLINE    ONLINE    yvpdb11

3. Remove database

$  srvctl remove database -d gsqsprd

Remove the database gsqsprd? (y/[n]) y

$

Categories: clusterware

RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode

March 7, 2011 Leave a comment

Today,

I duplicate new database from existing database on the same RAC servers. At the end, I got the following messages

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/07/2011 11:29:05
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

Finally, I found that I foget setting the target database ( the new one) initial parameter cluster_database to false. After changing the parameter to false, and restart instance in nomount and then reduplicate the database again. It worked fine.

 

 

 

 

Categories: Administration

How to mount/umount CDROM on Solaris

March 2, 2011 Leave a comment

You can mount cdrom by vold or manually

By vold daemon:

1. Check if the vold daemon is runing

# pgrep vold

2. If it is not runing, restart it

# pkill vold && /usr/sbin/vold &

3. Check the mount status of CDROM

# df-k

Manually:
1. Find the cdrom device on Solaris
$ ls -al /dev/sr* | awk '{print "/" $11}'
/dsk/c1t0d0s
2. Mount the CDROM
$ mount -F hsfs -r /dev/sr0 /cdrom
or
$ mount -F hsfs -o -ro /dev/c1t0d0s2
Categories: Solaris Admin