Latest Contributions by MarcoBoeringa

Seems to me it is time for that phone call to your ESRI representative to request the correct 10.0 Enterprise Standard key you need to get it up and running... ... View more

Could I use the 10.1 licenses, or must I request new ones?! Good question, I can't tell. Codes may be - and likely are - tight to specific versions, but only a phone call to ESRI could tell. Clearly, the 9.2 code doesn't work with 10.0, so it probably is version tight and you may need to request a new one. I don't think it would hurt though to run a SQL UPDATE statement and replace "101" with "100". In addition, if the *.ecp file is text, you might even edit that, and run it through the authorization process in the modified form. At worst, you replaced a bad key with another bad and non functional key. Could this be the cause of my trouble!? Well, having "101" where the authorization software maybe expects to read "100", is probably not going to help, although I am not sure if the authorization software even cares to process the ecp file to extract these individual values, or simply tries to run an UPDATE statement against the database (that somehow inexplicably fails than). ... View more

Still no results. Cannot create a direct connection, nor authenticate. If, like seems the case here based on your SQL query result, the key still references the old 9.2 one, it isn't strange you can't connect. Does the authentication for v10 write the key to the registry, or into a table in the database (like 9.2, that writes into SDE.SERVER_CONFIG, if I am correct?) ? I think you answered this yourself by extracting it from the database using the SQL statement Vince supplied. It is clearly stored in the Server_Config table. I don't know if there is a secondary storage in registry, Vince undoubtedly can tell, but it seems highly unlikely to me to have dual storage here for an option like this. If it writes to the registry, maybe I could create a registry key with the contents of the .ecp file I received from ESRI? I think your better shot at this would be to use a SQL UPDATE statement to update the contents of the Server_Config table with the contents of the *.ecp file. E.g. I expect it to look something like this: sqlplus sde/password@instance UPDATE server_config SET char_prop_value='arcsdeserver,100,ecpYOUR_ArcSDE10_CODE,none,YOUR_ArcSDE10_CODE' WHERE prop_name = 'AUTH_KEY'; I am not sure if the "none" is also included with full ArcSDE server licences, or replaced by something else, but my ArcSDE Personal licence that came with my ArcGIS for Home Use licence, displays "none" in between the ecp code and the final code if I look inside the table in SQL Server Management Studio. And yes, all values are concatenated in one comma separated string. EDIT: I see the "None" is also included in the screenshot you posted of the faulty 9.2 authorization key in the Server_Config table of your installation, so it is also included with full ArcSDE server licences, so you can probably run the statement like above. ... View more

Yes, that was the first thing I did, when the direct connect failed. It works with sqlplus, but in ArcCatalog, it gives me a general error message (Operation failed). I have found in some forum, that the authentication error like this happens when a database name is changed, and I did change it...Now I will try to delete the database, and create a new 11g db, with the sam name as the 10g I did the upgrade and export from. I will post results. Tnx, M. Milo, Vince clearly stated in another thread that changing database names is NOT supported on geodatabases. This is because the database name is included in vital stored procedures and triggers etc. in the ArcSDE Repository. So yes, ensure the database name of the new instance is exactly the same as the old one. ... View more

I give up... this will not work no matter what. I did the import, all ok, but still cannot connect to Oracle directly, or create a service. Also I get error, that the authentification key cannot be updated. Seems to me you are awfully close to solving this, but I guess it may be good to call in some ESRI Help to get this ArcSDE authorization and database connection issue sorted out now you managed to upgrade and move the database to the 64-bit platform. Anyway, you probably already followed these steps, but have you tested the functioning of the Oracle Net client per the text below from this Help page? "2. Test that Oracle Net was installed successfully by typing the following at a command prompt on the client machine: sqlplus <user name>/<password>@<Oracle Net service name>" ... View more

Good to hear the upgrade to 10.x on the 32-bit installation went well after correcting the TEMP tablespace issue. Good luck with the migration to the 64-bit server. I haven't got any additional suggestions here, sounds like you are on the right track now, maybe Vince has something to add. I do see a potential issue with Oracle 11.2.0.1 mentioned here concerning import/export operations, but since you are using 11.2.0.3, this probably doesn't apply, anyway, maybe good to keep this in mind if anything goes wrong: http://support.esri.com/en/knowledgebase/techarticles/detail/38470 ... View more

I have granted all the privileges to the sde user...those on the list, and everything else, for the test only. Now I cannot even connect, so I must restore the gdb from backup. Should I maybe have done this as a SYS or SYSTEM user? What should be my next steps? Tnx. M. Have you checked the temporary tablespace settings, as per the Oracle links I linked in the last post? Restoring your geodatabase from backup, and contacting ESRI Tech support to guide you through the upgrade is probably the wisest thing at this point. You have a triple set of "upgrades" going on: geodatabase version, oracle version and switch from 32bit to 64bit database. That means a lot of details and points where it may go wrong. ... View more

It seems you aren't able to edit the DBTUNE table using the account with which you logged in. You might check if this is the case with the tools in the database. Do you have Insert and Update rights on the table. This Help page also mentions to ensure the ArcSDE administrator has sufficient permissions to do the upgrade (unfortunately, on it isn't mentioned which ones. Undoubtedly documented somewhere else...): "Grant the ArcSDE administrator the permissions necessary to upgrade a geodatabase." OK, I think they are listed here: User permissions for geodatabases in Oracle http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n0000002v000000 Probably wise to contact Tech support like Vince suggested, but here are two links concerning the Oracle error code: https://forums.oracle.com/forums/thread.jspa?threadID=969107 http://neeraj-dba.blogspot.nl/2011/04/ora-25153-temporary-tablespace-is-empty.html ... View more

