Oracle server and client build help documentation, oracle help documentation

Oracle server and client build help documentation, oracle help documentation
Oracle server and client creation help document

 

 

Directory introduction Oracle Server Installation Oracle client installation PLSQL installation login Test System Configuration Modification user operation unlock account, password creation account and password configuration listening file modification method listening graphical tool modification method

 

 

 

 

 

Introduction

 

Install the oracle database in windows. This installation help document includes the installation of the Oracle server, Oracle client, and PLSQL, the software versions used are oracle-server 10201_win32, oracle-client 10201_win32, and plsqldev804, which are run in the windows sever 2003 system environment. Before installation, you must first prepare two virtual machines in a clean and non-toxic windows operating system, and then perform a series of subsequent operations. The procedure is as follows:

 

 

 

Oracle Server Installation

1. Open a clean, non-toxic virtual machine, select the virtual machine button in the menu bar of VMware, and click set to open the hardware setting window.

 

2. Click CD/DVD, select use image file, Click Browse, find the image file of oracle-sever, and click open.

 

3. Double-click my computer on the Virtual Machine desktop to open it. When the CD drive turns into a state, it proves that the ISO file path is successfully arranged. Double-click the CD drive to open it.

 

4. Do not change the main directory path. Keep the default path. The Database Password must start with a letter and be set to "aa". click Next.

 

5. Waiting

6. If the overall result shows "pass", you can click Next.

 

7. Click "yes" to confirm

 

8. Click "Install"

 

9. Waiting for Installation

 

10. Waiting for Installation

 

11. The automatic pop-up window appears, waiting for the installation to complete

 

12. Click password management.

 

13. Click "tick" next to the scott user to unlock the scott user, enter the custom password in the last two columns, and confirm the password.

 

 

14. Click to exit

 

15. Click "yes" to exit the installation. The Oracle server has been installed.

Oracle client Installation

 

1. decompress the oracle-clientcompressed package and drag it to the virtual machine. Double-click the folder, find setup.exe, and double-click it.

 

2. click Next.

 

 

3. Select the Administrator type and click Next.

 

4. The default path does not need to be modified. click Next.

 

5. If the check result is successful, click Next.

 

6. Click to install

 

7. Waiting for Installation

 

8. Click Next. Do not select "execute typical configuration"

 

9. click Next.

 

10. Enter orcl in the service name and click Next.

 

11. The default protocol is TCP. click Next.

 

12. Enter the Server Host IP address (IP address queried by ipconfig in dos window) for the host name, select oracle default port 1521, and click Next.

 

13. Select "Yes, test"

 

14. Click "Change Logon", enter the user and password you have previously unlocked, and click "OK.

 

15. Check that the test is successful. click Next.

 

16. The default service name is orcl, which does not need to be modified. click Next.

 

17. No by default. click Next.

 

18. click Next.

 

19. click Next.

 

20. Click Finish

 

21. Click to exit

 

22. Click "yes". The Client installation is complete.

 

 

PLSQL Installation

 

1. decompress the plsql installation package

 

2. Waiting

 

3. Click "I AGREE"

 

 

4. The default path does not need to be modified. click NEXT.

 

5. Click "Finish"

 

6. Click "Close" to install PLSQL.

 

 

 

 

Logon Test

1. Find the registration information software license keygen.exe included in the installation package and double-click it to open the newly generated PLSQL shortcut on the desktop.

 

2. Enter the unlocked account and password, enter orcl in the database column, select the default nomal mode, and click OK.

 

3. Fill in the registration information in the previously opened registration information software in the pop-up window, and click Register

 

4. When the title bar is displayed, the logon is successful and data operations can be performed.

 

 

System Configuration Modification 1. user operation 1.1 unlock account and password

1.1.1 find SQL Plus in Start Menu> All Programs> Oracle-OraDb10g_home1> application development and click Open

 

 

1.1.2 enter the system and password. The password is the custom password in step 1 during Server installation. Click OK.

 

