Archive for August, 2007
Staging CD/DVD’s for Installation
There are two ways of staging the CD/DVD’s.
1. Traditional Way
In this way we invoke adautostg.pl located at </mountpoint>/Stage11i/startCD/Disk1/rapidwiz, which is part of startCD which invokes below screen wherein we input
a. Staging Directory
b. CD Drive Mounting Command
c. CD Drive [...]
Beware of costly typos “crontab -r”
Folks,
Today, i made a costly mistake in my Production definitely worth sharing !!!
On our HP-UX machine, as ‘oracle’ user , instead of issuing ‘crontab -e’,
i mistyped as ‘crontab -r’ and guess what, ALL MY CRON JOBS VANISHED !!!
******************
/home/oracle> crontab -r
/home/oracle>
/home/oracle> crontab -l
/home/oracle>
*******************
LUCKily i had saved the “crontab -l” listing sometime. So, i edited again
and scheduled [...]
ORA-01194: File # needs media recovery to be consistent
ORA-01194: File 5 needs media recovery to be consistent
When you get the above error if you decide that you have to recover the datafile (or database), think twice. Always you may not have to recover the file. I had faced this scenario in one of the client places. Though the initial plan was to restore [...]
Read Full Post | Make a Comment ( 3 so far )How to recover a table using RMAN backup
This article is about recovering a particular table (which was dropped or truncated) using RMAN backup. I assume that logical backup is not planned as the size of the database is in Terabytes (TB) and RMAN is used for backing up the database. Here tablespace point in time recovery (TSPITR) does not come into picture [...]
Read Full Post | Make a Comment ( 8 so far )crontab: you are not authorized to use cron. Sorry.
One of my applications instance is running on HP-UX 11. I was planning to schedule a hotbackup as a cronjob and realized that “oracle” user did not have proper permissions to set a cron. I got the following error issuing “crontab -e”
”crontab: you are not authorized to use cron. Sorry.”
Googled for it and got the [...]
More diagnostics tests with latest R12 Diagnostics Pack for Jul’07 (6044942)
Few days back, i had posted about Diagnostics and R12.
Basically, i had cribbed about the fact that a lot of Diagnostics tests are yet to be ported in R12. Well, the latest Diag patch has the answers. It provides all of them that you get to see in 11i and more.
As usual, make sure that [...]
What is EUL_DUMVW_YEEHA ?
In our Production 11i environment, we have setup database
read-only roles for all the developers that has limited
access to APPS schema objects. This way, only the DBA team
can perform code migrations in PROD since they have the
APPS password.
The read-only role just has “select” on ALL of APPS’s
views and synonyms. To incorporate future views and
synonyms, there is [...]
