Re: Query to find DB Version on Rman Catalog

My requirement is to query in RMAN CATALOG Database to find what are the db version has been registered to rman catalog database

Regards,

Naga

On Tue, Mar 24, 2009 at 2:03 AM, Ram Srinivasan <srinivasanram2004_at_gmail.com
> wrote:

> Nagaraj:
> $rman target /
>
>
> Recovery Manager: Release 10.1.0.5.0 - 64bit Production
>
> Copyright (c) 1995, 2004, Oracle. All rights reserved.
>
> connected to target database: XXCSER (DBID=3818643774)
>
> RMAN> exit
>
> Now you knwo what the target database is:
>
> Set your ORACLE_SID as export ORACLE_SID=XXCSER
>
> and login to the database as sysdba using sqlplus. Then you can query the
> v$version table. You cal also query the registry$history table or
> dba_registry_history table to get the latest patches applied.
>
>
>
> Ram Srinivasan
>
>
>
>
> On 3/20/09, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
>>
>> Hi Gurus,
>>
>>
>> I have different oracle database versions registered to my RMAN CATALOG
>> DATBASE. Is there any query to find What is the version of the database
>> registered to my RMAN CATALOG DATABASE?
>>
>>
>>
>> Regards,
>>
>> Naga
>>
>
>
>
> --
> Sincerely
> Ram Srinivasan

--
http://www.freelists.org/webpage/oracle-l