ORA-24314: service handle not initialized 数据库服务器启动不了，求救！

ddy2000 2004-08-20 03:35:08
ORA-24314: service handle not initialized
各位大侠，我的Oracle以前是好的，但可能安装哪个补丁时影响了，现在一启动就出现这样的提示：
[oracle@localhost oracle]$ dbstart

SQL*Plus: Release 9.0.1.0.0 - Production on Fri Aug 20 09:35:52 2004

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> ERROR:
ORA-24314: service handle not initialized


SQL> ORA-12545: Connect failed because target host or object does not exist
SQL>
Database "appora" warm started.
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
lsnrctl的提示：

$ lsnrctl start

LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 20-AUG-2004 09:29:11

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Starting /opt/oracle/product/9i/bin/tnslsnr: please wait...

TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNSrotocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 2: No such file or directory

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
listener.ora , tnsnames.ora,sqlnet.ora等配置文件都检查过（放到配置相同的另一个服务器可以使用），没问题的

请指教啊，感谢！

...全文
807 17 打赏 收藏 转发到动态 举报
写回复
用AI写文章
17 条回复
切换为时间正序
请发表友善的回复…
发表回复
drabit 2004-08-23
  • 打赏
  • 举报
 回复
检查一下etc/system文件是否有破环，或者你的memeory硬件有问题
rouqu 2004-08-23
  • 打赏
  • 举报
 回复
up
ddy2000 2004-08-23
  • 打赏
  • 举报
 回复
alert.log的部分内容，请 drabit(square) 指点
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
Thu Aug 19 11:25:38 2004
WARNING: EINVAL creating segment of size 0x0000000015083000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 1048576
java_pool_size = 117440512
resource_manager_plan = SYSTEM_PLAN
control_files = /opt/oracle/oradata/Ora9i/control01.ctl, /opt/oracle/oradata/Ora9i/control02.ctl, /opt/oracle/oradata/Ora9i/control03.ctl
db_block_size = 8192
db_cache_size = 67108864
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = myOra
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = /opt/oracle/admin/Ora9i/bdump
user_dump_dest = /opt/oracle/admin/Ora9i/udump
core_dump_dest = /opt/oracle/admin/Ora9i/cdump
sort_area_size = 524288
db_name = Ora9i
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Thu Aug 19 11:25:39 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Aug 19 11:25:40 2004
ALTER DATABASE MOUNT
Thu Aug 19 11:25:47 2004
Successful mount of redo thread 1, with mount id 3445661814.
Thu Aug 19 11:25:47 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Aug 19 11:25:47 2004
ALTER DATABASE OPEN
Thu Aug 19 11:25:47 2004
Beginning crash recovery of 1 threads
Thu Aug 19 11:25:47 2004
Started first pass scan
Thu Aug 19 11:25:47 2004
Completed first pass scan
Thu Aug 19 11:25:47 2004
Started recovery at
Thread 1: logseq 19, block 572, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 19 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/Ora9i/redo03.log
Thu Aug 19 11:25:48 2004
Ended recovery at
Thread 1: logseq 19, block 590, scn 0.605209
12 data blocks read, 12 data blocks written, 18 redo blocks read
Crash recovery completed successfully
Thu Aug 19 11:25:48 2004
Thread 1 advanced to log sequence 20
Thread 1 opened at log sequence 20
Current log# 1 seq# 20 mem# 0: /opt/oracle/oradata/Ora9i/redo01.log
Successful open of redo thread 1.
Thu Aug 19 11:25:49 2004
SMON: enabling cache recovery
Thu Aug 19 11:25:49 2004
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Aug 19 11:25:49 2004
SMON: enabling tx recovery
Thu Aug 19 11:25:52 2004
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN


