sqlplus获取命令执行状态

ghostgorst

&nbsp;&nbsp;&nbsp;&nbsp;sqlplus /nolog > /dev/null <<EOF &nbsp;&nbsp;&nbsp;&nbsp;connect $_m_sql_connect_str; &nbsp;&nbsp;&nbsp;&nbsp;set heading off; &nbsp;&nbsp;&nbsp;&nbsp;set feedback off; &nbsp;&nbsp;&nbsp;&nbsp;set echo off; &nbsp;&nbsp;&nbsp;&nbsp;set linesize 32767; &nbsp;&nbsp;&nbsp;&nbsp;set trimspool on; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;$unite_sql; &nbsp;&nbsp;&nbsp;&nbsp;commit; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;exit; EOF

我想检查connect $_m_sql_connect_str;连接数据库执行结果,连接成功exit success

连接失败exit failure.

请问sqlplus里有什么命令可以检查connect $_m_sql_connect_str;这种语句执行结果么?

Minsic

可以考虑在sqlplus连接数据库前先用tnsping检测一下？

y331044508

2楼说的不错，可以先用tnsping ,这个方式相当方便而且简单。

caribe

yes, but how about account validation? need to write a simple script...