Sap Oracle Connection with other oracle

[Former Member]

Dear Experts ,

I am trying to connect other oracle machine through database enterned necessary entries in TNS and listerner ora , but i not able to connect

oracle veriosn is 9.2 and on sap server oracle is 10.2 , is there any prblm with version

Please advise

[fidel_vales]

hi,

could you provide a little more information?

like,

how are you trying to connect?

what error are you getting?

any log?

any useful info?

[Former Member]

Hi Fidel.

My requirement is i want to connect to other oracle database with my sapsystem oracle database .

i am trying to connect thru SQL prompt .i am able to ping the Ip of system , TNSping is also working .

had made entries in TNS and lister.

but when i am trying to connect from SQL iam getting error

ORA-12170: TNS:Connect timeout occurred

please advice

Thanks and regards

[fidel_vales]

good, we have a "little" more information

Is there a firewall between the two databases?

What kind of network exist between the two databases? what is the delay?

Do the listener get the request?

[Former Member]

HI Fidel ,

I was able to solve the problem by making additonal entries in TNSnames.ora file

thanks for help