Friday, February 01, 2008

Questions needed answers

Dears apps dbas,
I hope thing are well with you, I received the following questions from a friend of mine and I promised him to answer them and wanted to share them with you maybe you can help me answer most of them.
Appreciate your help.

(we have some of the answers by dave (thank you) in the comments and all of them under http://www.teachmeoracle.com/forum/viewtopic.php?t=4102)

1. How do we know that particular instance is cloned or normal installed?
2. How can you know that how many modules are already implemented in this instance?
3. How to enable archive log without shutting down your database?
4. How can we know that whether we already applied latest AUTOCONFIG patch or not at our instance?
5. Is this possible to clone a database from hotbackup? If yes plz tell how?
6. Suppose your database size is 2000GB now you want to clone a particular one datafile or tablespace. Plz tell how co clone a datafile or tablespace?
7. You are applying a patch but suddenly it HANGS but log file didn’t showing any error what should be the reason for that HANG?
8. How to clone from multimode to single node?
9. How to apply patch on forms/reports server?

Thanks again for help
Fadi

3 comments:

Dave said...

Here are a couple of quick answers, however, some are more involved and not enough room in a comment section.

1. How do we know that particular instance is cloned or normal installed?

Hrmm.. Good question.. You could always look in $APPL_TOP/admin and see the context files. If this system is not the primary then you'll see context files from other environments. (If they weren't cleaned up after the clone.)

Also, you could check apps.fnd_nodes. This table seems to have stale data after a clone.

2. How can you know that how many modules are already implemented in this instance?

I would check licensing via OAM. See how many modules your licensed for. You can also look at the output from patchsets.sh, this will tell you which modules are fulling installed, shared, etc.

3. How to enable archive log without shutting down your database?

You can't.

4. How can we know that whether we already applied latest AUTOCONFIG patch or not at our instance?

Either check ad_bugs for the latest ad patch number or run patchsets.sh.

5. Is this possible to clone a database from hotbackup? If yes plz tell how?

Yes, we use rman's duplicate to refresh the database each night. Check section 4 of note: 230672.1

6. Suppose your database size is 2000GB now you want to clone a particular one datafile or tablespace. Plz tell how co clone a datafile or tablespace?

You can't. Currently, there isn't a supported method i'm aware of to either clone a single dataifle/tablespace or reduce the amount of data. However, there may be 3rd party tools.

7. You are applying a patch but suddenly it HANGS but log file didn’t showing any error what should be the reason for that HANG?

If nothing is in the logfile check for database locks. Sometimes, depending on the number of workers you spawn, they could lock each other. Kill the lock, or kill all the patch processes, restart the database and continue with the patch.

8. How to clone from multimode to single node?

Bit long for a comment section. Oracle describes this in note: 230672.1

Section 4 contains information on multinode to singlenode.

9. How to apply patch on forms/reports server?

Set your ORACLE_HOME to IAS_ORACLE_HOME and execute the patch script.

Anonymous said...

For answers, check this
http://www.teachmeoracle.com/forum/viewtopic.php?t=4102

fhasweh said...

thanks dave, good answers.

fadi