HA Oracle startup/shutdown question
Environment:
2 Sunfire V890's running solaris 2.9 and SC3.1U4
Hello All,
I am having a problem with oracle startup and shutdown in my cluster. In order to get oracle to startup after a failover, shutdown what have you, I need to implement the following procedure as a pre/post oracle startup operation/script. Can anyone tell me if there is a place or hook in the HAOracle agent where I can add my own operation? I would rather avoid having to write a GDS agent in order to do this, if it is at all possilble.
Thanks,
George Cebulka
PS
Please Note: (This is a DBA thing, not mine!)
************** Begin *********************
After a failover or startup we need following to avoid the 揳uthentication error?br>1. remove the sqlnet.ora soft link from $ORACLE_HOME/network/admin
1. rm /global/oracle/oracledb/oraclev10201/network/admin/sqlnet.ora
2. Create a new soft link to sqlnet.ora in $ORACLE_HOME/network/admin as following
1. ln 杝 /global/pitt/dba/network/net8/sqlnet.ora /global/oracle/oracledb/oraclev10201/network/admin/sqlnet.ora
3. startup the database and listeners (using cluster database).
4. Now database is up and running and we need to turn on radius authentication for which we need this post stuff
5. Remove the sqlnet.ora link
1. rm /global/oracle/oracledb/oraclev10201/network/admin/sqlnet.ora
6. Create a new soft link to replace sqlnet.ora with radius sqlnet.ora
1. ln 杝 /global/pitt/dba/network/net8/sqlnet.ora.radius /global/oracle/oracledb/oraclev10201/network/admin/sqlnet.ora
*************** End ******************
[1667 byte] By [
gcebulkaa] at [2007-11-27 6:44:38]
# 2
Nope, haven't logged a support call yet.
The problem that we are having is one of authentication.
In order for Oracle to start up, it needs to use local authentication. Once oracle has started, we need to switch to radius authentication so all of our users can connect and use the data warehouse. So, Oracle won;t start using radius authentication and users can;t work using local authentication.
Basically what I need to do is use the local sqlnet.ora file when oracle is starting and then change to sqlnet-radius.ora file once the db is up and running. So what I am hoping for is a hook in the HAoracle DS to do the pre and post startup operations. I could modify the Sun supported oracle scripts, but, due to support issues I'd rather not do this.
George
# 5
You could also try the following:
Create two GDS agents, where you need to include the steps to disable the pmf action script, which I describe in a blog at
http://blogs.sun.com/TF/entry/disabling_pmf_action_script_with .
This is needed since your scripts will not leave a process running for PMF.
1. GDS resource (for this example I call it ora-prestart-rs):
Start_command: It will do the steps to implement the original sqlnet.ora file + the steps from the blog
Probe_command: /bin/true
Stop_command: not needed
2. GDS resource (for this example I call it ora-poststart-rs):
Start_command: It will do the steps to setup the link for the radius sqlnet.ora file + the steps from the blog
Probe_command: /bin/true
Stop_command: It will do the steps to re-implement the original sqlnet.ora file
Then you create the following resource dependencies (here I assume the name for the SUNW.oracle_server resource is ora-rs):
scrgadm -c -j ora-rs -y Resource_dependencies=ora-prestart-rs
scrgadm -c -j ora-poststart-rs -y Resource_dependencies=server-dwdd-rs
Maybe you need to setup the same dependencies to include the SUNW.oracle_listerner resource. You did not mention which of those is facing problems.
Of course, I never tried this. But this would enable you to use the HA Oracle agent unchanged.
Greets
Thorsten
PS: I forgot to also mention that you need to set the Restart_type extension property for the SUNW.oracle_server resource to RESOURCE_GROUP_RESTART:
scrgadm -c -j ora-rs -y Restart_type=RESOURCE_GROUP_RESTART
That way a triggered restart by ora-rs will allways force the RG to go through stop/start - and only then the link will get set back to the sqlnet.ora the SUNW.oracle_server needs to work correctly.
Note again - this is theory and needs proper testing.
Message was edited by:
Thorsten.Frueauf
