monitoring of database using xymon
I have a script which monitor my oracle database xymon on solaris 10. the script is monitoing my lisntener and tnsping and then the tablespace usage of extent, session etc.
Please see error below:-
Database check: cnp1 is down or in hung state
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where ::= [/][@] ::= [][/][@] SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where ::= [/][@] ::= [][/][@] SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
The function which deals that part is below:-