Computing.Net > Forums > Windows Server 2003 > Sqlplus batch script under win2003

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Sqlplus batch script under win2003

Reply to Message Icon

Name: ple
Date: August 9, 2005 at 18:29:59 Pacific
OS: Windows 2003 server
CPU/Ram: 1cpu/512MB
Comment:

Hi there, has anyone experience problem running a sqlplus batch script under win2003 dos shell. I can schedule (with task scheduler) the script to run within 30mins after I logoff from Windows and 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 os authentication to none. I have been struggling with problem for two weeks. It would be nice if someone could help me resolve this issue.

Thanks,
Patrick



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


DHCP Server Won't Assign ... Newb 2003/server question



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows Server 2003 Forum Home


Sponsored links

Ads by Google


Results for: Sqlplus batch script under win2003

FTP batch script www.computing.net/answers/windows-2003/ftp-batch-script/5436.html

Batch script to move/delete files www.computing.net/answers/windows-2003/batch-script-to-movedelete-files/6453.html

Batch script for copying files www.computing.net/answers/windows-2003/batch-script-for-copying-files/6487.html