疑难杂症 standby ORA-12535: TNS:operation timed out

显示全部楼层 · 2009-10-9 08:28:00

1 以前standby系统一直正常

2 由于需要将此系统IP更换
更换前将
alter system set log_archive_dest_state_3=defer;

3 改动完成后
将主备的 ip 修改过来
将standby 系统启动到 recovery 模式

4主库 tnsping 备库正常
备库 read only 状态下可以在主库 sqlplus user/pass@standby 登录

说明主库到备库网路是通的
5 将 alter system set log_archive_dest_state_3=enable；
发现报错 ORA-12535
select *
from v$archive_dest_status
where status != 'INACTIVE';

千问 · 2009-10-9 08:28:00

重做依然百思不得其解

千问 · 2009-10-9 08:28:00

如果将 archivelog copy过去 register 还是可以恢复的

千问 · 2009-10-9 08:28:00

备库监听重启下试过吗？注意不要reload，stop再start

千问 · 2009-10-9 08:28:00

sure

千问 · 2009-10-9 08:28:00

除了修改ip地址然后再改回来，还有什么修改过吗？比如主机名，域名，listener.ora或者tnsnames.ora

千问 · 2009-10-9 08:28:00

帅哥这些俺还是会的

千问 · 2009-10-9 08:28:00

那就奇怪了

要不把alert包含ORA-12535这个错误的上下几行都贴出来瞧瞧？
或许确实不是oracle的问题，网络确实有问题那？tnsping多少毫秒？

千问 · 2009-10-9 08:28:00

log_archive_dest_1
stringlocation=/oraarch/hw3c
log_archive_dest_10
string
log_archive_dest_2
stringservice=std_HW3C delay=360
log_archive_dest_3
stringservice=std_HW3CP optional
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_4
stringservice=std_HW3CPT optional
log_archive_dest_5
string
log_archive_dest_6
string
log_archive_dest_7
string
log_archive_dest_8
string
log_archive_dest_9
string
log_archive_dest_state_1
stringenable
log_archive_dest_state_10
stringenable
log_archive_dest_state_2
stringDEFER
log_archive_dest_state_3
stringDEFER

$ tnsping std_HW3CP
TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production on 16-OCT-2008 09:25:23
Copyright (c) 1997 Oracle Corporation.All rights reserved.
Used parameter files:
/data1/orahw3c/hw3cdb/9.2.0/network/admin/HW3C_h3cmr01-or/sqlnet_ifile.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=10.63.8.42)(PORT=1521)) (CONNECT_DATA= (SID=HW3C)))
OK (20 msec)
$ exit

Errors in file /data1/orahw3c/hw3cdb/9.2.0/admin/HW3C_h3cmr01-or/bdump/hw3c_arc1_5853552.trc:
ORA-12535: TNS

peration timed out
Creating archive destination LOG_ARCHIVE_DEST_1: '/oraarch/hw3c/redo_1_24494.dbf'
ARC0: Completed archivinglog 3 thread 1 sequence 24494
orahw3c@h3cmr01-or-HW3C> sqlplus apps/apps@std_HW3CP
SQL*Plus: Release 9.2.0.6.0 - Production on Thu Oct 16 09:36:13 2008
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

千问 · 2009-10-9 08:28:00

orahw3c@h3cmr01-or-HW3C> ping 10.63.8.42
PING 10.63.8.42: (10.63.8.42): 56 data bytes
64 bytes from 10.63.8.42: icmp_seq=0 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=1 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=2 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=3 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=4 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=5 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=6 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=7 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=8 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=9 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=10 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=11 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=12 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=13 ttl=255 time=0 ms
64 bytes from 10.63.8.42: icmp_seq=14 ttl=255 time=0 ms
^C
----10.63.8.42 PING Statistics----
15 packets transmitted, 15 packets received, 0% packet loss
round-trip min/avg/max = 0/0/0 ms
You have mail in /usr/spool/mail/orahw3c

并且standby open read only 是可以连的

select name,value from v$parameter where name like '%fal%';
select name,value from v$parameter where name like '%log%';
alter system set log_archive_dest_state_3=enable;
alter system set fal_client='std_HW3CP';
select *
from v$archive_dest_status
where status != 'INACTIVE';