OraFAQ Forum: Server Administration » ORA-01103: database name 'TOM' in control file is not 'TAB'

Home » RDBMS Server » Server Administration » ORA-01103: database name 'TOM' in control file is not 'TAB' (windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506050]

Fri, 06 May 2011 05:49

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

here i have error. i have rename my tab database into tom name but when i open my datbase i got this error
ORA-01103: database name 'TOM' in control file is not 'TAB'

and when execute this command i got this error

SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01507: database not mounted

so anyone give me the solution of this error

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506052 is a reply to message #506050]

Fri, 06 May 2011 06:05

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Can you check your instance parameter db_name ?

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506053 is a reply to message #506052]

Fri, 06 May 2011 06:11

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

here i have copy my init.ora file name.... here in db_name i have change from tab to tom but sitll i have same error

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Archive
###########################################
log_archive_format=ARC%S_%R.%T

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=tom

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=f:\oracle\product\10.2.0/admin/tab/bdump
core_dump_dest=f:\oracle\product\10.2.0/admin/tab/cdump
user_dump_dest=f:\oracle\product\10.2.0/admin/tab/udump

###########################################
# File Configuration
###########################################
control_files=("f:\oracle\product\10.2.0\tab\control01.ctl", "f:\oracle\product\10.2.0\tab\control02.ctl", "f:\oracle\product\10.2.0\tab\control03.ctl")
db_recovery_file_dest=f:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.5.0

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
sga_target=1253048320

###########################################
# Security and Auditing
###########################################
audit_file_dest=f:\oracle\product\10.2.0/admin/tab/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=tabXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=417333248

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506055 is a reply to message #506053]

Fri, 06 May 2011 06:19

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

THat may not be relevant, you might not be using that file, but an spfile instead. To check the parameter,

select value from v$parameter where name='db_name';

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506061 is a reply to message #506055]

Fri, 06 May 2011 06:39

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

i have copy my this SPFILETAB.ORA file here... here i also change this parametter in spfile is db_name=tom from db_name=tab

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Archive
###########################################
log_archive_format=ARC%S_%R.%T

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=tom

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=f:\oracle\product\10.2.0/admin/tab/bdump
core_dump_dest=f:\oracle\product\10.2.0/admin/tab/cdump
user_dump_dest=f:\oracle\product\10.2.0/admin/tab/udump

###########################################
# File Configuration
###########################################
control_files=("f:\oracle\product\10.2.0\tab\control01.ctl", "f:\oracle\product\10.2.0\tab\control02.ctl", "f:\oracle\product\10.2.0\tab\control03.ctl")
db_recovery_file_dest=f:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.5.0

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
sga_target=1253048320

###########################################
# Security and Auditing
###########################################
audit_file_dest=f:\oracle\product\10.2.0/admin/tab/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=tabXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=417333248

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506062 is a reply to message #506061]

Fri, 06 May 2011 06:42

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

and when i run this query i got this output

SQL> select value from v$parameter where name='TAB';

no rows selected

SQL> select value from v$parameter where name='TOM';

no rows selected

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506065 is a reply to message #506055]

Fri, 06 May 2011 06:49

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

I'm sorry to have to say this, but if you don't understand the instruction I gave, then I don't think you will ever be able to sort out this issue. Before you start attemptiong database administration, you must learn SQL.

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506066 is a reply to message #506065]

Fri, 06 May 2011 06:58

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

i told you i alrady send you my spfile
again i copy my spfile here
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Archive
###########################################
log_archive_format=ARC%S_%R.%T

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=tom

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=f:\oracle\product\10.2.0/admin/tab/bdump
core_dump_dest=f:\oracle\product\10.2.0/admin/tab/cdump
user_dump_dest=f:\oracle\product\10.2.0/admin/tab/udump

###########################################
# File Configuration
###########################################
control_files=("f:\oracle\product\10.2.0\tab\control01.ctl", "f:\oracle\product\10.2.0\tab\control02.ctl", "f:\oracle\product\10.2.0\tab\control03.ctl")
db_recovery_file_dest=f:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.5.0

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
sga_target=1253048320

###########################################
# Security and Auditing
###########################################
audit_file_dest=f:\oracle\product\10.2.0/admin/tab/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=tabXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=417333248

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506076 is a reply to message #506066]

Fri, 06 May 2011 07:37

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Shaan, I'll try again, but this has to be the last time. You need to run the query I gave you earlier:

select value from v$parameter where name='db_name';

this will select the value of the parameter db_name. We need to see if it set to TOM or TAB. Your queries tried to to find the values of the parameters TOM and TAB, and of course there are no such parameters.

And I do not believe that you have posted your spfile. An spfile can't be posted like that, because it has binary characters. I think you have posted another copy of your pfile. the only way to exrtact information reliably from an spfile is with SQL:

select value from v$spparameter where name='db_name';

[Updated on: Fri, 06 May 2011 07:39]

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506078 is a reply to message #506076]

Fri, 06 May 2011 07:51

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that Shaan didn't understand what 'db_name' is. So here's a screenshot (MS Windows 7, Command prompt window, connected to SQL*Plus):

