"Introduction to this article"
Recently, because of the needs of a project, from zero to learn from Oracle, now learn to share a record of things.
The first is the installation, in the WIN8 installed 10G has failed, online various methods have tried, and finally have to give up, choose 11G.
The installation of 11G is very simple, basically is "next"-"complete" mode, this article just describes which steps need to pay attention to and the corresponding noun in the explanation,
This information may be used in the future.
"Typical Steps for Installation"
1. Typical Installation
Here you need to remember the " Global database name " and " Manage password " that are red circles.
(1) Global database name : to differentiate from the following SID, is the real unique identity of the database, as everyone has their own identity card, a room can have a lot of people, but everyone has their own identity card, identity card is unique, can distinguish everyone. A network domain has multiple databases, but each database should have an identity that distinguishes it from other databases-the global database name. At the same time, the global database name is required to install the database, create a new database, create a database control file, modify the data structure, and back up and restore the database.
(We can pass: select name from V$database; command to view the current global database name. )
(2) Manage Password: the password of the database.
Figure 1
2. End of installation
In the installation process to fill in the "System identifier", aka "SID", 2.
(1) system identifier (SID): Global database name = SID + domain name. The SID value defaults to the database name portion of the global database name, such as the global database named orcl.21.23.110, and the SID defaults to Oracl.
Required when connecting remotely to a database on a server, 3.
Available via command select instance_name from V$instance; View.
(2) password management : Unlike MySQL, MySQL is a user management database, and Oracle management user, a "user" equivalent to a MySQL "database", users can be built on the table and other operations. After installing a "Manage password" button, you can "lock/unlock the database user account and/or change the default password" after going in. And you can see some system-level users that originally existed by default. 4.
Figure 2
Figure 3
Figure 4
3. Start the service and login to a user
Run-Enter cmd--input sqlplus--Enter user name-Enter the password, you can enter into a user under the manipulation of the database (Figure 5). For information on how to manipulate the database, see the following series of posts.