You will get some idea about auditing and then you can get back to your friend and ask more about what he wants as there may be issues even if the auditing is enabled.
2. The listeners scans vips are part of nodeapps and managed separately. Cannot comment about the nodes status , you have to check the alert log file to know this.
Yes it is possible to bring it up on one node… for that you need to set the cluster_database=false and threads=1 in the spfile and restore/recover (It will become a single instance database.)
If you want it to be RAC then you can use “ONE NODE RAC” new feature for 11gR2.
In 10.2.0.4, if we do not want to apply patch, we can do this by setting event 5614566 at session level and then using dbms_shared_pool.purge (may have to run dbmspool.sql if purge is not present)
From “ORCL:DISK1” it seems that you are using ASMLIB on your server.
I searched from Metalink and found on doc which explains the same issue as you are having. As per doc, this problem occurs if voting disk is not available to the system.
As I am aware: the node which boots-up first is the master node but if the master node shuts down, the node with the lowest node number will become master node and dynamic remastering of the resources will take place.
To find out the master node for particular resource, you can query v$ges_resource for MASTER_NODE column.
To find out which is the master node, you can see ocssd.log file and search for “master node number”.
This blog reflect our own views and do not necessarily represent the views of our current or previous employers.
The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.
Recent Comments