Home > Default > Oracle 11g XE listener does not start automatically during boot

Oracle 11g XE listener does not start automatically during boot

November 30Hits:0
Advertisement
Hi,
This happened to me recently I just wanted to share it with you.
For development I was running Standard Edition, at some point I decided to run also XE on the same server for another reasons. Everything was working fine, except that after restart of the server, the XE listener is not starting automatically. Debugging the startup script I found that this happens because of a bug in the code, which assumes that XE listener is running if it finds the word LISTENER within the processes list. I didn't found any obligation in the docs for running XE without any other databases on the same host.
In file /etc/init.d/oracle-xe, at line 556 the code is failing:
1     + status='oracle 2889 1 0 May13 ? 00:00:05 /oracle/ora112se/bin/tnslsnr LISTENER -inherit'
2     + '[' 'oracle 2889 1 0 May13 ? 00:00:05 /oracle/ora112se/bin/tnslsnr LISTENER -inherit' == '' ']'
As you can see I have another listener(the one for SE) running and because of the XE startup script found the keyword LISTENER it’s supposing that the XE LISTENER is already running.
To fix this simply change line 556 from:
1     status=`ps -ef | grep tns | grep oracle`
To:
1     status=`ps -ef | grep tns | grep oracle | grep xe`
Now XE listener is started automatically during boot.
Sve
Blog: http://sve.to
Twitter: sgyurov

Answers

I though the same thing, but XE LISTENER is running on localhost and port 1522. On the other hand XE have local_listener explicitly set to the very same connection descriptor. Even XE installation was second on this server.
I've could change that yes, but the startup script doesn't seemed to have this mind.
Regards,
Sve

Read other 3 answers

Tags:

Related Articles

  • Oracle 11g XE listener does not start automatically during bootNovember 30

    Hi, This happened to me recently I just wanted to share it with you. For development I was running Standard Edition, at some point I decided to run also XE on the same server for another reasons. Everything was working fine, except that after restart

  • Oracle 11g R1: How to create indexes automatically in tablespaces?November 30

    Hello, Obviously, due to maintenance and performance reasons it is better to put indexes in own tablespaces, separated from the data. I would like to know now whether there is a way under Oracle 11g R1 to create every index automatically in a tablesp

  • Can not open database control in oracle 11g r2, listener issuesOctober 11

    Hi, I installed Oracle 11g r2 database on my laptop for testing. at beginning everything was fine and working. 2 days later i am unable to run oracle database control.. i get page not found! I tried all the tricks and read almost 200 pages from oracl

  • Oracle 11g Express: listener/DB stopped regularly ...October 11

    Dear all, we currently use oracle DB 11g express edition on Win XP in order to do nigthly test of our product accessing the DB via a JDBC driver. After two successful nightly test communicating via JDBC doesn't work anymore due to stopped DB listener

  • Oracle 11g database Listening PortNovember 30

    Hi, It can allow only 127.0.0.1 through this port that is localhost. "TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING" how can i create one more IP LISTENING port. I want to access my db using ip address without(localhost) Kindly help. The below format:

  • Oracle 11g automatic archival // maintaining historic dataNovember 30

    Hi Group, We are planning to get Oracle 11g. I want to know if Oracle 11g has the capability to do automatic archival? My requirement is, few of the tables in our application will have lot of records (data) and after some days/ months it might slog t

  • Oracle 11g listener issueNovember 30

    Hello, I have installed oracle 11g on windows 7. Installation and database creation was successfull but after creating database listener should automatically up and start but i am not able to listener in the services window and not able to conntest d

  • Does listener log file need to be purged in Oracle 11g DBNovember 30

    We have the Oracle 11g database setup. I have a query as to if it is required to purge the listener log file in Oracle 11g database. I believe that the size of the listener log file is infinite and we need to manually purge the listener log file or i

  • Installation of Oracle 11g on RHEL 5 (Listener cannot start )October 11

    Hello, I have install Oracle 11g on my linux RHEL5. The installation was succesfull but cannot start the listener. The configuration of even the EM at the end of the installation for the same reason , Listener not started. Trying to connect to my Lis

  • TNS Listener -ORA-12514 error following database shutdown - Oracle 11gOctober 11

    Hi I have hit a problem with my oracle development database. When in sqlplus I executed the shutdown command, but nothing happened for several minutes and it was just hanging. No messages were displayed to the screen. The only thing was to close the

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.596 s.