teachmeoracle.com

[sarfaraz]

1. While applying a patch how to skip a pre-requisites of that patch?

2. Your system is not rapid-clone enable and you have to clone it without shutting down the database and also end user should not be affected how to do that. You can't use :
SQL> alter TS TS_NAME begin backup;
command as if you write this some end user will be affected.

3. If by mistake you have change patch of $ORACLE_HOME and patch of bdump file. What error you will get when you will try to start the database?

4.Core dump folder is created for what purpose?

5.What should be the minimum kernel version to install R-12

6.Why the password of guest user “ORACLE” is in CAPS at $FND_SECURE
GUEST_USER_PWD=GUEST/ORACLE

7. Suppose there are 5000 tables in a particular TS but you want to take backup of 3500 tables how can it possible?

8. If by mistake you will delete the alert_SID.log file the oracle engine will automatically create a new one. But how to recover the previous alert.log file?

9. What exactly happen when you execute alter database backup controlfile to trace;

Thanks & Regards
_________________
Sarfaraz Karim
APPS DBA

[atul_iiit]

1. While applying a patch how to skip a pre-requisites of that patch?

Use options with adpatch like (in latest ad patchsets prereqs are not checked)

options=noprereq

2. Your system is not rapid-clone enable and you have to clone it without shutting down the database and also end user should not be affected how to do that. You can't use :

Take hot backup of database or use old backup and apply archives to roll forward . This is for database clone

For Middle tier clone - copy file system in normal cloning way. You don't have to shutdown middle tier

3. If by mistake you have change patch of $ORACLE_HOME and patch of bdump file. What error you will get when you will try to start the database?

What do you mean by change patch ? (Is it path ?)

If ORACLE_HOME is not set properly you will not be able to start db, you will get error like initialization file not found..

4.Core dump folder is created for what purpose?
In case oracle process core dump in case of any issues , this will go in cdump directory

5.What should be the minimum kernel version to install R-12
Which operating system ? (windows, linux, solaris...)
Check respective o.s. installation guide


6.Why the password of guest user “ORACLE” is in CAPS at $FND_SECURE
GUEST_USER_PWD=GUEST/ORACLE

Because this is way it si stored in database (in old release of apps passwords used to be case insensitive but now a days they are case sensitive - This behaviour is driven by profile option)

Useraname & Password for GUEST in database are set via autoconfig


8. If by mistake you will delete the alert_SID.log file the oracle engine will automatically create a new one. But how to recover the previous alert.log file?

Don't know

9. What exactly happen when you execute alter database backup controlfile to trace;

Google it there is lot of information on net or I'll cover this at http://onlineappsdba.com soon
_________________
Atul Kumar
Apps DBA
http://OnLineAppsDBA.com