Installation and uninstallation of Oracle11g and use of common tools

Installation and uninstallation of Oracle11g and use of common tools

Installation and uninstallation of Oracle11g and use of common tools

Purpose:

(1) master the installation and uninstallation processes of the Oracle 11g Database.

Installation and uninstallation of Oracle11g and use of common tools

Purpose:

(1) master the installation and uninstallation processes of the Oracle 11g Database.

(2) learn how to use Oracle 11g Enterprise Manager and SQL * Plus.

Content:

1) install Oracle Database 11g.

2) uninstall Oracle11g.

3) Basic Environment and services after Oracle Database 11g is installed.

4) Enterprise Manager (EM) tool.

5) use the SQL * Plus tool.

6) use of tools such as net manager and net configuration assistant.

Steps:

1. Install Oracle Database 11g.

1.decompress the downloaded package. Then, click setup.exe to start installation.

2. The following message is displayed: deselect the check box and click Next,

Click "yes" after the pop-up'

3. Select create and configure the database, and click Next.

4. Select the server class because the desktop class does not have the advanced options.

5. select a single instance database and click Next.

6. Select advanced installation and click Next.

7. Select a language. If other languages are not used in the database, the default language is used. Next step:

8. Select the installation version and use the Enterprise Edition. Next Step

9. Note the following when selecting the base directory. It is best to create a custom directory so that you can easily query and change it yourself. Do not use this default directory. It is troublesome to delete it. The following describes how to create a custom directory.

10. create a custom Directory: Create a folder under drive D, named myoracle, enter this folder, and create a folder named oracle. note: The names of these two folders can be defined by yourself, but it is better not to use the Chinese name as the folder name, which is prone to problems. The following directory structure is recommended.

This is what it looks like:

11. Continue the installation. Click the one next to the 'oracle base directory:

12. Select the new d: \ myoracle \ oracle Folder:

13. after the above selection, it should look like the following: After the base directory is selected, the software location will be automatically selected, regardless of the browsing below, click Next directly.

14. Select 'General purpose transaction process' and click Next:

15. The 'Global database name' can be customized. The following service identifiers can also be customized. Generally, the default values are used. Next step.

16. Click Next by default.

17. Select the default option. Next Step

18. It is still the default one. click Next.

19. Go to the next step.

20. Configure the password. If you are in trouble, just use it for learning. If advanced, you can set different passwords. These user permissions are different. I used the unified password and entered oracle123... Note: Your password must start with a letter and start with a number. There will be many problems later.

21.

22. after you enter the oracle123 above, the following pop-up will pop up: note that the oracle password standard requires a combination of letters, numbers, and upper and lower case numbers greater than eight digits. Generally, it is only for learning, don't care about this. Just click "yes.

23. Check the environment:

24. after the Environment check is complete, you can directly click Next, and some will appear, such as: This is generally the case, so there should be no big problem, choose Ignore all, click Next.

25. The following will appear: Click Finish to start the installation.

26. Installation started: the installation is slow. After the database software is installed, a database instance will be created, so wait for a while and wait for a while.

27. This is displayed after installation: click OK. Disable.

This completes the installation of oracle.

Run the SQL plus command that comes with oracle.

Username: system. Password: oracle. (The password defined in step 20 ). Smooth access: note that the password entered here in oracle is not displayed and is logged on in a way similar to linux. You can enter an SQL statement here.

Oracle11g uninstall

A. Stop all Oracle-related services

B. Uninstall the Oracle 11g database server component (using the Universal Installer)

C. manually delete Oracle-related content in the registry.

D. Delete Oracle environment variables

E. Delete Oracle-related folders in the TEMP directory

F. check whether any Oracle program group exists in the "Start" menu. If yes, delete it.

G. restart the computer

H. Delete the Program Files \ Oracle directory in the Windows system installation disk

I. Delete the Oracle Installation Directory

3. Basic Environment and services after Oracle Database 11g installation.

The system "service" window is shown in:

First, you must start Oracle listening and services.

The Database Service Properties dialog box is shown in:

4. Use the Enterprise Manager (EM) tool.

Enter the user name and password on the interface. because the system has not yet created a new user, the system will log on to the system by default when installing the system. Services for this user are automatically set by the system, select a connection identity from the drop-down list box. There are two types of Oracle connection identities: "Normal (Normal identity)" is the basic connection method with the lowest level; "SYSDBA (Administrator identity)" is the "DBA" connection method with the highest level. Generally, a user connects as "Normal", and the connection identity of "SYS" is "SYSDBA ".

After entering the information, click "Log on" to display the first interface.

When viewing through OEM, enter: https: // 127.0.0.1: 1158/em/

5) use the SQL * Plus tool.

SQL * Plus is the core product of Oracle. Developers and DBAs can directly access Oracle databases through SQL * Plus, including data extraction, database structure modification, and database object management, its commands and functions are based on the SQL language.

