How does mod_plsql determine what SID to use?

Posted on 2006-07-19
Medium Priority
Last Modified: 2010-03-04
Configuration file?  Environment variable?  Where?
Question by:Mr_Snrub
LVL 24

Accepted Solution

slyong earned 1500 total points
ID: 17143322

If I remember correctly, it was taking from the Environment variable ORACLE_SID.

Author Comment

ID: 17143495
Thanks... that's not actually it (it is correct for sqlplus though).  For Oracle 8 I had to add a data access descriptor through the web configuration interface (found via http://www.orafaq.com/faqmodpl.htm).  For Oracle 9 or higher it's through dads.conf I think.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you are running a LAMP infrastructure, this little code snippet is very helpful if you are serving lots of HTML, JavaScript and CSS-related information. The mod_deflate module, which is part of the Apache 2.2 application, provides the DEFLATE…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Suggested Courses

597 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