用数据库用户登录oracle/oracle hp-unix
$sqlplus /nolog
SQL> connect /as sysdba -----登录
Connected.
SQL> startup ----启动ORACLE数据库
$ sqlplus 用户名/密码
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Aug 13 10:07:48 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
$ lsnrctl start ---------启动监听器
LSNRCTL for HPUX: Version 9.2.0.2.0 - Production on 13-AUG-2007 10:08:01
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oracle/OraHome1/bin/tnslsnr: please wait...
...........
Connecting to (DEscrīptION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
..............
$ lsnrctl status ----监听器状态查看
LSNRCTL for HPUX: Version 9.2.0.2.0 - Production on 13-AUG-2007 10:08:13
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DEscrīptION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 9.2.0.2.0 - Production
Start Date 13-AUG-2007 10:08:01
Uptime 0 days 0 hr. 0 min. 11 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/OraHome1/network/admin/listener.ora
Listener Log File /oracle/OraHome1/network/log/listener.log
Listening Endpoints Summary...
.........
The command completed successfully
$