Install and uninstall oracle10g
I. installation 1. due to the special nature of oracle, I chose to install the flagship version of windows 7 to install the database through a virtual machine. If your system is windows xp, windows 7, windows 8, you can directly install it, windows 10 is incompatible with oracle of this version and is not recommended. 2. I use the oracle10g compressed package. You can also use an image to install it and open the oracle installer. If there is a problem that cannot be opened, you need to set compatibility,
3. after the setup is complete, click the installer. Although the Basic installation options can save some time, if you are a beginner in oracle like the author, it is recommended to choose advanced installation, have a detailed understanding of the oracle installation process.
4. For the installation type, we select Enterprise Edition and oracle as a large database. The security and high throughput of oracle are very good for enterprises. We chose Enterprise Edition to consider that we can obtain the most database functions.
5. to continue the installation, when a prerequisite check occurs, you must note that the oracle installer may not select a check item (Network Configuration Requirements, etc.) by default, so as to report some warnings, you can select the check box. This is based on the actual situation of the reader. For example, if the database itself does not need to be connected, it can be ignored only for local learning and use. However, this interface only checks the environment, so even if you do not select the network, it does not mean that you will not be connected to the network after the installation is successful.
6. in the configuration options, we choose to create a database. Note that the difference between oracle and mysql is that oracle is not like mysql. It is easy to create a database through the command line, this involves some oracle tablespace and user management knowledge. I will discuss this knowledge in detail in subsequent articles. If you forget to choose to create a database, it is recommended that you use Database Configuration Assistant to create a Database after installation.
7. Database Configuration. If you have no special requirements, you can select a general purpose.
8. database Configuration option. You can set the database name on this interface. The sid also exists as the unique identifier of the database instance to distinguish different instances. We recommend that you have the same name as the database, we recommend that you select the unicode Standard UTF-8 for the database character set, for UTF-8 readers should be very familiar with, here and ASCII encoding compatibility issues, we did not select UTF-16, there is a database option with a sample solution in the database example. You can select this option for beginners, because many oracle teaching databases use the solution provided by these databases to explain the oracle syntax, as for the similarities and differences between the solution and our traditional tables, I will explain them in a later article.
9. If you only want to manage the database locally, select "database control database". Select "email notification.
10. For the database storage option, select the file system. Here, the database file location is not the installation location of the oracle software.
11. backup and recovery options. For the efficiency of software operation, we choose not to start backup here.
12. on the Database Password interface, the author selects a unified password. You can select a password based on your own situation. Note that the user names in the user list, such as sys, system, system, scott and so on. These users are of different use. I will explain in detail later. The usage of related users seems to me that oracle user management and permission management are both characteristic and difficult points of oracle, if you want to learn more about oracle, we recommend that you understand it as much as possible.
13. Next we will see that oracle will print the selected services into a list. We will continue to install the services. In this case, we may jump out of the firewall security warning, select allow access, and continue the installation.
14. If an error occurs during installation
I have not found a specific solution to this problem, but according to this error, it can be inferred that some problems may occur on some visual interfaces related to oracle, since we will select other software for development like pl/SQL developer later, we can leave it empty for the time being and click OK. If I encounter some problems in the use of the oracle database in the future, this article will be updated in a timely manner. Ii. Uninstall 1. oracle's uninstallation is notoriously exhausting. Because oracle writes a large number of registries during installation, if the registry cannot be deleted, the next oracle database installation will be affected, here I will post a ppt that Mr. Han shunping summarized during oracle uninstallation.
Ps: if some inappropriate behaviors exist in this figure, please send a private email to the author and delete it in time.
2. if the reader is using a virtual machine, it becomes very simple. Before the installation, use the snapshot function of the Virtual Machine. If you find that there is a problem with the installation of the oracle database, you can directly restore it to the time when the database is not installed.
Written in the last few words: I am also a beginner of oracle. There may be some misunderstandings on related issues. I hope all the major players can correct them in time and I am very grateful!
