| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PMON seems to not close sessions in a timely manner eg "Max
Do you know if the connections (sessions) created for the web app are shared
or dedicated?
If it's dedicated, did you try to connect using sqlplus from that win2k
server and other hosts?
Trying to isolate the problem?
Regards,
Waleed
-----Original Message-----
Sent: Thursday, December 26, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
> Does your app connect to the database using the listener or
> directly (BEQ) without specifying a connect string?
>
> It should connect using the listener and a connect string.
>
> Regards,
>
> Waleed
>
Waleed
Yes, it's a web application and uses a listener. The listener entry has not been modified. There was a vague reference in the MTS docs that eluded to using a special connection string. But I got the impression that you would use a special connection string *if* you wanted the abillity to chooose between direct connection or mts (shared).
In my case Id simply like to have all connections to use MTS.
Should I be using a special connection string or listener entry? If so where can I find some examples
Here is my asp application connection string (using the Oracle OLEDB
provider wich is current)
Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=z;Persist Security
Info=True;User ID=me;Data Source=mydb
Here is my traditional sql+ connection
username/password_at_instance
So, Im wondering what type of "special" connection string I'd need for mts (if that's the case)
Listener entry
(SID_DESC =
(GLOBAL_DBNAME =mydb)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = mydb)
This is on win2k server, Oracle 8.1.7
Thanks!
bob
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: bmetelsky_at_cps92.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: Waleed.Khedr_at_FMR.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Dec 26 2002 - 10:24:25 CST
 |
 |