| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> oracle >> jiang jie Oracle shu ju ku 10g yi nan wen ti de jie jue fang fa
 

jiang jie Oracle shu ju ku 10g yi nan wen ti de jie jue fang fa

2008-08-15 05:14:55 编辑來源:互联网 评论
 
本文为【讲解Oracle数据库10g疑难问题的解决方法】的拼音翻译版
  yi 、 zen yang pei zhi EM shi qi zhi chi SSL xie yi
  10G EM zhong de OMS, DBConsole,Agent dou zhi chi SSL xie yi .
  ju ti cao zuo :
  ◆1. ru guo mei you huan jing bian liang ORACLE_SID, qing xian pei zhi , huo zhe zhi jie qiao ru set ORACLE_SID=xxx (UNIX huan jing xia qing gen ju bu tong de shell lei xing shi yong bu tong de yu fa :setenv, export...)
  ◆2. jian ru emctl secure , ke yi kan dao quan bu de xuan xiang :
  secure oms
  [] [-reset]
  secure agent
  secure em
  secure dbconsole
  []
  secure setpwd
  secure status [oms url]
  secure lock | unlock
  ◆3. yi pei zhi oms wei li
  ◆3.1 xian ting diao suo you yu oms xiang guan de fu wu (opmnctl stopall)
  ◆3.2 qiao ru : emctl secure oms, hui rang ni shu ru registration password, ran hou xi tong hui chan sheng xiang guan de zheng shu wen jian , ru guo yi qie shun li de hua , xi tong hui you ti shi pei zhi cheng gong de xin xi
  ◆3.3 chong xin qi dong fu wu (opmnctl startall)
  que sheng qing kuang xia ,7777 he 4889 zhe liang ge duan kou shi ke yong de , pei zhi cheng secure mo shi hou ,4888 duan kou shi zhi chi SSL xie yi de . cong $EM_HOME\sysman\config mu lu xia de emoms.properties wen jian zhong ke yi kan dao pei zhi xin xi .
  ◆3.4 jian ce oms shi fou yi jing yun xing zai https xie yi xia
  emctl secure status oms url
  zhu yi : URL yao shu ru wan zheng ,
  li ru : https://myserver:4888/em/upload/
  ◆4. Agent, DBconsole de pei zhi ji ben lei si .
  ◆5. qi dong liu lan qi yun xing shi ,IE hui tan chu yi ge an zhuang an quan zheng shu de chuang kou , an " que ren ".
  er 、 chu xian le wen ti , zen yang jie jue
  yi DB Control wei li , da zhi de bu zhou shi zhe yang de :
  ◆1. emctl status dbconsole cha kan db control de zhuang tai
  ◆2. qu $ORACLE_HOME\hostname_sid\sysman\log mu lu xia cha kan xiang guan ri zhi (emoms.log,emagent.log deng )
  ◆3. jian cha pei zhi wen jian emd.properties,emoms.properties
  mu lu : $ORACLE_HOME\hostname_sid\sysman\config
  ◆4. que bao jian ting qi gong zuo zheng chang : lsnrctl status
  ◆5. 10G EM shi yong de shi pei zhi wen jian zhong ding yi de lian jie chuan , er bu shi zhi jie fang wen tnsnames.ora .
  mu lu : $ORACLE_HOME\hostname_sid\sysman\config
  wen jian : emoms.properties.
  shen shu : oracle.sysman.eml.mntr.emdRepConnectDescriptor
  san 、 xiu gai le jian ting duan kou , zen yang bao zheng DB Control zheng chang yun xing
  ◆1. xiu gai listener.ora he tnsnames.ora zhe liang ge wen jian :
  tnsnames.ora zhong xu yao jia ru :
  listener_1 =
  (ADDRESS = (PROTOCOL = TCP)
  (HOST = xxxx)(PORT = xin de duan kou ))
  ran hou qi dong shu ju ku :
  SQL> show parameter local_listener ;
  SQL> alter system set local_listener='listener_1' scope=spfile;
  chong qi shu ju ku shi de xiu gai sheng xiao
  ◆2. xiu gai $ORACLE_HOME\hostname_sid\sysman\config
  xia de emoms.properties wen jian :
  oracle.sysman.eml.mntr.emdRepPort= xin de duan kou
  oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=xxx)(PORT\= xin de duan kou )))(CONNECT_DATA\=(SERVICE_NAME\=xxx)))
  ◆3. zui hou , huan yao xiu gai $ORACLE_HOME\hostname_sid\sysman\emd
  xia de targets.xml:
  ◆4. chong xin qi dong jian ting qi he dbconsole fu wu .
  ◆5. ru guo xian shang mian de cao zuo ma fan , ke yi yong emca zhe ge ming ling xing gong ju :
  emca -h cha kan suo you ke yong de ming ling
  emca -r tiao guo zi liao dang an ku de chuang jian .
  si 、 zen yang xiu gai DB Control de fu wu duan kou
  que sheng qing kuang xia , DB Control de duan kou shi 5500, ke yi shen kao xia mian de shuo ming geng gai duan kou 。
  ru guo yong hu xiang gai bian oms duan kou , bi xu gai bian yi xia san ge wen jian , ran hou chong qi db control yi shi de gai bian sheng xiao :
  ◆1. bian ji $ORACLE_HOME/_/sysman/config/emoms.properties bing gai bian yi xia shen shu :
  oracle.sysman.emSDK.svlt.ConsoleServerPort
  oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort
  ◆2. bian ji $ORACLE_HOME/_/sysman/config/emd.properties bing gai bian yi xia shen shu :
  REPOSITORY_URL
  emdWalletSrcUrl
  ◆3. bian ji $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole__/config/http-web-site.xml bing gai bian yi xia shen shu :
  web-site port
  zhu : qing zai xiu gai qian bei fen 。
  ◆ wu 、 ru he shi yong "Automatic SGA Management"
  Automatic SGA Management shi 10G yin ru de xin te xing zhi yi , jiang chu shi hua shen shu wen jian zhong yu nei cun guan li mi qie you guan de ji ge shen shu chou qu chu lai , jiao you shu ju ku qu zi xing guan li ( you xin zeng jia de shen shu SGA_TARGET lai guan li ), zai yi ding cheng xu shang neng jian qing DBA de fu dan .
  zhi yu shen shu de he li xing , huan xu yao jie he AWR Report qu yan zheng .
  SGA_TARGET = db_cache_size + db_nk_cache_size(n=2,4,...)
  + db_keep_cache_size + db_recycle_cache_size +
  shared_pool_size + java_pool_size + large_pool_size + xxxx
  xxx: shi yi ge bao liu zhi , cong mu qian de shi yan lai kan , ji ben shi 4M
  bu zhou :
  ◆1.
  alter system set sga_target=300m scope=both
  create pfile from spfile;
  shutdown immediate;
  xiu gai init.ora wen jian , jiang zhe xie shen shu de zhi she cheng 0:
  db_cache_size, shared_pool_size, java_pool_size,large_pool_size
  ◆2. qi dong SQLPLUS, yi xin de pfile wen jian qi dong shu ju ku
  SQL> startup pfile='....'
  rang wo men lai kan kan tiao zheng de jie guo :
  SQL> select name, block_size, current_size from v$buffer_pool;
  name block_size current_size
  -------------------------------------------------------------
  KEEP 8192 204
  SQL> Select pool, sum(bytes)/1024/1024 as "M bytes" from v$SGASTAT
  group by pool;
  pool M bytes
  -------------------------------------------------
  java pool 4
  large pool 4
  shared pool 84
  205.002403
  205.002403=buffer cache + log buffer + fixed sga + all others ...
  gai dong java pool de zhi
  SQL> alter system set java_pool_size=20M;
  SQL> select name, block_size, current_size,prev_size from v$buffer_pool;
  name block_size current_size prev_size
  ----------------------------------------------------------------------------------------------
  KEEP 8192 188 204
  SQL> Select pool, sum(bytes)/1024/1024 as "M bytes" from v$SGASTAT
  group by pool;
  pool M bytes
  -------------------------------------------------
  java pool 20
  large pool 4
  shared pool 84
  189.002403
  ke yi kan chu , db_cache_size de zhi yi jing bei zi dong tiao xiao le .
  zai ba java pool de zhi gai hui qu
  SQL> alter system set java_pool_size=8M;
  SQL> select name, block_size, current_size,prev_size from v$buffer_pool;
  name block_size current_size prev_size
  -----------------------------------------------------------------------------------
  KEEP 8192 188 204
  SQL> select name, block_size, current_size,prev_size from v$buffer_pool;
  pool M bytes
  -------------------------------------------------
  java pool 20
  large pool 4
  shared pool 84
  189.002403
  zhe yi ci , db_cache_size de zhi mei you bian hua , JAVA_POOL_SIZE de zhi ye mei you bian hua
  xiu gai large pool de zhi wei 16M
  SQL> alter system set large_pool_size=16M;
  System altered.
  SQL> select name,block_size,current_size,prev_size from v$buffer_pool;
  NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE
  -------------------- ---------- ------------ ---------
  DEFAULT 8192 176 188
  SQL> Select pool, sum(bytes)/1024/1024 as "M bytes" from v$sgastat group by pool;
  POOL M bytes
  ------------ ----------
  java pool 20
  large pool 16
  shared pool 84
  177.002403
  zhe ci ,db_cache_size he large_pool_size de zhi dou bian le
  tong yang , tiao da shared_pool_size hou , db_cache_size hui zi dong jian xiao .
  sui ran db_nk_cache_size de zhi bu hui sui zhe workload de gai bian er zi dong tiao zheng , wo men huan shi ke yi kan kan shou gong gai dong db_nk_block_size de qing kuang
  SQL> alter system set db_2k_cache_size=4m;
  System altered.
  SQL> select name,block_size,current_size,prev_size from v$buffer_pool;
  NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE
  ---------------- ----------------- ------------ ----------
  DEFAULT 8192 172 176
  DEFAULT 2048 4 0
  SQL> alter system set db_2k_cache_size=0;
  System altered.
  SQL> select name,block_size,current_size,prev_size from v$buffer_pool;
  NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE
  ----------------- ---------------- ------------------ --------------
  DEFAULT 8192 176 172
  SQL> alter system set db_2k_cache_size=8m;
  System altered.
  SQL> select name,block_size,current_size,prev_size from v$buffer_pool;
  NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE
  -------------------- ---------- ------------ ----------
  DEFAULT 8192 168 176
  DEFAULT 2048 8 0
  jie lun : shou gong tiao zheng db_nk_cache_size que shi hui ying xiang yuan you de shen shu .
  zui hou shuo yi dian : SGA_TARGET shen shu yu SGA_MAX_SIZE shen shu you mi qie guan lian , ji ben de yuan ze jiu shi qian zhe de zhi bu neng da yu hou zhe de zhi .
  zong jie : she zhi le SGA_TARGET shen shu hou , shu ju ku hui zai zhe ge fan wei nei zi xing tiao zheng ; dan xu duo qing kuang xia , zen yang he li di she zhi zhe ge shen shu reng shi DBA xu yao kao lv de wen ti , ta men xu yao jie he AWR Report deng fu zhu de gong ju lai fen xi .( dang ran , wo men ke yi gen ju Advisor de li shi xin xi er que ding yi ge bi jiao he li de zhi )。
  
  yi 、 luan ma wen ti
  Redhat RHEL AS3 xia an zhuang Oracle DB 10g zhong wen luan ma wen ti
  bu shao xiong di fan yang zai rhel3 xia an zhuang oracle10g shi chu xian luan ma , qi shi zai an zhuang he shi yong shi chu xian luan ma de di fang you duo ge , ke yi fen wei san lei :
  1. an zhuang shi de luan ma
  2. yi xie ying yong cheng xu de luan ma , bi ru dbca, netca
  3. yi xie ji yu oc4j de web ying yong de luan ma , bi ru isqlplus, em
  zao cheng zhe xie wen ti de yuan yin dou shi yi ge , jiu shi zhe xie cheng xu dou shi yong jdk, xiang ying de jdk( huo jre) shi yong de zi ti pei zhi wen jian font.properties zhong de zi ti he cao zuo xi tong de zi ti huo zhe zi ti pei zhi wen jian bu pi pei . jie jue de ban fa shi ba liang zhe gai cheng yi zhi .
  ◆1. xia zai , jie bao ship.db.cpio.gz, sheng cheng mu lu Disk1
  ◆2. cd Disk1/stage/Components/oracle.swd.jre/1.4.2.0.0/1/DataFiles/
  unzip all_except_bin.jar( zhe shi sheng cheng yi ge jre de mu lu )
  cd jre/1.4.2/lib/
  mv font.properties font.properties.bak
  cp font.properties.zh_CN.Redhat8.0 font.properties
  cd ../../../
  zip -r all_except_bin.jar.new jre/
  mv all_except_bin.jar.new all_except_bin.jar
  ( qi shi jiu shi ba font.properties wen jian huan diao . zhe yang an zhuang shi han zi xian shi jiu mei you wen ti le )
  ◆3. ru fa pao zhi , ba Disk1/stage/Components/oracle.jdk/1.4.2.0.0/1/DataFiles/sol_bin.1.1.jar wen jian li mian de font.properties wen jian huan diao , chuang jian shu ju ku he zhi xing wang luo pei zhi shi de luan ma jiu mei you le . isqlplus he em de luan ma ye jie jue le 。
  yong IE deng lu Linux fu wu qi shang de em chu xian de luan ma
  bu zhi dao da jia you mei you zhu yi dao ,EM xian shi de zhong wen fan yi hen shi zao gao ,up/down dong bu dong jiu fan yi cheng “ xiang shang ”“ xiang xia ”, rang ren ku xiao bu de . hen duo peng you dou shuo , gan cui gei xian shi ying wen suan le , ke shi zen me xian shi ne ?
  hao le , xian zai wo men you yi zhong ban fa hen rong yi de jie jue zhe ge wen ti :
  da kai ni de IE liu lan qi , xuan ze ' gong ju "-->Internet xuan xiang --> chang gui
  xuan ze “ yu yan ”, mo ren zhi you “ zhong wen ”, xuan ze “ tian jia ”, jia ru ying yu ( mei guo ), tiao zheng shun xu , ba ” ying yu ( mei guo )“ fang dao zui shang mian
  OK , que ding 。
  da kai ni de http://yoururl:5500/em
  wen ti jie jue le 。
  er 、10g ru he geng gai gui dang mo shi
  ◆1. dui yu chu shi hua wen jian , zhi xu yao xiu gai log_archive_dest_n zhe ge shen shu .n=1,2,3,....10, Oracle que sheng hui shi yong log_archive_dest_10 zhe ge shen shu lai shi yong flash recovery area li mian cun fang de gui dang ri zhi wen jian , da xiao you shen shu db_recovery_file_dest_size lai jue ding .
  xiu gai :
  log_archive_dest_1="location=c:\oracle\10g\...\archivelog quota_size=2G"
  ...
  ru guo gui dang shi yong flash recovery area, shang mian de shen shu bu xu yao zhi ding ren he zhi ,Oracle hui zi dong shi yong db_recovery_file_dest zhe ge shen shu suo zhi ding de lu jing 。
  ◆2. qi dong sqlplus:
  startup mount pfile='....'
  alter database archivelog;
  ( ru guo qi yong flashback, alter database flashback on)
  alter database open;
  archive log list( cha kan shi fou yun xing zai gui dang mo shi )
  ( ru guo qian mian de log_archive_dest_n mei you she zhi , ze hui xian shi USE_DB_RECOVERY_FILE_DEST)
  ◆3. zen yang bian cheng noarchivelog mo shi
  bu zhou ji ben tong shang 。
  san 、 yong dblink zai 10G zhong zuo create table ..as select * from ..varchar2() de column kuan du bian cheng 3 bei
  wen ti miao shu : li ru :varchar2(255)==>varchar(765)
  ce shi :
  ◆1. huan jing : liang tai ji qi dou zhuang de 10G de shu ju ku
  ◆2. ce shi bu zhou he jie guo :
  SQL> conn test1/test1@db10G_server1
  SQL> create database link link_server2
  connect to test1 identified by test1
  using 'db10G_server2'
  SQL> conn test1/test1@db10G_server2
  SQL> create table test1_t1 as select * from all_objects
  where rownum<=3000;
  SQL> desc test1_t1;
  Name Null? Type
  ---------------------------------------------------------------
  OWNER VARCHAR2(30)
  OBJECT_NAME VARCHAR2(30)
  SUBOBJECT_NAME VARCHAR2(30)
  OBJECT_ID NUMBER
  DATA_OBJECT_ID NUMBER
  OBJECT_TYPE VARCHAR2(19)
  CREATED DATE
  LAST_DDL_TIME DATE
  TIMESTAMP VARCHAR2(19)
  STATUS VARCHAR2(7)
  TEMPORARY VARCHAR2(1)
  GENERATED VARCHAR2(1)
  SECONDARY VARCHAR2(1)
  SQL> conn test1/test1@db10G_server1
  SQL> create table test1_linkt1 as
  select * from test1_t1@link_server2;
  SQL> desc test1_linkt1
  Name Null? Type
  ----------------------------------------- -------- ----------------
  OWNER VARCHAR2(60)
  OBJECT_NAME VARCHAR2(60)
  SUBOBJECT_NAME VARCHAR2(60)
  OBJECT_ID NUMBER
  DATA_OBJECT_ID NUMBER
  OBJECT_TYPE VARCHAR2(38)
  CREATED DATE
  LAST_DDL_TIME DATE
  TIMESTAMP VARCHAR2(38)
  STATUS VARCHAR2(14)
  TEMPORARY VARCHAR2(2)
  GENERATED VARCHAR2(2)
  SECONDARY VARCHAR2(2)
  biao jie gou yi yang , dan shi lie de chang du que shi bian le , tong guo dblink chuang jian de biao de varchar2 lie de chang du shi yuan biao de liang bei
  zai lai kan kan zi fu ji
  ◆1.Server1 shang de shu ju ku zi fu ji
  SQL> column value format A20
  SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
  value
  --------------
  ZHS16GBK
  ◆2. Server2 shang de shu ju ku zi fu ji
  SQL> conn test1/test1@db10G_server2
  SQL> column value format A20
  SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
  value
  --------------
  AL32UTF8
  si 、 zai 10g bu zhi chi de Linux fa xing ban shang an zhuang 10g de jie jue fang fa
  zheng chang an zhuang de 10g zhi zhi chi Red Hat Enterprise Linux 2.1 and 3, and on UnitedLinux 1.0。 ru guo shi qi ta de ban ben , bi ru fedora,rh9 deng ,10g jiang hui shuo bu zhi chi , er bu yuan xu an zhuang , jie jue fang fa ru xia :
  ◆1. yun xing runInstaller -ignoreSysPrereqs, zhe yang hui tiao guo jian cha
  ◆2. xiu gai /etc/redhat-release wen jian , rang 10g ren wei zi ji chu yu zhi chi de cao zuo xi tong zhong , yun xing xia mian de ming ling ji ke
  su - root
  cp /etc/redhat-release /etc/redhat-release.backup
  cat > /etc/redhat-release << EOF
  Red Hat Enterprise Linux AS release 3 (Taroon)
  EOF
  an zhuang wan bi , zai jiang na ge wen jian huan yuan :
  su - root
  cp /etc/redhat-release.backup /etc/redhat-release
  ◆3. tong yang de si lu , wo men ke yi qu xiu gai Oracle de install/oraparam.ini wen jian :
  [Certified Versions]
  Linux=redhat-2.1,UnitedLinux-1.0,redhat-3
  ba zhe ge ping bi diao , huo zhe shi tian jia xin de nei rong :
  [Certified Versions]
  Linux=redhat-2.1,UnitedLinux-1.0,redhat-3
  [Linux-redhat-2.1-optional]
  TEMP_SPACE=80
  SWAP_SPACE=150
  MIN_DISPLAY_COLORS=256
  [UnitedLinux-1.0-optional]
  TEMP_SPACE=80
  SWAP_SPACE=150
  MIN_DISPLAY_COLORS=256
  [Linux-redhat-3.0-optional]
  TEMP_SPACE=80
  SWAP_SPACE=150
  MIN_DISPLAY_COLORS=256
  dui zhe ge di fang ding zhi yi xia jiu ke yi le 。
  zhu : you xing qu de peng you bu fang ce shi yi xia , qi shi zai zhe ge di fang ke yi ding zhi hen duo dong xi de , dan shi bu tui jian zai zheng shi de ying yong zhong zhe me zuo 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
