After installing apex front end is not opening
SOLUTION:
This is because dispatchers parameter hasn’t set.
STEPS:
SQL> select value from v$parameter where name = ‘dispatchers’;
VALUE
——————————————————————————–
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string FERRARI_LOCAL
SQL> select name from v$database;
NAME
———
FERRARI
SQL> !lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 19-DEC-2018 15:18:07
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
————————
Alias FERRARI
Version TNSLSNR for Linux: Version 12.1.0.2.0 – Production
Start Date 22-OCT-2018 12:20:59
Uptime 58 days 2 hr. 57 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/FERRARI/db/12.1.0/network/admin/FERRARI_ferrari/listener.ora
Listener Log File /u01/FERRARI/db/12.1.0/admin/FERRARI_ferrari/diag/tnslsnr/ferrari/ferrari/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ferrari.xyz.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ferrari.xyz.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary…
Service “FERRARI” has 2 instance(s).
Instance “FERRARI”, status UNKNOWN, has 1 handler(s) for this service…
Instance “FERRARI”, status READY, has 1 handler(s) for this service…
Service “FERRARI_ebs_patch” has 1 instance(s).
Instance “FERRARI”, status READY, has 1 handler(s) for this service…
Service “ebs_patch” has 1 instance(s).
Instance “FERRARI”, status READY, has 1 handler(s) for this service…
The command completed successfully
SQL> alter system set dispatchers = “(PROTOCOL=TCP) (SERVICE=ferrariXDB)” scope=both;
System altered.
SQL> show parameter dispatc
NAME TYPE VALUE
———————————— ———– ——————————
dispatchers string (PROTOCOL=TCP) (SERVICE=ferrar
iXDB)
max_dispatchers integer
SQL> select comp_name, status, version from DBA_REGISTRY
where comp_name=’Oracle XML Database’;
2
COMP_NAME
——————————————————————————–
STATUS VERSION
——————————————– ——————————
Oracle XML Database
VALID 12.1.0.2.0
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string FERRARI_LOCAL
SQL> show parameter local_listener
NAME TYPE VALUE
———————————— ———– ——————————
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=f
errari.xyz.com)(port=
1521))
