Error Creating Arcsde Direct Connection Oracle
Contents |
Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site arcgis sde connection file About Us Learn more about Stack Overflow the company Business Learn more about hiring
Sde:oracle12c
developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems
Sde:oracle11g
Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Problems with direct connection to ESRI Oracle db for 9.3.1? up vote 0 down vote favorite I am trying to create a direct connection to ESRI Oracle database for version 9.3.1. When I try to connect I get this error: org.geotools.arcsde.ArcSdeException: Can't create connection to none for Session #14[SDE error -324][Error desc=SERVER LIBRARY FOR DIRECT CONNECT COULD NOT BE LOADED. ][Extended desc=] Here is my configuration: 1. I use Oracle11.2 client. My TNS is properly set. When I type sqlplus user/password@MyTnsName I can connect to the database. 2. I use Geotools 13 and its proper ArcSde Plugin. The connection is configured using these instructions: http://docs.geotools.org/stable/userguide/library/data/arcsde.html Here is a piece of code that uses the plugin to make connection: Map
client on the client computers, perform the following steps to set up a direct connection from ArcGIS Desktop. Note: If there is an existing connection to an ArcSDE geodatabase in the ArcGIS Desktop instance, any subsequent connections matching the original server, instance, and authentication mode properties will use the original connection properties. This means that if you connect to the same ArcSDE geodatabase with a connection file that does not save user name and password or version and there http://gis.stackexchange.com/questions/144995/problems-with-direct-connection-to-esri-oracle-db-for-9-3-1 is already a connection to the same ArcSDE geodatabase server and instance that does save the user name and password or version, you will not be prompted to fill in the missing properties; the properties from the original connection with the saved login or version will be used. Steps: Expand the Database Connections folder in the Catalog tree. http://help.arcgis.com/EN/arcgisdesktop/10.0/help/002n/002n00000039000000.htm This can be accessed in one of two ways: Start ArcMap, ArcScene, or ArcGlobe, open the Catalog window, then double-click the Database Connections folder in the Catalog tree. Start ArcCatalog and double-click the Database Connections folder in the Catalog tree. Double-click Add Spatial Database Connection. This opens the Spatial Database Connection dialog box. In the Server text box, type the name of the server on which the Oracle database resides. What you type in the Service text box varies depending on the version of Oracle client you use and whether you are connecting to the master sde instance or a geodatabase in a user's schema. If you are connecting to Oracle using an Oracle 10g client, type sde:oracle10g:
There is no ArcSDE Post Installation wizard, and the “Create ArcSDE service” operation (as part of the wizard) is no longer supported. And more significantly, the https://esriaustraliatechblog.wordpress.com/2012/09/27/creating-an-arcsde-service-on-windows-using-arcgis-10-1/ default means of connecting to the geodatabase is via Direct Connections. However, if there is still a need for an ArcSDE service (application server connection) at the 10.1 release, one https://sourceforge.net/p/geoserver/mailman/message/31048261/ can be manually created and registered (depending on DBMS) using the following workflow: Edit the service files on windows Steps: 1. Open the services.sde file in a text editor. This error creating file is in the ArcSDE\sdehome\etc folder. 2. Define the service name and TCP/IP port number on which the ArcSDE service will accept connection requests by doing one of the following: • Remove the comment mark (#) from the default entry esri_sde 5151/tcp. • Add a unique service name and TCP/IP port number, for example, arcsde 4000/tcp. 3. Open the Windows services error creating arcsde file which is generally located in C:\Windows\System32\drivers\etc. 4. Copy the service entry you defined in the services.sde file and paste it into the Windows service file. 5. Save and close both services files. Once the service information is defined, you can create the service. Create the ArcSDE service using the sdeservice command You must first execute the sdeservice command with the create operation. On all databases except Oracle, execute the sdeservice command again with the register operation to specify with which database this new service will be used. Syntax to execute this against a geodatabase in SQL Server is as follows: sdeservice -o create -d SQLSERVER,SQLSERVERINSTANCE -i
instructions: Windows Mac Red Hat Linux Ubuntu Click URL instructions: Right-click on ad, choose "Copy Link", then paste here → (This may not be possible with some types of ads) More information about our ad policies X You seem to have CSS turned off. Please don't fill out this field. You seem to have CSS turned off. Please don't fill out this field. Briefly describe the problem (required): Upload screenshot of ad (required): Select a file, or drag & drop file here. ✔ ✘ Please provide the ad click URL, if possible: Home Browse GeoServer Mailing Lists GeoServer Brought to you by: aaime, arneke, bencaradocdavie, cholmesny, and 9 others Summary Files Reviews Support Wiki Mailing Lists Tickets ▾ Patches Feature Requests News geoserver-announce geoserver-devel geoserver-users Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0 Re: [Geoserver-users] GeoServer 2.3.2 Direct Connect to ArcSDE 10.0 From: Downie, Sonya (DPIPWE)