ROK Blog

ArcSDE and Oracle On Different Servers

Jason Harris - Monday, September 19, 2005

Being from the SDE old school, I have had it drilled into my head for years the you should always install ArcSDE and your RDBMS on the same server. The argument is that there is the increase of network traffic between the two boxes would slow everything down. It sounds to me that this is just a leftover from the days of 10-base and 100-base connections. Nowadays, most servers have fiber connections with gigabit+ connections, so, this network traffic argument doesn't mean too terribly much any longer.

Many orgs now are really trying to separate DB's and application servers, so the ability to efficiently install SDE and your flavor of RDBMS is going to become increasingly important.

So armed with a couple of forum posts I was off. While I have done easily a hundred SDE SQL Server installs, I'm no slouch at Oracle these days either. I cut my teeth with Oracle SDE on a Florida Department of Health 8 cpu Sun Box, many years ago now, which is another story completely...

I'm happy to report the install went very very smooth. I only needed to change a couple of things. I used a mix of command line, sql plus and the post-install wizard. I used sql plus, along with the provided install script (in the sdehome\tools dir) to create the SDE user, Schema and set permissions. I then used the post install to 'authorize' SDE and then create the 'repository'. Next was the command line to create the service. The big thing here is the -n option, which tells the sde service not to depend on the Oracle service to start. Since Oracle wasn't on this server, thats obviously pretty important. Now, the only tough part...When I couldn't get the ArcSDE service to start, I went searching. I was luck to find this ESRI Kb article, that outlined the mod in the SDEHOME\etc\dbinit.sde file that I needed to make (set LOCAL=netservicename). Too bad I didnt find that article before, because its quite good.

Jason Harris


Jason Harris - Wednesday, September 07, 2005

After some initial reservations about doing a project based on Routemap IMS, I am happy to report that Routemap is a great product. Other folks here in our office have done a few routemap projects over the years, but this was the first one we have done in Coldfusion. It is a very database intensive site, so we thought that Coldfusion would be the best fit for this particular project.

I am an ArcIMS guy. I work with ArcIMS all the time and I love it. So when this project got pegged to me, I will admit, I went kicking and screaming. But, I will be the first to admit that it has been a pleasure to work with, its fast, efficient and makes very nice looking maps. So, I just thought I would share a quick little snippet of code to show you how to make the inital connection to Routemap:

<cfobject action="CREATE" type="JAVA" class="com.esri.rmims.IMSConnection" name="RMIMSCONNECTION">
<cfset RMIMSCONNECTION.setConnectionURL("http://itchy/Scripts/webgate.dll")>
<cfset RMIMSCONNECTION.setGroup("TEST")>
<cfset RMIMSCONNECTION.setUserName("TEST")>
<cfset RMIMSCONNECTION.setUserPassword("TEST")>
<cfset MapTemplate = RMIMSCONNECTION.loadMap("#APPLICATION.MapService#")>

Thats really it. After, you can do just simple stuff like zoom out:


So, if anyone is hesitant to take on something new like Routemap, I would encourage you to give it a try.

Jason Harris

ArcWeb Services Examples

Jason Harris - Friday, August 26, 2005
Jeremey Bartley passed this blog along to me. Jeremey has been doing lots of work with Coldfusion and ArcWeb services. Anyway, this guy is the team lead for ArcWeb services at ESRI. Good stuff.

Jason Harris


Jason Harris - Friday, August 19, 2005

Well, now that everyone and their mother has seen Googlemaps, all I keep hear from my clients is "can you make it pan like googlemaps?". To be honest, I had thought about doing something exaclty like it several years back, but dismissed the idea thinking no one would really want that anyway. Boy, was I wrong.

So, I thought I'd investigate the possibiity of making my own fancy pan function. I suppose if I had 3 gazillion dollars like google, I could make it do whatever I want. So, it looks like its being done with some kind of AJAX implementation.

I have heard some rumblings about the new ArcExlorer client using AJAX, but I was wondering if there is anyone out there doing this with ArcIMS yet? If not, its inevitable that we'll see one soon. If you have doing some experimenting already with AJAX/ARCIMS, I'd like to hear from you.

Jason Harris

Adding more ArcSDE Connections

Jason Harris - Friday, August 05, 2005

As we all probably know, ArcIMS and other ESRI products eat lots and lots of ArcSDE connections. Sometimes ArcSDE can even (gasp) leave orphaned connections out there. To overcome these issues, I always bump up my number of available connections.

I find myself refering to these instructions, emailing them, talking people through this over the phone, etc, quite often. This is a huge deal, but I don't feel that ESRI has stressed this enough. It used to be totally undocumented but now it is mentioned in the Config and Tuning guide for Sql Server and there is a knowledge base article found here. But, I thought I would post the info here just as a friendly reminder.

