Oracle Database Discussions

oracle 10gr2
soalris 9

Hi ,

I keep getting these follwoing errors in alert log file of primary database.
I got this for a while and stopped after issuing the "alter system switch logifle"
command few times and once standby started applying logs.

What could be the reason?

PRIMARY
------------


ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC0]: Heartbeat failed to connect to standby 'entrust.on.newsun.tcp'. Erro
r is 12154.
Tue May 6 11:52:48 2008
Error 12154 received logging on to the standby
Tue May 6 11:52:48 2008
Errors in file /orahome/oracle/admin/10.2.0/entrust/bdump/entrust_arc0_16700.trc
:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC0]: Heartbeat failed to connect to standby 'entrust.on.newsun.tcp'. Erro
r is 12154.
Tue May 6 11:55:24 2008
Thread 1 advanced to log sequence 231
Current log# 3 seq# 231 mem# 0: /ora/oradata/entrust/redo03.log
Current log# 3 seq# 231 mem# 1: /ora1/oradata/entrust/redo03a.log
Thread 1 advanced to log sequence 232
Current log# 1 seq# 232 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 232 mem# 1: /ora1/oradata/entrust/redo01a.log
Thread 1 cannot allocate new log, sequence 233
Checkpoint not complete
Current log# 1 seq# 232 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 232 mem# 1: /ora1/oradata/entrust/redo01a.log
Tue May 6 11:55:35 2008
Thread 1 advanced to log sequence 233
Current log# 2 seq# 233 mem# 0: /ora/oradata/entrust/redo02.log
Current log# 2 seq# 233 mem# 1: /ora1/oradata/entrust/redo02a.log
Tue May 6 11:57:19 2008
Thread 1 advanced to log sequence 234
Current log# 3 seq# 234 mem# 0: /ora/oradata/entrust/redo03.log
Current log# 3 seq# 234 mem# 1: /ora1/oradata/entrust/redo03a.log
Tue May 6 12:01:03 2008
Thread 1 advanced to log sequence 235
Current log# 1 seq# 235 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 235 mem# 1: /ora1/oradata/entrust/redo01a.log
Thread 1 cannot allocate new log, sequence 236
Checkpoint not complete
Current log# 1 seq# 235 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 235 mem# 1: /ora1/oradata/entrust/redo01a.log
Thread 1 advanced to log sequence 236
Current log# 2 seq# 236 mem# 0: /ora/oradata/entrust/redo02.log
Current log# 2 seq# 236 mem# 1: /ora1/oradata/entrust/redo02a.log
Tue May 6 12:18:16 2008
Thread 1 advanced to log sequence 237
Current log# 3 seq# 237 mem# 0: /ora/oradata/entrust/redo03.log
Current log# 3 seq# 237 mem# 1: /ora1/oradata/entrust/redo03a.log
Thread 1 advanced to log sequence 238
Current log# 1 seq# 238 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 238 mem# 1: /ora1/oradata/entrust/redo01a.log
Tue May 6 12:20:06 2008
Thread 1 advanced to log sequence 239
Current log# 2 seq# 239 mem# 0: /ora/oradata/entrust/redo02.log
Current log# 2 seq# 239 mem# 1: /ora1/oradata/entrust/redo02a.log
Thread 1 advanced to log sequence 240
Current log# 3 seq# 240 mem# 0: /ora/oradata/entrust/redo03.log
Current log# 3 seq# 240 mem# 1: /ora1/oradata/entrust/redo03a.log
Tue May 6 15:55:42 2008
Thread 1 advanced to log sequence 241
Current log# 1 seq# 241 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 241 mem# 1: /ora1/oradata/entrust/redo01a.log
Thread 1 advanced to log sequence 242
Current log# 2 seq# 242 mem# 0: /ora/oradata/entrust/redo02.log
Current log# 2 seq# 242 mem# 1: /ora1/oradata/entrust/redo02a.log
Tue May 6 16:22:51 2008
alter database backup controlfile to trace
Tue May 6 16:23:07 2008
Completed: alter database backup controlfile to trace
Tue May 6 16:23:13 2008
Thread 1 advanced to log sequence 243
Current log# 3 seq# 243 mem# 0: /ora/oradata/entrust/redo03.log
Current log# 3 seq# 243 mem# 1: /ora1/oradata/entrust/redo03a.log
Thread 1 advanced to log sequence 244
Current log# 1 seq# 244 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 244 mem# 1: /ora1/oradata/entrust/redo01a.log
Tue May 6 16:50:16 2008
Thread 1 advanced to log sequence 245
Current log# 2 seq# 245 mem# 0: /ora/oradata/entrust/redo02.log
Current log# 2 seq# 245 mem# 1: /ora1/oradata/entrust/redo02a.log
Thread 1 advanced to log sequence 246
Current log# 3 seq# 246 mem# 0: /ora/oradata/entrust/redo03.log
Current log# 3 seq# 246 mem# 1: /ora1/oradata/entrust/redo03a.log
Tue May 6 22:02:28 2008
Thread 1 advanced to log sequence 247
Current log# 1 seq# 247 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 247 mem# 1: /ora1/oradata/entrust/redo01a.log
Wed May 7 05:00:57 2008
Thread 1 advanced to log sequence 248
Current log# 2 seq# 248 mem# 0: /ora/oradata/entrust/redo02.log
Current log# 2 seq# 248 mem# 1: /ora1/oradata/entrust/redo02a.log
Wed May 7 07:33:02 2008
Thread 1 advanced to log sequence 249
Current log# 3 seq# 249 mem# 0: /ora/oradata/entrust/redo03.log
Current log# 3 seq# 249 mem# 1: /ora1/oradata/entrust/redo03a.log
Thread 1 advanced to log sequence 250
Current log# 1 seq# 250 mem# 0: /ora/oradata/entrust/redo01.log
Current log# 1 seq# 250 mem# 1: /ora1/oradata/entrust/redo01a.log
Wed May 7 08:59:57 2008
Thread 1 advanced to log sequence 251
Current log# 2 seq# 251 mem# 0: /ora/oradata/entrust/redo02.log
Current log# 2 seq# 251 mem# 1: /ora1/oradata/entrust/redo02a.log


