Oracle-11g图形界面创建数据库操作指南

Oracle 11g表空间——创建和扩展（永久）表空间本文内容创建（永久）表空间查看表空间扩展表空间创建（永久）表空间Oracle 按照区和段空间进行管理表空间。

区管理方式 - 针对区的分配方式的不同，有两种方式：字典管理方式（dictionary-managed tablespace，DMT）和本地管理方式（local-managed tablespace，LMT）。

Oracle 10g 开始强烈建议使用 LMT 方式。

从 Oracle 9i 开始，创建表空间时默认使用 LMT。

其中，LMT 区的分配方式：统一（UNIFORM）- 统一分配。

指定表空间中所有区的大小都相同。

默认值是 1MB。

自动（AUTOALLOCATE 或 SYSTEM）- 自动分配。

指定有 Oracle 系统来自动管理区的大小。

这是默认设置。

段管理方式– LMT 方式，除了可以指定区的分配方式外，还可以指定段的管理方式。

段空间管理方式主要是指 Oracle 用来管理段中已用数据块和空闲数据块的机制。

分为两种：手动（MANUAL）- Oracle 将使用空闲列表（free list）管理段的已用数据块和空闲数据块。

这是传统的段空间管理方式，为了与以前的版本兼容。

自动（AUTO）- Oracle 将使用位图（bitmap）来管理段的已用数据块和空闲数据块。

通过位图中单元的取值判断段中的数据块是否可用。

字典管理方式没有段管理。

下面示例演示用本地管理方式创建表空间。

这是 Oracle 推荐的方式。

示例 1：使用 AUTOALLOCATE 区分配方式。

创建表空间 mytbs01，数据文件是D:\oracledata\mytbs01_1.dbf，大小为 2M，并指定区分配方式为 AUTOALLOCATE。

create tablespace mytbs01datafile 'D:\oracledata\mytbs01_1.dbf' size 2Mautoallocate;示例 2：使用 UNIFORM 区分配方式。

Oracle 11g for Windows的安装与配置数据库管理系统的安装与升级是一项比较复杂的任务。

为了使Oracle 11g数据库系统可以安装在多种平台上，Oracle提供的Oracle Universal Installer（Oracle通用安装工具，OUI）是基于Java技术的图形界面安装工具，利用它可以完成在不同操作系统平台上的、不同类型的、不同版本的Oracle数据库软件的安装。

无论是Windows NT/XP/2003、Sun Solaris、HP UNIX、Digital UNIX、VMS还是OS/390都可以通过使用OUI以标准化的方式来完成安装任务。

本节主要介绍如何在Windows平台上安装和配置Oracle数据库服务器。

Oracle 11g数据库服务器由Oracle数据库和Oracle例程组成。

安装数据库服务器就是将管理工具、网络服务、实用工具、基本的客户机软件等部分，或者将相应的文件从安装盘复制到计算机硬盘的文件夹结构中，并创建数据库、配置网络、启动服务等。

Oracle 11g数据库服务器有两种安装方式：高级安装和基本安装。

由于基本安装比较简单，配置参数较少，用户只需要按照Oracle 11g的安装步骤要求一步一步往下安装就可以了，而高级安装较为复杂。

下面以高级安装为例进行介绍，其安装步骤如下：（1）运行安装文件夹中的Setup.exe命令，将启动Universal Installer，出现Oracle Universal Installer自动运行窗口，即快速检查一次计算机的软件、硬件安装环境，如果不满足最小需求，则返回一个错误并异常终止。

如图1-7所示。

图1-7 Oracle Universal Installer自动运行窗口（2）当OUI检查完软、硬件环境之后，出现【选择要安装的产品】窗口，如图1-8所示。

图1-8 选择要安装的产品如果想快速地安装Oracle 11g数据库，可以单击【基本安装】单选按钮，再输入数据库登录密码，然后单击【下一步】按钮开始基本安装。