Your question is so generic, that I think most people will have a hard time answering it. There's plenty to suggest, but I think you should do better to start thinking about what it is you want to do with your current setup, and read technical and marketing documentation by ESRI to get some feeling of what is possible, e.g. read the pages under "Products" and for example "Business Analyst", "Production Mapping", "ArcGIS for Aviation", "ArcGIS for Maritime" etc. depending on your organizations main focus. Anyway, for a more detailed technical insight into ArcSDE Technology, you may find this recent document by myself, posted in another thread, interesting to read. "The ESRI Geodatabase Framework" ... View more

Now I keep getting error that states that the app cannot load libraries. Found this: http://support.esri.com/en/knowledgebase/techarticles/detail/36510 It opposes your suggestion, but I tried it also, also no result... Any other suggestions? Thanks a lot. Regards, M. Since you seem to correctly have installed the 32bit version of the Oracle Client on the new machine with ArcGIS for Desktop from which you are trying to upgrade the geodatabase (at least you mention installing 32bit in your first post), I don't think this issue is related to your problems. This issue happens when you install a 64bit version of Oracle Client. ArcGIS for Desktop can not use a 64bit database client (ArcGIS for Server and the ArcSDE Application Server can). Again, I think this is unrelated. I think your main issue is that, according to the ESRI documentation in this Help page, you need to upgrade the geodatabase on the existing machine first (in your case your 9.2 production server). It must be upgraded to a 32bit Oracle database, ArcGIS 10.0 SP5 install. After that, you can migrate the upgraded geodatabase to the new server with 64bit Oracle and also ArcGIS 10.0 SP5 geodatabase. You did not do this, you moved the existing 9.2 geodatabase to the new 64bit Oracle database server, and than attempted to upgrade to 10.0 SP5 using the ArcGIS 10.0 SP5 installed on the new server. Again, if I understand the Help page well, you will need down time for maintenance on your production server to do the upgrade, unless you are able to create a second, temporary, identical 9.2 server with a copy of the Oracle 32bit database, to do the upgrade to 10.0 SP5 there. You could than migrate the data to the new 64bit server from there, and migrate somehow any data changes on your production server to the new 10.0 SP5 geodatabase on the new server. ... View more

Have you edited the PATH environment variable as referred to on this Help page?: http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000038000000 Also check your connection properties against the options listed for the Instance string in Oracle on this page: http://resources.arcgis.com/en/help/main/10.1/index.html#/Database_connections_in_ArcGIS_for_Desktop/019v00000003000000/ And check all steps listed here in the 10.0 Help about upgrading: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p0000000 Also, there are some caveats to take notice of when doing an upgrade from a 32bit to 64bit Oracle version in the same process. See this Help page. To be honest, you may wish to call in ESRI support for an upgrade like this... and it may even not be possible without temporarily making your production database unavailable for maintenance to allow an upgrade of the geodatabase there, if I understand the instructions well on this Help page: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Migrating_to_ArcSDE_64_bit_on_Windows_when_the_existing_DBMS_is_32_bit/002n000000q0000000/ ... View more

I think your issue is with the entry of the "serviceName". Unless you modified the Windows services file on your client PC to supply the corresponding TCP/IP number, you will not be able to connect by entering a service name (for some details regarding editing the services file, see this Help page). You may try entering the port number instead. In a default installation of ArcSDE, the port number is 5151, so enter that instead of "ssss.sss.sss.sss.au" ? OR "MyEDB" (database?) It should allow you to connect without specifying the service name. In addition, it is better to include the file extension "*.sde" to the name of the connection file, so "myConn.sde". An introduction to setting up and connecting too an Application Server can be found in this ESRI Australia blog article: http://esriaustraliatechblog.wordpress.com/2012/09/27/creating-an-arcsde-service-on-windows-using-arcgis-10-1/ All of this assumes you have an ArcSDE Application Server running on a server, and don't attempt to connect via Direct Connect, for which the "Create ArcSDE Connection File" tool is not meant to be used. If you are not familiar with the distinction between Direct Connect and an ArcSDE Application Server, you may also wish to read the document I recently posted in another thread: http://forums.arcgis.com/threads/83644-quot-The-ESRI-Geodatabase-Framework-quot-PDF ... View more

3) Contact Esri Tech Support (these Forums are not Tech Support). - V Agree. Marco ... View more

You need to create a new layer (schapefile) first. But if you have no experience at all using any form of GIS, I really recommend you to start reading some QGIS documentation first. Since QGIS is not an ESRI product, you are also better of asking questions on another dedicated QGIS forum, or a more general GIS forum like http://gis.stackexchange.com/ ... View more

According to this Help page, 51 is just a generic error code generated when ArcSDE doesn't recognize the DBMS error. Have you checked the logs as in the Help text?: "Underlying DBMS error (-51) An error was returned from the database that was not recognized by ArcSDE or the client application. Check the DBMS logs for more information." It is probably a completely unsupported operation by ESRI, but since it only affects two layers and it seems to concern orphaned rows "referencing non-existent states", you might consider joining the SDE_states system table to the A and D tables (User1.A172 etc.) that have the orphaned rows. This will quickly tell you which rows are orphaned, as there will be no join results from the SDE_states table for those records in the A and D tables that are orphaned. You could than delete those, or maybe even better copy them first to another table for reference and examining to make sure nothing important is lost upon delete. *** EDIT ***: Only do the above if your Feature Classes do not participate in any geodatabase behavior (e.g. no relationship classes, topology, network dataset etc. defined), so Simple Feature layers only. Otherwise the layers and A and D tables may, or better said will, have relationships and dependencies on other tables and Feature Classes, and that may cause additional issues. Backup the database beforehand. ... View more