Martin Liu

Martin Liu

Developer Advocate, DevOps China Community Organizer

liuadmin

1 分钟

ARS 版本 7.6.04 数据库 Oracle11G 和 ARS 在同一台服务器上

错误现象: ARS 服务不能正常启动

arerror.log报 390600 : SQL 数据库不可用 -- 将重试连接 (ARNOTE 590)
Sat Apr 02 20:27:41 2011 : Action Request System(R) 服务器 x64 版本 7.6.04 Build 002 201101141059
(c) Copyright 1991-2010 BMC Software, Inc.
Sat Apr 02 20:29:51 2011  390600 : SQL 数据库不可用 -- 将重试连接 (ARNOTE 590)
Sat Apr 02 20:29:51 2011     ORA-12170: TNS:Connect timeout occurred

排错步骤: 使用 sqlplus 测试登录,返回 TNS 超时错误

[powershell]
 C:\Users\martin>sqlplus ARAdmin/AR#Admin#@ars
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 2 20:48:35 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred  
[/powershell]

使用 tnsping ars 测试也不成功 ping 本机主机名

[powershell]
ping arsserver
Pinging arsserver [fe80::c123:5921:b71b:64fd%13] with 32 bytes of data:
Reply from fe80::c123:5921:b71b:64fd%13: time<1ms
Reply from fe80::c123:5921:b71b:64fd%13: time<1ms
Reply from fe80::c123:5921:b71b:64fd%13: time<1ms
Reply from fe80::c123:5921:b71b:64fd%13: time<1ms
Ping statistics for fe80::c123:5921:b71b:64fd%13:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms 
[/powershell]

貌似找到原因,修改 host 文件,加入主机名到 127.0.0.1 后面,在测试 ping 主机名成功。 重启 Oracle 监听器服务,再次测试 tnsping 和 sqlplus ,测试都获得成功。 重新启动 ARS 服务,服务被正常启动

最新文章

分类

关于

This Blog is sharing DevOps and SRE ariticles. I am translator of DevOps Handbook and SRE Workbook.