First, RDBMS based http and OEM will not work without SCAN address on a
RAC db. Second, with the requirement to put SCAN into DNS, DBA can no
longer install RAC without any help, the person who maintains the DNS
server, usually not DBA, will need to configure it.

I am not aware that anybody was requesting SCAN address, it's a
convenience, an endpoint for programmers to tie their services to, not
something that would help the user. Making a mess of the installation and
and making the SCAN address mandatory is infuriating, especially when
having in mind that this is done so it's safer to use cheap Elbonian
programmers. That is the reason for adding an additional level of
complexity to otherwise already convoluted, buggy and complex RAC
installation. In 10g, RAC installation became a form of black art. In
11g Oracle Corp. added more complexity to already convoluted and complex
environment, with even less real documentation.
The real question is whether this complexity has paid off? What did RAC
10g and RAC 11g provide that RAC 9i couldn't have provided? The answer is
ASM. The real purpose of ASM is to block the competition. Competitors can
and will use OCFS but competitors cannot use ASM. Thus the complexity.
Now, we got SCAN address requirement, which is infuriating. I didn't even
mention the idiotic multicast flop, which belongs to the same category.


--
http://mgogala.byethost5.com

On Sun, 07 Aug 2011 08:38:26 +0000, Mladen Gogala wrote:

I tried redirecting it with DBMS_XDB.SETLISTENERENDPOINT to VIP hostname,
but to no avail. It still didn't register with the listener. My
conclusion is that SCAN is being rammed down our throats. I will hack
around it.



--
http://mgogala.byethost5.com

On Aug 7, 2:16*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
you do know that you don't NEED SCAN, right? you can still start the
default listeners, the same way as before. SCAN is more analogous to a
cluster-alias (remember DEC/VMS clustering?? ) As for the install of
SCAN, you can use a single IP address in the /etc/hosts file to get it
installed and add the DNS later. (been there, done that on many
installations - it just ain't that hard).

Just curious, why would one use OCFS if they are not using Oracle? No
other database can have an active-active cluster database - it is more
than just access to the database files. There are locking mechanisms
to prevent one db node from over-writing what another db node just
wrote at nearly the same time.

I have been using ASM for quite some time now and on some very
sizeable databases. I was a dba in a fairly well-known telco and used
ASM on a 380TB data warehouse on a multi-node SUN 6900 cluster. The
management of this sort of beast without ASM and ASSM, OMFand LMT,
would be nearly impossible to keep one's sanity. We even moved the
ASM devices from one storage vendor to another online while adding 1TB/
day. Try that with any other database or file system. I have seen
many attempts using SAN storage tools - mostly failed (search for the
recent story on Amazon's cloud fiasco when they tried to move to new
storage online - their some x000 clients were without their data for
more than 36 hours while they recovered.)

as for the "infuriating" , have you not heard of DBA2.0. If you are
not a DBA 2.0, you need to work in that direction. DBA2.0 is a SYS/
NET/SAN/DB Admin all rolled into one... Not to mention that being a
DBA2.0, you really start to understand the "system" not just our
little world of databases.

On Wed, 10 Aug 2011 16:02:04 -0700, onedbguru wrote:


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.checkListenerStat usForDBControl
(Para
msManager.java:3342)
at oracle.sysman.emcp.EMDBPreConfig.performConfigurat ion
(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.com
Listener 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.3 3.30)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.3 3.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.com
Listener 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=EXTPROC15 21)))
(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 @#$%! 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: --------------------------------------------

On Aug 10, 4:02*pm, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:

DBA 2.0 is so 2006.

jg
--
@home.com is bogus.
Or 2001 http://www-personal.umich.edu/~beattie/dba/dbarrev.html