首页 文章 精选 留言 我的

精选列表

搜索[基准测试]，共10000篇文章
优秀的个人博客,低调大师

Cutter 1.10.1 发布，C 语言单元测试框架

Cutter 1.10.1现已发布，该版本更新内容如下： Highlights 现在默认在所有平台上都提供 r2dec 反编译器 radre2 已更新至最新版本-v4.2.1 整个 Cutter 的主要性能改进 从标志和函数中删除前缀以使其更漂亮 新对话框可设置和编辑断点，包括硬件和条件断点 插件作者的 API改进 更快，更好地伸缩Stack和Registers 各种 bug 修复和小改进 Additions 将 r2dec 捆绑到 macOS 和 Linux 构建中（＃2023，＃2033） 将实名和 libname 添加到 Flags and Imports 小部件（＃2024） 添加断点编辑器对话框（＃1975） 添加更多断点编辑选项（＃1967） 添加用于插件的 API 以扩展上下文菜单（＃2029） 添加自定义伸缩功能并改善 StackWidget 的输出（＃1990） ...... Fixes and Changes 将 radare2 更新为 4.2.1（＃2040） 简化插件上下文菜单 GUI 代码并将其移出核心。（＃2039） 将设置中的用户插件路径设置为链接（＃2034） 改善图表上的默认线宽值（＃2026） 如果可用，请将 r2ghidra 设置为默认的反编译器（＃2007） 提高标志和字符串小部件的性能（＃2021） 打开外观设置时设置缩放倍数。（＃2003） ...... 更多详细信息可查看更新说明：https://github.com/radareorg/cutter/releases
2020-02-04
优秀的个人博客,低调大师

P2V迁云工具迁移测试

一、什么是迁云工具 迁云工具是阿里云ECS的迁云服务客户端，支持在线迁移源服务器至阿里云ECS。如果是将线下IDC服务器环境迁移到ECS，我们常称迁云工具为P2V；如果是将虚拟机环境或者云平台主机环境迁移到ECS，我们常称迁云工具为V2V。 二、工作原理 在下载迁云工具到源服务器后，需要根据实际情况编写配置文件，迁云工具为源服务器的磁盘分区中的操作系统、应用程序与应用数据在线制作数据快照，并在ECS侧同步数据和生成自定义镜像。之后就可以使用该自定义镜像快速创建ECS，从而实现将服务器环境迁移到ECS。 迁云工具运行时，系统会默认在阿里云账号下创建一个ECS实例做中转站，中转实例为按量付费；之后对中转实例的磁盘创建快照以生成自定义镜像。 三、正式迁移 3.1、准备工作 3.1.1 要有阿里云官网账号；账号至少100元余额；最好创建一个RAM子账号，然后授予相应的权限，记好ak3.1.2 需要开通快照服务、OSS服务和ECS服务3.1.3 确认源服务器本地时间与实际时间一致，避免迁移时报错IllegalTimestamp3.1.4 当源服务器为linux时：1、确认已安装rsync库： 2、确认已关闭源服务器中selinux功能 3、确认已安装virtio（KVM）驱动，具体见链接：https://help.aliyun.com/document_detail/62423.html?spm=a2c4g.11186623.2.25.60e56ff62GpXMO#concept-dvq-cqs-xdb 4、确认已安装高版本系统引导程序grub，需要至少1.9版本以上，具体见链接（比较奇怪，我本地服务器没有安装grub，后来迁移也成功了）：https://help.aliyun.com/knowledge_detail/62807.html?spm=a2c4g.11186623.2.26.60e56ff62GpXMO 3.2 迁移流程 3.2.1下载和安装迁云工具迁云工具有windows和linux操作系统版本，下载链接：https://help.aliyun.com/document_detail/62394.html?spm=a2c4g.11186623.2.32.2b984a0bxAXEC1 通过unzip命令解压工具包，因为源服务器是linux 64位，所以再解压linux_x86_64工具包：unzip go2aliyun_client1.5.2_linux_x86_64.zip 3.2.2 编辑配置文件进入工具目录下： [root@cos7-jiang software]# cd go2aliyun_client1.5.2_linux_x86_64 编辑目录下的user_config.json文件：Access_id和secret_key就是前面生成的ram子账号的AK；Region_id代表源服务器预计迁入的阿里云地域ID，如cn-hangzhou（华东1）；Image_name表示给源服务器镜像起个名字；System_disk_size表示给系统盘指定大小，单位为GB；Platform表示源服务器的操作系统，取值如下：Windows Server 2003 | Windows Server 2008 | Windows Server 2012 | Windows Server 2016 | CentOS | Ubuntu | SUSE | OpenSUSE | Debian | RedHat | Others LinuxData_disks和bandwidth_limit是非必填项，这里不填。具体含义见链接：https://help.aliyun.com/document_detail/62394.html?spm=a2c4g.11186623.2.32.2b984a0bxAXEC1 3.2.3 运行迁云工具因为本次实验要迁移完整环境，无不迁移的文件和目录，所以不需要另外配置。如果有不迁移的文件或目录，配置见链接：https://help.aliyun.com/document_detail/62394.html?spm=a2c4g.11186623.2.32.2b984a0bxAXEC1 因为源服务器是linux，所以直接以root身份执行： chmod +x ./go2aliyun_client ./go2aliyun_client 脚本运行后，无需再做其它操作，耐心等待迁移完成； 3.2.4 迁移完成迁移过程可能较长，当提示：Goto Aliyun Finished时，如下图，表示迁移完成。之后前往阿里云官网ECS控制台，可以看到新生成的镜像： 在新建ECS时，选中该镜像，即完成了线下服务器到ECS的迁移。 四、迁移目录范围对于Linux服务器的迁移，默认会迁移根目录下的所有目录，包括挂载在根目录下的共享目录，生成一个系统盘分区；如果需要迁移其他分区目录如/disk1，或者有不迁移的文件或目录，需要另外的配置文件进行配置。 配置文件在Excludes目录下，如图： rsync_excludes_linux.txt是系统盘配置文件；rsync_excludes_linux_disk*系列都是数据盘配置文件，这系列文件初始时都是空文件； 排除不迁移的目录和文件的方式也很简单，只需要将相应的目录写在配置文件里就可以了。 说明：如果迁移涉及到公网传输，请保持网络稳定，否则网络一个短暂的波动都可能会导致迁移过程中断；
2019-09-01
优秀的个人博客,低调大师

