Upgrade Oracle 10.2.0.2 to 10.2.0.4

I don't have access to the patchset or to the readme file. Is it possible to get it from somewhere else?

I navigated to the oracle/product/10.2.0.4 location. I don't see any readme file placed there. Is there any way to get it from different source?

This is a practice project. I am learning.

Can I get the README.html file without having access to the metalink?

Thanks

Maybe the question itself needs clarification.


Are you trying to upgrade the oracle software from 10.2.0.2 to 10.2.0.4?
or
Are you trying to upgrade a 10.2.0.2 database to 10.2.0.4 and you already have the 10.2.0.4 software installed?

mrjoltcola is correct, you need to be licensed to get the 10.2.0.4 software

However, if you already have a 10.2.0.4 oracle home then it seems you already have it installed and you are in scenario 2.

It is upgrading the oracle software.
It is in a lab environment. I am trying to switch my position from a QA tester to a junior dba. I have been given the task to complete. The software is licensed. The pacth(10.2.0.4) is licenced. I had 2 lines of email which I mentioned in my question.
 I don't want to ask too many question to my tech lead. I want to complete this by myself. That is why I appeared before you all.
Thanks

if you already have a 10.2.0.4 home, it looks like you already have upgraded
there's nothing for you to do.

>> I don't want to ask too many question to my tech lead

The first step to learn as a junior DBA is when installing Oracle patches, you use the documentation for that patch _everytime_. So if you don't have that, you aren't really doing it the approved way.

I'm not sure who gave you the 10.2.0.4 version, but I always download from Metalink and review the README and release docs with that patch.

So I am not trying to be difficult with you, but if you are trying to learn, this is the way it is done.

Thanks.
After paying good attention to the mail I received I find it is updating the db not the software:
Here is the mail:
Database D101PROD is currently version 10.2.0.2; please upgrade it to Version 10.2.0.4.
The $ORACLE_HOME with 10.2.0.4 binaries is /oracle/product/10.2.0.4
So it is updating the db not the software. How can I procede?

sdstuber,
scenario 2 is the case. Any guidence, please!

Thanks

Yes, I read the contents in the link. Nothing has been mentioned there about the environment variables.
 I have collected a document which has some steps as follows:
Line # 1 - 3 were in the link and in my document as well.
1.  SQL> Spool  upgrade_info.log  
2.  SQL> @?/rdbms/admin/utl102i.sql
3. spool Off
Check the log file upgrade_info.sql for any issues needs to be addressed before proceeding.
Line # 4 & 5  are not in the link. These are in my document.

4. Set environment initially to the current(old) Oracle Home of the instance to be upgraded:
            $ . oraenv
5. Verify that all environment variables correctly point to the current (old) Oracle Home directory:
            $ env
6.  Logon as sysdba, Shutdown Immediate and exit from SQL prompt

7. Update database instance environment settings to the newer set of Oracle binaries:
          $vi /var/opt/oracle/oratab
8. Set environment to database instance again to take the updated values:
         $ . oraenv
9. verify that all environment variables now correctly contain the new $ORACLE_HOME directory:
         $ env
     Note: this is a very improtant step to ensure that patching goes smoothly, so double click the environment variables very carefully.
My Questions:

# 4 and 5 should already be the current (old) env variables. How do I set them again?
# 5 says "all env....variabls" - what are all?
# 7 - How do I change the oratab file and what changes need to be there?
# 9 - Do i change all the env varbls by exporting those? And see them in the $ env?

Thanks

Please give me some  hint on changing the variables in oratab file, reloading the variables value using . oraenv....
Do I have to change the ORACLE_HOME value in the .profile file and than reload the new value using the . oraaenv?
Any information about the env will be helpful

Thanks

I have
M101PROD:/oracle/product/10.2.0.2:Y

Do I have to change it to ....../10.2.0.4 in order to upgrade the db to 10.2.0.4?

Thanks

Yes, /etc/oratab should have the correct Oracle home path set for each instance.

Thanks.
One more question:
When I use the env command I see that there are values for AGENT_HOME, OHLIB_PATH, LD_LIBRARY_PATH, OH, ORA_NLS10, ORA_NLS33, ORA_NLS, PATH and all the values contain 10.2.0.2.
I need to change the env in all places where there is references to 10.2.0.2.
The question is "How do I change the values to 10.2.04?"
Do I change the .profile file (I am using kron shell)? Will all changes take place if I change the .profile file?
Please let me know how can I change all variables to reflect the new value of 10.2.0.4.

Thanks a lot again.