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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s