Tutorial: Oracle 11g OCP path (4): Common Tools

Artifact SQL Plus

SQL puls is an artifact. Apart from its powerful functions, SQL plus is available in severe cases. When SQL plus is unavailable, the system is finished. Let's recall how many accounts are available in our system? Sytem/Sys. use SQL plus to log on to the system account. 1,

2,

3. Just like the previous one, the price @ gp will be able to log on, and adding @ oracle or other will not work. Where is the problem? Gp must be configured by myself. Where can I configure it? We have configured different configurations for configuration differentiation.

4. We logged on to another account sys. Why did we log on without a username or password?

5. What is this 1111111111 string? Why can we still log on? This involves OS authentication. As long as you are locally connected, you can directly log on to the user with the highest permissions. Sys. Add an as sysdba.

6. Why do we clearly log on to sys and show that the user is public?

7. Why did I log on directly? An error is displayed.

In general, Oracle users are divided into normal, sysdba, and sysoper. Common users do not need as, and the other two must be as xx. We generally use normal and as sysdba for beginners, and remember that as sysdba can be OS-authenticated, that is, you can directly log on to the server without a password. As for the differences between sysdba, sysoper, and normal, you do not need to know for the time being, because it is too complicated.

SQL Developer (recommended Oracle tools)

1. The first login requires the java path. Oracle comes with java and we can find it. F: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ jdk \ bin \ java.exe. Simply put, in the Oracle_home directory, we should not say much about what Oracle_home is, the previous chapter is very detailed.

2. For Association configuration, we will not select all of them. Please confirm them directly.

3. Create a connection

4. basic Mode

4. tns mode.

Most third-party tools are used in the same way as SQL Developer. We will introduce several types below.

SQL third-party tools

Pl/SQL developer ToadOracleSQLHandler (a free tool written by Chinese people) Next we will talk about the Oracle architecture.