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 » Oracle client changed for WMB 6.0

Post new topic  Reply to topic
 Oracle client changed for WMB 6.0 « View previous topic :: View next topic » 
Author Message
sunny_30
PostPosted: Sun Jun 24, 2007 10:21 pm    Post subject: Oracle client changed for WMB 6.0 Reply with quote

Master

Joined: 03 Oct 2005
Posts: 258

Hi,

The WMB 6.0 Broker(on AIX) uses the Oracle-DB(10g).
Now, we have the Oracle-client 9.2.0.1 (on the Broker box) connecting to the Remote Oracle-DB(10g). Everything is working fine.

We are planning to install the Oracle-10g client on the Broker-box.

I wanted to confirm what steps are needed to be followed later:--
Change the $ORACLE_HOME to point to the new location. Is this step alone going to be fine OR Do I also need to run the mqsi_setupdatabase?
i.e mqsi_setupdatabase oracle10 $ORACLE_HOME

Thanks in advance.
-Sunny
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Mon Jun 25, 2007 12:27 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You should plan on having to do everything that you did to get the Oracle 9 client set up and working with broker, all over again.

You might not have to, but you should plan for it.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
sunny_30
PostPosted: Mon Jun 25, 2007 4:33 am    Post subject: Reply with quote

Master

Joined: 03 Oct 2005
Posts: 258

Thanks for the Reply.

Does it mean that I shd also plan to take the back-up of the Broker domain, so as to restore components if things are not working later, apart from planning to do mqsi_setupdatabase(if needed only, as you implied).

The Oracle client is being upgraded from 9.2 to 10.2. The Remote Oracle server remains the same. This is going to happen on the PRD box where everything is currently up & running.

Can somebody please list the tasks to do later (for my scenario)?
Back to top
View user's profile Send private message
sunny_30
PostPosted: Thu Jun 28, 2007 2:05 pm    Post subject: Reply with quote

Master

Joined: 03 Oct 2005
Posts: 258

To follow up with the discussion we had earlier, I tried doing the discussed steps after the Oracle-client upgrade from 9.2 to 10. Im having problem getting the Broker up. The DB-server is the same i.e Oracle-10g.
Everything was working fine earlier with client 9.2

Error in detail:
Environment:
Quote:
WMB 6.0.0.3
MQ 6.0.2.0
AIX
DataBase-Server: Oracle 10g
Client upgraded from 9.2.0.5 to 10.2.0.1


These are the steps I have done:
Quote:
1) Pointed the $ORACLE_HOME to new client install.
2) Get the QM & Broker down.
3) Run the mqsi_setupdatabase oracle10 $ORACLE_HOME


The Broker DSN remains the same.
This is the driver entry I have in the odbc.ini:
Quote:
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so


This is what Im getting in the syslog:
Quote:

Database error: SQL State '08001'; Native Error Code '12505';
Error Text '[DataDirect][ODBC Oracle driver][Oracle]ORA-12505: TNS:listener does not currently know of SID given in connect descriptor '. :
: The broker made an unsuccessful attempt to access its database wmbdev with userid wbimb. :


I took the ODBC-trace. It says the same as syslog:
Quote:
"[DataDirect][ODBC Oracle driver][Oracle]ORA-12505: TNS:listener does not currently know of SID given in connect descriptor"


Please help on how to proceed to fix this...

Thanks,
Sunny
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Jun 28, 2007 2:08 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Did you copy tnsnames.ora from the Oracle 9i install to the Oracle 10i install?

Did you verify that you didn't need to change the .odbc.ini (and the .odbc64.ini) files?

Did you verify that you can connect to the new 10i database using the broker username and password with the 10i version of SQLPlus?
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
sunny_30
PostPosted: Thu Jun 28, 2007 2:18 pm    Post subject: Reply with quote

Master

Joined: 03 Oct 2005
Posts: 258

Thanks for the Instant Reply!!

Yes. The tnsnames.ora file is copied.
The following were successful:
Quote:
tnsping SID
tnsping connect-string
sqlplus user-name/psswd@connect-string


It looks like the ODBC connection is failing from the Broker. Im trying to find a way to test the ODBC-connection on the Unix.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Jun 28, 2007 3:08 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Did you check whether the broker user had admin priviledges on it's DB in 10g, like it used to have in 9i ?
Quote:
"[DataDirect][ODBC Oracle driver][Oracle]ORA-12505: TNS:listener does not currently know of SID given in connect descriptor"

The error would suggest some problem with the SID. Check whether the SID in tnsnames uses the same case as the SID used in odbc... While you're at it check the user setup in Oracle. Have them check for SYNONYM setup as well.
Depending on the user setup you are not allowed to specify the schema or you have to specify the schema.

Enjoy
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle client changed for WMB 6.0
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.