Oracle Database Sharding Implementation

[JITENDRA PANIGRAHY, modificado 12 Anos atrás.]

Hi,

Am using Liferay CE 6.1 and JBoss 7 along with Oracle 10g database.
I need to implement database sharding. Please help with the steps.
Many Thanks in advance.
Jitendra Panigrahy
email: [e-mail]

[Hitoshi Ozawa, modificado 12 Anos atrás.]

Follow the steps in the following wiki page:

http://www.liferay.com/community/wiki/-/wiki/Main/Database+Sharding

[JITENDRA PANIGRAHY, modificado 12 Anos atrás.]

Thanks Hitoshi for the information.

[JITENDRA PANIGRAHY, modificado 12 Anos atrás.]

Hi Hitoshi,

I followed the steps in your link provided.
I ran the create-sharded-oracle.sql script in oracle XE, that created three users with data populated.
And along with that I added required entries in portal-ext.properties file (attached here with)
After run the JBoss, face error like "Listener Refused Connection.....". though database is up and running and users are connected.
FYI, it is working fine for MySql database.
Would appreciate for any help.
Many Thanks

[Hitoshi Ozawa, modificado 12 Anos atrás.]

Is work Liferay working with Oracle XE when you are not sharding?

[JITENDRA PANIGRAHY, modificado 12 Anos atrás.]

Yes, sometimes.
I could not able to find the reason. I replaced XE with Oracle 10g standard edition. It worked well.

[JITENDRA PANIGRAHY, modificado 12 Anos atrás.]

Hi, Just FYI, now its working fine

[Hitoshi Ozawa, modificado 12 Anos atrás.]

Great! Can you share with us what the problem was in case somebody else has a similar problem.

[JITENDRA PANIGRAHY, modificado 12 Anos atrás.]

Just to add more, I could not able to track the problem.with Oracle XE. Even sometimes it was not working without Sharding also.
I observed that, after start JBoss server, I was able to connect to XE server through Oracle client.
Might be, Oracle XE was not installed properly or may be something else!!! As a resolution I replaced XE with Oracle 10g and that works well.

[Hitoshi Ozawa, modificado 12 Anos atrás.]

May be it was a default limitation on number of available connections.

[JITENDRA PANIGRAHY, modificado 12 Anos atrás.]

You seem correct. After having enabled sharding, JBoss server does not allow more than one user to access same database.
Say, user1 has enabled sharding and currently access the DB server1, same time it does not allow user2 to acceess same DB server1 and that ends up with error "Listener Refused Connection....."

FYI, we need to have a multitenant architecture in order to build a multi tenant SaaS product using Liferay
Our data requirement is, multiple portal instances would have access to same database and one instance to multiple database as well.
Could it be achieved only with Sharding implementaion or any thing additional to implement. Please give some pointers.