593 reputation
51536
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 24
visits member for 3 years, 8 months
seen Mar 18 at 7:33

I am 11g OCP and I work as a Senior DBA at Ministry of Justice of Georgia.


Feb
25
comment ORA-15081: failed to submit an I/O operation to a disk
@Colin'tHart I have changed permissions but still not working. Maybe there is the problem with virtual disk, but don't know how to check.
Feb
25
asked ORA-15081: failed to submit an I/O operation to a disk
Feb
13
comment Oracle installation requires old rpm versions, what to do?
Ok, I will ignore it. I am trying to install old version and then upgrade it to 11.2.0.3
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