配置侦听器的安全性为侦听器设置口令lsnrctlchange_passwordsave_configsetpasswordpassLSNRCTL>change_passwordOldpassword:Newpassword:Reenternewpassword:正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.19)(PORT=1521)))LISTENER的口令已更改...(more)

全球化设置select*fromnls_database_parameters;PARAMETERVALUE----NLS_LANGUAGESIMPLIFIEDCHINESENLS_TERRITORYCHINANLS_CURRENCY?NLS_ISO_CURRENCYCHINANLS_NUMERIC_CHARACTERS.,NLS_CHARACTERSETZHS16GBKNLS_CALENDARGREGORIANNLS_DATE_FORMATDD-MON-RRNLS_DATE_LANG...(more)

管理eOracle数据库中的全球化语言selectparameter,valuefromv$nls_valid_valueswhereparameter='LANGUAGE';PARAMETERVALUELANGUAGEAMERICANLANGUAGEGERMANLANGUAGEFRENCHLANGUAGECANADIANFRENCHLANGUAGESPANISHLANGUAGEITALIANLANGUAGEDUTCHLANGUAGESWEDISHLANGUAGENORW...(more)

!/bin/shcount=0while[$count-lt$2]docount='expr$count+1'sqlplus-swillson/willsonm@$1@test.sqlsleep1donesetlinesize160colhost_namefora15altersessionsetnls_date_format='yyyy-mm-ddhh24:mi:ss';selectinstance_number,instance_name,host_name,status,startup_t...(more)

srvctl命令addAddadatabaseorinstanceconfigListtheconfigurationforthedatabaseorinstancegetenvListtheenvironmentvariablesintheSRVMconfigurationmodifyModifytheinstanceconfigurationremoveRemovethedatabaseorinstancesetenvSettheenvironmentvariableintheSRVMc...(more)

srvctl命令addAddadatabaseorinstanceconfigListtheconfigurationforthedatabaseorinstancegetenvListtheenvironmentvariablesintheSRVMconfigurationmodifyModifytheinstanceconfigurationremoveRemovethedatabaseorinstancesetenvSettheenvironmentvariableintheSRVMc...(more)

FollowthesestepstoconfigureRMANbackupsinDataGuardenvironment.Whenyouwanttomanagedthearchivelogdeletionpolicyfromonecentralpoint.CONFIGUREARCHIVELOGDELETIONPOLICYPossibleoptions:APPLIEDONSTANDBY-enablesflashrecoveryareatodeletearchivelogsthatareapplie...(more)

Dataguard依赖一个健康的网络，尤其是高负载的系统和网络环境，网络上有调整的需求。1.OracleNetSessionDataUnit(SDU)SizeOracleNet在将数据进行网络传输的时候,先将数据放在SDU中，该参数在10gR2默认为2k，适当增加大小，可以提高网络性能和利用率。Oracle推荐该参数取值为32767(...(more)

在logicalstandby环境下，备库基本上是一个独立的库，如果要在备库，以非sys用户对备库的数据进行DML修改，就会报错ora-16224au10qapap0tels2:ARS2AP:/opt/app/oracle/admin>oerrora1622416224,00000,"DatabaseGuardisenabled"//*Cause:Operationcouldnotbeperformedbecaused...(more)

Oracle11g的DataGuard不仅仅带给我们的是ActiveDataGuard实时查询特性，参见文章《【DataGuard】Oracle11g物理ActiveDataGuard实时查询（Real-timequery）特性》（http://space.itpub.net/519536/viewspace-718742）。同时还带来了另外一个惊喜，这便是SnapshotStandby数据库功能，此...(more)