Connecting to Oracle 9i with Cognos Reportnet 1.1 MR2

[eviltoolbox]

Hi,

i want to create a Database Connection to my Productive Oracle 9i Database. I don't know the exact syntax of the connection string. When i connect to my Oracle Managementconsole i use for example: sysdba, sysdbapass and the service name example.demo.com and the connection works.
In Cognos Connection i set SQL*Net connect string example.demo.com and as user sysdba with the correct pass, but the test of the connection doesn't work. How do i configure my database connection for oracle in cognos connection? Could someone help me, i've not much knowledge about oracle.

thanks alot.

 

[JGirl]

What is in your tnsnames.ora file for the database you are attempting to connect to?

J

 

[AlexJanssen]

First of all you need to install the Oracle 9i client or SQL NET libraries to get an Oracle connection.
After that you need to have a proper tnsnames.ora. Once you can login in with SQL Plus, you're ready to configure ReportNet.

For example:
^User ID:^?Password:;LOCAL;OR;ORACLE@%s@ALEX@MYDATASOURCE/%s@COLSEQ=

ALEX is the Database-user that has been made for me
MYDATASOURCE is the name of the entry in tnsnames.ora and how you connect to the Oracle database with SQL Plus

 

[eviltoolbox]

I forgot that the Oracle Database Server and the Cognos Reportnet Server are running on the same maschine. I made this tip with the classes12.zip. Here is my tnsnames.ora:

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.MDT-02.test.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

NVGD.MDT-02.test.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = roiwinsvapps2)(PORT = 1526))
)
(CONNECT_DATA =
(SID = NVGD)
(SERVER = DEDICATED)
)
)

thx for your help

 

[eviltoolbox]

JGirl how's the correct syntax for my tnsnames.ora? Would be nice if u could help me.

thx alot

 

[JGirl]

What are you putting in the Cognos Connect SQL*Net datasource name? Do you have userid and password checked in cognos connection?

J

 

[JGirl]

Also check the sqlnet.ora file that is in the same directory as the tnsnames.ora file.

I've had a few problems with this file in the past causing datasources to not connect correctly through Cognos, even though you can connect through the oracle tools.

Try commenting out (by adding a # at the beginning) the following line:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

Of course, this usually solves the cognos problem, but I don't know what the oracle impacts of commenting out this line are.

J

 

[eviltoolbox]

thx for your answers. i didn't solved my problem. Yeah i checked username and password box. i tried to logon with sql+ client and i got the error couldn't resolve service name. i used the service name from my tnsnames.ora. when i try to logon with sql+ worksheet it works. so i tried to create my database connection and i used this connection string ^User ID:^?Password:;LOCAL;OR;ORACLE@%s@ORACLE.DEMO.COM/%s@COLSEQ= . But it's different from AlexJansens example. So i added a SYSDBA@ infront of ORACLE.DEMO.COM/%s@COLSEQ= but that didn't worked to. This SQLNET Line is still in my sqlnet.ora, we need to check if its needed in our production system, if not i try to comment it out. What can i check now? Which Oracle Client did u meant?

Thx for your help.