DK-diary

Solution for ORA-01092, ORA-00704, ORA-39700

2009-03-09T13:52:00.001-07:00

Solution for ORA-01092, ORA-00704, ORA-39700

Sunday, September 14, 2008 1:04:07 PM (GTB Daylight Time, UTC+03:00) ( Oracle )

A few days ago i have created an Oracle database manually(once i have crated an automated DB creation tamplate, it has a bug L). Somehow, some errors occured during creation. Then, when i started open the db, i got some errors. I explained below what the work around is.

orcl oracle@srv:/data06/app/oracle/admin/orcl/scripts> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 5 23:50:26 2008

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 104857600 bytes

Fixed Size 2046864 bytes

Variable Size 75498608 bytes

Database Buffers 20971520 bytes

Redo Buffers 6340608 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

Check the alert log and trace

orcl oracle@srv:/data06/app/oracle/admin/orcl/bdump> more alert_orcl.log

......

.....

Errors in file /data06/app/oracle/admin/orcl/udump/orcl_ora_151225.trc:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Tue Aug 5 23:45:33 2008

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Instance terminated by USER, pid = 151225

ORA-1092 signalled during: alter database open...

Then solution

orcl oracle@srv:/data06/app/oracle/admin/orcl/scripts> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 5 23:51:59 2008

Connected to an idle instance.

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 104857600 bytes

Fixed Size 2046864 bytes

Variable Size 75498608 bytes

Database Buffers 20971520 bytes

Redo Buffers 6340608 bytes

Database mounted.

Database opened.

SQL> @/data06/app/oracle/product/10.2/rdbms/admin/catalog.sql;

.....

SQL> @/data06/app/oracle/product/10.2/rdbms/admin/catproc.sql;

from: http://mennan.kagitkalem.com/SolutionForORA01092ORA00704ORA39700.aspx

Solution for ORA-01092, ORA-00704, ORA-39700

2009-03-09T13:52:00.000-07:00

Solution for ORA-01092, ORA-00704, ORA-39700

Sunday, September 14, 2008 1:04:07 PM (GTB Daylight Time, UTC+03:00) ( Oracle )

orcl oracle@srv:/data06/app/oracle/admin/orcl/scripts> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 5 23:50:26 2008

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 104857600 bytes

Fixed Size 2046864 bytes

Variable Size 75498608 bytes

Database Buffers 20971520 bytes

Redo Buffers 6340608 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

Check the alert log and trace

orcl oracle@srv:/data06/app/oracle/admin/orcl/bdump> more alert_orcl.log

......

.....

Errors in file /data06/app/oracle/admin/orcl/udump/orcl_ora_151225.trc:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Tue Aug 5 23:45:33 2008

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Instance terminated by USER, pid = 151225

ORA-1092 signalled during: alter database open...

Then solution

orcl oracle@srv:/data06/app/oracle/admin/orcl/scripts> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 5 23:51:59 2008

Connected to an idle instance.

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 104857600 bytes

Fixed Size 2046864 bytes

Variable Size 75498608 bytes

Database Buffers 20971520 bytes

Redo Buffers 6340608 bytes

Database mounted.

Database opened.

SQL> @/data06/app/oracle/product/10.2/rdbms/admin/catalog.sql;

.....

SQL> @/data06/app/oracle/product/10.2/rdbms/admin/catproc.sql;

Java language from command line

2008-06-04T04:51:00.000-07:00

java -Duser.language=de -jar xxx.jar

Java string to int

2008-06-04T04:34:00.000-07:00

You can convert a String to integer using parseInt() method of Integer wrapper class or using valueOf() and intValue() methods together as follows.

    String str = "10";
   int i = Integer.valueOf(str).intValue();
   or
   int i = Integer.parseInt(str); // possible exception here

google-earth has caught signal 11

2008-04-23T06:55:00.000-07:00

Load this version of libGL.so.1 into the google-earth directory:

wget http://librarian.launchpad.net/7037027/libGL.so.1 -O libGL.so.1

Skype on XP disable autostart

2008-04-14T22:42:00.000-07:00

Follow the instructions in this link:
http://linansg.wordpress.com/2007/02/22/to-remove-autostart-programs-from-windows/

To remove autostart programs from windows

Windows XP comes with the System Configurationtool (Msconfig.exe), an excellent way to manage the startup process. To start it:

Click Start, click Run, type Msconfig, and then press Enter.
On the Startup tab, you’ll see a list of all the programs and processes that are set to run when Windows XP loads.
Speed up your overall start time by clearing the check box next to any item you think you don’t need.
Click Apply, and then restart your computer for the changes to take effect.

Java plugin for Firefox x86_64

2008-03-11T23:06:00.000-07:00

