| Author |
Message |
 Topic: Cannot run sqlplus from my trigger program |
crazyleya
Replies: 12
Views: 8147
|
 Forum: IBM MQ Java / JMS Posted: Thu Jun 01, 2006 4:57 pm Subject: Cannot run sqlplus from my trigger program |
It was not able to find the oracle libraries because the script was being triggered as the user mqm. Here's what I got from IBM.
When effective and real uids differ,
LD_LIBRARY_PATH is ignore ... |
| Topic: Cannot run sqlplus from my trigger program |
crazyleya
Replies: 12
Views: 8147
|
Forum: IBM MQ Java / JMS Posted: Wed May 24, 2006 9:40 am Subject: Cannot run sqlplus from my trigger program |
| It's solaris 5.9. I'm starting the trigger manually. |
| Topic: Cannot run sqlplus from my trigger program |
crazyleya
Replies: 12
Views: 8147
|
Forum: IBM MQ Java / JMS Posted: Wed May 24, 2006 3:12 am Subject: Cannot run sqlplus from my trigger program |
| I tried using two scripts as mentioned in the ppt. It didn't help |
| Topic: Cannot run sqlplus from my trigger program |
crazyleya
Replies: 12
Views: 8147
|
Forum: IBM MQ Java / JMS Posted: Tue May 23, 2006 7:17 pm Subject: Cannot run sqlplus from my trigger program |
| It is a user called app_admin. Not mqm |
| Topic: Cannot run sqlplus from my trigger program |
crazyleya
Replies: 12
Views: 8147
|
Forum: IBM MQ Java / JMS Posted: Tue May 23, 2006 5:33 pm Subject: Cannot run sqlplus from my trigger program |
| If LD_LIBRARY_PATH is indeed the problem how will I work around the problem. I need /apps/oracle/9.2.0.4/lib in LD_LIBRARY_PATH for sqlplus to run. |
| Topic: Cannot run sqlplus from my trigger program |
crazyleya
Replies: 12
Views: 8147
|
Forum: IBM MQ Java / JMS Posted: Tue May 23, 2006 5:30 pm Subject: Cannot run sqlplus from my trigger program |
| I put an env inside the script. I guess the LD_LIBRARY_PATH is being used. I have a java program being called inside the script. If I remove the /opt/mqm/lib from the LD_LIBRARY_PATH, the java program ... |
| Topic: Cannot run sqlplus from my trigger program |
crazyleya
Replies: 12
Views: 8147
|
Forum: IBM MQ Java / JMS Posted: Tue May 23, 2006 12:01 pm Subject: Cannot run sqlplus from my trigger program |
I have MQ 5.3.
I have a script that is triggered on arrival of a message. I am trying to run sqlplus in the script. I get this error "ld.so.1: sqlplus: fatal: libclntsh.so.9.0: open failed: No such f ... |
| Topic: MQ Java Triggered server example |
crazyleya
Replies: 11
Views: 12851
|
Forum: General Discussion Posted: Thu May 04, 2006 2:54 pm Subject: MQ Java Triggered server example |
| Thanks a lot guys. The ppt was very informative. I assigned "$@" to a variable and passed it to a function which had the java call. Works well. |
| Topic: MQ Java Triggered server example |
crazyleya
Replies: 11
Views: 12851
|
Forum: General Discussion Posted: Wed May 03, 2006 3:18 pm Subject: MQ Java Triggered server example |
| I tried the java trigger example and it works well when I have java -cp.... JavaTrigger on the applicid on the process. I am trying to call a shell script on the applicid and I get the following error ... |
