Oracle Restart and Third Party Applications - possible?

  • From: Martin Klier <usn@xxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Wed, 11 Jul 2012 17:21:22 +0200

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

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


Other related posts:

  • » Oracle Restart and Third Party Applications - possible? - Martin Klier