Oracle 11g on ECS 测试实践--安装案例

参考文档：MOS Doc ID 472408.1基于 AMERICAN_AMERICA.US7ASCII 字符集 [oracle@orcl1 schema]$ cd /u01/app/oracle/product/11.2.0/db_1/demo/schema/ [oracle@orcl1 schema]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 25 15:54:50 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @mkplug.sql specify password for SYS as parameter 1: Enter value for 1: oracle specify password for HR as parameter 2: Enter value for 2: oracle specify password for OE as parameter 3: Enter value for 3: oracle specify password for PM as parameter 4: Enter value for 4: oracle specify password for IX as parameter 5: Enter value for 5: oracle specify password for SH as parameter 6: Enter value for 6: oracle specify password for BI as parameter 7: Enter value for 7: oracle specify INPUT metadata import file as parameter 8: Enter value for 8: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example.dmp specify INPUT database backup file for tablespace EXAMPLE as parameter 9: Enter value for 9: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example01.dfb specify OUTPUT database file for tablespace EXAMPLE as parameter 10: Enter value for 10: /oradata/ORCL/example01.dbf specify OUTPUT log directory as parameter 11: Enter value for 11: /home/oracle/log.txt specify OUTPUT dump file directory as parameter 12: Enter value for 12: /home/oracle/ Sample Schemas are being plugged in ... Connected. TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:07 1 row selected. old 1: CREATE USER hr IDENTIFIED BY &&password_hr new 1: CREATE USER hr IDENTIFIED BY oracle User created. old 1: CREATE USER oe IDENTIFIED BY &&password_oe new 1: CREATE USER oe IDENTIFIED BY oracle User created. old 1: CREATE USER ix IDENTIFIED BY &&password_ix new 1: CREATE USER ix IDENTIFIED BY oracle User created. old 1: CREATE USER sh IDENTIFIED BY &&password_sh new 1: CREATE USER sh IDENTIFIED BY oracle User created. old 1: CREATE USER pm IDENTIFIED BY &&password_pm new 1: CREATE USER pm IDENTIFIED BY oracle User created. old 1: CREATE USER bi IDENTIFIED BY &&password_bi new 1: CREATE USER bi IDENTIFIED BY oracle User created. SQL> SET FEEDBACK 1 SQL> SET NUMWIDTH 10 SQL> SET LINESIZE 80 SQL> SET TRIMSPOOL ON SQL> SET TAB OFF SQL> SET PAGESIZE 100 SQL> SQL> CREATE OR REPLACE DIRECTORY data_file_dir AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/'; Directory created. SQL> CREATE OR REPLACE DIRECTORY log_file_dir AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/log/'; Directory created. SQL> CREATE OR REPLACE DIRECTORY media_dir AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/'; Directory created. SQL> SQL> GRANT READ ON DIRECTORY media_dir TO pm; Grant succeeded. SQL> GRANT READ ON DIRECTORY log_file_dir TO sh; Grant succeeded. SQL> GRANT READ ON DIRECTORY data_file_dir TO sh; Grant succeeded. SQL> GRANT WRITE ON DIRECTORY log_file_dir TO sh; Grant succeeded. SQL> EXECUTE DBMS_DATAPUMP_UTL.REPLACE_DEFAULT_DIR; PL/SQL procedure successfully completed. SQL> EXECUTE ORACLE_OCM.MGMT_CONFIG_UTL.create_replace_dir_obj; PL/SQL procedure successfully completed. SQL> SQL> GRANT CREATE SESSION TO hr; Grant succeeded. SQL> GRANT ALTER SESSION TO hr; Grant succeeded. SQL> GRANT CREATE DATABASE LINK TO hr; Grant succeeded. SQL> GRANT CREATE SEQUENCE TO hr; Grant succeeded. SQL> GRANT CREATE SYNONYM TO hr; Grant succeeded. SQL> GRANT CREATE VIEW TO hr; Grant succeeded. SQL> GRANT RESOURCE TO hr; Grant succeeded. SQL> GRANT execute ON sys.dbms_stats TO hr; Grant succeeded. SQL> SQL> GRANT CREATE SESSION TO oe; Grant succeeded. SQL> GRANT CREATE DATABASE LINK TO oe; Grant succeeded. SQL> GRANT CREATE SYNONYM TO oe; Grant succeeded. SQL> GRANT CREATE VIEW TO oe; Grant succeeded. SQL> GRANT RESOURCE TO oe; Grant succeeded. SQL> GRANT CREATE MATERIALIZED VIEW TO oe; Grant succeeded. SQL> GRANT QUERY REWRITE TO oe; Grant succeeded. SQL> GRANT execute ON sys.dbms_stats TO oe; Grant succeeded. SQL> SQL> GRANT CONNECT TO pm; Grant succeeded. SQL> GRANT RESOURCE TO pm; Grant succeeded. SQL> GRANT execute ON sys.dbms_stats TO pm; Grant succeeded. SQL> GRANT READ ON DIRECTORY media_dir TO pm; Grant succeeded. SQL> SQL> GRANT CONNECT TO ix; Grant succeeded. SQL> GRANT RESOURCE TO ix; Grant succeeded. SQL> SQL> GRANT aq_administrator_role TO ix; Grant succeeded. SQL> GRANT aq_user_role TO ix; Grant succeeded. SQL> SQL> GRANT ALTER SESSION TO ix; Grant succeeded. SQL> GRANT CREATE CLUSTER TO ix; Grant succeeded. SQL> GRANT CREATE DATABASE LINK TO ix; Grant succeeded. SQL> GRANT CREATE SEQUENCE TO ix; Grant succeeded. SQL> GRANT CREATE SESSION TO ix; Grant succeeded. SQL> GRANT CREATE SYNONYM TO ix; Grant succeeded. SQL> GRANT CREATE TABLE TO ix; Grant succeeded. SQL> GRANT CREATE VIEW TO ix; Grant succeeded. SQL> GRANT CREATE CLUSTER TO ix; Grant succeeded. SQL> GRANT CREATE INDEXTYPE TO ix; Grant succeeded. SQL> GRANT CREATE OPERATOR TO ix; Grant succeeded. SQL> GRANT CREATE PROCEDURE TO ix; Grant succeeded. SQL> GRANT CREATE SEQUENCE TO ix; Grant succeeded. SQL> GRANT CREATE TABLE TO ix; Grant succeeded. SQL> GRANT CREATE TRIGGER TO ix; Grant succeeded. SQL> GRANT CREATE TYPE TO ix; Grant succeeded. SQL> GRANT CREATE SESSION TO ix; Grant succeeded. SQL> SQL> GRANT CONNECT, RESOURCE, SELECT_CATALOG_ROLE TO ix; Grant succeeded. SQL> SQL> GRANT EXECUTE ON sys.dbms_stats TO ix; Grant succeeded. SQL> GRANT EXECUTE ON DBMS_AQ TO ix; Grant succeeded. SQL> GRANT EXECUTE ON DBMS_AQADM TO ix; Grant succeeded. SQL> GRANT EXECUTE ON DBMS_APPLY_ADM TO ix; Grant succeeded. SQL> GRANT EXECUTE ON DBMS_CAPTURE_ADM TO ix; Grant succeeded. SQL> GRANT EXECUTE ON DBMS_FLASHBACK TO ix; Grant succeeded. SQL> GRANT EXECUTE ON DBMS_PROPAGATION_ADM TO ix; Grant succeeded. SQL> GRANT EXECUTE ON DBMS_STREAMS_ADM TO ix; Grant succeeded. SQL> GRANT SELECT ANY DICTIONARY TO ix; Grant succeeded. SQL> SQL> EXECUTE DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( - > privilege => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, - > grantee => 'ix', - > grant_option => FALSE); PL/SQL procedure successfully completed. SQL> SQL> EXECUTE DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( - > privilege => DBMS_RULE_ADM.CREATE_RULE_OBJ, - > grantee => 'ix', - > grant_option => FALSE); PL/SQL procedure successfully completed. SQL> SQL> GRANT CREATE SESSION TO sh; Grant succeeded. SQL> GRANT CREATE TABLE TO sh; Grant succeeded. SQL> GRANT CREATE VIEW TO sh; Grant succeeded. SQL> GRANT CREATE CLUSTER TO sh; Grant succeeded. SQL> GRANT ALTER SESSION TO sh; Grant succeeded. SQL> GRANT CREATE SEQUENCE TO sh; Grant succeeded. SQL> GRANT CREATE SYNONYM TO sh; Grant succeeded. SQL> GRANT CREATE DATABASE LINK TO sh; Grant succeeded. SQL> GRANT CREATE DIMENSION TO sh; Grant succeeded. SQL> GRANT QUERY REWRITE TO sh; Grant succeeded. SQL> GRANT CREATE MATERIALIZED VIEW TO sh; Grant succeeded. SQL> GRANT CREATE VIEW TO sh; Grant succeeded. SQL> GRANT RESOURCE TO sh; Grant succeeded. SQL> GRANT select_catalog_role TO sh; Grant succeeded. SQL> GRANT cwm_user TO sh; Grant succeeded. SQL> GRANT execute ON sys.dbms_stats TO sh; Grant succeeded. SQL> rem ALTER USER sh GRANT CONNECT THROUGH olapsvr; SQL> SQL> GRANT CREATE SESSION TO bi; Grant succeeded. SQL> GRANT CREATE TABLE TO bi; Grant succeeded. SQL> GRANT CREATE VIEW TO bi; Grant succeeded. SQL> GRANT CREATE CLUSTER TO bi; Grant succeeded. SQL> GRANT ALTER SESSION TO bi; Grant succeeded. SQL> GRANT CREATE SEQUENCE TO bi; Grant succeeded. SQL> GRANT CREATE SYNONYM TO bi; Grant succeeded. SQL> GRANT CREATE DATABASE LINK TO bi; Grant succeeded. SQL> GRANT RESOURCE TO bi; Grant succeeded. SQL> SQL> -- SQL> -- Restoring database file backup SQL> -- (Using RMAN works in OMF, OCFS, raw devices and in normal file systems) SQL> -- SQL> SQL> SQL> set echo off; TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:07 1 row selected. old 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'&data_file_name'); new 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'/oradata/ORCL/example01.dbf'); old 33: dbms_backup_restore.restoreBackupPiece('&dump_path'||'&data_file_backup', done); new 33: dbms_backup_restore.restoreBackupPiece('/home/oracle/'||'/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example01.dfb', done); Allocating device.... Specifying datafiles... Specifing datafiles... Restoring ... declare * ERROR at line 1: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /home/oracle/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/exampl e01.dfb ORA-19505: failed to identify file "/home/oracle/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/examp le01.dfb" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 5937 ORA-06512: at line 33 1 row selected. TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:07 1 row selected. old 1: create or replace directory SS_IMPEXP_DIR as '&dump_path' new 1: create or replace directory SS_IMPEXP_DIR as '/home/oracle/' Directory created. Grant succeeded. old 1: create or replace directory SS_LOGPATH_DIR as '&log_path' new 1: create or replace directory SS_LOGPATH_DIR as '/home/oracle/log.txt' Directory created. Grant succeeded. LRM-00118: syntax error at '=' at the end of input Connected. TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:08 1 row selected. ALTER TABLESPACE example READ WRITE * ERROR at line 1: ORA-00959: tablespace 'EXAMPLE' does not exist TABLESPACE_NAME FILE_NAME STATUS --------------- ---------------------------------------------- --------- SYSTEM /oradata/ORCL/system01.dbf AVAILABLE SYSAUX /oradata/ORCL/sysaux01.dbf AVAILABLE UNDOTBS1 /oradata/ORCL/undotbs01.dbf AVAILABLE USERS /oradata/ORCL/user01.dbf AVAILABLE 4 rows selected. Creating sequences, views, procedures and objects privileges for HR ... TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:08 1 row selected. Connected. Sequence created. Sequence created. Sequence created. regions r * ERROR at line 41: ORA-00942: table or view does not exist Procedure created. BEFORE INSERT OR UPDATE OR DELETE ON employees * ERROR at line 2: ORA-00942: table or view does not exist ALTER TRIGGER secure_employees DISABLE * ERROR at line 1: ORA-04080: trigger 'SECURE_EMPLOYEES' does not exist Warning: Procedure created with compilation errors. AFTER UPDATE OF job_id, department_id ON employees * ERROR at line 2: ORA-00942: table or view does not exist Commit complete. GRANT REFERENCES, SELECT ON employees TO oe * ERROR at line 1: ORA-00942: table or view does not exist GRANT REFERENCES, SELECT ON countries TO oe * ERROR at line 1: ORA-00942: table or view does not exist GRANT REFERENCES, SELECT ON locations TO oe * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON jobs TO oe * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON job_history TO oe * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON departments TO oe * ERROR at line 1: ORA-00942: table or view does not exist Creating synonyms, sequences, views and functions for OE ... TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:08 1 row selected. Connected. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Sequence created. , product_descriptions d * ERROR at line 22: ORA-00942: table or view does not exist , products p * ERROR at line 8: ORA-00942: table or view does not exist , products p * ERROR at line 8: ORA-00942: table or view does not exist , products p * ERROR at line 8: ORA-00942: table or view does not exist FROM product_information * ERROR at line 7: ORA-00942: table or view does not exist FROM customers c, countries cr * ERROR at line 7: ORA-00980: synonym translation is no longer valid Warning: Function created with compilation errors. customers c * ERROR at line 30: ORA-00942: table or view does not exist FROM orders * ERROR at line 11: ORA-00942: table or view does not exist Creating XML schema, XML folders, OC subschema and objects privileges for OE ... TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:08 1 row selected. specify password for OE as parameter 1: PROMPT password for SYS as parameter 2: Connected. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. 1* GRANT alter session TO oe Grant succeeded. View created. View created. Grant succeeded. Session altered. Package created. Warning: Package Body created with compilation errors. View created. Package altered. View altered. Grant succeeded. Trigger created. Synonym created. Grant succeeded. Call completed. Session altered. Session altered. Function created. no rows selected Synonym created. Grant succeeded. Package created. no rows selected Synonym created. Grant succeeded. Package created. no rows selected Package body created. no rows selected Synonym created. Grant succeeded. Package created. no rows selected Package body created. no rows selected Grant succeeded. Synonym created. Package created. no rows selected Package body created. no rows selected Synonym created. Grant succeeded. PL/SQL procedure successfully completed. Connected. DROP DIRECTORY SS_OE_XMLDIR * ERROR at line 1: ORA-04043: object SS_OE_XMLDIR does not exist Directory created. Commit complete. Connected. Revoke succeeded. Connected. Connected. Session altered. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Call completed. Call completed. PL/SQL procedure successfully completed. Connected. Revoke succeeded. Connected. Connected. Revoke succeeded. Revoke succeeded. Revoke succeeded. Package dropped. Package dropped. Package dropped. Package dropped. Package dropped. Trigger dropped. View dropped. Connected. Session altered. ...creating subschema OC in OE Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Type created. Warning: Type created with compilation errors. Type created. Type created. Type created. Warning: Type created with compilation errors. Type created. Type body created. Type created. Type body created. Type created. Type body created. Table created. FROM inventories i, warehouses w * ERROR at line 6: ORA-00942: table or view does not exist FROM product_information p * ERROR at line 10: ORA-00942: table or view does not exist FROM customers c * ERROR at line 20: ORA-00942: table or view does not exist FROM customers c * ERROR at line 20: ORA-00942: table or view does not exist FROM customers c * ERROR at line 20: ORA-00942: table or view does not exist FROM orders o * ERROR at line 9: ORA-00942: table or view does not exist ON oc_orders FOR EACH ROW * ERROR at line 2: ORA-00942: table or view does not exist TABLE order_item_list OF oc_orders FOR EACH ROW * ERROR at line 2: ORA-00942: table or view does not exist Commit complete. FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 5: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 5: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 5: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 5: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist FROM oc_product_information o * ERROR at line 4: ORA-00942: table or view does not exist 1 row created. 1 row created. 1 row created. 1 row created. Type altered. 3 rows updated. 0 rows updated. 0 rows updated. 0 rows updated. Commit complete. Type body altered. Type body altered. Type body altered. GRANT SELECT ON bombay_inventory TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON customers TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON inventories TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON orders TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON order_items TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON products TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON product_descriptions TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON product_information TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON product_prices TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON promotions TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON sydney_inventory TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON toronto_inventory TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON warehouses TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT REFERENCES, SELECT ON product_information TO pm * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON order_items TO pm * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON orders TO pm * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON product_descriptions TO pm * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON inventories TO pm * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON customers TO pm * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON warehouses TO pm * ERROR at line 1: ORA-00942: table or view does not exist Creating dimensions, materialized views, external table and object privileges for SH ... TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:14 1 row selected. Connected. CREATE DIMENSION customers_dim * ERROR at line 1: ORA-00942: table or view does not exist Commit complete. BEGIN dbms_olap.validate_dimension('customers_dim','sh',false,true); END; * ERROR at line 1: ORA-20000: cannot find the dimension ORA-06512: at "SYS.DBMS_DIMENSION", line 413 ORA-06512: at "SYS.DBMS_DIMENSION", line 435 ORA-06512: at "SYS.DBMS_SUMMARY", line 54 ORA-06512: at line 1 no rows selected CREATE DIMENSION products_dim * ERROR at line 1: ORA-00942: table or view does not exist BEGIN dbms_olap.validate_dimension('products_dim','sh',false,true); END; * ERROR at line 1: ORA-20000: cannot find the dimension ORA-06512: at "SYS.DBMS_DIMENSION", line 413 ORA-06512: at "SYS.DBMS_DIMENSION", line 435 ORA-06512: at "SYS.DBMS_SUMMARY", line 54 ORA-06512: at line 1 no rows selected CREATE DIMENSION times_dim * ERROR at line 1: ORA-00942: table or view does not exist BEGIN dbms_olap.validate_dimension('times_dim','sh',false,true); END; * ERROR at line 1: ORA-20000: cannot find the dimension ORA-06512: at "SYS.DBMS_DIMENSION", line 413 ORA-06512: at "SYS.DBMS_DIMENSION", line 435 ORA-06512: at "SYS.DBMS_SUMMARY", line 54 ORA-06512: at line 1 no rows selected CREATE DIMENSION channels_dim * ERROR at line 1: ORA-00942: table or view does not exist BEGIN dbms_olap.validate_dimension('channels_dim','sh',false,true); END; * ERROR at line 1: ORA-20000: cannot find the dimension ORA-06512: at "SYS.DBMS_DIMENSION", line 413 ORA-06512: at "SYS.DBMS_DIMENSION", line 435 ORA-06512: at "SYS.DBMS_SUMMARY", line 54 ORA-06512: at line 1 no rows selected CREATE DIMENSION promotions_dim * ERROR at line 1: ORA-00942: table or view does not exist BEGIN dbms_olap.validate_dimension('promotions_dim','sh',false,true); END; * ERROR at line 1: ORA-20000: cannot find the dimension ORA-06512: at "SYS.DBMS_DIMENSION", line 413 ORA-06512: at "SYS.DBMS_DIMENSION", line 435 ORA-06512: at "SYS.DBMS_SUMMARY", line 54 ORA-06512: at line 1 no rows selected TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:14 1 row selected. FROM costs c, sales s * ERROR at line 13: ORA-00942: table or view does not exist , times t * ERROR at line 8: ORA-00942: table or view does not exist , products p * ERROR at line 12: ORA-00942: table or view does not exist Table created. Creating OLAP metadata ... <<<<< CREATE CWMLite Metadata for the Sales History Schema >>>>> - <<<<< CREATE CATALOG sh_cat for Sales History >>>>> No catalog to drop CWM Collect Garbage - <<<<< CREATE the Sales CUBE >>>>> Sales amount, Sales quantity <TIMES CHANNELS PRODUCTS CUSTOMERS PROMOTIONS > Drop SALES_CUBE prior to recreation No cube to drop Add dimensions - to SALES_CUBE and map the foreign keys ERROR:: dimension_not_found Object Type: DIMENSION Object Owner: SH Object Name: TIMES_DIM Secondary Name: Tertiary Name: User-Defined Exception ERROR: dimension_not_found declare * ERROR at line 1: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "OLAPSYS.CWM$OLAP$DIMENSION", line 242 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "OLAPSYS.CWM$UTIL", line 368 ORA-01403: no data found ORA-06512: at line 1691 Commit complete. GRANT SELECT ON channels TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON countries TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON times TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON costs TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON customers TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON products TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON promotions TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON sales TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON times TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON cal_month_sales_mv TO bi * ERROR at line 1: ORA-00942: table or view does not exist GRANT SELECT ON sh.fweek_pscat_sales_mv TO bi * ERROR at line 1: ORA-00942: table or view does not exist Creating views, synonyms for BI ... TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:15 1 row selected. specify password for BI as parameter 1: Connected. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Commit complete. Connected. PL/SQL procedure successfully completed. Connected. BEGIN dbms_aqadm_sys.validate_Queue('IX', 'AQ$_ORDERS_QUEUETABLE_E'); END; * ERROR at line 1: ORA-24010: QUEUE IX.AQ$_ORDERS_QUEUETABLE_E does not exist ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383 ORA-06512: at line 1 BEGIN dbms_aqadm_sys.validate_Queue('IX', 'AQ$_STREAMS_QUEUE_TABLE_E'); END; * ERROR at line 1: ORA-24010: QUEUE IX.AQ$_STREAMS_QUEUE_TABLE_E does not exist ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383 ORA-06512: at line 1 BEGIN dbms_aqadm_sys.validate_Queue('IX', 'ORDERS_QUEUE'); END; * ERROR at line 1: ORA-24010: QUEUE IX.ORDERS_QUEUE does not exist ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383 ORA-06512: at line 1 BEGIN dbms_aqadm_sys.validate_Queue('IX', 'STREAMS_QUEUE'); END; * ERROR at line 1: ORA-24010: QUEUE IX.STREAMS_QUEUE does not exist ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383 ORA-06512: at line 1 Directory dropped. Directory dropped. mkplug.sql DONE TO_CHAR(SYSTIMEST ----------------- 20190725 04:01:16 1 row selected. SQL>
2019-07-24
优秀的个人博客,低调大师

