Re: Question regarding Network ACLs in 11g DB upgrade
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Lu.Jiang@xxxxxxxxxxxx, D'Hooge Freek <Freek.DHooge@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Jan 2009 09:08:53 -0800 (PST)
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@xxxxxxxxxxxx>
To: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Wednesday, January 14, 2009 11:01 AM
To: Jiang, Lu; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx
tel. +32 (0)3 451 23 82
http://www.uptime.be
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
