Oracle DB Service Mapping

[Jason_DaSilva]

Good day to all,

We are having some issues with Service Mapping on our Oracle DBs.  We are running into a lot of permission issues, but specifically we are seeing that commands like these are failing (OC4J Connectivity Step 16):

$process.currentDir + "/opmn/bin/opmnctl @farm status -noheaders -fsep \"|\" -fmt %cmp%prt%clu%ins%por"

There are a few things that I would like to point out with this failing.  Our Oracle team insists that our setup is standard, but our folder structure does not contain /opmn.  That part of the path is not there for us.  I did correct this by removing it from the path (making my own OC4J Connectivity copy to make these changes), but that is the first thing that strikes me as wrong.

When we run this command we get a definite permission fail.  The file does exist here, as we can run this command and get back a result:

sudo ls -la /MAINSERVER/app/fs1/FMW_Home/webtier/instances/123_web_MAINSERVER_ABC/bin/opmnctl
 
I have also tried to add 'sudo' infront of the status run, but that too errors out, though with a slightly different error of OPMN cannot run as the root user
opmnctl status: opmn is not running

They seem to think that this is a ServiceNow problem, and don't seem to want to help further without some insight from ServiceNow.  Can anyone share experiences like this and how you got around it?

[Stev Williams1]

@Jason_DaSilva Hi Jason, appreciate this was a long time ago but did you ever get a resolution to this?

[Jason_DaSilva]

@Stev Williams1 ,
Sorry, but no.  And our company has shifted focus now to strip out the 5 years of customization we have in HAM as we move to HAM Pro.  We will probably go back to it later.  At that point I may come looking for answers again.