Hi:
I have 2 questions. The first is referred to multithread. I have two machines, one has server and client Oracle. the other only the client. In the first machine I used cdemocp.c like the base to my program and when this call to the function OCIConnectionPoolCreate this create 10 subprocess because the minimum connections is set in 10. An important point is that the function OCIConnectionPoolCreate as parameter database is "". Then I took the same program in the second machine, but it is rejected with ORA-12545. So I modify the variable database and the program works, but does not create the 10 processes.
So I made this change (modify the database variable) in the program on the first machine and the 10 processes are not created.
What happened? What is missing in the second machine to get the Ora error?.
The second question is about the function OCILogon2. In the first machine, the first invocation into the threadFunction take a lot of time in response. The next invocations are very quickly.
I hope you can give one hand about this.
Anonymous
Ufff, has been passed to many weeks since I posted and I can't find an answer about it. Come on pals, please give me a hand.
Thanks
1 / on the 2nd host, the client is not able to resolve the database parameter.
2 => Are you using 11g client with DNS resolution ?
I don't see any link between OCILIB and your initial post....
Hi, thanks for your help. First at all, I make a mistake confusing the OCI APIs with OCILIB APIs. I'm sorry for this mistake.
About the first answer, okay, the client is not able to resolve but do you have any idea about the why i can't see the 10 processes created (ps -fea).
To the second question, I'm using 11g client without DNS resolution.
Thank you very much again.