Home » RDBMS Server » Backup & Recovery » NID- utility giving ora-01103 error (Oracle 10.2.0.1.0 windows 2003 server)
NID- utility giving ora-01103 error [message #425726] Mon, 12 October 2009 00:53 Go to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi please sugget me on this issue.
Z:\>set oracle_sid=kalyani

Z:\>nid

DBNEWID: Release 10.2.0.1.0 - Production on Mon Oct 12 11:11:43 2009

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

Keyword     Description                    (Default)
----------------------------------------------------
TARGET      Username/Password              (NONE)
DBNAME      New database name              (NONE)
LOGFILE     Output Log                     (NONE)
REVERT      Revert failed change           NO
SETNAME     Set a new database name only   NO
APPEND      Append to output log           NO
HELP        Displays these messages        NO


Z:\>sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 12 11:12:36 2009

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

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247876 bytes
Variable Size              83887484 bytes
Database Buffers           75497472 bytes
Redo Buffers                7139328 bytes
Database mounted.
SQL> select name from v$database;

NAME
---------
KALYANI

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
kalyani

SQL> host nid target=sys/tejajun20 dbname=mallik

DBNEWID: Release 10.2.0.1.0 - Production on Mon Oct 12 11:16:08 2009

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

Connected to database KALYANI (DBID=4102920684)

Connected to server version 10.2.0

Control Files in database:
    C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL01.CTL
    C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL02.CTL
    C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL03.CTL

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

Proceeding with operation
Changing database ID from 4102920684 to 1121083962
Changing database name from KALYANI to MALLIK
    Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL01.CTL - modified
    Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL02.CTL - modified
    Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL03.CTL - modified
    Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\SYSTEM01.DBF - dbid changed, wrote new name
    Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\UNDOTBS01.DBF - dbid changed, wrote new name
    Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\SYSAUX01.DBF - dbid changed, wrote new name
    Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\USERS01.DBF - dbid changed, wrote new name
    Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\EXAMPLE01.DBF - dbid changed, wrote new name
    Datafile C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\TEMP01.DBF - dbid changed, wrote new name
    Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL01.CTL - dbid changed, wrote new name
    Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL02.CTL - dbid changed, wrote new name
    Control File C:\ORACLE\PRODUCT\10.2.0\ORADATA\KALYANI\CONTROL03.CTL - dbid changed, wrote new name
    Instance shut down

Database name changed to MALLIK.
Modify parameter file and generate a new password file before restarting.
Database ID for database MALLIK changed to 1121083962.
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.


SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> conn sys / as sysdba
Enter password:
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247876 bytes
Variable Size              83887484 bytes
Database Buffers           75497472 bytes
Redo Buffers                7139328 bytes
ORA-01103: database name 'MALLIK' in control file is not 'KALYANI'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted

SQL>


How can i recover my database.

Regards
Sriram.

Re: NID- utility giving ora-01103 error [message #425754 is a reply to message #425726] Mon, 12 October 2009 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to also change the name in pfile/spfile.

It is a BAD idea to use nid when connected to the database.
Exit from SQL*Plus before doing this.

Regards
Michel
Re: NID- utility giving ora-01103 error [message #425764 is a reply to message #425754] Mon, 12 October 2009 02:42 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks michel...renamed spfile and opened the database with resetlogs options its working now.

Regards
Sriram Smile
Re: NID- utility giving ora-01103 error [message #506023 is a reply to message #425764] Fri, 06 May 2011 03:35 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
hey i have also this same error and i also follow this all steps as u follow..ok can u tell me how can u change your this spfile name can u give me this steps
Re: NID- utility giving ora-01103 error [message #506027 is a reply to message #506023] Fri, 06 May 2011 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please can you repost in correct english.
What does mean "how can u change your this spfile"?

Regards
Michel
Re: NID- utility giving ora-01103 error [message #506054 is a reply to message #506027] Fri, 06 May 2011 06:19 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
Re: NID- utility giving ora-01103 error [message #425764 is a reply to message #425754] Mon, 12 October 2009 02:42
ramoradba
Messages: 2095
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I... Senior Member

Thanks michel...renamed spfile and opened the database with resetlogs options its working now.

you post this resolution to this user

ramoradba
at January 2009

so askd you this how can we rename this spfile...i change db_name in spfile but error is same
Re: NID- utility giving ora-01103 error [message #506058 is a reply to message #506054] Fri, 06 May 2011 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how can we rename this spfile

C:\>move /?
Déplace des fichiers et renomme des fichiers et répertoires.

Pour déplacer un ou plusieurs fichiers :
MOVE [/Y | /-Y] [lecteur:][chemin]fichier1[,...] destination

Pour renommer un répertoire:
MOVE [/Y | /-Y] [lecteur:][chemin]répert1 répertoire2

  [lecteur:][chemin]fichier1 Spécifie l'emplacement et le nom du ou des
                             fichiers que vous voulez déplacer.
  destination                Spécifie le nouvel emplacement du fichier.
                             Destination peut être une lettre de lecteur et
                             deux-points (:), un nom de répertoire, ou une
                             combinaison. Si vous déplacez un seul fichier,
                             vous pouvez aussi inclure un nom de fichier si
                             vous voulez renommer le fichier en le déplaçant.
  [lecteur:][chemin]répert1  Spécifie le répertoire que vous voulez renommer.
  répert2                    Spécifie le nouveau nom du répertoire.

  /Y                         Supprime la demande de confirmation de
                             remplacement de fichiers de destination existants.
  /-Y                        Provoque la demande de confirmation de
                             remplacement de fichiers de destination existants.

L'option /Y peut être présente dans la variable d'environnement COPYCMD.
Outrepassez ceci en utilisant /-Y dans la ligne de commandes. Par défaut, une
demande de confirmation apparaît sauf si la commande MOVE est exécutée depuis
un script de commandes.

Regards
Michel


Re: NID- utility giving ora-01103 error [message #506060 is a reply to message #506058] Fri, 06 May 2011 06:33 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
what is this dear.
in which language you give me reply
i cannot understand it
Re: NID- utility giving ora-01103 error [message #506070 is a reply to message #506060] Fri, 06 May 2011 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry forgot that my current PC is in French.
Do it yourself: "move /?"

Regards
Michel
Re: NID- utility giving ora-01103 error [message #506136 is a reply to message #506070] Fri, 06 May 2011 11:15 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Interesting. Here is there problem

SQL> host nid target=sys/tejajun20 dbname=mallik


Exit your sql session and open new terminal window / command prompt for NID

Babu
Re: NID- utility giving ora-01103 error [message #506141 is a reply to message #506136] Fri, 06 May 2011 11:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not what I have said almost 2 years ago?

Michel Cadot wrote on Mon, 12 October 2009 09:04
...
It is a BAD idea to use nid when connected to the database.
Exit from SQL*Plus before doing this.

Regards
Michel

Re: NID- utility giving ora-01103 error [message #506216 is a reply to message #506141] Sat, 07 May 2011 02:03 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
i alrady shutdown my database by using shutdown immediate before running this NID
Re: NID- utility giving ora-01103 error [message #506219 is a reply to message #506216] Sat, 07 May 2011 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But we do not know what you have, you didn't post any information about it.
Copy and paste what you do and get.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: NID- utility giving ora-01103 error [message #506223 is a reply to message #506219] Sat, 07 May 2011 02:29 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
Is this not what I have said almost 2 years ago?


Michel Cadot wrote on Mon, 12 October 2009 09:04
...
It is a BAD idea to use nid when connected to the database.
Exit from SQL*Plus before doing this.
Regards
Michel

=============

i give u reply related to this your answer......

i told u i have shutdown my database before i am using this nid .
for to change my databasename
Re: NID- utility giving ora-01103 error [message #506227 is a reply to message #506223] Sat, 07 May 2011 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And? What is the problem?

Please do not use IM/SMS speak. Use complete words and plain english.

Regards
Michel

[Updated on: Sat, 07 May 2011 03:02]

Report message to a moderator

Re: NID- utility giving ora-01103 error [message #506236 is a reply to message #506223] Sat, 07 May 2011 04:27 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
ok i am sorry for that now i am sending you my this complite steps that i did now give me solution

how can i resolve my this error.i want to change my this database name michel


thanks in advance ..plz help me to resolve my this task

  • Attachment: dbrename.pdf
    (Size: 45.63KB, Downloaded 1866 times)
Re: NID- utility giving ora-01103 error [message #506252 is a reply to message #506236] Sat, 07 May 2011 10:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in

It is a BAD idea to use nid when connected to the database.
Exit from SQL*Plus before doing this


Regards
Michel
Re: NID- utility giving ora-01103 error [message #506431 is a reply to message #506252] Mon, 09 May 2011 04:58 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
i have resolved my this error
michel
further steps are here

=====

F:\oracle\product\10.2.0\db_1\bin>set instance_name=dom

F:\oracle\product\10.2.0\db_1\bin>sqlplus startup

SQL*Plus: Release 10.2.0.5.0 - Production on Sat May 7 16:47:19 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Enter password:
ERROR:
ORA-01005: null password given; logon denied


Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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


ORACLE instance shut down.
SQL>
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1304848 bytes
Variable Size 301991664 bytes
Database Buffers 947912704 bytes
Redo Buffers 7081984 bytes
SQL>
SQL> alter system set db_name='DON' scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1304848 bytes
Variable Size 301991664 bytes
Database Buffers 947912704 bytes
Redo Buffers 7081984 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;

Database altered.

SQL>
SQL>
SQL> select name from v$database;

NAME
---------
DON
Re: NID- utility giving ora-01103 error [message #506432 is a reply to message #506431] Mon, 09 May 2011 05:01 Go to previous message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
step by step steps are here
here we have to change dom database name to don

how can we change database name i have mention my step by step activity here

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\SHOAIB>F:

F:\>cd oracle/product/10.2.0/db_1/bin

F:\oracle\product\10.2.0\db_1\bin>set oracle_sid=dom

F:\oracle\product\10.2.0\db_1\bin>sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Sat May 7 13:07:06 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v$database;

NAME
---------
DOM

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
dom
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size 1304848 bytes
Variable Size 301991664 bytes
Database Buffers 947912704 bytes
Redo Buffers 7081984 bytes
Database mounted.
SQL> host nid target=sys/oracle dbname=don
DBNEWID: Release 10.2.0.5.0 - Production on Sat May 7 13:25:57 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to database DOM (DBID=25563362)
Connected to server version 10.2.0
Control Files in database:
F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL01.CTL
F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL02.CTL
F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL03.CTL

Change database ID and database name DOM to DON? (Y/[N]) => y

Proceeding with operation
Changing database ID from 25563362 to 4292826086
Changing database name from DOM to DON
Control File F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL01.CTL - modified
Control File F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL02.CTL - modified
Control File F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL03.CTL - modified
Datafile F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\SYSTEM01.DBF - dbid changed, w
rote new name
Datafile F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\UNDOTBS01.DBF - dbid changed,
wrote new name
Datafile F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\SYSAUX01.DBF - dbid changed, w
rote new name
Datafile F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\USERS01.DBF - dbid changed, wr
ote new name
Datafile F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\EXAMPLE01.DBF - dbid changed,
wrote new name
Datafile F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\TEMP01.DBF - dbid changed, wro
te new name
Control File F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL01.CTL - dbid chang
ed, wrote new name
Control File F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL02.CTL - dbid chang
ed, wrote new name
Control File F:\ORACLE\PRODUCT\10.2.0\ORADATA\DOM\CONTROL03.CTL - dbid chang
ed, wrote new name
Instance shut down

Database name changed to DON.
Modify parameter file and generate a new password file before restarting.
Database ID for database DON changed to 4292826086.
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.


SQL> shutdown immediate
ORA-03113: end-of-file on communication channel
SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1304848 bytes
Variable Size 301991664 bytes
Database Buffers 947912704 bytes
Redo Buffers 7081984 bytes
ORA-01103: database name 'DON' in control file is not 'DOM'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted


SQL>



Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\SHOAIB>F:

F:\>cd oracle/product/10.2.0/db_1/bin

F:\oracle\product\10.2.0\db_1\bin>set instance_name=dom

F:\oracle\product\10.2.0\db_1\bin>sqlplus startup

SQL*Plus: Release 10.2.0.5.0 - Production on Sat May 7 16:47:19 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Enter password:
ERROR:
ORA-01005: null password given; logon denied


Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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


ORACLE instance shut down.
SQL>
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1304848 bytes
Variable Size 301991664 bytes
Database Buffers 947912704 bytes
Redo Buffers 7081984 bytes
SQL>
SQL> alter system set db_name='DON' scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1304848 bytes
Variable Size 301991664 bytes
Database Buffers 947912704 bytes
Redo Buffers 7081984 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;

Database altered.

SQL>
SQL>

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
dom

SQL> select name from v$database;

NAME
---------
DON

[Updated on: Mon, 09 May 2011 05:11]

Report message to a moderator

Previous Topic: RMAN Cold Backup
Next Topic: Controlfile piece handle lost from Tape
Goto Forum:
  


Current Time: Thu Mar 28 06:27:45 CDT 2024