Post

1 follower Follow
0
Avatar

dbvisit not running on Windows Task Scheduler

dbvisit fail to run inside Windows Task scheduler.

It fail to connect to OracleService and then loops out thinking the database is down.

But it will run in DOS CMD mode without any problem.

To check if it is was settings or permission error, a batch file to login as sqlplus was run with Task Scheduler. It work perfectly, only dbvisit failed.

below is the batch that was run in the task scheduler

sqlplus / as sysdba @write_log.sql
dbvisit JURISDB

the sql script read from the database and spool some data without any problem

I am unable to find the usual support portal, so I am writing in this post.

Pls write to me for more details.

the trace file shows the following when run with task scheduler:

20190313 15:05:33 Standby::Auxiliary::trace-> main::cmn_db_state: logon_type: sysdba
20190313 15:05:33 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: action: stat oracle_sid=jurisdb service=OracleServicejurisdb
20190313 15:05:33 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: win_service: OracleServicejurisdb
20190313 15:05:33 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: Service not ready yet (wait 10) (loop=0)
20190313 15:05:43 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: service=OracleServicejurisdb db_state=
20190313 15:05:43 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: win_service: OracleServicejurisdb
20190313 15:05:53 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: service list empty loop=0
20190313 15:06:03 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: service list empty loop=1
20190313 15:06:03 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: return 49

 

When run manualy in DOS CMD, the trace is:

20190313 15:22:22 Standby::Auxiliary::trace-> main::cmn_db_state: logon_type: sysdba
20190313 15:22:22 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: action: stat oracle_sid=jurisdb service=OracleServicejurisdb
20190313 15:22:22 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: win_service: OracleServicejurisdb 4
20190313 15:22:22 Standby::Auxiliary::trace-> main::UTIL_WIN32_maintain_service: return 4

 

 

Kclai

Please sign in to leave a comment.