yi 、 zen yang pei zhi EM shi qi zhi chi SSL xie yi 10G EM zhong de OMS, DBConsole,Agent dou zhi chi SSL xie yi . ju ti cao zuo : ◆1. ru guo mei you huan jing bian liang ORACLE_SID, qing xian pei zhi , huo zhe zhi jie qiao ru set ORACLE_SID=xxx (UNIX huan jing xia qing gen ju bu tong de shell lei xing shi yong bu tong de yu fa :setenv, export...) ◆2. jian ru emctl secure , ke yi kan dao quan bu de xuan xiang : secure oms [] [-reset] secure agent secure em secure dbconsole [] secure setpwd secure status [oms url] secure lock | unlock ◆3. yi pei zhi oms wei li ◆3.1 xian ting diao suo you yu oms xiang guan de fu wu (opmnctl stopall) ◆3.2 qiao ru : emctl secure oms, hui rang ni shu ru registration password, ran hou xi tong hui chan sheng xiang guan de zheng shu wen jian , ru guo yi qie shun li de hua , xi tong hui you ti shi pei zhi cheng gong de xin xi ◆3.3 chong xin qi dong fu wu (opmnctl startall) que sheng qing kuang xia ,7777 he 4889 zhe liang ge duan kou shi ke yong de , pei zhi cheng secure mo shi hou ,4888 duan kou shi zhi chi SSL xie yi de . cong $EM_HOME\sysman\config mu lu xia de emoms.properties wen jian zhong ke yi kan dao pei zhi xin xi . ◆3.4 jian ce oms shi fou yi jing yun xing zai https xie yi xia emctl secure status oms url zhu yi : URL yao shu ru wan zheng , li ru : [url=https://myserver:4888/em/upload/]https://myserver:4888/em/upload/[/url] ◆4. Agent, DBconsole de pei zhi ji ben lei si . ◆5. qi dong liu lan qi yun xing shi ,IE hui tan chu yi ge an zhuang an quan zheng shu de chuang kou , an " que ren ". er 、 chu xian le wen ti , zen yang jie jue yi DB Control wei li , da zhi de bu zhou shi zhe yang de : ◆1. emctl status dbconsole cha kan db control de zhuang tai ◆2. qu $ORACLE_HOME\hostname_sid\sysman\log mu lu xia cha kan xiang guan ri zhi (emoms.log,emagent.log deng ) ◆3. jian cha pei zhi wen jian emd.properties,emoms.properties mu lu : $ORACLE_HOME\hostname_sid\sysman\config ◆4. que bao jian ting qi gong zuo zheng chang : lsnrctl status ◆5. 10G EM shi yong de shi pei zhi wen jian zhong ding yi de lian jie chuan , er bu shi zhi jie fang wen tnsnames.ora . mu lu : $ORACLE_HOME\hostname_sid\sysman\config wen jian : emoms.properties. shen shu : oracle.sysman.eml.mntr.emdRepConnectDescriptor san 、 xiu gai le jian ting duan kou , zen yang bao zheng DB Control zheng chang yun xing ◆1. xiu gai listener.ora he tnsnames.ora zhe liang ge wen jian : tnsnames.ora zhong xu yao jia ru : listener_1 = (ADDRESS = (PROTOCOL = TCP) (HOST = xxxx)(PORT = xin de duan kou )) ran hou qi dong shu ju ku : SQL> show parameter local_listener ; SQL> alter system set local_listener='listener_1' scope=spfile; chong qi shu ju ku shi de xiu gai sheng xiao ◆2. xiu gai $ORACLE_HOME\hostname_sid\sysman\config xia de emoms.properties wen jian : oracle.sysman.eml.mntr.emdRepPort= xin de duan kou oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=xxx)(PORT\= xin de duan kou )))(CONNECT_DATA\=(SERVICE_NAME\=xxx))) ◆3. zui hou , huan yao xiu gai $ORACLE_HOME\hostname_sid\sysman\emd xia de targets.xml: ◆4. chong xin qi dong jian ting qi he dbconsole fu wu . ◆5. ru guo xian shang mian de cao zuo ma fan , ke yi yong emca zhe ge ming ling xing gong ju : emca -h cha kan suo you ke yong de ming ling emca -r tiao guo zi liao dang an ku de chuang jian . si 、 zen yang xiu gai DB Control de fu wu duan kou que sheng qing kuang xia , DB Control de duan kou shi 5500, ke yi shen kao xia mian de shuo ming geng gai duan kou 。 ru guo yong hu xiang gai bian oms duan kou , bi xu gai bian yi xia san ge wen jian , ran hou chong qi db control yi shi de gai bian sheng xiao : ◆1. bian ji $ORACLE_HOME/_/sysman/config/emoms.properties bing gai bian yi xia shen shu : oracle.sysman.emSDK.svlt.ConsoleServerPort oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort ◆2. bian ji $ORACLE_HOME/_/sysman/config/emd.properties bing gai bian yi xia shen shu : REPOSITORY_URL emdWalletSrcUrl ◆3. bian ji $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole__/config/http-web-site.xml bing gai bian yi xia shen shu : web-site port zhu : qing zai xiu gai qian bei fen 。 ◆ wu 、 ru he shi yong "Automatic SGA Management" Automatic SGA Management shi 10G yin ru de xin te xing zhi yi , jiang chu shi hua shen shu wen jian zhong yu nei cun guan li mi qie you guan de ji ge shen shu chou qu chu lai , jiao you shu ju ku qu zi xing guan li ( you xin zeng jia de shen shu SGA_TARGET lai guan li ), zai yi ding cheng xu shang neng jian qing DBA de fu dan . zhi yu shen shu de he li xing , huan xu yao jie he AWR Report qu yan zheng . SGA_TARGET = db_cache_size + db_nk_cache_size(n=2,4,...) + db_keep_cache_size + db_recycle_cache_size + shared_pool_size + java_pool_size + large_pool_size + xxxx xxx: shi yi ge bao liu zhi , cong mu qian de shi yan lai kan , ji ben shi 4M bu zhou : ◆1. alter system set sga_target=300m scope=both create pfile from spfile; shutdown immediate; xiu gai init.ora wen jian , jiang zhe xie shen shu de zhi she cheng 0: db_cache_size, shared_pool_size, java_pool_size,large_pool_size ◆2. qi dong SQLPLUS, yi xin de pfile wen jian qi dong shu ju ku SQL> startup pfile='....' rang wo men lai kan kan tiao zheng de jie guo : SQL> select name, block_size, current_size from v$buffer_pool; name block_size current_size ------------------------------------------------------------- KEEP 8192 204 SQL> Select pool, sum(bytes)/1024/1024 as "M bytes" from v$SGASTAT group by pool; pool M bytes ------------------------------------------------- java pool 4 large pool 4 shared pool 84 205.002403 205.002403=buffer cache + log buffer + fixed sga + all others ... gai dong java pool de zhi SQL> alter system set java_pool_size=20M; SQL> select name, block_size, current_size,prev_size from v$buffer_pool; name block_size current_size prev_size ---------------------------------------------------------------------------------------------- KEEP 8192 188 204 SQL> Select pool, sum(bytes)/1024/1024 as "M bytes" from v$SGASTAT group by pool; pool M bytes ------------------------------------------------- java pool 20 large pool 4 shared pool 84 189.002403 ke yi kan chu , db_cache_size de zhi yi jing bei zi dong tiao xiao le . zai ba java pool de zhi gai hui qu SQL> alter system set java_pool_size=8M; SQL> select name, block_size, current_size,prev_size from v$buffer_pool; name block_size current_size prev_size ----------------------------------------------------------------------------------- KEEP 8192 188 204 SQL> select name, block_size, current_size,prev_size from v$buffer_pool; pool M bytes ------------------------------------------------- java pool 20 large pool 4 shared pool 84 189.002403 zhe yi ci , db_cache_size de zhi mei you bian hua , JAVA_POOL_SIZE de zhi ye mei you bian hua xiu gai large pool de zhi wei 16M SQL> alter system set large_pool_size=16M; System altered. SQL> select name,block_size,current_size,prev_size from v$buffer_pool; NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE -------------------- ---------- ------------ --------- DEFAULT 8192 176 188 SQL> Select pool, sum(bytes)/1024/1024 as "M bytes" from v$sgastat group by pool; POOL M bytes ------------ ---------- java pool 20 large pool 16 shared pool 84 177.002403 zhe ci ,db_cache_size he large_pool_size de zhi dou bian le tong yang , tiao da shared_pool_size hou , db_cache_size hui zi dong jian xiao . sui ran db_nk_cache_size de zhi bu hui sui zhe workload de gai bian er zi dong tiao zheng , wo men huan shi ke yi kan kan shou gong gai dong db_nk_block_size de qing kuang SQL> alter system set db_2k_cache_size=4m; System altered. SQL> select name,block_size,current_size,prev_size from v$buffer_pool; NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE ---------------- ----------------- ------------ ---------- DEFAULT 8192 172 176 DEFAULT 2048 4 0 SQL> alter system set db_2k_cache_size=0; System altered. SQL> select name,block_size,current_size,prev_size from v$buffer_pool; NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE ----------------- ---------------- ------------------ -------------- DEFAULT 8192 176 172 SQL> alter system set db_2k_cache_size=8m; System altered. SQL> select name,block_size,current_size,prev_size from v$buffer_pool; NAME BLOCK_SIZE CURRENT_SIZE PREV_SIZE -------------------- ---------- ------------ ---------- DEFAULT 8192 168 176 DEFAULT 2048 8 0 jie lun : shou gong tiao zheng db_nk_cache_size que shi hui ying xiang yuan you de shen shu . zui hou shuo yi dian : SGA_TARGET shen shu yu SGA_MAX_SIZE shen shu you mi qie guan lian , ji ben de yuan ze jiu shi qian zhe de zhi bu neng da yu hou zhe de zhi . zong jie : she zhi le SGA_TARGET shen shu hou , shu ju ku hui zai zhe ge fan wei nei zi xing tiao zheng ; dan xu duo qing kuang xia , zen yang he li di she zhi zhe ge shen shu reng shi DBA xu yao kao lv de wen ti , ta men xu yao jie he AWR Report deng fu zhu de gong ju lai fen xi .( dang ran , wo men ke yi gen ju Advisor de li shi xin xi er que ding yi ge bi jiao he li de zhi )。 yi 、 luan ma wen ti Redhat RHEL AS3 xia an zhuang Oracle DB 10g zhong wen luan ma wen ti bu shao xiong di fan yang zai rhel3 xia an zhuang oracle10g shi chu xian luan ma , qi shi zai an zhuang he shi yong shi chu xian luan ma de di fang you duo ge , ke yi fen wei san lei : 1. an zhuang shi de luan ma 2. yi xie ying yong cheng xu de luan ma , bi ru dbca, netca 3. yi xie ji yu oc4j de web ying yong de luan ma , bi ru isqlplus, em zao cheng zhe xie wen ti de yuan yin dou shi yi ge , jiu shi zhe xie cheng xu dou shi yong jdk, xiang ying de jdk( huo jre) shi yong de zi ti pei zhi wen jian font.properties zhong de zi ti he cao zuo xi tong de zi ti huo zhe zi ti pei zhi wen jian bu pi pei . jie jue de ban fa shi ba liang zhe gai cheng yi zhi . ◆1. xia zai , jie bao ship.db.cpio.gz, sheng cheng mu lu Disk1 ◆2. cd Disk1/stage/Components/oracle.swd.jre/1.4.2.0.0/1/DataFiles/ unzip all_except_bin.jar ( zhe shi sheng cheng yi ge jre de mu lu ) cd jre/1.4.2/lib/ mv font.properties font.properties.bak cp font.properties.zh_CN.Redhat8.0 font.properties cd ../../../ zip -r all_except_bin.jar.new jre/ mv all_except_bin.jar.new all_except_bin.jar ( qi shi jiu shi ba font.properties wen jian huan diao . zhe yang an zhuang shi han zi xian shi jiu mei you wen ti le ) ◆3. ru fa pao zhi , ba Disk1/stage/Components/oracle.jdk/1.4.2.0.0/1/DataFiles/sol_bin.1.1.jar wen jian li mian de font.properties wen jian huan diao , chuang jian shu ju ku he zhi xing wang luo pei zhi shi de luan ma jiu mei you le . isqlplus he em de luan ma ye jie jue le 。 yong IE deng lu Linux fu wu qi shang de em chu xian de luan ma bu zhi dao da jia you mei you zhu yi dao ,EM xian shi de zhong wen fan yi hen shi zao gao ,up/down dong bu dong jiu fan yi cheng “ xiang shang ”“ xiang xia ”, rang ren ku xiao bu de . hen duo peng you dou shuo , gan cui gei xian shi ying wen suan le , ke shi zen me xian shi ne ? hao le , xian zai wo men you yi zhong ban fa hen rong yi de jie jue zhe ge wen ti : da kai ni de IE liu lan qi , xuan ze ' gong ju "-->Internet xuan xiang --> chang gui xuan ze “ yu yan ”, mo ren zhi you “ zhong wen ”, xuan ze “ tian jia ”, jia ru ying yu ( mei guo ), tiao zheng shun xu , ba ” ying yu ( mei guo )“ fang dao zui shang mian OK , que ding 。 da kai ni de [url=http://yoururl:5500/em]http://yoururl:5500/em[/url] wen ti jie jue le 。 er 、10g ru he geng gai gui dang mo shi ◆1. dui yu chu shi hua wen jian , zhi xu yao xiu gai log_archive_dest_n zhe ge shen shu .n=1,2,3,....10, Oracle que sheng hui shi yong log_archive_dest_10 zhe ge shen shu lai shi yong flash recovery area li mian cun fang de gui dang ri zhi wen jian , da xiao you shen shu db_recovery_file_dest_size lai jue ding . xiu gai : log_archive_dest_1="location=c:\oracle\10g\...\archivelog quota_size=2G" ... ru guo gui dang shi yong flash recovery area, shang mian de shen shu bu xu yao zhi ding ren he zhi ,Oracle hui zi dong shi yong db_recovery_file_dest zhe ge shen shu suo zhi ding de lu jing 。 ◆2. qi dong sqlplus: startup mount pfile='....' alter database archivelog; ( ru guo qi yong flashback, alter database flashback on) alter database open; archive log list( cha kan shi fou yun xing zai gui dang mo shi ) ( ru guo qian mian de log_archive_dest_n mei you she zhi , ze hui xian shi USE_DB_RECOVERY_FILE_DEST) ◆3. zen yang bian cheng noarchivelog mo shi bu zhou ji ben tong shang 。 san 、 yong dblink zai 10G zhong zuo create table ..as select * from ..varchar2() de column kuan du bian cheng 3 bei wen ti miao shu : li ru :varchar2(255)==>varchar(765) ce shi : ◆1. huan jing : liang tai ji qi dou zhuang de 10G de shu ju ku ◆2. ce shi bu zhou he jie guo : SQL> conn [url=mailto:test1/test1@db10G_server1]test1/test1@db10G_server1[/url] SQL> create database link link_server2 connect to test1 identified by test1 using 'db10G_server2' SQL> conn [url=mailto:test1/test1@db10G_server2]test1/test1@db10G_server2[/url] SQL> create table test1_t1 as select * from all_objects where rownum<=3000; SQL> desc test1_t1; Name Null? Type --------------------------------------------------------------- OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(30) SUBOBJECT_NAME VARCHAR2(30) OBJECT_ID NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(19) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) SQL> conn [url=mailto:test1/test1@db10G_server1]test1/test1@db10G_server1[/url] SQL> create table test1_linkt1 as select * from [url=mailto:test1_t1@link_server2]test1_t1@link_server2[/url]; SQL> desc test1_linkt1 Name Null? Type ----------------------------------------- -------- ---------------- OWNER VARCHAR2(60) OBJECT_NAME VARCHAR2(60) SUBOBJECT_NAME VARCHAR2(60) OBJECT_ID NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(38) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(38) STATUS VARCHAR2(14) TEMPORARY VARCHAR2(2) GENERATED VARCHAR2(2) SECONDARY VARCHAR2(2) biao jie gou yi yang , dan shi lie de chang du que shi bian le , tong guo dblink chuang jian de biao de varchar2 lie de chang du shi yuan biao de liang bei zai lai kan kan zi fu ji ◆1.Server1 shang de shu ju ku zi fu ji SQL> column value format A20 SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET'; value -------------- ZHS16GBK ◆2. Server2 shang de shu ju ku zi fu ji SQL> conn [url=mailto:test1/test1@db10G_server2]test1/test1@db10G_server2[/url] SQL> column value format A20 SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET'; value -------------- AL32UTF8 si 、 zai 10g bu zhi chi de Linux fa xing ban shang an zhuang 10g de jie jue fang fa zheng chang an zhuang de 10g zhi zhi chi Red Hat Enterprise Linux 2.1 and 3, and on UnitedLinux 1.0。 ru guo shi qi ta de ban ben , bi ru fedora,rh9 deng ,10g jiang hui shuo bu zhi chi , er bu yuan xu an zhuang , jie jue fang fa ru xia : ◆1. yun xing runInstaller -ignoreSysPrereqs, zhe yang hui tiao guo jian cha ◆2. xiu gai /etc/redhat-release wen jian , rang 10g ren wei zi ji chu yu zhi chi de cao zuo xi tong zhong , yun xing xia mian de ming ling ji ke su - root cp /etc/redhat-release /etc/redhat-release.backup cat > /etc/redhat-release << EOF Red Hat Enterprise Linux AS release 3 (Taroon) EOF an zhuang wan bi , zai jiang na ge wen jian huan yuan : su - root cp /etc/redhat-release.backup /etc/redhat-release ◆3. tong yang de si lu , wo men ke yi qu xiu gai Oracle de install/oraparam.ini wen jian : [Certified Versions] Linux=redhat-2.1,UnitedLinux-1.0,redhat-3 ba zhe ge ping bi diao , huo zhe shi tian jia xin de nei rong : [Certified Versions] Linux=redhat-2.1,UnitedLinux-1.0,redhat-3 [Linux-redhat-2.1-optional] TEMP_SPACE=80 SWAP_SPACE=150 MIN_DISPLAY_COLORS=256 [UnitedLinux-1.0-optional] TEMP_SPACE=80 SWAP_SPACE=150 MIN_DISPLAY_COLORS=256 [Linux-redhat-3.0-optional] TEMP_SPACE=80 SWAP_SPACE=150 MIN_DISPLAY_COLORS=256 dui zhe ge di fang ding zhi yi xia jiu ke yi le 。 zhu : you xing qu de peng you bu fang ce shi yi xia , qi shi zai zhe ge di fang ke yi ding zhi hen duo dong xi de , dan shi bu tui jian zai zheng shi de ying yong zhong zhe me zuo 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
上海柏雅居酒店模拍
清晨美丽的风景
梦清园的靓丽女生
妖艳的食人花(7)
且行且攝------"色"影大連
【做股票的朋友看过来-华尔街的铜牛】
端午节后闲逛
捐款赈灾吴川行 花絮
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有