Tuesday, November 08, 2005

Oracle Express Edition: two strikes, the pitcher steps up to the plate...

The world is divided into two groups of people: those for whom installing Oracle Express edition has been a piece of cake and those for whom it's been a flipping nightmare. Unfortunately I find myself in the latter group.

The first problem was the install spinning when it was trying to create the XE services. CPU meter up to 100% for as long as you like. This turned out to be an artefact of having NLS_LANG set to UK English. All that was required was settting to American_America.WE8ISO8859P1. Ooops! We might have thought that offshoring so much development and support work would have alerted Oracle to globalisation but apparently not.

Having got past that the second problem rears its ugly head. I now have an instance but no data files. Each time the scripts tried to connect to the database the failed with ORA-12557: TNS:protocol adapter not loadable. This is a rara avis; the only note on Metalink relates to Grid controllers, which doesn't seem to fit the case here, and Google likewise draws a blank. Let's hope Mike Townsend comes up with something.

Before you Linuxen start smirking this is not particularly a Windows problem: I was able to install XE on my home laptop first time. My home machine is lower spec but same operating system so it's something about the specific configuration of my work machine that's giving me grief. I am only persevering with this because if I ever need XE, I will need it on my work machine.

Although I must admit I am starting to get very tired with the process: it requires several manual steps - editing the registry, renaming files, two reboots - to clear down XE prior to re-installing. However, I have just discovered that if I re-run the MSI against an untouched install it asks if I want to uninstall XE. I wish I known this earlier: the Installation guide talks about using Add/Remove Programs in the Control Panel but that option only appears once the installation has passed the Services point. Of course, the MSI uninstall option may also only be triggered if the prior install got to that point. I'm afraid I lack the strength to de- and re-install just to find out.

So what have I learnt so far? Not a lot. I've spent hours, literally hours, trying to install XE on my work machine with no success. I certainly haven't had time to build an app on my home machine. I do know two things. One is that the MSDE team is not yet quaking in their boots. The other is that I don't think this blog is likely to appear in the 10XE User Experiences any time soon.

7 Comments:

Blogger Barry Cooper said...

I don't suppose going back to a system restore point prior to the install will help?

I created a restore point prior to installing XE on my laptop, just in case anything went a-over-t!

8 November 2005 04:13:00 GMT-8  
Anonymous Anonymous said...

1. It's a BETA
2. It installed fine on my machine which is pretty good considering it is a beta.

8 November 2005 07:23:00 GMT-8  
Blogger APC said...

>> 2. It installed fine on my machine

Well congratulations. As I said it also installed fine on my home machine.

The point of my article, which I obviously failed to make clear and I apologise for that failure, is that installing XE is either pretty simple or jolly complex. As Oracle are marketing XE as a "deploy and forget" database they need to work on smoothing the troublesome deployments.

For instance, one of the problems I experienced is the Instant Client issue. There's probably a lot of people in their target demographic who have Active State Perl on their desktops, and a lot of them are going to favour a database that works with Perl. I believe that is one bug that Oracle have now fixed.

9 November 2005 09:54:00 GMT-8  
Blogger richard said...

I too have had many problems

- one work machine went fine. Came back a week later - Oracle would finid it's home page! Finally got fed up installing it on this server and opted for my desktop PC.

- problem 2 - this one just won't connect using the starting HTML page. services say it is running fine but get "web page not found" - no sign of any dbf files so dunno.

Since my background is SQL Server - if you compare this SQL Desktop - SQL Desktop comes out the clear winner!

26 April 2006 12:00:00 GMT-7  
Anonymous Anonymous said...

I've hit success on one out of three machines myself. The two machines that failed already had an Oracle 9i Client installed and one of those was running tomcat. In those cases I'm thinking that the install script has problems with the fact that port 8080 is already in use and even though I've selected another port (8081) there still seem to be some conflicts because my TNSListener service won't start (actually starts but immediately stops with no actual error message) and the database homepage won't load. Our company guru says this is because parts of XE are still attempting to run on port 8080 and if I spend enough time hunting through the registry changing the ports for XE it will eventually work.

The one machine that worked was one that did NOT have either Oracle clients or Tomcat installed and therefore was able to take all of the defaults as is and run. Even then the web based admin screen are horribly slow and of course I don't have Toad installed on that machine so have to either use free Toad or the mind-numbingly slow web interface.

Anyways I'd have to agree that Oracle still needs help on their install scripts. Better than the 9i installer but considering the fact that as soon as one default is changed the installer fails I think they have a lot of room for improvement.

23 May 2006 07:24:00 GMT-7  
Anonymous Anonymous said...

情趣用品,情趣用品,情趣用品,情趣用品,情趣用品,情趣,情趣,情趣,情趣,情人歡愉用品,情趣用品,AIO交友愛情館,情人歡愉用品,美女視訊,情色交友,視訊交友,辣妹視訊,美女交友,嘟嘟成人網,按摩棒,震動按摩棒,微調按摩棒,情趣按摩棒,逼真按摩棒,G點,跳蛋,跳蛋,跳蛋,性感內衣,飛機杯,充氣娃娃,情趣娃娃,角色扮演,性感睡衣,SM,潤滑液,威而柔,香水,精油,芳香精油,自慰,自慰套,性感吊帶襪,情趣用品加盟,情人節禮物,情人節,吊帶襪,成人網站,AIO交友愛情館,情色,情色貼圖,情色文學,情色交友,色情聊天室,色情小說,七夕情人節,色情,A片,A片下載,免費A片,免費A片下載,情色電影,色情網站,辣妹視訊,視訊聊天室,情色視訊,免費視訊聊天,視訊聊天,美女視訊,視訊美女,美女交友,美女,情色交友,成人交友,自拍,本土自拍,情人視訊網,視訊交友90739,生日禮物,情色論壇,正妹牆,正妹,成人網站,A片,免費A片,A片下載,免費A片下載,AV女優,成人影片,色情A片,成人論壇,情趣,免費成人影片,成人電影,成人影城,愛情公寓,色情影片,保險套,舊情人,微風成人,成人,成人遊戲,成人光碟,色情遊戲,跳蛋,按摩棒,一夜情,男同志聊天室,肛交,口交,性交,援交,免費視訊交友,視訊交友,一葉情貼圖片區,性愛,視訊,嘟嘟成人網

愛情公寓,情色,舊情人,情色貼圖,情色文學,情色交友,色情聊天室,色情小說,一葉情貼圖片區,情色小說,色情,色情遊戲,情色視訊,情色電影,aio交友愛情館,色情a片,一夜情,辣妹視訊,視訊聊天室,免費視訊聊天,免費視訊,視訊,視訊美女,美女視訊,視訊交友,視訊聊天,免費視訊聊天室,情人視訊網,影音視訊聊天室,視訊交友90739,成人影片,成人交友,美女交友,微風成人,嘟嘟成人網,成人貼圖,成人電影,A片

11 October 2008 09:30:00 GMT-7  
Blogger Jerry said...

cheap wedding gowns
discount bridal gowns
China wedding dresses
discount designer wedding dresses
China wedding online store
plus size wedding dresses
cheap informal wedding dresses
junior bridesmaid dresses
cheap bridesmaid dresses
maternity bridesmaid dresses
discount flower girl gowns
cheap prom dresses
party dresses
evening dresses
mother of the bride dresses
special occasion dresses
cheap quinceanera dresses
hot red wedding dresses

18 June 2009 08:40:00 GMT-7  

Post a Comment

<< Home