Oracle租赁管理系统OLM介绍

Oracle 12c 新特性之ILM 数据生命周期管理张乐奕云和恩墨副总经理，Oracle ACE总监，ACOUG 联合创始人ILM 全称是Information Lifecycle Management，意思是信息生命周期管理，听上去很高端洋气的一个词，但是实际上几乎每个稍微大些的系统都已经在做ILM 了，比如说将生产表中的数据定期插入到历史表中，并把生产表中的这些数据删除，这就是数据生命周期管理；又比如使用了分区，定期将过期的数据分区删除掉，或者置为READONLY，让RMAN 不再备份，这也是数据生命周期管理。

因此ILM 由来已久，只要数据存在活跃-不活跃-静止这样的周期变化，那么ILM 就必不可少，Oracle Database 12c 中提供了很多新功能用来方便地进行数据生命周期管理，有些功能甚至是我们期盼已久的。

时间有效期管理（Temporal Validity）以下简称TV，TV 的功能大致上可以这样描述：在表中手动或者自动建两个时间类型的字段，一个表示有效期的开始时间，一个表示有效期的结束时间，就可以通过设置让只有在有效期内的记录才会被选择出来。

以下这个场景是我构想出来的，一张表里不断地INSERT 数据，但是每条数据有效期只有1分钟，过了1分钟再查就看不见了，如果加以仔细策划，应该会是很有趣的功能。

直接进入测试:1) 设置TV，需要使用dbms_flashback_archive 包，需要该包的执行权限。

2) 创建测试表，period for 关键字是TV新功能的关键字，valid_time 是TV 策略的名字，可以随便写。

valid_time_start 和valid_time_end 字段可以不手工定义，只要指定了period for 关键字，Oracle 会自动创建两个不可见字段。

我这里之所以手工定义开始和结束时间字段，是为了能够指定DEFAULT 值。

有效期开始时间valid_time_start 是记录插入的当前时间，有效期结束时间valid_time_end 是当前时间的后一分钟。

