OraFAQ Forum: Server Utilities » oracle instance being terminated on startup

Home » RDBMS Server » Server Utilities » oracle instance being terminated on startup

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

oracle instance being terminated on startup [message #74421]

Wed, 08 December 2004 05:23

Natraj
Messages: 53
Registered: March 2003

Member

Hi,

I refreshed a database, using a cold backup.i had to change certail datafiles becoz i didnt have space. while opening the database i get error.

SQL> startup
ORACLE instance started.

Total System Global Area� 370379224 bytes
Fixed Size�� 731608 bytes
Variable Size�� 218103808 bytes
Database Buffers�� 150994944 bytes
Redo Buffers�� 548864 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
�when i startup and mount the database, and query v$datafiles i find that the datafiles have been moved to new location as per my need. now i cant open the database.Initially i got password error i recreated password file. still database isnt opening.

Report message to a moderator

Re: oracle instance being terminated on startup [message #74422 is a reply to message #74421]

Wed, 08 December 2004 05:48

Natraj
Messages: 53
Registered: March 2003

Member

Hi , I wanted to add the alert.log entry.my p file has undo_tablespace =undo.however i get the error.and db doesnt open..
ORA-30012: undo tablespace 'UNDO' does not exist or of wrong type
Wed Dec 8 08:27:52 2004
Error 30012 happened during db open, shutting down database
USER: terminating instance due to error 30012
Instance terminated by USER, pid = 2752
ORA-1092 signalled during: alter database open...

Report message to a moderator

Re: oracle instance being terminated on startup [message #74424 is a reply to message #74421]

Wed, 08 December 2004 06:00

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is a very generic message.
Post your oracle version, OS etc.
First check whether you have a proper (try to get along with OFA) directory structure and write permssions for
directories like

$ORACLE_BASE/admin/bdump
$ORACLE_BASE/admin/cdump
$ORACLE_BASE/admin/udump

check specifically the BACKGROUND_DUMP_DEST directory
which by default should be $ORACLE_BASE/admin/bdump.
if there no privs on this directory, oracle cannot create the alert_< sid >.log .

if the above is all set, post only relevent part of the
alert_< sid >.log file.
POST compelete error messages!.

Report message to a moderator

Re: oracle instance being terminated on startup [message #74425 is a reply to message #74422]

Wed, 08 December 2004 06:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is supposed to be something like this.
check whether you have your undo_tablespace defined and check whether it is right name~.

*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'

Report message to a moderator

Re: oracle instance being terminated on startup [message #74426 is a reply to message #74425]

Wed, 08 December 2004 07:31

Natraj
Messages: 53
Registered: March 2003

Member

Hi Mahesh,
i resolved the error and wa about to say that its resolved, but u have already sent ur reply:) i knew u wud have replied back. actually i didnt create undo tbs. and pfile was having undotbs, so i went and commented in the pfile, then create d the undo tbs, and then went back and uncommented the undotbs in the pfile. now the db is open:) anyway thanks for responding:) and the other listener wala errorin RMAN... i had 2 listeners in listener.ora filewith different oracle versions.
Cheers natraj

Report message to a moderator

Re: oracle instance being terminated on startup [message #74427 is a reply to message #74425]

Wed, 08 December 2004 07:35

Natraj
Messages: 53
Registered: March 2003

Member

mahesh, the datbase is open, however when iwas checking v$lofile i got status as stale. how do i resolve this??
pls see the v$lofile output
SQL> select * from v$logfile;

GROUP# STATUS TYPE
---------- --------------------- ---------------------
MEMBER
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4 STALE ONLINE
/u05/oradata/DMDEV1/log04_01.rdo

4 STALE ONLINE
/u06/oradata/DMDEV1/log04_02.rdo

3 STALE ONLINE
/u01/oradata/DMDEV1/log03_01.rdo

3 STALE ONLINE
/u02/oradata/DMDEV1/log03_02.rdo

2 STALE ONLINE
/u01/oradata/DMDEV1/log02_01.rdo

2 STALE ONLINE
/u02/oradata/DMDEV1/log02_02.rdo

1 ONLINE
/u01/oradata/DMDEV1/log01_01.rdo

1 ONLINE
/u02/oradata/DMDEV1/log01_02.rdo

8 rows selected.

Report message to a moderator

Re: oracle instance being terminated on startup [message #74428 is a reply to message #74427]

Wed, 08 December 2004 07:46

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

nothing~.
it means, the contents of redologfile are incomplete.
It will be all set after a while.
Just to make yourself happy, try this.

sql > alter system switch logfile;

Now query the status;
which redolog was currently used, the status will be cleared.
just switch the all the logfiles ~.

Report message to a moderator

Re: oracle instance being terminated on startup [message #74432 is a reply to message #74428]

Wed, 08 December 2004 12:21

Natraj
Messages: 53
Registered: March 2003

Member

u are right.

Report message to a moderator

Previous Topic:	SQLLOADER FAILS WITH CCYYMMDD FORMAT
Next Topic:	creating sqlldr control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:56:55 CDT 2024