Shulou(Shulou.com)06/01 Report--

1. Install Oracle

Oracle software is free, you can go to the official website to download the corresponding installation package. But if you use it for commercial purposes, you need to buy License. The official website is available for a variety of platforms, both 32-bit and 64-bit. If you download it in Windows, you will usually download two files. Take Oracle 11g as an example, there are two zip compressed files. Note that the contents of the two compressed files are unzipped and merged before installation. Installation Tip Monitor configuration must display at least 256 colors, which can be ignored. Other installation pre-item check, may flash, really do not know why, can only replace the operating system. Note that the installation directory cannot be a directory name with spaces or special characters, such as C:\ Oracle\. I am currently installed in Server 2008 R2 English version and Sever 2012 R2 English version. After the installation is complete, you can see below.

Database Control can view and manage databases through web pages, and each database has one, distinguished by port, such as the https:// machine name: 1158/em (em should mean Enterprise Manager). Note that when installing on Window Server 2008 R2, the final creation of the database will report an error: an error occurred when uploading Oracle configuration data to the data archive because Window Server 2008 R2 will return an IPv6 address when accessing the local machine name over the network, but Oracle Enterprise Manager only accepts the IPv4 address, that is, the https:// machine name, and will not get the IPv4 address. You need to add: to the host file:

127.0.0.1 localhostIPv4 address Machine name

Database Configuration Assistant creates the configuration and deletes the database.

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

SQL Developer development management tools, the installation of 64-bit Oracle Database can not be opened, prompt can not find JDK, even if the correct point to Oracle's own JDK, the search result is 32-bit JDK, temporarily ignored.

SQL Plus command line tools, familiar with MySQL will soon get started.

Oracle also has an Oracle Client, that is, the client, which does not need to be installed on Server. It can be installed on other machines that need to connect to Server. After installation, management tools like those shown above will appear.

2.Oracle backend service

Each additional database adds an Oracle instance. The following figure shows the background process with two databases, ORCL and WIND.

3. Log in to Oracle

You can use the SQL Plus login test, and if you do not create a dedicated user when creating the database, you can use the SYS or SYSTEM account login system to configure. SYS is the highest authority. You can't log in directly using SYS. It will flicker. You can log in in the following ways to let SYS log in using an alias

C:\ sqlplusEnter user-name:sysEnter password: yourpassword as sysdbaorC:\ sqlplus / nologSQL > conn sys/yourpassword as sysdbaorC:\ sqlplus sys/yourpassword as sysdba

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.