|
POST
|
Hi Alexander, The two hosts are due to using Oracle Data Guard with the Primary and the Fail Over servers. We have a Dev, Test and Prod environment - the Test is basically more a staging set up that is a mirror install of Prod using virtual machines etc. Cheers, Mark
... View more
08-23-2016
03:24 PM
|
0
|
2
|
3386
|
|
POST
|
Hi Christian, The tnsnames.ora with the extra bracket. RMCDB.DPIPWE.TAS.GOV.AU = (DESCRIPTION = (LOAD_BALANCE = off) (ADDRESS = (PROTOCOL = TCP)(HOST = box1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = box2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SIDName) ) ) ) Cheers, Mark
... View more
08-18-2016
03:26 PM
|
0
|
4
|
3386
|
|
POST
|
Hi Peoples, A quick note on an upgrade issue I just came across. May help others out in the future. We are doing an upgrade to one of our ArcSDE instances. This has been bought about by the need to do an Oracle upgrade. Given the number of versions we are behind, we have had to create a new virtual machine on an updated OS, with a new instance of Oracle at 12c, then export the entire database from the old instance to the new instance. Once the new Oracle database came across, then do the ArcSDE upgrade from 10.1 to 10.3.1. So a fair bit going on here. We did this all last week on a test instance – and went swimmingly well. So to today. To connect to the new Oracle instance, there are a few option in relation to the TNSnames.ora file. Option A We can add a new entry for the new database Option B we can use the same name in the TNS, but alter the server details. Option B in theory means you can make one change to the TNSnames, and then all your connections from ArcGIS, FME, SQL Developer etc just continue to work. No need to alter all your projects with the new connection. So we went with option B. I was able to connect to ArcSDE as the SDE user, and to perform the per-requisite checks. So all looked good in relation to connections. When the upgrade ran : this was the result: Executing: UpgradeGDB "Database Connections\rmcdb.dpipwe.tas.gov.au@sde@DC.sde" PREREQUISITE_CHECK UPGRADE Start Time: Thu Aug 18 08:57:52 2016 Paused the database for upgrade. There are no other active connections. User has privileges required to upgrade. Connected RDBMS instance is setup for ST_GEOMETRY configuration. Running Pre-Requisite check (C:\Users\mchilcott\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\rmcdb.dpipwe.tas.gov.au@sde@DC.sde). Instance supports XML type. Updating server tables and stored procedures. Could not update server tables and stored procedures. Refer to upgrade logfiles for more details: C:\Users\mchilcott\AppData\Local\Esri\Desktop10.3\GDBUpgrade.log (null) Unpaused the database. Failed to execute (UpgradeGDB). Failed at Thu Aug 18 08:57:52 2016 (Elapsed Time: 0.28 seconds) Nothing in the UpgradeGDB.log Nothing in the sdesetup.log These gave some hint as to the issue: http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3 http://support.esri.com/technical-article/000011653 Going back over the TNSnames.ora file, I found an extra bracket. Also, I am not sure if the TNS is case dependent, as we altered rmcdb.dpipwe.tas.gov.au > RMCDB.DPIPWE.TAS.GOV.AU Fixing the tnsnames.ora file, and creating a new ArcMap database connection - and it worked. It looks to me there is a bug in here somewhere. If the TNS was incorrect, or the connection file in SDE is slightly different –then the connection should have failed, or the per-requisite should have failed. To have the connection succeed, and the per-requisite succeed, only to have the upgrade fail is strange. This leads you to think it is a server issue, rather than a client issue. Bottom line - if you see this, then check your TNSnames.ora file, and recreate your connections. Maybe even attempt the upgrade from another computer.
... View more
08-17-2016
07:47 PM
|
1
|
7
|
5619
|
|
POST
|
We are starting to scope out what we may need to do to implement GDA2020 once the coordinate system has been defined and the NTv2 grids become available at the beginning of 2017. I have only touched the surface of this – but was hoping for a quick reality check on some of my initial thoughts. ArcMap As far as ArcMap goes – it all looks reasonably clear. Once registered with the EPSG and included with the software at some later release, once I upgrade ArcMap, it is just another projection and coordinate system. Just an ArcMap upgrade to support a new coordinate system and transform. Server It is not entirely clear to me what is going on with server (both ArcSDE and Server [Publishing]). I suspect the new coordinate system and transform forms part of the server software – so if I want my ArcSDE data or my published services to support GDA2020 – I will need to do server upgrades. Is this the case? The data What I was hoping for was to use some ArcSDE magic and ST_GEOM sql to just say : upgrade <feature_class> transform GEOM to GDA2020. (you get the drift). Then all the feature classes just become GDA2020. Magic. What I am thinking is it will not be that easy. I think I am going to have to run a tool that transforms the data into a new feature class. This has some interesting challenges in relation to: Versioned editing: Archives : Relationship classes : Topologies: … So … to the heart of the matter: If I have to export all the feature classes to transform them, and I have to upgrade the servers to support the new coordinate system – then for all intents and purposes – I am looking at a complete system rebuild – all new data on all new servers, with the additional challenges of moving complex data structures. Is this correct, or am I just missing something really obvious? Cheers, Mark
... View more
08-04-2016
10:23 PM
|
0
|
1
|
2892
|
|
POST
|
Hi Peoples, esri's current status is they do not support the use of SD cards with Collector for Android. However, I noted with the new release of Android 6.0 Marshmallow: Starting with Android 6.0 Marshmallow, though, some phones can use SD cards as internal storage as well. In this case, your Android device “adopts” the SD card as part of its internal pool. It’ll be treated as part of your internal storage, and Android can install apps to it and save app data to it. In fact, since it’s considered internal storage, any type of app can be installed to the SD card–including apps that provide widgets and background processes. Unlike older versions of Android, it doesn’t matter whether the developer has disabled the “move to SD card” permission or not. http://www.techradar.com/au/news/phone-and-communications/mobile-phones/android-m-release-date-when-can-i-get-it--1297182 http://www.howtogeek.com/242937/how-to-set-up-a-new-sd-card-in-android-for-extra-storage/ Anyone tried this to see if it works? Anyone know if the use of internal storage SD cards with therefore technically be supported? Cheers, Mark
... View more
07-18-2016
06:07 PM
|
1
|
1
|
2481
|
|
IDEA
|
When you need to work offline – Basemaps can be downloaded directly to your smartphone or tablet using the Collector app. This involved creating a tile package, and copying it to the device. If you use Apple devices - the only way Collector supports copying to the device is with iTunes. This is somewhat difficult. Apps like Avenza PDF Maps offer the following 4 methods to copy data to the App. You can do so in four ways: 1. From the Maps list, tap the + button at the top-right. In the From the Web box, type a URL, network or server address into the box to download and process a map to load it from a public URL/network/server. 2. By Email, you can tap and hold an attachment until you see the "Open in PDF Maps" option. 3. Connect your iOS device to your computer and open iTunes. Add files to PDF Maps from the Apps section in iTunes. Once added, you can process these maps in the app by tapping the iTunes File Sharing option. 4.Link your Dropbox account to PDF Maps and choose compatible files (geospatial PDF, GeoPDF and GeoTIFF) to download to the PDF Maps app. Collector should be able to do the same.
... View more
05-02-2016
04:05 PM
|
10
|
3
|
1798
|