MSCS for 4.6C and Oracle10 on winx86_64

[former_member192334]

Hello guys

We have to install SAP R/3 4.6C clustered by MSCS.

Details:

SAP R/3 4.6C

SAP Kernel 4.6D EXT 32 bits

Oracle 10.2.0.2

Windows x86_64

We did preparations regarding to MSCS

We have already installed succesfully SAP R/3 4.6C in one of nodes of cluster. SAP system is ok.

Now we have doubts in phase Clustering. Documentation is confuse...

As per note 975467 - Oracle 10g Support on Windows: 4.6D-Based SAP Systems, we find:

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

o Do not use the following chapters from the installation guides for

your 4.6D-based system:

"Installing the Oracle Database Software",

"Installing the Oracle Failsafe Software",

"Converting the DB to a Fail Safe DB"

Use the respective chapters from the installation guide for SAP

Netweaver 2004s SR1 instead:

"Installing the Oracle Database Software",

"Installing the Oracle Failsafe Software",

"Additional Steps for the Oracle Fail Safe Configuration",

"Creating the Oracle Fail Safe Group",

"Setting Up a Shared Database Directory in Oracle Home",

"Adding the Oracle Database Resource to the Fail Safe Group".

********************************************************+

So ,it seems is necessary use Chapters of guide of Netweaver...

and then, in last point we find:

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

If you plan to set up a Microsoft Cluster Service (MSCS)

configuration of 4.6D on X86_64, refer to SAP Note 955785 for more

information

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

So , we read note 955785 and we find:

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

Do not use the "Start - Programs" entries to start the clustering

steps: "Configuring MSCS Node A", "Configuring MSCS Node B",

"Completing MSCS".

Use "R3Sedit.exe" instead and load the templates NTCMIGNA.R3S,

NTCMIGNB.R3S, UPDINSTV.R3S

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

So it seems clustering must be done using secuence of 4.6C guide, but some points must be replaced by tasks of Netweaver guide.

But The thing is that sequence of steps to Clustering in release 4.6C is not the same than in Netweaver....

..so all of this is confused...

Please could you tell me which steps are necessary to clustering SAP R/3 4.6C , Oracle 10, with MSCS and in which order?

Thanks and regards

Javier

[former_member433984]

that is correct:

1) you use "guide of Netweaver" to install and cluster Oracle software.

The difference to 32-bit is that you install 64-bit Oracle and OFS software, but you will install 32-bit OFS client.

2) you use notes 814834 and 955785 to install CI, load data and cluster the CI.

[former_member192334]

Ok, so... that means right order is following???

1- NTCLUST.BAT in node A ( 4.6C guide)

2- NTCLUST.BAT in node B (4.6C guide)

3- CONFIGURING NODE A FOR MSCS (4.6 C guide)

4- ADDITIONNEL STEPS FOR ORACLE FAIL SAFE CONFIGURATION (Netweaver Guide)

5.- CREATE ORACLE FAIL SAFE GROUO ( Netweaver guide)

6.- SET UP AS SHARED DATABASE DIRECTORY IN ORACLE HOME (Netweaver guide)

7.- ADD ORACLE DATABASE RESOURCE TO FAIL SAFE GROUP (Netweaver guide)

8.- CONFIGURING NODE B FOR MSCS (4.6C guide)

9.- COMPLETING CONVERSION MSCS IN NODE B ( 4.6C guide)

10-COMPLETING CONVERSION MSCS IN NODE A (4.6C guide)

Is that right???

Thanks and regards

Javier

[former_member433984]

that is correct, you simply replace Oracle related steps with NW2004 SR1/SR2 guide

[former_member192334]

Ok thanks

but I have already started.. and in step 3, I get an error because template NTMIGNA.R3S , in section

[DBORADETECT_NT_ORA]

CLASS=COraDetect

CONFIRMATION=NLS_CHARACTERSET

MSGID=RI_GIST_DBORADETECT_IND_IND

NLS_CHARACTERSET=WE8DEC

SVRMGR=@DB_HOME@\bin\svrmgr30.exe

is using SVRMGR30.exe !!! and this an old executable for Oracle 8 ...

So, that template is wrong

and, why should I use NTMIGNA.R3S instead of NTCLUSNA.R3s ???

Thanks

[former_member433984]

are you using the correct ext CD, that supports O10 (INSORA102_0-10002548.SAR from the note 976457)?

> So, that template is wrong

> and, why should I use NTMIGNA.R3S instead of

> NTCLUSNA.R3s ???

you have to use templates attached to the note 955785 - ntclust.sar

[former_member192334]

OK

I made a mistake with point 1

But regarding to point 2 ,

note 955785 say:

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

Do not use the "Start - Programs" entries to start the clustering

steps: "Configuring MSCS Node A", "Configuring MSCS Node B",

"Completing MSCS".

Use "R3Sedit.exe" instead and load the templates NTCMIGNA.R3S,

