Upgrading oracle8.1.6 database to 8.1.7.2.0 under Oracle Applications 11i

[Shahbaz_1]

Hi,
- database instance is running under oracle 8.1.7.2.0.
I have to change the existing databae with old database which was under 8.1.6 binaries.

I copyied all 8.1.6 datafiles under 8.1.7.2.0 home and recreated the controlfile.
---- it successfully recreated the controlfile

Next I was trying to use odma, but hit with the following error

/u01/prod/proddb/8.1.7/odma[48]: /u01/prod/proddb/8.1.7/JRE/bin/jre: not found

please help....

Thanks in Adv

Regards
Shah

[T G Manikandan]

I think it is trying to bring up the GUI screen but it is unable to find the jre path.
check whether you have set the path of java variables in your oracle profile.

else download the JDK pack from here,install it and add it to your path and try executing the command.
http://www.hp.com/products1/unix/java/java2/sdkrte1_3/downloads/license_sdk_1-3-1-05.html

Thanks

[Shahbaz_1]

Thanks Manikandan,

How should I know, whether the sdk is already installed?

The one, which you are pointing to, is the correct version,
does the database version matters?

please let me know more about jre and the correct path etc.

Thanks & Regards

Shah

[T G Manikandan]

Just look for jre
by searching for jre

#find / -name jre -print

I have come across 1.1.8 version of jre during my oracle installation.
The version 1.3.1 version should be compatible for lower versions.

Thanks

[Shahbaz_1]

hi Manikandan,

When I find jre, it is there in the system in many location.
I think odma was looking for the jre, is not there in the path.
Now how to find out the correct jre version and put it into the PATH?

My oracle db ver is 8.1.7.2.0 serving oracle apps 11i.


please ...

Regards
Shahbaz

[T G Manikandan · Accepted solution]

I have it under my oracle home directory

/home/oracle/8.1.7/jre/1.1.8/bin/jre

Make sure when you type
#/home/oracle/8.1.7/jre/1.1.8/bin/jre

-doCloseWithReadPending close fds with readers, don't block
-cs -checksource check if source is newer when loading classes
-ss set the maximum native stack size for any thread
-oss set the maximum Java stack size for any thread
-ms set the initial Java heap size
-mx set the maximum Java heap size
-minf set the percentage of minimum free Java heap

It shows that the jre command is installed on this path.When you run it you can see different optiions like the above.

Then you can add it to your path like

PATH=$PATH:/home/oracle/8.1.7/jre/1.1.8/bin

Then it should be fine.
Please post out your results.

Thanks

[Shahbaz_1]

Sorry Manikandan,

I didn't find jre in the following location,

#/home/oracle/8.1.7/jre/1.1.8/bin/jre




Regard
Shah

[T G Manikandan]

It cannot be under that location because during the installation I chose that location.It must be somewhat in a different location.
Find it out and add it to your path.

Thanks

[Shahbaz_1]

Hi,

When I try to use odma, it comes out with the error,

/u01/prod/prodb/8.1.7/bin/odma [48] : /u01/prod/prodb/8.1.7/JRE/bin/jre: not found,

so it is looking for jre in /u01/prod/prodb/8.1.7/JRE/bin/jre, but I specified diff location in the PATH

like export PATH=/u01/j817/1.8.1/bin:$PATH

but still it is looking into the old path?

where to change? so that the odma should search in =/u01/j817/1.8.1/bin for jre

Regards
Shah

[T G Manikandan]

you can just do a

$which jre
to find which path it is looking into.
If you find some other path remove that specific entry from the variable and
add this path to the path variable.

PATH=$PATH:/u01/...
export PATH

again do a which jre to find that it is picking the right path

Another thing is that ,please do not assign 8,9.or 10 points for the answer that had not solved your problem.
Because when you have a rabit gif (magical solution) on your post,forum members do not open it for to reply.


THanks