Oracle Startup scripts.

. #!/bin/bashset-xsu-oracle >>eonlsnrctl Startsqlplus/nolog >>eofconn/as SysdbastartupexitEOFexitEON

We often use the <<eof redirect input in the shell script to input the command string we entered as an execution program, so that we do not need to manually enter the command in that program environment in order to automate the functions we need, such as:

[Plain]View Plaincopy

2. Sqlplus EMSSXJK/EMSSXJK <<eof
4. Select COUNT (*) from Sncn_yxyj where create_date like sysdate;
6. Eof

The SQL statement is equivalent to the input in the Sqlplus program environment, so that the input content is sandwiched between two eof, can be long and short, EOF can also be replaced by any other character, case, as long as the pair appears, for example:

[Plain]View Plaincopy

2. SQLPLUS&NBSP;EMSSXJK/EMSSXJK&NBSP;<<STD&NBSP;&NBSP;
4. Select COUNT (*) from Sncn_yxyj where create_date like sysdate;
6. STD

Of course , this iconic character cannot be reserved, the most commonly used or EOF.

Note that the first EOF must start with the redirect character <<, and the second EOF must be shelf written, otherwise it will be an error.

Let's look at an example of automatic ftp:

[Plain]View Plaincopy

2. #ftp data to 10.178.37.244
4. rq= ' Date +%y%m%d '
6. Cd/data/product/song
8. Ftp-i-N <<!
10. Open 10.178.37.244
12. User Oracle Post
14. CD EMS
16. Bin
18. Put ${rq}.dat
20. Bye
22. !

Oracle Startup scripts.