关于oracle的continue

在不支持continue的oracle版本(11G之前),怎么实现continue功能呢?求大神解惑。

2个回答

lzyyqxxh
lzzyqxxh 额,谢谢了,不过跟我想要的答案有点差距啊……
4 年多之前 回复

使用goto可以代替continue

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
mysql 异常处理 CONTINUE HANDLER FOR SQLEXCEPTION

一个存储过程,循环表数据,遇到异常回滚,如果插入发生错误,删除还能正常执行,不能回滚 DECLARE CONTINUE HANDLER FOR SQLEXCEPTION 不能回滚吗 DELIMITER $$ DROP PROCEDURE IF EXISTS `test`$$ CREATE DEFINER=`ydkj`@`%` PROCEDURE `test`() BEGIN DECLARE done INT ; DECLARE order_id BIGINT ; DECLARE order_cursor CURSOR FOR SELECT id FROM order_info a WHERE a.`DEL_FLAG` = '1' OR a.`STATUS` = '99' ; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1 ; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; COMMIT ; END ; OPEN order_cursor ; -- 循环 order_loop : LOOP -- 取游标中的数据 FETCH order_cursor INTO order_id ; IF done = 1 THEN LEAVE order_loop ; END IF ; START TRANSACTION ; INSERT INTO _order SELECT NOW(),a.* FROM order_ext a WHERE a.order_id = order_id ; DELETE FROM t_cargo_order_info WHERE id = cargo_order_id ; COMMIT; END LOOP ; CLOSE order_cursor ; END$$ DELIMITER ;

Navicat for Oracle 创建执行计划 执行存储过程报错

**Navicat for Oracle 创建执行计划 执行存储过程报错** 当创建执行计划时: --自动执行*1小时 ``` Declare jobno Number; Begin dbms_job.submit(:jobno,'ur_procedure;',Sysdate,'sysdate+1/24'); commit; end; ``` 提示 > [Err] ORA-01008: 并非所有变量都已绑定 还有网上有说计划名称前不加:(冒号)的,但依旧报错 > > [Err] ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" 有错误 > ORA-06508: PL/SQL: 无法找到正在调用 : "SYS.DBMS_INTERNAL_LOGSTDBY" 的程序单元 > ORA-06512: 在 "SYS.DBMS_JOB", line 126 > ORA-06512: 在 line 4 > 用的Navicat for Oracle 但搜的的创建执行计划只有上边的那种, 新手,求大神指点,谢谢

linux下Oracle安装之后重启监听失败。具体情况见下 、还往大家帮忙

我的操作是安装oracle之后、尝试连接 [oracle@linux64 ~]$ sqlplus / as sysdba Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> SQL> SQL> set linesize 2000; SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO --------------- ---------------- ---------------------------------------------------------------- ----------------- ------------ ------------ --- ---------- ------- ------------------------------ ---------- --- ----------------- ------------------ --------- --- 1 trade linux64 11.2.0.1.0 05-SEP-15 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO 通过这个查询 应该说明我库应该是配置了,监听也起来了、我想试着重启一下监听。就先查看了下监听的状态、然后stop监听、再start 监听就起不来了 ORACLE安装完成后直接查看监听状态 [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:02 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 18:58:31 Uptime 0 days 0 hr. 28 min. 31 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) Services Summary... Service "trade" has 1 instance(s). Instance "trade", status READY, has 1 handler(s) for this service... Service "tradeXDB" has 1 instance(s). Instance "trade", status READY, has 1 handler(s) for this service... The command completed successfully 关闭监听 [oracle@linux64 ~]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:35 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The command completed successfully 再次打开监听 [oracle@linux64 ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:40 Copyright (c) 1991, 2009, Oracle. All rights reserved. Starting /home/oracle/oracle/product/11R2/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /home/oracle/oracle/product/11R2/network/admin/listener.ora Log messages written to /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully ----再次查看监听状态 [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:44 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 4 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully [oracle@linux64 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-SEP-2015 19:27:47 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 05-SEP-2015 19:27:40 Uptime 0 days 0 hr. 0 min. 7 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/oracle/product/11R2/network/admin/listener.ora Listener Log File /home/oracle/oracle/diag/tnslsnr/linux64/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux64)(PORT=1521))) The listener supports no services The command completed successfully

executing oracle import utility please wait

