Oracle Foundation Learning 1--oracle Installation

The installation process is simple, follow the steps to go. Here's a reminder. If you are using PL/SQL to operate Oracle, it is best to install a 32-bit Oracle program. The reason is that the web says PL/SQL only supports 32-bit Oracle, and if you work with 64 for Oracle+pl/sql, there are a number of issues, such as the inability to load oci.dll, and so on. Of course, I have personally experienced, 64-bit Oracle alone is very good, but the corresponding PL/SQL developer is more difficult to configure.

There are two places to be aware of during the installation process:

? Global database name;

? Password for the system user (usually by default)

　　How do I verify that the installation was successful? With your own experience, there are two important service programs on the Oracle server side. So:

? First look at whether the service program is installed in the Oracle related two major service programs, such as my is, Oracleoradb11g_home1tnslistener and ORACLESERVICEORCL, a listener a master database instance service program, such as:

　　

? The program is installed, and then test whether the above two service programs are configured correctly and execute two commands (assuming the global database name is ORCL):

Tnsping ORCL: Test listener Configuration

　　

Sqlplus System/[email protected]: Test database Routines Installation and startup program configuration (assuming the password for the system user is password)

　　

The successful execution of the command indicates that the installation was successful.