Oracle Financial Services Lending and Leasing for Asset Finance Providers Oracle Financial Services Lending and Leasing is a modern, strategic, and integrated Asset Finance platform for lenders whooffer lending and leasing equipment finance services.As a purpose-built lending and leasing solution covering origination and servicing through collections, it fully supports all loan and leasing product lines. With advanced workflow capabilities and easy integration by design, it can work seamlessly with a financial i nstitution’s other core platforms and supporting applications. It enables a move towards more service-based financing models with a dynamic automation engine, IOT services integration, and pay-for-use pricing models. With flexibility by design, organizations can launch new products and amend existing products rapidly, as well as make timely changes to workflows and business rules. This all works together to build and maintain the best customer experience.Grow Sales and BusinessMany equipment financers are burdened by a rigid and incomplete legacy IT infrastructure. Constraints in adapting quickly to an ever-changing marketplace limit opportunities to explore new areas of competitive advantage and boost revenue growth―and modern lenders must be able to create and support new financial products and provide attractive and flexible finance options.Oracle Financial Services Lending and Leasing has a state of the art, n-tier, service- oriented architecture with a browser-based user interface, a middle tier of business components, and a back-end relational database. The solution uses RESTful web services that lead to faster processing and better operational efficiency. In addition to the robust technology platform, Oracle has extensive experience in the financial services industry that allows it to deliver predefined industry-leading processes and practices.The application is modular and quick and easy to deploy. To meet a diverse and ever-growing range of business requirements, each module offers high levels of functional richness and an open architecture. There are configurable native workflow and automation tools within the application that offer flexibility and coverage for advanced automation requirements. And with over Products and Pricing for Increased Penetration•Operating, finance, and sales-type leases•Fixed and variable-rate loans•Revolving credit facilities•Usage, rental, andsubscription-basedpricing•Subsidized pricingprograms•Wholesale floorplanproducts for dealers anddistribution networks600 REST API services and other integration tools by design, each module slots easily into the complex eco-system of the modern financial institution.Leverage Product, Pricing and Promotion FlexibilityAsset finance lenders often look to boost revenue growth and enhancemarketability by providing bundled solutions of equipment, services, and consumables. Oracle Financial Services Lending and Leasing can offer a master account structure that enables asset finance lenders to link and monitor all these elements under a single bill and payment. Bundling equipment and service charges simplifies solutions for customers and improves internal controls for the lender.Asset finance lenders increasingly need to offer new and innovative products, as well as adapt existing financial products to meet changing demands. Oracle Financial Services Lending and Leasing delivers core flexibility over interest rates (multiple fixed/variable options) and facilitates both traditional rentals and usage-based pricing and subscriptions. It also provides flexibility to launch new products rapidly, as well as the ability to change workflows and business rules quickly—allowing organizations to enhance and maintain the customer experience and remain a leader in the marketplace.In addition, price incentives and promotions are vital tools in equipment sales to drive sales for lenders and manufacturers. Oracle Financial Services Lending and Leasing provides the ability to configure, manage, and control subsidies, or include fixed or usage-based fees in contracts. Lenders also have the ability to offer quick-fire promotions for new business in response to short-term market dynamics as well as to facilitate longer term marketing strategies.Expand into Markets and GeographiesTo operate globally, asset finance lenders need to manage contracts and transactions according to the standards required by each jurisdiction. Oracle Financial Services Lending and Leasing, as a multi-company, multi-language, and multi-currency solution, addresses this requirement head on. It maintains contracts in different currencies in a single portfolio by defining transactional currencies and exchange rates. Its sub ledger also integrates with the global enterprise general ledger system to support diverse and complex accounting regulations with robust and flexible accounting options.Control and Monitor Financed AssetsOnce equipment is delivered to a customer, lenders need to track the equipment through its life. Integration routes between Oracle ERP (or third party ERP platforms) and Oracle Financial Services Lending and Leasing enable all business units of the lender or manufacturer to view asset information, how long they have been in service, and the physical locations. Once a leased asset is terminated, remarketing teams can continue to track assets and sell, re-lease, or scrap the assets once they are returned. Data for Informed Decisions •Customer, vendor, anddealer granularity •Detailed asset records and asset management withtracking functionality •Tools to manageInvestment pools andportfolios•Full accounting sub-ledger for asset financeoperations•Data-driven customerinteractionsExpand into New MarketsUse multiple currencies and exchange rates in asingle portfolioComply with complexaccounting regulationswith flexible accountingdefinitionsCalculate, collect, andremit transaction taxesBundle Products and Services Simplify solutions bybundling products,services, andconsumablesManage separateelements often chargedby different businessunitsBill and collect atcustomer, mastercontract, or individualcontract levelManage Investor PortfoliosStrong relationships with investors are critical to ensuring funding for continued growth. By managing securitization pools, Oracle Financial Services Lending and Leasing gives asset finance lenders powerful tools to manage investor portfolios, including the ability to create multiple pools of receivables for sale using a wide variety of attributes.Drive Operational Efficiency to Improve MarginsIn the dynamic equipment financing market, the ability to provide quick, easy, and hassle-free financing arrangements often makes the difference in a sale. Oracle Financial Services Lending and Leasing Origination allows asset finance lenders to accept, process, and decision credit requests in a paperless, single data entry process. Credit guidelines can be configured to ensure compliance and automate routine credit decisions or make recommendations on more complex requests requiring manual sanction. It provides a flexible workflow management system that users configure to guide and control their underwriting process steps. By managing the origination process, asset finance lenders can adapt workflows, add pricing strategies, define user responsibilities to control access, and add administrative overrides.Oracle Financial Services Lending and Leasing also offers opportunities to leverage Oracle’s transformative technologies, such as artificial intelligence (AI), machine learning (ML), and Internet of Things (IoT) to enhance operating efficiencies and create unprecedented experiences with customers and partners. For example, users can leverage AI and ML to make quicker, more precise credit decisions, as well as manage residuals and collection strategies. Specialized Collection ToolsWith growing pressure on margins on traditional asset lending products, the importance of streamlined, effective collections is paramount. Oracle Financial Services Lending and Leasing has a comprehensive collections module that leverages a unified information architecture along with a robust collection dashboard to provide lenders with word-class capabilities to identify and pursue potential collection problems. Collectors have access to all the information needed to work with customers to ensure payments are collected on-time and functionality to take timely, curative action when needed. Experience a Complete SolutionThe integration pathways between Oracle ERP Cloud (or third-party ERP platforms) and Oracle Financial Services Lending and Leasing offer the complete, best-in-market, digital-class solution. Configure lease, loan, and revolving credit products all in the same system to grow revenue and control operating costs. Built on a unified information architecture, providing a single definition of customers, vendors, suppliers, employees, and financial products―the solution allows lenders to manage customer and investor relationships and control credit, operational, and statutory risk. The cloud- Save customers time and cost by consolidatingcharges on one invoiceAccount automatically for bundled products andservices transactions tothe appropriate accounts Simplify accounting and general ledgerclassificationsautomatically for eachcontractForge Strong Relationships Provide a better customer experience throughshared service centersand self-service accessManage end-of-termoptions with upgrades,swaps, exchanges, andextensive assetinformationManage agreements with investors to fund growth Settlement Platform and automation ensuressuppliers and partners getpaid quicklyOpen, digital-classarchitecture enableslenders to partner withsuppliers to offer unique,powerful solutionprograms to theircustomersbased architecture provides practically unlimited opportunities to expand andintegrate with other applications to create new and innovative solutions thathelp asset finance lenders stay ahead of their competition.Connect with usCall +1.800.ORACLE1 or visit . Outside North America, find your local office at: /OFSLL./financialservices /oracleFS /oraclefsCopyright © 2020, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. This device has not been authorized as required by the rules of the Federal Communications Commission. This device is not, and may not be, offered for sale or lease, or sold or leased, until authorization is obtained. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 1020Disclaimer: This document is for informational purposes. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described in thisdocument may change and remains at the sole discretion of Oracle Corporation.。

