DATABASE IS NOT OPERATIONAL UPTO 30 MINUTES

[former_member189971]

Dear All,

Today I all of sudden the oracle database is down.

I have checked alert<SID>.log .. and where as I see the errors in dev_w0 as below.

database is not available betweenn the time invterval 11:29 to 12:32.

How to identify the root cause of the this issue.

Thanks in advance.

--------------------------------------------------------------------------------------------------------------------------------------

Fri Nov 28 11:23:12 2014

N  *** ERROR => SsfVerify failed (see note 1055856). [ssoxxsgn.c   144]

N  {root-id=0050569D56CF1EE49DD31DAF4BA96577}_{conn-id=0050569D56CF1EE49DD31DBA7828E577}_1

N   SsfVerify returned 5 :: SSF_API_SIGNER_ERRORS :: Error during verify - signer error.

N   SSF LIB returned 27 :: SSF_API_RECIPIENT_NOT_OK :: Operation not ok for recipient.

N  *** ERROR => ValidateTicket failed with rc = 5 and ssf_rc = 27. [ssoxxapi.c   235]

N  {root-id=0050569D56CF1EE49DD31DAF4BA96577}_{conn-id=0050569D56CF1EE49DD31DBA7828E577}_1

N  *** ERROR => Ticket validation failed with rc = 5 and ssf_rc = 27. [ssoxxkrn.c   993]

N  {root-id=0050569D56CF1EE49DD31DAF4BA96577}_{conn-id=0050569D56CF1EE49DD31DBA7828E577}_1

M Fri Nov 28 11:41:44 2014

-------------------------------------------------------------------------------------------------------------------------------------------------------

Regards,

Rama

[former_member189971 · Accepted solution]

Dear All,

Here is the History...

What happened :

CRM production server was down between the time interval 11:41 to 12:32.

I tried to check the logs in alert<sid>.log .. to identify what error caused for system down.

but I dont see any error logs in alert<sid>.log and LISTENER.log file's .

Then How to check the logs at OS level:

I have seen the logs in STO6-.OSlog

Hosting partner have been made changes to system during the business hours with out acknowledgement .. so system went down ... after that I have started it manually

Thanks for your valuable inputs ..

Regards,

Rama.

[former_member189971]

Hi

Actually LISTENER Is STOPPED and I have started it .. Manually.

I am unable to Identify the exact error ... so I request .. Kindly let me How to identify the exact errors.

for this issues.

This is a production sever.

Reards,

Rama

[former_member182657]

Hi Rama,

Could you share alert_<SID>.log and listener.log file for analysis.

Regards,

[karthikeyan_natarajan4]

Hi Rama,

In that case, please share us the complete listener.log

[former_member189971]

Fri Nov 28 11:01:12 2014

28-NOV-2014 11:01:12 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=64496)) * establish * CP1 * 0

Fri Nov 28 11:16:12 2014

28-NOV-2014 11:16:12 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=64872)) * establish * CP1 * 0

Fri Nov 28 11:31:12 2014

28-NOV-2014 11:31:12 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=65244)) * establish * CP1 * 0

Fri Nov 28 12:32:43 2014

System parameter file is /oracle/CP1/112_64/network/admin/listener.ora

Log messages written to /oracle/CP1/saptrace/diag/tnslsnr/cllxcdlccp01/listener/alert/log.xml

Trace information written to /oracle/CP1/saptrace/diag/tnslsnr/cllxcdlccp01/listener/trace/ora_5678_140584199296768.trc

Trace level is currently 0

Started with pid=5678

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=CP1.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=CP1)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.175.93.143)(PORT=1527)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

WARNING: Subscription for node down event still pending

28-NOV-2014 12:32:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=cllxcdlccp01)(USER=oracp1))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

Fri Nov 28 12:33:53 2014

28-NOV-2014 12:33:53 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=R3trans)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.175.93.1

43)(PORT=42602)) * establish * CP1 * 0

Fri Nov 28 12:34:44 2014

28-NOV-2014 12:34:44 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42627)) * establish * CP1 * 0

28-NOV-2014 12:34:44 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42628)) * establish * CP1 * 0

28-NOV-2014 12:34:44 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42629)) * establish * CP1 * 0

28-NOV-2014 12:34:44 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42630)) * establish * CP1 * 0

28-NOV-2014 12:34:44 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42631)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42632)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42634)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42633)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42635)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42636)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42637)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42639)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42638)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42640)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42641)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42642)) * establish * CP1 * 0

28-NOV-2014 12:34:45 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42643)) * establish * CP1 * 0

Fri Nov 28 12:35:09 2014

28-NOV-2014 12:35:09 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=42653)) * establish * CP1 * 0

Fri Nov 28 12:36:05 2014

28-NOV-2014 12:36:05 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=dw.sapCP1_DVEBMGS00)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST

