Archive

Archive for November, 2010

ORA-06512: at “SYS.DBMS_DEBUG_JDWP”, line 68

November 30, 2010 Leave a comment

Symptoms

SQL> exec dbms_debug_jdwp.connect_tcp(‘0.0.0.0’, ‘111’)
BEGIN dbms_debug_jdwp.connect_tcp(‘0.0.0.0’, ‘111’); END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_DEBUG_JDWP”, line 68
ORA-06512: at line 1

 

Fix

Grant the debug connect session, and any procedure to the user

SQL> grant debug connect session, debug any procedure to vod;

Grant succeeded.

 

Categories: TroubleShooting

Big mistake for installation 11gR2

November 26, 2010 1 comment

Today, I have made a big mistake for installation of 11gR2. I installed the 11gR2 in silent mode and couldn’t encounter any great problems. But when I started to create database in silent as well, it returned the following errors

$  dbca -silent -responseFile /export/home/oracle/database/response/dbca.rsp
Cleaning up failed steps
5% complete
Copying database files
7% complete
8% complete
100% complete
Look at the log file “/opt/oracle/cfgtoollogs/dbca/testdb/testdb1.log” for further details.

$ cat /opt/oracle/cfgtoollogs/dbca/testdb/testdb1.log
Cleaning up failed steps
DBCA_PROGRESS : 5%
Copying database files
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 8%
ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error

DBCA_PROGRESS : 100%

I spent 1~2 days surfing on internet to look up solutions. Almost root causes were related to different version of oracle binary after Oracle upgrade or ORACLE_SID were not set. All suggests I have done, but there  were no one to solve my problem. Finally, I found that I make a big mistake to mix different version of oracle zip to install.

 

$ ls -al
total 4650919
drwxr-xr-x   6 oracle   dba            9 Nov 26 13:47 .
drwxr-xr-x   3 root     root           3 Nov 12 12:15 ..
drwxr-xr-x   2 oracle   dba           78 Nov 25 09:31 .fontconfig
-rw-r–r–   1 oracle   dba          798 Nov 24 16:21 .profile
drwx——   2 oracle   dba            3 Nov 24 10:55 .ssh
drwx——   3 oracle   dba            3 Nov 24 10:55 .sunw
drwxr-xr-x   8 oracle   dba           10 Nov  6  2009 database
-rw-r–r–   1 oracle   dba      1373903591 Nov 24 10:58 solaris.sparc64_11gR2_database_1of2.zip <– it is used for solaris platform
-rw-r–r–   1 oracle   dba      1005450726 Nov 25 09:18 solaris.x64_11gR2_database_2of2.zip <– it is used for X86 intel platform
$

 

 

 

 

 

 

 

Categories: Installation

Mount USB device in solaris 10

November 26, 2010 Leave a comment

Notice: Solaris only support FAT/FAT32 filesystem, (NTFS can’t be mounted)

1. Check the configuration of /etc/vold.conf

# Copyright 2006 Sun Microsystems, Inc.  All rights reserved.
# Use is subject to license terms.
#
# ident “@(#)vold.conf  1.27    06/01/20 SMI”
#
# Volume Daemon Configuration file
#

# Database to use (must be first)
db db_mem.so

# Volfs support of removable media devices
support nomedia

# Labels supported
label cdrom label_cdrom.so cdrom
label dos label_dos.so floppy rmdisk pcmem
label sun label_sun.so floppy rmdisk pcmem

# Devices to use
use cdrom drive /dev/rdsk/c*s2 dev_cdrom.so cdrom%d
use floppy drive /dev/rdiskette[0-9] dev_floppy.so floppy%d
use pcmem drive /dev/rdsk/c*s2 dev_pcmem.so pcmem%d forceload=true
use rmdisk drive /dev/rdsk/c*s2 dev_rmdisk.so rmdisk%d (<– this line is unremarked)

