脚本：检查Oracle数据库的默认密码
Code：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 |
[oracle@ora12c - allah:~]$ ps -ef | grep ora_ oracle 11610 1 0 02:55 ? 00:00:01 ora_pmon_allah oracle 11612 1 0 02:55 ? 00:00:02 ora_psp0_allah oracle 11614 1 0 02:55 ? 00:00:16 ora_vktm_allah oracle 11618 1 0 02:55 ? 00:00:00 ora_gen0_allah oracle 11620 1 0 02:55 ? 00:00:00 ora_mman_allah oracle 11624 1 0 02:55 ? 00:00:00 ora_diag_allah oracle 11626 1 0 02:55 ? 00:00:18 ora_dbrm_allah oracle 11628 1 0 02:55 ? 00:00:02 ora_vkrm_allah oracle 11630 1 0 02:55 ? 00:00:38 ora_dia0_allah oracle 11632 1 0 02:55 ? 00:00:04 ora_dbw0_allah oracle 11634 1 0 02:55 ? 00:00:03 ora_lgwr_allah oracle 11636 1 0 02:55 ? 00:00:13 ora_ckpt_allah oracle 11638 1 0 02:55 ? 00:00:01 ora_smon_allah oracle 11640 1 0 02:55 ? 00:00:00 ora_reco_allah oracle 11642 1 0 02:55 ? 00:00:00 ora_lreg_allah oracle 11644 1 0 02:55 ? 00:00:00 ora_pxmn_allah oracle 11646 1 0 02:55 ? 00:00:19 ora_mmon_allah oracle 11648 1 0 02:55 ? 00:00:22 ora_mmnl_allah oracle 11650 1 0 02:55 ? 00:00:00 ora_d000_allah oracle 11652 1 0 02:55 ? 00:00:00 ora_s000_allah oracle 11664 1 0 02:56 ? 00:00:00 ora_tmon_allah oracle 11666 1 0 02:56 ? 00:00:00 ora_arc0_allah oracle 11668 1 0 02:56 ? 00:00:00 ora_arc1_allah oracle 11670 1 0 02:56 ? 00:00:00 ora_arc2_allah oracle 11672 1 0 02:56 ? 00:00:00 ora_arc3_allah oracle 11674 1 0 02:56 ? 00:00:00 ora_tt00_allah oracle 11676 1 0 02:56 ? 00:00:00 ora_smco_allah oracle 11678 1 0 02:56 ? 00:00:00 ora_aqpc_allah oracle 11682 1 0 02:56 ? 00:00:10 ora_cjq0_allah oracle 11696 1 0 02:56 ? 00:00:00 ora_p000_allah oracle 11700 1 0 02:56 ? 00:00:00 ora_p001_allah oracle 11757 1 0 02:56 ? 00:00:00 ora_p002_allah oracle 11759 1 0 02:56 ? 00:00:00 ora_p003_allah oracle 11835 1 0 02:56 ? 00:00:00 ora_qm02_allah oracle 11839 1 0 02:56 ? 00:00:00 ora_q002_allah oracle 15099 1 0 08:49 ? 00:00:00 ora_q001_allah oracle 18691 1 0 15:11 ? 00:00:00 ora_w002_allah oracle 20079 1 0 16:56 ? 00:00:00 ora_w003_allah oracle 20449 1 0 17:22 ? 00:00:00 ora_w000_allah oracle 20457 20216 0 17:24 pts/0 00:00:00 grep ora_ [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ lsnrctl status LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-NOV-2014 17:22:00 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora12c)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 18-NOV-2014 17:21:43 Uptime 0 days 0 hr. 0 min. 17 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/ora12c/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "allah" has 1 instance(s). Instance "allah", status READY, has 1 handler(s) for this service... Service "allahXDB" has 1 instance(s). Instance "allah", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ cat check_default_passwd.sh #!/bin/bash if [ $# -ne 1 ] then echo "Usage: $0 SID" exit 1 fi userlist="system sys dbsnmp dip oracle_ocm outln" for u1 in $userlist do case $u1 in system) pwd=manager cdb=$1 ;; sys) #pwd="change_on_install" pwd="oracle" cdb="$1 as sysdba" ;; *) pwd=$u1 cdb=$1 esac echo "select 'default' from dual;" | \ sqlplus -s $u1/$pwd@$cdb | grep default > /dev/null if [[ $? -eq 0 ]] then echo "ALERT: $u1/$pwd@$cdb default password" else echo "cannot connect to $u1 with default password." fi done exit 0 [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ sh check_default_passwd.sh allah cannot connect to system with default password. ALERT: sys/oracle@allah as sysdba default password cannot connect to dbsnmp with default password. cannot connect to dip with default password. cannot connect to oracle_ocm with default password. cannot connect to outln with default password. [oracle@ora12c - allah:~]$ |
————————————————————
Ending。
