Metadata Repository on Oracle RAC

U · Post by U » Thu Nov 06, 2014 5:48 pm

Can anyone provide a link to documentation about how to install the repository tier for Information Server version 11.3.1 on an Oracle RAC ?

All the IBM Knowledge Center links direct you to 11.3.0 documentation, in which the only option is DB2.

Is this some nefarious IBM marketing ploy?

stuartjvnorton · Post by **stuartjvnorton** » Thu Nov 06, 2014 6:08 pm

Have you tried the Planning, Installation and Configuration Guide?
Look to the 11.3.1 doco specifically. 11.3.0 only supported DB2 and 11.3.1 added the other DBs.

IIRC, in previous versions you have to install to a single node in the RAC and then update the configuration afterwards to point to the RAC as a whole.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 06, 2014 6:27 pm

The Knowledge Center has been updated to include this information, even though it still shows as 11.3.0 documentation (since there is no separate 11.3.1 version of the Knowledge Center).

Try these links:
http://www-01.ibm.com/support/knowledge ... ml?lang=en
http://www-01.ibm.com/support/knowledge ... ml?lang=en

Special thanks to Beate Porst (IBM product manager for DataStage) for this advice.

U · Post by U » Thu Nov 06, 2014 7:07 pm

That was awesomely fast!

Many thanks, as always.

U · Post by U » Sun Nov 30, 2014 5:47 pm

Re-opened this topic. We're getting really close to installing now.

Our DBAs have set up the Oracle RAC, and the entry in tnsnames.ora has four nodes mentioned.

The Planning, Installation and Configuration Guide for Information Server isn't very helpful at this point. All it says is "To install InfoSphere Information Server in an Oracle RAC configuration, install to a single node in the configuration. Then perform additional steps to cause InfoSphere Information Server to operate with the complete Oracle RAC configuration."

Do we have to reduce tnsnames.ora to containing only one node, and reinstate it later? If not, how do we "install to a single node"?

Relying on your experiences.

Thank you for your time.

U · Post by U » Tue Dec 02, 2014 3:58 pm

Is anyone able to answer this question?

I guess we'll have to involve official support.

stuartjvnorton · Post by **stuartjvnorton** » Tue Dec 02, 2014 4:45 pm

When it asks for the xmeta DB details, give it the name of a single node in the RAC. Your DBA can help you out there.

The steps for pointing it back to the RAC are in the guide.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 02, 2014 7:50 pm

Basically you need to have the tnsnames.ora entry changed so that there is only one ADDRESS component in the ADDRESS_LIST.

Most DBAs put each ADDRESS component on a separate line, so it should be a simple matter of commenting out all but one.

Once the installation is complete, you can reinstate them.

Of course, it may be the case that you need to get write permission to tnsnames.ora to be able to make this change, or have the Oracle DBA look after it for you.

If they question the requirement for a single node, point them at the IBM Knowledge Center, specifically
http://www-01.ibm.com/support/knowledge ... tedbs.html

ray.wurlod · Post by **ray.wurlod** » Tue Dec 02, 2014 8:25 pm

For example, your tnsnames.ora entry might look like

Code: Select all

TRADES_APP.WORLD =
  (DESCRIPTION =
    (ENABLE_BROKEN = TRUE)(CONNECT_TIMEOUT = 3)(TRANSPORT_CONNECT_TIMEOUT = 2)(RETRY_COUNT = 3)
    (ADDRESS_LIST =
      (LOAD_BALANCE = ON)(FAILOVER = ON)
     (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing120-scan.trades)(PORT = 1521))
     (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing130-scan.trades)(PORT = 1521))
     (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing121-scan.trades)(PORT = 1521))
     (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing131-scan.trades)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TRADES_APP)
    )
  )

While you are installing InfoSphere Information Server, it should look like this (for example).

Code: Select all

TRADES_APP.WORLD =
  (DESCRIPTION =
    (ENABLE_BROKEN = TRUE)(CONNECT_TIMEOUT = 3)(TRANSPORT_CONNECT_TIMEOUT = 2)(RETRY_COUNT = 3)
    (ADDRESS_LIST =
      (LOAD_BALANCE = ON)(FAILOVER = ON)
#    (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing120-scan.trades)(PORT = 1521))
     (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing130-scan.trades)(PORT = 1521))
#    (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing121-scan.trades)(PORT = 1521))
#    (ADDRESS = (PROTOCOL = TCP)(HOST = itgsing131-scan.trades)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TRADES_APP)
    )
  )

If you are using a local, rather than global, tnsnames.ora file, you may also need to get rid of the ".WORLD".

(Names of hosts, etc., have been invented.)

U · Post by U » Tue Dec 02, 2014 10:12 pm

That's really excellent! Many thanks.