Oracle Learning Note 02

2.1 Network Configuration Tool NET Manager

Oracle is a database system in a networked environment, and its own net manager configures and sets up the network environment. Net Manager as a tool for managing the network environment by configuring and managing Oracle NET components and their features.

It is generally necessary to configure some of the following configuration documents:

1. Profile 2. Service naming 3. Listener 4.oracle Name Server

Right-----Start-----the configuration and migration tools under the Oracle program can open net Mannger.

Profile: You can choose or remove some methods.

　　　　

If you need to access a remote database, you first need to identify the remote database, you can set the service naming to identify the remote database, service naming is a naming method, you can resolve the network service name to a connection descriptor, the client connects the database and the service through this connection descriptor. The new service named Network Service name and connection description are saved in the Tnsnames.ora file, and you can test the connection to the remote database by configuring the service naming. The configuration service naming steps are as follows: (Simply put, the test can be connected to a database on another computer!) ）

Select service naming, + number creation.

　　

　　

　　　　As expected, the test connection failed, it is estimated that the hostname is set wrong, there is no remote database let me test.

whether the test succeeds or not, the connection description is saved and the description information is stored in the Tnsnames.ora.

There may be several reasons why the connection test fails in general:

1. The specified database does not exist or the service is not started (this is the reason I failed to estimate).

2. The user name and password for the test are incorrect

3. The client and the server cannot communicate properly through the specified protocol

4. The client and server are in different domains and access to each other has a permissions problem.

Listener Program:

2.2 NET Configuration Assistant (Small Network assistant)

The network Configuration Assistant is a tool that connects to a remote database server and requires the configuration of listeners, named methods, local NET service name configuration, and directory usage configuration.

Under Configuration and Migration tools, open the NET configuration Assistant and configure it.

　　

　

All of the above tools are configured, and the general company is done by the DBA, which is rarely required if individual users are not particularly interested in research.

2.3 Sql*plus and Isql*plus

As an individual user, This can only be done with these two own tools when there is no graphical management tool for interfaces such as Toad Frogs and PL/SQL developer barrels. So the use of this tool is very necessary.

strong> 2.3.1  sql*plus can be completed:

strong> 1. Enter the SQL statement for strong> sql*plus Environment for configuration   2. Input access edit read run SQL command and PL $3. Interact with end users 4. Enter the results of the query into the report

strong> 　　 5. Start and close the database 6. Define variable catch PL/SQL errors   7. list column definitions for tables   8. Perform database management, etc.

strong>   Open under Application development Strong>sql*plus, select the Login dialog box.

strong> strong>      

strong> strong> where the host string refers to the name of the service that connects to the database, Can only use the permission is normal's account login, DBA account landing error. The login succeeds as follows, similar to MySQL's cmd interface.

 

strong> strong>

　　Unlock permission locks that execute SQL statements first

Show Table Structure

Querying all table names under the current user

Insert Data:

Common keywords and commands:

2.3.2 Isql*plus is a web version before use, you need to go to the service below to start the Isql*plus service before you open the server address.

In the Address bar, enter:http://127.0.0.1:5560/isqlplus normal User

HTTP://127.0.0.1:5560/ISQLPLUS/DBA Administrator

Oracle Learning Note 02