ORA-00205: error in identifying control file while...

sbmrafikul2 · ‎03-22-2016

Dear Experts,

Trying to install db instance in oracle RAC and found the below error message on perform oracle post load activities

I have already checked the control files physically, it's present. But sap installer not able to identify the soft link for the ASM control file and mount it. SAP Installer starts the instance and not able to identify control files later. We can manually Mount and Open the db instance with SID as "SID".

If, we start the instance in mount state & Retry for SAP Installer to Mount, it errors stating Instance number is BUSY.

From sapinst_dev.log

TRACE 2016-03-21 09:08:57.824 (root/sapinst) [syuxctask.cpp:539] CUnixProcessManager::sap_waitpid()

Child process 24422 returned 0

TRACE 2016-03-21 09:08:57.840 (root/sapinst) [syuxctask.cpp:229] CChildApplicationImpl::doStart()

A child process has been started. Pid = 24423

TRACE 2016-03-21 09:08:57.867 (root/sapinst) [syuxctask.cpp:539] CUnixProcessManager::sap_waitpid()

Child process 24423 returned 0

ERROR 2016-03-21 09:08:57.876 (root/sapinst) [CSiStepExecute.cpp:1210] id=controller.stepExecuted errno=FCO-00011

The step convertPFileToSPFile with step key |NW_Java_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_Postload|ind|ind|ind|ind|postload|0|NW_Postload_ORA|ind|ind|ind|ind|ora|0|convertPFileToSPFile was executed with status ERROR ( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: ORA-00205: error in identifying control file, check alert log for more info

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

From alert_SID.log

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

With the Partitioning, Real Application Clusters, Oracle Label Security, Oracle Database Vault

and Real Application Testing options.

ORACLE_HOME = /oracle/SID/112

System name: Linux

Node name:

Release: 2.6.32-504.16.2.el6.x86_64

Version: #1 SMP Tue Mar 10 17:01:00 EDT 2015

Machine: x86_64

VM name: VMWare Version: 6

Using parameter settings in server-side pfile /oracle/SID/112/dbs/initSS2.ora

System parameters with non-default values:

processes = 1000

sessions = 2000

filesystemio_options = "setall"

memory_target = 10G

memory_max_target = 50G

control_files = "+DATA/sid/cntrlss2_01.ctl"

control_files = "+RECO/sid/cntrlss2_02.ctl"

control_files = "+FLASH/sid/cntrlss2_03.ctl"

control_file_record_keep_time= 30

db_block_size = 8192

compatible = "11.2.0.4"

log_archive_dest_1 = "LOCATION=+FLASH/SID/oraarch"

log_archive_format = "SID_%s_%r_%t.arc"

cluster_database = FALSE

db_recovery_file_dest = "+FLASH"

db_recovery_file_dest_size= 30000M

replication_dependency_tracking= FALSE

_in_memory_undo = FALSE

recyclebin = "on"

remote_os_authent = FALSE

remote_login_passwordfile= "EXCLUSIVE"

remote_listener = "pppspor-cluster-scan:1521"

parallel_execution_message_size= 16384

_table_lookup_prefetch_size= 0

audit_file_dest = "/oracle/SID/saptrace/audit"

db_name = "SID"

open_cursors = 2000

_sort_elimination_cost_ratio= 10

_b_tree_bitmap_plans = FALSE

star_transformation_enabled= "true"

parallel_threads_per_cpu = 2

query_rewrite_enabled = "true"

_index_join_enabled = FALSE

_optim_peek_user_binds = FALSE

_optimizer_mjc_enabled = FALSE

diagnostic_dest = "/oracle/SID/saptrace"

max_dump_file_size = "20000"

Deprecated system parameters with specified values:

remote_os_authent

End of deprecated system parameter listing

Cluster communication is configured to use the following interface(s) for this instance

10.35.103.13

cluster interconnect IPC version:Oracle UDP/IP (generic)

IPC Vendor 1 proto 2

Mon Mar 21 09:08:50 2016

PMON started with pid=2, OS id=24342

Mon Mar 21 09:08:50 2016

PSP0 started with pid=3, OS id=24344

Mon Mar 21 09:08:51 2016

VKTM started with pid=4, OS id=24348

VKTM running at (100ms) precision

Mon Mar 21 09:08:51 2016

GEN0 started with pid=5, OS id=24352

Mon Mar 21 09:08:51 2016

DIAG started with pid=6, OS id=24354

Mon Mar 21 09:08:51 2016

DBRM started with pid=7, OS id=24356

Mon Mar 21 09:08:51 2016

PING started with pid=8, OS id=24358

Mon Mar 21 09:08:51 2016

ACMS started with pid=9, OS id=24360

Mon Mar 21 09:08:51 2016

DIA0 started with pid=10, OS id=24362

Mon Mar 21 09:08:51 2016

LMON started with pid=11, OS id=24364

Mon Mar 21 09:08:51 2016

LMD0 started with pid=12, OS id=24366

* Load Monitor used for high load check

* New Low - High Load Threshold Range = [15360 - 20480]

Mon Mar 21 09:08:51 2016

RMS0 started with pid=13, OS id=24368

Mon Mar 21 09:08:51 2016

LMHB started with pid=14, OS id=24370

Mon Mar 21 09:08:51 2016

MMAN started with pid=15, OS id=24372

Mon Mar 21 09:08:51 2016

DBW0 started with pid=16, OS id=24374

Mon Mar 21 09:08:51 2016

DBW1 started with pid=17, OS id=24376

Mon Mar 21 09:08:51 2016

LGWR started with pid=18, OS id=24379

Mon Mar 21 09:08:51 2016

CKPT started with pid=19, OS id=24381

Mon Mar 21 09:08:51 2016

SMON started with pid=20, OS id=24383

Mon Mar 21 09:08:51 2016

RECO started with pid=21, OS id=24385

Mon Mar 21 09:08:52 2016

RBAL started with pid=22, OS id=24387

Mon Mar 21 09:08:52 2016

ASMB started with pid=23, OS id=24391

Errors in file /oracle/SID/saptrace/diag/rdbms/ss2/SS2/trace/SID_asmb_24391.trc:

ORA-15055: unable to connect to ASM instance

ORA-27300: OS system dependent operation:open failed with status: 13

ORA-27301: OS failure message: Permission denied

ORA-27302: failure occurred at: sskgmsmr_7

Mon Mar 21 09:08:52 2016

MMON started with pid=24, OS id=24393

Mon Mar 21 09:08:52 2016

MMNL started with pid=23, OS id=24395

lmon registered with NM - instance number 1 (internal mem no 0)

Reconfiguration started (old inc 0, new inc 2)

List of instances:

1 (myinst: 1)

Global Resource Directory frozen

* allocate domain 0, invalid = TRUE

Communication channels reestablished

Master broadcasted resource hash value bitmaps

Non-local Process blocks cleaned out

Set master node info

Submitted all remote-enqueue requests

Dwn-cvts replayed, VALBLKs dubious

All grantable enqueues granted

Post SMON to start 1st pass IR

Submitted all GCS remote-cache requests

Post SMON to start 1st pass IR

Reconfiguration complete

ORACLE_BASE not set in environment. It is recommended

that ORACLE_BASE be set in the environment

Mon Mar 21 09:08:53 2016

ALTER DATABASE MOUNT

Starting background process ASMB

Mon Mar 21 09:08:53 2016

ASMB started with pid=26, OS id=24402

Starting background process ASMB

Mon Mar 21 09:08:56 2016

ASMB started with pid=27, OS id=24415

Mon Mar 21 09:08:56 2016

Starting background process ASMB

Mon Mar 21 09:08:56 2016

ASMB started with pid=27, OS id=24417

Starting background process ASMB

Mon Mar 21 09:08:56 2016

ASMB started with pid=27, OS id=24419

ORA-00210: cannot open the specified control file

ORA-00202: control file: '+FLASH/sid/cntrlss2_03.ctl'

ORA-17503: ksfdopn:2 Failed to open file +FLASH/sid/cntrlss2_03.ctl

ORA-15001: diskgroup "FLASH" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

ORA-27300: OS system dependent operation:open failed with status: 13

ORA-27301: OS failure message: Permission denied

ORA-27302: failure occurred at: sskgmsmr_7

ORA-00210: cannot open the specified control file

ORA-00202: control file: '+RECO/sid/cntrlss2_02.ctl'

ORA-17503: ksfdopn:2 Failed to open file +RECO/sid/cntrlss2_02.ctl

ORA-15001: diskgroup "RECO" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

ORA-27300: OS system dependent operation:open failed with status: 13

ORA-27301: OS failure message: Permission denied

ORA-27302: failure occurred at: sskgmsmr_7

ORA-00210: cannot open the specified control file

ORA-00202: control file: '+DATA/sid/cntrlss2_01.ctl'

ORA-17503: ksfdopn:2 Failed to open file +DATA/sid/cntrlss2_01.ctl

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

ORA-27300: OS system dependent operation:open failed with status: 13

ORA-27301: OS failure message: Permission denied

ORA-27302: failure occurred at: sskgmsmr_7

ORA-205 signalled during: ALTER DATABASE MOUNT...

Starting background process ASMB

Mon Mar 21 09:08:59 2016

ASMB started with pid=25, OS id=24440

Starting background process ASMB

Mon Mar 21 09:09:02 2016

ASMB started with pid=25, OS id=24467

Starting background process ASMB

Mon Mar 21 09:09:05 2016

ASMB started with pid=25, OS id=24497

Mon Mar 21 09:09:08 2016

Starting background process ASMB

Mon Mar 21 09:09:08 2016

ASMB started with pid=25, OS id=24559

Starting background process ASMB

Mon Mar 21 09:09:08 2016

ASMB started with pid=25, OS id=24561

Starting background process ASMB

Mon Mar 21 09:09:12 2016

ASMB started with pid=25, OS id=24567

Starting background process ASMB

Mon Mar 21 09:09:12 2016

ASMB started with pid=25, OS id=24569

Starting background process ASMB

Mon Mar 21 09:09:12 2016

ASMB started with pid=25, OS id=24571

From Ora_sql_results.log

2016-03-21, 15:56:46 SAPINST ORACLE start logging for SHUTDOWN IMMEDIATE;exit;Output of SQL executing program:SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 15:56:46 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

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

With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,

Oracle Database Vault and Real Application Testing options

Database closed.

Database dismounted.

ORACLE instance shut down.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,

Oracle Database Vault and Real Application Testing options

SAPINST: End of output of SQL executing program /oracle/SID/112/bin/sqlplus. 2016-03-21, 15:57:14 SAPINST ORACLE stop logging

================================================================================

2016-03-21, 15:57:14 SAPINST ORACLE start logging for STARTUP MOUNT;exit;Output of SQL executing program:

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 15:57:14 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started.

Total System Global Area 5.3447E+10 bytes

Fixed Size 2265864 bytes

Variable Size 4.9795E+10 bytes

Database Buffers 3623878656 bytes

Redo Buffers 26480640 bytes

ORA-00205: error in identifying control file, check alert log for more info

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Oracle Label Security, Oracle Database Vault

and Real Application Testing options

SAPINST: End of output of SQL executing program /oracle/SID/112/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2016-03-21, 15:57:27 SAPINST ORACLE stop logging

Any Hint.

Regards,

sbmrafikul2 · ‎03-24-2016

Dear All,

Thanks for your comments.

In my scenario, both nodes are up and running. Owner with wich Oracle software are correct as already 3 DB instances are running & +DATA, +RECO, +FLASH etc are mounted.

Meanwhile I got two point from Oracle installation guide "SAP Databases on Oracle Automatic Storage Management 11g Release 2 Configuration Guidelines for UNIX and Linux Platforms "

Server Parameter File For customers who run their database and Oracle ASM on a single host or a RAC cluster with a shared <OHRDBMS> it is recommended to place the spfile for the database instance under <OHRDBMS>/dbs. Placing the spfile outside Oracle ASM allows much easier handling.

Example: SQL> create spfile='spfileRM1.ora' from pfile='initRM1.ora'; File created. SQL>

Customers who do not run a RAC cluster with a shared file system for <OHRDBMS> or customers who want to place the spfile on Oracle ASM for any other reason can use the following command to create the spfile on Oracle ASM.

Example: create spfile='+DATA/RM1/spfileRM1.ora' from pfile='initRM1.ora'; Please note that 'spfileRM1.ora' is just an alias on Oracle ASM:

Example: Oracle ASMCMD> ls -l Type Redund Striped Sys Name N spfileRM1.ora => +DATA/RM1/PARAMETERFILE/spfile.267.737217857

Although it is recommended that you use 'srvctl' to startup and shutdown your database, it may be necessary to startup and shutdown the database with 'sqlplus'. In this case you need an additional pfile under <OHRDBMS>/dbs which points to the spfile on Oracle ASM.

Example: initRM1.ora: SPFILE=’+DATA/RM1/spfileRM1.ora’

Also "Register the new database and <OHRDBMS> with the GRID stack. "

As I am mid of sapinst, should I have to perform the above mentioned steps.

Kindly advise.

Regards,

Former Member · ‎03-23-2016

hi try this:- You need startup ASM1 and ASM2 instances on both nodes and use correct service names. then check crs_stat if all services come online try to connect your database

Former Member · ‎03-23-2016

Please check the owner with wich Oracle software has been installed. Also what tool (asmlib, udev) you are using to manage disk devices?

former_member185239 · ‎03-22-2016

Dear Jituda,

I think the +DATA diskgroup is not mounted.

ORA-15001: diskgroup "DATA" does not exist or is not mounted

You can ask the database team to mount the disk group in asm.

With Regards

Ashutosh Chaturvedi

Former Member · ‎03-22-2016

Hi,

What is the ASM configuration setup here?. Looks like the ASM instance could be down from Alertlog file.

ORA-00210: cannot open the specified control file

ORA-00202: control file: '+FLASH/sid/cntrlss2_03.ctl'

ORA-17503: ksfdopn:2 Failed to open file +FLASH/sid/cntrlss2_03.ctl

ORA-15001: diskgroup "FLASH" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

Cheers.

kalyan

Sriram2009 · ‎03-22-2016

Hi

1. If possible restart the full system and then try again in the same phase.

2. Could you check the Oracle parameters as mention in the SAP Note for error message ".ORA-32004: obsolete or deprecated parameter "

1431798 - Oracle 11.2.0: Database Parameter Settings

3. Check the over all disk free space in Usr & database dirves

Regards

SS

ORA-00205: error in identifying control file while trying to install DB instance on Oracle RAC

Accepted Solutions (0)

Answers (6)

Answers (6)

[BIG PROBLEM] SAP Host Agent cannot connect to SYS...

What is the right SAP MARA field to map with CPI L...

SKU for Additional Storage

Re: IAS as proxy

Re: cloud connector