- 启动数据库
以oracle用户通过
telnet
方式登录数据库操作系统上,
执行命令:
$
echo $ORACLE_SID
proplh
如果结果不是proplh,需要重新设置ORACLE_SID,命令如下:
$
export ORACLE_SID=proplh
$
lsnrctl start
在提示信息的最后一行,出现以下信息,说明lsnrctl服务启动成功:
The command completed successfully
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Mon Aug 21 17:58:43 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
conn / as sysdba
Connected.
SQL>
startup
- 关闭数据库
以oracle用户通过
telnet
方式登录数据库操作系统上,
执行命令:
$
echo $ORACLE_SID
proplh
如果结果不是proplh,需要重新设置ORACLE_SID,命令如下:
$
export ORACLE_SID=proplh
$
sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Aug 15 12:49:43 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
conn / as sysdba
Connected.
SQL>
shutdown immediate
(一般需要等2--5 分钟左右的时间)
Database closed.
Database dismounted.
ORACLE instance shut down.
(出现上述提示说明数据库已经正常关闭了)
SQL>
exit
(退出SQLPLUS)
$ (回到oracle用户的提示符下)
以oracle用户关闭Oracle数据库的监听进程
$
lsnrctl stop
LSNRCTL for HPUX: Version 9.2.0.4.0 - Production on 21-AUG-2006 18:00:37
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.203.4.117)(PORT=1521)))
The command completed successfully
(出现上述提示说明:Oracle数据库的监听进程已经正常关闭了)