Can the scripting part of a custom TCP service be used to send commands from a different program?
What I would like to do is send the following command
Send=Sqlplus userid/password@database
Expect=~Production
Send=exit
When I try this I get the following return from the debug log
(C:\Program Files\WhatsUp\Web\Text_oracle.wup) map poll start
ping 172.16.34.21 returned in 0 ms. 0
Checking hughp1.smeco.com : 12 : test2
[172.16.34.21] >>> TCP COHS CHECK 1521 on 172.16.34.21
[172.16.34.21] connected
[172.16.34.21] >>> TCP COHS CHECK 1521 on 172.16.34.21
[172.16.34.21] 000: Send=SQLPLUS dbsnmp/dbsnmp@lasmdev
SQLPLUS dbsnmp/dbsnmp@lasmdev
[172.16.34.21] 001: Expect=~Production
[172.16.34.21] <<< TCP COHS EXIT=14
TCP/IP Service check complete. FAILED
Check Complete (-2) hughp1.smeco.com : 12 : test2
20030110<009>145329<009>C:\Program Files\WhatsUp\Web\Text_oracle.wup<009>SVCDOWN<009>hughp1.smeco.com<009>172.16.34.21<009>test2 <009>
(C:\Program Files\WhatsUp\Web\Text_oracle.wup) map poll complete
I have the oracle client installed on my system and it is in the path, I can run this from a command prompt and it works. What I am trying to accomplish is being able to test the availability of oracle databases. I have a script that tests the listener that another member of this list sent in, what he has done is to send a tnsping to the server by writing it out in binary, the only problem with this test is that it only checks that the listener is up on port 1521 but the databases behind the listener are not checked. I would like to accomplish this without having to go through that much work.
Michael D Sahli
Network Administrator
ACS
301-274-4344
