Discovery not consistently getting Oracle instance version (Quebec)

[David77]

We are able to successfully populate the CMDB with Oracle Instance, but only a small percentage show a version. 
I've read the post, linked to below, but not sure I understand why it's working for some, but not others. We have not made any modifications to the Discovery Patterns. 

Thanks!

https://community.servicenow.com/community?id=community_question&sys_id=8d52af09db8181d0fd63250913961992&anchor=answer_a2b6683d1b89091056b699b8bd4bcbba&view_source=searchResult 

[Rahul Priyadars · Accepted solution]

For Servers running Oracle and Version not getting Populated , Please run Oracle Pattern ((Oracle DB On Unix or Oracle DB On Windows)) in Debug Mode and see the Output of Below pattern Step-

Oracle DB On Unix for example - need to see the Output of below STEPS.

Hope this helps

Regards

RP

[David77]

Thanks!, I'll look into this right now, and more a correct when I figure out how to do this. 

[David77]

Turns out it's failing on this command

Command: ORACLE_HOME=;/bin/sqlplus -v
Result: sh: /bin/sqlplus: No such file or directory

Our DBA is telling my sqlplus is not in the bin directory, but I seem to recall it is, but have no login to the system to verify this as accurate. Thoughts?

[William44]

You can use the command prompt button next to the Debug Mode button on the top right to enter a command prompt session on the server and view the contents of the directory (ls /bin) or to search for sqlplus (find / -name "sqlplus") 

Though sqlplus may not be installed on the system.  Or you can ask the DBA where sqlplus is installed.

If it's not been disabled, you can use the command line console from ServiceNow:

https://[instancename]/SaCmdManager.do?ip=[Target IP]