Oracle Foundation Learning 1--oracle Installation

The installation process is relatively simple. Follow the steps to go. Here is a reminder to use PL/SQL to operate Oracle. It is best to install 32-bit Oracle programs. The reason is that the web says PL/SQL only supports 32-bit Oracle, assuming that with 64 for Oracle+pl/sql to work together, there are many problems, such as 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 Management-lock/Unlock database user accounts and change default passwords

　　How do I verify a successful installation? According to own experience to be able, oracleserver side has two important service procedures. So:

? The first thing to look at is whether the two major Oracle-related service programs are installed in the service program.　For example, mine is. Oracleoradb11g_home1tnslistener and ORACLESERVICEORCL. A listener is a master database instance service program. For example, with:

　　

? The program is installed, and then test whether the above two service programs are configured correctly, run two commands (if 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 appropriate password for the system user is password)

　　

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvd2fuzzm3oti3ntyxna==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/center ">

When the command is successful, it represents a successful installation.

Oracle Foundation Learning 1--oracle Installation