Re: OracleXE 10g listener service can't start after server joined domain and changed computer name.

On Apr 16, 9:28 am, gazzag <gar..._at_jamms.org> wrote:
> On 16 Apr, 14:06, Amber <guxiaobo1..._at_gmail.com> wrote:
>
> > There is not any logs appended to listener.org since the server was
> > renamed. Now I am using VMWare Converter to convert the physical
> > machine to a virtual machine, then try to rename the virtual machine
> > to the origial one, hoping I can recove the database:(
>
> I thought you said that you can start the database?  If so, try the
> following at a command prompt:
>
> set ORACLE_SID=XE
>
> sqlplus / as sysdba
>
> Copy and paste the output you get here.
>
> HTH
>
> -g

Also you might want to check and make sure:

1. Your listener.ora file has the correct new hostname
2. That if you ping the hostname that it is resolving via DNS to the correct machine & that nothing in your c:\windows\system32\drivers\etc \hosts file is pointing to the wrong ip address.
3. That the local listener, if configured, is pointing to the correct tnsnames.ora entry
4. Check the tnsnames.ora file for the same issue as #2 above
5. Make sure, if you have multiple oracle home directories that are not being used that Oracle isn't using an old or wrong tnsnames.ora file.
6. Make sure that the directory ownership/permissions have not been changed or that the user you are logging in as has the proper permissions.

Not sure if that will help or not but those are some things I would check in this case. And I agree - posting any error messages would be helpful.

One last thing. It's been a while since I've worked on Oracle on Windows but I'd also 1) check your Windows logs if you haven't already to see if you can garner any information there. There's also a way to change the service I believe so you can see it's output while starting which may be helpful. Received on Wed Apr 16 2008 - 10:47:33 CDT