OraFAQ Forum: Windows » how to find oracle patch

Home » Infrastructure » Windows » how to find oracle patch

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

how to find oracle patch [message #551793]

Fri, 20 April 2012 13:38

priteshranjan.preet
Messages: 125
Registered: April 2012
Location: delhi

Senior Member

hi how can i find the oracle patch on os window. oracle 10.2.0.1

i m using
sql>opatch lsinventory but cant work.

thanks
pritesh ranjan

Report message to a moderator

Re: how to find oracle patch [message #551794 is a reply to message #551793]

Fri, 20 April 2012 13:47

Mahesh Rajendran
Messages: 10572
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

opatch lsinventory happens to be an OS command.
Not an SQL*plus command.

[Updated on: Fri, 20 April 2012 13:48]

Report message to a moderator

Re: how to find oracle patch [message #551841 is a reply to message #551794]

Sat, 21 April 2012 06:27

priteshranjan.preet
Messages: 125
Registered: April 2012
Location: delhi

Senior Member

when i m going to run oracle patch i get the following error.
Oracle Home is not set. opatch can not proceed.
opatch failed with error code=1.

i m running the following command
d:\> D:\oracle\product\10.2.0\db_1\OPatch\opatch.bat

if i m wrong then suggest me how can i proceed it.

i m also run the following
d:\> D:\oracle\product\10.2.0\db_1\OPatch\OPatch$ opatch lsinventory

but can't success.

thanks & regards
pritesh ranjan

Report message to a moderator

Re: how to find oracle patch [message #551842 is a reply to message #551841]

Sat, 21 April 2012 06:36

Mahesh Rajendran
Messages: 10572
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Oracle Home is not set. opatch can not proceed.
Set your ORACLE_HOME

In the command prompt

set ORACLE_HOME=yourOraclehome

cd to opatch directory.
opatch lsinventory to list the patches that are already applied.
http://docs.oracle.com/cd/B16240_01/doc/em.102/e15294/options.htm

[Updated on: Sat, 21 April 2012 06:36]

Report message to a moderator

Re: how to find oracle patch [message #551844 is a reply to message #551842]

Sat, 21 April 2012 07:06

Littlefoot
Messages: 16975
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Directories you posted, as well as opatch.bat suggest it is MS Windows, not Unix. So, which operating system do you use, really?

Report message to a moderator

Re: how to find oracle patch [message #551846 is a reply to message #551844]

Sat, 21 April 2012 07:53

priteshranjan.preet
Messages: 125
Registered: April 2012
Location: delhi

Senior Member

os window xp.
i m unsucessful to set the oracle home environment.
i see the oracle home directory from the registry.
start>program>run>regedit>heky_local_machine>software>oracle>key_oradb10g_home1
here i find the name and location related to oracle. then i set the oracle home on the command prompt like this.

D:\>set ORACLE_HOME=d:\oracle\product\10.2.0\db_1;

after that i run the command.
d:\> d:\oracle\product\10.2.0\db_1\OPatch\opatch lsinventory;
but now this the following error.
the system can not find the path specified.
file not found.
FINDSTR:can not open \oui\oraparam.ini
java could not be located.OPatch can not proceed!
OPatch failed with error code = 1;
i think my oracle home can not set properly but how can i do it.plz help me.

Report message to a moderator

Re: how to find oracle patch [message #551851 is a reply to message #551846]

Sat, 21 April 2012 09:01

Michel Cadot
Messages: 54187
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

cd  d:\oracle\product\10.2.0\db_1\OPatch
.\opatch lsinventory

Copy and paste the WHOLE dos session including SET result.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Regards
Michel

Report message to a moderator

Re: how to find oracle patch [message #551861 is a reply to message #551846]

Sat, 21 April 2012 11:18

John Watson
Messages: 3106
Registered: January 2010
Location: Global Village

Senior Member

When working in an OS shell, do not put semi-colons at the end of your commands.

Report message to a moderator

Re: how to find oracle patch [message #551883 is a reply to message #551861]

Sat, 21 April 2012 15:03

priteshranjan.preet
Messages: 125
Registered: April 2012
Location: delhi

Senior Member

thanks to all i do it successfully.
my mistake is that i put the semicolon(;) at last when i set the oracle_home it is wrong.but now it run successfully.

according to John Watson.

thanks & regards
pritesh ranjan

[EDITED by LF: disabled smilies in this message]

[Updated on: Sun, 22 April 2012 01:29] by Moderator

Report message to a moderator