Re: SCAN address
Date: Thu, 11 Aug 2011 03:29:17 +0000 (UTC)
Message-ID: <j1viad$o4n$1_at_solani.org>
On Wed, 10 Aug 2011 16:02:04 -0700, onedbguru wrote:
> you do know that you don't NEED SCAN, right? you can still start the > default listeners, the same way as before.
Wrong. You definitely do need it:
SEVERE: Scan Listener is not up or database service is not registered with
it. S
tart the Scan Listener and register database service and run EM
Configuration As
sistant again .
Refer to the log file at /ORACLE/base/cfgtoollogs/dbca/vms_p/emConfig.log
for mo
re details.
Aug 7, 2011 3:41:19 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Scan Listener is not up or
datab
ase service is not registered with it. Start the Scan Listener and
register data
base service and run EM Configuration Assistant again .
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl
(Para
msManager.java:3342)
at oracle.sysman.emcp.EMDBPreConfig.performConfiguration (EMDBPreConfig.
Of course, I could do it with emca directly, but emca is not the problem. The problem is a built-in HTTP which also doesn't start without scan. I need that in order to start Apex. Listener is running, instances are properly registered and the DB is OK:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
local_listener string (DESCRIPTION=
(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)
(HOST=10.1
01.33.32)(PORT=1521))))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 06-AUG-2011 20:40:47 Uptime 4 days 2 hr. 39 min. 25 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service vms_p.vmsinfo.comListener Parameter File /ORACLE/product/11.2.0/grid/network/admin/ listener.ora
Listener Log File /ORACLE/product/11.2.0/grid/log/diag/tnslsnr/lpo- oracle-01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.33.30)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.33.32)(PORT=1521)))
Services Summary...
Service "vms_p.vmsinfo.com" has 2 instance(s). Instance "vmsp1", status READY, has 1 handler(s) for this service... Instance "vmsp2", status READY, has 1 handler(s) for this service... The command completed successfully
-bash-3.00$
-bash-3.00$ srvctl status database -d vms_p Instance vmsp1 is running on node lpo-oracle-01 Instance vmsp2 is running on node lpo-oracle-02 -bash-3.00$
Now, this is what listener supports on another DB, which is not RAC:
Uptime 19 days 2 hr. 34 min. 59 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service mcst.vmsinfo.comListener Parameter File /software/oracle/base/product/11.2.0/dbhome01/ network/admin/listener.ora
Listener Log File /software/oracle/base/diag/tnslsnr/oracle2a/ listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle2a)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle2a)(PORT=7777))
(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle2a)(PORT=2121))
(Presentation=FTP)(Session=RAW))
Services Summary...
Service "MCSTXDB.vmsinfo.com" has 1 instance(s). Instance "MCST", status READY, has 1 handler(s) for this service... Service "mcst.vmsinfo.com" has 2 instance(s). Instance "MCST", status UNKNOWN, has 1 handler(s) for this service... Instance "MCST", status READY, has 1 handler(s) for this service... The command completed successfully
Do you notice slight difference? There is Apex on oracle2a, port 7777, no problems whatsoever. I am not going to put SCAN on this RAC in the DNS because it's just temporary. The next week the build of 64 machines to which I will move them will be complete and those will be in DNS. I had to hack around this _at_#$%! SCAN interface mess in order to enable users to use their applications while I am waiting for the new 64 bit machines.
-- Harry Potter in 1D: --------------------------------------------Received on Wed Aug 10 2011 - 22:29:17 CDT