I recently ran into a problem that did not make any sense until I delved into a a bit further. I had a stored procedure which did an online index rebuild: CREATE PROCEDURE scott.rebuild_idx_proc AS BEGIN EXEC IMMED ‘ALTER INDEX scott.emp_pk REBUILD ONLINE’; END; / The artery which carries blood to the penis is very …
Category: Uncategorized
Jul 28
11.2.0.2 Upgrade with Standby on RAC
I have been working on upgrading an existing 11.1.0.7 database to 11.2.0.2. This database is on a RAC cluster on Oracle Enterprise Linux 5. After successfully upgrading Oracle Clusterware to Oracle Grid Infrastructure 11.2.0.2, I was looking towards upgrading the database next. The last piece you need to know is that this database is part …
Feb 10
Welcome
Well everyone else is going it, I might as well host my own blog. I intend this blog to focus on the multitude of database topics that I deal with on a regular basis, but I will also write about any IT technology that peaks my interest. Enjoy reading! Thanks, After abducting the site manager …