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:
Conditional update
Unix...
Tip:
How remove a file named -r
PLSQL...
Script:
TYPE TABLE
Unix...
Tip:
How remove a file named -r
Shell scripting...
Script:
Compact if construct
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
Php Funzione mail()
XPath is a language for addressing parts of an XML document.
It is designed to be used by XSLT and XPointer.
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
|
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 Executing a shell script [Unix] Shell scripting passare parametri ad un programma [Shell scripting] Cheking mandatory parameters have been passed to shell file, comparing strings in if construct and some other basics warming up with shell scripting [Shell scripting] Estendere un logical volume e di un filesystem allocare pił storage da riga di comando su Unix Hp [HP UX 11i] Korn shell scripting If constructs AND, OR, &&, || syntax examples [Unix] Function connecting to oracle getting results, executing query, verify db connection [Shell scripting] Cheking parameters have been passed to shell file, comparing strings in if construct warming up with shell scripting [Shell scripting] awk command line tutorial and examples sintax, functions, conditional constructs, text file operations [Unix] How many processor and what kind of CPU extracting info from red hat system file /proc/cpuinfo [REDHAT] sed command example on fixing errors and adding and removing blank lines [Unix] Shell scripting eseguire controlli [Shell scripting] Script while do loop simple shell script [Shell scripting] if e else strutture condizionali [Shell scripting] Array valorizzazione e stampa [Shell scripting] Hide user input on screen parameter of read command [Shell scripting] Array in do while construct printing elements [Shell scripting] Shell script automating oracle data pump schema export automatically export and compress database schemas in single separated dump files [Shell scripting] Script per ricavare i nomi dei db (SID) dal file oratab [Unix] Ciclo sul contenuto directory [Shell scripting] If contruct check if a value is null or not [Unix] Shell script extract items and looping example: issue dba statment for each db listed in oratab [Unix] Passing parameters to shell script example sum of two numbers [Shell scripting] Export and compress dump on the fly script to reduce storage need while using exp and imp Oracle utilities [Unix] Pulire i file provenienti da ambieti dos/ windoes da caratteri sporchi dos2ux, dos2unix per eliminare i control M (^M) [Shell scripting] Script for archiving and compressing folder and file utility example [Shell scripting] How to get size or other file info in a shell script manipulating with cut or awk operative system commands output [Shell scripting] Comandi Privilegi su file o cartella (lettura, scrittura, execuzione) [Unix] Cancellazione di una directory rm o rmdir [Unix] Cd: cambiare directory [Unix] Copiare un file in un altra cartella [Unix] hostname [HP UX 11i] uname visaulizza informazioni sul sistema operativo e la versione [HP UX 11i] ipcs report stato dei processi [HP UX 11i] getconf ricavare se si ha a disposizione un Kernel da 32-bit o 64-bit [HP UX 11i] swlist -l patch determinare il software e le patch installate nella piattaforma [HP UX 11i] who determinare gli utenti connessi [Unix] shutdown [Unix] env visualizzazione (e modifica) variabili dell'ambiente [Unix] w attivitą degli utenti [Unix] bdf visualizzare spazio disponibile [HP UX 11i] df visualizzazione spazio disponibile [Unix]
Marco Magnani marcomagnani@fishscript.com
|
Cerca
Unix...
Info:
ps
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
Unix...
Info:
ps
Oracle...
Definizioni:
Transazione
Shell scripting...
Script:
if e else
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 |