| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Is AlternateServers in odbc.ini stanza mandatory |
« View previous topic :: View next topic » |
| Author |
Message
|
| Frnd |
 Posted: Tue Sep 06, 2011 1:47 am Post subject: Is AlternateServers in odbc.ini stanza mandatory |
 |
|
Apprentice
Joined: 04 Jun 2007
Posts: 33
|
Hi All,
We had made the db configurations ORACLEDB n the real time message broker environment with DSN as PINKY and with SID PINKY01.Then we noticed that oracle DB is created with ServiceName - PINKY01 and not SID. Now we i think we need to change the odbc.ini stanza to be ORACLERACDB instead of ORACLEDB. I have some questions here.
1. We do not have any parameters for AlternateServers to be entered. Is this parameter mandatory in the ORACLERACDB stanza?
2. We need to get help from a different team to make the changes if any.Wanted to confirm whether I am in the right direction/any more setting has to be taken care of ? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Sep 06, 2011 5:28 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
First and most important question. Answer this before you do anything else.
Does the existing configuration *work*?
If YES, leave it alone.
If NO, then you don't need to do anything other than change the single line that specifies SID to state ServiceName instead.
Secondly, you need to make sure that it is really serVICE name and not servER name. If it's servER name, then you might need a full Oracle client install and tnsnames.ora file. |
|
| Back to top |
|
|
| Frnd |
| Posted: Wed Sep 07, 2011 12:00 am Post subject: |
|
|
Apprentice
Joined: 04 Jun 2007
Posts: 33
|
Hi Jeff,
| Quote: |
| Does the existing configuration *work*? |
I tried executing the flow without changing the SID to SERVICE NAME. I am getting the below exception:
Insert
Type:INTEGER:5
Text:CHARACTER:60
Insert
Type:INTEGER:2
Text:CHARACTER:1509
Insert
Type:INTEGER:5
Text:CHARACTER:[IBM][ODBC 20101 driver]1509
I verified the older post in this forum for this error. The answer was to set
ColumnSizeAsCharacter=1
NLS_CHARACTERSET is AL32UTF8
That is also done.
| Quote: |
| If NO, then you don't need to do anything other than change the single line that specifies SID to state ServiceName instead. |
Will try this .Need to work with a different team to change anything related to database:-(
| Quote: |
| Secondly, you need to make sure that it is really serVICE name and not servER name. If it's servER name, then you might need a full Oracle client install and tnsnames.ora file. |
Its SERVICENAME only |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
