0 comments Thursday, March 8, 2007

Hi Folks

It was from a while. I didn't write anything in my blogs because I have exam's and a lot of assignment to do.

Today I have to work on Oracle 9i but the service stop immediately after starting. I don't know why but I remembered that I changed the computer name so everything goes wrong after searching I found the answer

You have to change hostname to the new one in the following files.

·       tnsnames.ora

·       sqlnet.ora

·       listener.ora

And delete all *.q file inside network/agent folder

Thanks to Oracle Forum

Have fun