Detailed introduction to oracle11

Detailed introduction to oracle11

I can learn about oracle recently, so I installed oracle yesterday and couldn't connect my mysql for unknown reasons. To be honest, it is a little complicated if you read the tutorial and install it. Especially for me, I installed oracle11g. after I installed it, I installed it for my classmates, but I guess they didn't understand how to install it. I was also drunk!

Now let's talk about oracle installation.

For more information about oracle practice, see the following link:

1. oracle Installation

1, enter the official website download, http://www.oracle.com/index.html oracle11g, a total of two files, new users must first register the oracle account can enter download

Win64_11gr2_database_1of2.zip、win64_11gr2_databasesilicate f2.zip. decompress the package to a folder and find the executable Installation File setup.exe. Double-click the installation file.

2. Installation Step 1: Configure Security Updates. skip this step without entering your email address. Cancel the following "I want to accept Security Update (W) through My Oracle Support )".

3. Select "Create and configure Database" as the installation option ".

4. Typical installation. Important steps. We recommend that you only update the Oracle base directory. The directory path should not contain Chinese characters or other special characters. The global database name can be default, and the password must be kept in mind. A warning is prompted when the password is entered. If the password does not comply with the suggestion of cancel, skip this step. (Because the suggested password rules by El are troublesome, they must be uppercase letters, lowercase letters, and numbers, and must be more than 8 characters long. Troublesome. You can enter a short password that you normally use. If the entered password is short and simple, the following prompt will be displayed during installation. Directly confirm that Y continues the installation.

Set the database name and password during installation. Never forget the password anyway. Otherwise, you have to retrieve it again. It's speechless.

5. The next step is the next step. After the database management software file and dbms file are installed, a database named orcl in front of the Instance database is automatically created and installed by default. The instance database has been created. By default, all accounts are locked and unavailable (except sys and system accounts are available). We recommend that you click password management on the right, unlock a common scott account and enter the password.

Download this file at http://www.oracle.com/technetwork/developer-tools/sql-#/downloads/index-098778.html. It takes a long time to install it directly.

When using sqldeveloper, you need to enter the connection name, account, and password. Note: You can use SCOTT for the connection name and SYSTEM for the user name, which is generally common and then enter the password, note that the connection type, role, and network alias must be set in my image. Then you can log in.

7. If you do not want to use the official graphical tool, you can also install the most classic pl/SQL.

Download plsql_developer.rar and install it. Some may need to be cracked at this time, so you can directly crack it. What I want to talk about is how to set the connection. In general, it cannot be used directly after installation, and then download instantclient_11_2 from the official website .. zip 32-bit. (whether your computer is 32-bit or 64-bit, you need to use 32-bit. Otherwise, it will not be connected .) Decompress instantclient_11_2 and place it in the same directory of pl. SQL,

Copy the tnsnames. ora file from E: \ oracle \ app \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ tnsnames. ora to the NETWORK \ ADMIN directory under the instantclient_11_2 folder. Then you can configure the image as shown in the following figure.

Main directory name E: \ oracle \ PLSQL \ instantclient_11_2

OCI library E: \ oracle \ PLSQL \ instantclient_11_2 \ oci. dll

Finally, the installation was complete. It was really troublesome and speechless. But I am a tough young man, hahaha! If you have any better method, please leave a message and let me know! Share and learn together!

At last, I want to record my mysql problems here: the connection fails, and the error is reported. Finally, I found that I upgraded the AppServ, and the old version of the database was not overwritten. Then I deleted the Registry (enter SC delete mysql57 In the Administrator cmd) and started the service, I re-installed Appserv and finally used it. For mysql installation, I only need to install AppServ, which is very convenient! You do not need to go to oracle to download any mysql database of the installation version or the installation-free version!

Use SQLyog for graphical management tools and enter the password directly!

Ii. oracle practice

Database:

Oracle databases are physical storage of data. This includes (data file ORA or DBF, control file, online log, and parameter file ). In fact, the concept of Oracle Database is different from that of other databases. The database here has only one database for an operating system. It can be seen that Oracle only has one large database.

Instance:

An Oracle instance consists of a series of BackguoundProcesses and MemoryStructures. A database can have n instances.

User:

The user is created under the instance. Users with the same name can be created for different instances.

Tablespace:

 

Tablespace is the logical ing of Oracle to the relevant data files (ORA or DBF Files) in the physical database. A database is logically divided into several tablespaces, each of which contains a set of logically associated structures. Each database has at least one tablespace (called the system tablespace ).

Each tablespace consists of one or more files on the same disk. These files are called data files ). A data file can belong to only one tablespace.

Data Files (dbf, ora ):

Data files are physical storage units of databases. The database data is stored in the tablespace, and is actually in one or more data files. A tablespace can be composed of one or more data files. A data file can belong to only one tablespace. Once a data file is added to a tablespace, it cannot be deleted. to delete a data file, you can only delete the tablespace it belongs.

Note: The table data is stored in a certain tablespace, Which is randomly stored in one or more data files.

Since oracle databases are not a common concept, oracle manages and stores data by users and tablespaces. However, the table does not have a tablespace to query, but is queried by the user. Because different users can create tables with the same name in the same tablespace! The difference here is the user!