=10.175.93.143)(PORT=42679)) * establish * CP1 * 0

Fri Nov 28 12:46:07 2014

28-NOV-2014 12:46:07 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=42914)) * establish * CP1 * 0

Fri Nov 28 13:01:07 2014

28-NOV-2014 13:01:07 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=43260)) * establish * CP1 * 0

Fri Nov 28 13:16:07 2014

28-NOV-2014 13:16:07 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=43596)) * establish * CP1 * 0

Fri Nov 28 13:25:38 2014

WARNING: Subscription for node down event still pending

28-NOV-2014 13:25:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=cllxcdlccp01)(USER=r736001))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

Fri Nov 28 13:31:07 2014

28-NOV-2014 13:31:07 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=43930)) * establish * CP1 * 0

Fri Nov 28 13:46:07 2014

28-NOV-2014 13:46:07 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=44269)) * establish * CP1 * 0

Fri Nov 28 14:01:07 2014

28-NOV-2014 14:01:07 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=44602)) * establish * CP1 * 0

Fri Nov 28 14:16:07 2014

28-NOV-2014 14:16:07 * (CONNECT_DATA=(SID=CP1)(GLOBAL_NAME=CP1.WORLD)(CID=(PROGRAM=tp@cllxcdlccp01)(HOST=cllxcdlccp01)(USER=cp1adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.

175.93.143)(PORT=44946)) * establish * CP1 * 0

Regards,

Rama

[former_member189971]

Hi Rana,

Below is the alert sid log.

Fri Nov 28 11:12:15 2014

Beginning log switch checkpoint up to RBA [0x4f7c.2.10], SCN: 524313226

Thread 1 advanced to log sequence 20348 (LGWR switch)

  Current log# 4 seq# 20348 mem# 0: /oracle/CP1/origlogB/log_g14m1.dbf

  Current log# 4 seq# 20348 mem# 1: /oracle/CP1/mirrlogB/log_g14m2.dbf

Fri Nov 28 11:12:16 2014

Archived Log entry 20030 added for thread 1 sequence 20347 ID 0xa114b2dc dest 1:

Fri Nov 28 11:17:24 2014

Completed checkpoint up to RBA [0x4f7c.2.10], SCN: 524313226

Fri Nov 28 11:29:40 2014

Incremental checkpoint up to RBA [0x4f7c.6550.0], current log tail at RBA [0x4f7c.68d7.0]

Fri Nov 28 12:32:02 2014

Starting ORACLE instance (normal)

****************** Large Pages Information *****************

Total Shared Global Region in Large Pages = 0 KB (0%)

Large Pages used by this instance: 0 (0 KB)

Large Pages unused system wide = 0 (0 KB) (alloc incr 32 MB)

Large Pages configured system wide = 0 (0 KB)

Large Page size = 2048 KB

RECOMMENDATION:

  Total Shared Global Region size is 8802 MB. For optimal performance,

  prior to the next instance restart increase the number

  of unused Large Pages by atleast 4401 2048 KB Large Pages (8802 MB)

  system wide to get 100% of the Shared

  Global Region allocated with Large pages

***********************************************************

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

ORACLE_HOME = /oracle/CP1/112_64

System name:    Linux

Node name:      cllxcdlccp01

Release:        2.6.32-358.0.1.el6.x86_64

Version:        #1 SMP Wed Feb 20 11:05:23 EST 2013

Machine:        x86_64

VM name:        VMWare Version: 6

Using parameter settings in server-side spfile /oracle/CP1/112_64/dbs/spfileCP1.ora

System parameters with non-default values:

  processes                = 150

  sessions                 = 300

  event                    = "44951 level 1024"

  event                    = "38085"

  event                    = "38068 level 100"

  event                    = "10995 level 2"

  event                    = "10191"

  event                    = "10142"

  event                    = "10028"

  event                    = "10183"

  event                    = "10027"

  event                    = "38087"

  shared_pool_size         = 4352M

  filesystemio_options     = "setall"

  _file_size_increase_increment= 2044M

  control_files            = "/oracle/CP1/oraflash/CP1/controlfile/o1_mf_9385r4xl_.ctl"

  control_file_record_keep_time= 30

  db_block_size            = 8192

  db_cache_size            = 4352M

  compatible               = "11.2.0"

  log_archive_dest_1       = "LOCATION=/oracle/CP1/oraarch/CP1arch"

  log_archive_format       = "%t_%s_%r.dbf"

  db_files                 = 256

  db_recovery_file_dest    = "/oracle/CP1/oraflash"

  db_recovery_file_dest_size= 30000M

  log_checkpoints_to_alert = TRUE

  replication_dependency_tracking= FALSE

  undo_tablespace          = "PSAPUNDO"

  _in_memory_undo          = FALSE

  _securefiles_concurrency_estimate= 50

  recyclebin               = "off"

  _mutex_wait_time         = 10

  _mutex_wait_scheme       = 1

  remote_os_authent        = TRUE

  remote_login_passwordfile= "EXCLUSIVE"

  parallel_execution_message_size= 16384

  _table_lookup_prefetch_size= 0

  _fix_control             = "9495669:ON"

  _fix_control             = "9196440:ON"

  _fix_control             = "8937971:ON"

  _fix_control             = "7168184:OFF"

  _fix_control             = "6972291:ON"

  _fix_control             = "6626018:ON"

  _fix_control             = "6440977:ON"

  _fix_control             = "6430500:ON"

  _fix_control             = "6399597:ON"

  _fix_control             = "6120483:OFF"

  _fix_control             = "6055658:OFF"

  _fix_control             = "5705630:ON"

  _fix_control             = "5099019:ON"

  audit_file_dest          = "/oracle/CP1/saptrace/audit"

  db_name                  = "CP1"

  open_cursors             = 2000

  _sort_elimination_cost_ratio= 10

  _b_tree_bitmap_plans     = FALSE

  star_transformation_enabled= "true"

  _optimizer_extended_cursor_sharing_rel= "NONE"

  _optimizer_adaptive_cursor_sharing= FALSE

  parallel_threads_per_cpu = 1

  optimizer_index_cost_adj = 20

  query_rewrite_enabled    = "false"

  _index_join_enabled      = FALSE

  _optim_peek_user_binds   = FALSE

  pga_aggregate_target     = 6060559564

  _optimizer_mjc_enabled   = FALSE

  _optimizer_use_feedback  = FALSE

  diagnostic_dest          = "/oracle/CP1/saptrace"

  max_dump_file_size       = "20000"

Deprecated system parameters with specified values:

  remote_os_authent

End of deprecated system parameter listing

Fri Nov 28 12:32:03 2014

PMON started with pid=2, OS id=5593

Fri Nov 28 12:32:03 2014

PSP0 started with pid=3, OS id=5595

Fri Nov 28 12:32:04 2014

VKTM started with pid=4, OS id=5597

VKTM running at (100ms) precision

Fri Nov 28 12:32:04 2014

GEN0 started with pid=5, OS id=5601

Fri Nov 28 12:32:04 2014

DIAG started with pid=6, OS id=5603

Fri Nov 28 12:32:04 2014

DBRM started with pid=7, OS id=5605

Fri Nov 28 12:32:04 2014

DIA0 started with pid=8, OS id=5607

Fri Nov 28 12:32:04 2014

MMAN started with pid=9, OS id=5609

Fri Nov 28 12:32:04 2014

DBW0 started with pid=10, OS id=5611

Fri Nov 28 12:32:04 2014

LGWR started with pid=11, OS id=5613

Fri Nov 28 12:32:04 2014

CKPT started with pid=12, OS id=5615

Fri Nov 28 12:32:04 2014

SMON started with pid=13, OS id=5617

Fri Nov 28 12:32:04 2014

RECO started with pid=14, OS id=5619

Fri Nov 28 12:32:04 2014

MMON started with pid=15, OS id=5621

Fri Nov 28 12:32:04 2014

MMNL started with pid=16, OS id=5623

ORACLE_BASE from environment = /oracle

Fri Nov 28 12:32:05 2014

ALTER DATABASE   MOUNT

Successful mount of redo thread 1, with mount id 2741198981

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE   MOUNT

Fri Nov 28 12:32:09 2014

ALTER DATABASE OPEN

Beginning crash recovery of 1 threads

parallel recovery started with 3 processes

Started redo scan

Completed redo scan

read 262 KB redo, 101 data blocks need recovery

Started redo application at

Thread 1: logseq 20348, block 48084

Recovery of Online Redo Log: Thread 1 Group 4 Seq 20348 Reading mem 0

  Mem# 0: /oracle/CP1/origlogB/log_g14m1.dbf

  Mem# 1: /oracle/CP1/mirrlogB/log_g14m2.dbf

Completed redo application of 0.09MB

Completed crash recovery at

Thread 1: logseq 20348, block 48608, scn 524338472

101 data blocks read, 101 data blocks written, 262 redo k-bytes read

LGWR: STARTING ARCH PROCESSES

Fri Nov 28 12:32:10 2014

ARC0 started with pid=21, OS id=5641

ARC0: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

ARC0: STARTING ARCH PROCESSES

Fri Nov 28 12:32:11 2014

ARC1 started with pid=22, OS id=5643

Fri Nov 28 12:32:11 2014

ARC2 started with pid=23, OS id=5645

ARC1: Archival started

ARC2: Archival started

Fri Nov 28 12:32:11 2014

ARC3 started with pid=24, OS id=5647

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

ARC2: Becoming the heartbeat ARCH

Thread 1 advanced to log sequence 20349 (thread open)

Thread 1 opened at log sequence 20349

  Current log# 1 seq# 20349 mem# 0: /oracle/CP1/origlogA/log_g11m1.dbf

  Current log# 1 seq# 20349 mem# 1: /oracle/CP1/mirrlogA/log_g11m2.dbf

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

Archived Log entry 20031 added for thread 1 sequence 20348 ID 0xa114b2dc dest 1:

[5629] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:2058794 end:2059064 diff:270 (2 seconds)

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is UTF8

No Resource Manager plan active

Starting background process QMNC

Fri Nov 28 12:32:13 2014

QMNC started with pid=25, OS id=5651

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

Incremental checkpoint up to RBA [0x4f7d.3.0], current log tail at RBA [0x4f7d.41.0]

Completed: ALTER DATABASE OPEN

Fri Nov 28 12:32:15 2014

db_recovery_file_dest_size of 30000 MB is 0.09% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Fri Nov 28 12:35:19 2014

Starting background process SMCO

Fri Nov 28 12:35:19 2014

SMCO started with pid=45, OS id=9920

Fri Nov 28 12:35:29 2014

Beginning log switch checkpoint up to RBA [0x4f7e.2.10], SCN: 524351088

Thread 1 advanced to log sequence 20350 (LGWR switch)

  Current log# 2 seq# 20350 mem# 0: /oracle/CP1/origlogB/log_g12m1.dbf

  Current log# 2 seq# 20350 mem# 1: /oracle/CP1/mirrlogB/log_g12m2.dbf

Fri Nov 28 12:35:30 2014

Archived Log entry 20032 added for thread 1 sequence 20349 ID 0xa114b2dc dest 1:

Fri Nov 28 12:40:35 2014

Completed checkpoint up to RBA [0x4f7e.2.10], SCN: 524351088

Fri Nov 28 13:02:16 2014

Incremental checkpoint up to RBA [0x4f7e.a2fe.0], current log tail at RBA [0x4f7e.c8d7.0]

Fri Nov 28 13:03:00 2014

Beginning log switch checkpoint up to RBA [0x4f7f.2.10], SCN: 524363335

Thread 1 advanced to log sequence 20351 (LGWR switch)

  Current log# 3 seq# 20351 mem# 0: /oracle/CP1/origlogA/log_g13m1.dbf

  Current log# 3 seq# 20351 mem# 1: /oracle/CP1/mirrlogA/log_g13m2.dbf

Fri Nov 28 13:03:00 2014

Archived Log entry 20033 added for thread 1 sequence 20350 ID 0xa114b2dc dest 1:

Fri Nov 28 13:08:02 2014

Completed checkpoint up to RBA [0x4f7f.2.10], SCN: 524363335

Fri Nov 28 13:28:12 2014

Beginning log switch checkpoint up to RBA [0x4f80.2.10], SCN: 524368867

Thread 1 advanced to log sequence 20352 (LGWR switch)

  Current log# 4 seq# 20352 mem# 0: /oracle/CP1/origlogB/log_g14m1.dbf

  Current log# 4 seq# 20352 mem# 1: /oracle/CP1/mirrlogB/log_g14m2.dbf

Fri Nov 28 13:28:13 2014

Archived Log entry 20034 added for thread 1 sequence 20351 ID 0xa114b2dc dest 1:

Fri Nov 28 13:32:18 2014

Incremental checkpoint up to RBA [0x4f7f.c8d7.0], current log tail at RBA [0x4f80.160f.0]

Fri Nov 28 13:33:12 2014

Completed checkpoint up to RBA [0x4f80.2.10], SCN: 524368867

Fri Nov 28 14:02:20 2014

Incremental checkpoint up to RBA [0x4f80.423a.0], current log tail at RBA [0x4f80.7926.0]

Fri Nov 28 14:12:10 2014

Beginning log switch checkpoint up to RBA [0x4f81.2.10], SCN: 524376786

Thread 1 advanced to log sequence 20353 (LGWR switch)

  Current log# 1 seq# 20353 mem# 0: /oracle/CP1/origlogA/log_g11m1.dbf

  Current log# 1 seq# 20353 mem# 1: /oracle/CP1/mirrlogA/log_g11m2.dbf

Fri Nov 28 14:12:11 2014

Archived Log entry 20035 added for thread 1 sequence 20352 ID 0xa114b2dc dest 1:

Fri Nov 28 14:17:19 2014

Completed checkpoint up to RBA [0x4f81.2.10], SCN: 524376786

[former_member182657]

Hi Rama,

Kindly follow SAP Note   1055856 - Common error messages when setting up Single Sign-On

point 4 under solutions.

Regards,

Gaurav

[former_member189971]

Hi Rana,

Thanks for the quick response.

Is this cause for the Oracle Instance down ? 

Regards,

Rama