1.1.3 when the text is displayed in the window, the connection is successful.

 

1.1.4 the server has many users by default. These accounts are locked by default and need to be unlocked first. Enter the command statement "select * from all_users;" and press the Enter key to view all users.

 

1.1.5 here, we will use unlocking the "scott" user as an example (Step 12-13 on the server side has not unlocked the scott user). In the command bar, enter "alter user scott account unlock;" and press Enter, the user has been changed. The user is successfully unlocked.

 

Note: "alter user scott account lock;" locks scott.

 

1.1.6 enter "alter user scott identified by aaa;" in the command bar, and the user has been modified. scott's password is changed to "aaa ".

 

 

1.2 create a user and password

1.2.1 enter "create user zhangsan identified by aaa;" in the command line to create a user named zhang with the password aaa

 

1.2.2 grant permissions to the user after the user is created. The specific command is as follows:

1. Grant operation Permissions

Grant create session to zhangsan; // grant the zhangsan user the permission to create a session, that is, the login permission.

Grant unlimited tablespace to zhangsan; // grant the zhangsan user the permission to use the tablespace.

Grant create table to zhangsan; // grant the table creation permission

Grante drop table to zhangsan; // grant the table deletion permission

Grant insert table to zhangsan; // insert table permission

Grant update table to zhangsan; // Modify table Permissions

Grant all to public; // This is important. grant all permissions to all users (public)

2. oralce is more rigorous in permission management. Common users cannot access each other by default and must be authorized to each other.

Grant select on tablename to zhangsan; // grant the zhangsan user the permission to view the specified table.

Grant drop on tablename to zhangsan; // grant the table deletion permission.

Grant insert on tablename to zhangsan; // grant the insert permission

Grant update on tablename to zhangsan; // grant the table modification permission.

Grant insert (id) on tablename to zhangsan;

Grant update (id) on tablename to zhangsan; // grant the insert and modify permissions for specific fields in the specified table. Note that only insert and update are allowed.

Grant alert all table to zhangsan; // grant permissions to any table of the zhangsan user alert

3. revoke permissions

The basic syntax is the same as grant. The keyword is revoke.

4. View Permissions

Select * from user_sys_privs; // view all permissions of the current user

Select * from user_tab_privs; // view the table permissions of the users used

 

Note: The preceding operations can also be performed in the pl/SQL window. The specific operation is file> new> command window. Then, enter the specific command in the pop-up window, however, other accounts and authorization operations must be performed on the premise of logging on to the sys or system account.

 

 

 

2. Configure the listener File

Through the previous installation, we know that the server listens to the client through IP addresses, but the IP addresses are automatically allocated by default, when the IP address is changed and you log on to the account again, a window will pop up and you cannot log on.

In this case, we need to manually modify the listening file or fix the IP address of the Local Machine to prevent this situation from happening again.

 

2.1 listener File Modification Method

2.1.1 double-click my computer and find the listener. ora file and tnsnames. ora file in the path.

 

2.1.2 open tnsnames. ora in text mode, change host in the red box to the IP address of the remote server, port to the port number of the remote server, and service_name to orcl. You can also change host to the host Name of the remote server.

 

2.1.3 open the listener. ora file in txt text. In the red box, enter the IP address of the listening client or the host name of the listening client, and port enter the port of the client.

 

 

2.1.4 locate the tnsnames. ora file of the client according to the path on the way, and configure the IP address of the host or directly the host name of the client.

 

 

 

2.1.5 open the PLSQL logon shortcut, enter the password, and click OK.

 

 

2.1.6 logon successful

 

 

2.2 graphical tool modification method

2.2.1 follow the arrow to find the server's net manager tool and click open.

 

2.2.2 Oracle Net configuration> Local> listener> Add address

 

2.2.3 enter the Client IP address or host name in the host bar, enter the default port 1521 on the port, click Close, and click Save. The modification is complete.