用lsnrctl start启动后提示Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cyst)(PORT=1521)))
Services Summary...
Service "ccms" has 1 instance(s).
Instance "ccms", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:43 refused:0
LOCAL SERVER
The command completed successfullyccms是建的数据库,看样子没有启动起来unix怎么启动啊
Services Summary...
Service "ccms" has 1 instance(s).
Instance "ccms", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:43 refused:0
LOCAL SERVER
The command completed successfullyccms是建的数据库,看样子没有启动起来unix怎么启动啊
conn / as sysdba
startup
startup
提示
ORA-01081: 无法启动已在运行的 ORACLE --- 请首先关闭
shutdown immediate
再startup
dbstart
lsnrctl如果开机时让Oracle自行启动,请参考:
http://hi.baidu.com/hummer613/blog/item/f182d713ad9a06836438db1f.html
再startup这样可以但是我的实例数据库还是没有启动起来
dbstart
lsnrctl start
提示
$ dbstart
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnsls
nr
$ lsnrctl startLSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 29-OCT-2008 12:40:10Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /oracle/bin/tnslsnr: please wait...TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
System parameter file is /oracle/network/admin/listener.ora
Log messages written to /oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cyst)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cyst)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
Start Date 29-OCT-2008 12:40:10
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/network/admin/listener.ora
Listener Log File /oracle/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cyst)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "ccms" has 1 instance(s).
Instance "ccms", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$
conn sys/passas@ccms as sysdba
startup
#shutdown -hy 0 --立即关机再启动后:
在Oracle$Home目录下:
dbstart
lsnrctl start