Install "iced tea plugin" from following link:
"http://software.opensuse.org/search?q=java-1_7_0-icedtea-plugin&baseproject=openSUSE:Factory"

Firefox enable mms

2008-02-22T11:46:00.000-08:00

f you're sick of seeing "MMS is not a registered protocol" when trying to view streaming content, here's the fix (compiled from a few half-correct or half-clear descriptions from around the net).

I use Debian Linux with the KDE desktop, but this should work so long as you've got Firefox and Kaffeine installed. Mplayer would probably work in place of Kaffeine.

(1.) Open Firefox, type "about:config" (no quotes) in the address window, and click enter.
(2.) Right click on the window and choose , then from the pop-up menu that appears.
(3.) In the first pop-up box, enter: "network.protocol-handler.app.mms" (no quotes, and it might just be easier to cut 'n paste this into the box).
(4.) In the next pop-up box enter the path to Kaffeine (e.g. "/usr/bin/kaffeine").
(5.) Now, click in the main window again but choose
(6.) In the first pop-up box, enter: "network.protocol-handler.external.mms"
(7.) In the second pop-up select .

Done. Enjoy.

From: http://www.cinlug.org/node/316

Wine date format in Lotus Notes

2008-02-14T09:45:00.000-08:00

When running Lotus Notes on Wine the date format might be incorrect. To change this set e.g.
LANG="de_DE.UTF-8"
for the wine environment. Of course "de_DE" shuold be replaced by the language environment required for Notes...

VNC and AltGr

2008-02-11T23:14:00.000-08:00

This link: http://www.mpifr-bonn.mpg.de/staff/emiddelberg/help/linux.txt
gives some hints, the important information duplicated here:

Put this in your .Xmodmap to enable german Umlauts and the Euro sign
====================================================================

by Walter Alef, 26Mar2003

keycode 64 = Meta_L
keycode 0x6D = Multi_key
!
! Peter Müller, MPIfR Bonn 16. Mai 1999
!
! This file makes the following changes:
!
! ä on alt a
! ö on alt o
! ü on alt u
! ß on alt s
! µ on alt m
! ¤ (EURO) on alt e
! The "Alt Gr" key generates Mode_switch and Multi_key

keysym u = u U udiaeresis Udiaeresis
keysym o = o O odiaeresis Odiaeresis
keysym a = a A adiaeresis Adiaeresis
keysym s = s S ssharp degree
keysym m = m M mu section
keysym e = e E EuroSign EuroSign
keysym Alt_R = Mode_switch Multi_key

clear Shift
clear Lock
clear Control
clear Mod1
clear Mod2
clear Mod3
clear Mod4
clear Mod5

add Shift = Shift_L Shift_R
add Lock = Caps_Lock
add Control = Control_L Multi_key
add Mod1 = Meta_L
add Mod2 = Num_Lock
add Mod3 = Mode_switch
add Mod4 = Super_L Super_R
add Mod5 = Scroll_Lock Hyper_R

Enabling Umlauts
================

by Enno Middelberg, 26Mar2003

To enable Umlauts by pressing the Windows key, vowel and '"', put this
in your .Xmodmap:

!!
!! Xmodmap: Some Settings for a standard PC key board
!!
!! Note: the scan codes of the keys (keycode) used here
!! are specific for PC key boards.
!!
!! by werner 1993, 1997, 1998

!! enables use of German Umlauts using the left Windows key

keycode 115 = Multi_key

Skype on openSuSE 10.3 x86_64

2008-01-31T01:02:00.000-08:00

Install these libraries

libsigc++2-32bit-2.0.18-3.x86_64.rpm
libqt4-32bit-4.3.1-23.x86_64.rpm
libqt4-dbus-1-32bit-4.3.1-23.x86_64.rpm
libqt4-x11-32bit-4.3.1-23.x86_64.rpm

Check out this: http://forum.skype.com/index.php?showtopic=104670&st=0&p=476113&#entry476113
http://www.susebrasil.org/modules/newbb/viewtopic.php?topic_id=28&forum=2&post_id=81

This allows the installation.

The sound configuration on
Sony VAIO VGN-AR51SU:

Install the latest alsa software from this repository:
http://download.opensuse.org/repositories/multimedia:/audio/openSUSE_10.3_Update/

Download th corresponding alsa-lib sources from http://ftp.suse.com/pub/projects/
edit ./src/mixer/simple_none.c
--------------------------------------------------------
1492: /* err = -EINVAL; */
1493: goto __ignore;

1542: __ignore:
-------------------------------------------------------

./configure
make
cp /usr/lib64/libasound.so.2.0.0 /usr/lib64/libasound.so.2.0.0.ori
cp ./src/.libs/libasound.so.2.0.0 /usr/lib64/
ln -sf /usr/lib64/libasound.so.2.0.0 /usr/lib64/libasound.so
ln -sf /usr/lib64/libasound.so.2.0.0 /usr/lib64/libasound.so.2

Kmix -screens should show (something like) this:

Kmix -screens should show this:

This may vary when using the internal microphone!

/etc/modprobe.conf.local:
options snd-hda-intel enable=1 index=0 model=vaio

(=vaio is only an invalid model for alc262 but this makes thing work, strange...)

Set all skype sound devices to:
"HDA Intel (hw:Intel,0)"

Video configuration on Sony Vaio VGN-AR51SU
lsusb reports
Bus 005 Device 002: ID 05ca:1839 Ricoh Co., Ltd

To enable webcam support add this repository to the list of used repositories:
http://download.opensuse.org/repositories/drivers:/webcam/openSUSE_10.3/
Install from the repository above
r5u870
r5u870-kmp-default

Other software needed is listed in this restart script, which should be used to restart the video system in
case of wrong colour maps etc.
---------------------------------------------------------------------
modprobe -r uvcvideo

modprobe -r r5u870
modprobe -r v4l2-common
modprobe -r v4l1-compat
modprobe -r video-buf
modprobe -r sony-laptop
modprobe -r videodev
modprobe -v videodev
modprobe -v sony-laptop camera=1
modprobe -v video-buf
modprobe -v v4l1-compat
modprobe -v v4l2-common
modprobe -v r5u870

modprobe -v uvcvideo
--------------------------------------------------

openSuse 10.3 USB automount

2007-12-07T11:21:00.000-08:00

Symptom: usb automount not working
Try to check/remove ~/.kde/share/config/medianotifierrc
But it stopped working again...

VMWare Converter error

2007-12-05T00:51:00.001-08:00

Symptom: VMWare Converter (3.01 buil 44840) fails after step "Source Login" with some unspecific error message.
Workaround: Create a folder c:\Temp
and create (or modify) the environment variables "TMP" and "TEMP" to point
to the created directory.
See also this page (in Spanish) "http://ssinyol.wordpress.com/2007/05/31/vmware-converter-301-runtime-error/"

ora_rowscn and oracle 11.1.0.6.0/Linux

2007-11-27T22:26:00.000-08:00

Symptom: code does not compile when using ora_rowscn in joins.
Sulution: Download the patch .6168363 by Metalink and install it as described in the readme file
More:

REDISCOVERY INFORMATION:
If you see a dump in phf_copy_to_diana and the PL/SQL unit being compiled
contains a SQL statement as described in the problem description and
simple test case.
@
WORKAROUND:
Change the order of the tables in the join so the pseudo column or built in
is called on the first table in the join.
@
RELEASE NOTES:
]]Compilation of PL/SQL units with SQL statements that involve joins and
]]references to pseudo columns or zero argument built in functions may
]]fail in some circumstances.