Oracle 11g on ECS 测试实践--DB篇

我通过脚本和RMAN克隆两种方法创建数据库一.通过SQL创建数据库参考文档1.创建pfile [oracle@orcl1 dbs]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs [oracle@orcl1 dbs]$ cat bak.initORCL.ora db_name='orcl' db_unique_name='orcl1' memory_target=400437056 processes = 150 audit_file_dest='/u01/app/oracle/admin/orcl/adump' audit_trail ='db' db_block_size=8192 db_create_file_dest='/u01/app/oracle/oradata' db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' db_recovery_file_dest_size=2G diagnostic_dest='/u01/app/oracle' dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' control_files = '/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/flash_recovery_area/orcl/control02.ctl' compatible ='11.2.0' 2.启动创建数据库 ##创建数据库的脚本 [oracle@orcl1 dbs]$ cat /home/oracle/scripts/createdb.sql CREATE DATABASE ORCL USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle CONTROLFILE REUSE CHARACTER SET UTF8 NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 5 MAXLOGHISTORY 292 MAXDATAFILES 1024 MAXINSTANCES 32 LOGFILE GROUP 1('/oradata/ORCL/redo01a.log','/oradata/ORCL/redo01b.log') SIZE 50M BLOCKSIZE 512, GROUP 2('/oradata/ORCL/redo02a.log','/oradata/ORCL/redo02b.log') SIZE 50M blocksize 512, GROUP 3('/oradata/ORCL/redo03a.log','/oradata/ORCL/redo03b.log') SIZE 50M BLOCKSIZE 512 DATAFILE '/oradata/ORCL/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 10G SYSAUX DATAFILE '/oradata/ORCL/sysaux01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 10G DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/ORCL/temp01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 1G UNDO TABLESPACE UNDOTBS1 DATAFILE '/oradata/ORCL/undotbs01.dbf'SIZE 10M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 1G DEFAULT TABLESPACE USERS DATAFILE '/oradata/ORCL/users01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 10G / ##基表、动态性能视图等 [oracle@orcl1 dbs]$ cat /home/oracle/scripts/env.sql @?/rdbms/admin/catalog.sql; @?/rdbms/admin/catproc.sql; conn system/oracle; @?/sqlplus/admin/pupbld.sql; [oracle@orcl1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 24 22:11:55 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @/home/oracle/scripts/createdb.sql; SQL> @/home/oracle/scripts/env.sql; 二、通过DBCA中的自带的备份片进行克隆1.创建基于seed的pfileDBCA使用的备份片，dbname是seeddata，如使用11.2.0.4版本，pfile应如下 [oracle@orcl1 dbs]$ cat initseed.ora db_name=seeddata sga_target=500M control_files=/oradata/ORCL/control01.ctl compatible ='11.2.0.4' 2.复制控制文件 [oracle@orcl1 templates]$ cd /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates [oracle@orcl1 templates]$ cp Seed_Database.ctl /oradata/ORCL/control01.ctl 3.启动seed实例 [oracle@orcl1 ~]$ export ORACLE_SID=seed [oracle@orcl1 dbs]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 24 22:29:21 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup mount; Oracle instance started database mounted Total System Global Area 521936896 bytes Fixed Size 2254824 bytes Variable Size 159385624 bytes Database Buffers 356515840 bytes Redo Buffers 3780608 bytes 4.修改redo位置 SQL> select 'alter database rename file '||chr(39)||member||chr(39)||' to '||chr(39)||replace(member,'/ade/b/2232964209/oracle/oradata/seeddata','/oradata/ORCL') ||chr(39)||';' from v$logfile; 'ALTERDATABASERENAMEFILE'||CHR(39)||MEMBER||CHR(39)||'TO'||CHR(39)||REPLACE(MEMBER,'/ADE/B/2232964209/ORACLE/ORADATA/SEEDDATA','/ORADATA/ORCL')||CHR(39)||';' -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- alter database rename file '/ade/b/2232964209/oracle/oradata/seeddata/redo01.log' to '/oradata/ORCL/redo01.log'; alter database rename file '/ade/b/2232964209/oracle/oradata/seeddata/redo02.log' to '/oradata/ORCL/redo02.log'; alter database rename file '/ade/b/2232964209/oracle/oradata/seeddata/redo03.log' to '/oradata/ORCL/redo03.log'; SQL> alter database rename file '/ade/b/2232964209/oracle/oradata/seeddata/redo01.log' to '/oradata/ORCL/redo01.log'; Database altered. SQL> alter database rename file '/ade/b/2232964209/oracle/oradata/seeddata/redo02.log' to '/oradata/ORCL/redo02.log'; Database altered. SQL> alter database rename file '/ade/b/2232964209/oracle/oradata/seeddata/redo03.log' to '/oradata/ORCL/redo03.log'; Database altered. 5.RMAN恢复数据库 RMAN> catalog start with '/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb'; using target database control file instead of recovery catalog searching for all files that match the pattern /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb List of Files Unknown to the Database ===================================== File Name: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb Do you really want to catalog the above files (enter YES or NO)? y cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb RMAN> run 2> {set newname for datafile 1 to '/oradata/ORCL/system01.dbf'; 3> set newname for datafile 2 to '/oradata/ORCL/sysaux01.dbf'; 4> set newname for datafile 3 to '/oradata/ORCL/undotbs01.dbf'; 5> set newname for datafile 4 to '/oradata/ORCL/user01.dbf'; 6> restore database; 7> switch datafile all; 8> recover database; 9> } executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 24-JUL-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=18 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /oradata/ORCL/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /oradata/ORCL/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00003 to /oradata/ORCL/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00004 to /oradata/ORCL/user01.dbf channel ORA_DISK_1: reading from backup piece /ade/b/2232964209/oracle/oradata/Seed_Database.dfb channel ORA_DISK_1: errors found reading piece handle=/ade/b/2232964209/oracle/oradata/Seed_Database.dfb channel ORA_DISK_1: failover to piece handle=/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/Seed_Database.dfb tag=NULL channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:45 Finished restore at 24-JUL-19 datafile 1 switched to datafile copy input datafile copy RECID=5 STAMP=1014503999 file name=/oradata/ORCL/system01.dbf datafile 2 switched to datafile copy input datafile copy RECID=6 STAMP=1014503999 file name=/oradata/ORCL/sysaux01.dbf datafile 3 switched to datafile copy input datafile copy RECID=7 STAMP=1014503999 file name=/oradata/ORCL/undotbs01.dbf datafile 4 switched to datafile copy input datafile copy RECID=8 STAMP=1014503999 file name=/oradata/ORCL/user01.dbf Starting recover at 24-JUL-19 using channel ORA_DISK_1 starting media recovery RMAN-08187: WARNING: media recovery until SCN 925701 complete Finished recover at 24-JUL-19 RMAN> alter database open resetlogs; database opened 6.修复临时文件 [oracle@orcl1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 24 22:52:08 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select file_name from dba_temp_files; select file_name from dba_temp_files * ERROR at line 1: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: '/ade/b/2232964209/oracle/oradata/seeddata/temp01.dbf' SQL> alter tablespace temp add tempfile '/oradata/ORCL/temp01.dbf' size 10m; Tablespace altered. SQL> alter tablespace temp drop tempfile '/ade/b/2232964209/oracle/oradata/seeddata/temp01.dbf'; Tablespace altered. 7.修改dbname SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 521936896 bytes Fixed Size 2254824 bytes Variable Size 159385624 bytes Database Buffers 356515840 bytes Redo Buffers 3780608 bytes Database mounted. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@orcl1 dbs]$ nid target=sys/oracle dbname=ORCL DBNEWID: Release 11.2.0.4.0 - Production on Wed Jul 24 23:17:23 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to database SEEDDATA (DBID=4152976186) Connected to server version 11.2.0 Control Files in database: /oradata/ORCL/control01.ctl Change database ID and database name SEEDDATA to ORCL? (Y/[N]) => y Proceeding with operation Changing database ID from 4152976186 to 1542337155 Changing database name from SEEDDATA to ORCL Control File /oradata/ORCL/control01.ctl - modified Datafile /oradata/ORCL/system01.db - dbid changed, wrote new name Datafile /oradata/ORCL/sysaux01.db - dbid changed, wrote new name Datafile /oradata/ORCL/undotbs01.db - dbid changed, wrote new name Datafile /oradata/ORCL/user01.db - dbid changed, wrote new name Datafile /oradata/ORCL/temp01.db - dbid changed, wrote new name Control File /oradata/ORCL/control01.ctl - dbid changed, wrote new name Instance shut down Database name changed to ORCL. Modify parameter file and generate a new password file before restarting. Database ID for database ORCL changed to 1542337155. All previous backups and archived redo logs for this database are unusable. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully. 8.使用ORCL的pfile启动实例 [oracle@orcl1 dbs]$ cat initORCL.ora db_name='ORCL' db_unique_name='ORCL1' memory_target=512m processes = 150 audit_file_dest='/u01/app/oracle/admin/orcl/adump' audit_trail ='db' db_block_size=8192 db_recovery_file_dest='/orabackup/flash_recovery_area' db_recovery_file_dest_size=2G diagnostic_dest='/u01/app/oracle' dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' control_files = '/oradata/ORCL/control01.ctl' compatible ='11.2.0.4' [oracle@orcl1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 24 23:27:44 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup mount; ORACLE instance started. Total System Global Area 534462464 bytes Fixed Size 2254952 bytes Variable Size 385877912 bytes Database Buffers 142606336 bytes Redo Buffers 3723264 bytes Database mounted. SQL> alter database open resetlogs; Database altered. DB创建完成完成。
2019-07-23
优秀的个人博客,低调大师

