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

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

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

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

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

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

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

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

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

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

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

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

Java string to int

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

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

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:

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

Java plugin for Firefox x86_64

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