First, bump up the allocated memory: The size of the interactive and non-interactive desktop heaps is determined by a registry setting under \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\SubSystems. Within the 'Windows' string value, there is a 'SharedSection' parameter that by default should read: SharedSection=1024,3076,512 Change the 512 to 1024

To bump up the number of available SDE connections, you need to now edit the SDE_server_config table-->prop_name-->connections change that value to the number of connections you need. Don't go overboard - just add what you need to be safe. See my previous posting for more info on how to do this.

Jason Harris

Integrating ArcIMS With ArcGIS Server

Jason Harris - Friday, August 05, 2005

Hey All...Just wanted to give you Southeast folks a quick heads up on a little demonstration that we will be giving on Integrating ArcIMS With ArcGIS Server. Its going to be Tuesday, August 30th in Atlanta.

For a long time, well since 1999 I guess when we got our hands on the first ArcIMS Alpha release, we have been trying to figure out how to get more out of ArcIMS. From trying the good old buffer distance=0 trick to inserting points into ArcSDE to creating shapefiles from your VML drawings. ArcIMS is a fantastic product, but its just not capable of some of the more advanced things that people are now expecting...Well its not capable without violating your ESRI terms of use I should say.

So, now we have many more options with ArcGIS Server. Mixing the 2 products throughout the organization is going to become the hot topic in the future.

Some of the likely topics include:

* Using ArcGIS Server generated webservices through ArcIMS * Advanced backed editing * Mixing ArcServer Clients with ArcIMS clients throughout an organization * Real spatial analysis

Jason Harris

ESRI User Conference In Full Swing

Jason Harris - Wednesday, July 27, 2005

Well, I suppose by now the conference is in full swing. Unfortunatley, I couldn't make it this year. But, after working on a grueling Routemap IMS Coldfusion project (yes, you did read that correct), I have decided to take a few days off and have a couple of my college buddies who I haven't seen in a while come down to visit.

I trust all you guys will let me know how the conference is going. I am especially interested to hear how the Coldfusion Arcims Users Group meeting went.

Jason Harris

Coldfusion ArcIMS Users Group Meeting

Jason Harris - Monday, July 18, 2005

Hey all, unfortunately, I can't make it to this years meeting at the user conference, but fellow Coldfusion developer (and the creator of mapdex.org), Jeremy Bartley will be running the show. Here are the details of the meeting from Jeremy:

Fellow CF/ArcIMS developer-

You don't know me, but I am in charge of putting together the third annual ArcIMS-CF users group get-together at the ESRI users conference this year. The meeting will be on Thursday July 28 from 12:15-1:15 in room 3 (SDCC). We are pleased this year to have Mike Nimer of Macromedia attend our session. Mike is a ColdFusion MX engineer with experience building GIS applications. Mike also has extensive experience with CF Flash Forms that he can share with us. Margaret Lyszkiewicz from the ArcIMS development team at ESRI will also join us. Margaret is an accomplished developer who has been carrying the CF flag at ESRI for years. We are honored to have Mike and Margaret at our meeting this year. This is your chance to give advice to the developers of the software you use most (CF and ArcIMS).

Don’t miss it!

Jason Harris

ArcIMS Tomcat on Windows 2003 - Redirector Issue

Jason Harris - Thursday, July 14, 2005

Hey there everyone. If you are like me, you have at one time or another in the past struggled with getting Tomcat to work on your IIs based machine. Just the other day, I struggled with an install, only to give up in frustration.

The specs were: Windows Server 2003 standard Tomcat 5.028 ArcIMS 9.1

No matter what I did I couldn't get this thing to redirect to IIs. Port 8080 worked like a champ, so I knew Tomcat itself was ok. There is just something funky with iis6 I suppose. Anyway, a coworker of mine, Big LU took over the install, and late last night, he was able to get it going. He used the attached guide to help him through the install. I wish I knew where this guide came from so that we could give them proper credit, but I just don't know.

So, if you are one of those folks currently struggling with the Tomcat redirector issue, check out this guide: Click the download link below.

Jason Harris

Santa Rosa County Florida - Hurricane Map Search

Jason Harris - Sunday, July 10, 2005
One of our clients, Santa Rosa County, Florida was ground zero for hurricane Dennis. This has been a tough tropical season for them already. I recently visited onsite with them, and they were still recovering from hurricane Ivan last season. Lucky for the citizens there, they have a very proactive county goverment in place. I know many of the county employees were working sleepless nights making sure that everything would be ready for the recovery effort that is ahead of them. The Hurricane Evacuation Map Search site that we developed and host for them was lit up like a christmas tree all weekend. I'm glad that we were able to help out in this time of need for them....All you Santa Rosa County residents - hang in there!

Jason Harris

Recent Posts



All content © ROK / Website by Hazel Digital Media