# Actions
eject dev/diskette[0-9]/* user=root /usr/sbin/rmmount
eject dev/dsk/* user=root /usr/sbin/rmmount
insert dev/diskette[0-9]/* user=root /usr/sbin/rmmount
insert dev/dsk/* user=root /usr/sbin/rmmount
notify rdsk/* group=tty user=root /usr/lib/vold/volmissing -p
remount dev/diskette[0-9]/* user=root /usr/sbin/rmmount
remount dev/dsk/* user=root /usr/sbin/rmmount

# List of file system types unsafe to eject
unsafe ufs hsfs pcfs udfs

2. Restart the volfs

/etc/init.d/volmgt stop

/etc/init.d/volmgt start

or

# svcs -a | grep volf
online         14:46:03 svc:/system/filesystem/volfs:default
# svcadm restart  svc:/system/filesystem/volfs:default

3. The USB filesystem is mounted as the following

/vol/dev/dsk/c5t0d0/unnamed_rmdisk:c
4061392 2549008 1512384    63%    /rmdisk/unnamed_rmdisk

 

 

 

 

Categories: Solaris Admin Tags:

Oracle 11gR2 silent installation problem

November 25, 2010 1 comment

When I installed Oracle 11gR2 in silent mode, I encountered two problems. The details and solutions are shown as below

Problem 1:

Symptoms

1. Edit the ./response/db_install.rsp withe following settings

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=testvmdb

UNIX_GROUP_NAME=dba

INVENTORY_LOCATION=/opt/oracle/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/opt/oracle/product/11g

ORACLE_BASE=/opt/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=dba

2. Start the silent installation

$  ./runInstaller -silent -ignorePrereq  -responseFile ‘/export/home/oracle/database/response/db_install.rsp’
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 180 MB.   Actual 180764 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4233 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-11-25_10-52-41AM. Please wait …$ Exception in thread “main” java.lang.NoClassDefFoundError
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at java.awt.Toolkit$2.run(Toolkit.java:821)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804)
at javax.swing.UIManager.initialize(UIManager.java:1262)
at javax.swing.UIManager.maybeInitialize(UIManager.java:1245)
at javax.swing.UIManager.getUI(UIManager.java:851)
at javax.swing.JPanel.updateUI(JPanel.java:104)
at javax.swing.JPanel.<init>(JPanel.java:64)
at javax.swing.JPanel.<init>(JPanel.java:87)
at javax.swing.JPanel.<init>(JPanel.java:95)
at oracle.sysman.oii.oiif.oiifo.OiifoOCMUI.<init>(OiifoOCMUI.java:125)
at oracle.sysman.oii.oiif.oiifo.OiifoOCMInterfaceManager.<init>(OiifoOCMInterfaceManager.java:79)
at oracle.sysman.oii.oiif.oiifo.OiifoOCMInterfaceManager.getInstance(OiifoOCMInterfaceManager.java:124)
at oracle.install.ivw.db.driver.DBInstaller.run(DBInstaller.java:123)
at oracle.install.commons.util.Application.startup(Application.java:869)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265)
at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114)
at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)

Fix

Check the installation session environment variable, unset the DISPLAY

$ unset DISPLAY

 

Problem 2:

Symptoms

1. After fixing the problem 1, restart the installation in silent mode

2. Start the silent installation, got the following server problem

“/export/home/oracle/database/response/db_install.rsp” 415 lines, 22657 characters
$ ./runInstaller -silent -ignorePrereq  -responseFile ‘/export/home/oracle/database/response/db_install.rsp’
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 180 MB.   Actual 184798 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 5549 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-11-25_10-28-43AM. Please wait …$ [SEVERE] – Email Address Not Specified
A log of this session is currently saved as: /tmp/OraInstall2010-11-25_10-28-43AM/installActions2010-11-25_10-28-43AM.log. Oracle recommends that if you want to keep this log, you should move it from the temporary location to a more permanent location.

Fix

Set both installation variables in db_install.rsp with values shown

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

 

Categories: Installation

Enable or restart ntp client to cause Oracle RAC nodes reboot

November 23, 2010 Leave a comment

Symptoms

We can simulate the problem with set system time a few second advance and restart ntp as the following

1. date -a 7

2. Wait about 1 minutes (

3. Restart the ntp

# svcadm restart svc:/network/ntp:default

4. RAC node got reboot and the /var/adm/messages get the following

Nov 23 10:18:59 qapdb03 xntpd[302]: [ID 866926 daemon.notice] xntpd exiting on signal 15
Nov 23 10:19:00 qapdb03 ntpdate[10199]: [ID 774510 daemon.notice] step time server 192.168.31.220 offset -3.733644 sec
Nov 23 10:19:00 qapdb03 xntpd[10225]: [ID 702911 daemon.notice] xntpd 3-5.93e+sun 03/08/29 16:23:05 (1.4)
Nov 23 10:19:00 qapdb03 xntpd[10225]: [ID 301315 daemon.notice] tickadj = 5, tick = 10000, tvu_maxslew = 495, est. hz = 100
Nov 23 10:19:00 qapdb03 xntpd[10225]: [ID 266339 daemon.notice] using kernel phase-lock loop 0041, drift correction 0.00000
Nov 23 10:19:00 qapdb03 xntpd[10225]: [ID 266339 daemon.notice] using kernel phase-lock loop 0041, drift correction 7.70099

Finding  Solutions

I got three solutions from internet with similar symptoms

1.  Set the following system parameters

set tod_broken = 1
set dosynctodr = 0

Comment: It didn’t work, nodes still got reboot

2. Set /etc/inet/ntp.conf with “slewalways yes” or -x

Comment: It didn’t work, nodes still got reboot

3. Set oracle clusterware parameter diagwait to 13 second ( default = 500ms)

Comment: It worked

Categories: clusterware

You do not have write access

November 15, 2010 Leave a comment

Symptoms

Login Ldom guest through v-console, get the following messages

“You do not have write access” and can’t get login prompt

 

Causes

There is another session, it has login the guest. When this session is terminated, the problem is fixced


 

 

Categories: LDom

Add OS DVD to guest domain

November 15, 2010 Leave a comment

# ldm add-vdsdev /vol/dev/dsk/c0t0d0/sol_10_1008_sparc cdrom@primary-vds0

# ldm add-vdisk cdrom cdrom@primary-vds0 sgvmdb01

# ldm start sgvmdb01
LDom sgvmdb01 started
# telnet localhost 5001
Trying 127.0.0.1…
Connected to localhost.
Escape character is ‘^]’.

Connecting to console “sgvmdb01” in group “sgvmdb01” ….
Press ~? for control options ..

{0} ok devalias
cdrom                    /virtual-devices@100/channel-devices@200/disk@2
sgdbcrs                  /virtual-devices@100/channel-devices@200/disk@5
sgdbvoting               /virtual-devices@100/channel-devices@200/disk@4
sgdbdata                 /virtual-devices@100/channel-devices@200/disk@3
os_boot_disk             /virtual-devices@100/channel-devices@200/disk@1
sysdisk                  /virtual-devices@100/channel-devices@200/disk@0
vnet2                    /virtual-devices@100/channel-devices@200/network@2
vnet1                    /virtual-devices@100/channel-devices@200/network@1
vnet0                    /virtual-devices@100/channel-devices@200/network@0
net                      /virtual-devices@100/channel-devices@200/network@0
disk                     /virtual-devices@100/channel-devices@200/disk@0
virtual-console          /virtual-devices/console@1
name                     aliases
{0} ok boot cdrom

SPARC Enterprise T5120, No Keyboard
Copyright 2010 Sun Microsystems, Inc.  All rights reserved.
OpenBoot 4.30.7, 8192 MB memory available, Serial #83568233.
Ethernet address 0:14:4f:fb:26:69, Host ID: 84fb2669.

Categories: LDom