Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE 11G - "sourplum" command?

chillychinJan 3 2018 — edited Jan 25 2018

I am seeing something very peculiar in my OBIEE 11g installation

We recently had a power outage at work, and were in the midst of restarting our servers.

I noticed in our production server that the processes that are running are as follows

pastedImage_0.png

The process or command I have in question is "sourplum"

Its really sucking up all the server resources, and when comparing to my DEV and QA enviroments I do not recognize this at all.

Looking at the start logs (/obiee-start.log) I also see this error popping out

pastedImage_1.png

Can not run program power shell.

When I quickly googled what is sourplum I am seeing malware warnings.

Does anyone know what this could be? Is it a virus of some sort?
This post has been answered by Ariel_S on Jan 8 2018
Jump to Answer

Comments

Gary Graham-Oracle

You do not say which version of SQL Developer is in use, which JDK, which OS, whether Thin or OCI/Thick JDBC driver, etc., etc.  However, assuming recent versions not subject to old, known bugs, you may just need to read this blog post...

http://www.thatjeffsmith.com/archive/2013/03/why-cant-i-see-my-tables-in-oracle-sql-developer/

1 person found this helpful
2933934

Thank you, Gary.

I updated the post with the version info. I did not explicitly install this JDBC driver, so whatever the OSD came with?  Unless it is using whatever is installed on my machine, in which case would be the thin driver.

I did check out that post, and I appreciate you sharing it. I did click the 'include synonyms' filter, but behavior remained unchanged.

I would prefer to use OSD, and that is what our dev team was expecting to use, but we just can't see the information.  We are using an ID that does not 'own' those tables, per se.  But, why would DBVisualizer show these tables, when OSD does not?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 5 2018
Added on Jan 3 2018
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
1 comment
451 views