General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Shahbaz_1
Regular Advisor

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

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

Let's share the great thing "THE KNOWLEDGE"
9 REPLIES
T G Manikandan
Honored Contributor

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

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
Regular Advisor

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

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
Let's share the great thing "THE KNOWLEDGE"
T G Manikandan
Honored Contributor

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

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
Regular Advisor

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

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
Let's share the great thing "THE KNOWLEDGE"
T G Manikandan
Honored Contributor
Solution

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

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
Regular Advisor

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

Sorry Manikandan,

I didn't find jre in the following location,

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




Regard
Shah




Let's share the great thing "THE KNOWLEDGE"
T G Manikandan
Honored Contributor

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

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
Regular Advisor

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

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
Let's share the great thing "THE KNOWLEDGE"
T G Manikandan
Honored Contributor

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

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