11g: Connection pool is not available in initialization block




Today i had issue that: Connection Pools are not being shown in browse list of initialization block.


I’ve imported some sources to rpd and trying to create session initialization block which will use the new imported schema to query. Unfortunately i’m unable to see the connection pool list that these new imported db is holding.


But it’s visible in Repository initialization block.


Anyways, this is happening because, by default the first connection pool specific to each db will not be shown in browse list.


Here is note from help document:

By default, the first connection pool under the database object in the Physical layer is not available for selection. This behavior ensures that you cannot use the same connection pool for initialization blocks that you use for queries.

So make sure that every time you import new connection, you’ve duplicated connection pool dedicated to use in initialization block.



Kishore Guggilla


About Kishore & Naresh

Hi.. This is a blog operated by Kishore and Naresh. We are colleagues and working as BI Developers. Here we want to share our ideas and researches here. We were the active members of OTN Forums and inspired with Venkat and John's blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks

3 responses »

  1. Good stuff!
    One way around this requirement is to switch off the option in Tools -> Options “Allow First Connection Pool for Init blocks”..
    Ofcourse, use at your own peril!

    Ram Chaitanya

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s