| Author |
Message
|
| sunny_30 |
 Posted: Sun Jun 24, 2007 10:21 pm Post subject: Oracle client changed for WMB 6.0 |
 |
|
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 |
|
 |
| jefflowrey |
| Posted: Mon Jun 25, 2007 12:27 am Post subject: |
|
|
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 |
|
|
| sunny_30 |
| Posted: Mon Jun 25, 2007 4:33 am Post subject: |
|
|
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 |
|
|
| sunny_30 |
| Posted: Thu Jun 28, 2007 2:05 pm Post subject: |
|
|
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 |
|
|
| jefflowrey |
| Posted: Thu Jun 28, 2007 2:08 pm Post subject: |
|
|
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 |
|
|
| sunny_30 |
| Posted: Thu Jun 28, 2007 2:18 pm Post subject: |
|
|
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 |
|
|
| fjb_saper |
| Posted: Thu Jun 28, 2007 3:08 pm Post subject: |
|
|
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 |
|
|
|
|
