Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Unix...
Info:
ps
Oracle...
Script:
TO_CHAR, double pipe (||)
Unix...
Tip:
Eseguire pił comandi in una sola linea
PLSQL...
Script:
Record
Unix...
Tip:
Rimuovere un file in Unix / Delete a file
Shell scripting...
Script:
How to get size or other file info in a shell script
A User Agent, like a web browser, uses HTTP to request a HTML document
Php Funzione mail()
In programming the danger of exploring the small details of coding is that you get obsessed with every line of code you write, thereby greatly reducing productivity.
In general, is not worth obsessing over code. On the other hand you should code with deliberation and intent. Steven Feurstein Oracle Magazine July /August 2004 A User Agent, like a web browser, uses HTTP to request a HTML document
|
Unix
Home >Unix > Shell script extract items and looping
The shell will extract the db names:
This basic shell script read all first words (but not lines beginning with #) on each line of a file, like, for examples, db name listed on oratab. for each word (in my example db) an action can be issued. If oratab is the input file: # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # CUSTOMER01:/product/oracle/10g2:N CUSTOMER02:/product/oracle/10g2:N
#!/usr/bin/ksh
## mm 2006-09-11 testend on HP-UX, SunOS #some basic controls if [ $# -ne 1 ] then echo "Usage : $0 file" echo "Example : $0 /etc/oratab" exit 1 fi if [ -f $1 ] then vlist=`grep -v \# $1 | cut -f1-1 -d:` # grep list else echo "ERROR: cannot get file $1" exit 1 fi for velement in ${vlist} do echo ${velement} #action assuming sysdba os authentication export ORACLE_SID=${velement} sqlplus -s /nolog<<eofs spool ${velement}.LOG conn sys as sysdba alter database backup controlfile to trace; quit eofs done To run the script: # HP-UX $ t.ksh /etc/oratab # SunOS $ bash t.ksh /var/opt/oracle/oratab Output: CUSTOMER1 Database altered. CUSTOMER2 Database altered. Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Cerca
Unix...
Info:
ps
Anger is creative, depression is useless.
Dyson, Freeman J. Anger is creative, depression is useless.
Dyson, Freeman J.
Unix...
Info:
Variabili nelle shell unix/linux
Oracle...
Definizioni:
Area PGA
Shell scripting...
Script:
Script for archiving and compressing folder and file
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |