- 命令行隐藏数据库用户名和密码
#!/bin/ksh
heading=on
SYSTEM_CONNECT="dbname/dbpass"
$ORACLE_HOME/bin/sqlplus -s /nolog <<!!
set line 200
set feedback off
set heading ${heading}
connect ${SYSTEM_CONNECT};
column global_name heading "Instance" format a15
column sessions_max heading "Max" format 9999
column sessions_warning heading "Warning" format 9999
column sessions_current heading "Current" format 9999
column sessions_highwater heading "Highwater" format 9999
select
global_name,sessions_max,sessions_warning,
sessions_current-1 sessions_current,
sessions_highwater
from
v\$license,global_name ;
quit;
!!
2. 获取系统当前启动的数据库实例
ps -ef | grep ora_pmon | grep -vE 'grep|sed' | sed -e 's/^.*ora_pmon_//'