Execute shell script under Linux to call SQL file and transfer it to remote server

1. To write sql.

2. To write shell,shell In the use sqlplus call sql File generation csv file , Also write information about the peer server .

3. What will be written sql and shell File transfer to linux Server

4. Switch to the file storage directory , Use the following command to execute shell：

sh -x ******.sh                ( Direct execution of scripts )

nohup sh -x ******.sh &        ( Executing scripts in the background )

ps -ef|grep ***                ( See about the threads of this script , Confirm that it is in execution )

5. After successful execution, you can view the log in the specified directory , See if there's a mistake .

6. View the generated csv file

7.ftp To the peer server , Check whether the file has been transferred ：

ftp Peer server ip

Enter your username and password

ls * file name *                (* Fuzzy query can be done )

8. Query to , Transmission successful .

Other commands used ：

crontab -l                View all scheduled tasks

ls -ltr                        Under the display directory , Files are sorted by time

kill -9 Process number               Delete the process with the specified process number , Note that the process number here is best copied , Avoid possible wrong input