Home » Other » General » ORA-604 signalled during: ALTER TABLESPACE (Oracle 10.2.0.4 EE, Windows Server 2003)
ORA-604 signalled during: ALTER TABLESPACE [message #442513] Mon, 08 February 2010 16:28 Go to next message
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!
Re: ORA-604 signalled during: ALTER TABLESPACE [message #442521 is a reply to message #442513] Mon, 08 February 2010 21:07 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: ORA-604 signalled during: ALTER TABLESPACE [message #442536 is a reply to message #442513] Mon, 08 February 2010 22:59 Go to previous message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Service Error: sr/home: User does not have "Read SR" privilege.
Next Topic: Help verifying a fix on 11.2
Goto Forum:
  


Current Time: Sun Nov 23 23:44:57 CST 2014

Total time taken to generate the page: 0.07359 seconds