Oracle HTTP Server 11g R1 Configuration for FLEXCUBEOracle FLEXCUBE Universal BankingRelease 12.4.0.0.0[May] [2017]Table of Contents1.PURPOSE (3)2.INTRODUCTION TO ORACLE HTTP SERVER (OHS) (3)2.1HTTP L ISTENER (3)2.2M ODULES (MODS) (3)3.INSTALLATION OF OHS 11G (4)4.CONFIGURE ORACLE HTTP SERVER INFRONT OF WEBLOGIC SERVER (11)4.1F OR W EB L OGIC IN SINGLE INSTANCE (11)4.2F OR W EBLOGIC INSTANCES IN CLUSTER (12)5.ENABLE “WEBLOGIC PLU G-IN ENABLED” FLAG I N WEBLOGIC (13)PRESSION RULE SETTING (13)6.1L OADING MOD_DEFLATE (13)6.2C ONFIGURING FILE TYPES (14)6.3HTTPD.CONF FILE CHANGES (14)7.CONFIGURING SSL FOR ORACLE HTTP SERVER (16)7.1SSL CONFIGURATION FOR I NBOUND R EQUEST TO O RACLE HTTP S ERVER (16)7.1.1Create a new Wallet and import Certificate (16)7.1.2Configuring Wallet in ssl.conf file (20)7.2C ONFIGURING SSL BETWEEN O RACLE HTTP S ERVER AND O RACLE W EBLOGIC S ERVER (21)7.2.1Turn off KeepAliveEnabled (21)7.2.2To enable one-way SSL (21)7.2.3To enable two-way SSL (22)8.SAMPLE CONFIGURATION FILES (23)9.STARTING, STOPPING, AND RESTARTING ORACLE HTTP SERVER (23)9.1S TART (23)9.2S TOP (23)9.3R ESTART (23)10.TEST THE APPLICATION (24)11.SERVER LOGS LOCATION (24)12.REFERENCES (24)1. PurposeThe objective of this document is to explain the installation and configuration of Oracle HTTP Server 11g R1(11.1.1.6.0). This includes setting up of server details, configuration of compression rules and enabling SSL.2. Introduction to Oracle HTTP Server (OHS)Oracle HTTP Server is the Web server component for Oracle Fusion Middleware. It is based on Apache web server, and includes all base Apache modules and modules developed specifically by Oracle. It provides a HTTP listener for Oracle WebLogic Server and the framework for hosting static pages, dynamic pages, and applications over the Web. Key aspects of Oracle HTTP Server are its technology, its serving of both static and dynamic content and its integration with both Oracle and non-Oracle products.Oracle HTTP Server consists of several components that run within the same process. These components provide the extensive list of features that Oracle HTTP Server offers when handling client requests.Following are the major components:2.1 HTTP ListenerOracle HTTP Server is based on an Apache HTTP listener to serve client requests. An HTTP server listener handles incoming requests and routes them to the appropriate processing utility.2.2 Modules (mods)Modules extend the basic functionality of Oracle HTTP Server, and support integration between Oracle HTTP Server and other Oracle Fusion Middleware components. There are modules developed specifically by Oracle for Oracle HTTP Server. Ex: mod_wl_ohs, mod_plsqlOracle HTTP Server also includes the base Apache and third-party modules out-of-the-box.These modules are not developed by Oracle. Ex: mod_proxy, mod_perl3. Installation of OHS 11gInvoke the setup exe to start the installationSelect Skip Software UpdatesSelect Install and ConfigureSelect only Oracle HTTP ServerEnter the required OHS instance and component namesThis completes the installation of Oracle HTTP Server with <Instance> and <component>. Example: Instance is instance1 and component is ohs1.If you would like to change the port after the installation(OHS Listen Port) edit$ORACLE_INSTANCE/config/OHS/<component_name>/httpd.conf and change the listen port.NOTE: This port is for http protocol and not for https.4. Configure Oracle HTTP Server infront of Weblogic ServerIn Oracle HTTP Server requests from Oracle HTTP Server to Weblogic server are proxied usingmod_wl_ohs module. This configuration file needs to be modified to include the Weblogic server and port details.mod_wl_ohs.conf file is located at${ORACLE_INSTANCE}/config/OHS/{COMPONENT_NAME}/mod_wl_ohs.confAdd the below directives to mod_wl_ohs.conf file.4.1 For WebLogic in single instance<Location /<<context/url>> >SetHandler weblogic-handlerWebLogicHost <<server name>>WeblogicPort <<port>></Location>Example:<Location /FCJNeoWeb>SetHandler weblogic-handlerWebLogicHost wlserver1WeblogicPort 7707</Location>This will forward /FCJNeoWeb from HTTP server to /FCJNeoWeb on WebLogic Server wlserver1: 77074.2 For Weblogic instances in cluster<Location /<<context/url>> >SetHandler weblogic-handlerWebLogicCluster <server1>:<port1>,<server2>:<port2></Location>Example<Location / FCJNeoWeb >SetHandler weblogic-handlerWebLogicCluster wlserver1:7010, wlserver2:7010</Location>This will forward /FCJNeoWeb from HTTP server to /FCJNeoWeb on WebLogic Cluster wlserver1:7010 and wlserver2:70105.Enable “WebLogic Plug-In Enabled” flag in weblogicThis flag needs to be enabled in weblogic if it is accessed through proxy plugins. When the WebLogic plugin is enabled, a call to getRemoteAddr will return the address of the browser client from the proprietary WL-Proxy-Client-IP header instead of the web server.a. Plugin flag at managed server leveli. Click on ‘Environment’- > 'Servers' -> '<ManagedServer>' -> 'General' -> 'Advanced'ii. Check the 'WebLogic Plug-In Enabled' box.iii. Click 'Save'iv. Restart the Server.b. Plugin flag at domain levelv. Click on <Domain> -> 'Web Applications'vi. Check the 'WebLogic Plug-In Enabled' box.vii. Click 'Save'viii. Restart the server.6. Compression rule settingContent compression in Oracle HTTP Server is done using mod_deflate. This can compress HTML, text or XML files to approx. 20 - 30% of their original sizes, thus saving on server traffic. However, compressing files causes a slightly higher load on the server, but clients' connection times to server is reduced.6.1 Loading mod_deflatemod_deflate is used for compression in OHS and this is installed in Oracle HTTP Server under location "${ORACLE_HOME}/OHS/modules/mod_deflate.so"But it might not be loaded.To load the file add the below directive in mod_wl_ohs.conf fileLoadModule deflate_module "${ORACLE_HOME}/OHS/modules/mod_deflate.so"6.2 Configuring file typesmod_deflate also requires to specify which type files are going to be compressed.In the LOCATION section of mod_wl_ohs.conf file add the below entries.AddOutputFilterByType DEFLATE text/plainAddOutputFilterByType DEFLATE text/xmlAddOutputFilterByType DEFLATE application/xhtml+xmlAddOutputFilterByType DEFLATE text/cssAddOutputFilterByType DEFLATE application/xmlAddOutputFilterByType DEFLATE application/x-javascriptAddOutputFilterByType DEFLATE text/htmlSetOutputFilter DEFLATEImages are supposed to be in a compressed format, and therefore are bypassed by mod_deflate.6.3 httpd.conf file changesThis is a server configuration file which typically contains directives that affect how the server runs, such as user and group IDs it should use, and location of other files. Cross check the existence of mod_wl_ohs.conf include in httpd.conf file.httpd.conf file is present under location“${ORACLE_INSTANCE}/config/OHS/{COMPONENT_NAME}/httpd.conf”In this file cross check for the below entryinclude "${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/mod_wl_ohs.conf"If above include entry is not present, then add the above include section.7. Configuring SSL for Oracle HTTP ServerSecure Sockets Layer (SSL) is required to run any Web site securely. Secure Sockets Layer (SSL) is an encrypted communication protocol that is designed to securely send messages across the Internet.Reading of “SSL_Configuration on Weblogic” document provide d as part of FCUBS installation isrecommended before proceeding with further setup.In Oracle HTTP server, SSL configuration can be done between1. Browser to Oracle HTTP Server(Mandatory)2. Oracle HTTP Server to Oracle Weblogic Server(If required)7.1 SSL configuration for Inbound Request to Oracle HTTP ServerPerform these tasks to enable and configure SSL between browser and Oracle HTTP Server.1. Obtain a certificate from CA or create a self signed certificate.2. Create an Oracle Wallet which contains the above SSL Certificate. The default wallet that isautomatically installed with Oracle HTTP Server is for testing purposes only. The default wallet is located in "${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/keystores/default"3. Configuring Wallet in ssl.conf file7.1.1 Create a new Wallet and import Certificate1. Go to the \Oracle_WT1\bin\launch.exe, this will launch your wallet manager2. Click on Create new and then click no option.3. Enter the wallet password and click on OK, this will create a new wallet.4. Not it will ask for certificate request creation, Click on NO to proceed5. Right click on trusted certificates and then import trusted certificate.6. Browse to the folder where certificate is stored and click on Open7. Click on Save Wallet button on the left side navigation and save the wallet either to defaultlocation("${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/keystores/default") or folder of your choice.8. Click on Wallet tab and enable Auto Login7.1.2 Configuring Wallet in ssl.conf fileIn ssl.conf file the newly created wallet need to updated. This file is located under folder"${ORACLE_INSTANCE}/config/OHS/${COMPONENT_NAME}/1. Change the SSLWallet directive to point to the location of new wallet created.SSLWallet "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/keystores/"2. Change the Listen port number in ssl.conf file to the SSL enabled port, by default the value is 44437.2 Configuring SSL between Oracle HTTP Server and Oracle Weblogic ServerSSL for outbound requests from Oracle HTTP Server are configured in mod_wl_ohs.Refer to “SSL_Configura tion on Weblogic” document for weblogic server setting mentioned in below section.7.2.1 Turn off KeepAliveEnabledThe below parameter in mod_wl_ohs should be turned off, by default it is on. Add the below directive under LOCATION section of mod_wl_ohs fileKeepAliveEnabled OFF7.2.2 To enable one-way SSL1. Generate a custom keystore identity.jks for Weblogic Server containing a certificate.2. At Identity section in Keystores tab in weblogic Admin Console for server seta. The custom trust store with the identity.jks file locationb. The keystore type as JKSc. The passphrase used to created the keystore3. Copy the certificate to Oracle HTTP Server and import the new certificate into OHS wallet as a trustedcertificate.4. Add following new directive in mod_wl_ohs.conf to point to the wallet locationWlSSLWallet "${ORACLE_INSTANCE}/config/OHS/{COMPONENT_NAME}/keystores/default"5. Change the port in mod_wl_ohs file to point to SSL port of Weblogic server.6. Restart both Weblogic Server and Oracle HTTP Server7.2.3 To enable two-way SSL1. Perform one-way SSL configuration steps2. Generate a new trust store, trust.jks for Weblogic server3. Keystore created for one-way SSL could be used, but it is recommended to create a separate truststore4. Export the user certificate from Oracle HTTP Server wallet, and import it into truststore created above5. At Trust section in Keystores tab in Weblogic Admin Console for the server seta. The custom trust store with the trust.jks file locationb. The keystore type as JKSc. The passphrase used to created the keystore6. Under the SSL tabEnsure trusted CA is set as from Custom Trust Keystore.7. Restart Weblogic Server8. Sample Configuration Fileshttpd.conf mod_wl_ohs.conf ssl.conf9. Starting, Stopping, and Restarting Oracle HTTP ServerNavigate to the below location in command prompt ${ORACLE_INSTANCE}/bin/ and run below commands 9.1 Startopmnctl startproc ias-component={COMPONENT_NAME}Example: opmnctl startproc ias-component=ohs19.2 Stopopmnctl stopproc ias-component={COMPONENT_NAME}Example: opmnctl stopproc ias-component=ohs19.3 Restartopmnctl restartproc ias-component={COMPONENT_NAME}Example: opmnctl restartproc ias-component=ohs110. Test the applicationTest the application deployed on Weblogic using Oracle HTTP Server after restarting both the oracle http server and weblogic serverhttps://ohs_servername:ohs_https_port/<<context/url>>http://ohs_servername:ohs_http_port/<<context/url>>ohs_servername: server on which OHS is deployedohs_https_port: port number mentioned against LISTEN directive in SSL.conf fileohs_http_port: port number mentioned against LISTEN directive in httpd.conf fileExample:https://localhost:4443/FCJNeoWeb/welcome.jspOrhttp://localhost:7777/FCJNeoWeb/welcome.jsp11. Server Logs LocationOracle HTTP Server Logs are generated under folder${ORACLE_INSTANCE}/diagnostics/logs/OHS/{COMPONENT_NAME}/12. ReferencesSSL_Configuration.doc for Weblogic provided as part of FCUBS installation./cd/E16764_01/web.1111/e10144/under_mods.htm/cd/E25054_01/core.1111/e10105/sslconfig.htmOracle_HTTP_Server_Configuration[May] [2017]Version 12.4.0.0.0Oracle Financial Services Software LimitedOracle ParkOff Western Express HighwayGoregaon (East)Mumbai, Maharashtra 400 063IndiaWorldwide Inquiries:Phone: +91 22 6718 3000Fax:+91 22 6718 3001/financialservices/Copyright © 2007, 2017, Oracle and/or its affiliates. All rights reserved.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。

