測試庫csdb安裝ORACLE_TEXT元件
1. 準備工作
1.1 在.profile裡面修改$ORACLE_HOME新增
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
connect SYS/password as SYSDBA
set echo on
col comp_name for a30
spool textinstall.log
1.2 建立DRSYS 表空間
mklv -y csdb013_01glv -t jfs2 -T O datavg2 8 hdiskpower12 hdiskpower13 hdiskpower14 hdiskpower15
chown oracle:dba /dev/rcsdb013_01glv
CREATE TABLESPACE DRSYS DATAFILE '/dev/rcsdb013_01glv' SIZE 1023m;
2.Start of Text loading
EXECUTE dbms_registry.loading('CONTEXT', 'Oracle Text');
start ?/ctx/admin/dr0csys ctxsys DRSYS TEMP
3.Install CTXSYS objects
connect CTXSYS/ctxsys
start ?/ctx/admin/dr0inst /software/oracle/product/9.2/ctx/lib/libctxx9.so
start ?/ctx/admin/defaults/drdefcs.sql
4.Upgrade CTXSYS to the latest patchset version, only required for >9.2.0.1
connect SYS/password as SYSDBA
start ?/ctx/admin/ctxpatch.sql
select comp_name, version, status from dba_registry;
spool off
exit;
Review the output file textinstall.log for errors.
Installation of Oracle Text 9.2.0.x is complete.
5.check out
------------------- cut here ------------------------------
connect SYS/password as SYSDBA
set pages 1000
col object_name format a40
col object_type format a20
col comp_name format a30
column library_name format a8
column file_spec format a60 wrap
spool text_install_verification.log
-- check on setup
select comp_name, status, substr(version,1,10) as version
from dba_registry
where comp_id = 'CONTEXT';
select * from ctxsys.ctx_version;
select substr(ctxsys.dri_version,1,10) VER_CODE from dual;
select count(*)
from dba_objects where owner='CTXSYS';
-- Get a summary count
select object_type, count(*)
from dba_objects where owner='CTXSYS'
group by object_type;
-- Any invalid objects
select object_name, object_type, status
from dba_objects
where owner='CTXSYS'
and status != 'VALID'
order by object_name;
select library_name,file_spec,dynamic,status
from all_libraries
where owner = 'CTXSYS';
spool off
1.1 在.profile裡面修改$ORACLE_HOME新增
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
connect SYS/password as SYSDBA
set echo on
col comp_name for a30
spool textinstall.log
1.2 建立DRSYS 表空間
mklv -y csdb013_01glv -t jfs2 -T O datavg2 8 hdiskpower12 hdiskpower13 hdiskpower14 hdiskpower15
chown oracle:dba /dev/rcsdb013_01glv
CREATE TABLESPACE DRSYS DATAFILE '/dev/rcsdb013_01glv' SIZE 1023m;
2.Start of Text loading
EXECUTE dbms_registry.loading('CONTEXT', 'Oracle Text');
start ?/ctx/admin/dr0csys ctxsys DRSYS TEMP
3.Install CTXSYS objects
connect CTXSYS/ctxsys
start ?/ctx/admin/dr0inst /software/oracle/product/9.2/ctx/lib/libctxx9.so
start ?/ctx/admin/defaults/drdefcs.sql
4.Upgrade CTXSYS to the latest patchset version, only required for >9.2.0.1
connect SYS/password as SYSDBA
start ?/ctx/admin/ctxpatch.sql
select comp_name, version, status from dba_registry;
spool off
exit;
Review the output file textinstall.log for errors.
Installation of Oracle Text 9.2.0.x is complete.
5.check out
------------------- cut here ------------------------------
connect SYS/password as SYSDBA
set pages 1000
col object_name format a40
col object_type format a20
col comp_name format a30
column library_name format a8
column file_spec format a60 wrap
spool text_install_verification.log
-- check on setup
select comp_name, status, substr(version,1,10) as version
from dba_registry
where comp_id = 'CONTEXT';
select * from ctxsys.ctx_version;
select substr(ctxsys.dri_version,1,10) VER_CODE from dual;
select count(*)
from dba_objects where owner='CTXSYS';
-- Get a summary count
select object_type, count(*)
from dba_objects where owner='CTXSYS'
group by object_type;
-- Any invalid objects
select object_name, object_type, status
from dba_objects
where owner='CTXSYS'
and status != 'VALID'
order by object_name;
select library_name,file_spec,dynamic,status
from all_libraries
where owner = 'CTXSYS';
spool off
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29468144/viewspace-1076721/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 測試資料庫是否安裝成功資料庫
- 安裝測試kafkaKafka
- memcached安裝測試
- mq安裝測試MQ
- sqlserver 安裝測試SQLServer
- OGG安裝測試
- 測試安裝是否成功
- AD元件庫安裝與使用元件
- app的安裝與解除安裝測試點APP
- 【MySQL】Tokudb安裝測試初探MySql
- vue測試安裝和配置Vue
- kaldi 的安裝及測試
- MHA安裝搭建和測試
- Django 測試是否安裝成功Django
- 效能測試 -- docker安裝influxdbDockerUX
- 【GO】MAC安裝和測試GoGoMac
- pyflink的安裝和測試
- Pig 的安裝與測試
- JDK安裝及測試檔案JDK
- 【STATSPACK】Statspack安裝、測試與使用
- 每日測試思維培養—— PC端安裝解除安裝軟體,怎麼測試,如何設計測試用例?
- cloudera 5 的安裝測試步驟Cloud
- 軟體測試--selenium安裝使用
- 軟體測試--selenium 安裝使用
- Jmeter下載安裝配置---測試小白JMeter
- 三十七、Flume的安裝及測試
- 介面測試:postman的安裝與使用Postman
- sysbench的安裝和做效能測試
- 1. mysql的安裝與測試MySql
- GoldenGate的安裝、配置與測試Go
- Redis叢集方案,Codis安裝測試Redis
- CentOS 下效能測試工具 wrk 安裝CentOS
- 查詢資料庫已經安裝元件資料庫元件
- 試用Redis安裝、php環境連線、測試RedisPHP
- 12C 單例項-測試庫-圖形介面-安裝步驟單例
- 安裝與配置MySQL,phpmyAdmin;安裝與測試PHPLIB (轉)MySqlPHP
- SpringBoot Cli 安裝執行測試Spring Boot
- 安裝GBase 8t 測試版