Hi All,
I've tried creating 2 different databases along with dbcontrol, but both of them failed to configure dbcontrol. During the configuration, screen pops up with error "ORA-01012 not logged on".
Environment details:
OEL 5.5 x86-64
Hostname:
rac1.oel5-11204.tap rac1
rac2.oel5-11204.tap rac2
Multi user : Grid / Oracle
2-node Oracle RAC 11.2.0.4
ASMlib:
rpm -qa | grep oracleasm*
oracleasm-2.6.18-194.el5-2.0.5-1.el5
oracleasmlib-2.0.4-1.el5
oracleasm-support-2.1.3-1.el5
[root@rac1 disks]# uname -a
Linux rac1.oel5-11204.tap 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
As per metalink Certification:
https://support.oracle.com/epmos/faces/CertifyDrillDownNDetails?searchCtx=st%255EANY%257Cpa%255Epi%255E563_Oracle%2BReal…
Keen Observation is needed for the following outputs:
[oracle@rac1 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 5 00:13:10 2015
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, OLAP,
Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
=======================================================================
[oracle@rac1 ~]$ sqlplus sys/Oracle123@BORCL as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 5 00:13:34 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected.
SQL>
========================================================================
In addition to this i can't configure dbcontrol for either of the database.
[oracle@rac1 ~]$ emca -config dbcontrol db -repos create -cluster
STARTED EMCA at Mar 4, 2015 5:16:21 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database unique name: aorcl
Service name: aorcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Password for SYS user:
Mar 4, 2015 5:16:42 PM oracle.sysman.emcp.DatabaseChecks checkDataGuardEnabled
WARNING: ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATADG/aorcl/controlfile/current.260.873477931'
ORA-15081: failed to submit an I/O operation to a disk
Any help is appreciable.
Regards
Samad Ul Haq