/forum/fa/8938/0/

/forum/fa/8938/0/

See? You need to specify 'db_name' literally.

Attachment: db_name.png
(Size: 10.04KB, Downloaded 12910 times)

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506220 is a reply to message #506078]

Sat, 07 May 2011 02:11

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

ok i got it but when i run this query i got an error like this

SQL> select value from v$spparameter where name='db_name';
select value from v$spparameter where name='db_name'
*
ERROR at line 1:
ORA-01034: ORACLE not available

=======
and this time when i did this step i got this error

i have attached this my commandpromt slide here

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

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506222 is a reply to message #506220]

Sat, 07 May 2011 02:25

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

when i perfort this step i got this lisner error

Attachment: pic.png
(Size: 1.67MB, Downloaded 1242 times)

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506226 is a reply to message #506222]

Sat, 07 May 2011 02:51

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Hi - are you aware of the difference between an instance and database? The instance is memory structures and processes, the datbase is files on disc. They are separate, and may have different names. Nothing spoken of so far refers to changing the name of the instance. In your screen shot, you appear to be changing the operating system variable instance_name: do not do that, your instance name is still TAB. This is why you are getting the ora-12650.

And please answer my question regarding the file you posted: was it a copy of the pfile (which is probably called INITtab.ora) or thhe spfile (which is probably SPFILETAB.ORA

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506237 is a reply to message #506226]

Sat, 07 May 2011 04:39

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

this is my init.ora file copy here

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Archive
###########################################
log_archive_format=ARC%S_%R.%T

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=tom

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=f:\oracle\product\10.2.0/admin/tab/bdump
core_dump_dest=f:\oracle\product\10.2.0/admin/tab/cdump
user_dump_dest=f:\oracle\product\10.2.0/admin/tab/udump

###########################################
# File Configuration
###########################################
control_files=("f:\oracle\product\10.2.0\tab\control01.ctl", "f:\oracle\product\10.2.0\tab\control02.ctl", "f:\oracle\product\10.2.0\tab\control03.ctl")
db_recovery_file_dest=f:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.5.0

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
sga_target=1253048320

###########################################
# Security and Auditing
###########################################
audit_file_dest=f:\oracle\product\10.2.0/admin/tab/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=tabXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=417333248

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506238 is a reply to message #506226]

Sat, 07 May 2011 04:47

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

and this is my SPFILETAB.ORA file copy here.

____________________________________________tab.__db_cache_size=947912704
tab.__java_pool_size=8388608
tab.__large_pool_size=8388608
tab.__shared_pool_size=285212672
tab.__streams_pool_size=0
*.audit_file_dest='f:\oracle\product\10.2.0/admin/tab/adump'
*.background_dump_dest='f:\oracle\product\10.2.0/admin/tab/bdump'
*.compatible='10.2.0.5.0'
*.control_files='f:\oracle\product\10.2.0\tab\control01.ctl','f:\oracle\product\10.2.0\tab\control02.ctl','f:\oracle\product\10.2.0\t ab\control03.ctl'
*.core_dump_dest='f:\oracle\product\10.2.0/admin/tab/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='tab'
*.db_recovery_file_dest='f:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=tabXDB)'
*.job_queue_processes=10
*.log_archive_format='ARC%S_%R.%T'
*.open_cursors=300
*.pga_aggregate_target=417333248
*.processes=150
*.remote_login_passwordfile='NONE'
*.sga_target=1253048320
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='f:\oracle\product\10.2.0/admin/tab/udump'

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506239 is a reply to message #506237]

Sat, 07 May 2011 04:48

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Your init.ora file is completely irrelevant. It is the inittab.ora file or the spfiletab.ora file that matter. So again I ask, when you said in your post timed at 6 May 6:58 that it was your spfile, what file was it?
And what about my last question: are you aware of the difference between the instance name and the database name? Which are you trying to change?

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506240 is a reply to message #506238]

Sat, 07 May 2011 04:52

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

At last we have the answer! In your spfile, you have not changed the db_name parameter. So, get your instance into nomount mode. To do that, set your operating system environment variable instance_name, like this:

c:\> set instance_name=tab

then start the isntance:

sql> conn / as sysdba
startup nomount

then change the parameter

sql> alter system set dn_name='TOM' scope=spfile;

then restart:

SQL> startup force

OK?

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506246 is a reply to message #506240]

Sat, 07 May 2011 07:22

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

yeah its working now so thans you very much ..............thanks a lot again..its realy helpful me.....thanks again.....

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506247 is a reply to message #506240]

Sat, 07 May 2011 07:23

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

thanks jhon..

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506250 is a reply to message #506247]

Sat, 07 May 2011 08:05

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

I'll send the invoice later Smile

Smile

Report message to a moderator

Re: ORA-01103: database name 'TOM' in control file is not 'TAB' [message #506440 is a reply to message #506250]

Mon, 09 May 2011 05:17

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

ok sure i will pay you later when my company give me my salary..hahaha

Report message to a moderator

Previous Topic:	OMF online logfiles
Next Topic:	Flashback SYS table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 14:48:20 CDT 2024