STANDBY
---------------

RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_242_653'
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_243_653'
Tue May 6 16:29:33 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_242_6538642l
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_243_6538642l
Media Recovery Waiting for thread 1 sequence 244
Tue May 6 16:56:21 2008
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_244_653'
Tue May 6 16:56:22 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_244_6538642l
Tue May 6 16:56:23 2008
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_245_653'
Tue May 6 16:56:24 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_245_6538642l
Media Recovery Waiting for thread 1 sequence 246
Tue May 6 22:08:35 2008
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_246_653'
Tue May 6 22:08:45 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_246_6538642l
Tue May 6 22:09:35 2008
Media Recovery Waiting for thread 1 sequence 247
Wed May 7 05:07:03 2008
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_247_653'
Wed May 7 05:07:07 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_247_6538642l
Wed May 7 05:07:53 2008
Media Recovery Waiting for thread 1 sequence 248
Wed May 7 07:39:07 2008
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_248_653'
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_249_653'
Wed May 7 07:39:11 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_248_6538642l
Wed May 7 07:39:22 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_249_6538642l
Media Recovery Waiting for thread 1 sequence 250
Wed May 7 09:06:02 2008
RFS[2]: No standby redo logfiles created
RFS[2]: Archived Log: '/orahome/oracle/admin/10.2.0/entrust/arch/arch_1_250_653'
Wed May 7 09:06:05 2008
Media Recovery Log /orahome/oracle/admin/10.2.0/entrust/arch/arch_1_250_6538642l
Media Recovery Waiting for thread 1 sequence 251

Message was edited by:
user539835