About some problems encountered when installing and using Oracle database on Windows

1.InstallationOracle

Oracle software is free, you can go to the official website to download the corresponding installation package. However, if you use it for commercial purposes, you need to purchase a License. The official website targets various platforms, both 32-bit and 64-bit. If you are using Windows, you will generally download two files. Taking Oracle 11g as an example, there are two zip compressed files. Please note that the contents of the two compressed files should be decompressed and merged before installation. The installation prompts that the monitor configuration must display at least 256 colors and can be ignored. Checking other pre-installation items may cause a crash. I really don’t know why, so I 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 normal installation on Server 2008 R2 English version and Sever 2012 R2 English version. After the installation is completed, you can see the following.

Database Control can view and manage the database through the web page. Each database has one, which is distinguished by the port. The URL is such as https://Machine name: 1158/em (em should be Enterprise Manager means). Note that when installing on Window Server 2008 R2, an error will be reported in the last Create Database: An error occurred when uploading Oracle configuration data to the database. This is because Window Server 2008 R2 will return an IPv6 address when accessing the local machine name through the network. However, Oracle Enterprise Manager only accepts IPv4 addresses, that is, https://machine name, and will not obtain IPv4 addresses. You need to add:

127.0.0.1 localhost
IPv4地址 机器名

Database Configuration Assistant to create configuration and delete database in the host file.

Net Configuration Assistant network related configuration, such as listening program.

SQL Developer development management tool, installed 64-bit Oracle Database cannot be opened, prompting that the JDK cannot be found, even if it correctly points to the JDK that comes with Oracle, it will not work, SearchThe result is that 32-bit is required JDK, ignore it for now.

SQL Plus command line tool, you can get started quickly if you are familiar with MySQL.

Oracle also has an Oracle Client, which is the client. There is no need to install it on the Server. You can install it on other machines that need to connect to the Server. After installation, the picture above will appear. The same management tools.

2.Oracle background service

Every time a database is added, an Oracle instance will be added. As shown in the figure below, there are two background processes in the case of ORCL and WIND databases

3. Log in to Oracle

You can use SQL Plus to log in for the test. If no special user is created when creating the database, you can use Log in to the system with the SYS or SYSTEM account to configure. SYS has the highest authority. You cannot use SYS to log in directly, or it will crash. You can use the following methods to log in and let SYS log in using an alias

C:\sqlplus
Enter user-name:sys
Enter password: yourpassword as sysdbaor
C:\sqlplus /nolog
SQL> conn sys/yourpassword as sysdba

or
C:\sqlplus sys/yourpassword as sysdba

The above is the detailed content of About some problems encountered when installing and using Oracle database on Windows. For more information, please follow other related articles on the PHP Chinese website!