mschwach
Active participant

Oracle LMS detection in a Clustered env. with failover Servers

When discovering Oracle DB-Instanzes in a clustered env with one failover Server, Oracle LMS detection throws an Error on the failover Server, let's call him "B". Error is about a missing Instanz which is configured on "B" but not running.

Instanz is currently running on Server "A" and "B" has only configurations for this Instanz. So in case of Errors, "B" can take over from "A".

Oracle error is also complaining about a missing a directory, which is located on a NFSshare. In case of errors this share will switch from "A" to System "B", but is not present during the OracleLMS-scan.

So, seems like an Oracle-false-positiv message, which is confusing.

Any idea how to handle this?

7 Replies
JohnSorensenDK
Moderator Moderator
Moderator

Re: Oracle LMS detection in a Clustered env. with failover Servers

@mschwach 

I'm a little confused about your description that I'm interpreting into that the Oracle LMS scan fails on server "B", but at the same time you're claiming that it results in "false positives". Do you see the Oracle instances running on server "B" in the Oracle Instances view although the scan has failed?

Thanks,

mschwach
Active participant

Re: Oracle LMS detection in a Clustered env. with failover Servers

Hello JohnSorensenDK

the Instanz is not running on "B". B is only prepared to take over from A in case of Errors.

When scanning B with FlexNet Agent 2020 R1 - we can see following error message in tracker.log:

 

[Fri Nov 20 09:54:21 2020 (G, 0)] {56951004} WARNING: Configuration properties for the Oracle home "/pkg/addp/oracle/base/product/12.1.0/dbhome_1" could not be discovered and instances in this home will not be inventoried.
[Fri Nov 20 09:54:21 2020 (G, 0)] {56951004} +-- "/pkg/addp/oracle/base/product/12.1.0/dbhome_1": Discovered by = Oratab, Executable ID = 0:0, DBA group = "dba", Home owner = "", Has SQLPlus = false, SQLNet Authentication Services = "", Can Inventory = false, Real Home = ""
[Fri Nov 20 09:54:21 2020 (G, 0)] {56951004} | +-- Instance "LISTENER_addp": Discovered by = Oratab, Process ID = 0, State = unknown, Process owner = "<N/A>"
[Fri Nov 20 09:54:21 2020 (G, 0)] {56951004} | +-- Instance "addp": Discovered by = Oratab, Process ID = 0, State = unknown, Process owner = "<N/A>"
[Fri Nov 20 09:54:21 2020 (G, 0)] {56951004} WARNING: The SQLPlus command was not found in Oracle home "/pkg/addp/oracle/base/product/12.1.0/dbhome_1".
[Fri Nov 20 09:54:21 2020 (G, 0)] {56951004} WARNING: Did not detect instance "LISTENER_addp" in "/pkg/addp/oracle/base/product/12.1.0/dbhome_1" to be in a running state.
[Fri Nov 20 09:54:21 2020 (G, 0)] {56951004} WARNING: Did not detect instance "addp" in "/pkg/addp/oracle/base/product/12.1.0/dbhome_1" to be in a running state.

 

Also in our FNMS reports we can see following errormsg for this particular instanz.

Unable to gather Oracle database information, sqlplus or sqlnet.ora file may be missing for oracle home: /pkg/addp/oracle/base/product/12.1.0/dbhome_1

 

We thought that's an Error so we investigated with our DB-Admins, they told us, it's not an Error because the System is prepared for the Instanz but it is currently not running there.

Maybe the false-positiv statement is wrong here. Sorry for the confusion. 

 

 

 

 

 

 

0 Kudos
JohnSorensenDK
Moderator Moderator
Moderator

Re: Oracle LMS detection in a Clustered env. with failover Servers

@mschwach 

No worries, just want to make sure that your expectations are being addressed...

The error message indicates (correctly as I understand your scenario) that the Oracle instance isn't currently running on server "B", and therefore it obviously cannot run the Oracle LMS scripts against the instance database.

So please allow me to return to your expectations now, i.e. which outcomes did you expect the FlexNet inventory to collect from server "B"? Do you need to somehow make both server "A" and server "B" consume from an Oracle license?

Please elaborate on this.

Thanks,

0 Kudos
mschwach
Active participant

Re: Oracle LMS detection in a Clustered env. with failover Servers

Hi JohnSorensenDK,

we're a little afraid to chase possible Errors just to find out, that's not an Error.

In my honest opinion, I've would have expected that OracleLMS-scans or FlexNet Agent could give a hint, that this particular System might be part of a cluster and therefore the failure message in tracker.log - or somewhere else - is more precise about the current situation.

Else wise, as an global acting company, we've a lot of Oracle DBs installed. And this error message appears for almost 100 Systems.

hope this helps

regards,
Matthias

0 Kudos