I am checking out a laptop on which Personal Oracle 10g is installed.
Unfortunately, I cannot log into the db, and checking Windows services, I see that two are not started: OracleDBConsoleorcl and OracleOraDb10g_home1TNSListener
Attempting to start them returns error messages. Digging further, I see tnsnames files and other places, the database HostName is the IP address to which (I assume) this laptop was using at the time the db was installed. The "Database Control - orcl" startup shortcut even references URL "http://nnn.nnn.nnn.nnn:1158/em" (where the nnn... is the IP address.
Fortunately, I have a working Vista laptop with "Personal Oracle Database 10g Release 10.2.0.3.0" installed and working well. In the good laptop, the hostname is the same as the Windows "computer name."
Searching within C:\oracle\product\10.2.0\ on the bad computer, I find 87 files with that IP address.
The installActions...log file shows:
*** Specify Local Host Name Page***
'nnn.nnn.nnn.nnn'. Received the value from the default settings.
Should I just uninstall and reinstall the db? I am thinking this would be the easiest route to correcting the trouble. Is there a better solution?
Thanks for any and all help.