Oracle:How to use “Linux Alias”?
今天看一本书的时候,看到原来Linux的别名还可以这么使用,… 作者的想法比较独特。
具体如下:
1.准备命令:
通过Linux的别名(ALIAS)制作常用命令的快捷方式
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
[oracle@ora12c - allah:~]$ alias tail_alert_log_allah='tail -f /u01/app/oracle/diag/rdbms/allah/allah/trace/alert_allah.log' [oracle@ora12c - allah:~]$ alias call_sqlplus='sqlplus / as sysdba' [oracle@ora12c - allah:~]$ alias start_database='echo "startup;" | call_sqlplus' [oracle@ora12c - allah:~]$ alias shutdown_database='echo "shutdown immediate;" | call_sqlplus' [oracle@ora12c - allah:~]$ alias list_oracle_process='ps -ef | grep --color ora_' [oracle@ora12c - allah:~]$ alias list_remote_connect_lsnr_process='ps -ef | grep --color LOCAL=NO' [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ alias alias call_sqlplus='sqlplus / as sysdba' alias l.='ls -d .* --color=tty' alias list_oracle_process='ps -ef | grep --color ora_' alias list_remote_connect_lsnr_process='ps -ef | grep --color LOCAL=NO' alias ll='ls -l --color=tty' alias ls='ls --color=tty' alias shutdown_database='echo "shutdown immediate;" | call_sqlplus' alias start_database='echo "startup;" | call_sqlplus' alias tail_alert_log_allah='tail -f /u01/app/oracle/diag/rdbms/allah/allah/trace/alert_allah.log' alias which='alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde' [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ |
2.使用:
关闭数据库:
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 |
[oracle@ora12c - allah:~]$ ps -ef | grep ora_ oracle 3586 1 0 00:05 ? 00:00:00 ora_w005_allah oracle 3943 29038 0 00:20 pts/2 00:00:00 grep ora_ oracle 19854 1 0 Oct28 ? 00:00:00 ora_pmon_allah oracle 19856 1 0 Oct28 ? 00:00:00 ora_psp0_allah oracle 19858 1 0 Oct28 ? 00:00:06 ora_vktm_allah oracle 19862 1 0 Oct28 ? 00:00:00 ora_gen0_allah oracle 19865 1 0 Oct28 ? 00:00:00 ora_mman_allah oracle 19869 1 0 Oct28 ? 00:00:00 ora_diag_allah oracle 19872 1 0 Oct28 ? 00:00:05 ora_dbrm_allah oracle 19874 1 0 Oct28 ? 00:00:00 ora_vkrm_allah oracle 19877 1 0 Oct28 ? 00:00:15 ora_dia0_allah oracle 19880 1 0 Oct28 ? 00:00:02 ora_dbw0_allah oracle 19882 1 0 Oct28 ? 00:00:04 ora_lgwr_allah oracle 19884 1 0 Oct28 ? 00:00:05 ora_ckpt_allah oracle 19886 1 0 Oct28 ? 00:00:00 ora_smon_allah oracle 19888 1 0 Oct28 ? 00:00:00 ora_reco_allah oracle 19890 1 0 Oct28 ? 00:00:00 ora_lreg_allah oracle 19892 1 0 Oct28 ? 00:00:00 ora_pxmn_allah oracle 19895 1 0 Oct28 ? 00:00:17 ora_mmon_allah oracle 19897 1 0 Oct28 ? 00:00:10 ora_mmnl_allah oracle 19899 1 0 Oct28 ? 00:00:00 ora_d000_allah oracle 19901 1 0 Oct28 ? 00:00:00 ora_s000_allah oracle 19953 1 0 Oct28 ? 00:00:00 ora_tmon_allah oracle 19955 1 0 Oct28 ? 00:00:00 ora_tt00_allah oracle 19958 1 0 Oct28 ? 00:00:00 ora_smco_allah oracle 19968 1 0 Oct28 ? 00:00:00 ora_aqpc_allah oracle 19982 1 0 Oct28 ? 00:00:00 ora_p000_allah oracle 19984 1 0 Oct28 ? 00:00:00 ora_p001_allah oracle 19987 1 0 Oct28 ? 00:00:00 ora_p002_allah oracle 19989 1 0 Oct28 ? 00:00:00 ora_p003_allah oracle 19997 1 0 Oct28 ? 00:00:04 ora_cjq0_allah oracle 20222 1 0 Oct28 ? 00:00:00 ora_qm02_allah oracle 20227 1 0 Oct28 ? 00:00:00 ora_q002_allah oracle 20229 1 0 Oct28 ? 00:00:00 ora_q003_allah oracle 32066 1 0 Oct28 ? 00:00:00 ora_w002_allah [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ shutdown_database SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 29 00:21:05 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SYS@allah AS SYSDBA:29-OCT-14> Database closed. Database dismounted. ORACLE instance shut down. SYS@allah AS SYSDBA:29-OCT-14> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ ps -ef | grep ora_ oracle 3956 29038 0 00:21 pts/2 00:00:00 grep ora_ [oracle@ora12c - allah:~]$ |
启动数据库:
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 |
[oracle@ora12c - allah:~]$ ps -ef | grep ora_ oracle 3966 29038 0 00:22 pts/2 00:00:00 grep ora_ [oracle@ora12c - allah:~]$ start_database SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 29 00:22:16 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SYS@allah AS SYSDBA:29-OCT-2014 00:22:17> ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 2929936 bytes Variable Size 578816752 bytes Database Buffers 251658240 bytes Redo Buffers 5455872 bytes Database mounted. Database opened. SYS@allah AS SYSDBA:29-OCT-2014 00:22:17> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@ora12c - allah:~]$ [oracle@ora12c - allah:~]$ ps -ef | grep ora_ oracle 3978 1 0 00:22 ? 00:00:00 ora_pmon_allah oracle 3981 1 0 00:22 ? 00:00:00 ora_psp0_allah oracle 3983 1 0 00:22 ? 00:00:00 ora_vktm_allah oracle 3987 1 0 00:22 ? 00:00:00 ora_gen0_allah oracle 3989 1 0 00:22 ? 00:00:00 ora_mman_allah oracle 3993 1 0 00:22 ? 00:00:00 ora_diag_allah oracle 3995 1 0 00:22 ? 00:00:00 ora_dbrm_allah oracle 3997 1 0 00:22 ? 00:00:00 ora_vkrm_allah oracle 3999 1 0 00:22 ? 00:00:00 ora_dia0_allah oracle 4001 1 0 00:22 ? 00:00:00 ora_dbw0_allah oracle 4003 1 0 00:22 ? 00:00:00 ora_lgwr_allah oracle 4005 1 0 00:22 ? 00:00:00 ora_ckpt_allah oracle 4007 1 0 00:22 ? 00:00:00 ora_smon_allah oracle 4010 1 0 00:22 ? 00:00:00 ora_reco_allah oracle 4012 1 0 00:22 ? 00:00:00 ora_lreg_allah oracle 4014 1 0 00:22 ? 00:00:00 ora_pxmn_allah oracle 4016 1 9 00:22 ? 00:00:01 ora_mmon_allah oracle 4018 1 0 00:22 ? 00:00:00 ora_mmnl_allah oracle 4020 1 0 00:22 ? 00:00:00 ora_d000_allah oracle 4022 1 0 00:22 ? 00:00:00 ora_s000_allah oracle 4036 1 0 00:22 ? 00:00:00 ora_tmon_allah oracle 4038 1 0 00:22 ? 00:00:00 ora_tt00_allah oracle 4040 1 0 00:22 ? 00:00:00 ora_smco_allah oracle 4042 1 0 00:22 ? 00:00:00 ora_w000_allah oracle 4044 1 0 00:22 ? 00:00:00 ora_w001_allah oracle 4048 1 0 00:22 ? 00:00:00 ora_aqpc_allah oracle 4061 1 0 00:22 ? 00:00:00 ora_p000_allah oracle 4063 1 0 00:22 ? 00:00:00 ora_p001_allah oracle 4070 1 0 00:22 ? 00:00:00 ora_p002_allah oracle 4073 1 0 00:22 ? 00:00:00 ora_p003_allah oracle 4130 1 3 00:22 ? 00:00:00 ora_cjq0_allah oracle 4220 29038 0 00:22 pts/2 00:00:00 grep ora_ [oracle@ora12c - allah:~]$ |
查看Oracle后台进程:
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 |
[oracle@ora12c - allah:~]$ list_oracle_process oracle 3978 1 0 00:22 ? 00:00:00 ora_pmon_allah oracle 3981 1 0 00:22 ? 00:00:00 ora_psp0_allah oracle 3983 1 0 00:22 ? 00:00:00 ora_vktm_allah oracle 3987 1 0 00:22 ? 00:00:00 ora_gen0_allah oracle 3989 1 0 00:22 ? 00:00:00 ora_mman_allah oracle 3993 1 0 00:22 ? 00:00:00 ora_diag_allah oracle 3995 1 0 00:22 ? 00:00:00 ora_dbrm_allah oracle 3997 1 0 00:22 ? 00:00:00 ora_vkrm_allah oracle 3999 1 0 00:22 ? 00:00:00 ora_dia0_allah oracle 4001 1 0 00:22 ? 00:00:00 ora_dbw0_allah oracle 4003 1 0 00:22 ? 00:00:00 ora_lgwr_allah oracle 4005 1 0 00:22 ? 00:00:00 ora_ckpt_allah oracle 4007 1 0 00:22 ? 00:00:00 ora_smon_allah oracle 4010 1 0 00:22 ? 00:00:00 ora_reco_allah oracle 4012 1 0 00:22 ? 00:00:00 ora_lreg_allah oracle 4014 1 0 00:22 ? 00:00:00 ora_pxmn_allah oracle 4016 1 2 00:22 ? 00:00:01 ora_mmon_allah oracle 4018 1 0 00:22 ? 00:00:00 ora_mmnl_allah oracle 4020 1 0 00:22 ? 00:00:00 ora_d000_allah oracle 4022 1 0 00:22 ? 00:00:00 ora_s000_allah oracle 4036 1 0 00:22 ? 00:00:00 ora_tmon_allah oracle 4038 1 0 00:22 ? 00:00:00 ora_tt00_allah oracle 4040 1 0 00:22 ? 00:00:00 ora_smco_allah oracle 4042 1 0 00:22 ? 00:00:00 ora_w000_allah oracle 4044 1 0 00:22 ? 00:00:00 ora_w001_allah oracle 4048 1 0 00:22 ? 00:00:00 ora_aqpc_allah oracle 4061 1 0 00:22 ? 00:00:00 ora_p000_allah oracle 4063 1 0 00:22 ? 00:00:00 ora_p001_allah oracle 4070 1 0 00:22 ? 00:00:00 ora_p002_allah oracle 4073 1 0 00:22 ? 00:00:00 ora_p003_allah oracle 4130 1 0 00:22 ? 00:00:00 ora_cjq0_allah oracle 4223 1 0 00:22 ? 00:00:00 ora_qm02_allah oracle 4225 1 0 00:22 ? 00:00:00 ora_q001_allah oracle 4227 1 0 00:22 ? 00:00:00 ora_qm03_allah oracle 4229 1 0 00:22 ? 00:00:00 ora_q003_allah oracle 4240 29038 0 00:23 pts/2 00:00:00 grep --color ora_ [oracle@ora12c - allah:~]$ |
——————————————————
Finished。