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!
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!