Oracle 11g on ECS 测试实践--安装篇

一、环境介绍1.ECS使用1核2G，系统、数据盘各20G这样的配置。2.OS使用CentOS7.63.Oracle 使用 11.2.0.44.存储规划：/u01在系统盘，/oradata（存放数据）和/orabackup（存放备份）分别占用10G空间，存储设备使用上面单独的数据盘二、安装1.配置环境这里我蹭一下Oracle的包，十分便利，参考文档 cd /etc/yum.repos.d/ wget http://public-yum.oracle.com/public-yum-ol7.repo yum install oracle-rdbms-server-11gR2-preinstall --nogpgcheck ##完成后配置oracle用户的的环境变量 [root@orcl1 ~]# cat /home/oracle/.bashrc # .bashrc # Source global definitions if [ -f /etc/bashrc ]; then . /etc/bashrc fi # Uncomment the following line if you don't like systemctl's auto-paging feature: # export SYSTEMD_PAGER= # User specific aliases and functions # Oracle configure profile parameters success export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 export PATH=$ORACLE_HOME/bin:$PATH export ORACLE_OWNER=oracle export ORACLE_SID=chsh export ORACLE_TERM=vt100 export THREADS_FLAG=native export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export PATH=$ORACLE_HOME/bin:$PATH # # change this NLS settings to suit your country: # example: # german_germany.we8iso8859p15, american_america.we8iso8859p2 etc. # export LANG=en_US 2.使用静默的方式安装 [root@orcl1 database]# cp ./response/db_install.rsp ./db_install.rsp ##此处我们对 db_install.rsp文件内容进行修改： oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=orcl1 UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.DBA_GROUP=dba DECLINE_SECURITY_UPDATES=true ##静默安装 ./runInstaller -silent -responseFile /opt/oracle/install/database/db_install.rsp ##安装及执行root脚本 略 3.善后-DB相关目录 ##看下阿里分配的磁盘叫啥 [root@orcl1 database]# fdisk -l Disk /dev/vda: 21.5 GB, 21474836480 bytes, 41943040 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0x000b0ebb Device Boot Start End Blocks Id System /dev/vda1 * 2048 41943039 20970496 83 Linux Disk /dev/vdb: 21.5 GB, 21474836480 bytes, 41943040 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes ##将/dev/vdb划分成两个分区，划分过程略 [root@orcl1 database]# ls /dev/vdb* /dev/vdb /dev/vdb1 /dev/vdb2 ##将磁盘设置为自动挂载 [root@orcl1 database]# blkid /dev/vdb1 >> /etc/fstab [root@orcl1 database]# blkid /dev/vdb2 >> /etc/fstab ##/etc/fstab 修改成如下（UUID保平安） UUID=1cff7e09-01a3-4ae3-a4f1-81590d664a99 /oradata ext4 defaults 0 0 UUID=4a242a04-ed42-4f61-9f95-781ee264b3f5 /orabackup ext4 defaults 0 0 ##创建文件夹并修改属组 [root@orcl1 database]# mkdir /oradata [root@orcl1 database]# mkdir /orabackup [root@orcl1 database]# chown -R oracle.oinstall /ora* [root@orcl1 database]# mount -a [root@orcl1 database]# mount sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime) proc on /proc type proc (rw,nosuid,nodev,noexec,relatime) devtmpfs on /dev type devtmpfs (rw,nosuid,size=930656k,nr_inodes=232664,mode=755) securityfs on /sys/kernel/security type securityfs (rw,nosuid,nodev,noexec,relatime) tmpfs on /dev/shm type tmpfs (rw,nosuid,nodev) devpts on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000) tmpfs on /run type tmpfs (rw,nosuid,nodev,mode=755) tmpfs on /sys/fs/cgroup type tmpfs (ro,nosuid,nodev,noexec,mode=755) cgroup on /sys/fs/cgroup/systemd type cgroup (rw,nosuid,nodev,noexec,relatime,xattr,release_agent=/usr/lib/systemd/systemd-cgroups-agent,name=systemd) pstore on /sys/fs/pstore type pstore (rw,nosuid,nodev,noexec,relatime) cgroup on /sys/fs/cgroup/cpuset type cgroup (rw,nosuid,nodev,noexec,relatime,cpuset) cgroup on /sys/fs/cgroup/devices type cgroup (rw,nosuid,nodev,noexec,relatime,devices) cgroup on /sys/fs/cgroup/perf_event type cgroup (rw,nosuid,nodev,noexec,relatime,perf_event) cgroup on /sys/fs/cgroup/cpu,cpuacct type cgroup (rw,nosuid,nodev,noexec,relatime,cpuacct,cpu) cgroup on /sys/fs/cgroup/freezer type cgroup (rw,nosuid,nodev,noexec,relatime,freezer) cgroup on /sys/fs/cgroup/pids type cgroup (rw,nosuid,nodev,noexec,relatime,pids) cgroup on /sys/fs/cgroup/memory type cgroup (rw,nosuid,nodev,noexec,relatime,memory) cgroup on /sys/fs/cgroup/blkio type cgroup (rw,nosuid,nodev,noexec,relatime,blkio) cgroup on /sys/fs/cgroup/net_cls,net_prio type cgroup (rw,nosuid,nodev,noexec,relatime,net_prio,net_cls) cgroup on /sys/fs/cgroup/hugetlb type cgroup (rw,nosuid,nodev,noexec,relatime,hugetlb) configfs on /sys/kernel/config type configfs (rw,relatime) /dev/vda1 on / type ext4 (rw,relatime,data=ordered) hugetlbfs on /dev/hugepages type hugetlbfs (rw,relatime) debugfs on /sys/kernel/debug type debugfs (rw,relatime) mqueue on /dev/mqueue type mqueue (rw,relatime) tmpfs on /run/user/0 type tmpfs (rw,nosuid,nodev,relatime,size=188224k,mode=700) systemd-1 on /proc/sys/fs/binfmt_misc type autofs (rw,relatime,fd=26,pgrp=1,timeout=0,minproto=5,maxproto=5,direct,pipe_ino=48832) binfmt_misc on /proc/sys/fs/binfmt_misc type binfmt_misc (rw,relatime) /dev/vdb1 on /oradata type ext4 (rw,relatime,data=ordered) /dev/vdb2 on /orabackup type ext4 (rw,relatime,data=ordered) [root@orcl1 database]# chown -R oracle.oinstall /ora* 基础安装结束
2019-07-20
优秀的个人博客,低调大师

