Windows环境下ORACLE以及ERP的安装和配置--张伟
Windows环境下ORACLE以及ERP的安装和配置
日期：2011/08/16
目录
1 oracle数据库的安装 (4)
1.1 安装oracle数据库 (4)
1.2 创建数据库 (6)
1.3 创建监听程序和NET服务器配置 (11)
1.3.1 创建监听程序 (11)
1.3.2 配置本地NET服务器 (14)
2 PL SQL 的安装 (19)
2.1 安装PL SQL (19)
2.2 PL SQL 的登录 (19)
2.3 创建表空间 (20)
2.4 创建用户脚本 (21)
2.5 以tts用户名登录 (22)
2.6 导入表 (22)
2.7 编译无效对象 (25)
3 jdk的安装以及java环境的配置 (25)
3.1 jdk的安装 (26)
3.2 Java环境变量的配置 (26)
3.3 验证java安装已经环境变量的设置 (27)
4 安装jboss (27)
4.1 jboss的部署 (27)
4.2 jboss环境变量的设置 (30)
1 oracle数据库的安装
1.1 安装oracle数据库
此图乃是安装oracle的截图，在安装界面上有一默认创建启动数据库选项，勾去不选，等oracle安装完成后自己创建数据库。
1.2 创建数据库
Oracle软件安装完成之后，在“cmd”命令下输入“dbca”创建数据库。
直接点击下一步。
在此安装界面下，选择“创建数据库”选项，然后点击下一步。
在此界面下选择“一般用途”选项，然后点击下一步。
在此界面下设置全局数据库名和SID，然后点击下一步。
在此界面下设置账户使用的口令，点击下一步。
下一步。
数据库正在安装，直至完成。
1.3 创建监听程序和NET服务器配置
1.3.1 创建监听程序
在dos界面下，输入“netca”命令，创建监听程序和设置net服务器。
在此界面下选择“监听程序配置”选项，然后点击下一步。
此界面是设置监听程序的名字，选择默认。
此程序是设置标准端口号1521，选择默认。
至此监听程序创建完成。
1.3.2 配置本地NET服务器
设置本机的ip地址
在此界面下选择“本地NET服务名配置”，然后点击下一步。
在此界面下选择“添加”，然后点击下一步。
在此界面下设置服务名为“”，然后点击下一步。
设置主机名为本机ip地址192.168.42.110，标准端口为1521，点击下一步
测试服务名配置，更改登录口令，口令为“tts0001”
测试成功后点击下一步。
设置网络服务名，点击下一步。
至此net服务名配置完成。
2 PL SQL 的安装2.1 安装PL SQL
2.2 PL SQL 的登录
第一次登录使用system用户名登录。
2.3 创建表空间
登录成功后，创建表空间，创建的语句为：
CREATE SMALLFILE TABLESPACE "TTSDB" DATAFILE
'E:/oracle/product/10.2.0/oradata/zw/TTSDB'SIZE400M AUTOEXTEND ON NEXT10M
MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
2.4 创建用户脚本
创建用户脚本，创建的语句为：
-- Create the user
create user TTS
identified by "tts0001"
default tablespace TTSDB
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to TTS with admin option;
grant dba to TTS with admin option;
grant resource to TTS with admin option;
-- Grant/Revoke system privileges
grant unlimited tablespace to TTS with admin option;
2.5 以tts用户名登录
表空间和用户脚本创建成功后，以tts 用户名登录。
2.6 导入表
登录之后开始导入表。
继续导入表。
2.7 编译无效对象
表导入完成之后，编译无效对象，创建视图。
至此，安装全部完成。
3 jdk的安装以及java环境的配置
3.1 jdk的安装
此图是安装jdk软件
3.2 Java环境变量的配置
Jdk软件安装成功后需要设置环境变量，图中所示是jdk环境变量的设置。
图中所示是jdk环境变量设置下的path设置。
3.3 验证java安装已经环境变量的设置
Jdk 安装完成以及环境变量设置完成后，在运行下输入“cmd”命令，然后输入“cd %java_home”验证jdk安装以及环境变量设置是否正确，若如图所示，即表示安装正确，可以使用了。
4 安装jboss
4.1 jboss的部署
在“服务器环境”文件夹下，找到文件名为ds-center和ds-local的两个文件，把这两个文件拷贝到“\JBOSS\jboss-4.0.5.GA-dz\bin”这条路径的bin文件夹下，然后分别打开这两个文件，修改配置，配置如上两图所示；此外，服务器环境文件夹下的config文件也一并复制到这个bin文件夹下覆盖bin文件夹下的config文件；
修改服务器环境下的tts-ds这个文件，修改内容如图上所示，然后再将tts-ds文件和tts-platform文件一并拷贝到“\JBOSS\jboss-4.0.5.GA-dz\server\default\deploy”这条路径下的deploy文件夹之下；
将服务器环境文件夹下的ChkTkSessionBean，HeadQuerySBean，ReportSchSBean，ScheduledPlanSBean，这四个文件拷贝到“\JBOSS\jboss-4.0.5.GA-dz\server\default\deploy”这条路径下的deploy文件夹之下；
4.2 jboss环境变量的设置
设置jboss环境变量。
Oracle 11g for Windows的安装与配置
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数据库，可以单击【基本安装】单选按钮，再输入数据库登录密码，然后单击【下一步】按钮开始基本安装。
Windows下oracle客户端安装使用方法
Windows下oracle客户端安装使用方法1. 下载完整的oracle客户端（不是oracle instantclient）并安装（1）在windows下ORACLE_HOME环境变量是通过注册表设置的，其值指向oracle客户端所在的目录。
在安装oracle客户端时，要确保ORACLE_HOME未被设置set ORACLE_HOME=（2）自定义安装时一般要选上database utiltites、oci、sqlplus等选项（3）win7下，oracle在注册表中的位置为HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE，内容如下：[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE]"inst_loc"="C:\\Program Files (x86)\\Oracle\\Inventory"[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient10g_home1]"ORACLE_HOME"="D:\\oracle10.2.0.1""ORACLE_HOME_NAME"="OraClient10g_home1""ORACLE_GROUP_NAME"="Oracle - OraClient10g_home1""ORACLE_BUNDLE_NAME"="Enterprise""NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK""StatementCacheSize"="0""SQLPATH"="D:\\oracle10.2.0.1\\dbs""MSHELP_TOOLS"="D:\\oracle10.2.0.1\\MSHELP"[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient10g_home1\]"TraceFileName"="C:\\ODPNET.trc""TraceLevel"="0""TraceOption"="0""StatementCacheSize"="0"2. tnsnames.ora 设置正确才能使用TNS进行连接， tnsnames.ora 文件放置在%ORACLE_HOME%/network/admin，文件内容大致如下：ORCL =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.1)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = test)))3. 客户端的使用问题（1）我在win7下安装10.2.0.1客户端后，运行sqlplus会出现以下错误：SP2-1503: 无法初始化Oracle 调用界面SP2-0152: ORACLE 不能正常工作以管理员方式运行sqlplus这个问题就解决了。
windows环境下配置连接oracle数据库的方法及步骤
配置oracle连接怎么在windows环境下配置连接oracle数据库？步骤如下：一、安装PL/SQL：1、获取PL/SQL安装包；（PL/SQL是连接oracle的客户端）2、安装PL/SQL；（1）双击PL/SQL安装程序，安装PL/SQL；（2）选择“I Agree”进行安装；（3）选择安装路径（一般选择默认路径）；点击【Next】按钮；（4）默认选择，点击【Next】按钮；（5）默认选择，点击【Finish】按钮，开始安装；（6）安装进度显示（7）窗口提示“PL/SQL Developer installed successfully”，安装完成，点击【Close】按钮。
二、配置连接1、获取oci.dll文件（该文件是用来连接数据库的文件），将该文件及其所在的文件夹放置在一个不含有中文的路径下（如：F:\instantclient）;2、双击打开PL/SQL客户端，点击【Cancel】按钮;3、跳转到PL/SQL页面，如下图所示。
选择【Tool】—>Preferences;4、按下图进行选择，在“Oracle Home（enpty is autodetect）”栏中选择oci.dll文件所在的目录；在“OCI library(enpty is autodetect)”栏中选择oci.dll文件5、点击【OK】按钮即可完成6、退出PL/SQL页面，重新登录。
双击PL/SQL客户端，在Oracle Logon窗口中填写数据库的用户名、密码、数据库名和连接方式；点击【OK】按钮即可查询数据库。
完毕！谢谢！附：配置环境变量（1）Path：访问配置文件的路径。
如：配置文件存放目录为：D:\PL SQL\instantclient;Path: D:\PL SQL\instantclient;（2）TNS_ADMIN：配置连接文件“tnsnames.ora”和监听文件“listener.ora”的存放路径。
Oracle+erp+安装详解(含图片)
Start Rapidwiz必须从命令行运行startCD\Disk1\rapidwiz下的rapidwiz，启动安装程序。
注意：安装文件的路径也不能有空格。
Welcome Informaiton出来欢迎界面。
Select Wizard Operation选择安装模式，初次安装请选择“Install Oracle Application E-Business 11i”，下面的“Use Express Configuration”不要选，这样我们可以自己配制安装选项，了解安装任务。
Load Configuration第一次运行Rapidwiz，没有安装配置文件，所以要选择No，以后再启动Rapidwiz，就可以选择以前保存的安装配置文件。
Install Type选择Single-node (All Services on a single node)，所有服务都装在一台机器上。
如果选择Multi-node，那么可以选择数据库和Concurrent Manager装在一台机器上，HTTP/FORM/REPROT服务和Application装在另一台机器上。
Define Database Type选择Vision Demo的话会装一个演示环境，需要90G的空间。
选择Fresh Database，会安装一个空的数据库，所有模块的设置都需要从头进行。
Database Install Information选择数据库安装目录。
选择Advance，可以把DB Oracle Home/SYS数据文件/LOG文件/Transaction数据文件/归档文件装在不同的磁盘上。
这里没有提供控制文件的安装路径选择，只好待安装完之后，再来移动控制文件。
Select Licensing Type这里的License选择，仅仅代表你买了什么产品，并不会影响功能模块的使用。
安装完之后也可以通过OAM来添加License。
E-Business Suite Licensing模式默认选择了一些常用的模块。
Windows环境下ORACLE以及ERP的安装和配置--张伟
Windows环境下ORACLE以及ERP的安装和配置日期：2011/08/16目录1 oracle数据库的安装 (4)1.1 安装oracle数据库 (4)1.2 创建数据库 (6)1.3 创建监听程序和NET服务器配置 (11)1.3.1 创建监听程序 (11)1.3.2 配置本地NET服务器 (14)2 PL SQL 的安装 (19)2.1 安装PL SQL (19)2.2 PL SQL 的登录 (19)2.3 创建表空间 (20)2.4 创建用户脚本 (21)2.5 以tts用户名登录 (22)2.6 导入表 (22)2.7 编译无效对象 (25)3 jdk的安装以及java环境的配置 (25)3.1 jdk的安装 (26)3.2 Java环境变量的配置 (26)3.3 验证java安装已经环境变量的设置 (27)4 安装jboss (27)4.1 jboss的部署 (27)4.2 jboss环境变量的设置 (30)1 oracle数据库的安装1.1 安装oracle数据库此图乃是安装oracle的截图，在安装界面上有一默认创建启动数据库选项，勾去不选，等oracle安装完成后自己创建数据库。
1.2 创建数据库Oracle软件安装完成之后，在“cmd”命令下输入“dbca”创建数据库。
直接点击下一步。
在此安装界面下，选择“创建数据库”选项，然后点击下一步。
在此界面下选择“一般用途”选项，然后点击下一步。
在此界面下设置全局数据库名和SID，然后点击下一步。
在此界面下设置账户使用的口令，点击下一步。
下一步。
数据库正在安装，直至完成。
1.3 创建监听程序和NET服务器配置1.3.1 创建监听程序在dos界面下，输入“netca”命令，创建监听程序和设置net服务器。
在此界面下选择“监听程序配置”选项，然后点击下一步。
此界面是设置监听程序的名字，选择默认。
此程序是设置标准端口号1521，选择默认。
windows下怎样安装和链接oracle数据库
windows下怎样安装和链接oracle数据库Oracle数据库系统是目前世界上最流行的关系型数据库管理系统，其系统可移植性好、使用方便、功能强大，是一种高效率、可靠性好的数据库解决方案。
下面是店铺收集整理的windows下怎样安装和链接oracle数据库，希望对大家有帮助~~windows下怎样安装和链接oracle数据库工具/原料windows系统oracle数据库方法/步骤在oracle官网上下载oracle数据库，以Oracle Database 11g Release 2版本的oracle数据库为例，其他版本的安装也大同小异。
注意，下载前得Accept License Agreement.下载并解压文件，找到setup.exe，双击进行安装。
与一般软件安装一样，一路next，接收许可协议中的条款，注意可以自定义安装路径。
安装过程中需要设置管理员用户sys/system的口令密码(记住这个密码)，通过管理员用户可以创建普通用户，输入密码后继续安装，这里要注意oracle数据库的监听器程序端口是1521。
安装成功后，每当windows启动的时候，oracle服务器跟监听器就会自动启动，不常用数据库时，可以将oracle服务设置为手动启动模式。
设置方法为右击计算机进入管理系统，进入服务和应用程序中的服务界面，找到oracle数据库的四个服务器，其中有两个正在运行，先停止这两个服务器，然后在属性中的启动类型中设置成手动模式。
通过SQL命令链接数据库：在开始菜单中的所有应用中找到oracle database,进入运行SQL命令行，在SQL命令行中输入conn system，会提示你输入口令，输入在安装过程中设置的口令即可链接成功。
通过windows自带的命令行链接数据库：找到运行(win+R),输入cmd进入cmd命令输入界面，输入sqlplus，然后输入管理员用户名(system)和口令密码即可链接成功。
Oracle数据库学习（1）Windows环境下安装Oracle
Oracle数据库学习（1）Windows环境下安装Oracle概述：Oracle数据库是⼀种⽹络上的数据库, 它在⽹络上⽀持多⽤户, ⽀持服务器/客户机等部署(或配置)。
服务器与客户机是软件概念：它们与计算机硬件不存在⼀⼀对应的关系. 即:同⼀台计算机既可以充当服务器⼜可以充当客户机,或者⼀台计算机只充当服务器或只充当充当客户机Oracle的体系结构：平常所说的Oracle或Oracle数据库指的是Oracle数据库管理系统。
Oracle数据库管理系统是管理数据库访问的计算机软件(Oracle database manager system). 它由Oracle数据库和 Oracle实例(instance)构成.（1）Oracle 数据库: ⼀个相关的操作系统⽂件(即存储在计算机硬盘上的⽂件)集合,这些⽂件组织在⼀起, 成为⼀个逻辑整体, 即为 Oracle 数据库.Oracle ⽤它来存储和管理相关的信息.Oracle数据库必须要与内存⾥实例合作，才能对外提供数据管理服务。
（2）Oracle 实例: 位于物理内存⾥的数据结构，它由操作系统的多个后台进程和⼀个共享的内存池所组成,共享的内存池可以被所有进程访问.Oracle ⽤它们来管理数据库访问.⽤户如果要存取数据库(也就是硬盘上的⽂件) ⾥的数据, 必须通过Oracle实例才能实现, 不能直接读取硬盘上的⽂件.实际上,Oracle 实例就是平常所说的数据库服务(service) .Oracle数据库与Oracle实例的区别：实例可以操作数据库；在任何时刻⼀个实例只能与⼀个数据库关联，访问⼀个数据库；⽽同⼀个数据库可由多个实例访问（RAC）（3）Oracle数据库与其他数据库的基本区分：oracle:⼤型数据库管理系统mysql：中⼩型DB2：中⼩型Acess：⼩型Sql Server：⼤型数据库⼀：Oracle服务器端的安装：本⼈介绍安装的是Oracle 11g版本，下载地址：安装要求：安装步骤：1、下载完后，将压缩包解压到没有中⽂的路径下，如本⽂解压到D:\oracle_database路径下2、以管理员⽅式运⾏setup.exe⽂件下⼀步可能会出现INS-13001的提⽰，这是因为版本注册的问题。
微软Web应用程序服务器在Oracle计算云服务上的部署和配置说明书
Deploying Microsoft Web Application Server on Oracle Compute Cloud ServiceSetup and ConfigurationO R A C L E W H I T E P A P E R|A U G U S T2016Table of ContentsIntroduction 1 Creating an Oracle Compute Windows Instance 1 Connecting to the Oracle Cloud: Remote Desktop and Network Configuration 2 Oracle Database Cloud Service Connection Information 2 Installing Microsoft Internet Information Services 3 Web Deployment 3 Enable Server Roles 3 3 IIS Management Service 4 Web Deployment Tool Installation 4 Configure Web Deploy for a Non-Administrator 6 Command Line Web Deploy Configuration 6 IIS Manager Web Deploy Configuration 7 Creating and Deploying a Web Application 9 Creating a Website Application 9 Add to the Website Application 9 Configuring DataSource Entry in web.config 9 Database Connection 10 Deploy Website Application 10 Connect to the Website Hosted on Oracle Compute 12 Conclusion 12IntroductionThe Oracle Compute Cloud Service is Infrastructure as a Service (IaaS) that can run any workload in the cloud. That includes Microsoft .NET and Internet Information Services (IIS) web applications, as well as Java and open source technologies. These options provide organizations flexibility and choice when moving new and existing applications to the cloud.Organizations have complete control over the deployment and configuration of their legacy and modern .NET and IIS applications within Oracle Compute Cloud Service. This paper describes how to install and configure IIS and Oracle Data Provider for .NET () on a Oracle Compute Cloud Service, then connect to an Oracle Database Cloud Service. It will demonstrate the following technologies and steps:» Creating an Oracle Compute Windows Instance. This section describes how to create a Windows Server instance in the Oracle Compute Cloud Service.» Remote Desktop and Network Configuration. This section describes how to configure Oracle Compute Cloud Service for Remote Desktop access and network access to the Windows instance. » Oracle Database Cloud Service connection information. This section describes how to obtain Oracle Database Cloud Service connection information.» Microsoft Internet Information Services. This section describes the steps needed to install and configure IIS on the Oracle Compute Cloud Service. The steps are needed only if IIS will host web applications.» Web Deployment. This section describes how to enable Web Deployment on your Oracle Compute Cloud Service. The steps are needed only if Web Deploy will be used when deploying IIS-based applications to the Oracle Compute Cloud Service.» Creating and deploying a Web application. This section describes how to create and deploy a simple web application to the Oracle Compute Cloud Service from Microsoft Visual Studio. This section is useful for those who are not familiar with Web Deploy and want to use it to deploy to the Oracle Cloud.Oracle Compute Cloud Service currently supports Windows Server 2012 R2 and Windows Server 2008 R2. This white paper will use Windows Server 2012 R2 in its demonstration steps.Creating an Oracle Compute Windows InstanceThis section guides how to create an Oracle Compute Windows instance. Microsoft Windows Server images are available from the Oracle Cloud Marketplace for use within Oracle Compute.1. Sign in to Oracle Cloud Marketplace. Search for “Microsoft Windows Server 2012 R2” and select thatWindows image.2. Think of a strong password for the Windows Administrator of your instance and keep the password handy.Ensure that the password meets the Windows password complexity requirements.3. Click Get App button and follow the process to create an instance using the web console.The remaining steps are the same as creating a generic instance for Oracle Compute from the Oracle Cloud Marketplace. If you’re unfamiliar with those steps, this Oracle Compute Cloud (IaaS) documentation page will guide you.When this Compute service is created, remember the Administrator password. This password will be needed when logging in through Microsoft Remote Desktop. Once you have completed creating the Compute instance, proceed to the next section.Connecting to the Oracle Cloud: Remote Desktop and Network ConfigurationThis section describes how to enable Microsoft Remote Desktop Protocol (RDP) access and configure the Windows instance network access. These steps allow you to connect to the Windows cloud instance directly to setup and administer the IIS web server, deploy applications to the instance, and permit your end users to access the application.Port 3389 should be configured to allow RDP access. Port 80, 443, and 8172 should be configured for HTTP, HTTPS, and msdeploy (Web Deploy) access, respectively. The network ports can be configured in the Oracle Public Cloud management portal.1. Login to the Oracle Cloud My Services dashboard.2. Navigate to the Compute section and click on the Open Service Console button.3. Select the Network tab in the Service Console for the Oracle Compute Cloud Service.4. Click on the Security Applications menu item to create the following security application:a. rdp for tcp protocol and port 3389b. http for tcp protocol and port 80c. https for tcp protocol and port 443d. msdeploy for tcp protocol and port 81725. Click on the Security Lists menu item to create a security list for the instance. Specify DENY for theinbound policy and PERMIT for the outbound policy.6. Click on the Security IP Lists menu item to create a security IP list if necessary.7. Click on the Security Rules menu item to create security rules from the security IP list (public-internet) tothe just created security list for http, https, rdp, and msdeploy.8. To associate the security list with the newly created Oracle machine instance:a. Click on Instances in the Oracle Compute menu.b. Find the machine instance you plan to configure and click on the hamburger button to its right.Choose View from the expanded list.c. Under Security Lists, click the Add to Security List button. Choose the security list you justcreated and click the Add button.d. Delete the default security list by clicking on its hamburger menu to its left and choosing Removefrom Security List.Oracle Database Cloud Service Connection InformationThe Oracle Database Cloud Service connection information can be determined from the Oracle Public Cloud portal. This tutorial assumes you have already created a database cloud service.1. Navigate to the Oracle Database Cloud Service section of the Oracle Public Cloud portal.2. Click Service Console for the Oracle Database Cloud Service.3. Select the service instance to which you want to connect. Where it says Additional Information, selectShow More.4. Look at Connect String, which uses the following format: <hostname>:<port>/<service_name>You may need the fully-qualified hostname. Alternatively, you can use the IP address instead. To determine this information:1. Select the Service Console for the Oracle Compute Cloud Service.2. Select View for the instance for the database service from the hamburger menu.3. Look at DNS Name for the fully-qualified hostname of the database service or Public IP Address for its IPaddress.Installing Microsoft Internet Information ServicesThis section describes how to install Microsoft IIS, which is required for hosting web content. IIS installation and eventual setup requires using the just configured RDP connection.1. Open Microsoft Remote Desktop from the Windows client.2. Enter the Oracle Compute Cloud Service’s public IP into the Computer field.3. Enter the user name: Administrator4. Enter the password. The password was provided during the instance creation process.5. Click Ok.6. The IIS Web Server role, Web Server (IIS), can be enabled by using the graphical Server Manager orcommand line.a. The graphical Server manager installation instructions are available here.b. Alternatively, execute the Deployment Image Servicing and Management (DISM.exe) present onthe machine from the command line using:DISM.EXE /enable-feature /online /featureName:IIS-WebServerRole/featureName:IIS-WebServer7. Verify the Web Server (IIS) is running once done enabling it.Web DeploymentThis section describes the steps required to deploy a web application to Oracle Compute Windows instance. Enable Server RolesEnable following server roles:» » Management Service is required for running -based managed web applications. It can be installed by selecting this option under Application Development on the Web Server Role (IIS) Role Services page in Server Manager.Alternatively, this task can be performed from the command line by executing the following:DISM.EXE /enable-feature /all /online /featureName:IIS-ASPNET45In this command, 4.5 is installed.IIS Management ServiceThe IIS Management Service is required for remotely managing the web server and remotely deploying and administrating web applications. It can be installed by selecting the option under Management Tools on the Web Server Role (IIS) → Role Services page in Server Manager.Alternatively, this task can be performed from the command line by executing:DISM.EXE /enable-feature /all /online /featureName:IIS-ManagementServiceWeb Deployment Tool InstallationWeb Deploy can be used to migrate, manage and deploy IIS Web Servers, Web applications and Websites.Installing IIS Deployment Handler feature in the Web Deployment Tool allows integration with Web Management Service and allows users to perform remote operations.Download the Web Deployment Tool from the Microsoft Web Deploy download page to the Oracle Compute instance. Oracle recommends using the 64-bit version.You will have to adjust the browser security settings if you download this file from the internet.1. Go to Internet Explorer.2. Choose Internet Options from Tools in the menu bar.3. Click on the Security tab.4. Click on the Internet icon.5. Click on the Custom Level button.6. Scroll down to the Downloads→File Download setting and select Enable.7. Click Ok twice to exit.Web Deploy can be installed from the command line in silent mode using the command:msiexec /i WebDeploy_amd64_en-US.msi ADDLOCAL=ALL LicenseAccepted="0" /qnNote: The command will return immediately, but the Windows Installer process may still be running and the installation may take a few minutes to complete.You may execute the below command instead to display a progress bar to indicate the installation status.msiexec /i WebDeploy_amd64_en-US.msi ADDLOCAL=ALL LicenseAccepted="0" /passiveAlternatively, the GUI installer can be used by running the MSI file that was downloaded.1. Double click the MSI file to begin installation.2. Click the Next button.3. Accept the license agreement and click on the Next button.4. Choose Setup Type Complete so that IIS Deployment Handler will also be installed. Or choose CustomSetup Type and select the IIS Deployment Handler feature.5. Click on Install button to begin installationConfigure Web Deploy for a Non-AdministratorWhen a web application is published from Visual Studio using Web Deploy, a username and password need to be specified. The user will be authenticated by Web Deploy on IIS, and that user must have the privileges to deploy the web application. First, a Windows user needs to be created on the IIS. Then, IIS Manager can be used to authorize that Windows user. This step can be configured from either command line or IIS Manager:Command Line Web Deploy ConfigurationExecute SetupSiteForPublish.ps1 as documented by Microsoft for automating Web Deploy setup.For exampl e, let’s publish for a Windows user named Oracle on the existing website, Default Web Site, and save the publish settings file Oracle_Default Web Site.PublishSettings onto the Windows Administrator Desktop. From the PowerShell command window, execute SetupSiteForPublish.ps1 from '%programfiles%\IIS\Microsoft Web Deploy v3\Scripts'" directory as below:.\SetupSiteForPublish.ps1 -siteName "Default Web Site" -deploymentUserName Oracle -publishSettingSavePath C:\Users\Administrator\Desktop -publishSettingFileName "Oracle_Default Web Site.PublishSettings"Note: The Oracle_Default Web Site.PublishSettings file will contain the deployment user name’s password.IIS Manager Web Deploy Configuration1. In IIS Manager, select Default Web Site, and double-click on IIS Manager Permissions.2. In the Actions pane, click Allow User.In the Allow User dialog box, with Windows selected, click Select, and select a Windows user. Then, click on OK.3. In IIS Manager, right-click Default Web Site, and from the Deploy sub-menu, select Configure WebDeploy Publishing. If you don’t see the Deploy sub-menu, exit out of IIS Manager and reopen it.Click the down arrow for Select a user to give publishing permissions, and select the Windows user to authorize, such as Oracle. Then, click Setup.4. The Windows user will be authorized to deploy a web application using Web Deploy.A PublishSettings file will also be generated. This file can be copied to the client where Visual Studio is,then imported by the Publish Web wizard. It then needs to be configured.a. The web application name will need to be appended to the site name and the destination URL.b. The machine name will need to be replaced with the IP address or DNS name of the OracleCompute instance.c. The password needs to be entered in the Publish Web wizard.Creating and Deploying a Web ApplicationThis section describes the steps to create and deploy an application that uses from on-premises to Oracle Compute Windows instance.Creating a Website ApplicationCreate an website application using the following steps:1. Open Visual Studio 2015.2. Click File→New→Project.3. In the left pane under Templates→Visual C#, select Web. In the center pane select WebApplication. Provide a name and location for the project. Select an appropriate target .NET Frameworkversion from the dropdown at the top of the dialog. .NET Framework 4.0, 4.5, 4.5.1 is included in Windows 2012 R2. .NET Framework 4.5.2 and higher are not included by default, but can be downloaded from theMicrosoft website. Click on OK.4. In the New Project screen, select Empty as a template. Click on OK.5. In the Solution Explorer, right click the project and select Add→New Item6. In the Add New Item dialog, select Visual C# → Web in the left pane. Select Web Form in the middlepane. Select an appropriate name, for example, default.aspx. Click on Add.Note: If you choose an unconventional name for the default page, such as WebForm1.aspx, then add this name to the Default Document list in IIS Manager on the web server.7. Right click on default.aspx under the project and select Set as Start Page.Add to the Website ApplicationAdd , Managed Driver to the application so that data access can occur between the middle tier and database server. These steps will outline installation using NuGet package management.1. Un-GAC and un-configure any existing managed assembly (i.e.Oracle.ManagedDataAccess.dll) and policy DLL (i.e. Policy.4.121.Oracle.ManagedDataAccess.dll)with the same main major version numbers that exist in the GAC. For example, if you plan to use managed version 12.1.0.2 in your Oracle Compute application, remove all managed 12.1.0.2references from the GAC.2. Remove all Oracle.ManagedDataAccess references from the machine.config file, if any exist.3. Right click the existing Website project and select Manage NuGet Packages.4. Select as the package source.5. In the Search box, search for the package with id, Oracle.ManagedDataAccess. Verify that the packageuses this unique ID to ensure it is the official Oracle Data Provider for .NET, Managed Driver.6. Select the package and click on the Install button.7. Accept the license agreement and Visual Studio will continue the setup.Configuring DataSource Entry in web.configThe web application’s web.config file needs to be configured properly with a <dataSource> entry to connect to the Oracle Database Cloud Service.The connection information for Oracle Database Cloud Service can be determined from the Oracle Public Cloud portal. The instructions to determine this information was included earlier in the Oracle Database Cloud Service Connection Information section of this white paper.The NuGet package installation creates a <dataSource> entry for the SampleDataSource alias in the web.config, such as what you see below.<dataSources><dataSource alias="SampleDataSource"descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host_name>)(PORT=<port>))(CONNECT_DATA=(SERVIC E_NAME=<service_name>))) "/></dataSources>Modify the <host_name>, <port>, and <service_name> placeholders for the SampleDataSource alias with the values of the connection string that was obtained from the Oracle Public Cloud portal. You can also change the SampleDataSource name to something more relevant for your application. Database ConnectionThe following steps allow the website application to use to connect to the database service:1. Add a button control to the default.aspx web form in the project. Set the button text in its property page toOpen Connection.2. Add a Label control to default.aspx and set its text to Connection State.3. Add a text box to default.aspx.4. In default.aspx.cs, in the section of using directives at the top of the file, add usingOracle.ManagedDataAccess.Client to use managed namespace.5. Double click on the button and add the below code.// C# -- Specify appropriate user id, password, and data source belowstring constr = "user id=<user id>;password=<password>;data source=<SampleDataSource>";try{OracleConnection con = new OracleConnection(constr);con.Open();TextBox1.Text = con.State.ToString();}catch (Exception ex){TextBox1.Text = ex.Message;}Deploy Website Application1. In the website project in Visual Studio 2015, click on Build Publish <Project Name>.2. In the Publish Web dialog, for Profile, select Import for the publish target.3. In the Import Publish Settings dialog, specify the PublishSettings file that was created in the ConfigureWeb Deploy for a Non-Administrator section of this white paper. You may have already copied this file from the Oracle Compute instance to your local development machine. Click OK.4. In the Publish Web dialog, for Connection, specify the below values and click the Publish button:a. Publish Method: Web Deployb. Server: The virtual machine instance IP address or DNS name needs to be specified, replacingthe value from the PublishSettings file. This is the same IP address as you used to connect tothe machine via Microsoft Remote Desktop. Use the full URL to the server, including the formatfor Web Deploy, such as https://<IPaddress>:8172/msdeploy.axdc. Site Name: The web application needs to be appended to the web site name, replacing thevalue from the PublishSettings file.d. User Name: Use the user name from the PublishSettings file. This is the user that wasauthorized when configuring Web Deploy for a non-administrator.e. Password: Specify the password for the user name.f. Destination URL: The virtual machine instance IP address or DNS name needs to be specified,replacing the value from the PublishSettings file using the format http://<IP address>/<SiteName>.Connect to the Website Hosted on Oracle ComputeWith the website published to Oracle Compute instance, you can now connect to it by opening a browser and specifying:http://<IP or machine name>/<Site Name>For example,http://123.123.123.123/WebApplication1This will load default.aspx, which is the startup page. Click the Open Connection button and check the connection status in the text box. You should be able to successfully connect from your browser to your Oracle Compute Windows instance running IIS to your Oracle Database Cloud Service.ConclusionThis white paper demonstrated how to setup Microsoft Windows, .NET, and IIS in the Oracle Public Cloud (IaaS). Through the Oracle Cloud Marketplace, you created an Oracle Compute Windows instance, then installed and set up IIS and .NET on the machine. You then created an application and deployed it to Oracle Compute. The application connected to an Oracle Database Cloud Service. Finally, you were able to use the web application by connecting to the website hosted on Oracle Compute.Oracle Corporation, World Headquarters Worldwide Inquiries 500 Oracle Parkway Phone: +1.650.506.7000 Redwood Shores, CA 94065, USA Fax: +1.650.506.7200Copyright © 2016, 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.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. 0116Deploying Microsoft Web Application Server on Oracle Compute Cloud ServiceAugust 2016Authors: Steven Caminez, Alex Keh, Ashish ShahContributing Authors: Riaz Ahmed, Nari AkiyamaC O N N E C T W I T H U S /windows /dotnet /oracledotnet/oracledotnetteam。
Window下Oracle安装图文教程
Window下Oracle安装图⽂教程⼀、Oracle下载地址
⼆、解压⽂件
1、解压这两份⽂件，解压到当前⽂件夹
2、多出⼀个database⽂件夹
3、进⼊database⽂件夹，双击setup.exe
就会弹出⼀个窗⼝，等待⼀下
三、安装步骤
1、电⼦邮箱可以不填写，去掉接收安全更新的勾，点击下⼀步
点击是
2、选择仅安装数据库软件，下⼀步
3、选择单实例数据库安装，下⼀步
4、选择语⾔，下⼀步
5、选择企业版，下⼀步
6、创建⼀个新的window⽤户，下⼀步
7、选择安装路径，⽂件名oracle_base，最好不要⽤有中⽂的路径
8、等待安装完成后，下⼀步
提⽰：如果安装时出现下⾯这个错误的话
查看下安装路径，和JDK的环境变量中是否存在中⽂，将中⽂去掉就可以了
9、完成
四、配置环境变量
ORACLE_BASE=D:\oracle_base
ORACLE_HOME=D:\oracle_base\product\12.1.0\dbhome_1
ORACLE_SID=ORCL
五、创建数据库
win+R输⼊dbca
提⽰：
1、数据库名称建议使⽤ORCL(类似Java中驼峰式命名变量，只是⼀种习惯)
2、数据库字符集应改为utf-8
3、不选择创建容器数据库
接下来就等待创建
总结：在安装过程若出现问题⾸先检查是否使⽤管理员⾝份操作。
更多精彩内容，请点击，进⾏深⼊学习和研究。
以上就是本⽂的全部内容，希望对⼤家的学习有所帮助，也希望⼤家多多⽀持。
Windows10x64安装、配置Oracle11g过程记录（图文教程）
Windows10x64安装、配置Oracle11g过程记录（图⽂教程）备注：本想在⾃⼰电脑上安装个oracle练习⽤，但是害怕安装过程中出现问题，⽽oracle的卸载⼜是出了名的⿇烦，所以⽤虚拟机搭建了⼀个跟本机⼀样的系统，同时记录下安装的每⼀步。
环境：windows10系统最好先安装jre或jdk（此软件⽤来打开oracle⾃带的可视化操作界⾯，不装也没关系；可以安装plsql，或者直接⽤命令⾏操作）1、oracle下载2、oracle安装a.将下载的两个压缩包解压到同⼀⽂件夹下，点击解压⽂件中的setup.exe开始安装b.安装共分10个步骤。
第⼀步，取消安全更新的勾选，点击“下⼀步”c.选择“仅安装数据库软件”，点击“下⼀步”d.选择“单实例数据库安装”，点击“下⼀步”e.默认选择，点击“下⼀步”f.选择“企业版”，点击“下⼀步”g.此处选择oracle的安装⽬录，（就是软件在电脑中的位置），点击“下⼀步”h.这⾥是你之前7个步骤选择的总结，可以在这⾥检查之前的选择是否错误。
确认⽆误后，点击“下⼀步”i.下⾯就是漫长的等待安装过程了。
j.安装完成，点击“关闭”3、oracle数据库配置oracle软件安装完成后，需要先配置⼀个数据库，以便使⽤。
oracle数据库的配置步骤较多，但是⼤部分都是默认，下⼀步，所以并不⿇烦。
a.打开windows开始菜单，找到oracle安装软件中的“Database Configuration Assistant”，点击打开，点击“下⼀步”b.选择“创建数据库”，点击“下⼀步”c.默认选择，点击“下⼀步”d.输⼊全局数据库名（即数据库的名字），SID默认创建，点击“下⼀步”e.取消“配置Enterprise Manager"勾选，点击“下⼀步”f.选择”所有账户使⽤同⼀管理⼝令“，输⼊⼝令（即数据库⽤户sys,system的密码。
oracle数据库有很多⽤户，sys、system是数据库的管理员，权限最⼤）g.不做修改，点击“下⼀步”h.不做修改，点击“下⼀步”i.选择”⽰例⽅案"(会默认创建⼏张表），点击“下⼀步”j.不做修改，点击“下⼀步”k.点击“下⼀步”l.不做修改，点击“完成”m.确认配置信息是否正确，点击“确定“n.进⾏安装，漫长的等待o.安装完成后，弹出下图页⾯，点击”⼝令管理“，进⼊⽤户管理页⾯p.，找到下图SCOTT⽤户，取消”锁定账户“，输⼊”新⼝令“和“确认⼝令”，点击“确认”，完成数据库的配置这样，数据库就能⽤sys、system、scott三个⽤户登陆了4、oracle监听器配置配置完数据库还需要配置监听，⽅便以后的使⽤。