cancel
Showing results for 
Search instead for 
Did you mean: 

Can not retrive the CMS cluster details from the CMS db in BO Ent Xi Rel 2

Former Member
0 Kudos

Dear Friends

In my setup I'm using a oracle 9.0.4 database which is install in the seperate Sun server as my CMS database. CMS server is windows 2003 server machine which use oracle client 9.0.4. In oracle database I use a seperate schema call bocms for store CMS data. From the PC by using sqlplus i can connect to the bocms schema which is in the 9i db. But the problem is at the end of the BO installation while starting the CMS server it dosen't initialles the database. I cannot figure out what is the issue for that. In the installation I selected the using exsisting database option and select oracle and then insert server as Sun server name , username as schema name and the required password only.

Please some body help me.

Regards

Aruna

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I have seen this issue occur quite often on Unix where sqlplus connects fine but XI does not when using a 64 bit Oracle client. I suppose if you happen to be running a 64 bit Windows 2003 server this could also be the root cause of your issue. Does the event viewer show any additional information on the failure. Although SP3 and higher is certified for 64 bit windows, the XI app is still 32 bit and has to use a 32 bit Oracle client.

Hope this helps,

Jack Renaud

Answers (2)

Answers (2)

denis_konovalov
Active Contributor
0 Kudos

2 things may be going wrong here.

1. You need to make sure you're using tnsnames.ora for Oracle name resolution and that you supply tnsname (oracle service name) for server name during CMS DB setup

2. Please make sure that the Oracle user you are using has following rights on the DB : Create procedure, add, create and modify tables. I usualy give that user following Roles : Resource and Connect and it's usualy enough.

Good Luck,

Denis

Former Member
0 Kudos

Aruna,

The only thing I can think of is that the username (user) that you are accessing to Oracle does not have the permissions for creating tables, and etc....

Thanks

John