Re: 2nd Listener
From: joel garry <joel-garry_at_home.com>
Date: Mon, 29 Mar 2010 13:14:45 -0700 (PDT)
Message-ID: <b579b5aa-ab6d-41bd-a9f9-fbe525da1bc2_at_c2g2000pre.googlegroups.com>
On Mar 29, 8:40 am, Bill <billshatne..._at_googlemail.com> wrote:
> We have internal users connecting via Forms and external users
> connecting via Oracle Apps Server 10.1.
>
> Currently, there's one listener for everything.
>
> Would there be any merit in creating a second listener for just the
> external users?
>
> The connection pooling is done via application server, so I see no
> point in creating a shared server arrangement.
>
> This kind of follows on from my question about DBMS_LDAP but is
> separate enough to warrant a new thread.
>
> I'd like to keep a large amount of Oracle processes open in the
> database for the large influx of online users we're expecting so if
> anyone knows a good way on the apps server for me to do that I'd be
> most grateful. I know there are a few parameters like MaxClients but
> it would be nice to hit the right ones as the time we have for testing
> isn't that much.
>
> Thanks.
Date: Mon, 29 Mar 2010 13:14:45 -0700 (PDT)
Message-ID: <b579b5aa-ab6d-41bd-a9f9-fbe525da1bc2_at_c2g2000pre.googlegroups.com>
On Mar 29, 8:40 am, Bill <billshatne..._at_googlemail.com> wrote:
> We have internal users connecting via Forms and external users
> connecting via Oracle Apps Server 10.1.
>
> Currently, there's one listener for everything.
>
> Would there be any merit in creating a second listener for just the
> external users?
>
> The connection pooling is done via application server, so I see no
> point in creating a shared server arrangement.
>
> This kind of follows on from my question about DBMS_LDAP but is
> separate enough to warrant a new thread.
>
> I'd like to keep a large amount of Oracle processes open in the
> database for the large influx of online users we're expecting so if
> anyone knows a good way on the apps server for me to do that I'd be
> most grateful. I know there are a few parameters like MaxClients but
> it would be nice to hit the right ones as the time we have for testing
> isn't that much.
>
> Thanks.
In addition to what the others said, google about on the phrase "oracle hardening" for your db version. There are some listener issues in those white papers that may not be obvious, not to mention sqlnet (including expire_time and how it deals with pooling and firewalling).
jg
-- _at_home.com is bogus. I don't want creative. I want support. http://blogs.adobe.com/jd/2010/03/_the_fundamental_things_apply.htmlReceived on Mon Mar 29 2010 - 15:14:45 CDT