RE: Oracle / Spirion

Well, we got it to work. Apparently there is a bug in their system when you copy a job schedule to make a new one, it doesn’t work. If you create a job schedule from scratch, it works. That was after the technical person insisted that they needed RDP access to the database server and the database login needed sysdba privs, neither of which they were going to get.

Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

From: Neil Chandler <neil_chandler_at_hotmail.com> Sent: Friday, December 3, 2021 3:26 AM
To: Scott Canaan <srcdco_at_rit.edu>
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle / Spirion

CAUTION: This message came from outside RIT. If you are unsure about the source or content of this message, please contact the RIT Service Center at 585-475-5000 or help.rit.edu before clicking links, opening attachments or responding.

Not used aspirin but my money would be on a (lack of) environment (variable) setting in the scheduler. Neil.
sent from my phone

On 2 Dec 2021, at 20:15, Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> wrote: 
Does anyone use Spirion against their Oracle databases? We are testing against an Oracle 19.13 database. If we start the scan interactively, it works. If we try to run the scan through the Spirion scheduler, it fails, saying it can’t connect to the database. Spirion is insisting that it’s an Oracle issue, even though the Oracle client on the Spirion server can connect to the database.

If anyone has run into this and knows what the issue is, I’d appreciate you letting me know. The Spirion technical person insists that it isn’t their problem.

Thank you,

Scott Canaan ‘88
Sr Database Administrator

--
http://www.freelists.org/webpage/oracle-l