Thinking Out Loud

January 9, 2011

RMAN Bug 10306699 ORA-01008

Filed under: oracle — mdinh @ 5:12 pm

I just wanted to share a RMAN bug that I have encountered, just in case you get infected as well.

The OS is

> uname -an
SunOS  5.10 Generic_142909-17 sun4u sparc SUNW,SPARC-Enterprise

> rman

Recovery Manager: Release 11.2.0.2.0 - Production on Sat Jan 8 07:28:19 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target /

DBGSQL: TARGET> select count(*) into :dbstate from v$parameter where lower(name) = '_dummy_instance' and upper(value) = 'TRUE'
DBGSQL: sqlcode = 1008
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01008: not all variables bound

RMAN>

Bug 10306699: ORA-1008 DURNING RMAN BACKUP AFTER UPGRADING TO 11.2.0.2.0
https://supporthtml.oracle.com/ep/faces/secure/km/BugDisplay.jspx?id=10306699&bugProductSource=Oracle&h=Y

Suggested solution was to set cursor_sharing=EXACT

Also, it helps to flush the shared pool before connecting to target.

UPDATED:

As Gerrit has stated in the comment, there is a patch available.

Have not seen the issue since then.

Patch  9877980      : applied on Sun Aug 21 20:12:30 PDT 2011
Unique Patch ID:  13349636
   Created on 19 Jan 2011, 18:34:07 hrs PST8PDT
   Bugs fixed:
     9877980

 

January 7, 2011

VirtualBox Command Line

Filed under: VirtualBox — mdinh @ 4:20 am

I have manually configured VirtualBox Host-Only Ethernet Adapter for static IP.

However, the IP can change after reboot which affects connectivity with the Guest with static IP.

I have not been able able to figure out why.

However, one method to resolve this is to add the following commands in a batch file and have it executed at startup.

VBoxManage hostonlyif ipconfig “VirtualBox Host-Only Ethernet Adapter” –ip 192.168.56.1
VBoxManage dhcpserver modify –ifname “VirtualBox Host-Only Ethernet Adapter” –disable
VBoxManage list -l hostonlyifs

C:\>VBoxManage hostonlyif ipconfig "VirtualBox Host-Only Ethernet Adapter" --ip 192.168.56.1

C:\>VBoxManage dhcpserver modify --ifname "VirtualBox Host-Only Ethernet Adapter" --disable

C:\>VBoxManage list -l hostonlyifs
Name:            VirtualBox Host-Only Ethernet Adapter
GUID:            97cdbf73-e6e7-45d3-a8fe-ea4ee0fd5939
Dhcp:            Disabled
IPAddress:       192.168.56.1
NetworkMask:     255.255.255.0
IPV6Address:     fe80:0000:0000:0000:ecfc:c04f:b7dd:4054
IPV6NetworkMaskPrefixLength: 64
HardwareAddress: 08:00:27:00:98:7d
MediumType:      Ethernet
Status:          Up
VBoxNetworkName: HostInterfaceNetworking-VirtualBox Host-Only Ethernet Adapter

C:\>

Blog at WordPress.com.