topic Re: Connect Desktop 10.1 to Oracle with easy connect in Data Management Questions https://community.esri.com/t5/data-management-questions/connect-desktop-10-1-to-oracle-with-easy-connect/m-p/442301#M25189 <HTML><HEAD></HEAD><BODY><SPAN>Ghassan,</SPAN><BR /><BR /><SPAN>Install 32 bit Oracle client, </SPAN><STRONG>configure</STRONG><SPAN> it, and connect to the database.</SPAN><BR /><BR /><SPAN>Be sure the sqlnet.ora file on the client is configured to allow the use of Easy Connect and the Oracle server is configured to allow Easy Connect syntax. Also note that if your Oracle instance is not listening on the default Oracle port number, you must use connection syntax that includes the port number.</SPAN></BODY></HTML> Wed, 09 Oct 2013 04:21:48 GMT NidhinKarthikeyan 2013-10-09T04:21:48Z Connect Desktop 10.1 to Oracle with easy connect https://community.esri.com/t5/data-management-questions/connect-desktop-10-1-to-oracle-with-easy-connect/m-p/442300#M25188 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to create a database connection from ArcGIS desktop 10.1 to Oracle server using easy connect syntax</SPAN><BR /><SPAN>So, from ArcCatalog I use "Add database connection"</SPAN><BR /><SPAN>then I chose Oracle in database platform</SPAN><BR /><BR /><SPAN>then in the instance I write down </SPAN><BR /><BR /><SPAN>myserver: port/serviceid</SPAN><BR /><BR /><SPAN>so I write</SPAN><BR /><BR /><SPAN>dbserer:1539/devDatabase</SPAN><BR /><BR /><SPAN>but it gives me ora-12154 TNS:could not resolve the connect identifier</SPAN><BR /><BR /><SPAN>I thought by using the easy connect I don't have to worry about TNS names</SPAN></BODY></HTML> Tue, 08 Oct 2013 15:43:07 GMT https://community.esri.com/t5/data-management-questions/connect-desktop-10-1-to-oracle-with-easy-connect/m-p/442300#M25188 GhassanKarwchan 2013-10-08T15:43:07Z Re: Connect Desktop 10.1 to Oracle with easy connect https://community.esri.com/t5/data-management-questions/connect-desktop-10-1-to-oracle-with-easy-connect/m-p/442301#M25189 <HTML><HEAD></HEAD><BODY><SPAN>Ghassan,</SPAN><BR /><BR /><SPAN>Install 32 bit Oracle client, </SPAN><STRONG>configure</STRONG><SPAN> it, and connect to the database.</SPAN><BR /><BR /><SPAN>Be sure the sqlnet.ora file on the client is configured to allow the use of Easy Connect and the Oracle server is configured to allow Easy Connect syntax. Also note that if your Oracle instance is not listening on the default Oracle port number, you must use connection syntax that includes the port number.</SPAN></BODY></HTML> Wed, 09 Oct 2013 04:21:48 GMT https://community.esri.com/t5/data-management-questions/connect-desktop-10-1-to-oracle-with-easy-connect/m-p/442301#M25189 NidhinKarthikeyan 2013-10-09T04:21:48Z