Database Administration (MOSC)

MOSC Banner

Task scheduler with ORA-01017

edited Mar 11, 2022 9:51PM in Database Administration (MOSC) 8 commentsAnswered

Hi

I have a task scheduler process running daily on servers that are all configured the same way. The process works on all of them except one server with error ORA-01017.

If I run the script in a cmd window it works fine, but if I run it via the task scheduler process, it doesn't. The process runs under the SYSTEM account as on the other servers.

The command that is run manually or in the powershell script is:

sqlplus /@TEST as sysdba

Task scheduler process error ORA-01017: invalid username/password; login denied.

Already tried:

  • orapwd file=%ORACLE_HOME%\database\PWDTEST.ora password=<passw> entries=10 force=y

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center