开源区块链-链(NULS ChainBox)搭建和测试

简介：NULS ChainBox是一个基于NULS2.0区块链底层运行环境构建的一套区块链应用快速开发平台。它可以帮助区块链应用开发者快速构建自己的区块链应用，而无需关心复杂的底层逻辑。它包含一套友好的开发流程，开发工具以及若干的模块开发模板。 NULS2.0底层运行环境基于微服务架构，支持多语言模块接入，开发者还可使用ChainBox提供的各种开发模板无需关心如何与NULS2.0模块通信，只需专注于业务的实现。github地址：https://github.com/lijunzhou/nuls-engine1.环境准备：macOS、centos7+、ubuntu 14+或者其他linux内核的操作系统，服务器最低标准4核8G安装 Git （推荐yum安装）安装命令 yum -y install git git --version 安装
2019-06-27

资源下载

更多资源
Mario

Mario

马里奥是站在游戏界顶峰的超人气多面角色。马里奥靠吃蘑菇成长，特征是大鼻子、头戴帽子、身穿背带裤，还留着胡子。与他的双胞胎兄弟路易基一起，长年担任任天堂的招牌角色。

时间: 2026-10-18 大小: 211.28KB 下载: 56次
Nacos

Nacos

Nacos /nɑ:kəʊs/ 是 Dynamic Naming and Configuration Service 的首字母简称，一个易于构建 AI Agent 应用的动态服务发现、配置管理和AI智能体管理平台。Nacos 致力于帮助您发现、配置和管理微服务及AI智能体应用。Nacos 提供了一组简单易用的特性集，帮助您快速实现动态服务发现、服务配置、服务元数据、流量管理。Nacos 帮助您更敏捷和容易地构建、交付和管理微服务平台。