1. log on to SQL * Plus

On the operating system interface, select start \ Program \ Oracle _ OraDB11g _ home1 \ Application Development \ SQL * Plus. The SQL * Plus window appears, please.

Enter the user name and password in the window. Because no new user has been created in the system, use the "scott" User Created by default during system installation to log on. The password is the password set during installation. Press the Enter key. If the logon is successful, capture the successful page.

2. SQL * Plus Environment Introduction

The SQL * Plus work environment is an interactive operation environment that uses row editing. You can enter and execute SQL commands in this environment. The SQL * Plus environment provides five menu options. The "file" menu is used to access files of SQL commands or PL/SQL programs. The file extension is generally ". SQL ".

Because SQL * Plus is a line editor, similar to the DOS environment, it is difficult to modify the SQL command if you type an error. Therefore, when you type an incorrect SQL command, you can type the "EDIT" command to call the external editor. The default is the text editor set by the system. Once you enter the external editor environment, the system automatically transfers the SQL commands or PL/SQL programs in the current row editing buffer to the editor. You can modify and save them as needed, the default SAVING file is "afiedt. buf ". If you select "file" \ "save" from the menu bar, the content in the current editor will be saved to "afiedt. buf file. If the "file" \ "Save as" option is selected, the content in the editor will be saved to the specified file. After the modification is saved, close the window and the system will return to the row editing workspace. The current content in the external editor is also placed in the row editing buffer, and type the symbol "/". the symbol "/" is the symbol used to execute commands in the SQL * Plus environment to continue executing the modified commands or programs.

Start SQL * Plus

Command Line cmd Input

Run sqlplus sys/oracle as sysdba.

Other users

Sqlplus scott/oracle

There are also some examples:

P editing Buffer

N N -- use a number to locate the current row in the buffer;

N A [PPEND] -- append the specified text to the end of the current row in the buffer;

A [PPEND] text

N DEL -- Delete the text of the current row in the buffer;

P execution Buffer

N R [UN]

N/

P clears the buffer

N CL [EAR] BUFF [ER]

P n text

Summary:

(1) read the online documentation carefully to ensure that the current installation environment meets the installation requirements.

(2) If the system has installed Oracle, uninstall the Oracle_Home environment variable.

(3) If you have installed an Oracle database and want to reinstall it, stop all Oracle services. To stop all services starting with "Oracle", open the "control panel", "Administrative Tools", and "services" in Windows. Otherwise, an error occurs during Oracle installation.

(4) to ensure the smooth installation of the system, we recommend that you extract the Installation File (two compressed files) of Oracle Database 11g to the same folder.

(2) learn how to use Oracle 11g Enterprise Manager and SQL * Plus.

Content:

1) install Oracle Database 11g.

2) uninstall Oracle11g.

3) Basic Environment and services after Oracle Database 11g is installed.

4) Enterprise Manager (EM) tool.

5) use the SQL * Plus tool.

6) use of tools such as net manager and net configuration assistant.

Steps:

1. Install Oracle Database 11g.

1.decompress the downloaded package. Then, click setup.exe to start installation.

2. The following message is displayed: deselect the check box and click Next,

Click "yes" after the pop-up'

3. Select create and configure the database, and click Next.

4. Select the server class because the desktop class does not have the advanced options.

5. select a single instance database and click Next.

6. Select advanced installation and click Next.

7. Select a language. If other languages are not used in the database, the default language is used. Next step:

8. Select the installation version and use the Enterprise Edition. Next Step

9. Note the following when selecting the base directory. It is best to create a custom directory so that you can easily query and change it yourself. Do not use this default directory. It is troublesome to delete it. The following describes how to create a custom directory.

10. create a custom Directory: Create a folder under drive D, named myoracle, enter this folder, and create a folder named oracle. note: The names of these two folders can be defined by yourself, but it is better not to use the Chinese name as the folder name, which is prone to problems. The following directory structure is recommended.

This is what it looks like:

11. Continue the installation. Click the one next to the 'oracle base directory:

12. Select the new d: \ myoracle \ oracle Folder:

13. after the above selection, it should look like the following: After the base directory is selected, the software location will be automatically selected, regardless of the browsing below, click Next directly.

14. Select 'General purpose transaction process' and click Next:

15. The 'Global database name' can be customized. The following service identifiers can also be customized. Generally, the default values are used. Next step.

16. Click Next by default.

17. Select the default option. Next Step

18. It is still the default one. click Next.

19. Go to the next step.

20. Configure the password. If you are in trouble, just use it for learning. If advanced, you can set different passwords. These user permissions are different. I used the unified password and entered oracle123... Note: Your password must start with a letter and start with a number. There will be many problems later.

21.

22. after you enter the oracle123 above, the following pop-up will pop up: note that the oracle password standard requires a combination of letters, numbers, and upper and lower case numbers greater than eight digits. Generally, it is only for learning, don't care about this. Just click "yes.

