Content Store Issue after installing Oracle

[Prerna Chaudhary]

Hello,

I am getting the below error while I am trying to configure the content store for the first time after installing Oracle 11.2.0.1.0 (32 bit) on my machine:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager cannot start because the database character set for the content store is not supported. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.

Cognos version is 10.1.1 (32 bit) and OS is Windows 64 bit (2008).

I tried creating a data source connection in Cognos administration and it got successfully created.

However , The content store is not up and giving the above error.

I did troubleshoot online and came to know that the Content store database is not using the correct character set.

Is there any way to  change the character set. Or does that mean I have to again install Oracle from scratch?

Please let me know how can this be fixed.

Appreciate your help/guidance.

Regards,
Prerna

[MFGF]

Hello,

I am getting the below error while I am trying to configure the content store for the first time after installing Oracle 11.2.0.1.0 (32 bit) on my machine:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager cannot start because the database character set for the content store is not supported. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.

Cognos version is 10.1.1 (32 bit) and OS is Windows 64 bit (2008).

I tried creating a data source connection in Cognos administration and it got successfully created.

However , The content store is not up and giving the above error.

I did troubleshoot online and came to know that the Content store database is not using the correct character set.

Is there any way to  change the character set. Or does that mean I have to again install Oracle from scratch?

Please let me know how can this be fixed.

Appreciate your help/guidance.

Regards,
Prerna

Hi,

Have you copied odbc5.jar to the <cognos install location>\webapps\p2pd\WEB-INF\lib directory?

MF.

[bdbits]

It sounds like the content store database has not been populated, in which case you would not need to worry about preserving any data.

In that case, drop and recreate the content store database with the proper character set.

[Prerna Chaudhary]

Hi MFGF,

I have copied both the  ojdbc5.jar & ojdbc5_g.jar files from "\product\11.2.0\dbhome_1\jdbc\lib" into the <cognos install location>\webapps\p2pd\WEB-INF\lib.

However,I cannot find odbc5.jar ,rather its ojdbc5.jar.

Does that make any difference?

Please let me know.

Hey bdbits,

Can you please guide me onto how to go ahead with "dropping and recreating the content store database with the proper character set."

Thanks for all your valuable inputs.

Appreciate your help.

Regards,
Prerna

[Prerna Chaudhary]

Hello,

I have created a new instance of oracle using Database Configuration Assistant and changed the character set to "AL32UTF8" and confirmed by executing below command:

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';


However now when I test the content store, I am getting the below error:
Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager failed to connect to the content store. The connection string is "jdbc:oracle:thin:@192.168.64.27:1521:RICM". The error encountered is: "Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

I checked the status of the lsitener using lsnrctl start lstn  (llstn is the name of the listener) and got the below description:

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 19-NOV-2015 17:23:15

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Log messages written to f:\app\administrator\product\11.2.0\dbhome_1\log\diag\tnslsnr\SVR027\lstn\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.64.27)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
STATUS of the LISTENER
------------------------
Alias                     lstn
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date                19-NOV-2015 17:23:19
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         f:\app\administrator\product\11.2.0\dbhome_1\log\diag\tnslsnr\SVR027\lstn\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.64.27)(PORT=1521)))
The listener supports no services
The command completed successfully


Any help will be appreciated.

Regards,
Prerna

[cognoslearner1]

Hello Prerna,

Did you update tns strings in  tnsnames.ora from from oracle\network\admin ?

Thanks,
Cognoslearner

[Prerna Chaudhary]

Yes , I have updated the tnsnames.ora file and added the new details but still no luck:

RICM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.64.27)(PORT = 1521))
   )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RICM)
    )
  )

Also I checked the lsitener.ora file, it looks like this:

# listener.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LSTN =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.64.27)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = RICM)
      (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = RICM)
      (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = RICM)
    )
  )

Is there some kind of settings  which I am missing out.

Please let me know.

[cognoslearner1]

Copy only ojdbc5.jar file not the other.. please rename other jar file if its there in this location <cognos install location>\webapps\p2pd\WEB-INF\lib
have u set oracle_home,tns_admin,ld_library_path environmental variables properly ?