Automation

1.

 #!/bin/bash

user="u1"

password="u1"

server="192.168.1.130"

port="1521"

svc="prod"

CONN="${user}/${password}@${server}:${port}/${svc}"

query_header="

SET PAGESIZE 0;

SET FEEDBACK OFF;

SET VERIFY OFF;

SET SERVEROUTPUT ON;

SET HEADING OFF;

"

sql_connection_check="SELECT 'SUCCESS' FROM dual;"

check_conn=$(echo "

${query_header}

${sql_connection_check}" | sqlplus -s $CONN)

echo "check connection result: $check_conn"

2.

#!/bin/bash

user=${1}

password=${2}

server=${3}

port="1521"

svc=${4}

CONN="${user}/${password}@${server}:${port}/${svc}"

query_header="

SET PAGESIZE 0;

SET FEEDBACK OFF;

SET VERIFY OFF;

SET SERVEROUTPUT ON;

SET HEADING OFF;

"

sql_connection_check="SELECT 'SUCCESS' FROM dual;"

check_conn=$(echo "

${query_header}

${sql_connection_check}" | sqlplus -s $CONN)

echo "check connection result: $check_conn"

3.

#!/bin/bash

user=${1}

password=${2}

server=${3}

port="1521"

svc=${4}

function logprefix()

{

date 

5:23

CONN="${user}/${password}@${server}:${port}/${svc}"

query_header="

SET PAGESIZE 0;

SET FEEDBACK OFF;

SET VERIFY OFF;

SET SERVEROUTPUT ON;

SET HEADING OFF;

"

sql_connection_check="SELECT 'SUCCESS' FROM dual;"

check_conn=$(echo "

${query_header}

${sql_connection_check}" | sqlplus -s $CONN)

echo "check connection result: $check_conn"