Log pits in the process of installing and using Oracle databases on Windows

1. Install Oracle

Oracle software is free and can be downloaded to the website to download the appropriate installation package. However, if commercial use is required to purchase license. Official online for various platforms, both 32-bit and 64-bit, if Windows is generally downloaded to two files. In Oracle 11g, for example, there are two zip compressed files, note that the contents of the two compressed files are extracted and merged before installation. The installation prompt monitor configuration must display at least 256 colors that can be ignored. Other pre-installation check, may be flash back, for some reason, can only replace the operating system. Note The installation directory may not be a directory name with spaces or special characters, such as C:\Oracle\. Currently I am in the server R2 English version and Sever R2 English version of the normal installation. After installation is complete, the following is visible.

Database control can view and manage databases through a Web page, each database has one, through port-differentiated, URLs such as https://machine name: 1158/em (em should be Enterprise Manager meaning). Note When you install on Windows Server R2, the last time you create the database, you get an error: The Oracle configuration data was uploaded to the repository with errors because the window server, R2, accesses the local machine name over the network and returns the IPV6 address, but the Oracle Enterprise Manager accepts only the IPV4 address, which is the https://machine name, and does not get the IPV4 address. The host file needs to be added:

127.0. 0.1 localhostIPv4 Address machine name

Database Configuration Assistant Create configuration and delete databases.

NET Configuration Assistant network-related configurations, such as listeners.

SQL Developer Development Management tool, install 64-bit Oracle database can not open, prompted not to find the JDK, even if the correct point to the Oracle's own JDK does not, the search results are required 32-bit JDK, temporarily ignored.

SQL Plus command-line tool, familiar with MySQL is quick to get started.

650) this.width=650; "title=" image "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; Float:none; padding-top:0px; padding-left:0px; Margin-left:auto; Display:block; padding-right:0px; border-top-width:0px; Margin-right:auto "border=" 0 "alt=" image "src=" http://s3.51cto.com/wyfs02/M00/8C/61/ Wkiol1hrhmxj5dq7aaauymqmocu311.png "width=" 231 "height=" 384 "/>

Oracle also has an Oracle client, which is not installed on the server and can be installed on other machines that need to connect to the server, and the same management tools will appear after installation.

2.Oracle Backend Service

Each additional database adds an Oracle instance, such as a background process with two database ORCL and wind conditions

650) this.width=650; "title=" image "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; Float:none; padding-top:0px; padding-left:0px; Margin-left:auto; Display:block; padding-right:0px; border-top-width:0px; Margin-right:auto "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/8C/61/wKioL1hrHmah28GVAAA_RZa_ Zcw097.png "width=" 629 "height=" 229 "/>

3. Log in to Oracle

You can use the SQL Plus login test, and if you do not create a dedicated user when you create the database, you can configure it using the SYS or SYSTEM account login. SYS is the highest privilege and cannot be directly logged on using SYS and will flash back. There are several ways to log in to let SYS use an alias login

C:\sqlplusEnter User-name:sysenter Password:yourpassword as Sysdba/nologsql As sysdbaorc:\sqlplus sys/yourpassword as SYSDBA

Log pits in the process of installing and using Oracle databases on Windows