Windows 7/Server 2008 Oracle 11g静默安装指南:创建响应文件

需积分: 10 1 下载量 14 浏览量 更新于2024-09-13 收藏 629KB DOCX 举报
Oracle静默安装BSA (Business System Administrator) 是一种无交互式的方式,用于在Windows操作系统,如Windows 7、Windows Server 2008及更高版本上自动化安装Oracle数据库11g服务器版的过程。静默安装允许管理员通过预先配置好的响应文件(如install_oracle_11g_only.rsp)来控制安装过程,无需用户交互,从而提高部署效率。 在进行静默安装前,首先要确保操作系统环境符合Oracle的要求。根据提供的refhost.xml文件,认证系统部分列出了一系列支持的操作系统版本及其对应的服务包。对于Windows 7和Windows Server 2008,它们基于相同的内核版本6.1,因此可以直接使用针对Windows Vista(6.0)或Windows 7(6.1)的条目来进行配置。需要注意的是,在实际操作时,确认当前系统版本并更新相应 `<VERSIONVALUE>` 和 `<SERVICE_PACKVALUE>`。 在配置好安装环境后,创建一个批处理文件(如Record.bat),使用`setup-record-destinationFile`命令记录安装过程。这一步骤会在指定的文件夹(例如E:\respnse_Files\)生成名为`install_oracle_11g_only.rsp`的响应文件,它包含了安装过程中所有默认或自定义的选项和参数,如数据库的安装路径、许可模式、语言选择等。运行批处理后,响应文件会详细记录这些配置,供后续的静默安装使用。 在执行静默安装时,只需将setup.exe与响应文件一起运行,如`setup.exe -responsefile E:\respnse_Files\install_oracle_11g_only.rsp`,Oracle 11g服务器版就会按照预先设定的配置进行安装,整个过程无需用户干预,节省了大量时间和人工成本。 总结来说,Oracle静默安装BSA是一种在Windows平台上进行高效、自动化数据库部署的方法,通过调整和记录响应文件,可以实现对不同版本Windows的兼容并简化安装流程。这对于大型企业或需要频繁部署的场景尤其有用。

SELECT bs.sample_id, bs.item_id, bs.report_id, bs.order_no, bs.order_id, bs.order_business_type, bs.commission_date, bs.customer_name, bs.applicant, bs.phone, bs.receive_user_name, bs.contract_no, bs.special_requirements, bs.report_org_name, bs.report_org_address, bs.sample_name, bs.standard_instrument_name, bs.complete_day, bs.sample_remark AS remark, bs.standard_instrument_id, bs.sample_no, bs.factory_number, bs.item_name, /*bs.item_quantity,*/ bs.inspection_type, bs.mandatory_flag, bs.test_quantity, bs.sample_state, bs.current_site, bs.plan_complete_date, bs.affix, bs.ranges, bs.grade, bs.factory, bs.calibrat_point, bs.apply_dept, bs.specification, bs.final_fee, bs.service_type, CASE WHEN bs.actual_complete_date IS NOT NULL THEN DATEDIFF( bs.plan_complete_date, bs.actual_complete_date ) ELSE datediff( bs.plan_complete_date, now()) END AS surplus_days, bs.report_no, bs.is_report_back, bs.back_reason AS report_back_reason, bs.is_just_certificate, bs.report_state, bs.temper, bs.humidity, bs.test_result, bs.test_date, bs.next_test_date, bs.test_cycle, bs.test_address, bs.generate_time, bs.point_report_id, bs.is_merge, bs.circulation_flag, bs.item_proposal_fee AS proposal_fee, bs.change_price_reason, bs.test_user_name, bs.group_id, bs.group_name, bs.charging_num, bs.other_fee, bs.receivable_fee, bs.affix_quantity, bs.test_org, bs.out_org_order_no, bs.out_org_sample_no, bs.business_user_name, bs.pdf_path, bs.settlement_state, bs.result_describe, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id JOIN bus_sample_attr bsa ON sa.id = bsa.id 根据bs.commission_date 进行排序最近的排上面 bs.commission_date

2023-07-15 上传

SELECT bs.report_no, bs.sample_id, bs.test_id, bs.service_type, bs.sample_name, bs.total_fee, bs.receivable_fee, bs.sample_no, bs.ranges, bs.grade, bs.sample_remark AS remark, bs.factory, bs.item_name, bs.apply_dept, bs.specification, bs.factory_number, bs.calibrat_point, bs.mandatory_flag, bs.inspection_type, bs.report_org_name, bs.plan_complete_date, bs.standard_instrument_name, bs.bleeding_site_name, bs.arrive_date, DATEDIFF( bs.plan_complete_date, NOW()) AS surplus_days, bs.order_no, bs.order_type, bs.customer_name, bs.order_id, bs.business_type, bs.group_id, bs.group_name, bs.item_id, bs.is_merge, bs.pass_time, bs.audit_time, bs.report_id, bs.compile_time, bs.generate_time, bs.pass_user_name, bs.audit_user_name, bs.compile_user_name, bs.report_state, bs.is_just_certificate, bs.label_price, bs.labor_cost, bs.product_type, bs.batch_number, bs.original_number, bs.type_no, bs.template_id, bs.template_version, bs.standard_instrument_id, bs.standard_instrument_name, bs.report_query_code, bs.test_user_id, bs.test_user_name, bs.test_time, bs.review_user_id, bs.review_user_name, bs.review_time, bs.or_number, bs.test_result, bs.test_result_text, bs.test_date, bs.test_address, bs.result_value, bs.unit, bs.test_dept_id, bs.test_dept_name, bs.sample_mass, bs.form, bs.color, bs.clarity, bs.amplification_detection, bs.precious_metal, bs.remarks, bs.photo, bs.identifying_code, bs.diamond_quality, bs.hand_ring, bs.craft, bs.instrument_photo, bs.customer_item_basis, bs.quality_photo, bs.check_point, bs.check_code, bs.mass_unit, bs.manufacturer_name, bs.manufacturer_addr, bs.result_sample_describe AS sampleDescribe, bs.test_rule AS metalRuleIdsStr, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id JOIN bus_sample_attr bsa ON sa.id = bsa.id 需要按照bs.report_no 的整数来从小到大进行排序

2023-07-15 上传