Oracle 10g to Qlikview 11 SR5

[mohammadkhatimi]

Hie...

Please help me out to connect Oracle 10g to Qlikview11 SR5....

Give the steps & what to download on my qlikview server...

Thanking You,

Regards,

Mohammad.

[ToniKautto]

This detail you should have put in the initial question, so that you get higher quality on the replies.

As you can see in the error message it refer to a ORA code, which is a Oracle error code. This is most of the time an indication of the problem being related to Oracle setup. This also means that Oracle is better equipped to help you resolve the issue.

Please see below link as a reference to where you can start troubleshooting the ORA error.

ORA-12150 to ORA-12236

[mohammadkhatimi]

I have installed InstantClient 12_1 on my Windows Server 2008 R2 Enterprise

Is installed Client of Oracle is correct??? If not which version I should install???

Also Oracle 10g 32bit is in different server... I want to fetch these data into my Qlikview

Please tell me the process or steps I need to do to connect Oracle with Qlikview......

Hope you understand my problem.....

Regards,

Mohammad

[ToniKautto]

What I am trying to say is that this is not a QlikView issue, it is a Oracle issue, so you might get better input in a Oracle forum.

Have you validated that your Oracle setup is accurate?

Do you have any other SQL client that you can use to validate that the connection to the database works?

ORA-12154: TNS:could not resolve the connect identifier sp...

You expressed this as a urgent issue, then my advise is that you talk to your Oracle database administrator to get help with the setup. I have a hard time seeing that Qlik Community is the quickest way for you to resolve a non-QlikView problem

[mohammadkhatimi]

Bro I knw its an oracle error nt qlikview error...

TNSNAMES.ORA is not getting in my system thatswhy i cant do anything now i m trying to reinstall oracle on qlikview server...

Thanks for replying and helping...

If anyone knows about an error to recover kindly help...

[mohammadkhatimi · Accepted solution]

Steps for getting an ODBC connection to the YourDbName database on a local machine:

Get an Oracle client on your machine:

- First, go to the Oracle instant client download page (Instant Client downloads for Microsoft Windows (x64)) and download the ‘Instant Client Package – Basic’ – it’s the first one.

- Extract the contents of the downloaded zip file to C:\Oracle

Create a TNS names file:

- Copy the following text into a blank text file:

TNS Name=

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1800))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = )

    )

  )

- Save this text file into the C:/Oracle/network/admin folder (create it if it doesn’t exist already), and name it tnsnames.ora (if you have a tnsnames.ora file already, add the copied text to the end of it.

- Go to ‘My Computer’ -> Properties -> Advanced -> Environment Variables, and under ‘User variables’, add a new variable with name TNS_ADMIN, and value ‘C:/Oracle/network/admin’ (or wherever your tnsnames.ora file is)

Create an ODBC Data Source:

   - Go to Control Panel -> Data Sources (ODBC) -> System DSN, and click Add..

   - Scroll to the bottom of the list and select ‘Oracle in instantclient_11_2’

            - Create a data source

[buzzy996]

try this,

1. u have to create system dsn,

a. Start --Control panel -- administrative tools ---Data Sources(ODBC)

b. select System DSN tab

c. select ur data source name from the system dsn tab

d. click add button from system dsn tab

e. select relevant orace driver --clik finish

f. Enter ur odbc config details

   1. data source as : xxx

   2. DescriptionL: xxx

   3. select ur TNS Services Name from drop down box.

g.test connection,if u got success message ur connection is success else u have some settings problems to connect ur data source

2. use that dsn connection in qlikview as a connection string

3. put here ur load script

4.reload

[ToniKautto]

Commonly this issue occurs when the Oracle installer for some reason has failed to add the required Windows system variable. Then the solution is to add the required system variable as described below. If you are having problem with installing the actual tnsnames.ora file, then I still do not know how the Qlik Community can help you resolve this Oracle issue? And I still wonder if you have consulted Oracle knowledge base, Oracle communities or your system admin?

From Qlik Support Knowledge Base:

The ORA-12154 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases.

1. Open to Windows' System Properties, commonly found with Win+Break or Win+Pause
2. Open Advanced System Settings. Does not apply on all Windows versions
3. Go to Advanced tab > Environment Variables
4. Create a System environment variable called TNS_ADMIN and with the path to tnsnames.ora file as a value (for example if tnsnames.ora is located in C:/Oracle/network/admin, the value for TNS_ADMIN will be C:/Oracle/network/admin). Make sure it is a system environment variable and not a user variable if the connection to the database is done as a windows service (like in QlikView Server reloading tasks)
5. Restart Windows to apply the new system variable

If that still doesn't solve the issue, please consult Oracle documentation or expertise to further troubleshoot this issue.

[ToniKautto]

Is this your solution?

Please remember to mark helpful and correct answers so the community members know if your question has been answered or requires more input.