on 06-01-2007 11:44 AM
Hi Guys,
Can you help me waht are the exact command lines to use for an Oracle database in a UNIX system to know the database patch level.
Help me urgent please...
Its always Better to Use optach lsinventory to know the patch Level..I agree with Eric.
Regards,
Ershad Ahmed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks a lot for responding and helping me out. Anyways, for added information you can also read note 411068 about "Which Oracle patches/patch sets are already installed".. Thanks guys.. More power..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use Opatch to get that:
Opatch lsinventory
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jennah,
As ora<sid> user run:
<b>sqlplus -v</b>
If you just want to know the DB version/patch:
<b>sqlplus -v | awk '{print $3}'</b>
Best Regards,
JC Llanes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.