Home » RDBMS Server » Security » How can i identify Patch no ? How it is differ from patchsets no (oracle 10g rhel5)
How can i identify Patch no ? How it is differ from patchsets no [message #581979] Fri, 12 April 2013 06:51 Go to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
Quote:
Every patch or patch set also has a patch number to identify it


All patch and patch set releases carry version numbers. 
For ex : Oracle 10g Release 10.2.0.1, then an available patch set might be 10.2.0.2 , .... , 10.2.4.0 , 10.2.5.0


My QUES is : How can i identify Patch no ? How it is differ from patchsets no ?

Thanks in advance .. Well explanation will be Appreciated ..
Re: How can i identify Patch no ? How it is differ from patchsets no [message #581991 is a reply to message #581979] Fri, 12 April 2013 07:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
opatch lsinventory


Regards
Michel
Re: How can i identify Patch no ? How it is differ from patchsets no [message #581994 is a reply to message #581991] Fri, 12 April 2013 08:00 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member

1. How can i identify Patch no ? How it is differ from patchsets no ?

Quote:
Do you understand my question ?


For ex : my db version is 10.2.4.0 ; (this is patchsets) where to get patch release no ?

Re: How can i identify Patch no ? How it is differ from patchsets no [message #581995 is a reply to message #581994] Fri, 12 April 2013 08:02 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
$ pwd
/u01/app/oracle/product/10.2.0/db_1

$ cd opatch
-bash: cd: opatch: No such file or directory

$ opatch lsinventory
-bash: opatch: command not found
Re: How can i identify Patch no ? How it is differ from patchsets no [message #581996 is a reply to message #581995] Fri, 12 April 2013 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
cd opatch


should be "cd OPatch", a simple "ls" would tell you.

Regards
Michel

[Updated on: Fri, 12 April 2013 08:12]

Report message to a moderator

Re: How can i identify Patch no ? How it is differ from patchsets no [message #581998 is a reply to message #581996] Fri, 12 April 2013 08:21 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
Hmm . I got first +ve reply from here ..

Thanks to my God. Thanks Michel

$ pwd
/u01/app/oracle/product/10.2.0/db_1/OPatch
$ ls
docs  emdpatch.pl  jlib  opatch  opatch.ini  opatch.pl


Where is patch relese no's here ?

I never seen here .. and you ..... ?
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582001 is a reply to message #581998] Fri, 12 April 2013 08:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute the command I told you!

Regards
Michel
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582005 is a reply to message #582001] Fri, 12 April 2013 08:50 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
$ Opatch lsinventory 
-bash: Opatch: command not found

$ opatch lsinventory 
-bash: opatch: command not found


not workable .....
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582013 is a reply to message #582005] Fri, 12 April 2013 09:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think, if you are unable to run an executable, you should then try to find another job or take a Unix/Linux course to get the basics but from the moment stay away from the server.

Regards
Michel

[Updated on: Fri, 12 April 2013 09:17]

Report message to a moderator

Re: How can i identify Patch no ? How it is differ from patchsets no [message #582014 is a reply to message #582005] Fri, 12 April 2013 09:18 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
Is Opatch lsinventory this not workable ?

- Please provide alternative command ..

SQL>select * from sys.registry$history;

no rows selected


Re: How can i identify Patch no ? How it is differ from patchsets no [message #582016 is a reply to message #582014] Fri, 12 April 2013 09:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
it works OK for me
[oracle@localhost OPatch]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /home/oracle/app/oracle/product/11.2.0/dbhome_2
Central Inventory : /home/oracle/app/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.1
OUI version       : 11.2.0.2.0
OUI location      : /home/oracle/app/oracle/product/11.2.0/dbhome_2/oui
Log file location : /home/oracle/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/opatch2013-04-12_07-27-12AM.log

Patch history file: /home/oracle/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /home/oracle/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2013-04-12_07-27-12AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1): 

Oracle Database 11g                                                  11.2.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@localhost OPatch]$ 


Re: How can i identify Patch no ? How it is differ from patchsets no [message #582019 is a reply to message #582016] Fri, 12 April 2013 09:36 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
Could you please execute and paste following query ..

SQL>select * from sys.registry$history;

Please it's my humble request ... Please BlackSwan
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582020 is a reply to message #582016] Fri, 12 April 2013 09:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but you you know that you have to prefix the executable by its path if it is not in your PATH variable. Razz
And other can even activate what they (should) have between the ears. Wink

Regards
Michel
icon9.gif  Re: How can i identify Patch no ? How it is differ from patchsets no [message #582021 is a reply to message #582020] Fri, 12 April 2013 09:50 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
I got o/p for $ ./opatch lsinventory command.

And i don't have any o/p for SQL STAT ; select * from sys.registry$history;

and one more michel My Ques is

" How can i identify patch release no ? How it's differ from patchsets no's?

- but you are saying something different.

I mean , If my version is 10.2.0.1 means => This is patchsets release no.

Quote:
How can i identify patch release no for my existing installation.


Why do you refuse to answer my simple question ? Sad


Re: How can i identify Patch no ? How it is differ from patchsets no [message #582023 is a reply to message #582021] Fri, 12 April 2013 10:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you refuse to execute the command that gives you the answer better than I do?
You are unable to understand our answer, so leave it and start something else.


I do NOT spoonfeed people, I'm expecting they have a little more intelligence and understanding than a slug.

Regards
Michel
Tell me and I'll forget; show me and I may remember; involve me and I'll understand

[Updated on: Fri, 12 April 2013 10:01]

Report message to a moderator

Re: How can i identify Patch no ? How it is differ from patchsets no [message #582024 is a reply to message #582023] Fri, 12 April 2013 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition your question was (but it seems you have not more memory than a fish):

Quote:
How can i identify Patch no ? How it is differ from patchsets no ?


And my answer DID answer your question.

Regards
Michel
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582026 is a reply to message #582023] Fri, 12 April 2013 10:08 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member

Oh! I'm n't expecting spoonfeed from anyone.

If i get answer via GooGlE .. Why should i ask ?

Regarding patches .. Google also not answered.

Quote:
I'm expecting they have a little more intelligence


- If i am ask basic questions , Please don't assume "FOOL"

By experience , Everyone is learning !

Every time i'm getting -ve replies only except answers ..

Thanks a lot !
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582027 is a reply to message #582026] Fri, 12 April 2013 10:20 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
Please understand patches are handled by seniors only including MOS(metalink).

What's the need to compare intelligent or spoonfeed ?

I am relly expecting atleast +ve replies

Quote:
Some patches are for software only and some affect both software and database.


1. If  my database  needs  patch, how can I identify  ?
2. If  my oracle software  needs  patch, how can I identify ?
3. How can I identify my database needs PSU patch or CPU  patch ? 


Please don't ignore to answer my questions ..

[Updated on: Fri, 12 April 2013 10:21]

Report message to a moderator

Re: How can i identify Patch no ? How it is differ from patchsets no [message #582028 is a reply to message #582027] Fri, 12 April 2013 10:42 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
Can i get answers ?
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582031 is a reply to message #582028] Fri, 12 April 2013 11:01 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
Thanks to ORAFAQ !

I feel happy it's really unforgettable experience in my life with this FORUM !

Thanks members !
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582032 is a reply to message #582031] Fri, 12 April 2013 11:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We owe you nothing.
You don't want or are unable to read us, so no forum will can help you.
If you DEMAND answers to your questions just call Oracle and pay for it.

Regards
Michel
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582037 is a reply to message #582032] Fri, 12 April 2013 12:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Patch application is based upon corporate policy.
Some organizations maintain that patches must be kept up to date.
Other organizations operate under the premise that if it is not broken, then apply no patches; since a few patches have been known to cause problems.
There is no one rule that covers every situation regarding patches.
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582043 is a reply to message #582037] Fri, 12 April 2013 12:47 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
If you DEMAND answers to your questions just call Oracle and pay for it.

Quote:
If i demand anything , please provide any statement paste here ..


Can't , because i am asking normally. Michel started to talk about spoonfeed , knowledge ..

ORAFAQ FORUM purpose is to help others (If folks struggling to understand Oracle).

I asked very very basic question , Already i put it Google search .. No more answer .. So i am asking here ..

   If you want relly help me , Please answer  .. ( If Not interest , leave it ).

[Updated on: Fri, 12 April 2013 12:49]

Report message to a moderator

Re: How can i identify Patch no ? How it is differ from patchsets no [message #582053 is a reply to message #582043] Fri, 12 April 2013 14:58 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
When applying patch what exactly happens inside database ?
When applying patchsets what exactly happens inside database ?

Quote:
Whichone is affets oracle binary or oracle_home ?
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582057 is a reply to message #582053] Fri, 12 April 2013 15:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>When applying patch what exactly happens inside database ?

DML

>When applying patchsets what exactly happens inside database ?

DML
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582059 is a reply to message #582057] Fri, 12 April 2013 15:14 Go to previous messageGo to next message
rsb.oracle
Messages: 37
Registered: April 2013
Location: Chennai
Member
What DML ?

Not able to understand.

Did anyone affect oracle binary or $oraclehome ?



Re: How can i identify Patch no ? How it is differ from patchsets no [message #582060 is a reply to message #582059] Fri, 12 April 2013 15:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+DML
Re: How can i identify Patch no ? How it is differ from patchsets no [message #582064 is a reply to message #582059] Fri, 12 April 2013 15:25 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: Patch official document link
Next Topic: Is it possible to get a list of tables on which Audits are enabled
Goto Forum:
  


Current Time: Fri Mar 29 04:21:39 CDT 2024