删除XDB组件导致的对象失效

0

Posted on by

 在删除XDB的时候,导致一些sys一些对象失效:

版本为:11.2.0.1 to 11.2.0.2

SQL> select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry;

COMP_ID COMP_NAME                            VERSION      STATUS
------- ------------------------------------ ------------ --------
CONTEXT Oracle Text                          11.2.0.2.0   VALID
EXF     Oracle Expression Filter             11.2.0.2.0   VALID
OWM     Oracle Workspace Manager             11.2.0.2.0   VALID
CATALOG Oracle Database Catalog Views        11.2.0.2.0   INVALID
CATPROC Oracle Database Packages and Types   11.2.0.2.0   INVALID
RAC     Oracle Real Application Clusters     11.2.0.2.0   VALID
JAVAVM  JServer JAVA Virtual Machine         11.2.0.2.0   VALID
XML     Oracle XDK                           11.2.0.2.0   VALID
CATJAVA Oracle Database Java Packages        11.2.0.2.0   VALID

9 rows selected.

SQL> select OWNER, OBJECT_NAME, OBJECT_TYPE from dba_objects where status = 'INVALID';

OWNER[......]

查看全文

11.2 XDB Removal and Reinstall

0

Posted on by

  前段时间一个数据库发现没有安装XDB组件,查了下mos:

注意:在安装前和删除前必须重启数据库。

XDB Removal

The catnoqm.sql script drops XDB.

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

Some XDB related objects in the SYS schema are not dropped during the removal of XDB.  Also, the SYS.KU$_% views will become invalid.  Please see the following document for cleaning up these objects:

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

可参考:删除XDB组件导致的对象失效 

 

XDB Installation

The catqm.sql script requires the following parameters be passed to it when run:

A. XDB user password

B. XDB user default tablespace

   * The SYSTEM, UNDO and TEMP tablespace cannot be specified.

   * The specified tablespace must already exist prior to running the script.

[……]

查看全文

Installing and Using Standby Statspack in 11g

0

Posted on by

11g active dataguard 生成的awr信息是主库的awr,而不是dataguard的awr信息,不能生成备库的awr,但是可以生产statspack。

1. Standby Statspack Usage

1.1 Statspack Installation 

The perfstat schema and statspack related objects must be present on the primary and standby prior to installing standby statspack. 

If the perfstat user does not exist in the primary site then you will need to create the perfstat schema using the following:

sqlplus / as sysdba
SQL> @?/rdbms/admin/spcreate.sql

 

The standby statspack installation script (sbcreate.sql) creates the standby statspack schema to hold the standby snapshots. The script asks for:

1.  A password for stdbyperf user

2.  Default tablespace

3.  Temporary tablespace

The script creates the ‘stdbyperf’ user and assigns it the selected default and temporary table space. After the user has been created it calls sbaddins.sql to add the first standby[……]

查看全文

Exclude (Automatic) Statistics Gathering from external objects

0

Posted on by

数据库在自动收集统计信息时,报如下错误:

ORA-20011: Approximate NDV failed:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error

检查到是一个外部表收集统计信息的错误

 

管方的建议是:

用DBMS_STATS.LOCK_TABLE_STATS 不让他收集统计信息

或者直接drop table

 

但由于外部表又不能删除,只好

DBMS_STATS.LOCK_TABLE_STATS ('ownname','tabname');

 

有没有lock可以通过这个视图查看

SELECT stattype_locked FROM dba_tab_statistics;

 

在11gr2 Grid 上更改时区

0

Posted on by

grid 11.2.0.2 之后的版本(包含11.2.0.2),时区的配置文件是

 $GRID_HOME/crs/install/s_crsconfig_<nodename>_env.txt 这个文件中的

 

Grid Time Zone Setting

Once OS default timezone is changed, make sure:

1. For 11.2.0.1, shell environment variable TZ is set correctly for grid user and root.
2. For 11.2.0.2 and above, TZ entry in $GRID_HOME/crs/install/s_crsconfig_<nodename>_env.txt sets to correct time zone.

 

 

OS Default Timezone Setting

Linux

To change: /usr/sbin/timeconfig

To display current setting:

cat /etc/sysconfig/clock
ZONE="America/Los_Angeles"
UTC=true
ARC=false

To find out all valid setting: ls -l /usr/share/zoneinfo

Anything that appears in this directory is valid to use, for example, CST6CDT and America/Chicago. 
 
Note: the "Zone" field in /etc/sysconfig/clock could be different than w[……]

查看全文

第 3 页,共 12 页123456...10...最旧 »