Solaris 下的 oracle 的基本操作。
2020-03-09 22:54:55
供稿：网友
一、启动、关闭数据库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－－－停止监听
