OraFAQ Forum: General » ORA-604 signalled during: ALTER TABLESPACE

Home » Other » General » ORA-604 signalled during: ALTER TABLESPACE (Oracle 10.2.0.4 EE, Windows Server 2003)

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

ORA-604 signalled during: ALTER TABLESPACE [message #442513]

Mon, 08 February 2010 16:28

Apacer5
Messages: 3
Registered: February 2010
Location: ddd

Junior Member

Today I wanted to add new datafile...
First I restart the instance and then used EM to add datafile... After 5 minutes EM connection failed. Then I re-connect and EM don't show me any errors, everything was fine but new datafile was not added. Only I get error message in AlertSID.ora...

Mon Feb 08 10:23:04 2010
ALTER TABLESPACE "R1" ADD DATAFILE 'D:\Datafile\R03.DBF' SIZE 15000M AUTOEXTEND ON NEXT 512M MAXSIZE 32767M
Mon Feb 08 10:28:08 2010
ORA-604 signalled during: ALTER TABLESPACE "R1" ADD DATAFILE 'D:\Datafile\R03.DBF' SIZE 15000M AUTOEXTEND ON NEXT 512M MAXSIZE 32767M

Then I create datafile with command prompt and everything was fine, new datafile was added.

Any Ideas why does this happen?

Thanks!

Report message to a moderator

Re: ORA-604 signalled during: ALTER TABLESPACE [message #442521 is a reply to message #442513]

Mon, 08 February 2010 21:07

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Apacer5 wrote on Tue, 09 February 2010 03:58

Today I wanted to add new datafile...
First I restart the instance and then used EM to add datafile... After 5 minutes EM connection failed. Then I re-connect and EM don't show me any errors, everything was fine but new datafile was not added. Only I get error message in AlertSID.ora...

This your post right?
http://forums.oracle.com/forums/thread.jspa?threadID=1026047&tstart=0

i suspect here... After 5 minutes EM connection failed.
Why?whats the reason?
Don`t you have any other trace files/logs?

sriram

Report message to a moderator

Re: ORA-604 signalled during: ALTER TABLESPACE [message #442536 is a reply to message #442513]

Mon, 08 February 2010 22:59

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00604: error occurred at recursive SQL level %s
 *Cause:  An error occurred while processing a recursive SQL statement
           (a statement applying to internal dictionary tables).
 *Action: If the situation described in the next error on the stack
           can be corrected, do so; otherwise contact Oracle Support.

Regards
Michel

Report message to a moderator

Previous Topic:	Service Error: sr/home: User does not have "Read SR" privilege.
Next Topic:	Help verifying a fix on 11.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 05:53:03 CST 2024