Error Connecting To Oracle Arcsde Post Installation
without it enabled. Please turn JavaScript back on and reload this page.All Places > GIS > Managing Data > DiscussionsLog in to create and rate content, and to follow, bookmark, and share content with other members.troubles with arcsde oracle 11g installDiscussion created by jamiehollingsworth on May 25, 2011Latest reply on May 26, 2011 by vangelo-esristaff Like • Show 0 Likes0 Comment • 7So it is a long and complicated story but I have oracle 11.1.0.7 (32bit) installed on windows 2003 r2 (32bit) sever. Now i am trying to install arcsde 10 sp1 for oracle 11g (32bit) and after several weeks of trying things only get worse. Currently i can not get passed the connect as oracle sys user in the post install. the error is "Error connecting to Oracle:O contains an incorrect path". I am able to log in as sys user using the SQL/plus. So if someone has time to hold my hand through this i would be very great full.thanksjamieOutcomesVisibility: Managing Data2109 ViewsLast modified on May 25, 2011 4:48 PMTags:managing_dataContent tagged with managing_datagdbContent tagged with gdb_geodatabaseContent tagged with _geodatabaseThis content has been marked as final. Show 7 comments7 RepliesNameEmail AddressWebsite AddressName(Required)Email Address(Required, will not be published)Website Addressvangelo-esristaff May 25, 2011 7:30 PMIt would help if you give a *lot* more details on your configuration...+ What is your ORACLE_HOME?+ What is your ORACLE_SID?+ What does listener.ora contain?+ What does tnsnames.ora contain?+ What is your SDEHOME?+ What is in your PATH?+ Are you using the post-install GUI? If so, what values have you plugged in?+ Have you tried using the manual post-install proceess?+ Have you tried executing 'sdesetup -o prerequisite_check'?+ What is in your dbinit.sde a
in Home / *FME Desktop / Home / Unable to Connect to Database After Upgrading to ArcSDE 10.1 or Above Export to PDF MitaAtSafe created · Oct 08, 2015 at 07:13 PM · AnnabelleAtSafe edited · Oct 28, 2015 at 09:21 PM Article created with FME Desktop 2012 SymptomAfter upgrading ArcGIS software to 10.1 and above, a workspace using an SDE format can no longer connect to the database and will cause the translation to fail. 2014-11-04 13:56:15| 2.7| 0.0|ERROR |Could not https://geonet.esri.com/thread/29054 open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216023'. The error message from ArcObjects is: {Server machine not found} 2014-11-04 13:56:15| 2.7| 0.0|ERROR |Please ensure the connection parameters are correct (server=`myServer', instance=`port:5151', user=`sde', password=`*******', database=`sde', version=`SDE.DEFAULT') Note: You can tell if a three-tier connection is being used by a 'port' being specified in the instance parameter.For Example: instance=`port:5151' https://knowledge.safe.com/articles/465/unable-to-connect-to-database-after-upgrading-to-a.html Cause Any FME workspaces with the ESRI ArcSDE or Esri Geodatabase (ArcSDE Geodatabase) reader/writer will no longer be able to connect to ArcSDE 10.1 if they were set up using a three-tier connection: As of ArcSDE 10.1 there is no longer an SDE service running on port 5151 by default. ResolutionThere are 2 options: 1) Change the reader/writer parameters to use a two-tier (direct connect) connection. Details can be found here: http://fmepedia.safe.com/articles/FAQ/How-do-I-connect-to-my-ArcSDE-Geodatabase-using-Direct-Connect 2) Install the Application Server Services software on the ArcSDE server. This will bring back the ArcSDE service and allow the three-tier connection to work. This service must be manually installed using ArcSDE administration commands. Details can be found under “Application Server Services” here: http://blogs.esri.com/esri/supportcenter/2012/03/27/where-did-the-arcsde-post-installation-wizard-go-at-10-1/ For further information on the interaction between FME and the Esri products refer to our Compatibility page. thub.nodes.view.add-new-comment geodatabaseinstallationauthenticationarcsde Add comment 10 |1200 characters needed characters left characters exceeded ▼ Viewable by all users Viewable by moderators Viewable by moderators and the original poster Advanced visibility Viewable by all users Article Contributors Follow this article Follow No one ha
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 http://gis.stackexchange.com/questions/68909/arcsde-10-2-how-to-enable-and-create-geodatabase-in-oracle-without-arcgis-deskt the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Geographic Information Systems http://gis.stackexchange.com/questions/37125/is-arcsde-no-longer-needed-at-arcgis-10-1 Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes error connecting 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 ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop up vote 4 down vote favorite Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i error connecting to enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, but no desktop license. Is there any documentation about it? Any help is appreciated!! arcsde esri-geodatabase oracle oracle-11g share|improve this question asked Aug 16 '13 at 13:36 fischermatte 14827 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote accepted For Windows Service You can create and register an ArcSDE service on Windows servers from an MS-DOS prompt using the sdeservice command. http://resources.arcgis.com/en/help/install-guides/arcsde-application-server-oracle/10.2/index.html#/Creating_an_ArcSDE_service_on_Windows_using_the_sdeservice_command/00940000006w000000/ For creating the geodatabasase (after users/roles are set) python is required. Scripting geodatabase creation in Oracle Install and configure Oracle on your server. If you will be running the Python script from a different computer than the Oracle server, install the Oracle client on the computer from which you will run the script. The Oracle client can be downloaded from the Esri Customer Care Portal. If you will be running the script from an ArcGIS 32-bit client, download the 32-bit version of the Oracle client. If you will be running the script from ArcGIS fo
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 About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems 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 Is ArcSDE no longer needed at ArcGIS 10.1? up vote 25 down vote favorite 12 Through my frustration of not finding the post-installation wizard with ArcSDE 10.1 and being unsuccessful with the command line tool to start an SDE service on our SDE databases, I found I was able to access the databases and copy/past/add features/delete features/etc. all through direct connections to our SQL Server 2012 machine. This was WITHOUT ArcSDE running. So... The question is, why do I need to go through the trouble of trying to get the SDE services to run if I can manage our databases through the Desktop tools? I was even able to create an enterprise geodatabase and verified that all of the necessary business tables were created. I have even recreated all our map services in ArcGIS Server 10.1 with direct connect and the web editing is perfectly working. Perhaps I'm missing something... UPDATE: As indicated in the What's New for Geodatabases topic: "The recommended method to access enterprise geodatabases is to connect directly from ArcGIS clients. If you only use direct connections to your geodatabase, you do not have to install the ArcSDE application server." If you need to edit settings in the ArcSDE system tables, though, you should still install the command line tools included with the application server. I don't think editing system tables directly through SQL is supported technically. arcgis-10.1 arcgis-server arcsde installation share|improve this question edited Dec 22 '13 at 21:21 PolyGeo♦ 39.1k1357143 asked Oct 19 '12 at 10:19 Luke 230138 2 This is nothing new. An ArcSDE Service is only necessary when using application server (or "three-tiered") connections. –blah238 Oct 19 '12 at 10:52 2 @blah238 this is something new - before 10.1 you couldn't configure an enterprise geodatabase without first installing ArcS