手工安装XDB 组件in oracle 11g

Myth丶恋晨 2021-12-20 01:27 180阅读 0赞

\#\#\#\#\#\#\#\#\#\#\#\#\#. sample 1

install guide

below step is only for oracle 11g database installation, 10g database did't need xdb install

step 1.Verify XDB Installation

add in f\_getlist function

spool xdb\_status.txt

set echo on;  
connect / as sysdba  
set pagesize 1000  
col comp\_name format a36  
col version format a12  
col status format a8  
col owner format a12  
col object\_name format a35  
col name format a25

\-- Check status of XDB

select comp\_name, version, status  
from dba\_registry  
where comp\_id = 'XDB';

\-- Check for invalid objects

select owner, object\_name, object\_type, status  
from dba\_objects  
where status = 'INVALID'  
and owner in ('SYS', 'XDB');

spool off;

step 2.

\#\# IMPORTANT: You must shutdown and restart the database between removal and reinstall \#\#  
\#\#\#FOR 11G DB

step 2.1  
First, find out the current value of these parameters:

connect / as sysdba  
show parameter aq\_tm\_processes  
1

show parameter job\_queue\_processes  
1000

Next, change the value to 0:

connect / as sysdba  
alter system set aq\_tm\_processes=0 scope=both;  
alter system set job\_queue\_processes=0 scope=both;

step 2.2  
spool xdb\_install.log  
set echo on;  
connect / as sysdba  
shutdown immediate;  
startup;  
\#\# /rdbms/admin/catqm.sql <XDB pwd> <XDB default tbs> <XDB temporary tbs> -- substitute the parameters with appropriate values  
@?/rdbms/admin/catqm.sql xdb SYSAUX TEMP YES  
@?/rdbms/admin/utlrp.sql  
spool off

time: 12minutes  
15:08 ~ 15:30

step 2.3

connect / as sysdba  
alter system set aq\_tm\_processes=1 scope=both;  
alter system set job\_queue\_processes=1000 scope=both;  
shutdown immediate;  
startup;

\#\#\#\#\#\#\#

step 3.after install :

select comp\_name, version, status  
from dba\_registry  
where comp\_id = 'XDB';

\-- Check for invalid objects

select owner, object\_name, object\_type, status  
from dba\_objects  
where status = 'INVALID'  
and owner in ('SYS', 'XDB');

\--Get current XDB tablespace  
set serveroutput on

declare  
v\_xdbtbs varchar2(30);  
begin  
select dbms\_xdb.getxdb\_tablespace into v\_xdbtbs from dual;  
dbms\_output.put\_line(a => 'Actual XDB tablespace is:'||v\_xdbtbs);  
end;  
/

Actual XDB tablespace is:SYSAUX

http://www.dba-oracle.com/t\_packages\_dbms\_current\_XDB\_tablespace.htm

\#\#v1  
select owner, object\_name, object\_type, status  
from dba\_objects  
where  
owner in ('XDB');

\#\#\#\#\#\#\#\#2  XDB re-install

XDB install meet hang issue , waiting for Streams AQ: waiting for messages in the queue

1. Deinstall XDB by implementing the steps in the following document:

(Doc ID 1292089.1) Master Note for Oracle XML Database (XDB) Install / Deinstall

spool xdb\_removal.log  
set echo on;  
connect / as sysdba  
shutdown immediate;  
startup  
@?/rdbms/admin/catnoqm.sql  
@?/rdbms/admin/utlrp.sql  
spool off;

2.2. There will be invalid SYS objects after the removal of XDB. Validate them by running the scripts in the document below:

(Doc ID 1269470.1) XDB Deinstallation script catnoqm.sql leads to Invalid SYS Objects

SQL> connect / as sysdba

\-- Make XDB Dummy views  
start ?/rdbms/admin/catxdbdv.sql

\-- update Data Pump related objects and KU$\_ views

start ?/rdbms/admin/dbmsmeta.sql  
start ?/rdbms/admin/dbmsmeti.sql  
start ?/rdbms/admin/dbmsmetu.sql  
start ?/rdbms/admin/dbmsmetb.sql  
start ?/rdbms/admin/dbmsmetd.sql  
start ?/rdbms/admin/dbmsmet2.sql  
start ?/rdbms/admin/catmeta.sql  
start ?/rdbms/admin/prvtmeta.plb  
start ?/rdbms/admin/prvtmeti.plb  
start ?/rdbms/admin/prvtmetu.plb  
start ?/rdbms/admin/prvtmetb.plb  
start ?/rdbms/admin/prvtmetd.plb  
start ?/rdbms/admin/prvtmet2.plb  
start ?/rdbms/admin/catmet2.sql

@?/rdbms/admin/utlrp.sql

REM Check to verify that all components are valid  
select COMP\_ID, COMP\_NAME, VERSION, STATUS from dba\_registry;

3. Change the value for init.ora parameters AQ\_TM\_PROCESSES and JOB\_QUEUE\_PROCESSES to 0 and restart the database in restricted mode.

First, find out the current value of these parameters:

connect / as sysdba  
show parameter aq\_tm\_processes  
1

show parameter job\_queue\_processes  
1000

Next, change the value to 0:

connect / as sysdba  
alter system set aq\_tm\_processes=0 scope=both;  
alter system set job\_queue\_processes=0 scope=both;  
shutdown immediate;  
startup restrict;

@?/rdbms/admin/catqm.sql xdb SYSAUX TEMP YES  
@?/rdbms/admin/utlrp.sql

connect / as sysdba  
alter system set aq\_tm\_processes=x scope=both;  
alter system set job\_queue\_processes=x scope=both;  
shutdown immediate;  
startup;

转载于:https://www.cnblogs.com/feiyun8616/p/10538571.html