Metadata Repository on Oracle RAC
Moderators: chulett, rschirm, roy
Metadata Repository on Oracle RAC
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?
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?
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For example, your tnsnames.ora entry might look like
While you are installing InfoSphere Information Server, it should look like this (for example).
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.)
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)
)
)
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)
)
)
(Names of hosts, etc., have been invented.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.