Home » RDBMS Server » Server Administration » Unable to mount database
Unable to mount database [message #283810] Wed, 28 November 2007 03:31 Go to next message
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.
Re: Unable to mount database [message #283811 is a reply to message #283810] Wed, 28 November 2007 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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 Go to previous messageGo to next message
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
Re: Unable to mount database [message #283952 is a reply to message #283810] Wed, 28 November 2007 07:53 Go to previous messageGo to next message
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.
Re: Unable to mount database [message #283954 is a reply to message #283952] Wed, 28 November 2007 07:56 Go to previous messageGo to next message
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
Re: Unable to mount database [message #283962 is a reply to message #283954] Wed, 28 November 2007 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Unable to mount database [message #283964 is a reply to message #283962] Wed, 28 November 2007 08:13 Go to previous messageGo to next message
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.
Re: Unable to mount database [message #283966 is a reply to message #283964] Wed, 28 November 2007 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Unable to mount database [message #283984 is a reply to message #283810] Wed, 28 November 2007 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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).
Re: Unable to mount database [message #283987 is a reply to message #283984] Wed, 28 November 2007 09:24 Go to previous messageGo to next message
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.

Re: Unable to mount database [message #283994 is a reply to message #283966] Wed, 28 November 2007 09:36 Go to previous messageGo to next message
lselva21
Messages: 8
Registered: November 2007
Location: Kuala Lumpur
Junior Member

Thank you very much. Now i'm able to startup the DB.
Re: Unable to mount database [message #283995 is a reply to message #283994] Wed, 28 November 2007 09:39 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thanks for feedback.
Previous Topic: Oracle replication and version upgrade
Next Topic: Please guide me in Database Cloning
Goto Forum:
  


Current Time: Sun Dec 04 12:41:13 CST 2016

Total time taken to generate the page: 0.04561 seconds