Oracle图形化管理工具——OEM修改浏览权限| 删除Oracle图形化管理工具——OEMOracle企业管理器（Oracle Enterprise Manager，OEM）是Oracle提供的一个基于Web的图形化数据库管理工具。

通过OEM，用户可以完成几乎所有的原来只能通过命令行方式完成的工作，包括数据库对象、用户权限、数据文件、定时任务的管理，数据库参数的配置，备份与恢复，性能的检查与调优等。

28.5.1 安装和使用OEM如果要使用Oracle企业管理器，那么在创建数据库时需要选择【Enterprise Manager 资料档案库】复选框，如图28.57所示。

可执行如下命令查看OEM进程的状态。

$ emctl status dbconsole //查看OEM进程的状态Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.https://demoserver:1158/em/console/aboutApplicationOracle Enterprise Manager 11g is not running. //OEM进程未启动------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/dem-oserver_orcl/sysman/log图28.57 安装OEM组件如果没有启动，则执行如下命令启动OEM进程：$ emctl start dbconsole //启动OEM进程Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.https://demoserver:1158/em/console/aboutApplication//访问OEM的URLStarting Oracle Enterprise Manager 11g Database Control.......................... started. //启动正常------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/dem-oserver_orcl/sysman/log确定OEM已经启动后，打开浏览器，在地址栏中输入https://demoserver:1158/em（不同主机上的数据库，其OEM的访问端口可能会有所不同，用户可执行emctl status dbconsole命令获取实际的访问地址和端口）并回车，打开如图28.58所示的OEM登录页面。

oim操作手册OIM操作手册第一章：OIM概述1.1 OIM定义Oracle Identity Manager（简称OIM）是Oracle公司提供的一款综合性身份管理解决方案，可以帮助企业有效地管理用户身份和访问权限。

1.2 OIM的功能OIM具有以下核心功能：- 用户生命周期管理：OIM可以管理用户在整个生命周期中的变化，包括创建、修改和删除等操作。

- 访问权限管理：OIM可以根据用户角色和组织架构，实现对资源的访问权限管理，确保用户只能获得合法的访问权限。

- 自助服务：OIM支持用户自主申请和审批，用户可以根据自身需要申请访问权限，并经过审批流程后获得权限。

- 账户管理：OIM可以集中管理用户的账户信息，包括密码重置、账户锁定等功能。

- 合规性管理：OIM可以根据合规性要求对用户权限进行审计，确保企业符合法规和政策要求。

- 审计和监控：OIM可以记录用户操作和权限变更的日志，并支持监控和审计权限分配的情况。

