各味大侠,救命啊!
32 个解决方案
#1
操作系统是什么版本?
sqlplus "/as sysdba"
startup
把提示信息贴上来
sqlplus "/as sysdba"
startup
把提示信息贴上来
#2
oracle有这个可能,重启动机器后起不来,一般可能出现在大数据量操作,不能回滚而造成的.
#3
前天看到一帖,数据在D盘,C盘被格式化了,然后重装机器恢复库的.你找找.
#4
win2000
#5
2楼,sqlplus "/as sysdba" ,显示ora-12560协议适配器错误,可是在服务里是起来的。
#6
你这样恢复的话
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
#7
你这样恢复的话
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
我不太懂oracle,怎么做,谢谢!
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
我不太懂oracle,怎么做,谢谢!
#8
应该先shutdown。再全备份。你的IP地址又没有换?如果有换请把tns文件和listenner文件修改成主机名。再重启。
实例名是不是之前的一样的实例名,版本也要一致。
注意这三点。再试一下。
实例名是不是之前的一样的实例名,版本也要一致。
注意这三点。再试一下。
#9
tns文件和listenner文件都没问题,没改过ip,是shutdown后做的备份.
#10
同意这种方法,可以试试看
#11
有没有可能是微软补丁造成的,我以前打补丁都不重起机器!
#12
重启一下。等打完补丁包再试下。可能有冲突。
#13
还有重建listener就死机!
补丁都是以前打的,没新补丁,只不过一直没重起机器.
补丁都是以前打的,没新补丁,只不过一直没重起机器.
#14
你的oracle_sid没设置对吧?这个是不用listener的
c:\>set oracle_sid=你的实例名
再用sqlplus
#15
我重新装了一台机器,系统为2003,建同样数据库名,启动正常,拷入oradata的数据后,启动服务也是1053!
请教是何原因?
请教是何原因?
#16
解决ORA-12560: TNS: 协议适配器错误,与大家共享
今天遭遇ORA-12560: TNS: 协议适配器错误的问题,经过一番努力问题已经解决,与大家共享。
造成ORA-12560: TNS: 协议适配器错误的问题的原因有三个:
1.监听服务没有起起来。windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,
启动oraclehome92TNSlistener服务。
2.database instance没有起起来。windows平台如下操作:开始---程序---管理工具---服务,打开服务
面板,启动oracleserviceXXXX,XXXX就是你的database SID.
3.注册表问题。regedit,然后进入HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0将该环境变量ORACLE_SI
D设置为XXXX,XXXX就是你的database SID.或者右几我的电脑,属性--高级--环境变量---系统变量--新建
,变量名=oracle_sid,变量值=XXXX,XXXX就是你的database SID.或者进入sqlplus前,在command line下
输set oracle_sid=XXXX,XXXX就是你的database SID.
经过以上步骤,就可以解决问题。
ORA-12560:TNS:协议适配器错误
2.在机器上(4850Q)使用ORACLE 9I的服务器和 10G的客户端.
连接的时候,老报 ORA-12560:TNS:协议适配器错误
修改ORACLE_HOME\NETWORK\ADMIN\TNSNAMES.ORA
在里面添加本地主机的内容
GLIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = glis)
)
)
启动服务后,在CMD下,敲如下字幕:
>SET ORACLE_SID=GLIS
再连接,okey了.
今天遭遇ORA-12560: TNS: 协议适配器错误的问题,经过一番努力问题已经解决,与大家共享。
造成ORA-12560: TNS: 协议适配器错误的问题的原因有三个:
1.监听服务没有起起来。windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,
启动oraclehome92TNSlistener服务。
2.database instance没有起起来。windows平台如下操作:开始---程序---管理工具---服务,打开服务
面板,启动oracleserviceXXXX,XXXX就是你的database SID.
3.注册表问题。regedit,然后进入HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0将该环境变量ORACLE_SI
D设置为XXXX,XXXX就是你的database SID.或者右几我的电脑,属性--高级--环境变量---系统变量--新建
,变量名=oracle_sid,变量值=XXXX,XXXX就是你的database SID.或者进入sqlplus前,在command line下
输set oracle_sid=XXXX,XXXX就是你的database SID.
经过以上步骤,就可以解决问题。
ORA-12560:TNS:协议适配器错误
2.在机器上(4850Q)使用ORACLE 9I的服务器和 10G的客户端.
连接的时候,老报 ORA-12560:TNS:协议适配器错误
修改ORACLE_HOME\NETWORK\ADMIN\TNSNAMES.ORA
在里面添加本地主机的内容
GLIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = glis)
)
)
启动服务后,在CMD下,敲如下字幕:
>SET ORACLE_SID=GLIS
再连接,okey了.
#17
如果实例起不来,建议你把alert.log相关的错误贴出来,
大家帮忙分析
注: alert 文件位置
unix下在:$ORACLE_BASE/admin/sid/bdump下
windows:%ORACLE_BASE%/admin/sid/bdump下
大家帮忙分析
注: alert 文件位置
unix下在:$ORACLE_BASE/admin/sid/bdump下
windows:%ORACLE_BASE%/admin/sid/bdump下
#18
set oracle_sid=你的实例名
做了,键入用户名和密码后还是显示ora-12560协议适配器错误.
#19
主题: Starting OMS (Oracle Management Server) Fails with Error 1053 After Fresh Install
文档 ID: 注释:225459.1 类型: PROBLEM
上次修订日期: 09-JUL-2003 状态: PUBLISHED
fact: Oracle Enterprise Manager
fact: MS Windows 2000
fact: Ms Windows NT
symptom: Starting OMS (Oracle Management Server) Fails with Error 1053
After Fresh Install
symptom: Microsoft Managent Console reports errors
symptom: Error 1053: The service did not respond to the start or control
request
in a timely fashion.
Couldn't start the OracleOraHome81ManagementServer service on Local
Computer. The service didn't return an error. This could be an internal
service error.
symptom: Oms.nohup reports errors
symptom: ORA-00942: table or view does not exist
symptom: VXA-2017 : No Oracle Management Server services
symptom: Listener is running
symptom: Sqlnet connection works
change: VXA-2000 : Error encountered retrieving list of services to start:
cause: Probably the creation of repository wasn't succesfull (space errors)
fix:
Use EMCA to drop and recreate the repository
(Programs> Oracle- O817> Enterprise Manager> Configuration Assistant
or Programs> Oracle- O901> Configuration and Migration Tools>
Enterprise Manager Configuration Assistant)
And if you have none, create a new repository - make sure ther's
enough room (Also check <Note 132126.1> Release notes)
文档 ID: 注释:225459.1 类型: PROBLEM
上次修订日期: 09-JUL-2003 状态: PUBLISHED
fact: Oracle Enterprise Manager
fact: MS Windows 2000
fact: Ms Windows NT
symptom: Starting OMS (Oracle Management Server) Fails with Error 1053
After Fresh Install
symptom: Microsoft Managent Console reports errors
symptom: Error 1053: The service did not respond to the start or control
request
in a timely fashion.
Couldn't start the OracleOraHome81ManagementServer service on Local
Computer. The service didn't return an error. This could be an internal
service error.
symptom: Oms.nohup reports errors
symptom: ORA-00942: table or view does not exist
symptom: VXA-2017 : No Oracle Management Server services
symptom: Listener is running
symptom: Sqlnet connection works
change: VXA-2000 : Error encountered retrieving list of services to start:
cause: Probably the creation of repository wasn't succesfull (space errors)
fix:
Use EMCA to drop and recreate the repository
(Programs> Oracle- O817> Enterprise Manager> Configuration Assistant
or Programs> Oracle- O901> Configuration and Migration Tools>
Enterprise Manager Configuration Assistant)
And if you have none, create a new repository - make sure ther's
enough room (Also check <Note 132126.1> Release notes)
#20
最后一段,我down掉备数据,再没起来!
Fri Nov 21 10:52:50 2008
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 15728640
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\Oracle\oradata\jxkh\control01.ctl, D:\Oracle\oradata\jxkh\control02.ctl, D:\Oracle\oradata\jxkh\control03.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = jxkh
service_names = jxkh
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = jxkh
open_cursors = 100
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\Oracle\admin\jxkh\bdump
user_dump_dest = D:\Oracle\admin\jxkh\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri Nov 21 10:52:53 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Nov 21 10:52:54 2008
alter database mount exclusive
Fri Nov 21 10:53:01 2008
Successful mount of redo thread 1, with mount id 2278429325.
Fri Nov 21 10:53:01 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Nov 21 10:53:01 2008
alter database open
Fri Nov 21 10:53:02 2008
Thread 1 opened at log sequence 41548
Current log# 1 seq# 41548 mem# 0: D:\ORACLE\ORADATA\JXKH\REDO03.LOG
Successful open of redo thread 1.
Fri Nov 21 10:53:02 2008
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Nov 21 10:53:16 2008
Completed: alter database open
Fri Nov 21 10:54:17 2008
Restarting dead background process EMN0
EMN0 started with pid=15
Fri Nov 21 10:54:17 2008
Shutting down instance (immediate)
License high water mark = 5
Fri Nov 21 10:54:20 2008
alter database close normal
Fri Nov 21 10:54:20 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Nov 21 10:54:22 2008
Thread 1 closed at log sequence 41548
Fri Nov 21 10:54:22 2008
Completed: alter database close normal
Fri Nov 21 10:54:22 2008
alter database dismount
Completed: alter database dismount
archiving is disabled
Fri Nov 21 10:52:50 2008
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 15728640
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\Oracle\oradata\jxkh\control01.ctl, D:\Oracle\oradata\jxkh\control02.ctl, D:\Oracle\oradata\jxkh\control03.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = jxkh
service_names = jxkh
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = jxkh
open_cursors = 100
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\Oracle\admin\jxkh\bdump
user_dump_dest = D:\Oracle\admin\jxkh\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri Nov 21 10:52:53 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Nov 21 10:52:54 2008
alter database mount exclusive
Fri Nov 21 10:53:01 2008
Successful mount of redo thread 1, with mount id 2278429325.
Fri Nov 21 10:53:01 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Nov 21 10:53:01 2008
alter database open
Fri Nov 21 10:53:02 2008
Thread 1 opened at log sequence 41548
Current log# 1 seq# 41548 mem# 0: D:\ORACLE\ORADATA\JXKH\REDO03.LOG
Successful open of redo thread 1.
Fri Nov 21 10:53:02 2008
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Nov 21 10:53:16 2008
Completed: alter database open
Fri Nov 21 10:54:17 2008
Restarting dead background process EMN0
EMN0 started with pid=15
Fri Nov 21 10:54:17 2008
Shutting down instance (immediate)
License high water mark = 5
Fri Nov 21 10:54:20 2008
alter database close normal
Fri Nov 21 10:54:20 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Nov 21 10:54:22 2008
Thread 1 closed at log sequence 41548
Fri Nov 21 10:54:22 2008
Completed: alter database close normal
Fri Nov 21 10:54:22 2008
alter database dismount
Completed: alter database dismount
archiving is disabled
#21
各位大侠,帮帮忙吧,数据恢复不起来,就要下岗了,拜托!!!
#22
晕,看这些成功的信息做什么
你在sql中用startup命令,把最新的错误信息贴上来
你在sql中用startup命令,把最新的错误信息贴上来
#23
c:\>oradim -startup -sid jxkh
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
你在服务器上执行以上的,看能连上不?
绝不可能是协议适配器错误
应该会是连接到空实例
#24
就是在服务器上做的
#25
对了,我记得当时我想DOWN数据库,我用SVRMGRL进也是报错,但sqlplus能进去,后来我把服务停了备的数据。
#26
alert.log里就是上面贴的,没有错误数据!
#27
帮顶!
#28
这个是单机还是RAC?
c:\>oradim -startup -sid jxkh
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
你依次执行,还是报错吗?
#29
谢谢!
RAC是什么?
我是用远程桌面登的服务器!
RAC是什么?
我是用远程桌面登的服务器!
#30
我现在最想不通的为什么以前备的数据,拷到全新安装的机器里也是同样的毛病。
#31
我重建了服务
oradim -new -sid jxkh
全部服务都能起来,但还是12560错误!
oradim -new -sid jxkh
全部服务都能起来,但还是12560错误!
#32
不知道你怎么搞,这么说吧,假设你要在新的机器上恢复数据库。
1) 把旧的数据库的参数文件、控制文件、日志文件、数据文件都copy到新机器上,目录要一致
2) 创建服务: oradim -new -sid jxkh
3) startup 到unmount状态
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
sql>startup pfile=参数文件的路径; --8i应该是pfile
这样子,应该就能启动了,其它的比如密码文件之类的以后再做。
1) 把旧的数据库的参数文件、控制文件、日志文件、数据文件都copy到新机器上,目录要一致
2) 创建服务: oradim -new -sid jxkh
3) startup 到unmount状态
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
sql>startup pfile=参数文件的路径; --8i应该是pfile
这样子,应该就能启动了,其它的比如密码文件之类的以后再做。
#1
操作系统是什么版本?
sqlplus "/as sysdba"
startup
把提示信息贴上来
sqlplus "/as sysdba"
startup
把提示信息贴上来
#2
oracle有这个可能,重启动机器后起不来,一般可能出现在大数据量操作,不能回滚而造成的.
#3
前天看到一帖,数据在D盘,C盘被格式化了,然后重装机器恢复库的.你找找.
#4
win2000
#5
2楼,sqlplus "/as sysdba" ,显示ora-12560协议适配器错误,可是在服务里是起来的。
#6
你这样恢复的话
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
#7
你这样恢复的话
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
我不太懂oracle,怎么做,谢谢!
你先重做一下 日志
实在不行的话
你重新配置一下 dbca 试试
我不太懂oracle,怎么做,谢谢!
#8
应该先shutdown。再全备份。你的IP地址又没有换?如果有换请把tns文件和listenner文件修改成主机名。再重启。
实例名是不是之前的一样的实例名,版本也要一致。
注意这三点。再试一下。
实例名是不是之前的一样的实例名,版本也要一致。
注意这三点。再试一下。
#9
tns文件和listenner文件都没问题,没改过ip,是shutdown后做的备份.
#10
同意这种方法,可以试试看
#11
有没有可能是微软补丁造成的,我以前打补丁都不重起机器!
#12
重启一下。等打完补丁包再试下。可能有冲突。
#13
还有重建listener就死机!
补丁都是以前打的,没新补丁,只不过一直没重起机器.
补丁都是以前打的,没新补丁,只不过一直没重起机器.
#14
你的oracle_sid没设置对吧?这个是不用listener的
c:\>set oracle_sid=你的实例名
再用sqlplus
#15
我重新装了一台机器,系统为2003,建同样数据库名,启动正常,拷入oradata的数据后,启动服务也是1053!
请教是何原因?
请教是何原因?
#16
解决ORA-12560: TNS: 协议适配器错误,与大家共享
今天遭遇ORA-12560: TNS: 协议适配器错误的问题,经过一番努力问题已经解决,与大家共享。
造成ORA-12560: TNS: 协议适配器错误的问题的原因有三个:
1.监听服务没有起起来。windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,
启动oraclehome92TNSlistener服务。
2.database instance没有起起来。windows平台如下操作:开始---程序---管理工具---服务,打开服务
面板,启动oracleserviceXXXX,XXXX就是你的database SID.
3.注册表问题。regedit,然后进入HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0将该环境变量ORACLE_SI
D设置为XXXX,XXXX就是你的database SID.或者右几我的电脑,属性--高级--环境变量---系统变量--新建
,变量名=oracle_sid,变量值=XXXX,XXXX就是你的database SID.或者进入sqlplus前,在command line下
输set oracle_sid=XXXX,XXXX就是你的database SID.
经过以上步骤,就可以解决问题。
ORA-12560:TNS:协议适配器错误
2.在机器上(4850Q)使用ORACLE 9I的服务器和 10G的客户端.
连接的时候,老报 ORA-12560:TNS:协议适配器错误
修改ORACLE_HOME\NETWORK\ADMIN\TNSNAMES.ORA
在里面添加本地主机的内容
GLIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = glis)
)
)
启动服务后,在CMD下,敲如下字幕:
>SET ORACLE_SID=GLIS
再连接,okey了.
今天遭遇ORA-12560: TNS: 协议适配器错误的问题,经过一番努力问题已经解决,与大家共享。
造成ORA-12560: TNS: 协议适配器错误的问题的原因有三个:
1.监听服务没有起起来。windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,
启动oraclehome92TNSlistener服务。
2.database instance没有起起来。windows平台如下操作:开始---程序---管理工具---服务,打开服务
面板,启动oracleserviceXXXX,XXXX就是你的database SID.
3.注册表问题。regedit,然后进入HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0将该环境变量ORACLE_SI
D设置为XXXX,XXXX就是你的database SID.或者右几我的电脑,属性--高级--环境变量---系统变量--新建
,变量名=oracle_sid,变量值=XXXX,XXXX就是你的database SID.或者进入sqlplus前,在command line下
输set oracle_sid=XXXX,XXXX就是你的database SID.
经过以上步骤,就可以解决问题。
ORA-12560:TNS:协议适配器错误
2.在机器上(4850Q)使用ORACLE 9I的服务器和 10G的客户端.
连接的时候,老报 ORA-12560:TNS:协议适配器错误
修改ORACLE_HOME\NETWORK\ADMIN\TNSNAMES.ORA
在里面添加本地主机的内容
GLIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = glis)
)
)
启动服务后,在CMD下,敲如下字幕:
>SET ORACLE_SID=GLIS
再连接,okey了.
#17
如果实例起不来,建议你把alert.log相关的错误贴出来,
大家帮忙分析
注: alert 文件位置
unix下在:$ORACLE_BASE/admin/sid/bdump下
windows:%ORACLE_BASE%/admin/sid/bdump下
大家帮忙分析
注: alert 文件位置
unix下在:$ORACLE_BASE/admin/sid/bdump下
windows:%ORACLE_BASE%/admin/sid/bdump下
#18
set oracle_sid=你的实例名
做了,键入用户名和密码后还是显示ora-12560协议适配器错误.
#19
主题: Starting OMS (Oracle Management Server) Fails with Error 1053 After Fresh Install
文档 ID: 注释:225459.1 类型: PROBLEM
上次修订日期: 09-JUL-2003 状态: PUBLISHED
fact: Oracle Enterprise Manager
fact: MS Windows 2000
fact: Ms Windows NT
symptom: Starting OMS (Oracle Management Server) Fails with Error 1053
After Fresh Install
symptom: Microsoft Managent Console reports errors
symptom: Error 1053: The service did not respond to the start or control
request
in a timely fashion.
Couldn't start the OracleOraHome81ManagementServer service on Local
Computer. The service didn't return an error. This could be an internal
service error.
symptom: Oms.nohup reports errors
symptom: ORA-00942: table or view does not exist
symptom: VXA-2017 : No Oracle Management Server services
symptom: Listener is running
symptom: Sqlnet connection works
change: VXA-2000 : Error encountered retrieving list of services to start:
cause: Probably the creation of repository wasn't succesfull (space errors)
fix:
Use EMCA to drop and recreate the repository
(Programs> Oracle- O817> Enterprise Manager> Configuration Assistant
or Programs> Oracle- O901> Configuration and Migration Tools>
Enterprise Manager Configuration Assistant)
And if you have none, create a new repository - make sure ther's
enough room (Also check <Note 132126.1> Release notes)
文档 ID: 注释:225459.1 类型: PROBLEM
上次修订日期: 09-JUL-2003 状态: PUBLISHED
fact: Oracle Enterprise Manager
fact: MS Windows 2000
fact: Ms Windows NT
symptom: Starting OMS (Oracle Management Server) Fails with Error 1053
After Fresh Install
symptom: Microsoft Managent Console reports errors
symptom: Error 1053: The service did not respond to the start or control
request
in a timely fashion.
Couldn't start the OracleOraHome81ManagementServer service on Local
Computer. The service didn't return an error. This could be an internal
service error.
symptom: Oms.nohup reports errors
symptom: ORA-00942: table or view does not exist
symptom: VXA-2017 : No Oracle Management Server services
symptom: Listener is running
symptom: Sqlnet connection works
change: VXA-2000 : Error encountered retrieving list of services to start:
cause: Probably the creation of repository wasn't succesfull (space errors)
fix:
Use EMCA to drop and recreate the repository
(Programs> Oracle- O817> Enterprise Manager> Configuration Assistant
or Programs> Oracle- O901> Configuration and Migration Tools>
Enterprise Manager Configuration Assistant)
And if you have none, create a new repository - make sure ther's
enough room (Also check <Note 132126.1> Release notes)
#20
最后一段,我down掉备数据,再没起来!
Fri Nov 21 10:52:50 2008
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 15728640
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\Oracle\oradata\jxkh\control01.ctl, D:\Oracle\oradata\jxkh\control02.ctl, D:\Oracle\oradata\jxkh\control03.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = jxkh
service_names = jxkh
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = jxkh
open_cursors = 100
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\Oracle\admin\jxkh\bdump
user_dump_dest = D:\Oracle\admin\jxkh\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri Nov 21 10:52:53 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Nov 21 10:52:54 2008
alter database mount exclusive
Fri Nov 21 10:53:01 2008
Successful mount of redo thread 1, with mount id 2278429325.
Fri Nov 21 10:53:01 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Nov 21 10:53:01 2008
alter database open
Fri Nov 21 10:53:02 2008
Thread 1 opened at log sequence 41548
Current log# 1 seq# 41548 mem# 0: D:\ORACLE\ORADATA\JXKH\REDO03.LOG
Successful open of redo thread 1.
Fri Nov 21 10:53:02 2008
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Nov 21 10:53:16 2008
Completed: alter database open
Fri Nov 21 10:54:17 2008
Restarting dead background process EMN0
EMN0 started with pid=15
Fri Nov 21 10:54:17 2008
Shutting down instance (immediate)
License high water mark = 5
Fri Nov 21 10:54:20 2008
alter database close normal
Fri Nov 21 10:54:20 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Nov 21 10:54:22 2008
Thread 1 closed at log sequence 41548
Fri Nov 21 10:54:22 2008
Completed: alter database close normal
Fri Nov 21 10:54:22 2008
alter database dismount
Completed: alter database dismount
archiving is disabled
Fri Nov 21 10:52:50 2008
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 15728640
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\Oracle\oradata\jxkh\control01.ctl, D:\Oracle\oradata\jxkh\control02.ctl, D:\Oracle\oradata\jxkh\control03.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = jxkh
service_names = jxkh
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = jxkh
open_cursors = 100
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\Oracle\admin\jxkh\bdump
user_dump_dest = D:\Oracle\admin\jxkh\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri Nov 21 10:52:53 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Nov 21 10:52:54 2008
alter database mount exclusive
Fri Nov 21 10:53:01 2008
Successful mount of redo thread 1, with mount id 2278429325.
Fri Nov 21 10:53:01 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Nov 21 10:53:01 2008
alter database open
Fri Nov 21 10:53:02 2008
Thread 1 opened at log sequence 41548
Current log# 1 seq# 41548 mem# 0: D:\ORACLE\ORADATA\JXKH\REDO03.LOG
Successful open of redo thread 1.
Fri Nov 21 10:53:02 2008
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Nov 21 10:53:16 2008
Completed: alter database open
Fri Nov 21 10:54:17 2008
Restarting dead background process EMN0
EMN0 started with pid=15
Fri Nov 21 10:54:17 2008
Shutting down instance (immediate)
License high water mark = 5
Fri Nov 21 10:54:20 2008
alter database close normal
Fri Nov 21 10:54:20 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Nov 21 10:54:22 2008
Thread 1 closed at log sequence 41548
Fri Nov 21 10:54:22 2008
Completed: alter database close normal
Fri Nov 21 10:54:22 2008
alter database dismount
Completed: alter database dismount
archiving is disabled
#21
各位大侠,帮帮忙吧,数据恢复不起来,就要下岗了,拜托!!!
#22
晕,看这些成功的信息做什么
你在sql中用startup命令,把最新的错误信息贴上来
你在sql中用startup命令,把最新的错误信息贴上来
#23
c:\>oradim -startup -sid jxkh
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
你在服务器上执行以上的,看能连上不?
绝不可能是协议适配器错误
应该会是连接到空实例
#24
就是在服务器上做的
#25
对了,我记得当时我想DOWN数据库,我用SVRMGRL进也是报错,但sqlplus能进去,后来我把服务停了备的数据。
#26
alert.log里就是上面贴的,没有错误数据!
#27
帮顶!
#28
这个是单机还是RAC?
c:\>oradim -startup -sid jxkh
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
你依次执行,还是报错吗?
#29
谢谢!
RAC是什么?
我是用远程桌面登的服务器!
RAC是什么?
我是用远程桌面登的服务器!
#30
我现在最想不通的为什么以前备的数据,拷到全新安装的机器里也是同样的毛病。
#31
我重建了服务
oradim -new -sid jxkh
全部服务都能起来,但还是12560错误!
oradim -new -sid jxkh
全部服务都能起来,但还是12560错误!
#32
不知道你怎么搞,这么说吧,假设你要在新的机器上恢复数据库。
1) 把旧的数据库的参数文件、控制文件、日志文件、数据文件都copy到新机器上,目录要一致
2) 创建服务: oradim -new -sid jxkh
3) startup 到unmount状态
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
sql>startup pfile=参数文件的路径; --8i应该是pfile
这样子,应该就能启动了,其它的比如密码文件之类的以后再做。
1) 把旧的数据库的参数文件、控制文件、日志文件、数据文件都copy到新机器上,目录要一致
2) 创建服务: oradim -new -sid jxkh
3) startup 到unmount状态
c:\>set oracle_sid=jxkh
c:\>sqlplus /nolog
sql>connect / as sysdba
sql>startup pfile=参数文件的路径; --8i应该是pfile
这样子,应该就能启动了,其它的比如密码文件之类的以后再做。