We have a C # program that we plan to run in the Task Scheduler in Windows Server 2003, designed to delete obsolete files in a folder based on information obtained from several Oracle databases. I can run the application manually, and everything works fine - I registered either as me with administrator rights, or registered as a designated user of a task that has user rights.
When a task user leaves the machine, the application does not work in each database with one of two errors: either
ORA-12504: TNS: SERVICE_NAME in CONNECT_DATA was not reported to the listener
or
ORA-12154: TNS: could not determine the specified connection identifier.
All these databases use a connection string (received from another, SQL Server, database), which, as I said earlier, connects and works very well when working manually. I was everywhere on the Internet, looking for advice that may be applicable to this circumstance, and did not come up with a definitive answer.
Does anyone read this post, who can know the answer to this problem? Any suggestions are welcome.
source
share