Linux系统（X64）安装Oracle11g完整安装图⽂教程另附基本操作⼀、修改操作系统核⼼参数在Root⽤户下执⾏以下步骤：1）修改⽤户的SHELL的限制，修改/etc/security/limits.conf⽂件输⼊命令：vi /etc/security/limits.conf，按i键进⼊编辑模式，将下列内容加⼊该⽂件。

oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536编辑完成后按Esc键，输⼊“:wq”存盘退出2）修改/etc/pam.d/login ⽂件，输⼊命令：vi /etc/pam.d/login，按i键进⼊编辑模式，将下列内容加⼊该⽂件。

session required /lib/security/pam_limits.sosession required pam_limits.so编辑完成后按Esc键，输⼊“:wq”存盘退出3）修改linux内核，修改/etc/sysctl.conf⽂件，输⼊命令: vi /etc/sysctl.conf ，按i键进⼊编辑模式，将下列内容加⼊该⽂件fs.file-max = 6815744fs.aio-max-nr = 1048576kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576编辑完成后按Esc键，输⼊“:wq”存盘退出4）要使 /etc/sysctl.conf 更改⽴即⽣效，执⾏以下命令。

第一章 Oracle11g （Linux ）5.1 O racle11g 简介 5.1.1 Oracle11g 版本Oracle 11g 有多个版本可供选择： 标准版1、标准版和企业版。

