Oracle uses shell scripting to link databases

zabbix#vi/opt/script/conf/config.sh
name_pw= ' Username/password '
Export NAME_PW
zabbix#vi/opt/script/logger.sh

#!/bin/bash
. /opt/script/conf/config.sh
Export Oracle_sid=oracle1 #数据库实例名
Export oracle_home=/oracle/procduct/9.2
Su oracle-c "${oracle_home}/bin/sqlplus-s/nolog" <<eof
SET FEEDBACK OFF;
SET ECHO OFF;
CONN $NAME _PW
Insert into Table_test (id,date.messages) VALUES (' $! ', Sysdate, ' $ $ ') #向表table_test中插入数据
Commit
Exit
Eof

zabbix#sh/opt/script/logger.sh 1,test# writing data to the database

Oracle uses shell scripting to link databases