ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » tnsnames.ora to odbc64.in

Post new topic  Reply to topic
 tnsnames.ora to odbc64.in « View previous topic :: View next topic » 
Author Message
schmun
PostPosted: Tue Aug 04, 2009 1:34 am    Post subject: tnsnames.ora to odbc64.in Reply with quote

Novice

Joined: 03 Jul 2009
Posts: 24
Hi

For migration from broker 6.0 to 6.1 i need to adjust my odbc environment.

It looks like that i have to configure the DB-Parms for oracle in the odbc64.ini instead of the tnsnames.ora...

Now i have two problems.

This is the example in the the odbc64.ini:

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC64/V5.3/lib/UKora23.so
Description=DataDirect 5.3 64bit Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
SID=<Your Oracle SID>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1

This is my tnsnames.ora entry:

FOO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = FOO1)(PORT = 1234))
(ADDRESS = (PROTOCOL = TCP)(HOST = FOO2)(PORT = 1234))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SOME_SERVICENAME)
)
)

P1: How can I configure the loadbalaning ins the odbc64.in?
P2: How can I spcify the Servicename instead of the SID?

Thank you
Back to top
View user's profile Send private message
AkankshA
PostPosted: Tue Aug 04, 2009 1:51 am    Post subject: Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
see the stanza for RAC specified in odbc64.ini

for load balancing.. just comment the HostName & PortNumber lines

ensure that oracle_home and other oracle variables are set accordingly
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
schmun
PostPosted: Tue Aug 04, 2009 2:14 am    Post subject: Reply with quote

Novice

Joined: 03 Jul 2009
Posts: 24
Ah! Ok. ServiceName is there.

But i dont understand what will happen when i comment the two lines.

Old Way:

From
ServerName=FOO in .odbc.ini (32bit)
To
Foo-Entry in tnsnames.ora

And the new way? I miss some parameter like ServerName in the odbc64.ini. Or is ServerName=ServiceName?

Maybe you have some documentation?
Back to top
View user's profile Send private message
schmun
PostPosted: Tue Aug 04, 2009 3:15 am    Post subject: Reply with quote

Novice

Joined: 03 Jul 2009
Posts: 24
solved

wrong serach words before my first posting.

see here:
http://www.mqseries.net/phpBB2/viewtopic.php?t=49095&highlight=tnsnames+ora+odbc64
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » tnsnames.ora to odbc64.in
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.