所有这些版本都使用相同的通用代码库构建，这意味着企业的数据库管理软件可以轻松地从规模较小的单一处理器服务器扩展到多处理器服务器集群，而无需更改一行代码。

Oracle 数据库11g 企业版还有许多其他增强了性能、可伸缩性、可用性、安全性和可管理性的功能选项。

主要功能汇总简化版10g标准版1标准版企业版CPU 最大数量1 CPU2 Sockets 4 Sockets无限制RAM1GB操作系统允许的最大容量操作系统允许的最大容量操作系统允许的最大容量 数据库规模 4GB无限制无限制无限制 WindowsLinuxUnix支持 64 位5.2安装环境5.2.1硬件环境1.Linux（RedHat6_32bit服务版）操作系统主机一台，IP地址为172.16.165.2422.Linux系统安装Oracle系统要求：内存必须高于1G的物理内存交换区间一般为内存的2倍，例如：1G的内存可以设置swap 分区为3G大小硬盘5G以上5.2.2软件环境Oracle11g服务器安装包，安装包本地位置为：\\172.16.165.144\工具软件\Oracle11g安装平台为RedHat6_32bit的Linux操作系统5.3安装步骤5.2.1卸载Oracle如果在系统中本身已经安装了Oracle数据库，则在安装之前需要先将其卸载完全方可进行重新安装。

