- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
NID tool hangs
I have problem with NID tool, i have executed nid TARGET=SYS/[email protected] in our 10.2.0.5 dev environment. Database is in mount state before i executed nid.
And it lists all database files with " - dbid changed " and it sopped on control file with same message near name.
DBNEWID: Release 10.2.0.5.0 - Production on Wed Nov 25 15:37:01 2020
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to database DEV (DBID=61663411)
Connected to server version 10.2.0
Control Files in database:
Change database ID of database DEV? (Y/[N]) => y
Changing database ID from 61665847 to 4135760874
Proceeding with operation
Datafile /data/oracle/DEV/db/a_txn_ind05.dbf - dbid changed
Datafile /data/oracle/DEV/db/a_ref02.dbf - dbid changed
Datafile /data/oracle/DEV/db/temp01.dbf - dbid changed
Control data/db/oracle/DEV/db/10.2.0/dbs/cntrlDEV.dbf - dbid changed
Database is big, but im not sure how long nid tool does DBID changes approximately? Currently im waiting hour and half to finish, and still waiting...