Easy Methods to Find Out Oracle 9i 10g 11g DBID

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Method 1 From v$database;
SQL> select dbid from v$database;

      DBID
----------
 576655928

Method 2 Using RMAN
$ rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Tue Sep 6 12:18:18 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: PRMRFST1 (DBID=576655928)

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer