Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database not open after reboot

jymarkusgMar 5 2012 — edited Mar 5 2012
Hi!

I've installed oracle 11.2 database on a windows xp sp3 box. My box is part of an active directory domain and has a dynamic ip (class c address). Everything works fine - the database and listener get started autmatically on booting.

After switching to a static ip address without changing (class a address (10.1.1.12 for example)) the hostname the database doesn't get open after booting. When I log on in sqlplus as sysdba I can open the db without any error. Firstly I thought it's a hostname resolution problem. So I entered "localhost" and afterwards the static ip in listener.ora. But the database wasn't open after booting.

After disabling "netbios over tcp/ip" in the wins tab of the advanced ip configuration dialog, the database is opened after booting again (with original listener.ora).

Has anyone an idea why?

Thanks
Markus
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2012
Added on Mar 5 2012
2 comments
224 views