topic Re: Connection to Oracle database failed, in Data Management Questions

Connection to Oracle database failed,

Anonymous User — Sun, 16 Dec 2012 15:44:36 GMT

Original User: Jamal432@gmail.com

Connection to Oracle database failed,

I have created an enterprise oracle database and tried to connect to it but sounds not to work. I got the message shown in the screenshot below:

[ATTACH=CONFIG]19984[/ATTACH], [ATTACH=CONFIG]19985[/ATTACH]

What might be the reason?

Thank you in advance

Best

Jamal

Re: Connection to Oracle database failed,

Anonymous User — Fri, 21 Dec 2012 18:01:30 GMT

Original User: MelanieWhite

Hi Jamal,

Please consider the following:

Use Tnsping to insure that you can connect from to the listener. If you do not get a response, restart your listener. If you do, insure that you can connect to your Oracle instance using SQLPlus. If you can connect using SQL plus, there might be something wrong with your connections parameters. Do you have the correct server\instance name? Have you tried using a full Oracle client?

Melanie 🙂

Re: Connection to Oracle database failed,

JamalNUMAN — Mon, 24 Dec 2012 20:42:51 GMT

Hi Jamal,

Please consider the following:

Use Tnsping to insure that you can connect from to the listener. If you do not get a response, restart your listener. If you do, insure that you can connect to your Oracle instance using SQLPlus. If you can connect using SQL plus, there might be something wrong with your connections parameters. Do you have the correct server\instance name? Have you tried using a full Oracle client?

Melanie 🙂

Thank you for the answer Melanie

I�??m very new to this area of application.

�?� I don�??t know what the �??Tnsping�?� is
�?� I don�??t know how to start the �??listener�?�
�?� I�??m trying this connection from my machine (mylaptop) and the data is on my machine as well.
�?� How about the �??full Oracle client�?�? is it for free?

Best

Jamal

Re: Connection to Oracle database failed,

Anonymous User — Fri, 28 Dec 2012 13:02:41 GMT

Original User: mousaem

Hi,

first, you need to install Oracle Client on your machine (laptop) , depends on your database version if its 11g then install Oracle Client 11g.

after installing your Oracle Client, go to the directory where you can find tnsnames.ora file

add the Oracle TNS entry in this file.

Second, go to cmd in your machine and type sqlplus
then, type sde@your database TNS definition
then password

as melanie mentioned you can use tnsping command with your oracle database, the output put it in the tnsnames.ora file.
Ask your DBA about it......

here is a references:

http://resources.arcgis.com/en/help/main/10.1/index.html#/A_quick_tour_of_setting_up_a_geodatabase_in_Oracle/002n00000001000000/

Database Connection using ArcCatalog 10.1 :
http://resources.arcgis.com/en/help/main/10.1/index.html#/Geodatabase_connections_in_ArcGIS_Desktop/002n00000030000000/

Re: Connection to Oracle database failed,

JamalNUMAN — Fri, 28 Dec 2012 16:57:30 GMT

Hi,

first, you need to install Oracle Client on your machine (laptop) , depends on your database version if its 11g then install Oracle Client 11g.

after installing your Oracle Client, go to the directory where you can find tnsnames.ora file

add the Oracle TNS entry in this file.

Second, go to cmd in your machine and type sqlplus
then, type sde@your database TNS definition
then password

as melanie mentioned you can use tnsping command with your oracle database, the output put it in the tnsnames.ora file.
Ask your DBA about it......

here is a references:

http://resources.arcgis.com/en/help/main/10.1/index.html#/A_quick_tour_of_setting_up_a_geodatabase_in_Oracle/002n00000001000000/

Database Connection using ArcCatalog 10.1 :
http://resources.arcgis.com/en/help/main/10.1/index.html#/Geodatabase_connections_in_ArcGIS_Desktop/002n00000030000000/

Thank you Emad for the answer.

Iâ??ll try it and hopefully it will work

Best

Jamal

Re: Connection to Oracle database failed,

JamalNUMAN — Sat, 19 Oct 2013 11:12:34 GMT

Hi,

first, you need to install Oracle Client on your machine (laptop) , depends on your database version if its 11g then install Oracle Client 11g.

after installing your Oracle Client, go to the directory where you can find tnsnames.ora file

add the Oracle TNS entry in this file.

Second, go to cmd in your machine and type sqlplus
then, type sde@your database TNS definition
then password

as melanie mentioned you can use tnsping command with your oracle database, the output put it in the tnsnames.ora file.
Ask your DBA about it......

here is a references:

http://resources.arcgis.com/en/help/main/10.1/index.html#/A_quick_tour_of_setting_up_a_geodatabase_in_Oracle/002n00000001000000/

Database Connection using ArcCatalog 10.1 :
http://resources.arcgis.com/en/help/main/10.1/index.html#/Geodatabase_connections_in_ArcGIS_Desktop/002n00000030000000/

I got a help from an expert.

1. Oracle database X64 server must be installed on the server machine

2. Oracle database X32 client must be installed on the server machine and other client machines

3. Make sure that the â??Oracle home directoryâ?� is pointing to C:\app\jamal\product\11.2.0\dbhome_1

[ATTACH=CONFIG]28467[/ATTACH]

4. Access folders below and ensure that the two files below include to the correct server machine name

tnsnames.ora
listener.ora

[ATTACH=CONFIG]28468[/ATTACH], [ATTACH=CONFIG]28469[/ATTACH]

5. Copy the tnsnames.ora from C:\app\jamal\product\11.2.0\dbhome_1\NETWORK\ADMIN to the C:\app\jamal\product\11.2.0\client_1\NETWORK\ADMIN

[ATTACH=CONFIG]28470[/ATTACH]

6. Now, the oracle database can be accessed from the ArcGIS with no problem

[ATTACH=CONFIG]28471[/ATTACH]