A patch 6168363 has been created for Linux x86
Patch 6168363 is also available for Linux x86_64

Code to test this:
If procedure compiles OK then the patch is applied/not needed
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DROP TABLE c1;
DROP TABLE l1;
CREATE TABLE c1 (r1 VARCHAR2(11));
CREATE TABLE l1 (r1 VARCHAR2(11));
INSERT INTO c1 VALUES('ABC');
INSERT INTO l1 VALUES('ABC');
COMMIT;

CREATE OR REPLACE PROCEDURE TEST_SCN IS
v_scn NUMBER;
v_r1 VARCHAR2(11);
BEGIN

SELECT l1.ora_rowscn
INTO v_scn
FROM
c1,
l1
WHERE c1.r1 = l1.r1
AND c1.r1 ='ABC';
END TEST_SCN;
/

Lotus Notes: port forwarding

2007-11-08T11:48:00.001-08:00

the port for lotus notes port forwarding is: 1352!

Disk layout with seagate 120GB origin

2007-10-07T06:41:00.000-07:00

sfeger:~ # sfdisk -sl
/dev/hda: 244198584

Disk /dev/hda: 30401 cylinders, 255 heads, 63 sectors/track
Units = cylinders of 8225280 bytes, blocks of 1024 bytes, counting from 0

Device Boot Start End #cyls #blocks Id System
/dev/hda1 * 0+ 1565 1566- 12578863+ 7 HPFS/NTFS
/dev/hda2 1566 1826 261 2096482+ 82 Linux swap / Solaris
/dev/hda3 1827 14592 12766 102542895 83 Linux
/dev/hda4 14593 30400 15808 126977760 f W95 Ext'd (LBA)
/dev/hda5 14593+ 30400 15808- 126977728+ 83 Linux
/dev/sdc: 156290904

