隐藏 Oracle 命令行登录密码

1. 命令行隐藏数据库用户名和密码

#!/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_//'