OraFAQ Forum: Server Administration » Unable to mount database

Home » RDBMS Server » Server Administration » Unable to mount database

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

Unable to mount database [message #283810]

Wed, 28 November 2007 03:31

lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur

Junior Member

Hi ,
Can someone help me on this? Cannot mount database. This is the Error:
SQL> alter database mount
2 ;
alter database mount
*
ERROR at line 1:
ORA-01079: ORACLE database was not properly created, operation aborted

Alert log:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Offending statement at line 5161
CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/oracle/vol03/acsselva/acsselva_UNDOTB
S_01.dbf' size 100M
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5161
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

Thank in advance.

Report message to a moderator

Re: Unable to mount database [message #283811 is a reply to message #283810]

Wed, 28 November 2007 03:35

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You created or tried to create UNDOTBS undo tablespace in your create database and your parameter "undo_tablespace" is set to UNDOTBS1.

Regards
Michel

[Updated on: Wed, 28 November 2007 03:35]

Report message to a moderator

Re: Unable to mount database [message #283812 is a reply to message #283810]

Wed, 28 November 2007 03:36

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

ORA-30012:	undo tablespace 'string' does not exist or of wrong type
Cause:	the specified undo tablespace does not exist or of the wrong type.
Action:	Correct the tablespace name and reissue the statement.

Quote:

undo tablespace 'UNDOTBS1' does not exist

and ,

Quote:

CREATE UNDO TABLESPACE UNDOTBS

See the difference

Report message to a moderator

Re: Unable to mount database [message #283952 is a reply to message #283810]

Wed, 28 November 2007 07:53

lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur

Junior Member

Thanks Michel and Arju ..

Can someone help me on next step. What should i have to do now?

Currently my database in nomount state.

Thank you.

Report message to a moderator

Re: Unable to mount database [message #283954 is a reply to message #283952]

Wed, 28 November 2007 07:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1. open your pfile (init<sid>.ora) file and change undo_tablespace parameter to UNDOTBS.

2. Recreate your spfile file from pfile file.

3. shutdown immdiate;

4. startup

Report message to a moderator

Re: Unable to mount database [message #283962 is a reply to message #283954]

Wed, 28 November 2007 08:09

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can also directly change your parameter file (spfile) while in nomount mode with "alter system".

SYS> startup nomount
ORACLE instance started.
Total System Global Area  314572800 bytes
Fixed Size                  1290352 bytes
Variable Size             142610320 bytes
Database Buffers          167772160 bytes
Redo Buffers                2899968 bytes
SYS> alter system set undo_tablespace=undotbs scope=spfile;

System altered.

SYS> alter database mount;

Database altered.

SYS> alter database open;

Database altered.

SYS> select status from v$instance;
STATUS
------------
OPEN

1 row selected.

Regards
Michel

Report message to a moderator

Re: Unable to mount database [message #283964 is a reply to message #283962]

Wed, 28 November 2007 08:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SYS> alter system set undo_tablespace=undotbs scope=spfile;

System altered.
Micheal it is working... without shutdown and startup how can spfile take effect.

Report message to a moderator

Re: Unable to mount database [message #283966 is a reply to message #283964]

Wed, 28 November 2007 08:21

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Spfile can be accessed as soon as the instance process is created that is before mounting the database.
Hopefully as this is the only way to start when you have no configuration file (init.ora) and scramble your spfile.

Regards
Michel

Report message to a moderator

Re: Unable to mount database [message #283984 is a reply to message #283810]

Wed, 28 November 2007 09:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You can create a pfile (initSID.ora) file manually using the contents from the alert_SID.log file which contains non-default parameters & their values (as shown at time of last DB startup).

Report message to a moderator

Re: Unable to mount database [message #283987 is a reply to message #283984]

Wed, 28 November 2007 09:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

And we can also use init.ora (text file). but init.ora file is not exists then we have to use Ana suggestion.

Report message to a moderator

Re: Unable to mount database [message #283994 is a reply to message #283966]

Wed, 28 November 2007 09:36

lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur

Junior Member

Thank you very much. Now i'm able to startup the DB.

Report message to a moderator

Re: Unable to mount database [message #283995 is a reply to message #283994]

Wed, 28 November 2007 09:39

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Thanks for feedback.

Report message to a moderator

Previous Topic:	Oracle replication and version upgrade
Next Topic:	Please guide me in Database Cloning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:26:10 CDT 2024