Cao narode!
Voleo bih da kreiram batch script za pingovanje baza kroz odredjeni postavljeni uslov.
Evo ispocetka kako sam odradio deo posla, prvo sam kreirao batch fajl aca.bat koji izgleda:
tnsping test1.bb.com
tnsping test2.bb.com
tnsping test1.bb.com
.
.
.
zatim sam ga izvrsio iz cmd prompta aca.bat >>tnsping.log
i output tnsping.log fajla je ispao otprilike ovakav:
D:\DATA\sta8983\Desktop>tnsping test1.bb.com
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-SEP-2011 11:20:39
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=test.bb.com)(Port=1639))(CONNECT_DATA=(SERVICE_NAME=test1.bb.com)))
OK (300 msec)
D:\DATA\sta8983\Desktop>tnsping test2.bb.com
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-SEP-2011 11:20:39
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=server.bb.com)(Port=1837))(CONNECT_DATA=(SERVICE_NAME=test2.bb.com)))
TNS-12541: TNS:no listener
D:\DATA\sta8983\Desktop>tnsping test3.bb.com
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-SEP-2011 11:20:39
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=manage.bb.com)(Port=1740))(CONNECT_DATA=(SID=test3.bb.com)))
TNS-12545: Connect failed because target host or object does not exist
Moje pitanje je da li je moguce postaviti uslov u batch skripti, kako bi moj output sadrzao samo greske tnsping komande tj razlicito od OK na kraju svakog odziva baze? Ja jako slabo znam ovaj vid skriptovanja a hitno mi je potreban odgovor!
Hvala!