Hi there,

Has anyone experience problem running a sqlplus batch script under win2003 dos shell. I can schedule a script to with ask scheduler to run within 30mins after I logoff from Windows. It would run fine in the background as a system process. However, the job would fail when I schedule it for midnight or 5 hours later. I get an error ora-12560 TNS protocol adapter error. I tried setting the oracle environment (like oracle_home) in the script and Windows registry, but get the same results. I also checked the sqlnet.ora parameter and set the sqlnet.authentication_service to none.

my script

test.cmd

@echo off

sqlplus -s test/test@EBS @c:\home\test\test.sql

Error:

ORA-12560 TNS protocol adapter error

This only occurs after I logoff for some time.

Any help would be great.

Thanks,
Patrick -- working2hard ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------

Install MSI remotely - problem
remote scripting how to
Get returned information from ping
Changing Ip addresses in script?
ping subnet