下面为大家讲解Linux操作系统下的Oracle数据库的卸载。

1.使用SQL*PLUS停止数据库。

在桌面上右键选择“打开一个终端”[oracle@redhat 6 ~]$ sqlplus /nologSQL> connect / as sysdbaSQL> shutdown immediateSQL> exit2.停止Listener[oracle@redhat 6 ~]$ lsnrctl stop3.停止HTTP服务[root@redhat6 desktop]# service httpd stop4.用su或者重新登录到root(如想重新安装可以保留oracle用户，省得输入环境变量了)5.将安装目录删除[root@redhat6 desktop]# rm -rf /u01/app/oracle/6.将/usr/bin下的文件删除[root@redhat6 desktop]# rm /usr/local/bin/dbhome[root@redhat6 desktop]# rm /usr/local/bin/oraenv[root@redhat6 desktop]# rm /usr/local/bin/coraenv7.将/etc/oratab删除[root@redhat6 desktop]# rm /etc/oratab8.将/etc/oraInst.loc删除[root@redhat6 desktop]# rm /etc/oraInst.loc9.将oracle用户删除(若要重新安装,可以不删除)[root@redhat6 desktop]# userdel –r oracle10.将用户组删除(若要重新安装,可以不删除)[root@redhat6 desktop]# groupdel oinstall[root@redhat6 desktop]# groupdel dba11.将启动服务删除[root@redhat6 desktop]# chkconfig --del dbora到此为止，Oracle11g就从Linux系统中完全的卸载成功了。

