This forum is currently locked. You can't register or post questions at this time. (read more)

SPACE CONSUMPTION ON NODE 1 INCREASES BUT NOT ON NODE 2

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

1982
Senior Member
Posts: 72
Joined: Mon Apr 07, 2014 3:53 pm

Re: SPACE CONSUMPTION ON NODE 1 INCREASES BUT NOT ON NODE 2

Postby 1982 » Sat Apr 26, 2014 6:25 pm

1) Error ocurred during running root.sh on node 2

[root@ol5-112-rac2 ~]# sh /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2014-04-27 13:00:57: Parsing the host name
2014-04-27 13:00:57: Checking for super user privileges
2014-04-27 13:00:57: User has super user privileges
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node ol5-112-rac1, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
CRS-2672: Attempting to start 'ora.mdnsd' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.mdnsd' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.gipcd' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.gpnpd' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.cssdmonitor' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'ol5-112-rac2'
CRS-2672: Attempting to start 'ora.diskmon' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.diskmon' on 'ol5-112-rac2' succeeded
CRS-2676: Start of 'ora.cssd' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.ctssd' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.drivers.acfs' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.asm' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.crsd' on 'ol5-112-rac2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.evmd' on 'ol5-112-rac2' succeeded
Timed out waiting for the CRS stack to start.


After this i deconfigure and again rerun root.sh script.

[root@ol5-112-rac2 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -verbose -force

Then i got success


2) Yes
Error occurred during db creation

I think there is problem during running root.sh script on node 2. As i give full permission to oracle user over the disk

Please Tim Help me over the same. Pleas guide over the same

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: SPACE CONSUMPTION ON NODE 1 INCREASES BUT NOT ON NODE 2

Postby Tim... » Mon Apr 28, 2014 6:23 am

Hi.

1) You said it worked, which suggests that all CRS and ASM are running on both nodes.

2) The you say you think there is a problem running the root.sh on node 2...


It is either one thing or the other. It can't be successfull and have a problem... Do you understand why this is frustrating for me. Each sentence/paragraph/question contains contradictions. It is very hard to follow and makes me not want to read this stuff...

Please, please, please write clear, non-contradictory statements. This is science, not a random chat to your mates. If you can't formulate questions and conclusions properly, you are in the wrong job!

So, Please answer these questions with YES or NO.

1) Is there anything that has happened during the GI installation that leads you to believe there was a problem with it?
2) Is anything in the GI installation reporting a problem?

If the answer to both those questions are NO, then we have to assume the GI installation is fine!

I'm going to delete your other post, because it is a continuation of this and I'm not willing to run two threads on the same issue... The contents of that post were...

Using DBCA configuration of db during DB installation getting error:-


PRCR-1079: Failed start resource ora.rac.db
ORA-01092: Oracle instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occured at recursive SQL level 1
ORA-01578: ORACLE data block corrupted(file # 1, block #337)
ORA-01110: datafile 1:'+DATA/rac/datafile/system.256.845995921'
Process ID: 1250
Session ID: 1 Serial number:3

CRS-2674:Start of 'ora.rac.db' on 'ol5-112-rac2' failed
CRS-2632:There are no more servers to place resource 'ora.rac.db' on that would satisfy its placement policy


The error message "ORA-01578: ORACLE data block corrupted(file # 1, block #337)" says it all. There is a file corruption. This means one of two things:

1) The original file it is copied from in the installation is corrupt.
2) In copying it to ASM is is being corrupted.

To test this, create a new database using the custom option and pick one of the options without a template, so it doesn't copy the seed datafiles, but instead builds the database from scratch...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

1982
Senior Member
Posts: 72
Joined: Mon Apr 07, 2014 3:53 pm

Re: SPACE CONSUMPTION ON NODE 1 INCREASES BUT NOT ON NODE 2

Postby 1982 » Mon Apr 28, 2014 7:59 am

Sorry tim,

I didn't want to make you frustrated. I want your help to sort out the problem. As i told you previously i am getting error during GI installation while running root.sh script on node 2. That error says

CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node 11gdb, number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
CRS-2672: Attempting to start 'ora.mdnsd' on 'node2'
CRS-2676: Start of 'ora.mdnsd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'node2'
CRS-2676: Start of 'ora.gipcd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node2'
CRS-2676: Start of 'ora.gpnpd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node2'
CRS-2676: Start of 'ora.cssdmonitor' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node2'
CRS-2672: Attempting to start 'ora.diskmon' on 'node2'
CRS-2676: Start of 'ora.diskmon' on 'node2' succeeded
CRS-2676: Start of 'ora.cssd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'node2'
CRS-2676: Start of 'ora.ctssd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'node2'
CRS-2676: Start of 'ora.drivers.acfs' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node2'
CRS-2676: Start of 'ora.asm' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node2'
CRS-2676: Start of 'ora.crsd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'node2'
CRS-2676: Start of 'ora.evmd' on 'node2' succeeded
Timed out waiting for the CRS stack to start.

This is the only error i am getting during GI installation. After which i deconfigure crs on node 2 and rerun the root.sh script and then in works fine.


This is the only error in addition to the error you mentioned in your blog.


Again i am very sorry if i am unable to make you understand. But you are currently my hope to learn these stuff. So sorry once again.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: SPACE CONSUMPTION ON NODE 1 INCREASES BUT NOT ON NODE 2

Postby Tim... » Mon Apr 28, 2014 8:22 am

Hi.

So are far as you're concerned the GI is all running fine now...

So the only outstanding issue is with the DBCA, which I've given you feedback on...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

1982
Senior Member
Posts: 72
Joined: Mon Apr 07, 2014 3:53 pm

Re: SPACE CONSUMPTION ON NODE 1 INCREASES BUT NOT ON NODE 2

Postby 1982 » Mon Apr 28, 2014 8:37 am

yes.

But can you guide me why i am getting

Timed out waiting for the CRS stack to start.

During running root.sh script on node 2 and this will impact db creation

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: SPACE CONSUMPTION ON NODE 1 INCREASES BUT NOT ON NODE 2

Postby Tim... » Mon Apr 28, 2014 9:17 am

Hi.

It's a timeout... It has timed out... The fact it subsequently starts means it is OK... If this were a real system I would be concerned. Since it is an installation on some VMs on a PC, then it's hardly surrprising things like this happen from time to time. If you want it to run smoothly, do the installation on real servers or a big PC. I do this stuff on a dual xeon server at home with loads of memory. I use 4G+ per VM. If you are not doing that, you have to expect issues from time to time...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle RAC and Clusterware”

Who is online

Users browsing this forum: No registered users and 2 guests