register/install XE to fixed ip-address
469927Dec 16 2005 — edited Dec 16 2005Hallo,
i would like to make sure, that oracle XE is registering it's services to an specified, fixed ip-address. In a second step I would like to switch the XE-instance to another ip-address/dns-name on the same interface (e.a. 192.168.2.15 / ora02). Maybe it is much easier to solve step 2 before step 1 by editing some of the config files - any hints are very welcome :-)
Here is what I have done till now.
I have installed XE and after that I edited all *.ora files and substitute alle occurence of (in my case) ora01 or ora01.insite with the corresponding ip-address 192.168.2.11.
The listener is still "knowing" ora01 and ora01.insite as the logfile shows:
this is the part of the logfile when starting the listener:
TNSLSNR for Linux: Version 10.2.0.1.0 - Beta on 16-DEC-2005 13:16:11
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0
Started with pid=21310
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.11)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
16-DEC-2005 13:16:11 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ora01)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
this is the part of the logfile when I start the database:
16-DEC-2005 13:17:39 * service_register * XE * 0
16-DEC-2005 13:17:39 * service_update * XE * 0
16-DEC-2005 13:17:44 * service_update * XE * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora01.insite)(PORT=8080))(Presentation=HTTP)(Session=RAW))
16-DEC-2005 13:17:47 * service_update * XE * 0
16-DEC-2005 13:17:50 * service_update * XE * 0
as you can see, there are some occurences of ora01 and ora01.insite. Where do I have to fix this.
Thanks in advance