Connection to Oracle database failed,

Question

Original User: Jamal432@gmail.com

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

Clip_27.jpg

Clip_26.jpg

JamalNUMAN · Answer

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]

Clip_21.jpg

Clip_24.jpg

Clip_18.jpg

Clip_20.jpg

Clip_19.jpg

JamalNUMAN · Answer

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

Anonymous User · Answer

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/