NID-00135: There are 1 active threads
Cause:
NID utility throw the below error due to freshly installed database and threads are not open
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1509949440 bytes
Fixed Size 2924640 bytes
Variable Size 973082528 bytes
Database Buffers 520093696 bytes
Redo Buffers 13848576 bytes
Database mounted.
[oracle@dpprod ~]$ nid target=/ dbname=dpprod
DBNEWID: Release 12.1.0.2.0 - Production on Mon Oct 25 11:50:08 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to database DPTEST (DBID=105685757)
NID-00135: There are 1 active threads
Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.
Workaround:
Startup open the thread first and again start the database in mount
SQL> startup;
ORACLE instance started.
Total System Global Area 1509949440 bytes
Fixed Size 2924640 bytes
Variable Size 973082528 bytes
Database Buffers 520093696 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1509949440 bytes
Fixed Size 2924640 bytes
Variable Size 973082528 bytes
Database Buffers 520093696 bytes
Redo Buffers 13848576 bytes
Database mounted.
NID is working
[oracle@dpprod ~]$ nid target=/ dbname=dpprod
DBNEWID: Release 12.1.0.2.0 - Production on Mon Oct 25 11:55:44 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to database DPTEST (DBID=105685757)
Connected to server version 12.1.0
Control Files in database:
/u01/app/oracle/oradata/dptest/control01.ctl
/apps01/FRA/dptest/control02.ctl
Change database ID and database name DPTEST to DPPROD? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 105685757 to 4107286976
Changing database name from DPTEST to DPPROD
Control File /u01/app/oracle/oradata/dptest/control01.ctl - modified
Control File /apps01/FRA/dptest/control02.ctl - modified
Datafile /u01/app/oracle/oradata/dptest/system01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/dptest/sysaux01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/dptest/undotbs01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/dptest/example01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/dptest/users01.db - dbid changed, wrote new name
Datafile /u01/app/oracle/oradata/dptest/temp01.db - dbid changed, wrote new name
Control File /u01/app/oracle/oradata/dptest/control01.ctl - dbid changed, wrote new name
Control File /apps01/FRA/dptest/control02.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to DPPROD.
Modify parameter file and generate a new password file before restarting.
Database ID for database DPPROD changed to 4107286976.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.