cancel
Showing results for 
Search instead for 
Did you mean: 

what command line to use to know database patch level

Former Member
0 Kudos

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...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Its always Better to Use optach lsinventory to know the patch Level..I agree with Eric.

Regards,

Ershad Ahmed.

Answers (3)

Answers (3)

Former Member
0 Kudos

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..

former_member204746
Active Contributor
0 Kudos

use Opatch to get that:

Opatch lsinventory

Former Member
0 Kudos

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.