Overview Oracle 10g Server

There are many things worth learning about in Oracle. Here we will mainly introduce Oracle 10g servers, including the clients of Oracle9i.

1. Oracle dba account permissions, which are accessed by the Local Machine by default and are not open to remote users. You can enable this access permission by setting

2. After the Common Account of Oracle is installed, it has the permission to remotely access the database. Therefore, if you want to remotely connect to the database after installing the database, you should first create a common account and perform local authorization.

3. the Oracle9i client can access the Oracle 10g server. Configure TNS.

4. Oracle 10 Gb scott account is blocked by default. unlock execution statement: alter user scott account unlock;

5. in order for remote users to access the database server, the firewall on the server must open the database listening port. Oracle is 1521sqlserver and 1433mysql is 3306. To increase security, the open ports generally do not use the default ports, use another port instead.

If the default listening port of the service is changed to another port, the open port on the firewall should also be changed accordingly. Run the following command to add a port to the linux Firewall:/etc/sysconfig/iptables) -A RH-Firewall-1-INPUT-p tcp-m state-m tcp -- dport 1521 -- state NEW-j ACCEPT

6. Configure SSH first install the SSH service and start port 22 on the firewall to open-A RH-Firewall-1-INPUT-p tcp-m state-m tcp -- dport 22 -- state NEW-j ACCEPT

7. The port opened on the server should be protected in iptables to prevent security problems.

8. the listener and database of the Oracle 10g server are two services. They must be connected before being accessed by the outside world.

1. Oracle listener, let you listen to what you want
2. Do you know the Oracle. Net protocol stack?
3. Introduction to Oracle Database Optimizer
4. Brief Introduction to Oracle Provider
5. Detailed description of the Execution Plan for capturing Oracle SQL statements