Reputation
683
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
7 23 42
Impact
~226k people reached

  • 0 posts edited
  • 0 helpful flags
  • 33 votes cast
Feb
13
asked Oracle installation requires old rpm versions, what to do?
Feb
12
comment Check only prerequisites when running runInstaller in silent mode
-silentvalidate doesn't work for 11gR2
Feb
12
answered Check only prerequisites when running runInstaller in silent mode
Feb
12
asked Check only prerequisites when running runInstaller in silent mode
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
my spfile contains the following: crimesys1.undo_tablespace='UNDOTBS1' *.undo_tablespace='UNDOTBS' UNDOTBS is newly created undo tablespace, which I want to leave and delete other undo tablespaces.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@MindaugasRiauba dba_2pc_pending is empty now but, there is sometimes a record in gv$transaction referring to some of these segments.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil Why do you think that shutdown abort may resolve the issue?
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil I changed UNDOTBS2 to any available undo tablespace name and still returns 0 rows. Maybe, it is now that no one uses, but will be used after a while.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil Thank you. Your query returns nothing.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
I found that segments with PARTLY AVAILABLE statuses contains an active dead transactions.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
When I query status column of dba_rollback_segs view, filtering by UNDOTBS2, it shows me that most of them are OFFLINE and others are PARTLY AVAILABLE. If I drop OFFLINE segments, why it should be a problem?
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@MindaugasRiauba I have undo retention 24 hours. It is already 1 week I've deleted node from the RAC.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil I am going to follow, these are just examples.
Feb
7
asked What problems can be caused by dropping a rollback segment manually?
Feb
5
comment ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7
@Phil I have the full installation of 11.2.0.3. Can I upgrade my 11.2.0.1 database using this installation? Or do I need to download the patch? Is the patch software different from the fresh installation? Does runInstaller of the fresh installation have the option like upgrade? And is the patch(11.2.0.1->11.2.0.3) different from the patch(11.2.0.2 to 11.2.0.3)?
Feb
4
asked ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7
Jan
28
accepted Oracleasm deletedisk failed Unable to clear disk
Jan
22
asked Advice to set minimum preferable value for MEMORY_TARGET
Jan
21
awarded  Popular Question
Jan
20
answered Oracleasm deletedisk failed Unable to clear disk