Oracle XE 11.2.0 64-bit
Linux CentOS 6.2 64-bit
After installing and configuring Oracle XE, the configure script states that the listener configuration is done. But the database is not available and the listener is not started.
Trying to manually start listener generates the following error message:
TNSLSNR for Linux: Version 188.8.131.52.0 - Production
NL-00280: error creating log stream /u01/app/oracle/product/11.2.0/xe/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Linux Error: 13: Permission denied
Listener failed to start. See the error message(s) above...
Pl be aware that CentOS is not a supported distro for XE - http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#BABGGAJA - so things may or may nor work as expected.
What OS account are you using to start up the services ? What are the owners/permissions on file /u01/app/oracle/product/11.2.0/xe/network/log/listener.log ?
Since I did the install as 'root', that is the user I am using.
One added note: The configuration script that follows the install has to be run as 'root', as I am certain you know already. The configuration script states that the listener has been configured but then fails when configuring the database. Logs show the database not available and when I look to see if the listener is available, it also is not started.
You should not use root to start up any Oracle services - root is only used for the purposes of installation.
Pl follow the documented steps to start up the listener and the database - http://docs.oracle.com/cd/E17781_01/server.112/e18804/startup.htm#CHDGJGHB
I agree with you. But the configuration script which is run after installing Oracle XE on Linux specifically asks that the script be run as 'root' and it tries to configure and start both the listener and database. The database does not get configured on my system and the listener is not up and running when the script completes.
Could be wrong but as far as I can recall an XE installtion on Linux/Centos runs as user root ....... but autmatically creates a user Oracle (with group dba ) which becomes software owner.
After that manual tasks like starting/stopping database and listener should be done as user oracle.
You can restart the entire oracle stack (db and listenert ) using
service oracle-xe start ( or stop/status/restart)
the service command should be run as user root
Edited by: Bas de Klerk on 23-feb-2013 5:14