Stephen's Oracle Blog

I installed HTMLDB (off the 10.2 Companion disk) on Solaris today. Install seemed to run OK and at the end it told me that the HTMLDB instance had started and could be accessed at: http://wintermute:7778 When I tried to access it, no joy. Said it couldn't connect. I tried using opmnctl to check the status and found that opmn itself was up but none of the managed services were. Stopping and starting opmn and all it's managed processes produced: $ opmnctl stopall opmnctl: stopping opmn and all managed processes... $ opmnctl startall opmnctl: starting opmn and all managed processes... ================================================================================ opmn id=wintermute:6200 0 of 1 processes started. ias-instance id=IAS-X-wintermute.6299 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ias-component/process-type/process-set: HTTP_Server/HTTP_Server/HTTP_Server Error --> Process (pid=24282) failed to start a managed pr...

I was just having a play around on one of my test/sandpit databases ("small database on a low power machine that I use for testing out scripts &c, no live data and if the database gets destroyed I just have to wipe out the files and create a new one" type of thing). I'd forgotten the SYSDBA password (for sandpit systems I use the SID as the SYSDBA password so don't bother to write it down, for some reason this time I didn't) but needed it (I'm installing HTMLDB to try it out on that machine) so wanted to change it. I had been getting 1 : SQL> conn sys/sbtest@sbtest as sysdba ERROR: ORA-01017: invalid username/password; logon denied as you might expect. I used orapwd to change the password $ cp orapwsbtest orapwsbtest.20060629.bak $ orapwd file=orapwsbtest password=sbtest entries=16 OPW-00005: File with same name exists - please delete or rename $ rm orapwsbtest $ orapwd file=orapwsbtest password=sbtest entries=16 and thought I would be good to go....