Upgrade 10gR2 (10.2.0.3) to 11gR1 (11.1.0.7): old timezone warning

By | January 30th, 2009|Categories: Database|

Upgrade 10.2.0.3 to 11.1.0.7. Used sources at the bottom of this post.

What I’ve got is a simple database, no fancy options. Version 10.2.0.3. – Suse Linux 10.1.-64-bit. Put a 11.1.0.6.-software tree next to it, and patched this to 11.1.0.7.

Started DBUA (whimp! 🙂 – Several warnings hit me, but 1 of them is serious: ‘old timezone file version’ :

[…]

Sun JRE instead of Jinitiator with Forms and Webutil

By | January 26th, 2009|Categories: App. Server|Tags: , , , , |

Running Forms and Webutil with Sun Java 5.0.6 instead of Jinitiator.

And you know what:  it’s faster and has more functionality I’ve been told…
First you need the java-file. In this case: jre15006.exe.

Initially I found it hard to find on the site of Sun – didn’t even know the name of the file I was looking for…
Found it at http://www.muangyacctv.com/download/JAVA but if you keep searching the Sun-website, you will find it here:

https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/ViewProduct
Detail-Start?ProductRef=jre-1.5.0_06-oth-JPR@CDS-CDS_Developer

Then: where shall I put the file? The application server expects the file in /forms/jinitiator.
In forms.conf this is defined as:
AliasMatch ^/forms/jinitiator/(..*) “/software/oracle/middle/jinit/$1”

Next thing is the configuration in formsweb.cfg (at the end of this post is the configuration what worked for me,
but first some explanation, quoted from some notes):

[…]

Linux-mail failed with "name service error"

By | January 26th, 2009|Categories: RAC|

And now for something quite different…. Some monitoring-scripts are  mailing to me, for example the backup-script (will do it later on in Grid Control….).  For a few nodes in the DMZ this didn’t work anymore. And actually I don’t want to know what is going on, but at the place I work there’s no Linux admin in the neighbourhood. So I can give it a try…

Appeared that the network-boys (no girls..) changed some configuration (mx-records or something like this).  Logging and “mailq” gave ‘Name service error’.

Suse 9, x64-bit.  Solution:

[…]

Tomcat 6.0.18-install /config on Suse 10.1 with Java 6.11 / 6.13

By | January 13th, 2009|Categories: App. Server|

Tomcat, installation / configuration 6.0.18 with Sun, connection with Oracle db.

Never worked before with Tomcat, but an application-release needed to be upgraded from the old Tomcat 4.x to a higher level. So why not 6.0.18 with the latest Java, on Suse 10.1, 64-bits. How hard can it be?

Somewhat different than Oracle application server, but what the hack. With thanks to Timo Schijf, developer.

[…]

Statspack.snap failed with ora-00001

By | January 7th, 2009|Categories: Database|

Out of the blue, 9.2.0.6-database on Sun-Sparc 64-bit:

SQL> exec statspack.snap
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
ORA-06512: at “PERFSTAT.STATSPACK”, line 1148
ORA-06512: at “PERFSTAT.STATSPACK”, line 2134
ORA-06512: at “PERFSTAT.STATSPACK”, line 72
ORA-06512: at line 1

Cause: bug 2784796 , fixed in 10G ……. Solution:

[…]

Database crash – ora-00822, MMAN process died.

By | January 5th, 2009|Categories: Database|Tags: |

Got a mail from my grid-control monitoring: database unavailable. After a very short look: database crashed. No changes made the last month. Version 10.2.0.4 on Suse Linux 10.1, 64-bit, on a VM (ESX).

Alert-log: ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+1] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [] Mon Dec […]

WordPress-blog upgraded to 2.7

By | January 5th, 2009|Categories: Wordpress|

Not an oracle topic this time. Sorry 😉

This blog is powered by WordPress, and I performed an upgrade to 2.7. and configured some plugins.
Prepared my upgrade, checked this site for example: http://lorelle.wordpress.com/2008/12/11/wordpress-27-upgrade-tips . So far the theory.

Here’s what I actually did:

[…]

Comments Off on WordPress-blog upgraded to 2.7