下面应该是正常启动的
------------------------------------------------------------
Thu Jul 22 17:21:18 2004
Starting ORACLE instance (normal)
Thu Jul 22 17:21:18 2004
WARNING: EINVAL creating segment of size 0x0000000015083000
fix shm parameters in /etc/system or equivalent
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 9.0.1.0.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 1048576
java_pool_size = 117440512
resource_manager_plan = SYSTEM_PLAN
control_files = /opt/oracle/oradata/Ora9i/control01.ctl, /opt/oracle/oradata/Ora9i/control02.ctl, /opt/oracle/oradata/Ora9i/control03.ctl
db_block_size = 8192
db_cache_size = 67108864
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = myOra
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = /opt/oracle/admin/Ora9i/bdump
user_dump_dest = /opt/oracle/admin/Ora9i/udump
core_dump_dest = /opt/oracle/admin/Ora9i/cdump
sort_area_size = 524288
db_name = Ora9i
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Thu Jul 22 17:21:20 2004
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jul 22 17:21:20 2004
Create controlfile reuse set database Ora9i
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
Datafile
'/opt/oracle/product/9i/oradata/Ora9i/cwmlite01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/drsys01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/example01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/indx01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/system01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/tools01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/undotbs01.dbf' ,
'/opt/oracle/product/9i/oradata/Ora9i/users01.dbf'
LOGFILE GROUP 1 ('/opt/oracle/oradata/Ora9i/redo01.log') SIZE 102400K,
GROUP 2 ('/opt/oracle/oradata/Ora9i/redo02.log') SIZE 102400K,
GROUP 3 ('/opt/oracle/oradata/Ora9i/redo03.log') SIZE 102400K RESETLOGS
Thu Jul 22 17:21:25 2004
Successful mount of redo thread 1, with mount id 3443240915.
Thu Jul 22 17:21:25 2004
Completed: Create controlfile reuse set database Ora9i
MAX
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Thu Jul 22 17:21:26 2004
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Jul 22 17:21:26 2004
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Thu Jul 22 17:21:31 2004
Starting ORACLE instance (normal)
drabit 2004-08-23
  • 打赏
  • 举报
 回复
把alert_<sid>.log贴出来看看（相关部分）
ddy2000 2004-08-23
  • 打赏
  • 举报
 回复
期待高手出现，盼望大侠出手啊！
ddy2000 2004-08-23
  • 打赏
  • 举报
 回复
唉，没办法了，看来还是重新安装吧。
zwj0712 2004-08-20
  • 打赏
  • 举报
 回复
OracleOraHome92TNSListener服务起来一下啊。如果不行的话你可以到
D:\oracle\ora92\BIN\TNSLSNR 下启动服务！！
ddy2000 2004-08-20
  • 打赏
  • 举报
 回复
哪个服务是监听和数据库服务啊，环境是redHat AS3+Oracle9.01
solon2008 2004-08-20
  • 打赏
  • 举报
 回复
先到服务中看看你的监听服务和数据库服务启动没有
ddy2000 2004-08-20
  • 打赏
  • 举报
 回复
重启很多次了
Torrice 2004-08-20
  • 打赏
  • 举报
 回复
没有初始化服务句柄，重新启动机器试一下
ddy2000 2004-08-20
  • 打赏
  • 举报
 回复
还是不行啊，我是直接在服务器上做启动就不行，以前是好的，RedHat AS3+Oracle9.0.1.0
xuelee 2004-08-20
  • 打赏
  • 举报
 回复
超级管理员进net assitant 试试
ddy2000 2004-08-20
  • 打赏
  • 举报
 回复
回复人： chao778899(220330) ( ) 信誉：99 2004-08-20 16:05:00 得分: 0

重新配置监听器，重新配置服务名

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
具体步骤如何？谢谢！
chao778899 2004-08-20
  • 打赏
  • 举报
 回复
重新配置监听器，重新配置服务名
yujiabian 2004-08-20
  • 打赏
  • 举报
 回复
你的监听器没有打开
ddy2000 2004-08-20
  • 打赏
  • 举报
 回复
查看状态时出现下面提示：
oracle@localhost oracle]$ lsnrctl

LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 20-AUG-2004 15:59:20

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL>
Oracle11g服务器、客户端的安装和plsql developer（一次成功）
1.你能保证Oracle11g不出现错误吗？2.你能保证Oracle11g 服务器安装不出现错误吗？3.你能保证plsql developer不出ORA-12541 TNS 无监听程序错误吗？4.你知道Oracle11g安装服务器端，客户端，plsql developer都有哪些坑点吗？
oracle异常关闭，启动：ORA-24324: service handle not initialized
oracle关闭异常，再次启动时错误信息如下：SQL> shutdown immediate; ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01089: immediate shutdown in progress - no operations are permitted SQL> start
ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn
当前在线日志组破环，实例崩溃 SQL>startup; ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn exit sqlplus / as sysdba SQL>startup; SQL>select status from v$instanc...
ORA-24324: service handle not initialized
ORALCE启动不了报错ORA-24324: service handle not initialized   源文档 http://bbs.chinaunix.net/thread-1104660-1-1.html> SQL> startup ORA-27126: unable to lock shared memory segment in core HPUX-ia64 Erro
oracle断电报错，需重建控制文件 ORA-24324: service handle not initialized
oracle关闭异常，报错：ORA-24324: service handle not initialized oracle数据库关闭异常，报错如下： oracle@ app]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 23 07:25:03 2018 Copyright © 1982, 2009, Oracle. All rights reserved. Connected. SQL> startu
基础和管理

17,377

社区成员

95,127

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章