Records the pitfalls in installing and using Oracle databases on Windows.

Records the pitfalls in installing and using Oracle databases on Windows.

1. Install Oracle

Oracle software is free of charge. You can download the corresponding installation package from the official website. However, you need to purchase License for commercial purposes. On the official website, there are 32-bit and 64-bit platforms. If you are on Windows, two files will be downloaded. Take Oracle 11g as an example. There are two zip files. Note that before installation, extract and merge the contents of the two compressed files. The installation prompt "monitor configuration must be in at least 256 colors, which can be ignored. Other pre-Installation check items may crash. For some reason, you can only change the operating system. Note that the installation directory cannot be a directory name with spaces or special characters, such as C: \ Oracle \. Currently, I have installed Server 2008 R2 in English and Sever 2012 R2 in English. After the installation is complete, you can see the following.

Database Control allows you to view and manage databases on the web page. Each Database has one, which is differentiated by the port. The URL is https: // machine Name: 1158/em (em should be the meaning of Enterprise Manager ). Note: When Windows Server 2008 R2 is installed, an error occurs when the database is created: an error occurs when the Oracle configuration data is uploaded to the archive, the reason is that Window Server 2008 R2 returns an IPv6 address when accessing the local machine name through the network, but Oracle Enterprise Manager only accepts IPv4 addresses, that is, https: // machine name, and does not obtain IPv4 addresses. Add the following to the host file:

127.0.0.1 localhostIPv4 address machine name

Database Configuration Assistant creates configurations and deletes databases.

Net Configuration Assistant network configurations, such as listeners.

The 64-bit Oracle Database cannot be installed in the SQL Developer development and management tool. The prompt is that the JDK cannot be found, even if it points to the JDK that comes with Oracle correctly. The search result is a 32-bit JDK, which is temporarily ignored.

The SQL Plus command line tool is quick to get started with MySQL.

Oracle also has an Oracle Client, that is, the Server does not need to be installed. you can install it on other machines that need to connect to the Server. After installation, the same management tool will appear.

2. Oracle background services

An Oracle instance is added for each added database. If there are two databases, ORCL and WIND, background processes

3. log on to Oracle

You can use SQL Plus to log on to the test. If no special user is created during database creation, you can use the SYS or SYSTEM account to log on to the SYSTEM for configuration. SYS is the highest permission. If you cannot directly log on to SYS, it will crash. You can use the following methods to log on to SYS using an alias:

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