Oracle Database Learning Note 1 (Installation and use of the 11g version of the installation &pl/sql tool)

1. Installing oracle11g1.1

Password is the database login password, the student party with the password set simple point, violating the Oracle password setting rules can continue the next step

1.2

Oracle defaults to three account users Scott (normal user), need to install the interface when the lock is canceled, followed by password. SYS User: Super administrator, highest privilege, and its role is DBA. The default password is Change_on_install. has permission to create a database. I installed the password when the unified set of * * * *. System User: SysAdmin, with high permissions, its role is DBA operator, default password manager. Do not have permission to create DATABASE! Same as password.

1.3

Install the time to detect the computer hardware, my laptop is not even detected, but can be all checked, all ignore the next step.

2.Oracle Architecture Diagram Oracle Server: 1.oracle Database: A collection of data (saving data) Physical Structure: Data files: Control Files: log file:
Logical Structure: 2.oracle instance: Background process: Memory Structure: system Global Area (SGA): Shared Area
Program Global Zone (PGA):  

This system diagram is very important to hear, many companies interview request handwriting this figure

Installation of the 3.pl/sql tool

The first installation did not succeed, under the CSDN resources, now think of it should be tnsnames.ora there is a Sqlnet.ora two files are not configured, resulting in the connection when the detection of the database is only a 222222222, go in to say no listening program. Later on the Internet to check and change, change my DOS box of Oracle can not go. Then unloading load, Baidu Tutorial, the registry each to delete, in fact, it is not very troublesome, and then reloaded. The second time follows another tutorial:

Install PL/SQL Developer:
1.plsqldev1104.exe, follow the prompts to complete the installation
2. Click the Cancel button after launch, according to Plsqldev1104code hack

pl/sql Developer Connect local Oracle 11g 64-bit database:
1. Extracting instantclient-basic-win32-11.2.0.1.0 to Oracle under
2. Create a folder under Instantclient_11_2 network\admin
3. Copy from Oracle_home\network\admin
Sqlnet.ora/tnsnames.ora
To Instantclient_11_2\network\admin
4. Configuring Oracle Home and OCI for PL/SQL developer Libaray



Click "OK", now the configuration is complete, exit PL/SQL Developer
5. Re-login PL/SQL Developer done.

Solve Pl\sql Developer Query Chinese table appear question mark garbled problem:
Set environment variables, after restarting the computer, the later inserted Chinese will not garbled

Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk

Then I found that the re-installed Oracle did not have tnsnames.ora files, only a sqlnet.ora, but the DOS box of Oracle is still in the go. I didn't know exactly what I was doing. Who can tell me so much? And then read the online tutorial is a lot of ways. I directly copied and pasted the friend's Tnsnames.ora file, opened, changed the inside path, put in the above instantclient_11_2 and their own Oracle installation directory. Then configure PL/SQL. Sure enough, Scott was detected, select, log in, enter their own installation time set the password, go in, eh ha. (For the installation this has been a few days =-=)

Then create a new SQL window, and the file list below has the system and the database you created, which you can view.

PL/SQL can also perform visual operations on Oracle.

So the first time I installed PL/SQL, I said no listener, think about it. There should be no new folders and configuration of these two files, because these two tutorials are different in the final step, to see what this tutorial says:

I. Directory structure

D:\install\PLSQL
|--instantclient_11_2
|--Tnsnames.ora
|--Plsql Developer
|--Readme.txt

Two. Environment variables

Nls_lang = Simplified Chinese_china. Zhs16gbk

Tns_admin = D:\install\PLSQL\instantclient_11_2

three. PL/SQL Developer environment settings

1. Location

Connections, preferences, tools

2. Settings

Oracle Home Directory name = D:\install\PLSQL\instantclient_11_2

OCI Library = D:\install\PLSQL\instantclient_11_2\oci.dll

Four. Supplement

Tnsnames.ora files need to be created manually and set accordingly, refer to the online tutorial.

Pit Daddy, the key fourth part of this is a few words. Add that you should create your own Netword folder and paste the Tnsnames.ora and sqlnet.sql files in the Oracle installation directory so that the database can be detected when PL is logged in.

Sure enough, the first download of the 64-bit Green Chinese version of PL/SQL is logged in.

Want a resource message or contact me Oh ~ ~

Oracle Database Learning Note 1 (Installation and use of the 11g version of the installation &pl/sql tool)