XDB Service not showing in lsnrctl status
- From: "Ramon Estevez" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "r_estevez@xxxxxxxxx" for DMARC)
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 8 Jun 2014 08:15:15 -0700 (PDT)
Hi lists,
I have this problem accessing apex in my 11.2.0.2 DB in Centos Linux, when I
try to access the page http://1.1.1.1:8090/apex I get error could not to
connect to address 1.1.1.1:8090.
This is the setup in the DB:
dispatchers = "(PROTOCOL=TCP) (SERVICE=MYDBXDB)"
shared_servers = 10
local_listener = "(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1521))"
The output of lsnrctl stat is:
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-JUN-2014 11:12:33
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 08-JUN-2014 10:55:48
Uptime 0 days 0 hr. 16 min. 45 sec
Trace Level off
Security ON:
Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/11g/db/network/admin/listener.ora
Listener Log File
/u01/app/oracle/diag/tnslsnr/myserver/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.2)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=1523)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "MYDB" has 1 instance(s).
Instance "MYDB", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The listener.ora file is
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.5)(PORT = 1523))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11g/db)
(PROGRAM = extproc) )
(SID_DESC =
(GLOBAL_DBNAME = IBOR)
(ORACLE_HOME = /u01/app/oracle/product/11g/db)
(SID_NAME = IBOR) ) )
LIST_IBMSF =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.4)(PORT = 1522)) ) )
SID_LIST_LIST_IBMSF =
(SID_LIST =
(SID_DESC =
(SID_NAME = IBMSF)
(ORACLE_HOME = /u01/app/oracle/product/11g/db)
(PROGRAM = dg4odbc)
(ENV="LD_LIBRARY_PATH=/usr/local/easysoft/unixODBC/lib:/usr/local/easysoft/lib:/u01/app/oracle/product/11g/db/lib")
) )
I have 2 listeners 1 for Oracle database and the other for Sql Server DB. In
the Oracle DB I have 2 IP address each point to a different ports.
I don't know why the XDB service is not showing UP in the lsnrctl stat and I
suppose that's why I cant connect to APEX.
TIA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » XDB Service not showing in lsnrctl status - Ramon Estevez
