I have seen this error so many times that I thought I would note down the resolution (for me anyway)
When logging into the database you get:
ORA-01034: ORACLE not available. ORA-27101: shared memory realm does not exist
To solve you connect to sqlplus as follows:
sqlplus /nolog
Login in as a sys dba:
connect sys/sys as sysdba
When connected, startup the database using:
startup
The database will startup and can be connected to as normal.
Sitting at a desk for hours a day is not the best thing for your body so in the past few years I have been doing Crossfit at a local gym. It’s been good. The workouts are great and I am much healthier than I was 2 years ago.
When you get in that community people look after each other and help one another during workouts. They also encourage you to try out the huge array of races and competitions there are every month.
With a bunch of friends my wife and I decide that we would do the Spartan Race in Miami. We all know that we would not be the fastest doing it, far from it. We just had one goal: finishing.
The furthest that I have ran is 5k on road so doing 8+ miles on rough terrain with 20+ obstacles was always going to be interesting.
Things looked pretty good up until just after mile 4 during a climb of a cargo net I could feel my calfs (both of them starting to cramp). I got up and down the cargo net just fine but not long after that (probably near 5 miles) both legs cramped on me at the same time. It took a good 15 minutes of gentle persuasion to get them to the point that I could walk again.
After that it was a LONG 3-4 miles walking and doing obstacles to the finish line. I am glad that I did the race and that I finished but it’s shown that I need to do more running. I found the obstacles easy enough (Crossfit trains you for that) but 8+ miles running especially trail running is just not in me right now.
We all still had fun and the beer at the end never tasted better!
Well there you have it. 15 years have gone by and I hardly even noticed it. I have been developing, consulting and a whole host of other tasks in the Mobile GIS world now for 15 years!
Back on January 5th 1998 when I joined Conic Systems Ltd. little did I know that I would be still in this industry.
Times have changed in the GIS industry over the past 15 years. I started developing in VB3 and C++ (can’t even remember what rev number!) using an in-house graphics/GIS engine which still to this day has some great ideas in it. It was the precursor to MapObjects and still has users.
Smallworld was dominant in the utility market at that time and the link between Smallworld and Conic took up the most of my time.
That was working life until, in very quick succession, Tadpole bought Conic and we moved from a proprietary engine to using ArcObjects. I never delved into Avenue programming and have only seen ArcView 3.x about 3 times in my whole life!
Now we are in an age of server based GIS with mobile devices syncing when they can.
Users have moved from laptops to iOS and android devices and expect fit fit purpose applications.
I happened upon the GIS industry and am glad that I did.
I was fed up typing in the IP address of test machines that are on a different domain and dns within my network so decided to work out how to quickly switch to using that DNS when at work and back to dynamic when not.
It turns out to be really simple. The DNS being used is adapter specific which makes sense when you think of VPN and multiple other uses so you will need to know the name of the adpater you are using.
In my case it is “Wireless Network Connection”
netsh interface ip set dns "Wireless Network Connection" static ;
to set it back:
netsh interface ip set dns "Wireless Network Connection" dhcp
netsh should be in your path so this can be run from any directory in the command line.
John Selkirk 