oracle好久没用了,今天想在上边练习个项目,结果plsql导入dmp文件的时候报这个错误,有那个大神知道吗?![图片说明](https://img-ask.csdn.net/upload/201702/19/1487509310_974032.png)

Oracle查询结果集超过100M,超过后的数据怎么也一起查询出来?

result set exceeds the maximum size (100MB).if necessary,you can explicity continue this query Oracle查询结果集超过100M,超过后的数据怎么也一起查询出来?我要查询的数据大约有100万条左右 有没有办法一次性查出来 我现在是用rownum分段查询,可是这样太慢了,已经过了1个多小时了,还没查询完

用vbox在windows2008 server上安装 oracle 11g rac 遇到节点连接性检查失败

用vbox在windows2008 server上安装 oracle 11g rac 遇到节点连接性检查失败 在rac1安装grid的时候,提示节点连接性失败 安装日志如下 Using paramFile: C:\home\win64_11gR2_grid\grid\install\oraparam.ini Checking monitor: must be configured to display at least 256 colors. Actual 65536 Passed The commandline for unzip: C:\home\win64_11gR2_grid\grid\install\unzip -qqqo ..\stage\Components\oracle.jdk\1.5.0.17.04\1\DataFiles/"*.jar" -d "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM" INFO: Loading data from: jar:file:/C:/Windows/Temp/1/OraInstall2013-12-26_11-52-53AM/ext/jlib/installcommons_1.0.0b.jar!/oracle/install/driver/oui/resource/ConfigCommandMappings.xml INFO: Loading beanstore from jar:file:/C:/Windows/Temp/1/OraInstall2013-12-26_11-52-53AM/ext/jlib/installcommons_1.0.0b.jar!/oracle/install/driver/oui/resource/ConfigCommandMappings.xml INFO: Restoring class oracle.install.driver.oui.ConfigCmdMappings from jar:file:/C:/Windows/Temp/1/OraInstall2013-12-26_11-52-53AM/ext/jlib/installcommons_1.0.0b.jar!/oracle/install/driver/oui/resource/ConfigCommandMappings.xml INFO: Verifying target environment... INFO: Checking whether the IP address of the localhost could be determined... INFO: Completed verification of target environment. INFO: Inventory exists: false INFO: 注册设置 bean INFO: 构建流 INFO: Building the flow graph INFO: Loaded state init INFO: Loaded state ClusterInfoUI INFO: Loaded state InstallOptionsUI INFO: Loaded state ChecklistUI INFO: Loaded state InstallTypeUI INFO: Loaded state QuickInstallUI INFO: Loaded state productLanguage INFO: Loaded state flowDecider INFO: Loaded state CRSNodeSelectionUI INFO: Loaded state SCANInformationUI INFO: Loaded state getASMSNMPPassword INFO: Loaded state GridPlugPlayInfoUI INFO: Loaded state CRSNodeInformationUI INFO: Loaded state NetworkInterfaceUI INFO: Loaded state StorageOptionUI INFO: Loaded state CreateASMDiskGroupQI INFO: Loaded state CreateASMDiskGroup INFO: Loaded state ASMInstanceCredentialsGUI INFO: Loaded state DiskManagerGUI INFO: Loaded state WinOCRStorageUI INFO: Loaded state WinVDSKStorageUI INFO: Loaded state FailureIsolationUI INFO: Loaded state preInstallLocation INFO: Loaded state InstallLocationUI INFO: Loaded state CRSInstallLocationUI INFO: Loaded state prereqExecutionDecider INFO: Loaded state performChecks INFO: Loaded state showSummary INFO: Loaded state setup INFO: Loaded state finish INFO: Linking states INFO: State[ASMInstanceCredentialsGUI]: route=FRESH_HA_INSTALL; to=preInstallLocation INFO: State[ASMInstanceCredentialsGUI]: route=IPMI_SUPPORTED; to=FailureIsolationUI INFO: State[ASMInstanceCredentialsGUI]: route=IPMI_UNSUPPORTED; to=preInstallLocation INFO: State[CRSInstallLocationUI]: route=INVENTORY_ABSENT; to=prereqExecutionDecider INFO: State[CRSInstallLocationUI]: route=success; to=prereqExecutionDecider INFO: State[CRSNodeInformationUI]: route=success; to=NetworkInterfaceUI INFO: State[CRSNodeSelectionUI]: route=success; to=SCANInformationUI INFO: State[ChecklistUI]: route=success; to=InstallTypeUI INFO: State[ClusterInfoUI]: route=success; to=QuickInstallUI INFO: State[CreateASMDiskGroup]: route=success; to=ASMInstanceCredentialsGUI INFO: State[CreateASMDiskGroupQI]: route=inventory; to=prereqExecutionDecider INFO: State[CreateASMDiskGroupQI]: route=prereq; to=prereqExecutionDecider INFO: State[DiskManagerGUI]: route=success; to=WinOCRStorageUI INFO: State[FailureIsolationUI]: route=success; to=preInstallLocation INFO: State[GridPlugPlayInfoUI]: route=success; to=CRSNodeInformationUI INFO: State[InstallLocationUI]: route=INVENTORY_ABSENT; to=prereqExecutionDecider INFO: State[InstallLocationUI]: route=success; to=prereqExecutionDecider INFO: State[InstallOptionsUI]: route=crs; to=InstallTypeUI INFO: State[InstallOptionsUI]: route=success; to=productLanguage INFO: State[InstallTypeUI]: route=advanced; to=productLanguage INFO: State[InstallTypeUI]: route=typical; to=ClusterInfoUI INFO: State[NetworkInterfaceUI]: route=success; to=StorageOptionUI INFO: State[QuickInstallUI]: route=ASM; to=CreateASMDiskGroupQI INFO: State[QuickInstallUI]: route=inventory; to=prereqExecutionDecider INFO: State[QuickInstallUI]: route=prereq; to=prereqExecutionDecider INFO: State[SCANInformationUI]: route=noupgradeASM; to=preInstallLocation INFO: State[SCANInformationUI]: route=upgradeASM; to=getASMSNMPPassword INFO: State[StorageOptionUI]: route=ASM; to=CreateASMDiskGroup INFO: State[StorageOptionUI]: route=SHARED_FILE_SYSTEM; to=DiskManagerGUI INFO: State[WinOCRStorageUI]: route=success; to=WinVDSKStorageUI INFO: State[WinVDSKStorageUI]: route=IPMI_SUPPORTED; to=FailureIsolationUI INFO: State[WinVDSKStorageUI]: route=IPMI_UNSUPPORTED; to=preInstallLocation INFO: State[flowDecider]: route=FRESH_CRS_INSTALL; to=GridPlugPlayInfoUI INFO: State[flowDecider]: route=FRESH_HA_INSTALL; to=CreateASMDiskGroup INFO: State[flowDecider]: route=SWONLY_INSTALL; to=preInstallLocation INFO: State[flowDecider]: route=UPGRADE_CRS; to=CRSNodeSelectionUI INFO: State[flowDecider]: route=UPGRADE_HA; to=getASMSNMPPassword INFO: State[getASMSNMPPassword]: route=success; to=preInstallLocation INFO: State[init]: route=success; to=InstallOptionsUI INFO: State[performChecks]: route=success; to=showSummary INFO: State[preInstallLocation]: route=CRS_NO; to=InstallLocationUI INFO: State[preInstallLocation]: route=CRS_YES; to=CRSInstallLocationUI INFO: State[prereqExecutionDecider]: route=executeprereqs; to=performChecks INFO: State[prereqExecutionDecider]: route=ignoreprereqs; to=showSummary INFO: State[productLanguage]: route=productlanguage_yes; to=flowDecider INFO: State[setup]: route=success; to=finish INFO: State[showSummary]: route=success; to=setup INFO: Successfully built the flow INFO: Opening bean stores from which the beans can be loaded INFO: Loading beanstore from a given input stream INFO: Translating external format into raw format INFO: Registering the flow data beans INFO: [INS-07001] 在 BeanStore 中找不到属性 'CRSNodeList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_PublicNodeListWithoutDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_SCANName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_SCANPortNumber' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_ClusterName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VotingDiskRedundancy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_OCRRedundancy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_StorageOption' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_ConfigureGNS' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_UseIPMI' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_GNSSubDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_GNSVIPAddress' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_OCRLocations' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VotingDiskLocations' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_ClusterNodeList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_SelectedNodesForUpgrade' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.crs.interfaceList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_configuredCRSHome' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VIPNodeListWithoutDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_WindowsSystemDirectory' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'activeCRSVersion' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'activeCRSHomeName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_AutoConfig' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VIPNodeListWithDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'CLUSTER_CONFIGURATION_FILE' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_FinalInterfaceList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.crs.storageOption' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_BMCUsername' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_BMCPassword' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchOifcfg' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCluvfy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCRSInst' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCRSUpgrd' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_AdvancedInstall' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_DiskDriveMapping' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_HOME' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_BASE' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'FROM_LOCATION' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TOPLEVEL_COMPONENT' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TopLevelComponentVersion' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_InstallOption' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_UpgradeOption' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_OSDBA' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_OSOPER' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_OSASM' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_asm_MigrateASM' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_asm_DiskGroupName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_asm_DiskGroupRedundancy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_asm_DiskDiscoveryString' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_asm_Disks' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.disks' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.name' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.redundancy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.diskDiscoveryString' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_asm_SYSASMPassword' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.OSASM' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_asm_MonitorPassword' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchASMCA' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_HOME' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_BASE' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'FROM_LOCATION' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TOPLEVEL_COMPONENT' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TopLevelComponentVersion' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchRootBat' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchUpdateNodeList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'INVENTORY_LOCATION' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'UNIX_GROUP_NAME' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'SELECTED_LANGUAGES' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'COLLECTOR_RESPONSE_FILE' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'MYORACLESUPPORT_USERNAME' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'MYORACLESUPPORT_PASSWORD' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'DECLINE_SECURITY_UPDATES' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'PROXY_HOST' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'PROXY_PORT' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'PROXY_USER' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'PROXY_PWD' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'SECURITY_UPDATES_VIA_MYORACLESUPPORT' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'COLLECTOR_IGNORE_FAILURES' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'COLLECTOR_IGNORE_CONFIGURATION' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_HOSTNAME' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'CRSNodeList' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_PublicNodeListWithoutDomain' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_configuredCRSHome' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VIPNodeListWithoutDomain' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_WindowsSystemDirectory' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'activeCRSVersion' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'activeCRSHomeName' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VIPNodeListWithDomain' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'CLUSTER_CONFIGURATION_FILE' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_FinalInterfaceList' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.crs.storageOption' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchOifcfg' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCluvfy' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCRSInst' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCRSUpgrd' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_AdvancedInstall' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'FROM_LOCATION' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'TOPLEVEL_COMPONENT' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'TopLevelComponentVersion' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_UpgradeOption' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.disks' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.name' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.redundancy' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.diskGroup.diskDiscoveryString' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.asm.OSASM' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchASMCA' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'FROM_LOCATION' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'TOPLEVEL_COMPONENT' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'TopLevelComponentVersion' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchRootBat' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchUpdateNodeList' 的值。 WARNING: [INS-07001] 在 BeanStore 中找不到属性 'OCMSettings' 的值。 INFO: Set value for bean CRSSetupBean INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_HOME' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_BASE' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'FROM_LOCATION' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TOPLEVEL_COMPONENT' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TopLevelComponentVersion' 的值。 WARNING: Failed to load bean oracle.install.ivw.ha.bean.HAInstallSettings. Reason: [INS-07001] 在 BeanStore 中找不到属性 'HAInstallSettings' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'CRSNodeList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_PublicNodeListWithoutDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_SCANName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_SCANPortNumber' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_ClusterName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VotingDiskRedundancy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_OCRRedundancy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_StorageOption' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_ConfigureGNS' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_UseIPMI' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_GNSSubDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_GNSVIPAddress' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_OCRLocations' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VotingDiskLocations' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_ClusterNodeList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_SelectedNodesForUpgrade' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.crs.interfaceList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_configuredCRSHome' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VIPNodeListWithoutDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_WindowsSystemDirectory' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'activeCRSVersion' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'activeCRSHomeName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_AutoConfig' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_VIPNodeListWithDomain' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'CLUSTER_CONFIGURATION_FILE' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_FinalInterfaceList' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle.install.crs.storageOption' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_BMCUsername' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_BMCPassword' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchOifcfg' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCluvfy' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCRSInst' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_LaunchCRSUpgrd' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_AdvancedInstall' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'oracle_install_crs_DiskDriveMapping' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_HOME' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ORACLE_BASE' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'FROM_LOCATION' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TOPLEVEL_COMPONENT' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'TopLevelComponentVersion' 的值。 WARNING: Failed to load bean oracle.install.ivw.crs.bean.CRSInstallSettings. Reason: [INS-07001] 在 BeanStore 中找不到属性 'CRSInstallSettings' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'Enabled' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'Nodes' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'Username' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'Password' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ReuseKeys' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'SharedHome' 的值。 WARNING: Failed to load bean oracle.install.commons.net.support.SSHConnectivitySetupInfo. Reason: [INS-07001] 在 BeanStore 中找不到属性 'SSHConnectivitySetupInfo' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ClusterwareName' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ClusterNodes' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'Readonly' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'ClusterwareType' 的值。 INFO: [INS-07001] 在 BeanStore 中找不到属性 'Validated' 的值。 WARNING: Failed to load bean oracle.install.library.util.cluster.ClusterConfig. Reason: [INS-07001] 在 BeanStore 中找不到属性 'ClusterConfig' 的值。 INFO: Closing bean stores from which the beans can be loaded INFO: Registering the flow views INFO: Adding View[type: oracle.install.commons.base.interview.common.view.PrereqGUI viewId: null uiType: null] INFO: oracle.install.commons.base.interview.common.view.PrereqGUI added to View Type Registry with the key as [PrereqUI] INFO: Adding View[type: oracle.install.commons.base.interview.common.view.SummaryGUI viewId: null uiType: null] INFO: oracle.install.commons.base.interview.common.view.SummaryGUI added to View Type Registry with the key as [SummaryUI] INFO: Adding View[type: oracle.install.commons.base.interview.common.view.SetupGUI viewId: null uiType: null] INFO: oracle.install.commons.base.interview.common.view.SetupGUI added to View Type Registry with the key as [SetupUI] INFO: Adding View[type: oracle.install.ivw.common.view.ProductLanguageGUI viewId: ProductLanguageUI uiType: null] INFO: oracle.install.ivw.common.view.ProductLanguageGUI added to View Type Registry with the key as [ProductLanguageUI] INFO: Adding View[type: oracle.install.ivw.crs.view.FinishGUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.FinishGUI added to View Type Registry with the key as [FinishUI] INFO: Adding View[type: oracle.install.ivw.crs.view.InstallOptionsUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.InstallOptionsUI added to View Type Registry with the key as [InstallOptionsUI] INFO: Adding View[type: oracle.install.ivw.crs.view.InstallLocationUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.InstallLocationUI added to View Type Registry with the key as [InstallLocationUI] INFO: Adding View[type: oracle.install.ivw.crs.view.CRSInstallLocationGUI viewId: CRSInstallLocationUI uiType: null] INFO: oracle.install.ivw.crs.view.CRSInstallLocationGUI added to View Type Registry with the key as [CRSInstallLocationUI] INFO: Adding View[type: oracle.install.ivw.crs.view.GridPlugPlayInfoUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.GridPlugPlayInfoUI added to View Type Registry with the key as [GridPlugPlayInfoUI] INFO: Adding View[type: oracle.install.ivw.crs.view.ClusterConfigGUI viewId: ClusterConfigUI uiType: null] INFO: oracle.install.ivw.crs.view.ClusterConfigGUI added to View Type Registry with the key as [ClusterConfigUI] INFO: Adding View[type: oracle.install.ivw.crs.view.NetworkInterfaceUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.NetworkInterfaceUI added to View Type Registry with the key as [NetworkInterfaceUI] INFO: Adding View[type: oracle.install.ivw.crs.view.StorageOptionUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.StorageOptionUI added to View Type Registry with the key as [StorageOptionUI] INFO: Adding View[type: oracle.install.ivw.crs.view.ASMDiskGroupCreationGUI viewId: ASMDiskGroupCreationUI uiType: null] INFO: oracle.install.ivw.crs.view.ASMDiskGroupCreationGUI added to View Type Registry with the key as [ASMDiskGroupCreationUI] INFO: Adding View[type: oracle.install.ivw.crs.view.WinOCRStorageGUI viewId: WinOCRStorageUI uiType: null] INFO: oracle.install.ivw.crs.view.WinOCRStorageGUI added to View Type Registry with the key as [WinOCRStorageUI] INFO: Adding View[type: oracle.install.ivw.crs.view.WinVDSKStorageGUI viewId: WinVDSKStorageUI uiType: null] INFO: oracle.install.ivw.crs.view.WinVDSKStorageGUI added to View Type Registry with the key as [WinVDSKStorageUI] INFO: Adding View[type: oracle.install.ivw.crs.view.FailureIsolationUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.FailureIsolationUI added to View Type Registry with the key as [FailureIsolationUI] INFO: Adding View[type: oracle.install.ivw.crs.view.ASMInstanceCredentialsGUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.ASMInstanceCredentialsGUI added to View Type Registry with the key as [ASMInstanceCredentialsGUI] INFO: Adding View[type: oracle.install.ivw.crs.view.CRSNodeSelectionUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.CRSNodeSelectionUI added to View Type Registry with the key as [CRSNodeSelectionUI] INFO: Adding View[type: oracle.install.ivw.crs.view.SCANInformationUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.SCANInformationUI added to View Type Registry with the key as [SCANInformationUI] INFO: Adding View[type: oracle.install.ivw.crs.view.PrivilegedOSGroupsGUI viewId: null uiType: null] INFO: oracle.install.ivw.crs.view.PrivilegedOSGroupsGUI added to View Type Registry with the key as [PrivilegedOSGroupsUI] INFO: Adding View[type: oracle.install.ivw.crs.view.ChecklistGUI viewId: ChecklistUI uiType: null] INFO: oracle.install.ivw.crs.view.ChecklistGUI added to View Type Registry with the key as [ChecklistUI] INFO: Adding View[type: oracle.install.ivw.crs.view.InstallTypeGUI viewId: InstallTypeUI uiType: null] INFO: oracle.install.ivw.crs.view.InstallTypeGUI added to View Type Registry with the key as [InstallTypeUI] INFO: Adding View[type: oracle.install.ivw.crs.view.QuickInstallGUI viewId: QuickInstallUI uiType: null] INFO: oracle.install.ivw.crs.view.QuickInstallGUI added to View Type Registry with the key as [QuickInstallUI] INFO: Adding View[type: oracle.install.ivw.crs.view.ClusterInfoUI viewId: ClusterInfoUI uiType: null] INFO: oracle.install.ivw.crs.view.ClusterInfoUI added to View Type Registry with the key as [ClusterInfoUI] INFO: Adding View[type: oracle.install.ivw.crs.view.DiskManagerGUI viewId: DiskManagerGUI uiType: null] INFO: oracle.install.ivw.crs.view.DiskManagerGUI added to View Type Registry with the key as [DiskManagerGUI] INFO: Adding View[type: oracle.install.ivw.crs.view.ASMSNMPPasswordGUI viewId: ASMSNMPPasswordGUI uiType: null] INFO: oracle.install.ivw.crs.view.ASMSNMPPasswordGUI added to View Type Registry with the key as [ASMSNMPPasswordGUI] INFO: Initial values of Setup Properties : ---------------------------------------------------------------------------------------------------- PROPERTY VALUE ---------------------------------------------------------------------------------------------------- CLUSTER_CONFIGURATION_FILE COLLECTOR_IGNORE_CONFIGURATION false COLLECTOR_IGNORE_FAILURES false COLLECTOR_RESPONSE_FILE DECLINE_SECURITY_UPDATES false FROM_LOCATION C:\home\win64_11gR2_grid\grid\install\../stage/products. xml MYORACLESUPPORT_PASSWORD *Protected value, not to be logged* MYORACLESUPPORT_USERNAME ORACLE_BASE ORACLE_HOME ORACLE_HOSTNAME w2008-112-rac1.localdomain PROXY_HOST PROXY_PORT PROXY_PWD *Protected value, not to be logged* PROXY_USER SECURITY_UPDATES_VIA_MYORACLESUPPORT true SELECTED_LANGUAGES {"en","zh_CN"} oracle.install.crs.storageOption 0 oracle_install_WindowsSystemDirectory oracle_install_asm_MigrateASM false oracle_install_crs_AdvancedInstall false oracle_install_crs_AutoConfig false oracle_install_crs_ClusterName oracle_install_crs_ConfigureGNS true oracle_install_crs_LaunchASMCA false oracle_install_crs_LaunchCRSInst false oracle_install_crs_LaunchCRSUpgrd false oracle_install_crs_LaunchCluvfy false oracle_install_crs_LaunchOifcfg false oracle_install_crs_LaunchRootBat false oracle_install_crs_LaunchUpdateNodeList false oracle_install_crs_OCRLocations {} oracle_install_crs_OCRRedundancy 2 oracle_install_crs_SCANName oracle_install_crs_SCANPortNumber 0 oracle_install_crs_StorageOption 0 oracle_install_crs_UseIPMI false oracle_install_crs_VotingDiskLocations {} oracle_install_crs_VotingDiskRedundancy 2 ---------------------------------------------------------------------------------------------------- INFO: 启动 Oracle Grid Infrastructure INFO: Started executing the flow in INTERACTIVE mode INFO: Waiting for completion of background operations INFO: Finishing all forked tasks at state init INFO: Waiting for completion all forked tasks at state init INFO: All forked task are completed at state init INFO: Completed background operations INFO: Executing action at state init INFO: Completed executing action at state <init> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <init> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Validating view at state <init> INFO: Completed validating view at state <init> INFO: Validating state <init> WARNING: Validation disabled for the state init INFO: Completed validating state <init> INFO: Verifying route success INFO: Get view named [InstallOptionsUI] INFO: View for [InstallOptionsUI] is oracle.install.ivw.crs.view.InstallOptionsUI@6c98a8b8 INFO: Initializing view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Completed initializing view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Displaying view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Completed displaying view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Loading view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Completed loading view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Localizing view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Completed localizing view <InstallOptionsUI> at state <InstallOptionsUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state InstallOptionsUI INFO: InstallOption Action Entering and Exiting execute INFO: Completed executing action at state <InstallOptionsUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <InstallOptionsUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: CRS config selected INFO: Validating view at state <InstallOptionsUI> INFO: Completed validating view at state <InstallOptionsUI> INFO: Validating state <InstallOptionsUI> INFO: getInstallOption: CRS_CONFIG INFO: isCRSInstalled: false INFO: isHAInstalled: false INFO: isCRSConfigured: false INFO: isHAConfigured: false INFO: isLocalCSSConfigured: false INFO: existingCRSOrLocalCSSVersion: null INFO: Completed validating state <InstallOptionsUI> INFO: 检测系统信息 INFO: InstallOptionsAction Actions.transition called INFO: Verifying route crs INFO: Get view named [InstallTypeUI] INFO: View for [InstallTypeUI] is oracle.install.ivw.crs.view.InstallTypeGUI[,0,0,0x0,invalid,layout=java.awt.GridBagLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=] INFO: Initializing view <InstallTypeUI> at state <InstallTypeUI> INFO: checking for 92 RAC existence INFO: Completed initializing view <InstallTypeUI> at state <InstallTypeUI> INFO: Displaying view <InstallTypeUI> at state <InstallTypeUI> INFO: Completed displaying view <InstallTypeUI> at state <InstallTypeUI> INFO: Loading view <InstallTypeUI> at state <InstallTypeUI> INFO: Completed loading view <InstallTypeUI> at state <InstallTypeUI> INFO: Localizing view <InstallTypeUI> at state <InstallTypeUI> INFO: Completed localizing view <InstallTypeUI> at state <InstallTypeUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state InstallTypeUI INFO: Completed executing action at state <InstallTypeUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <InstallTypeUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Validating view at state <InstallTypeUI> INFO: Completed validating view at state <InstallTypeUI> INFO: Validating state <InstallTypeUI> INFO: 正在检查主机... INFO: checking for 92 RAC existence INFO: Completed validating state <InstallTypeUI> INFO: Verifying route typical INFO: Get view named [ClusterInfoUI] INFO: View for [ClusterInfoUI] is oracle.install.ivw.crs.view.ClusterInfoUI@30fd981a INFO: Initializing view <ClusterInfoUI> at state <ClusterInfoUI> INFO: validating SCAN name for emptiness and bad chars INFO: Registered bean [ClusterConfig] INFO: Executing ["C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe", -p, -n] with environment variables {PROCESSOR_ARCHITECTURE=AMD64, PUBLIC=C:\Users\Public, LOGONSERVER=\\W2008-112-RAC1, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, HOMEDRIVE=C:, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, HOMEPATH=\Users\Administrator, SESSIONNAME=RDP-Tcp#0, TMP=C:\Windows\temp\1, windir=C:\Windows, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 37 Stepping 5, GenuineIntel, SystemDrive=C:, USERPROFILE=C:\Users\Administrator, ProgramData=C:\ProgramData, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, CommonProgramFiles=C:\Program Files\Common Files, =::=::\, NUMBER_OF_PROCESSORS=1, COMPUTERNAME=W2008-112-RAC1, ComSpec=C:\Windows\system32\cmd.exe, ProgramW6432=C:\Program Files, OS=Windows_NT, CLIENTNAME=KUANG-PC, USERNAME=Administrator, TEMP=C:\Windows\temp\1, ALLUSERSPROFILE=C:\ProgramData, USERDOMAIN=W2008-112-RAC1, PROCESSOR_LEVEL=6, SystemRoot=C:\Windows, =C:=C:\Windows\temp\1, APPDATA=C:\Users\Administrator\AppData\Roaming, ProgramFiles(x86)=C:\Program Files (x86), Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, FP_NO_HOST_CHECK=NO, CommonProgramW6432=C:\Program Files\Common Files, PROCESSOR_REVISION=2505, ProgramFiles=C:\Program Files} INFO: Starting Output Reader Threads for process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe" INFO: The process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe" exited with code 0 INFO: Waiting for output processor threads to exit. INFO: Output processor threads exited. INFO: Environment variable SKIP_ALL_SCAN_VIP_VALIDATION is not set. INFO: Completed initializing view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Displaying view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Completed displaying view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Loading view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Completed loading view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Localizing view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Completed localizing view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state ClusterInfoUI INFO: checking for 92 RAC existence INFO: Completed executing action at state <ClusterInfoUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <ClusterInfoUI> INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: validating SCAN name for emptiness and bad chars INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Validating view at state <ClusterInfoUI> INFO: Completed validating view at state <ClusterInfoUI> INFO: Validating state <ClusterInfoUI> INFO: 验证 SCAN 信息 INFO: validating SCAN name for emptiness and bad chars INFO: Validating SCAN VIP INFO: Validating Network Interfaces INFO: Validating Interface name and subnet from the default list INFO: Executing ["C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe", -p, -n] with environment variables {PROCESSOR_ARCHITECTURE=AMD64, PUBLIC=C:\Users\Public, LOGONSERVER=\\W2008-112-RAC1, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, HOMEDRIVE=C:, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, HOMEPATH=\Users\Administrator, SESSIONNAME=RDP-Tcp#0, TMP=C:\Windows\temp\1, windir=C:\Windows, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 37 Stepping 5, GenuineIntel, SystemDrive=C:, USERPROFILE=C:\Users\Administrator, ProgramData=C:\ProgramData, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, CommonProgramFiles=C:\Program Files\Common Files, =::=::\, NUMBER_OF_PROCESSORS=1, COMPUTERNAME=W2008-112-RAC1, ComSpec=C:\Windows\system32\cmd.exe, ProgramW6432=C:\Program Files, OS=Windows_NT, CLIENTNAME=KUANG-PC, USERNAME=Administrator, TEMP=C:\Windows\temp\1, ALLUSERSPROFILE=C:\ProgramData, USERDOMAIN=W2008-112-RAC1, PROCESSOR_LEVEL=6, SystemRoot=C:\Windows, =C:=C:\Windows\temp\1, APPDATA=C:\Users\Administrator\AppData\Roaming, ProgramFiles(x86)=C:\Program Files (x86), Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, FP_NO_HOST_CHECK=NO, CommonProgramW6432=C:\Program Files\Common Files, PROCESSOR_REVISION=2505, ProgramFiles=C:\Program Files} INFO: Starting Output Reader Threads for process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe" INFO: The process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe" exited with code 0 INFO: Waiting for output processor threads to exit. INFO: Output processor threads exited. INFO: Validating for NO Public interfaces INFO: Validating if Public and Private lists have any common interface INFO: Validating for no private interface provided INFO: 执行通用验证 INFO: Performing generic checks INFO: 验证 IP INFO: Converting IPs to hostnames INFO: 验证重复项 INFO: Validating for Duplicates in the table INFO: 验证本地节点存在性 INFO: Checking for local node existence in the list of public nodes INFO: 验证 IP 地址 INFO: Checking all nodes are on the same domain. INFO: Local Domain Name: localdomain INFO: 验证节点是否已准备好 INFO: Checking for node liveliness INFO: 验证公共主机的等同用户 INFO: Validating Public nodes for user equivalence INFO: Validating for 9.2, 10gR1 or Local CSS INFO: Setting public and VIP node info to the bean INFO: Validating Cluster Node details INFO: Completed validating state <ClusterInfoUI> INFO: NetworkInterfaceUI processing interfaces for public and private only INFO: Processing interface name: INFO: Processing interface name: INFO: Verifying route success INFO: Get view named [QuickInstallUI] INFO: inventory location isC:\Program Files\Oracle\Inventory INFO: View for [QuickInstallUI] is oracle.install.ivw.crs.view.QuickInstallGUI@57530551 INFO: Initializing view <QuickInstallUI> at state <QuickInstallUI> INFO: Completed initializing view <QuickInstallUI> at state <QuickInstallUI> INFO: Displaying view <QuickInstallUI> at state <QuickInstallUI> INFO: Completed displaying view <QuickInstallUI> at state <QuickInstallUI> INFO: Loading view <QuickInstallUI> at state <QuickInstallUI> INFO: 提取共享分区 INFO: Completed loading view <QuickInstallUI> at state <QuickInstallUI> INFO: Localizing view <QuickInstallUI> at state <QuickInstallUI> INFO: Completed localizing view <QuickInstallUI> at state <QuickInstallUI> INFO: Waiting for completion of background operations INFO: Finishing all forked tasks at state QuickInstallUI INFO: Waiting for completion all forked tasks at state QuickInstallUI INFO: All forked task are completed at state QuickInstallUI INFO: Completed background operations INFO: Executing action at state QuickInstallUI INFO: Completed executing action at state <QuickInstallUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <QuickInstallUI> INFO: Terminating all background operations INFO: Terminated all background operations INFO: Displaying view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Completed displaying view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Loading view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Completed loading view <ClusterInfoUI> at state <ClusterInfoUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state ClusterInfoUI INFO: Completed executing action at state <ClusterInfoUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved back to state: ClusterInfoUI INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Validating view at state <ClusterInfoUI> INFO: Completed validating view at state <ClusterInfoUI> INFO: Validating state <ClusterInfoUI> INFO: 验证 SCAN 信息 INFO: validating SCAN name for emptiness and bad chars INFO: Validating SCAN VIP INFO: Validating Network Interfaces INFO: Validating Interface name and subnet from the default list INFO: Executing ["C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe", -p, -n] with environment variables {PROCESSOR_ARCHITECTURE=AMD64, PUBLIC=C:\Users\Public, LOGONSERVER=\\W2008-112-RAC1, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, HOMEDRIVE=C:, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, HOMEPATH=\Users\Administrator, SESSIONNAME=RDP-Tcp#0, TMP=C:\Windows\temp\1, windir=C:\Windows, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 37 Stepping 5, GenuineIntel, SystemDrive=C:, USERPROFILE=C:\Users\Administrator, ProgramData=C:\ProgramData, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, CommonProgramFiles=C:\Program Files\Common Files, =::=::\, NUMBER_OF_PROCESSORS=1, COMPUTERNAME=W2008-112-RAC1, ComSpec=C:\Windows\system32\cmd.exe, ProgramW6432=C:\Program Files, OS=Windows_NT, CLIENTNAME=KUANG-PC, USERNAME=Administrator, TEMP=C:\Windows\temp\1, ALLUSERSPROFILE=C:\ProgramData, USERDOMAIN=W2008-112-RAC1, PROCESSOR_LEVEL=6, SystemRoot=C:\Windows, =C:=C:\Windows\temp\1, APPDATA=C:\Users\Administrator\AppData\Roaming, ProgramFiles(x86)=C:\Program Files (x86), Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, FP_NO_HOST_CHECK=NO, CommonProgramW6432=C:\Program Files\Common Files, PROCESSOR_REVISION=2505, ProgramFiles=C:\Program Files} INFO: Starting Output Reader Threads for process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe" INFO: The process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\oifcfg.exe" exited with code 0 INFO: Waiting for output processor threads to exit. INFO: Output processor threads exited. INFO: Validating for NO Public interfaces INFO: Validating if Public and Private lists have any common interface INFO: Validating for no private interface provided INFO: 执行通用验证 INFO: Performing generic checks INFO: 验证 IP INFO: Converting IPs to hostnames INFO: 验证重复项 INFO: Validating for Duplicates in the table INFO: 验证本地节点存在性 INFO: Checking for local node existence in the list of public nodes INFO: 验证 IP 地址 INFO: Checking all nodes are on the same domain. INFO: Local Domain Name: localdomain INFO: 验证节点是否已准备好 INFO: Checking for node liveliness INFO: 验证公共主机的等同用户 INFO: Validating Public nodes for user equivalence INFO: Validating for 9.2, 10gR1 or Local CSS INFO: Setting public and VIP node info to the bean INFO: Validating Cluster Node details INFO: Completed validating state <ClusterInfoUI> INFO: NetworkInterfaceUI processing interfaces for public and private only INFO: Processing interface name: INFO: Processing interface name: INFO: Verifying route success INFO: Displaying view <QuickInstallUI> at state <QuickInstallUI> INFO: Completed displaying view <QuickInstallUI> at state <QuickInstallUI> INFO: Loading view <QuickInstallUI> at state <QuickInstallUI> INFO: Completed loading view <QuickInstallUI> at state <QuickInstallUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state QuickInstallUI INFO: Completed executing action at state <QuickInstallUI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <QuickInstallUI> INFO: inventory location isC:\Program Files\Oracle\Inventory INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Validating view at state <QuickInstallUI> INFO: Completed validating view at state <QuickInstallUI> INFO: Validating state <QuickInstallUI> INFO: 正在验证指定的位置... INFO: custom prereq file name: oracle.crs_NONE.xml INFO: refDataFile: C:\home\win64_11gR2_grid\grid\stage\cvu\oracle.crs_NONE.xml INFO: isCustomRefDataFilePresent: false INFO: InstallAreaControl exists: false INFO: Checking:NEW_HOME INFO: Checking:COMP INFO: Reading shiphome metadata from C:\home\win64_11gR2_grid\grid\install\..\stage\shiphomeproperties.xml INFO: Loading beanstore from file:/C:/home/win64_11gR2_grid/grid/install/../stage/shiphomeproperties.xml INFO: Translating external format into raw format INFO: Restoring class oracle.install.driver.oui.ShiphomeMetadata from file:/C:/home/win64_11gR2_grid/grid/install/../stage/shiphomeproperties.xml INFO: inventory location isC:\Program Files\Oracle\Inventory INFO: inventory location isC:\Program Files\Oracle\Inventory INFO: Reading shiphome metadata from C:\home\win64_11gR2_grid\grid\install\..\stage\shiphomeproperties.xml INFO: Loading beanstore from file:/C:/home/win64_11gR2_grid/grid/install/../stage/shiphomeproperties.xml INFO: Translating external format into raw format INFO: Restoring class oracle.install.driver.oui.ShiphomeMetadata from file:/C:/home/win64_11gR2_grid/grid/install/../stage/shiphomeproperties.xml INFO: size estimation for Completeinstall is 1338.40149974823 INFO: PATH has :==>C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\oui\lib\win64;C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM;C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin;C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\jdk\jre\bin;.;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\ INFO: 正在检查远程节点上的指定位置... INFO: size estimation for Completeinstall is 1338.40149974823 WARNING: [WARNING] [INS-30011] 输入的 SYSASM 口令不符合 Oracle 建议的标准。 原因: Oracle 建议输入的口令应该至少长为 8 个字符, 至少包含 1 个大写字符, 1 个小写字符和 1 个数字 [0-9]。 操作: 提供符合 Oracle 建议标准的口令。 INFO: Advice is CONTINUE INFO: Completed validating state <QuickInstallUI> INFO: Verifying route ASM INFO: Get view named [ASMDiskGroupCreationUI] INFO: View for [ASMDiskGroupCreationUI] is oracle.install.ivw.crs.view.ASMDiskGroupCreationGUI@31c9b6eb INFO: Initializing view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: inventory location isC:\Program Files\Oracle\Inventory INFO: inventory location isC:\Program Files\Oracle\Inventory WARNING: SRVCTL not found as there is no Grid Infrastructure home on the box INFO: Executing ["C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe", nohdr=true, verbose=true, disks=all, status=true, op=disks] with environment variables {PROCESSOR_ARCHITECTURE=AMD64, PUBLIC=C:\Users\Public, LOGONSERVER=\\W2008-112-RAC1, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, HOMEDRIVE=C:, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, HOMEPATH=\Users\Administrator, SESSIONNAME=RDP-Tcp#0, TMP=C:\Windows\temp\1, windir=C:\Windows, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 37 Stepping 5, GenuineIntel, SystemDrive=C:, USERPROFILE=C:\Users\Administrator, ProgramData=C:\ProgramData, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, CommonProgramFiles=C:\Program Files\Common Files, =::=::\, NUMBER_OF_PROCESSORS=1, COMPUTERNAME=W2008-112-RAC1, ComSpec=C:\Windows\system32\cmd.exe, ProgramW6432=C:\Program Files, OS=Windows_NT, CLIENTNAME=KUANG-PC, USERNAME=Administrator, TEMP=C:\Windows\temp\1, ALLUSERSPROFILE=C:\ProgramData, USERDOMAIN=W2008-112-RAC1, PROCESSOR_LEVEL=6, SystemRoot=C:\Windows, =C:=C:\Windows\temp\1, APPDATA=C:\Users\Administrator\AppData\Roaming, ProgramFiles(x86)=C:\Program Files (x86), Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, FP_NO_HOST_CHECK=NO, CommonProgramW6432=C:\Program Files\Common Files, PROCESSOR_REVISION=2505, ProgramFiles=C:\Program Files} INFO: Starting Output Reader Threads for process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe" INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK1 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK2 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK3 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK4 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK5 Unknown Unknown INFO: The process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe" exited with code 0 INFO: Waiting for output processor threads to exit. INFO: Output processor threads exited. INFO: Completed initializing view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: Displaying view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: Completed displaying view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: Loading view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: Completed loading view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: Localizing view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: Completed localizing view <ASMDiskGroupCreationUI> at state <CreateASMDiskGroupQI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state CreateASMDiskGroupQI INFO: Completed executing action at state <CreateASMDiskGroupQI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <CreateASMDiskGroupQI> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Validating view at state <CreateASMDiskGroupQI> INFO: Completed validating view at state <CreateASMDiskGroupQI> INFO: Validating state <CreateASMDiskGroupQI> INFO: Executing ["C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe", nohdr=true, verbose=true, disks=all, op=disks, dscvgroup=TRUE] with environment variables {PROCESSOR_ARCHITECTURE=AMD64, PUBLIC=C:\Users\Public, LOGONSERVER=\\W2008-112-RAC1, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, HOMEDRIVE=C:, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, HOMEPATH=\Users\Administrator, SESSIONNAME=RDP-Tcp#0, TMP=C:\Windows\temp\1, windir=C:\Windows, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 37 Stepping 5, GenuineIntel, SystemDrive=C:, USERPROFILE=C:\Users\Administrator, ProgramData=C:\ProgramData, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, CommonProgramFiles=C:\Program Files\Common Files, =::=::\, NUMBER_OF_PROCESSORS=1, COMPUTERNAME=W2008-112-RAC1, ComSpec=C:\Windows\system32\cmd.exe, ProgramW6432=C:\Program Files, OS=Windows_NT, CLIENTNAME=KUANG-PC, USERNAME=Administrator, TEMP=C:\Windows\temp\1, ALLUSERSPROFILE=C:\ProgramData, USERDOMAIN=W2008-112-RAC1, PROCESSOR_LEVEL=6, SystemRoot=C:\Windows, =C:=C:\Windows\temp\1, APPDATA=C:\Users\Administrator\AppData\Roaming, ProgramFiles(x86)=C:\Program Files (x86), Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, FP_NO_HOST_CHECK=NO, CommonProgramW6432=C:\Program Files\Common Files, PROCESSOR_REVISION=2505, ProgramFiles=C:\Program Files} INFO: Starting Output Reader Threads for process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe" INFO: Parsing 5117 \\.\ORCLDISK1 # Unknown Unknown INFO: Parsing 5117 \\.\ORCLDISK2 # Unknown Unknown INFO: Parsing 5117 \\.\ORCLDISK3 # Unknown Unknown INFO: Parsing 5117 \\.\ORCLDISK4 # Unknown Unknown INFO: Parsing 5117 \\.\ORCLDISK5 # Unknown Unknown INFO: The process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe" exited with code 0 INFO: Waiting for output processor threads to exit. INFO: Output processor threads exited. INFO: Executing ["C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe", nohdr=true, verbose=true, disks=all, status=true, op=disks, asm_diskstring='\\.\ORCLDISK1','\\.\ORCLDISK2','\\.\ORCLDISK3','\\.\ORCLDISK4','\\.\ORCLDISK5'] with environment variables {PROCESSOR_ARCHITECTURE=AMD64, PUBLIC=C:\Users\Public, LOGONSERVER=\\W2008-112-RAC1, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, HOMEDRIVE=C:, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, HOMEPATH=\Users\Administrator, SESSIONNAME=RDP-Tcp#0, TMP=C:\Windows\temp\1, windir=C:\Windows, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 37 Stepping 5, GenuineIntel, SystemDrive=C:, USERPROFILE=C:\Users\Administrator, ProgramData=C:\ProgramData, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, CommonProgramFiles=C:\Program Files\Common Files, =::=::\, NUMBER_OF_PROCESSORS=1, COMPUTERNAME=W2008-112-RAC1, ComSpec=C:\Windows\system32\cmd.exe, ProgramW6432=C:\Program Files, OS=Windows_NT, CLIENTNAME=KUANG-PC, USERNAME=Administrator, TEMP=C:\Windows\temp\1, ALLUSERSPROFILE=C:\ProgramData, USERDOMAIN=W2008-112-RAC1, PROCESSOR_LEVEL=6, SystemRoot=C:\Windows, =C:=C:\Windows\temp\1, APPDATA=C:\Users\Administrator\AppData\Roaming, ProgramFiles(x86)=C:\Program Files (x86), Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\, FP_NO_HOST_CHECK=NO, CommonProgramW6432=C:\Program Files\Common Files, PROCESSOR_REVISION=2505, ProgramFiles=C:\Program Files} INFO: Starting Output Reader Threads for process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe" INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK1 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK2 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK3 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK4 Unknown Unknown INFO: Parsing 5117 CANDIDATE \\.\ORCLDISK5 Unknown Unknown INFO: The process "C:\Windows\temp\1\OraInstall2013-12-26_11-52-53AM\ext\bin\kfod.exe" exited with code 0 INFO: Waiting for output processor threads to exit. INFO: Output processor threads exited. INFO: Completed validating state <CreateASMDiskGroupQI> INFO: Verifying route inventory INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state prereqExecutionDecider INFO: Completed executing action at state <prereqExecutionDecider> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Moved to state <prereqExecutionDecider> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Validating view at state <prereqExecutionDecider> INFO: Completed validating view at state <prereqExecutionDecider> INFO: Validating state <prereqExecutionDecider> WARNING: Validation disabled for the state prereqExecutionDecider INFO: Completed validating state <prereqExecutionDecider> INFO: Verifying route executeprereqs INFO: Get view named [PrereqUI] INFO: View for [PrereqUI] is oracle.install.commons.base.interview.common.view.PrereqGUI@69904b13 INFO: Initializing view <PrereqUI> at state <performChecks> INFO: Completed initializing view <PrereqUI> at state <performChecks> INFO: Displaying view <PrereqUI> at state <performChecks> INFO: Completed displaying view <PrereqUI> at state <performChecks> INFO: Loading view <PrereqUI> at state <performChecks> INFO: Completed loading view <PrereqUI> at state <performChecks> INFO: Localizing view <PrereqUI> at state <performChecks> INFO: Completed localizing view <PrereqUI> at state <performChecks> INFO: Waiting for completion of background operations INFO: Completed background operations INFO: Executing action at state performChecks INFO: CVU tracingEnabled = false INFO: Nodes are prepared for verification. INFO: Completed executing action at state <performChecks> INFO: Waiting for completion of background operations INFO: Finishing all forked tasks at state performChecks INFO: Waiting for completion all forked tasks at state performChecks INFO: Creating PrereqChecker Job for leaf task 节点连接性 INFO: Creating PrereqChecker Job for leaf task 物理内存 INFO: Creating PrereqChecker Job for leaf task 可用物理内存 INFO: Creating PrereqChecker Job for leaf task 交换空间大小 INFO: Creating CompositePrereqChecker Job for container task 空闲空间 INFO: Creating PrereqChecker Job for leaf task 空闲空间: w2008-112-rac2:C:\Windows\temp\1 INFO: Creating PrereqChecker Job for leaf task 空闲空间: w2008-112-rac1:C:\Windows\temp\1 INFO: Creating PrereqChecker Job for leaf task 体系结构 INFO: Creating PrereqChecker Job for leaf task Environment variable: "PATH" INFO: ********************************************* INFO: 节点连接性: 此先决条件将测试所有节点之间是否存在连接性。 INFO: Severity:CRITICAL INFO: OverallStatus:OPERATION_FAILED INFO: ----------------------------------------------- INFO: Verification Result for Node:w2008-112-rac2 WARNING: 此验证任务没有结果值 INFO: ********************************************* INFO: 物理内存: 此先决条件将测试系统物理内存总量是否至少为 1.3672GB (1433600.0KB)。 INFO: Severity:IGNORABLE INFO: OverallStatus:SUCCESSFUL INFO: ----------------------------------------------- INFO: Verification Result for Node:w2008-112-rac2 INFO: Expected Value:1.3672GB (1433600.0KB) INFO: Actual Value:1.9996GB (2096696.0KB) INFO: ----------------------------------------------- INFO: ----------------------------------------------- INFO: Verification Result for Node:w2008-112-rac1 INFO: Expected Value:1.3672GB (1433600.0KB) INFO: Actual Value:1.9996GB (2096696.0KB) INFO: ----------------------------------------------- INFO: ********************************************* INFO: 可用物理内存: 此先决条件将测试系统可用物理内存是否至少为 50MB (51200.0KB)。 INFO: Severity:IGNORABLE INFO: OverallStatus:SUCCESSFUL INFO: ----------------------------------------------- INFO: Verification Result for Node:w2008-112-rac2 INFO: Expected Value:50MB (51200.0KB) INFO: Actual Value:1.6376GB (1717108.0KB) INFO: ----------------------------------------------- INFO: ----------------------------------------------- INFO: Verification Result for Node:w2008-112-rac1 IN

Navicat连接Oracle,存储过程为什么提示错误?

代码 ``` create or replace procedure EXCHANGE(a inout number,b inout number) as temp number(10); begin temp:=a; a:=b; b:=temp; end; ``` 一直提示如下错误: > PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following: :=.),@%default character The symbol ":=" was substituted for "NUMBER" to continue. ![图片说明](https://img-ask.csdn.net/upload/201908/01/1564657719_285955.png)

PL/SQL连接oracle11g时报出ORA-12545错,怎么解决啊,求帮忙。。。

现在我想用PL/SQL连接我的oracle11g,可是一直报ORA-12545,为什么啊,我测试能成功,就是用PL/SQL连的时候报错。。。求各路大神帮忙啊

oracle12.2 存储过过程执行完成,但时间还在走

使用plsql,调用存储过程删除数据,数据已成功删除,但执行时间还在走。 点击停止,就会报![图片说明](https://img-ask.csdn.net/upload/202004/02/1585806206_545200.png)错误 点击确定,又会报 ![图片说明](https://img-ask.csdn.net/upload/202004/02/1585806246_464834.png) 代码如下: ``` CREATE OR REPLACE PROCEDURE PRO_DEL_DATA IS V_COUNT NUMBER; CURSOR CUR IS SELECT HISID FROM T_xxxxx T WHERE T.TOTAL_COST < 0; BEGIN V_COUNT := 0; FOR VR IN CUR LOOP BEGIN DELETE FROM T_xxxxx T2 WHERE T2.HISID = VR.HISID; EXCEPTION WHEN NO_DATA_FOUND THEN CONTINUE; END; V_COUNT := V_COUNT + 1; IF V_COUNT MOD 1000 = 0 THEN COMMIT; END IF; END LOOP; COMMIT; END; ```

centos7,安装oracle11G,修改OS系统标识时 出错

进行到修改os系统标识的时候,在Root用户下执行以下步骤: vi /etc/redhat-release,进入编辑, 将CentOS Linux release 7.2.1511 (Core) 修改为redhat-7, 然ESC,:,wp,回车。本该退出,但是提示"/etc/redhat-release" 1L, 10C written E163: There is only one file to edit Press ENTER or type command to continue (只有一个文件来编辑 按回车或键入命令继续), 无法正常退出,进入终端命令行~!! 只能强行关闭终端,点右上X,请大神指导~!! 按道理说,ROOT 用户,权限是够的。

请教一个Oracle存储过程问题!

我在写oracle存储过程。oracle 9i的。 结构像这样。 for i in 1..3 loop begin insert .... 1 for j in 1..3 loop insert ... 2 insert ... 3 end loop; end exception when others then ... end loop; commit; 在2处发生了异常,会到异常处理那里去处理。现在我想把当前的这个循环continue掉。但是1处的insert还是会执行。而如果我在异常里面写rollback了,会报错,之后的循环就不会执行了。 请问下这里该怎么改,才能实现continue效果,还能保证事务的完整性? [b]问题补充:[/b] 你的意思是说,如果2处插入时出异常了,那就干脆不插入了。其他地方该怎么执行还怎么执行? 2处出异常了,1处就不插入了。就是说整个外部循环的此个循环无效了。 下一个循环继续插入。。。。 [b]问题补充:[/b] 我的异常处理是在循环里面的啊。。。。 [b]问题补充:[/b] 你的END和EXCEPTION写反了,应该是EXCEPTION在END之前。你这么一写,因为你在外层FOR循环下一行的BEGIN在里层FOR循环结束处就已经有END了,ORACLE在解析的时候,可能直接就把你的这个EXCEPTION当成是和存储过程同级的EXCEPTION。 反过来依然是这个问题。。。。。 找了半天说是oracle bug。。。。。 我用数据反补的方式给手动回滚了。。。谢谢你的热心。

oracle10g PLS-00103: 出现符号 "CREATE" 怎么解决啊

create or replace procedure autocomputer is rs_cursor SYS_REFCURSOR; comment_array myPackage.my.Array; match number; article number; sport number; total number; average number; student_id number; record myPackage.stdInfo; i number; begin i :=1; get_comment(comment_array); open rs_cursor for select t.student_id,t.match,t.article,t.sport from student t ; loop fetch rs_cursor into student_id,match ,article ,sport; exit when rs_cursor%NOTFOUND; total := match + article + sport; for i in 1..comment_array.count loop if record.s_comment = 'a' then begin total := total + 20; exit;--跳出for循环 end; end if; end loop; <<continue>> average := total / 3; update student t set t.total = total, t.average = average where t.student_id = student_id; end loop; end autocomputer; -- 取得学生课外评分信息 create or replace procedure get_comment(commentArray out myPackage.myArray) is --PLS-00103: 出现符号 "CREATE" rs SYS_REFCURSOR ; record myPackage.stdInfo; stu_id number(30); s_comment char(1); i number; begin open rs for select stu_id,s_comment from out_school i := 1; LOOP fetch rs into stu_id,s_comment; exit when rs%NOTFOUND; record.stu_id := stu_id; record.s_comment := s_comment; recommentArray(i) := record; i:=i + 1; end LOOP; end get_comment; -- 定义数组类型myArray create or replace package myPackage is begin type stdInfo is record(stu_id number,s_comment char(1)); type myArray is table of stdInfo index by binary_integer; end myPackage;

何时在PHP执行Oracle PL / SQL-OCI8时会执行自动回滚?

<div class="post-text" itemprop="text"> <p>I have PHP code that execute a stored procedure 10 times. If one stored procedure call fails, it should continue on, and at the end commit the transaction.</p> <p>It basically looks like this:</p> <pre><code>$connection = getConn(); foreach($row as $i=&gt;$j) { $SQL = "BEGIN MYPROC.EXECUTE(:VAL1, :VAL2); END;"; $statement = OCIParse($connection, $SQL); oci_bind_by_name($statement, 'VAL1', $row[i]['FIRSTVAL']); oci_bind_by_name($statement, 'VAL2', $row[i]['SECONDVAL']); $success = @OCIExecute($statement, OCI_DEFAULT); if(!$success) { print 'Exception in stored proc call'; } else { print 'Success'; } } oci_commit($connection); </code></pre> <p>My question is, if there is an exception raised in, say, the 5th stored proc call, will that roll back all the stored proc calls up to that point?</p> </div>

excel 数据导入oracle中有哪些方法

数据初始化时,很多excel文件上的数据需要导入到数据库中,不知道有一些什么好方法? 目前,我是用程序导入的,但是速度肯定不如直接操作数据库,简单一点的表目前是弄了一个中间表,先讲数据导入到中间表,然后对一些字段进行处理,存储过程,讲数据复制到目标表中,但是,也存在一些问题,就是,如果想要查一个关联的id,返回多个的时候,需要把信息保存下来,但是本条数据不处理,相当于程序中的continue,还有异常的处理,父子关系,比如说,一个父对象,下面一个子对象,子对象又有子对象,最下面的子对象保存上面所有级数的id,这种情况,用存储过程又该怎么处理? 希望各位大神多多指教!

SQLConfigDataSource 能自动创建Oracle数据源吗?

手动配置oracle数据库 odbc测试成功,使用程序自动创建时报错 2017-03-31 16:02:07 32000001-E OnClickedButtonbcon_inidb SQLConfigDataSource returned rc=0, msg=<部件在注册表中找不到>, might because the DSN already exist, will continue 2017-03-31 16:02:07 32000001-E X: Error from <SQLConnect>. Details follow. 2017-03-31 16:02:07 32000001-E X: SqlState (IM002) Msg ([Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序) 2017-03-31 16:02:07 32000001-E OnClickedButtonbcon_inidb: Can't initialize HR Database parameters: rc=4060

PHP Oracle分页无法在下一页中加载数据

<div class="post-text" itemprop="text"> <p>This question is continue from my last question.</p> <p>I have jQuery Table Pagination using ORACLE database.</p> <p>The code like this :</p> <pre><code>$cur_page = $page; $page -= 1; $per_page = 14; $previous_btn = true; $next_btn = true; $first_btn = true; $last_btn = true; $start = $page * $per_page; $query_pag_data = " SELECT * FROM ( SELECT x.*, ROWNUM as r FROM ( SELECT P.PRODUCTION_STATUS, P.DATE_ADDED, P.FORM_NO, P.QTY_PLAN, ROWNUM, M.MODEL_NO, M.MODEL_NAME FROM SEIAPPS_PRODUCTION_STATUS P, SEIAPPS_MODEL M WHERE P.MODEL_NO = M.MODEL_NO ORDER BY P.DATE_ADDED DESC, P.TIME ) x ) WHERE r &gt;= $start AND r &lt;= $per_page "; </code></pre> <p>I limit per page is 14 row. The result for first page is OK, no problem. But when I try to open next page, it's not load the data. Whereas I have more 20 row data in table.</p> <p>Anyone please help.<br> Thanks.</p> </div>

Ajax和表单认证

<div class="post-text" itemprop="text"> <p>I am trying to implement form authentication in my ajax application. The problem I have is that when the session expires I get 302 code which redirects me to a login page I specified in web.xml (and it messes everything up refreshing the whole app to login page).</p> <p>What I want to do is to get a "not authenticated" (401) code, then display the login form in a popup window and when the login is successful continue with what I was doing.</p> <p>here is a picture of what is going on: <img src="https://i.stack.imgur.com/hySyx.gif" alt="http://docs.oracle.com/javaee/1.4/tutorial/doc/images/security-formBasedLogin.gif"></p> <p>and the docs <a href="http://docs.oracle.com/javaee/1.4/tutorial/doc/Security5.html" rel="nofollow noreferrer">http://docs.oracle.com/javaee/1.4/tutorial/doc/Security5.html</a></p> <p>basically, I want to display the popup instead of redirect to login page and then don't do the redirect to the resource but do my update in AJAX way. From what I understand it couldn't be done only on the client side since the redirect can't be avoided (see here: <a href="https://stackoverflow.com/questions/8238727/how-to-prevent-ajax-requests-to-follow-redirects-using-jquery">redirect info</a>), I would need to write some kind of logic on the server to prevent redirect, see here for detail about doing it in IIS: <a href="http://haacked.com/archive/2011/10/04/prevent-forms-authentication-login-page-redirect-when-you-donrsquot-want.aspx" rel="nofollow noreferrer">IIS implementation</a></p> <p>P.S. So far this: <a href="http://www.oracle.com/technetwork/articles/entarch/session-lifecycle-096133.html" rel="nofollow noreferrer">http://www.oracle.com/technetwork/articles/entarch/session-lifecycle-096133.html</a> looks like the most promising way to implement it. The class is deprecated, but I can't find the new one and think it's the only way to do it for Weblogic.</p> </div>

Kettle 连接数据库错误报错如图,如何解决,求大神。

![图片说明](https://img-ask.csdn.net/upload/201608/01/1470031905_964369.png) 点击打开转换出现的问题。 org.pentaho.di.core.exception.KettleDatabaseException: Unable to populate tree with repository objects Unable to get list of repository objects MODIFIED_DATE String : couldn't convert string [2016-07-28 15:31:56] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2016-07-28 15:31:56" at org.pentaho.di.ui.repository.RepositoryDirectoryUI.getTreeWithNames(RepositoryDirectoryUI.java:193) at org.pentaho.di.ui.repository.dialog.SelectObjectDialog.refreshTree(SelectObjectDialog.java:433) at org.pentaho.di.ui.repository.dialog.SelectObjectDialog.setSort(SelectObjectDialog.java:420) at org.pentaho.di.ui.repository.dialog.SelectObjectDialog.getData(SelectObjectDialog.java:453) at org.pentaho.di.ui.repository.dialog.SelectObjectDialog.open(SelectObjectDialog.java:344) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3731) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3682) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton.access$100(SwtToolbarbutton.java:38) at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton$1.widgetSelected(SwtToolbarbutton.java:85) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7051) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8311) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) Caused by: org.pentaho.di.core.exception.KettleException: Unable to get list of repository objects MODIFIED_DATE String : couldn't convert string [2016-07-28 15:31:56] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2016-07-28 15:31:56" at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getRepositoryObjects(KettleDatabaseRepositoryConnectionDelegate.java:1469) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getRepositoryObjects(KettleDatabaseRepository.java:717) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getTransformationObjects(KettleDatabaseRepository.java:702) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getJobAndTransformationObjects(KettleDatabaseRepository.java:1761) at org.pentaho.di.ui.repository.RepositoryDirectoryUI.getTreeWithNames(RepositoryDirectoryUI.java:115) ... 29 more Caused by: org.pentaho.di.core.exception.KettleValueException: MODIFIED_DATE String : couldn't convert string [2016-07-28 15:31:56] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2016-07-28 15:31:56" at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:619) at org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1670) at org.pentaho.di.core.row.RowMeta.getDate(RowMeta.java:245) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getRepositoryObjects(KettleDatabaseRepositoryConnectionDelegate.java:1462) ... 33 more Caused by: java.text.ParseException: Unparseable date: "2016-07-28 15:31:56" at java.text.DateFormat.parse(DateFormat.java:337) at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:614) ... 36 more

SQL的存储过程中DECLARE 的用法DEMO如何理解

DELIMITER // DROP PROCEDURE IF EXISTS curdemo// CREATE PROCEDURE curdemo() BEGIN DECLARE done INT DEFAULT 0; DECLARE cnt INT DEFAULT 0; DECLARE s_region CHAR(255); DECLARE stmp CHAR(255)DEFAULT''; DECLARE cur_region CURSOR FOR SELECT DISTINCT c_region FROM ssbm.customer ORDER BY c_region LIMIT 1000; DECLARE CONTINUE HANDLER FOR SQLSTATE '02000'SET done=1; DROP TABLE IF EXISTS products; CREATE TABLE products(region CHAR(255),count INT); OPEN cur_region; REPEAT FETCH cur_region INTO s_region; IF NOT done THEN #这句话怎么理解呢? IF stmp='' THEN SET stmp=s_region; SET cnt=1; END IF; IF stmp!=s_region THEN INSERT INTO products(region ,count)VALUES(stmp,cnt); SET cnt=1; SET stmp=s_region; END IF; SET cnt=cnt+1; END IF; UNTIL done END REPEAT; CLOSE cur_region; INSERT INTO products(region,count)VALUES(stmp,cnt); END// DELIMITER ; CALL curdemo; SELECT region,count FROM products; 请解答下执行步骤是什么!谢谢

2019 AI开发者大会

2019 AI开发者大会(AI ProCon 2019)是由中国IT社区CSDN主办的AI技术与产业年度盛会。多年经验淬炼,如今蓄势待发:2019年9月6-7日,大会将有近百位中美顶尖AI专家、知名企业代表以及千余名AI开发者齐聚北京,进行技术解读和产业论证。我们不空谈口号,只谈技术,诚挚邀请AI业内人士一起共铸人工智能新篇章!

实现简单的文件系统

实验内容: 通过对具体的文件存储空间的管理、文件的物理结构、目录结构和文件操作的实现,加深对文件系统内部功能和实现过程的理解。 要求: 1.在内存中开辟一个虚拟磁盘空间作为文件存储器,在其上实现一个简

MIPS单周期CPU-组成原理实验-华中科技大学

使用logisim布线完成的MIPS单周期CPU,可支持28条指令。跑马灯的代码已经装入了寄存器,可以直接开启时钟运行。

2019数学建模A题高压油管的压力控制 省一论文即代码

2019数学建模A题高压油管的压力控制省一完整论文即详细C++和Matlab代码,希望对同学们有所帮助

基于QT和OpenCV的五子棋实现源码

一个简单的五子棋应用,基于QT和OpenCV的实现源码,通过相邻棋子判断是否获胜,不包含人工智能算法,适合新手入门

Git 实用技巧

这几年越来越多的开发团队使用了Git,掌握Git的使用已经越来越重要,已经是一个开发者必备的一项技能;但很多人在刚开始学习Git的时候会遇到很多疑问,比如之前使用过SVN的开发者想不通Git提交代码为什么需要先commit然后再去push,而不是一条命令一次性搞定; 更多的开发者对Git已经入门,不过在遇到一些代码冲突、需要恢复Git代码时候就不知所措,这个时候哪些对 Git掌握得比较好的少数人,就像团队中的神一样,在队友遇到 Git 相关的问题的时候用各种流利的操作来帮助队友于水火。 我去年刚加入新团队,发现一些同事对Git的常规操作没太大问题,但对Git的理解还是比较生疏,比如说分支和分支之间的关联关系、合并代码时候的冲突解决、提交代码前未拉取新代码导致冲突问题的处理等,我在协助处理这些问题的时候也记录各种问题的解决办法,希望整理后通过教程帮助到更多对Git操作进阶的开发者。 本期教程学习方法分为“掌握基础——稳步进阶——熟悉协作”三个层次。从掌握基础的 Git的推送和拉取开始,以案例进行演示,分析每一个步骤的操作方式和原理,从理解Git 工具的操作到学会代码存储结构、演示不同场景下Git遇到问题的不同处理方案。循序渐进让同学们掌握Git工具在团队协作中的整体协作流程。 在教程中会通过大量案例进行分析,案例会模拟在工作中遇到的问题,从最基础的代码提交和拉取、代码冲突解决、代码仓库的数据维护、Git服务端搭建等。为了让同学们容易理解,对Git简单易懂,文章中详细记录了详细的操作步骤,提供大量演示截图和解析。在教程的最后部分,会从提升团队整体效率的角度对Git工具进行讲解,包括规范操作、Gitlab的搭建、钩子事件的应用等。 为了让同学们可以利用碎片化时间来灵活学习,在教程文章中大程度降低了上下文的依赖,让大家可以在工作之余进行学习与实战,并同时掌握里面涉及的Git不常见操作的相关知识,理解Git工具在工作遇到的问题解决思路和方法,相信一定会对大家的前端技能进阶大有帮助。

实用主义学Python(小白也容易上手的Python实用案例)

原价169,限时立减100元! 系统掌握Python核心语法16点,轻松应对工作中80%以上的Python使用场景! 69元=72讲+源码+社群答疑+讲师社群分享会&nbsp; 【哪些人适合学习这门课程?】 1)大学生,平时只学习了Python理论,并未接触Python实战问题; 2)对Python实用技能掌握薄弱的人,自动化、爬虫、数据分析能让你快速提高工作效率; 3)想学习新技术,如:人工智能、机器学习、深度学习等,这门课程是你的必修课程; 4)想修炼更好的编程内功,优秀的工程师肯定不能只会一门语言,Python语言功能强大、使用高效、简单易学。 【超实用技能】 从零开始 自动生成工作周报 职场升级 豆瓣电影数据爬取 实用案例 奥运冠军数据分析 自动化办公:通过Python自动化分析Excel数据并自动操作Word文档,最终获得一份基于Excel表格的数据分析报告。 豆瓣电影爬虫:通过Python自动爬取豆瓣电影信息并将电影图片保存到本地。 奥运会数据分析实战 简介:通过Python分析120年间奥运会的数据,从不同角度入手分析,从而得出一些有趣的结论。 【超人气老师】 二两 中国人工智能协会高级会员 生成对抗神经网络研究者 《深入浅出生成对抗网络:原理剖析与TensorFlow实现》一书作者 阿里云大学云学院导师 前大型游戏公司后端工程师 【超丰富实用案例】 0)图片背景去除案例 1)自动生成工作周报案例 2)豆瓣电影数据爬取案例 3)奥运会数据分析案例 4)自动处理邮件案例 5)github信息爬取/更新提醒案例 6)B站百大UP信息爬取与分析案例 7)构建自己的论文网站案例

深度学习原理+项目实战+算法详解+主流框架(套餐)

深度学习系列课程从深度学习基础知识点开始讲解一步步进入神经网络的世界再到卷积和递归神经网络,详解各大经典网络架构。实战部分选择当下最火爆深度学习框架PyTorch与Tensorflow/Keras,全程实战演示框架核心使用与建模方法。项目实战部分选择计算机视觉与自然语言处理领域经典项目,从零开始详解算法原理,debug模式逐行代码解读。适合准备就业和转行的同学们加入学习! 建议按照下列课程顺序来进行学习 (1)掌握深度学习必备经典网络架构 (2)深度框架实战方法 (3)计算机视觉与自然语言处理项目实战。(按照课程排列顺序即可)

C/C++跨平台研发从基础到高阶实战系列套餐

一 专题从基础的C语言核心到c++ 和stl完成基础强化; 二 再到数据结构,设计模式完成专业计算机技能强化; 三 通过跨平台网络编程,linux编程,qt界面编程,mfc编程,windows编程,c++与lua联合编程来完成应用强化 四 最后通过基于ffmpeg的音视频播放器,直播推流,屏幕录像,

三个项目玩转深度学习(附1G源码)

从事大数据与人工智能开发与实践约十年,钱老师亲自见证了大数据行业的发展与人工智能的从冷到热。事实证明,计算机技术的发展,算力突破,海量数据,机器人技术等,开启了第四次工业革命的序章。深度学习图像分类一直是人工智能的经典任务,是智慧零售、安防、无人驾驶等机器视觉应用领域的核心技术之一,掌握图像分类技术是机器视觉学习的重中之重。针对现有线上学习的特点与实际需求,我们开发了人工智能案例实战系列课程。打造:以项目案例实践为驱动的课程学习方式,覆盖了智能零售,智慧交通等常见领域,通过基础学习、项目案例实践、社群答疑,三维立体的方式,打造最好的学习效果。

Java基础知识面试题(2020最新版)

文章目录Java概述何为编程什么是Javajdk1.5之后的三大版本JVM、JRE和JDK的关系什么是跨平台性?原理是什么Java语言有哪些特点什么是字节码?采用字节码的最大好处是什么什么是Java程序的主类?应用程序和小程序的主类有何不同?Java应用程序与小程序之间有那些差别?Java和C++的区别Oracle JDK 和 OpenJDK 的对比基础语法数据类型Java有哪些数据类型switc...

Python界面版学生管理系统

前不久上传了一个控制台版本的学生管理系统,这个是Python界面版学生管理系统,这个是使用pycharm开发的一个有界面的学生管理系统,基本的增删改查,里面又演示视频和完整代码,有需要的伙伴可以自行下

Vue.js 2.0之全家桶系列视频课程

基于新的Vue.js 2.3版本, 目前新全的Vue.js教学视频,让你少走弯路,直达技术前沿! 1. 包含Vue.js全家桶(vue.js、vue-router、axios、vuex、vue-cli、webpack、ElementUI等) 2. 采用笔记+代码案例的形式讲解,通俗易懂

linux“开发工具三剑客”速成攻略

工欲善其事,必先利其器。Vim+Git+Makefile是Linux环境下嵌入式开发常用的工具。本专题主要面向初次接触Linux的新手,熟练掌握工作中常用的工具,在以后的学习和工作中提高效率。

JAVA初级工程师面试36问(完结)

第三十一问: 说一下线程中sleep()和wait()区别? 1 . sleep()是让正在执行的线程主动让出CPU,当时间到了,在回到自己的线程让程序运行。但是它并没有释放同步资源锁只是让出。 2.wait()是让当前线程暂时退让出同步资源锁,让其他线程来获取到这个同步资源在调用notify()方法,才会让其解除wait状态,再次参与抢资源。 3. sleep()方法可以在任何地方使用,而wait()只能在同步方法或同步块使用。 ...

java jdk 8 帮助文档 中文 文档 chm 谷歌翻译

JDK1.8 API 中文谷歌翻译版 java帮助文档 JDK API java 帮助文档 谷歌翻译 JDK1.8 API 中文 谷歌翻译版 java帮助文档 Java最新帮助文档 本帮助文档是使用谷

我以为我对Mysql事务很熟,直到我遇到了阿里面试官

太惨了,面试又被吊打

智鼎(附答案).zip

并不是完整题库,但是有智鼎在线2019年9、10、11三个月的试题,有十七套以上题目,普通的网申行测题足以对付,可以在做题时自己总结一些规律,都不是很难

Visual Assist X 破解补丁

vs a's'sixt插件 支持vs2008-vs2019 亲测可以破解,希望可以帮助到大家

150讲轻松搞定Python网络爬虫

【为什么学爬虫?】 &nbsp; &nbsp; &nbsp; &nbsp;1、爬虫入手容易,但是深入较难,如何写出高效率的爬虫,如何写出灵活性高可扩展的爬虫都是一项技术活。另外在爬虫过程中,经常容易遇到被反爬虫,比如字体反爬、IP识别、验证码等,如何层层攻克难点拿到想要的数据,这门课程,你都能学到! &nbsp; &nbsp; &nbsp; &nbsp;2、如果是作为一个其他行业的开发者,比如app开发,web开发,学习爬虫能让你加强对技术的认知,能够开发出更加安全的软件和网站 【课程设计】 一个完整的爬虫程序,无论大小,总体来说可以分成三个步骤,分别是: 网络请求:模拟浏览器的行为从网上抓取数据。 数据解析:将请求下来的数据进行过滤,提取我们想要的数据。 数据存储:将提取到的数据存储到硬盘或者内存中。比如用mysql数据库或者redis等。 那么本课程也是按照这几个步骤循序渐进的进行讲解,带领学生完整的掌握每个步骤的技术。另外,因为爬虫的多样性,在爬取的过程中可能会发生被反爬、效率低下等。因此我们又增加了两个章节用来提高爬虫程序的灵活性,分别是: 爬虫进阶:包括IP代理,多线程爬虫,图形验证码识别、JS加密解密、动态网页爬虫、字体反爬识别等。 Scrapy和分布式爬虫:Scrapy框架、Scrapy-redis组件、分布式爬虫等。 通过爬虫进阶的知识点我们能应付大量的反爬网站,而Scrapy框架作为一个专业的爬虫框架,使用他可以快速提高我们编写爬虫程序的效率和速度。另外如果一台机器不能满足你的需求,我们可以用分布式爬虫让多台机器帮助你快速爬取数据。 &nbsp; 从基础爬虫到商业化应用爬虫,本套课程满足您的所有需求! 【课程服务】 专属付费社群+每周三讨论会+1v1答疑

JavaWEB商城项目(包括数据库)

功能描述:包括用户的登录注册,以及个人资料的修改.商品的分类展示,详情,加入购物车,生成订单,到银行支付等!另外还有收货地址的和我的收藏等常用操作.环境(JDK 1.7 ,mysql 5.5,Ecli

Python数据挖掘简易入门

&nbsp; &nbsp; &nbsp; &nbsp; 本课程为Python数据挖掘方向的入门课程,课程主要以真实数据为基础,详细介绍数据挖掘入门的流程和使用Python实现pandas与numpy在数据挖掘方向的运用,并深入学习如何运用scikit-learn调用常用的数据挖掘算法解决数据挖掘问题,为进一步深入学习数据挖掘打下扎实的基础。

一学即懂的计算机视觉(第一季)

图像处理和计算机视觉的课程大家已经看过很多,但总有“听不透”,“用不了”的感觉。课程致力于创建人人都能听的懂的计算机视觉,通过生动、细腻的讲解配合实战演练,让学生真正学懂、用会。 【超实用课程内容】 课程内容分为三篇,包括视觉系统构成,图像处理基础,特征提取与描述,运动跟踪,位姿估计,三维重构等内容。课程理论与实战结合,注重教学内容的可视化和工程实践,为人工智能视觉研发及算法工程师等相关高薪职位就业打下坚实基础。 【课程如何观看?】 PC端:https://edu.csdn.net/course/detail/26281 移动端:CSDN 学院APP(注意不是CSDN APP哦) 本课程为录播课,课程2年有效观看时长,但是大家可以抓紧时间学习后一起讨论哦~ 【学员专享增值服务】 源码开放 课件、课程案例代码完全开放给你,你可以根据所学知识,自行修改、优化 下载方式:电脑登录https://edu.csdn.net/course/detail/26281,点击右下方课程资料、代码、课件等打包下载

软件测试2小时入门

本课程内容系统、全面、简洁、通俗易懂,通过2个多小时的介绍,让大家对软件测试有个系统的理解和认识,具备基本的软件测试理论基础。 主要内容分为5个部分: 1 软件测试概述,了解测试是什么、测试的对象、原则、流程、方法、模型;&nbsp; 2.常用的黑盒测试用例设计方法及示例演示;&nbsp; 3 常用白盒测试用例设计方法及示例演示;&nbsp; 4.自动化测试优缺点、使用范围及示例‘;&nbsp; 5.测试经验谈。

初级玩转Linux+Ubuntu(嵌入式开发基础课程)

课程主要面向嵌入式Linux初学者、工程师、学生 主要从一下几方面进行讲解: 1.linux学习路线、基本命令、高级命令 2.shell、vi及vim入门讲解 3.软件安装下载、NFS、Samba、FTP等服务器配置及使用

2019 Python开发者日-培训

本次活动将秉承“只讲技术,拒绝空谈”的理念,邀请十余位身处一线的Python技术专家,重点围绕Web开发、自动化运维、数据分析、人工智能等技术模块,分享真实生产环境中使用Python应对IT挑战的真知灼见。此外,针对不同层次的开发者,大会还安排了深度培训实操环节,为开发者们带来更多深度实战的机会。

快速入门Android开发 视频 教程 android studio

这是一门快速入门Android开发课程,顾名思义是让大家能快速入门Android开发。 学完能让你学会如下知识点: Android的发展历程 搭建Java开发环境 搭建Android开发环境 Android Studio基础使用方法 Android Studio创建项目 项目运行到模拟器 项目运行到真实手机 Android中常用控件 排查开发中的错误 Android中请求网络 常用Android开发命令 快速入门Gradle构建系统 项目实战:看美图 常用Android Studio使用技巧 项目签名打包 如何上架市场

机器学习初学者必会的案例精讲

通过六个实际的编码项目,带领同学入门人工智能。这些项目涉及机器学习(回归,分类,聚类),深度学习(神经网络),底层数学算法,Weka数据挖掘,利用Git开源项目实战等。

4小时玩转微信小程序——基础入门与微信支付实战

这是一个门针对零基础学员学习微信小程序开发的视频教学课程。课程采用腾讯官方文档作为教程的唯一技术资料来源。杜绝网络上质量良莠不齐的资料给学员学习带来的障碍。 视频课程按照开发工具的下载、安装、使用、程序结构、视图层、逻辑层、微信小程序等几个部分组织课程,详细讲解整个小程序的开发过程

相关热词 c#框体中的退出函数 c# 按钮透明背景 c# idl 混编出错 c#在位置0处没有任何行 c# 循环给数组插入数据 c# 多线程死锁的例子 c# 钉钉读取员工排班 c# label 不显示 c#裁剪影像 c#工作进程更新ui
立即提问