[ prepek2000 @ 01.09.2011. 13:23 ] @
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! |