Connection to Oracle database failed,

2791
5
12-16-2012 07:44 AM
by Anonymous User
Not applicable
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
0 Kudos
5 Replies
by Anonymous User
Not applicable
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 🙂
0 Kudos
JamalNUMAN
Legendary Contributor
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
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
by Anonymous User
Not applicable
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_i...

Database Connection using ArcCatalog 10.1 :
http://resources.arcgis.com/en/help/main/10.1/index.html#/Geodatabase_connections_in_ArcGIS_Desktop/...
0 Kudos
JamalNUMAN
Legendary Contributor
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_i...

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


Thank you Emad for the answer.

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

Best

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
JamalNUMAN
Legendary Contributor
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_i...

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




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]
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos