Skip to Main Content

Oracle Database Express Edition (XE)

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!

register/install XE to fixed ip-address

469927Dec 16 2005 — edited Dec 16 2005
Hallo,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2006
Added on Dec 16 2005
3 comments
466 views