查看oracle数据库是否正常启动
[root@912616.cn Desktop]# su - oracle
[oracle@912616.cn ~]$ 10g
[oracle@912616.cn ~]$ ps -ef | grep ora_ | grep 10g
oracle 9915 1 0 14:32 ? 00:00:00 ora_pmon_wyzc10g
oracle 9917 1 0 14:32 ? 00:00:00 ora_psp0_wyzc10g
oracle 9919 1 0 14:32 ? 00:00:00 ora_mman_wyzc10g
oracle 9921 1 0 14:32 ? 00:00:00 ora_dbw0_wyzc10g
oracle 9923 1 0 14:32 ? 00:00:00 ora_lgwr_wyzc10g
oracle 9925 1 0 14:32 ? 00:00:00 ora_ckpt_wyzc10g
oracle 9927 1 0 14:32 ? 00:00:00 ora_smon_wyzc10g
oracle 9929 1 0 14:32 ? 00:00:00 ora_reco_wyzc10g
oracle 9931 1 0 14:32 ? 00:00:00 ora_cjq0_wyzc10g
oracle 9933 1 0 14:32 ? 00:00:00 ora_mmon_wyzc10g
oracle 9935 1 0 14:32 ? 00:00:00 ora_mmnl_wyzc10g
oracle 9937 1 0 14:32 ? 00:00:00 ora_d000_wyzc10g
oracle 9939 1 0 14:32 ? 00:00:00 ora_s000_wyzc10g
oracle 9949 1 0 14:32 ? 00:00:00 ora_qmnc_wyzc10g
oracle 9966 1 0 14:32 ? 00:00:00 ora_q000_wyzc10g
oracle 9968 1 0 14:32 ? 00:00:00 ora_q001_wyzc10g
oracle 12389 1 0 15:15 ? 00:00:00 ora_j000_wyzc10g
#看到上面输出，即说明10g已经正常启动了
[oracle@912616.cn ~]$ netstat -an | grep :1521
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN
tcp 0 0 192.168.137.6:15288 192.168.137.6:1521 ESTABLISHED
tcp 0 0 192.168.137.6:1521 192.168.137.6:15288 ESTABLISHED
udp 0 0 ::1:15212 :::*
[oracle@912616.cn ~]$ which sqlplus
/u01/oracle/10g/bin/sqlplus
[oracle@912616.cn ~]$ echo $ORACLE_HOME
/u01/oracle/10g
[oracle@912616.cn ~]$ echo $ORACLE_SID
orcl
[oracle@912616.cn ~]$ sqlplus / as sysdba
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE