Home » Other » General » ORA 01555 In Oracle 8i (8.1.7.4)
ORA 01555 In Oracle 8i [message #542147] Sun, 05 February 2012 07:19 Go to next message
achal_mishra
Messages: 8
Registered: November 2011
Location: DELHI
Junior Member
EXPERT DBAs, Kindly help me to fix ORA 1555 issue i am facing evry day on all of my 8i databases.

Oracle Support is not supporting this Database.

Eagerly waiting for your response.

Client is getting ORA 01555 evry day and there jobs are failing.

Thanks

Achal Kumar
Re: ORA 01555 In Oracle 8i [message #542152 is a reply to message #542147] Sun, 05 February 2012 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Dear, there are thousands articles on the subject on the web and you din't find any?

Regards
Michel
Re: ORA 01555 In Oracle 8i [message #542153 is a reply to message #542147] Sun, 05 February 2012 08:00 Go to previous messageGo to next message
wgerum
Messages: 2
Registered: February 2012
Location: Landsberg
Junior Member

Hello,

look into the alert-log-file.
What does it say??
Perhaps it could be a timeout problem.
Maybe you have to change the retention time.

Best regards

Wolfgang
Re: ORA 01555 In Oracle 8i [message #542154 is a reply to message #542153] Sun, 05 February 2012 08:06 Go to previous messageGo to next message
achal_mishra
Messages: 8
Registered: November 2011
Location: DELHI
Junior Member
There is no messages in alert log.

Client is getting this message at there end.

yes, you are correct, I have seen many links for this, but not able to understand clearly that what i have to do.

Please help me out , it will be highly appreciated.

Achal
Re: ORA 01555 In Oracle 8i [message #542157 is a reply to message #542154] Sun, 05 February 2012 08:24 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
Replace your rollback segments with more, bigger, ones. And read all of this:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/rollbak.htm#414
Re: ORA 01555 In Oracle 8i [message #542162 is a reply to message #542157] Sun, 05 February 2012 10:25 Go to previous messageGo to next message
achal_mishra
Messages: 8
Registered: November 2011
Location: DELHI
Junior Member
Thanks John for your suggestion.

Is there any way where we can alter/resize the existing rollback segments? Is this require Database Bounce?

What is the meaning of shrink and optimal?

How can we resize the rollback segments?

Eagerly wating for your suggestion.
Re: ORA 01555 In Oracle 8i [message #542163 is a reply to message #542162] Sun, 05 February 2012 10:29 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
It is all in the docs. What did you not understand? Which paragraphs?
Re: ORA 01555 In Oracle 8i [message #542167 is a reply to message #542163] Sun, 05 February 2012 10:59 Go to previous messageGo to next message
achal_mishra
Messages: 8
Registered: November 2011
Location: DELHI
Junior Member
Hello John,

I have gon e through the doc and really its very uselful.
My question is different:

1) I have 20 Rollback segments and i have mark all rollback segments STORAGE to MAX UNLIMITED. Still Users jobs is failing with 1555 error.
(ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 7 with name "R04" too
small
ORA-06512: at line 687 )

2) I have gone through various sites and they all are explaining about WRAP and SHRINK and also optimal. I am totally confused with this.

I need a proper guideline and help from your senior members..

I am totally wash in this and not able to understand from where should i start.

Please help me out in this.
Re: ORA 01555 In Oracle 8i [message #542171 is a reply to message #542167] Sun, 05 February 2012 11:30 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
Have you run any of the queries given to check how your rollback segments are configured and how they are being used? And queries that show your current transactions and how much undo they are using? The queries in the manual are not good enough. You need to join dba_rollback_segs, dba_segments, v$rollstat, v$transaction, v$rollname, v$session, and more.
Once you know the pattern of undo usage, you can tune the RBSs accordingly.
Re: ORA 01555 In Oracle 8i [message #542175 is a reply to message #542167] Sun, 05 February 2012 11:40 Go to previous message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you had gone through many sites (including this one) you should know that the very first reason of ORA-01555 is commit inside loops.
Is this your case?

Regards
Michel
Previous Topic: Essentials for Oracle DBA
Next Topic: COPY COMMAND in Pl/sql
Goto Forum:
  


Current Time: Sat Sep 19 02:02:16 CDT 2020