| Scheduling of scrip using crontab [message #54374] |
Wed, 13 November 2002 22:06  |
kalpaj
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
hi
I am having my oracle8i on sun solaris7. every day
i have to load on flat file by putting all file through
ftp to server. by executing one executable file which
will load flat file to oracle.
everyday i have to do this.
now i want schedulise this process by putting
command in crontab.
30 19 * * 1-/source/product/Application/Run/EXPload 01 2>/expimp/UploadOraErr.log
30 20 * * 1-6 /expimp/fileupload.sh /expimp/Error.log
but i getting error --- ORA-12541: TNS:no listener
but if i run these command physically it is working
perfactly.Even there is schedulise scrip for Exporting
database which is working perfactly
I have put this command in Oracle8i user and also
in root crontab.
Anybody will help me in this matter it will great help for me
kalpaj
|
|
|
|
| Re: Scheduling of scrip using crontab [message #54386 is a reply to message #54374] |
Thu, 14 November 2002 11:30  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Your environment is different under cron than when you do an interactive login. Depending on your shell, you will be using .profile .kshrc or whatever. You can include your environment into your shell script - or run an environment script before your actual script.
To see the difference in environemnt, you can do a diff on 2 logfiles:
1.) from telnet session:
env > telnet_session.log
2.) submit a cronjob:
env > cron_session.log
Assuming you are using .profile, trey this:
30 20 * * 1-6 $HOME/.profile; /expimp/fileupload.sh /expimp/Error.log
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
