connecting to oracle

[khazare]

Hi,

I'm trying to connect to oracle database, query a table and preparing a dashboard using the data.

I navigated into ' system import sets --> administration--> data sources' and provided the details of my oracle instance.

the issue here is

1. i'm not able to connect to the database

2. I dont know what to do next to see the results

3. how do i build a chart/dashboard using the data.

I'm sorry i'm completely new and a first time user to service now.   please guide me through

Appreciate your help in advance.

Thanks

[tony_barratt]

Hi Kadambari,

I expect you are following the instructions here to set up your Oracle data source.

JDBC type data source

What is the version of the Oracle db you are connecting to?

For the the sake of completeness what is the version of your instance? geneva or fuji?

Are you using a MID Server?

What is the error message you see when you click test load 20 records?

Best Regards

Tony

[khazare]

Hi Tony,

Thank you so much for replying.

Yes, i did follow the instructions from that link.

Here's the tnsping to the oracle database :

Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lnxdb-dev-vm-218

.cisco.com)(PORT=1521))(CONNECT_DATA=(SID=CSSWDEV)(Server=Dedicated)))

OK (160 msec)

I'm getting the following error while clicking on test load 20 records:

I have a Geneva version.

appreciate if you could help me further.

Regards,

Kadambari

[tony_barratt]

Hi Kadambari,

Next Step is to verify network connectivity.

Are you using a MID-Server within the Enterprise where the db is situated?

If not I can advise there is no connectivity to the db from the Internet in general.

$ telnet lnxdb-dev-vm-218.cisco.com 1521

Trying 173.38.3.24...

telnet: connect to address 173.38.3.24: Operation timed out

telnet: Unable to connect to remote host

Possibly your ServiceNow instance can connect - if the instance source IPs are allowed through the Enterprise firewall.

If yes, you are using a MID-Server, what is the result of this command

telnet lnxdb-dev-vm-218.cisco.com 1521

Best Regards

Tony

[khazare]

Hi Tony,

I'm able to connect using telnet

I did go though the video tutorial of setting up , but i didnt get complete understanding of MID-server.

Thanks,

Kadambari