Shulou(Shulou.com)05/31 Report--

This article mainly explains "oracle how to use shell script to link to the database to operate", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "oracle how to use shell script to link to the database to operate"!

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 # Database instance name

Export ORACLE_HOME=/oracle/procduct/9.2

Su oracle-c "${ORACLE_HOME} / bin/sqlplus-S / nolog"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.