I wanted to reconfigure my Oracle-XE instance to run the tnslsnr on port 1522 instead of 1521. So as first try I went in and just changed the listener.ora and tnsnames.ora files. But after those changes, the system did not give away a beep when I e.g. called lsnrctrl status.
Solution to this was (on RHEL 5.3):
# mv /etc/sysconfig/oracle-xe /tmp/
# /etc/init.d/oracle-xe configure
The script asked some questions about ports (you can look them up in the copy in /tmp) and the db password etc. And then started the database with the new port.
4 comments:
thanks for this useful post. i finally was able to reconfigure oracle-xe on fedora.
any idea what this will be on ubuntu? as oracle-xe doesnt sit in sysconfig .
I have no idea about ubuntu, but couldn't you search for it via
$ find / -name oracle-xe
?
Hi,
sorry forgot to reply back. i found it. it resides under /etc/defaults/
so, the file path for ubuntu and its derivaties is
/etc/defaults/oracle-xe
Ubuntu 10.10:
/etc/default/oracle-xe
Post a Comment