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

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)
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google