输入dbca，打开图形化界面
选择Custom Database
指定实例名：
指定用户口令：
此处指定是否使用归档（生产环境建议开启归档;测试环境不需要归档，取消勾选。

）
取消不用的插件：
指定SGA的大小（建议为服务器物理内存的40%-60%即可）
Processes建议修改为500-1500（根据并发判断）
修改字符集为：ZHS16GBK
点击下方按钮All Initiallzation Parameters
点击按钮Show Advanced Parameters:
修改db_writer_processes 为2（缺省值为1）
修改open_cursors 为1000（缺省值为300）
点击Close
点击NEXT：
在这里可以修改默认表空间的路径、大小等信息：
Redolog 建议增加为4组，每组500M （缺省3组，每组50M）
点击Finish，
点击OK ，开始创建数据库
经过等待，弹出下列窗口则说明数据库实例创建成功。

Oracle建库步骤一、使用root用户登录系统，并修改oracle用户的密码。

二、用oracle用户借助图形化界面工具登录服务器。

本文档中，使用xmanager工具登录。

三、设置DISPLAY参数。

四、运行dbca命令，开始建库。

五、选择建立一个新库。

六、选择库模板，可以根据自己需要选择。

本文档选择定制数据库模板。

七、输入库名和实例名。

本文档库名和实例名使用test。

八、选择管理方式。

本文档不启用EM管理，也不启用自动维护任务。

九、设置sys和system的密码。

十、选择数据文件位置。

本文档中，数据文件模式选做file system模式，存放位置选择/oradb。

十一、恢复配置。

因暂缺集中备份环境，所以要求大家不要开启归档。

（如果开启归档，归档文件又没有得到及时清理的话，将会占用大量存储空间。

如果文件系统被占满，Oracle数据库将停止服务。

）十二、数据库附带工具选择。

十三、数据库参数选择。