1.3 OIM架构OIM采用三层架构，分为数据库层、应用层和客户端层。

- 数据库层：OIM使用Oracle数据库存储用户和权限信息。

- 应用层：OIM应用服务器负责处理用户请求和执行业务逻辑。

- 客户端层：用户可以通过浏览器或OIM客户端应用程序进行与OIM的交互。

第二章：OIM安装与配置2.1 硬件和软件要求在安装OIM之前，需要满足以下硬件和软件要求：- 服务器硬件要求：具备足够的内存、存储和处理能力，以支持OIM的运行。

- 操作系统要求：支持的操作系统包括Linux、Windows等。

- 数据库要求：需要安装和配置Oracle数据库。

- Java要求：需要安装和配置Java Development Kit（JDK）。

- Web服务器要求：推荐使用Oracle WebLogic Server。

2.2 安装步骤以下是安装OIM的基本步骤：1. 安装和配置Oracle数据库。

2. 安装和配置Java Development Kit（JDK）。

Oracle企业管理器(OEM)常见问题解答
Oracle企业管理器(OEM)常见问题解答Oracle企业管理器(OEM)常见问题解答发布时间：2006-05-13OracleEnterpriseManager(Oracle企业管理器,简称OEM)是通过一组Oracle程序，
为管理分布式环境提供了管理服务。

OEM包括了一组DBA工具，一个repository，
以及一个图形化显示的控制台。

OEM控制台与每一个服务器上的智能化代理(IntelligentAgent)相对应。

智能化代理能够监控系统的特定事件并且执行任务（作业）就象你在系统
本地一样。

事件和作业的结果会被送回控制台，这样可以在一个地方管理所有的系统。

OEM与ServerManagerMotif相比，有以下优点：
1）从适用范围看，OEM可以同时监控管理多个系统上的多个数据库，因而
特别适合分布式环境；而ServerManager只能监控管理一个数据库。

2）从管理对象看，OEM可以监控管理节点，数据库和监听进程（listener），
而ServerManager只能监控数据库。

3）从适用版本看，OEM可以同时监控管理Oracle7.x和8.x，而从8版开始，ServerManager已不存在。

ORACLE 硬件软件实现的虚拟技术介绍第一章虚拟技术作为云技术的重要组成部分，如今越来越重要，成为人们谈云的时候必谈的一个话题。

虚拟技术重点对服务器、存储以及网络进行虚拟化，人们通过该技术可以灵活获取到所需要的资源，包括计算资源、存储资源等等。

综合ORACLE的软硬件技术，其实现虚拟化方法非常地方便与灵活，而对于资源的管理也有众多方法与之适应。

而对于应用程序和架构师来说，如何选择虚拟技术，这需要根据具体的实际情况来做判选的标准。

Solaris Containers技术该方法被称为zone技术，是在操作系统层面实现的一种完全逻辑隔离的一个操作系统环境，Container技术适合所有运行Solaris 10的SPARC、X64的主机系统。

Zone实现的操作系统环境通过Solaris的Resource Management管理程序来实现CPU/memory等资源灵活的、颗粒度很小的划分。

zone通过虚拟硬件的方法实现旧有系统的无缝迁移，这是个非常重要的方法，他实现了原有系统无缝运行于最新的硬件系统中，使得旧有的程序分享了目前最新的硬件技术，其获得的好处是明显。

Sun Dynamic System Domains分区技术在中高端服务器中动态域技术实现了真正意义上的电气隔离的虚拟技术，在同一的机箱中实现不同域主机的完全隔离，并由此实现安全隔离系统和高有效性。

这对于将一些少量的关键应用服务器整合到同一物理服务器上提供了有效的方法，这也为数据中心大大节约了空间和电源的消耗。

分区技术在SUN Fire 6900以及M系列服务器得到了很好的应用。

Logical Domains（ORACLE Solaris VM）技术集成于底层的hypervisor提供了硬件管理，该虚拟技术的实现得益于固件层管理程序。

该虚拟方法综合了前两种方法的好处，即实现了硬件的隔离，又实现了逻辑上的系统隔离。

LDOM技术仅仅适于应用在T1、T2、T3、T4等CPU组成的主机系统中。