Online DBA

<<Back to Oracle DataGuard Main Page How to Resolve : ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added DGMGRL>  ADD DATABASE "ORCL3PS" AS CONNECT IDENTIFIER IS "ORCL3PS"; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added Cause: One of log_archive_dest_n parameter is set for service  ORCL3PS in either primary or standby or both databases Solution: Identify the log_archive_dest_n parameter which is set to value  ORCL3PS  and rest it. SQL> show parameter dest_4 log_archive_dest_4                   string      SERVICE=ORCL3PS.EU.MERCKGROUP.C                                                  OM DB_UNIQUE_NAME=ORCL3PS SQL> alter system set  log_archive_dest_4  =''; DGMGRL>  ADD DATABASE " ORCL3PS " AS CONNECT IDENTIFIER IS " ORCL3PS .EU.MERCKGROUP.COM"; Database " ORCL3PS " added

<<Back to DB Administration Main Page In this post NID utility is used to change both database name together with DBID About NID and its Syntax: NID utility is used to change Database Name , Database Identifier (DBID) both or just any one of them. You can invoke the command as below as user oracle after setting the environment of the database you want to work on. Change DB Name as well as DBID $nid TARGET=SYS DBNAME=TEST1D Change DB Name  Only $nid TARGET=SYS DBNAME=TEST1D SETNAME=YES Check out the post How to Rename Oracle Database Using NID Utility if want to change the database name only. Change DBID Only $nid TARGET=SYS  $nid help=y DBNEWID: Release 11.2.0.4.0 - Production on Mon Mar 2 11:29:26 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Keyword            Description                                   (Default) ---------------------------------------------------- TARGET           Username/P