Oracle Restart and Third Party Applications - possible?

From: Martin Klier <usn_at_usn-it.de>
Date: Wed, 11 Jul 2012 17:21:22 +0200
Message-ID: <4FFD99F2.9070409_at_usn-it.de>

Dear list,

I am using the option to protect and manage third party applications since 11.2 Grid Infrastructure is out, and I am quite happy with it. My approach is the script agent, execution scripts as root or other users.

Today for the first time I tried to do the very same with a single node, running Oracle Restart, that's based on the same grid architecture.

The first and most prominent problem is, that the OCW alert log shows the following:

scriptagent.bin(3911)
CRS-5821:Agent /u01/app/11.2.0/grid/bin/scriptagent_root' is started with wrong user 'oracle'.
Details at (:CRSAGF00116:) {0:22:2} in
/u01/app/11.2.0/grid/log/sp-a-mfr-a1/agent/ohasd/scriptagent_oracle/scriptagent_oracle.log

The mentioned detail is:

2012-07-11 16:32:55.191: [ AGFW][1097951552] {0:22:2} Created alert : (:CRSAGF00116:) : Agent is started with wrong userId: oracle , expected userId: root
(see full log entry below for better reading here)

My 3rd party resource was added by root, (tried the other way, to reconfigure it to owner root, as well), and everything in scripts, types and attribute files used for creating the resource is absolutely identical to another system, spare the fact that we are running a two node cluster there, not Restart.

Different to all my Grid Infrastructure systems, I can't see anything indicating that there is a scriptagent_root doing its work, or even attempt to do so (no log file, mostly).

THE QUESTION:
Is it proven possible or supported to so what I described, with Oracle Restart?

The desire behind my action is to keep scripts and process management stuff similar, no matter wether we have a cluster or single machine deployment.

Thanks a lot in advance!
Martin Klier
Senior DBA

---

scriptagent_oracle.log

2012-07-11 16:06:29.436: [ AGFW][1105213760] {0:19:2} Agent is exiting with exit code: 1
2012-07-11 16:32:55.176: [ AGFW][2615195376] Starting the agent:
/u01/app/11.2.0/grid/log/sp-a-mfr-a1/agent/ohasd/scriptagent_oracle/
2012-07-11 16:32:55.177: [ AGENT][2615195376] Agent framework initialized, Process Id = 3911
2012-07-11 16:32:55.177: [ USRTHRD][2615195376] Added resource type [klug.iwacs.type] to the agent framework 2012-07-11 16:32:55.177: [ AGFW][2615195376] SERVER IPC CONNECT STR: (ADDRESS=(PROTOCOL=IPC)(KEY=OHASD_IPC_SOCKET_11))

2012-07-11 16:32:55.177: [    AGFW][2615195376] Agent' version is: 2
2012-07-11 16:32:55.177: [CLSFRAME][2615195376] Inited lsf context 0x17dfe30
2012-07-11 16:32:55.177: [CLSFRAME][2615195376] Initing CLS Framework

messaging

2012-07-11 16:32:55.177: [CLSFRAME][2615195376] New Framework state: 2
2012-07-11 16:32:55.177: [CLSFRAME][2615195376] M2M is starting...
2012-07-11 16:32:55.188: [ CRSCOMM][2615195376] Ipc: Starting send thread
2012-07-11 16:32:55.188: [ CRSCOMM][1081313600] Ipc: sendWork thread

started.
2012-07-11 16:32:55.189: [ CRSCOMM][1095850304] IpcC: IPC Client thread started listening
2012-07-11 16:32:55.189: [ CRSCOMM][1095850304] IpcC: Received member number of 22
2012-07-11 16:32:55.189: [CLSFRAME][2615195376] New IPC Member:{Relative|Node:0|Process:0|Type:2}:OHASD:sp-a-mfr-a1 2012-07-11 16:32:55.189: [CLSFRAME][2615195376] New process connected to us ID:{Relative|Node:0|Process:0|Type:2} Info:OHASD:sp-a-mfr-a1

2012-07-11 16:32:55.189: [CLSFRAME][2615195376] Tints initialized with
nodeId: 0 procId: 22
2012-07-11 16:32:55.189: [CLSFRAME][2615195376] Starting thread model

named: MultiThread
2012-07-11 16:32:55.190: [CLSFRAME][2615195376] Starting thread model named: TimerSharedTM
2012-07-11 16:32:55.190: [CLSFRAME][2615195376] New Framework state: 3 2012-07-11 16:32:55.190: [ AGFW][2615195376] Agent Framework started successfully

2012-07-11 16:32:55.190: [    AGFW][1097951552] {0:22:2} Agfw engine
module has enabled...
2012-07-11 16:32:55.190: [CLSFRAME][1097951552] {0:22:2} Module Enabling

is complete
2012-07-11 16:32:55.190: [CLSFRAME][1097951552] {0:22:2} New Framework state: 6
2012-07-11 16:32:55.190: [CLSFRAME][2615195376] M2M is now powered by a doWork() thread.
2012-07-11 16:32:55.191: [ AGFW][1097951552] {0:22:2} Created alert : (:CRSAGF00116:) : Agent is started with wrong userId: oracle , expected userId: root

2012-07-11 16:32:55.191: [    AGFW][1097951552] {0:22:2} Agent sending
message to PE: AGENT_SHUTDOWN_REQUEST[Proxy] ID 20486:11
2012-07-11 16:32:55.193: [    AGFW][1097951552] {0:22:2} Agent is

shutting down.
2012-07-11 16:32:55.193: [ USRTHRD][1097951552] {0:22:2} Script agent is exiting..

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 11 2012 - 10:21:22 CDT