23. Check the environment:

24. after the Environment check is complete, you can directly click Next, and some will appear, such as: This is generally the case, so there should be no big problem, choose Ignore all, click Next.

25. The following will appear: Click Finish to start the installation.

26. Installation started: the installation is slow. After the database software is installed, a database instance will be created, so wait for a while and wait for a while.

27. This is displayed after installation: click OK. Disable.

This completes the installation of oracle.

Run the SQL plus command that comes with oracle.

Username: system. Password: oracle. (The password defined in step 20 ). Smooth access: note that the password entered here in oracle is not displayed and is logged on in a way similar to linux. You can enter an SQL statement here.

Oracle11g uninstall

A. Stop all Oracle-related services

B. Uninstall the Oracle 11g database server component (using the Universal Installer)

C. manually delete Oracle-related content in the registry.

D. Delete Oracle environment variables

E. Delete Oracle-related folders in the TEMP directory

F. check whether any Oracle program group exists in the "Start" menu. If yes, delete it.

G. restart the computer

H. Delete the Program Files \ Oracle directory in the Windows system installation disk

I. Delete the Oracle Installation Directory

3. Basic Environment and services after Oracle Database 11g installation.

The system "service" window is shown in:

First, you must start Oracle listening and services.

The Database Service Properties dialog box is shown in:

4. Use the Enterprise Manager (EM) tool.

Enter the user name and password on the interface. because the system has not yet created a new user, the system will log on to the system by default when installing the system. Services for this user are automatically set by the system, select a connection identity from the drop-down list box. There are two types of Oracle connection identities: "Normal (Normal identity)" is the basic connection method with the lowest level; "SYSDBA (Administrator identity)" is the "DBA" connection method with the highest level. Generally, a user connects as "Normal", and the connection identity of "SYS" is "SYSDBA ".

After entering the information, click "Log on" to display the first interface.

When viewing through OEM, enter: https: // 127.0.0.1: 1158/em/

5) use the SQL * Plus tool.

SQL * Plus is the core product of Oracle. Developers and DBAs can directly access Oracle databases through SQL * Plus, including data extraction, database structure modification, and database object management, its commands and functions are based on the SQL language.

1. log on to SQL * Plus

On the operating system interface, select start \ Program \ Oracle _ OraDB11g _ home1 \ Application Development \ SQL * Plus. The SQL * Plus window appears, please.

Enter the user name and password in the window. Because no new user has been created in the system, use the "scott" User Created by default during system installation to log on. The password is the password set during installation. Press the Enter key. If the logon is successful, capture the successful page.

2. SQL * Plus Environment Introduction

The SQL * Plus work environment is an interactive operation environment that uses row editing. You can enter and execute SQL commands in this environment. The SQL * Plus environment provides five menu options. The "file" menu is used to access files of SQL commands or PL/SQL programs. The file extension is generally ". SQL ".

Because SQL * Plus is a line editor, similar to the DOS environment, it is difficult to modify the SQL command if you type an error. Therefore, when you type an incorrect SQL command, you can type the "EDIT" command to call the external editor. The default is the text editor set by the system. Once you enter the external editor environment, the system automatically transfers the SQL commands or PL/SQL programs in the current row editing buffer to the editor. You can modify and save them as needed, the default SAVING file is "afiedt. buf ". If you select "file" \ "save" from the menu bar, the content in the current editor will be saved to "afiedt. buf file. If the "file" \ "Save as" option is selected, the content in the editor will be saved to the specified file. After the modification is saved, close the window and the system will return to the row editing workspace. The current content in the external editor is also placed in the row editing buffer, and type the symbol "/". the symbol "/" is the symbol used to execute commands in the SQL * Plus environment to continue executing the modified commands or programs.

Start SQL * Plus

Command Line cmd Input

Run sqlplus sys/oracle as sysdba.

Other users

Sqlplus scott/oracle

There are also some examples:

P editing Buffer

N N -- use a number to locate the current row in the buffer;

N A [PPEND] -- append the specified text to the end of the current row in the buffer;

A [PPEND] text

N DEL -- Delete the text of the current row in the buffer;

P execution Buffer

N R [UN]

N/

P clears the buffer

N CL [EAR] BUFF [ER]

P n text

Summary:

(1) read the online documentation carefully to ensure that the current installation environment meets the installation requirements.

(2) If the system has installed Oracle, uninstall the Oracle_Home environment variable.

(3) If you have installed an Oracle database and want to reinstall it, stop all Oracle services. To stop all services starting with "Oracle", open the "control panel", "Administrative Tools", and "services" in Windows. Otherwise, an error occurs during Oracle installation.

(4) to ensure the smooth installation of the system, we recommend that you extract the Installation File (two compressed files) of Oracle Database 11g to the same folder.