I have completed an upgrade to CA 11.1.7 FP1 from CA 11.0.13.

Upon trying to connect to the Content Store I am getting the following message:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

My Content Store is on Oracle and the connection defined as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=server.xxx.yyyy.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=database.oracle.yyyy.com)))
Whilst certain entities have been obfuscated, this same connection worked previous to the upgrade.

We use SSL and SSO.
Other than running an over-the-top install, I have made no other changes to the configuration.

Note: I am also getting an [Check NIST 131A conformance warning] while starting Cognos services message, but as this is only a warning I want to resolve the database connection issues first.

Thanks in advance.

I have completed an upgrade to CA 11.1.7 FP1 from CA 11.0.13.

Upon trying to connect to the Content Store I am getting the following message:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

My Content Store is on Oracle and the connection defined as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=server.xxx.yyyy.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=database.oracle.yyyy.com)))
Whilst certain entities have been obfuscated, this same connection worked previous to the upgrade.

We use SSL and SSO.
Other than running an over-the-top install, I have made no other changes to the configuration.

Note: I am also getting an [Check NIST 131A conformance warning] while starting Cognos services message, but as this is only a warning I want to resolve the database connection issues first.

Thanks in advance.

I have completed an upgrade to CA 11.1.7 FP1 from CA 11.0.13.

Upon trying to connect to the Content Store I am getting the following message:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

My Content Store is on Oracle and the connection defined as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=server.xxx.yyyy.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=database.oracle.yyyy.com)))
Whilst certain entities have been obfuscated, this same connection worked previous to the upgrade.

We use SSL and SSO.
Other than running an over-the-top install, I have made no other changes to the configuration.

Note: I am also getting an [Check NIST 131A conformance warning] while starting Cognos services message, but as this is only a warning I want to resolve the database connection issues first.

Thanks in advance.

Hi Adam,

depending what your configuration is.

Did you install Cognos 11.1 R7 on 11.0 R13 ?

Did you check network port is correctly open between Oracle and Cognos ?

Did you install Oracle client on Cognos computer ?

Did you put the driver in the correct folder ?

Did you double check login/password

etc...

regards,

I have completed an upgrade to CA 11.1.7 FP1 from CA 11.0.13.

Upon trying to connect to the Content Store I am getting the following message:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

My Content Store is on Oracle and the connection defined as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=server.xxx.yyyy.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=database.oracle.yyyy.com)))
Whilst certain entities have been obfuscated, this same connection worked previous to the upgrade.

We use SSL and SSO.
Other than running an over-the-top install, I have made no other changes to the configuration.

Note: I am also getting an [Check NIST 131A conformance warning] while starting Cognos services message, but as this is only a warning I want to resolve the database connection issues first.

Thanks in advance.

I have completed an upgrade to CA 11.1.7 FP1 from CA 11.0.13.

Upon trying to connect to the Content Store I am getting the following message:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

My Content Store is on Oracle and the connection defined as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=server.xxx.yyyy.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=database.oracle.yyyy.com)))
Whilst certain entities have been obfuscated, this same connection worked previous to the upgrade.

We use SSL and SSO.
Other than running an over-the-top install, I have made no other changes to the configuration.

Note: I am also getting an [Check NIST 131A conformance warning] while starting Cognos services message, but as this is only a warning I want to resolve the database connection issues first.

Thanks in advance.

I have completed an upgrade to CA 11.1.7 FP1 from CA 11.0.13.

Upon trying to connect to the Content Store I am getting the following message:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

My Content Store is on Oracle and the connection defined as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=server.xxx.yyyy.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=database.oracle.yyyy.com)))
Whilst certain entities have been obfuscated, this same connection worked previous to the upgrade.

We use SSL and SSO.
Other than running an over-the-top install, I have made no other changes to the configuration.

Note: I am also getting an [Check NIST 131A conformance warning] while starting Cognos services message, but as this is only a warning I want to resolve the database connection issues first.

Thanks in advance.

Adam,

Since you are using TCPS could it be some problem with the certificates? They should have been preserved with an over-the-top upgrade but might want to check into it. Also, the NIST warning means that you probably need to increase the strength of the confidentialities to 256-bit under Cryptography > Cognos and may have to remove weaker ciphers there as well. NIST is an SSL standard that requires strong encryption basically.

I have completed an upgrade to CA 11.1.7 FP1 from CA 11.0.13.

Upon trying to connect to the Content Store I am getting the following message:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.

My Content Store is on Oracle and the connection defined as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=server.xxx.yyyy.com)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=database.oracle.yyyy.com)))
Whilst certain entities have been obfuscated, this same connection worked previous to the upgrade.

We use SSL and SSO.
Other than running an over-the-top install, I have made no other changes to the configuration.

Note: I am also getting an [Check NIST 131A conformance warning] while starting Cognos services message, but as this is only a warning I want to resolve the database connection issues first.

Thanks in advance.