Hi!
I really hope someone can help me.
I had a fully functional oracle database 11.2.0.4 ( windows 2012). I changed the ip and server name and rebooted. When the server came back up I restarted the oracle service. I then started the listener service. The listener service would not start. I realize I forgot to change the tnsnames file. So I changed the tns to use my new host name but there seems to be a problem with the listener.
When I deleted the listener is took forever before it came back and said it was deleted.
When I try to recreate the listener it says there already is a listener with this name.
Right now I have NO Listener window service.
If I try to create listener with a new name it says the port is in use. I even booted the server but port is always in use.
It looks like listener still thinks the server name is 99walnut when it should be my new name.
"lstnrctl status" shows the old HOST name and errors:
C:\Users\operatorw>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 16-JUN-2014 13:42:42
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=99walnut.oak.local)(PORT=1521)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
64-bit Windows Error: 60: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory
C:\Users\operatorw>
Does anyone have any ideas on how I fix this?
Thanks!
Kathie