Problem configuring Sun ASP with oracle client
My configuration is:
The Sun ONE Active Server Pages ASP Version 4.0 (Chilli!Soft) on Solaris 9.
Oracle DB is 9i (9.2.0.2) on different server also running Solaris 9.
I configure DSN with oracle client and when I test this DSN I get error
揑M003 -- Specified driver could not be loaded?br>Same DNS settings (oracle with client) work fine from MS Windows
Testing DSN without oracle client is successful!! But oracle stored procedure is not working
Please give me some hints how to troubleshoot or what can be possible wrong with setup.
Please you can also copy message to angelinap@gmail.com
Regards,
Angelina
# 1
Is it possible to buy support for Active Server Pages?We desparetly need to solve oracle conection problem.Regards,Angelina
# 2
Are you using SunOne ASP 4.0 or 4.0.2?Duncan
# 3
PS. Information about support options is here http://developers.sun.com/asp/support/supportrequest.jsp
# 4
Do a search on oracle client in the forum there are quite a lot of relevant postings. This one in particular seems relevant. http://developers.sun.com/asp/kb/kb_display_200201031.html
# 5
Hi,
We are using SunOne ASP 4.0.
Also I noticed the driver in this release is for oracle 8 and we are having oracle 9i or the same driver can be used?!
What are enhancements in 4.0.2?
I have only production env without test environment so
I am afraid to do upgrade on production without testing.
Regards,
Angelina
# 6
Hi Duncam,
I believe I read about 10 Gb manuals and examples about this issue.
TNSNAMES.ora is correct
On client side I export ORACLE_HOME, ORACLE_SID ....
Also I did ldd on the odbc driver from /opt/casp/...YYxx.so (I do not remember correct path now) and I found out that actualy some essential system's libraries can not be found :(
First time when I ran ldd on the odbc driver even coudn not found main oracle library (libclntsh.so) - so I copied it on /opt/casp/....../lib directory but still can not find other library .....
I really do not know how to make these depending library available to odbc driver.
Our ASP runs as root :( so I added in root .profile LD_LIBRARY_PATH=/home/u01/app/oracle/product/8.1.7/lib; export LD_LIBRARY_PATH and restart the ASP server but still same result
I believe I am making mistake restarting ASP from console (when it does not pick up new environment variables.
I like when server runs under own username but this istalation like apache is initialy was installed under root :(
What would be impact if I change user name for ASP say I create casp, group casp?
My company is willing to pay for support/troubleshooting this problem so please free to contact me.
Regards,
Angelina
# 7
Would not use 4.0 for a production environment it had quite a lot of bugs.I would not upgrade without testing so it sounds like you need to set up a test environment.Duncan
# 8
Just checked the help for 4.0.2 and 9i is supported, don't know about 4.0
Check in your casp docs.
http://192.168.2.8:5100/caspdoc/ (replacing 192.168.2.8 with your asp servers ip address) and click on 'Supported in This Release'.
This lists what is supported including database versions.
Duncan
# 9
I will have a look when we returned back to office .... 2nd January.
Once more .... how much is advisible to install SunOne ASP under different username then root?
And,
When you restart ASP from the console (port 5100) does it read root .profile again or I have to stop ASP, export root environmet variables and from that window start ASP again?
Thank you very much.
Angelina
# 10
I've never run ASP as anything other than root, I can only suggest you read the documentation for 4.0.2 or search the forum to see if this is possible.
I've no idea whether it reads root.profile either.
As for oracle environment variables it appears these can be put elsewhere so that asp correct picks them up, do a search for 'oracle client' in the forum as there are quite a lot of postings on getting Oracle working.
Again it may be worth consulting the 4.0.2 docs. I know there are two options for using Oracle, one with the client and one without but not sure what the difference is as Its a long time since I've used Oracle.
I use MySQL these days.
Duncan
