数据库没有启动,
在\ORACLE\ORA81\BIN键入 svrmgrl
然后出现提示符
SVRMGR>
然后执行
SVRMGR>connect internal
SVRMGR>startup等数据库打开就可以了
在\ORACLE\ORA81\BIN键入 svrmgrl
然后出现提示符
SVRMGR>
然后执行
SVRMGR>connect internal
SVRMGR>startup等数据库打开就可以了
怎么办?
命令:
sqlplus " / as sysdba" SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jul 11 16:00:59 2001 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to an idle instance. SQL> startup
ORACLE instance started. Total System Global Area 336356520 bytes
Fixed Size 279720 bytes
Variable Size 268435456 bytes
Database Buffers 67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> 启动Oracle 9i监听程序
Oracle的监听程序主要是为客户端的连接提供接口
命令
lsnrctl LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 11-JUL-2001 16:12:17 Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> start
Starting /oracle/product/9.0.1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 9.0.1.0.0 - Production
System parameter file is /oracle/product/9.0.1/network/admin/listener.ora
Log messages written to /oracle/product/9.0.1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.0.1.0.0 - Production
Start Date 11-JUL-2001 16:12:58
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/product/9.0.1/network/admin/listener.ora
Listener Log File /oracle/product/9.0.1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wing)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "oracle" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
注册表HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome81TNSListener
改里面的ImagePath 没有就加上
类似这样的字符串ORACLE_HOME\ORA9X\BIN\TNSLSNR
或者删了用用net8再建一个
可以正常启动了,但数据库server不能正常启动成功,提示:
错误1053:服务并未能即时响应启动或控制请求。多谢了!