Highlighted
Intrepid explorer

Error for Oracle Inventory

Hi guys,

I'm trying Oracle Inventory with standalone scanning on Solaris SPARC.

But there was an error gcc library error when i ran ./ndtrack on /libexec so I just tried to run ./ndtrack on /bin folder but there were very small sized Oracle.ndi.gz and tracker.log stated log as following

=====================================================

[Fri May 22 16:09:58 2020 (G, 0)] {1697} ===== Discovered Oracle database instances and listeners

[Fri May 22 16:09:58 2020 (G, 0)] {1697} +-- "/oracle/app/oracle/product/920": Discovered by = Oratab, Executable ID = 0:0, DBA group = "dba", Home owner = "", Has SQLPlus = false, SQLNet Authentication Services = "", Can Inventory = false, Real Home = ""

[Fri May 22 16:09:58 2020 (G, 0)] {1697} |   +-- Instance "KKKDB": Discovered by = Oratab, Process ID = 0, State = unknown, Process owner = "<N/A>"

[Fri May 22 16:09:58 2020 (G, 0)] {1697} +-- "/oracle/app/oracle/product/816": Discovered by = Process,Environment, Executable ID = 34078720:1533444, DBA group = "dba", Home owner = "oracle", Has SQLPlus = true, SQLNet Authentication Services = "", Can Inventory = true, Real Home = ""

[Fri May 22 16:09:58 2020 (G, 0)] {1697} |   +-- Instance "KKKDB": Discovered by = Process, Process ID = 3067, State = running, Process owner = "oracle"

[Fri May 22 16:09:58 2020 (G, 0)] {1697} |   +-- Listener "LISTENER": User = "oracle", Discovered by = Process.

[Fri May 22 16:09:58 2020 (G, 0)] {1697} WARNING: The SQLPlus command was not found in Oracle home "/oracle/app/oracle/product/920".

[Fri May 22 16:09:58 2020 (G, 0)] {1697} WARNING: Did not detect instance "KTEDI1" in "/oracle/app/oracle/product/920" to be in a running state.

[Fri May 22 16:09:58 2020 (G, 0)] {1697} Oracle database instances were discovered for inventory.  Executing inventory queries on database instances.

[Fri May 22 16:09:58 2020 (G, 0)] {1697} Started tracking Oracle instance "KKKDB" in "/oracle/app/oracle/product/816".

[Fri May 22 16:09:58 2020 (G, 0)] {1697} |   The 'VersionNumber' Oracle database query failed to return a result.

[Fri May 22 16:09:58 2020 (G, 0)] {1697} Failed to inventory Oracle instance "KKKDB" in "/oracle/app/oracle/product/816".

[Fri May 22 16:09:58 2020 (G, 0)] {1697} Oracle inventory queries on database instances are complete.

[Fri May 22 16:09:58 2020 (G, 0)] {1697} Finished tracking Oracle database instances using inventory recognition rules

[Fri May 22 16:09:58 2020 (G, 0)] {1697} Started tracking Oracle listeners

[Fri May 22 16:09:59 2020 (G, 0)] {1697} Finished tracking Oracle listeners

==================================================

 

regards,

gotqcorp

0 Kudos
16 Replies
Highlighted
Consultant

Re: Error for Oracle Inventory

Hi @gotqcorp ,

What oracle version do you have on machine? As far as I remember Oracle 9 is not supported by the Flexera agent, the inventory must be done remote from beacon.

 

Highlighted
Active participant

Re: Error for Oracle Inventory

@gotqcorp 

KKKDB ((path: /oracle/app/oracle/product/816)

It seems to be a Oracle 8i database which is not supported by the agent and requires direct inventory beacon connection.

The message  "The 'VersionNumber' Oracle database query failed to return a result." is also for me the usual indicator for an version 8i.

 

KTEDI1 (path /oracle/app/oracle/product/920)

This one seems to be an Oracle 9i database

It it shows 2 issues for that one.

1. WARNING: The SQLPlus command was not found in Oracle home "/oracle/app/oracle/product/920".

2. WARNING: Did not detect instance "KTEDI1" in "/oracle/app/oracle/product/920" to be in a running state.

Those 2 warnings should be checked.

 

Regards,

Alexander

 

Highlighted
Community Manager Community Manager
Community Manager

Re: Error for Oracle Inventory

@adrian_ritz1 - I suspect you may be thinking of Oracle Database 8i, which must be inventoried using a direct connection from a beacon rather than using the FlexNet agent.

But you may be on the right path here: the home directory of the instance KKKDB is "/oracle/app/oracle/product/816", so if the "8" in this path is indicative that the Oracle version is indeed 8i then that would indeed explain why the agent is not gathering Oracle inventory. Use the beacon inventory gathering capability instead for that scenario.
(Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".)
Highlighted
Consultant

Re: Error for Oracle Inventory

@ChrisG , you are right, I was thinking at Oracle 8, typo error 🙂

 

0 Kudos