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@xxxxxxx<mailto:srcdco@xxxxxxx> | 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@xxxxxxxxxxx>
Sent: Friday, December 3, 2021 3:26 AM
To: Scott Canaan <srcdco@xxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx<mailto:srcdco@xxxxxxx>>
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