Oracle Database Discussions

I apologize in advance if I've missed something in another forum/thread, or leave out necessary information towards solving this. I tried to be as comprehensive in my research as possible prior to posting.

Here's the story - I have a 10g 10.2.0.1.0 database on Windows XP. It was running fine, until I tried to add DBWS_UTL/10.2.0.3.0 Client... I think?, components to it in order to enable it for Web Services. I followed the tutorial at the following link:

http://www.oracle.com/technology/obe/10gr2_db_single/develop/java/java_otn.htm

... and got down to Instruction #8, just before "Calling the Web Service". It says "Note that there are no errors." Unfortunately, I did have errors... and more unfortunately, I don't still have them handy.

After some testing I realized that not only do database web services not work, but my database was no longer functioning at all. Consultation with coworkers revealed the problem to likely be tied to now having improper version matching (10.2.0.1 versus 10.2.0.3...)

So, I tried upgrading my 10.2.0.1 to 10.2.0.3... and believe I have successfully done that. Every service started up in Windows Services except for "OracleDBConsoleSID", which reported "Error 1053: The service did not respond to the start or control request in a timely fashion" right after the little green timer blocks slowly and steadily filled up to the end.

Some more experimentation with a coworker, the OracleDBConsoleSID service no longer exists in my services list, and the database still doesn't start up.


Things I've tried:

1. Checking my tnsnames.ora and listener.ora files - the proper hostnames and Oracle home are listed.
2. Rebuilding the OracleDBConsole via "emca" commands from command prompt. EMCA responds but the actual commands to reconfigure or rebuild the repository fail out because the database is not responsive.
3. Connecting via my installed applications, Enterprise Manager, SQL Plus, and Command Line - all fail the same way, Error 1034.
4. Reconfiguring/rebuilding my Listener with Net Configuration Assistant - values seem to check out, no positive results.
5. Many many other small/random things mentioned in forums here and elsewhere on the net.


I guess that's it for now, there's plenty more details I could include but I don't want to muddle the post with irrelevant information. Any ideas/help are greatly appreciated, I would just reinstall/start over but I have important data in the database that I don't want to lose.


Thanks,
Greg

Edited by: user10997705 on May 6, 2009 4:47 PM