topic OPatch java-exception with 9.2.0.5 in Operating System - HP-UX

OPatch java-exception with 9.2.0.5

Volker Borowski — Tue, 15 Jun 2004 02:56:44 GMT

Hi,

have installed OPatch Version 43 and 48.
Both versions did work (i.e. lsinventory) with 9.2.0.4.

Patched 9.2.0.5 (and oui 10.1 as required).
Now both OPatch versions (43 and 48) throw java-eceptions for a DATE-Format issue.

sInstallTime = >2003.Nov.11 14:34:37 MET<
java.text.ParseException: Unparseable date: "2003.Nov.11 14:34:37 MET"

Well, it is pretty clear, that the dots are the Problem, but how to reformat that field ?

Environment LANG=en_US

Ideas welcome.
Metalink and SAPNET have nothing on this.
Call is open, but may be you guys are quicker :-)

Thanks
Volker

Re: OPatch java-exception with 9.2.0.5

Eric Antunes — Tue, 15 Jun 2004 06:04:43 GMT

See your nls_date_format. It should be set to something like this (with - and not .):

nls_date_format = DD-MON-RRRR

Re: OPatch java-exception with 9.2.0.5

Eric Antunes — Tue, 15 Jun 2004 06:07:08 GMT

Sorry, I forgot to tell you where you can see nls_date_format: it is set on init.ora ($ORACLE_HOME/dbs/init.ora on 8i)

Re: OPatch java-exception with 9.2.0.5

Eric Antunes — Tue, 15 Jun 2004 06:18:31 GMT

One more thing,

On Metalink they say to apply patch 2370146 (see Note 199271.1)

Re: OPatch java-exception with 9.2.0.5

Volker Borowski — Tue, 15 Jun 2004 06:22:05 GMT

Hi,

thanks for the suggestion.
Basicly the databas is not up and running while applying a bugfix, so no init.ora Parameter will change anything.

Nevertheless, I tried out to use NLS_TIMESTAMP_TZ_FORMAT in the environment, but it appears, that OPatch does not use any NLS.. environments.

This looks like a JAVA problem for me, and I suspect some locale <-> LANG problem, but locale en_US is installed, LANG set accordingly, and this User has never run anything diffrent than en_US.

More Ideas ?
Volker

Re: OPatch java-exception with 9.2.0.5

Eric Antunes — Tue, 15 Jun 2004 06:22:33 GMT

I've searched Metalink with the expression:

java.text.ParseException: Unparseable date

And got 3 matches:

Notes 199271.1, 243100.1 and 221410.1

Re: OPatch java-exception with 9.2.0.5

Sanjay Kumar Suri — Tue, 15 Jun 2004 06:32:36 GMT

Hello Volker

Recently we did an upgrade. Look at the attached document (if it helps).

sks

Re: OPatch java-exception with 9.2.0.5

Volker Borowski — Tue, 15 Jun 2004 06:46:03 GMT

Antunes:

I found those notes also. None of them is related to the use of OPatch, as far as I see.

Sanjay:

Nice Document. I am right in the middle, and prior updateing the system-tables, I need to apply two bugfixes.

Volker

Re: OPatch java-exception with 9.2.0.5

Eric Antunes — Tue, 15 Jun 2004 06:58:45 GMT

Hi Volker,

Yes, they aren't related with OPatch...

Have you seen bug 3558215? This is the only document I see on Metalink about your issue...

Re: OPatch java-exception with 9.2.0.5

Volker Borowski — Tue, 15 Jun 2004 07:33:02 GMT

... yes, that is exactly my problem.
Shows me that one has to check "bug database" in addition on advanced search :-)

Unfortunately no solution....

Volker

Re: OPatch java-exception with 9.2.0.5

Eric Antunes — Tue, 15 Jun 2004 08:43:08 GMT

That's why I don't like to be at the most recent techonology: there is always a bug you are going to find and help to resolve...

Re: OPatch java-exception with 9.2.0.5

Volker Borowski — Tue, 29 Jun 2004 09:06:31 GMT

Got a fix !

Looks like either OUI 10 or 9.2.0.5 delivers a new JRE and OPatch does not check this first. So a wrong version is taken.

In my case I needed to specify the new jre-dir to OPatch as well.
This is SAP-Environment, so please check diverting ORACLE_HOME/.... paths in your case:

opatch lsinventory -jre /oracle/T53/920_64/jre/1.4.2/bin/

/oracle/T53/920_64 is my ORACLE_HOME in this case.

I have been informed that this should be fixed with OPatch Version 50.

Thanks
Volker

Re: OPatch java-exception with 9.2.0.5

Volker Borowski — Mon, 23 Aug 2004 11:31:46 GMT

... see above for solution.