Disk /dev/sdc: 19457 cylinders, 255 heads, 63 sectors/track
Units = cylinders of 8225280 bytes, blocks of 1024 bytes, counting from 0

Device Boot Start End #cyls #blocks Id System
/dev/sdc1 * 0+ 1565 1566- 12578863+ 7 HPFS/NTFS
/dev/sdc2 1566 1826 261 2096482+ 82 Linux swap / Solaris
/dev/sdc3 1827 14592 12766 102542895 83 Linux
/dev/sdc4 14593 19456 4864 39070080 83 Linux
total: 400489488 blocks

OpenSuse 10.3 RC1 and bcm43xx

2007-10-01T12:35:00.000-07:00

1. check out http://en.opensuse.org/SDB:Broadcom_%28BCM4306%29_WLAN_Installation_under_SUSE
for installation instructions.
2. Remove nonsense information from /etc/udev/rules.d/70-persistent-net.rules
(to enable a wlan0 interface istead of ethx)

Only tested for ndiswrapper

Oracle 11g installation on OpenSuse 10.3 RC1xlib.lock error

2007-09-28T14:40:00.000-07:00

Installer errors
(
java: xcb_xlib.c:52: xcb_xlib_unlock: Assertion `c->xlib.lock' failed.
)
can be avoided by

1. sed -i 's/XINERAMA/FAKEEXTN/g' /usr/lib/jvm/java-1.5.0-sun-1.5.0_update12/jre/lib/i386/xawt/libmawt.so
(saving the original libmawt.so before doing this is maybe a good idea)
2. /orainst/runInstaller -jreLoc /usr/lib/jvm/java-1.5.0-sun-1.5.0_update12/jre
3. sed -i 's/XINERAMA/FAKEEXTN/g' $ORACLE_HOME/jdk/jre/lib/i386/xawt/libmawt.so
(this suppresses the error when using dbca)
4. when using dbca:
Try to type several time "return" in the terminal window if dbca is not responding
Enterprise manager configuration should be disabled when creating a database
5.emca -config dbcontrol db
This configures enterprise manager for the database (as we see this was not working in the previous step) If errors about missing free ports are shown than temprary change to /etc/hosts can help
(
127.0.0.1 localhost
#xxx.xxx.xxx.xxx hostname.domain hostname
127.0.0.1 hostname.domain hostname
)
Change this back after emca has succeeded.

More:

[Xcb] Workarounds for locking assertions in Sun Java 1.5 and 1.6

Josh Triplett josh at freedesktop.org
Fri Jun 1 18:23:34 PDT 2007

Previous message: [Xcb] Processed: Re: Bug#426715: 100_sloppy_lock.diff missing from libxcb 1.0-3
Next message: [Xcb] Bug#402165: Workarounds for locking assertions in Sun Java 1.5 and 1.6
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

tags 402165 + patch
tags 414535 + patch
thanks

I worked with jcristau and christoph4 via IRC on #debian-x, and we managed to
track down the problem with broken locking in Sun Java 1.5 and 1.6.  It only
occurs if Java finds the Xinerama extension, at which point it does something
broken with locking and triggers the assertion.  If Java never finds the
Xinerama extension, it doesn't trigger the assertion for broken locking.

The following workarounds address this problem:

For sun-java5-bin:
sed -i 's/XINERAMA/FAKEEXTN/g' /usr/lib/jvm/java-1.5.0-sun-1.5.0.11/jre/lib/i386/xawt/libmawt.so

For sun-java6-bin:
sed -i 's/XINERAMA/FAKEEXTN/g' /usr/lib/jvm/java-6-sun-1.6.0.00/jre/lib/i386/xawt/libmawt.so

The same fix (applied to the appropriate file) might work for other
proprietary JDKs.

Would the Debian maintainers of sun-java5-bin and sun-java6-bin please
consider applying these workarounds to the packages, to avoid locking
assertion failures when libx11-6 with Xlib/XCB enters unstable?

- Josh Triplett

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://lists.freedesktop.org/archives/xcb/attachments/20070601/09b55dd3/attachment.pgp

Previous message: [Xcb] Processed: Re: Bug#426715: 100_sloppy_lock.diff missing from libxcb 1.0-3
Next message: [Xcb] Bug#402165: Workarounds for locking assertions in Sun Java 1.5 and 1.6
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the Xcb mailing list

Maybe this resolves the problem as well!
One point of the movie perhaps warrants specific mention: I deliberately show you that simply launching Oracle's installer causes a new and rather odd java locking error. The cure for that is to set the delightfully-named LIBXCB_ALLOW_SLOPPY_LOCK environment variable to 1... after which the Java stuff all works as advertised.

Check also this site:
http://www.dizwell.com/prod/node/1033