Solaris 下的 oracle 的基本操作。 - 中國WEB開發者網絡 (http://www.webasp.net) -- 技術教程 (http://www.webasp.net/article/) --- Solaris 下的 oracle 的基本操作。 (http://www.webasp.net/article/22/21190.htm) |
| -- 作者：未知 -- 發佈日期： 2005-04-29 |
一、啟動、關閉數據庫1、啟動數據庫監聽su - oracle---切換oracle用戶(如果使用su oracle ，則啟動時不運行.profile用戶環境配置文件)$ lsnrctl start－－－啟動監聽2、啟動數據庫$ sqlplus "/ as sysdba"－－－用sys用戶登陸sqlplusSQL*Plus: Release 9.2.0.5.0 - Production on Thu Oct 9 15:06:11 2003Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup－－－啟動數據庫ORACLE instance started.Total System Global Area 538412728 bytesFixed Size 743096 bytesVariable Size 268435456 bytesDatabase Buffers 268435456 bytesRedo Buffers 798720 bytesDatabase mounted.Database opened.SQL> exit－－－退出sqlplusDisconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.5.0 - Production或者$dbstart3、查看數據庫進程$ ps -ef|grep ora_－－－查看oracle進程oracle 688322 1 0 15:06:20 - 0:00 ora_smon_bxmis oracle 696534 704704 0 15:06:35 pts/4 0:00 grep ora_ oracle 729224 1 0 15:06:20 - 0:00 ora_dbw0_bxmis oracle 745618 1 0 15:06:20 - 0:00 ora_reco_bxmis oracle 770216 1 0 15:06:20 - 0:00 ora_ckpt_bxmis oracle 778394 1 0 15:06:20 - 0:00 ora_pmon_bxmis oracle 843876 1 0 15:06:20 - 0:00 ora_qmn0_bxmis oracle 901342 1 0 15:06:20 - 0:00 ora_lgwr_bxmis oracle 925704 1 0 15:06:20 - 0:00 ora_cjq0_bxmis $ ps -ef|grep lsnr－－－查看oracle監聽進程4、關閉數據庫$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.5.0 - Production on Thu Oct 9 15:07:04 2003Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.5.0 - ProductionSQL> shutdown immediate－－－關閉數據庫Database closed.Database dismounted.ORACLE instance shut down.SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.5.0 - Production或者$dbshut5、停止數據庫監聽$ lsnrctl stop－－－停止監聽 |
| webasp.net |