Memory可以按照系统默认选择。

block size关系到数据文件的大小，如果bs选择为4k，则数据文件最大为16G，如果bs选择为8k，则数据文件最大为32G，请大家自行决定。

字符集选择，请大家按照自己的需求选择。

一旦选择，将很难更改，请慎重。

连接模式采用默认即可。

十四、数据库存储。

大家可以先建立库。

库建成后可以手动调整。

十五、建库。

十六、建库过程，时间比较长。

十七、使用命令netca建立监听。

服务器磁盘分配一般C盘100G装系统、D盘80G放ORACLE基目录和软件位置、E盘剩余空间（最大）放数据库目录。

Oracle 11g安装图文攻略注意用administrator用户登录一、Oracle 下载注意Oracle分成两个文件，下载完后，将两个文件解压到同一目录下即可。

路径名称中，最好不要出现中文，也不要出现空格等不规则字符。

二、Oracle安装1. 解压缩文件，将两个压缩包一起选择，鼠标右击- 解压文件如图2.两者解压到相同的一、Oracle 下载注意Oracle分成两个文件，下载完后，将两个文件解压到同一目录下即可。

路径名称中，最好不要出现中文，也不要出现空格等不规则字符。

二、Oracle安装1. 解压缩文件，将两个压缩包一起选择，鼠标右击-> 解压文件如图2.两者解压到相同的路径中，如图：3. 到相应的解压路径上面，找到可执行安装文件【setup.exe 】双击安装。

如图：4. 安装第一步：配置安全更新，这步可将自己的电子邮件地址填写进去（也可以不填写，只是收到一些没什么用的邮件而已）。

取消下面的“我希望通过My Oracle Support接受安全更新(W)”。

如图：5. 安全选项，直接选择默认创建和配置一个数据库(安装完数据库管理软件后，系统会自动创建一个数据库实例)。

如图：6. 系统类，直接选择默认的桌面类就可以了。

(若安装到的电脑是，个人笔记本或个人使用的电脑使用此选项) 服务器类直接点击这里跳转如图：7. 典型安装。

重要步骤。

建议只需要将Oracle基目录更新下，目录路径不要含有中文或其它的特殊字符。

全局数据库名可以默认，且口令密码，必须要牢记。

密码输入时，有提示警告，不符合Oracel建议时不用管。

(因Oracel建议的密码规则比较麻烦，必须是大写字母加小写字母加数字，而且必须是8位以上。

麻烦，可以输入平常自己习惯的短小密码即可) 如图：8. 若输入的口令短小简单，安装时会提示如下。

环境:
系统:WINDOWS 2008 server 服务器安装
双击setup 进入安装服务器端界面
选择高级安装，下一步
选择定制。

默认就行，如果需要改动ORACLE安装地址选择第一个浏览，确定地址，下一步。

下一步
检查通过，就可以下一步。

选择组件，全选。

下一步
创建数据库，下一步
点安装。

安装界面如下图。

默认下一步。

默认下一步
下一步
下一步
点完成。

选择一般用途就行了
输入服务器名，下一步
下一步
选择所有账户同一命令：GDLISNET
下一步
一直下一步到如下
分配内存，尽量大点。

调整大小，进程200~500
字符集选择上图所示，下一步，直到完成都是默认就行。

点完成
客户端安装:
双击setup
进入安装客户端界面
点下一步
如果是管理员安装选择管理员安装,点击下一步开始安装.
如果是普通老师机器上安装,则选择自定义,点下一步开始安装.
检查条件,如果条件不够会报警,下一步, 选择组件:选择如下
选择好组件后下一步开始安装客户端
端口号默认就行
点安装
安装界面如下
安装完成后会自动跳出配置窗口如下
下一步
默认本地命名就行了，下一步
服务器名：我们软件是GDLISNET，下一步
默认下一步
主机名输入服务器IP地址。

下一步
点测试，下一步
连接成功服务器成功，客户端安装完成。