Solved

otl_connect.rlogon API call hangs

Posted on 2014-04-04
7
657 Views
Last Modified: 2014-04-08
I am trying to connect to the oracle 11g database using the OTL 4.0 libraries in red hat Linux platform.

After passing the userid/passwd@db to the rlogon method,  the otl_connect.rlogon call stucks and never returns. So, the application hangs. The issue is looks like some system library related issue.

Thanks for your help,
0
Comment
Question by:LolaPet
  • 4
  • 2
7 Comments
 
LVL 86

Expert Comment

by:jkr
ID: 39978578
Are you calling 'set_connection_mode()' and 'set_program_name()' prior to 'rlogon()'? Also, what happens when you use 'set_timeout()' with an appropriate value?
0
 

Author Comment

by:LolaPet
ID: 39978726
JKR, Thanks for your help.

I am calling the below methods:

otl_connect objConn;
otl_connect::otl_initialize();
objConn.rlogon(userid/passwd@db);

In some Linux boxes, the above code hangs. But in  other system it works. So I think this issue may be due to the environmental (lib version etc) issue.

I will try your suggestions.
0
 
LVL 86

Expert Comment

by:jkr
ID: 39979143
The environment could well be an issue... so maybe the timeout can help...
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:LolaPet
ID: 39979163
Thanks jkr,

When I check the binary dependency (LDD), it looks fine. Since the binary was working in all other systems, I don't prefer to  change the existing the code.

When I use strace, the below output is keep logging.

times(NULL)                             = -838950935
times(NULL)                             = -838950935
times(NULL)                             = -838950935
times(NULL)                             = -838950935
times(NULL)                             = -838950935
times(NULL)                             = -838950935

I am wondering how can I find the root cause of this issue.
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39979210
Not familiar with the OTL 4 libraries but that error appears to be a known bug in the Oracle 10g client.

Check out:
https://community.oracle.com/message/1110985
0
 

Author Comment

by:LolaPet
ID: 39979262
Thanks slightwv.

I think your post will make sense to my problem. I can try updating my build machine with Oracle 11g client, rebuild the binaries and test it.
0
 

Author Comment

by:LolaPet
ID: 39986754
Hi slightwv,

I built my binaries using 11g libaries and it worked. Thank you very much for your solution.

Regards
LolaPet
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now