Thursday, May 15, 2014

Different errors while changing dbid during clone


            
  •  NID-00106: LOGIN to target database failed with Oracle error:
  •  ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

NID-00106  followed by  ORA-12514 occurs If tnsname.ora does not have entry for both Rac database nodes. put entry in tnsname.ora for both database nodes
  •         NID-00106: LOGIN to target database failed with Oracle error:
  •         ORA-01031: insufficient privileges

        If password file is not present in $ORACLE_HOME/dbs directory we will get this error.
         Create password file using command "orapwd".


               orapwd  file=file_name   password=password 

Place the password file on both nodes  in directory $ORACLE_HOME/dbs .           
  •              NID-00131: Control file is not current

          After control file creation during clone database was not open with reset logs. Open database     with reset logs and change dbid.
       
  •          NID-00600: Internal Error - [17] [1] [0] [0]

       Check status of all table space in a  database, one of them is in offline mode.
       change the status of tablespace from offline to online and then change the dbid.


No comments:

Post a Comment