Solaris 下的 oracle 的基本操作。

一、启动、关闭数据库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－－－停止监听

　

原文转自：http://www.ltesting.net