时间: 2026-09-24 大小: 189MB 下载: 9次
Rocky Linux

Rocky Linux

Rocky Linux（中文名：洛基）是由Gregory Kurtzer于2020年12月发起的企业级Linux发行版，作为CentOS稳定版停止维护后与RHEL（Red Hat Enterprise Linux）完全兼容的开源替代方案，由社区拥有并管理，支持x86_64、aarch64等架构。其通过重新编译RHEL源代码提供长期稳定性，采用模块化包装和SELinux安全架构，默认包含GNOME桌面环境及XFS文件系统，支持十年生命周期更新。

时间: 2026-08-21 大小: 1.42GB 下载: 6次
Sublime Text

Sublime Text

Sublime Text具有漂亮的用户界面和强大的功能，例如代码缩略图，Python的插件，代码段等。还可自定义键绑定，菜单和工具栏。Sublime Text 的主要功能包括：拼写检查，书签，完整的 Python API ， Goto 功能，即时项目切换，多选择，多窗口等等。Sublime Text 是一个跨平台的编辑器，同时支持Windows、Linux、Mac OS X等操作系统。

时间: 2026-08-21 大小: 9.84MB 下载: 40次
热门标签
DeepSeek Jdk25 OpenAi HarmonyOS6 Nacos3 SpringBoot4 SpringCloud Docker Kubernetes Service Mesh Redis Gemini3 Rocky

欢迎您来访！

登录后，您将获得更多功能！
热门文章
联系我们

有任何问题或合作意向欢迎联系我们

Email: 99873273@qq.com

QQ: 99873273

用户登录
用户注册