[SOLVED]Connecting content store

[monica]

Hello All,

I am having an issue with connecting to content store. I have done a new cognos 10.1.1 64 bit install on linux 64 bit env.
I have both 32 & 64 bit oracle client installed on the server. Environment variables TNS_ADMIN and ORACLE_HOME point to both 32 & bit client. I have tns entry made in tns.ora files. I am able to connect to content store db with sql plus but not able to connect from cognos configuration. I have copied ojdbc6.jar file from oracle32bit/lib to c10/webapps/p2pd/WEB-INF/LIB

Error recieved is : Content manager failed to connect to content store.The connect string is "jdbc:oracle:thin:@hostname:servicename"
The error encountered is :"Listener  refused the connection with following error : ORA-12505,TNS:Listener does not know SID given in the connector

Please help me on the above issue.

Thanks ,
Monica

[sdf]

ahmm..

You can try to export the SID path to your environment. (export ORACLE_SID = SID).
Also, try to import the  ojdbc5.jar instead of  ojdbc6.jar.

[monica]

Hi ,

I am getting this error now
Content Manager is unable to initialize the content store by using the initialisation file "C10\configuration\schemas\content\oracle\dbInitTest_oracle.sql".

However I am successfully able to connect to audit store.

[sdf]

I found this similar thread.




http://www.cognoise.com/index.php?topic=11304.0

[monica]

Finally issue resolved. It was due to problem in permissions and the less table space. When appropriate permissions were given to service account then issue was solved. Thank you Feds for your reply.

[sdf]

good to hear that.

You can mark this thread [solved] for future reference.