Re: Question regarding Network ACLs in 11g DB upgrade

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 14 Jan 2009 09:08:53 -0800 (PST)
Message-ID: <32618.90539.qm_at_web38906.mail.mud.yahoo.com>

XMLDB is on the regular database install disk. You may have installed it already. If you have an account called XDB or if you can describe resource_view then you have it installed. There is a view that will show if it's installed too, but off the top of my head I don't remember what it is called.

There is an Oracle XML DB Developers guide that will help you get started. It has a section on installing the product if you need to.

RF

 Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-)

• Original Message ---- From: "Jiang, Lu" <Lu.Jiang_at_umassmed.edu> To: D'Hooge Freek <Freek.DHooge_at_uptime.be>; oracle-l_at_freelists.org Sent: Wednesday, January 14, 2009 9:38:29 AM Subject: RE: Question regarding Network ACLs in 11g DB upgrade

Hi Freek,

Thanks for the quick response. I have read the upgrade documentation. Do you know where I can download XML DB install CD? Tried from OTN under DATABASE DOWNLOAD and could not find anything. Should I ignore the 'ACL' warning message and continue the upgrade, and then as post steps install XML DB, assign ACL to all the machine names which sysman needs to access and grant sysman the access?

Thanks,
Lu

-----Original Message-----

From: D'Hooge Freek [mailto:Freek.DHooge_at_uptime.be] Sent: Wednesday, January 14, 2009 11:01 AM To: Jiang, Lu; oracle-l_at_freelists.org Subject: RE: Question regarding Network ACLs in 11g DB upgrade

Lu,

Problem is that in 11g the privileges on the "network" packages are now fine grained.
This means that you have to explicit grant privileges to the ip's you need to access.
For some reason, Oracle decided to store the access control lists in XML DB.
So yes, XML DB is required when using the ACL's.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/changes.h tm#UPGRD12493
http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/afterup.h tm#UPGRD12428

regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge_at_uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 14 2009 - 11:08:53 CST