Steps for installing Oracle database software

If you are not familiar with the actual steps for installing the Oracle database software, you can click the following article to have a better understanding of how to install the Oracle database software, the following is an introduction to the relevant content of the article.

After logging on to Oracle and installing the Oracle product, the client must configure the network connection for data access to the database server. The network configuration includes the server configuration and client configuration.

Server Configuration: Listener)

Server configuration refers to configuring a listener. It is used to listen to connection requests sent from the client.

Listener Configuration includes the listener protocol, address, and other related information parameters.

Listener Configuration is stored in a configuration file named listener. ora.

The file is located at D: \ Oracle \ ora90 \ network \ ADMIN \ listener. ora

The default listener listens to the following TCP/IP addresses.

When installing the Oracle database software, the installer automatically configures a LISTENER named LISTENER. The listener corresponds to the windows Service OracleOraHome92TNSListener

Client configuration: Service name)

To connect a client to a server, you must create a network service name that establishes a connection with a remote or local listener. The client uses it to send a connection request to the server.

To connect to an Oracle server on a workstation without an Oracle database server installed, you must install the Oracle software separately. When creating a service name on the client, you must specify the network protocol, protocol-related information, and the global database name of the database SID ). These configuration information is stored in the tnsnames. ora file, and the storage location is the same as that of listener. ora.

The file is located at D: \ Oracle \ ora90 \ network \ ADMIN \ tnsnames. ora

※: [Both the Net Configuration Assistant and Net Manager tools in Oracle can be used to configure listeners and Network Service names]

Oracle application tools

Oracle Query Tools)

SQL * Plus

Isql * Plus

PL/SQL

Oracle Enterprise Manager: Oracle Enterprise Manager)

User Management

In Oracle, to enhance data security, you must have the corresponding account and permissions to access the Oracle database. The database administrator can create a user account that allows access to the database and grant it access permissions. After the account is created, the user can access the Oracle database according to the permissions granted by the Administrator.

Create a user in Oracle:

When you create a new database, Oracle creates some default database users and their corresponding modes. By default, the following users are used:

1. SYS: superuser: -- password: changle_on_install)

All data dictionaries and views in the database are stored in SYS mode. This user is mainly used to maintain system information and manage instances. In Oracle9i, SYS users can only log on to the system as SYSOPER or SYSDBA.

2. SYSTEM: SYSTEM Administrator: -- password: manager)

The SYSTEM user is the default SYSTEM administrator in Oracle and has the DBA permission. It is usually used to manage database users, permissions, and storage. We do not recommend creating user tables in this user mode.

3. SCOTT: Demo account: -- password: tiger)

This user is automatically created during Oracle installation. It is generally used for testing and demonstration. It has four demonstration tables.

The create user command in Oracle is used to CREATE a new USER. Each user has a default tablespace and a temporary tablespace. If this parameter is not specified during creation, Oracle sets SYSTEM as the default tablespace and TEMP as the temporary tablespace.

The above content is an introduction to installing the Oracle database software. I hope you will have some gains.