NTCMIGNB.R3S, UPDINSTV.R3S

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

So, is correct using NTCMIGNA and B?

thanks

[former_member433984]

should be correct - NTCMIGNA.R3S, NTCMIGNB.R3S, UPDINSTV.R3S

[former_member192334]

Ok thanks

Now I'm in step

7.- ADD ORACLE DATABASE RESOURCE TO FAIL SAFE GROUP (Netweaver guide)

I get following error:

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

Versions: client = 3.3.3 server = 3.3.3 OS =

Operation: Adding resource "I01.WORLD" to group "ORACLEI01"

Starting Time: Nov 29, 2007 12:00:49

Elapsed Time: 0 minutes, 15 seconds

1 12:00:49 Starting clusterwide operation

2 12:00:49 FS-10370: Adding the resource I01.WORLD to group ORACLEI01

3 12:00:49 FS-10371: ESBCNSAPF01 : Performing initialization processing

4 12:00:49 FS-10371: ESBCNSAPF02 : Performing initialization processing

5 12:00:49 FS-10372: ESBCNSAPF01 : Gathering resource owner information

6 12:00:49 FS-10372: ESBCNSAPF02 : Gathering resource owner information

7 12:00:49 FS-10373: ESBCNSAPF01 : Determining owner node of resource I01.WORLD

8 12:00:49 FS-10374: ESBCNSAPF01 : Gathering cluster information needed to perform the specified operation

9 12:00:49 FS-10374: ESBCNSAPF02 : Gathering cluster information needed to perform the specified operation

10 12:00:49 FS-10375: ESBCNSAPF01 : Analyzing cluster information needed to perform the specified operation

11 12:00:49 >>> FS-10652: ESBCNSAPF01 has Oracle Database version 10.2.0 installed in I01102

12 12:00:49 >>> FS-10652: ESBCNSAPF02 has Oracle Database version 10.2.0 installed in I01102

13 12:00:49 FS-10376: ESBCNSAPF01 : Starting configuration of resource I01.WORLD

14 12:00:49 FS-10378: ESBCNSAPF01 : Preparing for configuration of resource I01.WORLD

15 12:00:50 FS-10380: ESBCNSAPF01 : Configuring virtual server information for resource I01.WORLD

16 12:00:50 > FS-10496: Generating the Oracle Net migration plan for I01.WORLD

17 12:00:50 > FS-10490: Configuring the Oracle Net listener for I01.WORLD

18 12:00:50 >> FS-10600: Oracle Net configuration file updated: D:\ORACLE\I01\102\NETWORK\ADMIN\LISTENER.ORA

19 12:00:50 >> FS-10606: Listener configuration updated in database parameter file: D:\oracle\I01\102\database\SPFILEI01.ORA

20 12:00:51 >> FS-10603: Oracle Net listener LISTENER stopped

21 12:00:53 >> FS-10605: Oracle Net listener Fslesbcnsapf-ora created

22 12:00:53 > FS-10491: Configuring the Oracle Net service name for I01.WORLD

23 12:00:53 >> FS-10600: Oracle Net configuration file updated: D:\ORACLE\I01\102\NETWORK\ADMIN\TNSNAMES.ORA

24 12:00:53 FS-10381: ESBCNSAPF01 : Creating the resource information for resource I01.WORLD

25 12:00:53 > FS-10424: Checking whether the database I01.WORLD is online

26 12:01:02 ** ERROR : ORA-01506: missing or illegal database name

27 12:01:02 ** ERROR : FS-10778: The Oracle Database resource provider failed to configure the cluster resource I01.WORLD

28 12:01:02 ** ERROR : FS-10890: Oracle Services for MSCS failed during the add operation

29 12:01:02 ** ERROR : FS-10497: Starting clusterwide rollback of the operation

30 12:01:02 FS-10488: ESBCNSAPF01 : Starting rollback of operation

31 12:01:02 > FS-10090: Rolling back Oracle Net changes on node ESBCNSAPF01

32 12:01:04 FS-10489: ESBCNSAPF01 : Completed rollback of operation

33 12:01:04 ** ERROR : FS-10495: Clusterwide rollback of the operation has been completed

34 12:01:04 Please check your Windows Application log using the Event Viewer for any additional errors

35 12:01:04 The clusterwide operation failed !

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

What's the matter?

Thanks and regards

Javier

[former_member433984]

are you using spfile?

did you perform chapter "Additional Steps for the Oracle Fail Safe Configuration"?

[former_member192334]

OK I have already solved.

I didnt perform this chapter, because is a little confuse...

But I could solve the error, doing only step 8 of this chapter:

8. Create the init<DBSID>_OFS.ora file in the database directory, and enter the following line:

spfile = <path_to_Oracle_Home>\database\SPFILE<DBSID>.ora

Thanks a lot

[Former Member]

what's confusing in this chapter?

I would like to know it because we can change it.

peter