Oracle DBA 两日速成课程3
51CTO学院-老段带你学OCP Oracle 11g全套培训视频课程
51cto学院-老段带你学OCP Oracle 11g全套培训视频课程课程目标熟练掌握Oracle11gr2的各个功能，不仅能顺利通过OCP的考试，在工作中也能顺心应手适用人群对Oracle感兴趣，想通过ocp的人群，以及想从事DBA的人群课程简介老段OCP 11g培训系列课程包含OCP 11g培训大纲里面所有的内容，但并没有拘泥于大纲，以更适合学员接受的的顺序，对大纲拆毁重建，结构更加清晰。
相比于线下培训，本套培训课程的优势：1、讲解深入浅出，学员很容易理解；2、采用大量实例，贴近你的工作；3、线下培训价格在3000-4000元，本课程不到市面价格三分之一但服务是不打折扣的，24小时内答疑，专属课件资料，只为让您的学习更实惠、更有效、更便捷。
课程1ocp-1 Oracle体系介绍[免费观看]1小时5分钟Oracle体系介绍2ocp-2（1）安装和创建数据库[免费观看]56分钟本视频主要讲了了oracle11g在RHEL6下的安装步骤3ocp-2（2）安装和创建数据库[免费观看]40分钟本课程继续讲解了在RHEL6.3上oracle11g的安装4ocp-2（3）安装和创建数据库[免费观看]1小时9分钟本视频是老段工作室OCP随堂视频，主要讲解的是常见工具的使用，包括SQLPLUS,SQLDEVE LPOR,OEM的使用5ocp-2（4）安装和创建数据库[免费观看]22分钟6ocp-3(1) 实例管理[免费观看]45分钟本视频为老段工作室OCP11g视频，主要讲解的SQLPLUS的语法及使用7ocp-3(2) 实例管理[免费观看]1小时本视频为老段工作室OCP11g视频，主要讲解的是实例的配置8ocp-4(1) Oracle网络的配置[免费观看]38分钟本视频为老段工作室OCP11g视频，主要讲的也是实例的管理9ocp-4(2) Oracle网络的配置[免费观看]1小时2分钟本视频为老段工作室OCP11g视频，主要讲解的是oracle网络的配置10ocp-5(1) Oracle存储设置1小时6分钟本视频为老段工作室OCP11g视频，主要讲解的也是oracle网络的设置11ocp-5(2) Oracle存储设置44分钟本视频为老段工作室OCP视频，主要讲解了oracle存储结构12ocp-6(1) Oracle安全管理44分钟本视频为老段工作室OCP视频，主要讲解的也是oracle存储结构13ocp-6(2) Oracle安全管理30分钟本视频为老段工作室ocp11g视频，主要讲解的是也是oracle存储结构14ocp-6(3) Oracle安全管理54分钟本视频为老段工作室ocp视频，主要讲解的是用户管理15ocp-6(4) Oracle安全管理1小时3分钟16ocp-6(5) Oracle安全管理35分钟17ocp-6(6) Oracle安全管理1小时18ocp-7(1) DDL语句、约束、视图、索引、同义词、序列等1小时18分钟19ocp-7(2) DDL语句、约束、视图、索引、同义词、序列等54分钟20ocp-7(3) DDL语句、约束、视图、索引、同义词、序列等58分钟21ocp-7(4) DDL语句、约束、视图、索引、同义词、序列等15分钟22ocp-7(5) DDL语句、约束、视图、索引、同义词、序列等54分钟23ocp-7(6) DDL语句、约束、视图、索引、同义词、序列等1小时19分钟24ocp-7(7) DDL语句、约束、视图、索引、同义词、序列等20分钟25ocp-7(8) DDL语句、约束、视图、索引、同义词、序列等7分钟26ocp-8(1) DML语句、事务、PLSQL、触发器、存储过程56分钟27ocp-8(2) DML语句、事务、PLSQL、触发器、存储过程52分钟28ocp-8(3) DML语句、事务、PLSQL、触发器、存储过程20分钟29ocp-8(4) DML语句、事务、PLSQL、触发器、存储过程56分钟30ocp-8(5) DML语句、事务、PLSQL、触发器、存储过程46分钟31ocp-8(6) DML语句、事务、PLSQL、触发器、存储过程20分钟32ocp-9 select详解1小时15分钟33ocp-10 单行函数和转换函数1小时14分钟34ocp-11 分组函数34分钟35ocp-12 sql连接、多表查询55分钟36ocp-13(1) 子查询和集合运算符49分钟37ocp-13(2) 子查询和集合运算符28分钟38ocp-14(1)数据库备份和恢复配置58分钟为了方便学员很快速的了解本节要点，建议增加课时介绍，内容为本节要点，不得含有机构名称、招生信息、网站链接、QQ群等宣传推广性质的东西。
Oracle DBA 数据库日常维护手册 常用SQL 脚本
Oracle数据库日常维护【版本整理日期：2011/02/26 】版本整理人：1634068400@本文档包含以下内容：1．Oracle数据库日常维护2．Oracle DBA 常用管理脚本3．Oracle DB 常用SQL 语句/******************************************************** (若跳转不成功，请复制到浏览器或联系Q) /item.htm?id=7437120468Metalink Sharing ********************************************************/在Oracle数据库运行期间，DBA应该对数据库的运行日志及表空间的使用情况进行监控，及早发现数据库中存在的问题。
一、Oracle警告日志文件监控Oracle在运行过程中，会在警告日志文件(alert_SID.log)中记录数据库的一些运行情况：l数据库的启动、关闭，启动时的非缺省参数；l数据库的重做日志切换情况，记录每次切换的时间，及如果因为检查点(checkpoint)操作没有执行完成造成不能切换，会记录不能切换的原因；l对数据库进行的某些操作，如创建或删除表空间、增加数据文件；l数据库发生的错误，如表空间不够、出现坏块、数据库内部错误(ORA －600)DBA 应该定期检查日志文件，根据日志中发现的问题及时进行处理问题处理 启动参数不对 检查初始化参数文件因为检查点操作或归档操作没有完成造成重做日志不能切换 如果经常发生这样的情况，可以考虑增加重做日志文件组；想办法提高检查点或归档操作的效率；有人未经授权删除了表空间 检查数据库的安全问题，是否密码太简单；如有必要，撤消某些用户的系统权限出现坏块 检查是否是硬件问题(如磁盘本生有坏块)，如果不是，检查是那个数据库对象出现了坏块，对这个对象进行重建表空间不够增加数据文件到相应的表空间 出现ORA-600 根据日志文件的内容查看相应的TRC文件，如果是Oracle 的bug ，要及时打上相应的补丁二、数据库表空间使用情况监控（字典管理表空间）数据库运行了一段时间后，由于不断的在表空间上创建和删除对象，会在表空间上产生大量的碎片，DBA 应该及时了解表空间的碎片和可用空间情况，以决定是否要对碎片进行整理或为表空间增加数据文件。
oracle modify用法
Oracle Modify用法在Oracle数据库中，Modify语句是用来修改已经存在的表的结构的。
通过Modify语句，我们可以在不影响表中数据的情况下，修改表的列名、数据类型以及约束等信息。
下面我们就来详细了解一下Oracle Modify语句的用法。
1. 修改列名在Oracle中，我们可以使用Modify语句来修改表中已存在的列名。
我们有一个名为“employee”的表，其中包含了一个名为“name”的列，现在我们想将这个列名修改为“full_name”。
我们可以使用下面的Modify语句来实现这一操作：```sqlALTER TABLE employeeMODIFY (name VARCHAR2(50) NOT NULL, full_name);```在上面的例子中，我们通过Modify语句将“name”列名修改为“full_name”。
2. 修改列数据类型除了修改列名之外，Modify语句还可以用来修改已存在的列的数据类型。
我们有一个名为“employee”的表，其中包含了一个名为“age”的列，数据类型为NUMBER，现在我们想将这个列的数据类型修改为VARCHAR2。
我们可以使用下面的Modify语句来实现这一操作：```sqlALTER TABLE employeeMODIFY (age VARCHAR2(3));```在上面的例子中，我们通过Modify语句将“age”列的数据类型修改为VARCHAR2。
3. 添加列约束除了修改列名和数据类型之外，Modify语句还可以用来添加列约束。
我们有一个名为“employee”的表，其中包含了一个名为“salary”的列，我们现在想给这个列添加一个非空约束。
我们可以使用下面的Modify语句来实现这一操作：```sqlALTER TABLE employeeMODIFY (salary NUMBER(10,2) NOT NULL);```在上面的例子中，我们通过Modify语句给“salary”列添加了一个非空约束。
Windows不能在本地计算机启动OracleDBConsoleorcl
Windows不能在本地计算机启动OracleDBConsoleorcl OracleDBConsole[SID]服务简介OracleDBConsole[SID]服务负责Windows平台下启动Oracle企业管理器，从Oracle 10g开始引入这个服务，也是从Oracle 10g开始，Oracle的企业管理器从客户端形式变为浏览器操作模式，这里的[SID]即Oracle SID，如果是默认安装就是orcl，故这个服务在你的机器上可能就是OracleDBConsoleORCL，事实上在我的机器上也是它。
故障描述在一次正常使用企业管理器后，重新启动计算机，再次启动OracleDBConsoleORCL服务时，报：Windows 不能在本地计算机启动OracleDBConsoleORCL。
有关更多信息，查阅系统事件日志。
如果这是非Microsoft 服务，请与服务厂商联系，并参考特定服务错误代码1。
在应用程序事件日志中记录了如下错误信息：Process exited abnormally during initialization.出现情况：原来正常，计算机名更改或IP地址变了后就不能启动，解决步骤如下：一、我用过的方法1、开始-》运行cmd2、执行emctl start dbconsoleC:\Documents and Settings\xcl>emctl start dbconsoleEnvironment variable ORACLE_SID not defined. Please define it.提示：环境变量ORACLE_SID 未定义，请定义。
3、设置ORACLE_SID =ORCL (orcl是我的实例名，也是服务名)C:\Documents and Settings\xcl>set oracle_sid=orcl4、再次执行emctl start dbconsoleC:\Documents and Settings\xcl>emctl start dbconsoleOC4J Configuration issue. E:\oracle\product\ not found.提示：无法找到“E:\oracle\product\ “注：china-d9e3f7d07 是我的计算机名复制该目录下的“OC4J_DBConsole_localhost_orcl”文件夹放在同一目录下,且把名称改成“OC4J_DBConsole_china-d9e3f7d07_orcl”。
Digi-Star EZ II 9.0 直接访问号 - 设置 校准设置说明书
EZII/3 - Direct Access NumbersFor the Setup / Calibration SettingsThis method allows direct access to individual Setup & Calibration Settings. Enter the Direct Access Number of the setting you would like to change on the numeric keypad and then press the SELECT key. The display will show the setting name and then allow the value to be changed. Pressing the ON or ENTER key will return the scale to weighing.LONG FORM - SETUP/CALIBRATION SETTINGSPlease note: Settings will only be displayed if their feature is found in the indicator model.M ENU 1-B ASIC FEATURES IN MOST SCALESLANGUAGE {LANGAG} .................................. 101 Select Language to be displayed.DISPLAY RATE {D RATE} ............................. 102 Update Display 1, 2, 3, or 4 Times per Second.MOTION {MOTION} ........................................ 103 If ON - motion arrow flashes for unstable weight.ZERO TRACK {ZTRACK} ............................... 104 If ON - zero track adjust balance for buildup of snow & mud.WEIGH METHOD {W MTHD} .......................... 105 Select weigh method 1-General 2-Slow 3-Fast 4-Lock OnLOCK ON {LOCKON} ...................................... 106 Lower number if lock-on does not repeat-Raise to lock-on fasterTR HOLD {TR HLD} ....................................... 107 Display gross weight if TR key is held for 3 seconds.SCALE ID SETUP {SCALID} .......................... 108 Identity of scale location (Truck ID or Mixer Number).LOCK-N-HOLD {LKNHLD} ............................. 109 If ON - lock weight is held until next animal is weighed.AUTO OFF {AUTOFF} .................................... 111 Indicator turns off after selected minutes of stable weight.LOCK ON STORE {L STORE} ........................ 112 Select lock on storage method.LSTORE SEND MODE {LSSEND} ................ 113 ON=sends data with animal on scale. OFF=when animal leavesEID STORE {E STORE} ................................. 114 If ON - records are stored to internal memory.1 PRESS ZERO {1 ZERO} ............................. 115 If ON - Press and hold the Zero key to Zero/Balance scale.POWER LOSS MESS {PWRLOS}................... 116 If ON - Display time & date of power loss if preset/recipe active.EID AUTO RECORD{EIDAUT} ....................... 117 If ON - Immediately records eid tag.SCROLL DELAY {SCROLL} ........................... 118 Slow scroll rate for cold temperatures, 0=normal to 9=slowest.TR KEY FUNCTION {TRKEY1} ...................... 121 Select function of TR key (TARE, START/STOP, PRINT, LOAD, HOLD, etc…). FORCE PREMIS ENTRY{GINPIN} ................ 123 If ON - Operator MUST enter Group & Premis to use scale.SW4600 DEVIATION{SW DEV} ..................... 124 If ON – Enables standard deviation screens on SW4600 EID.MOTION WEIGHT{MOT WT} .......................... 125 Enter weight used to detect Motion. 0=Standard Motion detection.LOCK-ON TIME ADJ{L oc KTM} ...................... 126 Adjust the time required to lock onto a weight. Lower to lock on faster.CLEAR LOCK-ON AT ZERO{LKZERO} ......... 127 If OFF – Indicator can lock onto a new weight without returning to zero.MOTION LOCK SETUP{MOT LK} .................. 128 If ON - will not allow PRINT or ENTER key if motion is detected.NO LOW BATTERY SENSING{NOLBAT} ...... 129 If ON – Indicator will never display low battery status.SAVE TARE{SAVTAR} ................................... 131 If ON – Indicator will save tare weight to non-volatile memory.NUMBER OF BINS{BIN NUM} ......................... 132 Number of bins 0-10, 0 = bin feature off.NUMBER OF ROWS{ROWNUM} ..................... 133 Number of rows 0-100 used in CALC function, 0 = manual entry.ROW MAX CAPACITY{ROWMAX} .................. 134 Maximum capacity to limit preset in CALC function, 0 = no limit.PROGRAM ID{PRG ID} ................................. 198 Displays the software version.M ENU 2-C LOCK,P RINTER,C OMMUNICATIONS &E STIMATED W EIGHT F EATURESTIME FORMAT {TIME F} ............................... 201 Select time format - AM/PM or 24 hourTIME {TIME} .................................................. 202 Select key changes time, Function key choses hh:mm:ss.DATE FORMAT {DATE F} ............................. 203 Select date format 1-mm-dd 2-mm/dd/yy 3-mm/dd/yyyy 4-dd-mm 5-dd/mm/yy 6-dd/mm/yyyy 7-ddmoyy 8-ddmoyyyy.DATE {DATE} ................................................ 204 Select key changes date - Function key choses mm/dd/yyDATE CHECK {DT CHK} ............................... 205 If ON - Indicator verifies the real time clock has a valid date at power upTARE AUTO PRINT {TAREAP} ...................... 211 If ON - tare will auto-print displayed weight.ONE LINE PRINT {1L PRT} ........................... 212 If ON - scale data will be printed on one line.SCOREBOARD MODE{SCOREM} .................. 213 Select scoreboard output.AUTO PRINT {APRINT} ................................. 214 If ON - pressing keys will auto-print weight values.COMPUTER IN MODE {COM IN} ................... 215 DOWNLD = Data Down Loader, EZ CMD = Original EZ Commands & EZ2CMD =EZII Escape Commands.PRINT FORMAT{PRTFMT} ............................ 216 Select alternate & comma (CSV) formats.MEDIA TYPE{MEDIA} .................................... 217 Select DDL, Datakey or Serial PC for data storage.REMOTE{REMOTE} ........................................ 218 If ON - Communicate with Cab Control Display, MTLINE = 3 Line Display Cab Control ZERO OUTPUT {ZEROUT}............................. 219 Perform the Zero/Balance for the SCOREM #11 weight output and the Analog OutputOption (4-20mA).COM 1 DELAY {C1 DLY}................................ 221 Select seconds to delay before advancing to next line.COM 2 DELAY {C2 DLY} ............................... 222 Select seconds to delay before advancing to next line.PRINT ACCUMULATION{PRTACC} ............... 223 Shows a running total of the weights printed.RMT CC START STOP ENABLE{RMC EN} ... 224 If ON – Enables Cab Control start/stop control.RECORD SIZE{RECSIZ} ................................ 225 Select how many print lines make a record.RADIO RESET{RADRES} .............................. 228 Select between hardware reset or software for internal radio.EXTERNAL RADIO{EXTRAD} ........................ 229 If ON – Enables external radio to be attached to the J905 port.(continued)(continued)SCALE NUMBER{SCL NO}............................ 231 Select Scale Number for Cab Control communications.REMOTE DISPLAY{RMDISP} ........................ 234 Select type of Remote Display.PRINT KEY OPERATION{TARPRT} .............. 235 Reverse operation of Print/Tare key on the CC400 or EZ400.BAR GRAPH MODE{BARGRP} ...................... 236 Select output for bar graph display.BAR GRAPH WEIGHT{BAR WT} ................... 237 Enter the Full Scale Gross weight for the bar graph display.PRINT BUFFER{BUFFER}………………… .... 238 If ON - printed records are stored in internal memory.PB SCROLL BY LINES{PBLINE} ................... 239 Scroll through print buffer record memory PBLINE lines at a time. Select 1-3.ANALOG LOW WEIGHT{LOW WT} ................ 241 Enter Analog weight value to equal 4mA or 0 Volts.ANALOG HIGH WEIGHT{HIGHWT} ................ 242 Enter Analog weight value to equal 20mA or 5 Volts.ANALOG SELECT {ANAOUT} ........................ 243 Select 0-5V, 4-20ma or 0-20ma output.NEGATIVE ANALOG OUTPUT {-ANALG} ..... 244 Allow 4-20mA to output weight values less than Analog Low Weight.FRONT PANEL ZEROUT{ZEROFP} .............. 249 Use Zero key to zero out the serial gross weight.REMOTE TERMINAL {RMTERM} ................... 251 If ON – Display data is sent to a Remote Terminal.ISOBUS WEIGHT {ISO WT} ........................... 252 Select rate to broadcast ISOBUS weight data.OPERATING STATUS {OPST AT} .................. 253 Select operating data to be sent to a Remote Terminal.REMOTE TERMINAL PORT {RM PORT} ........ 254 Select scale port used to send data to a Remote Terminal.DISABLE RMPORT RESPONSE {RMNOPR} . 255 If ON – Disable sending ‘print’ type response to cmds received.ISOBUS BASE ADDRESS{ISOADR} ............. 256 Assign starting base the ISOBUS gateway should ‘address claim.’DISABLE ISOBUS VT MESSAGE{ISO VT} ... 257 If ON – Enable ISOBUS gateway to send VT messages.USE ISOBUS DDI VALUES{ISO DDI} ............ 258 If ON – Send ISO WT using ISOBUS DDI’s 229 & 232. OFF – use D/S legacy DDIs.PRINT ON PIN 2 {PRNT-2}............................ 261 If ON – Print data is sent out pin 2 of the Printer connector.COM 1-1 PARITY {C1-1PA} ............................ 271 Sets COM1-1 parity to 7E1, 8N1, or auto.COM 1-2 PARITY {C1-2PA} ........................... 272 Sets COM1-2 parity to 7E1, 8N1, or auto.COM 1-3 PARITY {C1-3PA} ........................... 273 Sets COM1-3 parity to 7E1, 8N1, or auto.COM 2 PARITY {C2 PA} .............................. 274 Sets COM2 parity to 7E1, 8N1, or auto.COM 1-1 BAUD RATE {C1-1BD} .................... 275 Sets COM1-1 baud rate to 1200, 2400, 4800, 9600, or auto.COM 1-2 BAUD RATE {C1-2BD} ................... 276 Sets COM1-2 baud rate to 1200, 2400, 4800, 9600, or auto.COM 1-3 BAUD RATE {C1-3BD} ................... 277 Sets COM1-3 baud rate to 1200, 2400, 4800, 9600, or auto.COM 2 BAUD RATE {C2 BD} ....................... 278 Sets COM2 baud rate to 1200, 2400, 4800, 9600, or auto.ESTIMATE WEIGHT {EST WT} ...................... 299 Adjust Gross weight of scale by changing the zero/balance.M ENU 3-S CALE C ALIBRATION S ETTINGSDISPLAY COUNT {COUNT} ........................... 301 Select display count size of weigh values.AUTO RANGE {ARANGE} .............................. 302 If ON - Auto increases the display count value by 1 count size at 300 lbs/kgs and 1more count size at 600 lbs/kgs.DISPLAY UNIT {LB-KG} ................................ 303 Display pounds - lb or kilograms - kgCAPACITY {CAP} ......................................... 304 Enter MAXIMUM weight measurable on scale.WM1 ADJUST 1 {WMA1-1} ............................. 305 Increase this number to smoothen weighing (2 to 100)WM1 ADJUST 2 {WMA1-2} ............................. 306 0=OFF. Use value less than WMA1-1 for quick weight response.WM1 ADJUST 3 {WMA1-3} ............................. 307 Enter the weight to activate quick weight response.WM2 ADJUST 1 {WMA2-1} ............................. 311 Increase this number to smoothen weighingWM2 ADJUST 2 {WMA2-2} ............................ 312 0=OFF. Use value less than WMA2-1 for quick weight response.WM2 ADJUST 3 {WMA2-3} ............................ 313 Enter the weight to activate quick weight response.MIMIC TYREL {TC1300} ............................... 321 If ON - Records preset weights like a Tyrel TCX-1300 Indicator.APPLICATION 10KMH {10K TA} ................... 322 If ON - Transmits application rate (Tons / Acre) for a speed of 10 KMH.APPLICATION UNITS {A UNIT} .................... 323 Enter application units in English or Metric.APPLICATION RATE {RATE } ...................... 324 Enter the desired rate in Tons per Acre (or Tonnes / Hectare).APPLICATION WIDTH {WIDTH } ................... 325 Enter the spread width in feet (or meters).GPS STORAGE INTERVAL {GPSSTR} ........ 326 Time interval used to store GPS data.TOTAL ACRES {ACRES } .............................. 327 Shows a running total of acres spread on the selected field.APP RATE ESTIMATE {ARATE1} .................. 331 The number of weight samples used for the application rate estimate. Increase valueto smoothen (2 to10).APP RATE AVERAGE {ARATE2} .................. 332 The number of rate samples averaged. Increase value to smoothen (1 to 5).APP RATE WINDOW {ARATE3} .................... 333 Determines range for minimum or maximum samples. Uses minimum samples whenoutside of window. 0 = ‘OFF’, 1 = RATE +/-RATE, 9 = RATE +/- 1/9RATE.APP MINIMUM SAMPLES {ARATE4} ............ 334 Minimum samples used in APP RATE WINDOW. Decrease for faster response.APP RATE EQUAL WEIGHTS {AWEQUL} ..... 335 Increase value for low application rates.APP RATE SPEED ADJUST {ARATE5} ........ 336 Select FAST for faster response when beginning to unload.APP RATE LOAD / UNLOAD {A L/UL } ....... 337 Select Load, Unload, or Auto detect for displaying T/A while loading or unloading.A,B,C Display Format {ABCDSP} ................. 341 Select Single (A,B,C), Total (A+B+C), or Combined (1 scale, 3 inputs) for ABC scales.M ENU 4-P RESET,B ATCHING &R OTATION C OUNTER F EATURESPRE ALARM {P MTHD} & {P-ALM} ................... 401 Select weight or percentage method, then enter a value to activate an early warningthat scale is reaching the preset.REMOTE INPUT {RM INP} ............................ 402 Set function of remote input line on the power cord.ALARM OUTPUT {AL OUT} ........................... 403 Select Preset OR TR to control Relay, Horn & Lamp. Switch to control Lamp.(continued)(continued)BUZZER {BUZZER} ........................................ 404 ALARM BUZZER–Alarm Horn can be shortened or turned OFF.PRELOAD TARE {PRETAR} .......................... 405 If ON - tare weights can be entered using the numeric keypadRELAY {RELAY} ............................................ 406 Select behavior for +12VDC Alarm Output.UNLOAD ALARM{U ALRM} ........................... 407 UNLOAD ALARM BUZZER- Alarm duration can be shortened or turned OFF. REMOTE SWITCH MESSAGE {RI MSG} ...... 411 Message that is displayed for remote input switch condition.REMOTE SWITCH STATE {RISTAT} ............ 412 Set remote input line state that displays message and/or illuminates alarm lamp.Open or Closed.REMOTE SWITCH MSG {RITIME}................. 413 Set how often the remote switch message is displayed. Once every 1-9 seconds. TIMER/COUNTER {TMRCTR} ........................ 421 Select time or mixer revolutions to decrement mix timer/counter.DRIVE RATIO {DRATIO} ................................ 422 Enter the number of input pulses that equal 1 mixer revolution.SET POINT {SETPNT} ................................... 423 Enter set point at which 12V Alarm output changes.CHANGE WEIGHT {SETCHG}........................ 424 Enter the weight below the set point for output to change.CHANGE DELAY {SETDEL} .......................... 425 Time 12V Alarm output remains constant before it changes.SET OVER UNDER {SETOUT} ...................... 426 Select ON for +12VDC ALARM when Over or UNDER set point.SET POINT COUNTER {SETCTR} ................. 427 Counts how many times set point is activated.RECIPE KEYS {RECKEY} .............................. 438 If ON - disables certain keys when Loading / Unloading Recipe.PROGRAM RECIPE {PROGRM} ..................... 439 Selects program method, PC or at SCALE.ENTRY METHOD {E MTHD} ......................... 441 Select batching 1-amount/animal 2-percent/load 3-amount/load.TOLERANCE {TOLER} .................................. 442 Select weight or percentage method, then enter a value to accept ingredient or turnoff relay output on Seed Tender models.INGR.ADVANCE DELAY{DELAY} ................. 443 Select seconds to delay before advancing to next ingredient.INGREDIENT NAMES {INGRNM} ................... 444 If ON - displays ingredient names while batching.ACCUMULATION {ACCUM} ........................... 445 If ON - ingredient weights are accumulated while batching.FORCE USER ID {USERID} ........................... 446 If ON - operator MUST enter User ID to use scale.MEDIA STORAGE{MSTORE} ......................... 447 Select MANUAL, AUTO or Quick START methods for transferring recipe informationwith the DDL or Datakey.RESIZE 3500 RECIPE{RESIZE} .................... 448 If ON - operator can change EZ3500 recipe size.INGREDIENT RE-SIZING {INGSIZ} ............... 449 Selects Automatic Ingredient Re-Sizing mode.RECIPE TOTAL {RECTOT}............................. 451 Selects Total amount to be displayed when starting recipe.DISPLAY SCOOP % {SCOOP%} ................... 452 If ON - displays scoop percentage to load.TOLER OVER LOCK {OVERLK} ................... 453 If ON - prevents auto-advancing if preset exceeds toleranceFEED ZONE {FDZONE} .................................. 454 Select feed zone for recipe deliveries.UNDONE RECIPES {UNDN I } ...................... 455 If ON - displays all incomplete recipes.DISPLAY RECIPE PENS {RECPEN} .............. 456 If ON - pens are displayed when selecting recipes.RANGE TEST {R-TEST} ................................ 457 If ON -Feedlines sent from DataLink are marked "done".AUTO START PENS {AUTPEN}..................... 458 If ON -Starts Pens List after Recipe is loaded.ERASE DONE FEEDLINE{ERASFD} ............. 459 If ON -Erases done feedlines after data transfer.MANUAL PEN ADVANCE{MANPEN} ............. 461 If ON -Overrides Automatic advance for Pens.PEN TOL {T MTHD} & {PENTOL} ....................... 462 Select weight or percentage method, then enter pen tolerance.PEN WEIGHT {PEN WT} ................................ 463 Select method for displaying pen weight - Net, Load, or Gross.BATCH NUMBER {BATNUM} ......................... 464 Select either PC or EZ to control the batch number.DOUBLE KEY {DBLKEY} ............................... 465 Ignore extra INGR ADVANCE keys while feeding.RECIPE REMAIN ACTIVE{RE-US E} ............. 466 Allows recipes to be RE-USED for another load.RECIPE STARTED WEIGHT{RSTART} ......... 467 This weight threshold determines if the recipe has been started.RECIPE ENTRY METHOD{RENTRY} ........... 468 Select recipe start method - recipe name or batch number.PARTIAL FEEDING {PARTFD} ...................... 469 If ON –Partial feedings will be recorded.PEN STARTED WEIGHT {PSTART} .............. 471 This weight threshold determines if the feeding has been started.SPLIT LOAD {SPLOAD} ................................. 472 If ON –Pen presets are re-calculated after each ingredient/pen.NUMBER OF INGREDIENTS {NUMING} ........ 473 Number of ingredients in the Ingredient Name Table- D.A.N. 444STARTING PRESET WEIGHT {STPRST} ..... 474 If ON –Return the starting preset in the timer/bunk read field of feedlinePRESET ACTIVE SIG. TIMEOUT{PAST} ..... 475 Time to continue preset active signal after preset is reached.UNLOAD WEIGHT DISPLAY {UNWEDI} ........ 476 NET = From zero, GROSS = Display total weight, LOAD = Unload from presetAUTO LOAD PRESET {alp} ....................... 477 If ON – Load the stored preset when unloading begins.VARIABLE THROTTLE {STTHRO} ................. 478 If ON – Enables seed tender variable throttle controlPRESET DELAY{PRTDLY} ............................ 479 If ON – Uses ingredient advance delay to clear a normal presetM ENU 5–C ONTROL S ETTINGSDOOR SETUP{UGDOOR} ............................... 501 If ON – Grain cart door control features enabled.UV GRAIN SOLONOID{UG3SOL} .................. 502 If ON – Scale uses 3 solenoids. If OFF – Scale uses 2 solenoids.PARTIAL LOAD {Truck } ............................. 503 If ON – Scale uses truck preset and remainder when loading.SPLIT HOPPER ALARM{S ALRM} ................ 504 Select length of time alarm sounds off when switching hoppers .SPLIT HOPPER PREALARM{SPALRM} ........ 505 Select weight difference to begin displaying message to switch hoppers .DOOR OPEN WEIGHT{DOOROW} ................. 506 Select unload weight before door begins to open.DOOR DEBUG MODE{DDEBUG} .................. 507 Sends door debug information out COM1 serial port.DIAGNOSTIC ENABLE{DIAG} .................... 508 ON enables diagnostic information - Press Select to display “DIAG”, then pressFunction to display RPM.DOOR OPEN TIME{DOOR OT} ....................... 509 Select the time required to fully open the grain door when closed.DOOR OPEN PERCENTAGE{DOOROP} ....... 511 Set the percentage the door will open.(continued)(continued)DOOR CLOSE TIME{DOORCT} ..................... 512 Select the time required to fully close the grain door when open.DOOR CLOSE WINDOW{DOORWT} .............. 513 Set the window for minimum weight change before door will close.DOOR INSIDE WINDOW TIME{DOORIT} ...... 514 Set the maximum time a weight can stay in the weight window before door closes. DOOR PREALARM OFFSET{DOORP O} ........ 515 Set the weight to switch from higher weight to lower weight.DOOR PREALARM SCALER{DOORPS} 516 Decrease if unloaded results are consistently lower than expected. Set higher ifunloaded results are consistently higher than expected.ADAPTIVE AUGER WEIGHT MAX{AUGRMX}517 Set the maximum adaptive weight change.LEFTOVER AUGER WEIGHT{AUGRWT} ....... 518 Set to modify Door Adaptive Weight.AUGER WEIGHT SCALAR GAIN{D R AWGN} . 519 Increase value for faster adaptation, decrease for slower adaptation.DOOR WEIGHT CLOSING{DOORWC} ........... 521 Set the weight for when the grain door should start closing.RPM START/STOP CONTROL{RSSCTL} ..... 531 ON enables AUTOLOG feature( RPM automatic start/stop control feature )RPM STOP SPEED{RSSMIN} ........................ 532 Set to 20-50% of PTO operating RPMS. Stop is activated using this value.RPM START TOL SPEED{RSStol} ............. 533 Set to 10% of PTO operating RPMS. Start is activated using this value + D.A.N. 532 RPM START DELAY{RSSTDY} ..................... 534 Start activated when RPMS above D.A.N 532 + D.A.N. 533 for this time is seconds RPM STOP DELAY{RSSPDY} ....................... 535 Stop activated when RPMS below D.A.N 532 for this time is secondsRPM CONTROL {RPMCTL}……………………536 ON enables RPM control feature. Use with D.A.N 537 and D.A.N 538RPM CONTROL MIN {RPMMIN}………………537 Set to minimum operating RPM value. Must be larger than RSSCTL (D.A.N 531) RPM CONTROL SPEED {RPMTOL}………….538 Set to between 5% and 20% of PRMMIN (D.A.N. 537)RPM CONTROL DELAY {RPMDLY}………….539 Time in seconds to delay door closingDEMO MODE {UGDEMO}………………………541 Demo ModeCALIB-C ALIBRATIONTEMP CALIBRATION {T CALB} .................... 801 If ON - scale adjust for temperature changes.DEAD WEIGHT CAL {CAL} .......................... 802 Calibration method using weights.SHORT FORM - CALIBRATION SETTINGSSETUP NUMBER {SETUP} ........................... 871 Quick entry value to select weigh method (1-4 lb) (5-8 kg), gain (1-9), display counts(0-9), and capacity (*1000)CALIBRATION NUMBER {CAL} .................. 872 Weight displayed at 0.4mV/V for these loadcells.。
数据库OCM认证培训大纲(oracle认证大师)
数据库OCM认证培训大纲（oracle认证大师）Oracle DBA大师班（10g OCM方向）1. 超过90%的Oracle认证专家认为Oracle认证增加了他们的专业可信度2. 超过90%的认证专家认为Oracle认证提高了他们的工作效率3. 89%的认证专家认为Oracle认证使他们有能力提供更高水准的客户服务4. 超过88%的认证专家认为Oracle认证使他们更有实力承担复杂的IT任务5. 92%的认证专家认为Oracle认证使他们的事业得到了更好的发展OCM培训介绍Oracle Certified Master (OCM) -Oracle认证大师，是Oracle认证的最高级别，是对数据库从业人员的技术、知识和操作技能的最高级别的认可。
Oracle OCM是解决最困难的技术难题和最复杂的系统故障的最佳Oracle专家人选，也是IT行业衡量IT专家和经理人的最高专业程度及经验的基准。
OCM不但有能力处理关键业务数据库系统和应用，还能帮助客户解决所有的Oracle技术困难，将成为企业内的资深专家和顾问。
通过这个课程使ORACLE数据库专家掌握了大型Oracle数据库在Linux/Unix平台上的网格、集群、灾备、调优、数据仓库、安全等高级维护技术，有资格成为大型数据中心行业权威。
OCM培训适合对象欲挑入年薪在15万-25万行业的在职者欲从事的Oracle 技术专家职位在校大学生（计算机相关专业）欲转行为企业ERP顾问的软件开发人员欲进入外企、银行、软件公司、国企从事IT信息技术职位的某职者OCM培训学习时间&培训班型OCM培训课程内容课程一：Oracle10g 服务器配置课程简介：通过本课程使的数据库工程技术人员能够了解OCM认证的考试形式、时间安排和注意事项，帮助学员掌握手工创建数据库和表空间，配置数据库监听器等任务。
课程内容：1. OCM考试简介2. 运用脚本创建数据库2. 确定和设置有关数据库架构的参数3. 条带化数据文件4. 创建与管理复用控制文件5. 大文件表空间管理6. 创建与管理多网络配置文件7. 监听器配置8. 共享数据库服务器的监听器配置9. 网络跟踪配置10. 管理Oracle 网络进程11．优化数据访问性能12. 临时、永久、UNDO表空间管理工具软件：Oracle 10g/11g Database 、Listener、SQL/PLUS课程二：Oracle10g网格计算与控制课程简介：Oracle网格计算使多组联网计算机能够组织到一起并按需进行共享，以满足不断变化的业务需求。
Oracle数据库运维管理培养方案
具备实际独立运维能力、能够胜任数据库一线运维工程师的中级 DBA。
培养方案：
1. 通过 ORACLE 自动存储管理的实训，对 ORACLE 初始化版本的 ASM 和最新的 ASM 产品
的功能熟悉，熟练掌握磁盘组之间 ORACLE 数据库的迁移等； 2. 数据库升级实训，让学员可以对 ORACLE 数据库进行版本升级，数据字典升级，确保可以
根据客户生产环境需要安全升级等； 3. 数据库迁移实训，对数据库异机迁移进行实训，数据库异版本、异构存储进行迁移实训，存
储类型包括文件系统、裸设备、ORACLE ASM，版本涵盖目前的 11.2.0 版本等； 4. 数据库运维常见场景实训，对日常运维中常用脚本进行实训，模拟各种可能出现的应用场景，
训练学员熟练掌握各种脚本的用途及用法，培养学员的数据库思维意识,加深学员对数据库 架构及基本原理的理解，帮助学员快速掌握数据库快速诊断技术。（常见等待事件，常见异 常及处理流程均包含在内）； 5. 数据库可用性设计能力实训，训练学员养成数据库停机时间窗口意识，设计多种应用需求， 对学员进行备份及恢复策略制定的实训，培养学员对数据库的数据安全意识（RMAN 恢复， ARCH 监控，数据库恢复时间窗口控制等均包含在内）； 6. 数据库巡检实训，训练学员使用 STATSPACK、AWR、ASH、ADDM 等工具，对数据库进 行例行检查，增强其对数据库各项指标的理解能力，同时加强其对数据库性能的理解力。 7. 数据库可用性实训中包括对数据库数据文件的 BLOCK 编辑、坏块处理，控制文件修复等。
技能要求：
1. 熟悉 SQL 语句，ORACLE 数据库基本原理，对数据库架构理解透彻； 2. 熟悉一种 LINUX 或者 UNIX 系统平台，熟练运用 Linux/UNIX 进行数据库管理； 3. 具备设计和实施 ORACLE 备份和恢复方案的能力，熟练掌握在各种场景及应用需求下数据
韩顺平老师oracle视频教程听课笔记
韩顺平老师 oracle教程笔记1.Oracle认证，与其它数据库比较，安装Oracle安装会自动的生成sys用户和system用户:（1）sys用户是超级用户，具有最高权限，具有sysdba角色，有create database的权限，该用户默认的密码是change_on_install （2）system用户是管理操作员，权限也很大。
具有sysoper角色，没有create database的权限，默认的密码是manager （3）一般讲，对数据库维护，使用system用户登录就可以拉也就是说sys和system这两个用户最大的区别是在于有没有create database的权限。
2.Oracle的基本使用--基本命令sql*plus的常用命令连接命令1.conn[ect]用法：conn 用户名/密码@网络服务名[as sysdba/sysoper]当用特权用户身份连接时，必须带上as sysdba或是as sysoper 2.disc[onnect]说明: 该命令用来断开与当前数据库的连接3.psssw[ord]说明: 该命令用于修改用户的密码，如果要想修改其它用户的密码，需要用sys/system登录。
4.show user说明: 显示当前用户名5.exit说明: 该命令会断开与数据库的连接，同时会退出sql*plus文件操作命令1.start和@说明: 运行sql脚本案例: sql>@ d:\a.sql或是sql>start d:\a.sql2.edit说明: 该命令可以编辑指定的sql脚本案例: sql>edit d:\a.sql,这样会把d:\a.sql这个文件打开3.spool说明: 该命令可以将sql*plus屏幕上的内容输出到指定文件中去。
案例: sql>spool d:\b.sql 并输入 sql>spool off交互式命令1.&说明：可以替代变量，而该变量在执行时，需要用户输入。