Follow below steps for changing the oracle database name using nid utility. We will change the database name from P2PRMD2 to P1D2ST.

1. Mount the database
SQL> STARTUP MOUNT

ORACLE instance started.

Total System Global Area 8754618368 bytes
Fixed Size                  4646288 bytes
Variable Size            3556776560 bytes
Database Buffers         5033164800 bytes
Redo Buffers              160030720 bytes
Database mounted.
SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
P2PRMD2   MOUNTED

2. Run the NID utility

SYNTAX – nid sys/password@CURRENT_DBNAME DBNAME=NEW_DBNAME

 

-bash-4.1$ nid target=sys/oracle@P1D2ST DBNAME=P1D2ST

DBNEWID: Release 12.1.0.1.0 - Production on Tue May 17 20:38:51 2016

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Connected to database P2PRMD2 (DBID=880632263)

Connected to server version 12.1.0

Control Files in database:
    /u02/oradata/P1D2ST/control01.ctl
    /u02/oradata/P1D2ST/control02.ctl

Change database ID and database name P2PRMD2 to P1D2ST? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 880632263 to 2286680027
Changing database name from P2PRMD2 to P1D2ST
    Control File /u02/oradata/P1D2ST/control01.ctl - modified
    Control File /u02/oradata/P1D2ST/control02.ctl - modified
    Datafile /u02/oradata/P1D2ST/system01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/sysaux01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/undotbs01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/users01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/siebel_oltp01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/siebel_oltp_indx01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/siebel_oltp02.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/siebel_oltp03.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/siebel_oltp_indx02.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/siebel_oltp04.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/smsresp.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/archival01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/seibeloltpupgindx01.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/B2CBIP_mds.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/B2CBIP_biplatform.db - dbid changed, wrote new name
    Datafile /u02/oradata/P1D2ST/DUNNING01.db - dbid changed, wrote new name
    Control File /u02/oradata/P1D2ST/control01.ctl - dbid changed, wrote new name
    Control File /u02/oradata/P1D2ST/control02.ctl - dbid changed, wrote new name
    Instance shut down

Database name changed to P1D2ST.
Modify parameter file and generate a new password file before restarting.
Database ID for database P1D2ST changed to 2286680027.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.


3. change the db_name parameter in the parameter file.
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 8754618368 bytes
Fixed Size                  4646288 bytes
Variable Size            3556776560 bytes
Database Buffers         5033164800 bytes
Redo Buffers              160030720 bytes
SQL> alter system set db_name=P1D2ST scope=spfile;

System altered.

SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL>
SQL>
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 8754618368 bytes
Fixed Size                  4646288 bytes
Variable Size            3556776560 bytes
Database Buffers         5033164800 bytes
Redo Buffers              160030720 bytes
SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      P1D2ST
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.

4. Rename the spfile to new db name

cp spfileP2PRMD2.ora spfileP1D2ST.ora

-bash-4.1$ export ORACLE_SID=P1D2ST
-bash-4.1$ s

SQL*Plus: Release 12.1.0.1.0 Production on Tue May 17 20:42:26 2016

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

Connected to an idle instance.

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 8754618368 bytes
Fixed Size                  4646288 bytes
Variable Size            3489667696 bytes
Database Buffers         5100273664 bytes
Redo Buffers              160030720 bytes
SQL> alter database mount;

Database altered.


SQL>  alter database open resetlogs;

Database altered.

SQL> show parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (ADDRESS_LIST=(ADDRESS=(PROTOC
                                                 OL=TCP)(HOST=192.56.204.1)(POR
                                                 T=1525)))
log_archive_local_first              boolean     TRUE
parallel_force_local                 boolean     FALSE
SQL> alter system register;

System altered.