Shulou(Shulou.com)06/01 Report--

First go to the Internet to download the files in the list below. Baidu searches everywhere.

Let me explain what the above catalogs are.

The instantclient-basic-win32-11.2.0.1.0.zip file is a configuration file, so let's not explain it for now. We'll use it later.

OraClient.zip is the client of oracle. I didn't use this when I installed it. I don't need this.

Plsqldev1104.zip this is the plsql client, the installation is very simple.

Win32_11gR2_database_1of2.zip

Win32_11gR2_database_2of2.zip

These are the installation files for the database. Let's decompress these two files first.

I created a directory under D: disk called oracle11g. You can do the same when you create a directory. Remember, do not use Chinese names in the catalogue.

We unzip the above two folders into the oracle11g directory at the same time. It's going to look like this.

Then we click setup.exe. Start the installation:

If this page appears, ignore him. Select 'Yes' directly; continue with the installation.

You don't have to fill in the mailbox here. Uncheck that.

Choose 'yes' and ignore the warnings.

The first one is fine by default here.

The path chooses the oracle11g that we created before. The global database name is generally used by default, and the password you can learn to use can be simpler, regardless of its password warning. The password I set here is "oracle".

Select Yes. Ignore the warning.

Then start the installation. Wait slowly ~ ~ Click when the installation is complete. "done" will appear with the following interface:

Automatically start installing the database instance. It will take a long time to wait here. After installing the database instance, we will be asked to configure the user password.

We select password management on the page where it pops up.

All the ticks are locked, generally leaving only 2-4 administrator users. Write the password yourself. The passwords I set for users here are all 'oracle''

Then we click OK to complete the installation.

Then let's log in to http://localhost:1158/em and have a look. Log in with sys and select dba as your identity. When the following interface appears, oracle is installed successfully ~ ~

The above oracle section is completely over, let's install the plsql client.

Before installing the plsql client, we set the

Instantclient-basic-win32-11.2.0.1.0.zip

This file is unzipped to the oracle11g directory. As shown in the figure:

Like this, some people decompress the folder with multiple names. 2 and so on, ignore it, it's all the same.

We create a new network\ admin under the instantclient directory. We don't know if the case has anything to do with it. Create a tnsnames.ora file under admin and write the following content:

Orcl = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (ORACLE_SID = orcl)

Orcl is the database name from the previous installation

Next we install the plsql client. The installation of the plsql client is very simple, so I won't take a screenshot here. Except for choosing the installation directory, you can use the default one.

After we have installed the plsql client, double-click the icon to open the client.

Drop this little pop-up box for login. Don't log in and go straight in.

Click on the tool-- > preferences

Choose the first one on the left, fill in the path of the previously installed instantclient here in oracle home, and fill in the oci.dll under oracle home in the OCI column (if you don't have oci.dll under your oracle home, you must have found the wrong one) this option is basically not handwritten. If you click on the drop-down box, he will pop up on his own. if it doesn't pop up, it may be a failure.

Then we click ok. Configuration completed ~

Turn off the plsql and turn it back on.

Let's log in and try:

These four login boxes, not to mention the first two, are the user name and password (the password is the password you wrote when you registered), and the third database is the database instance name, which can be selected from the drop-down, usually orcl. The last Connect as (); Normal this is a regular user. Sysdba is an administrator user. We only have administrator users at the time of installation, so we choose sysdba here. Ok login succeeded ~

As long as you can log in, you will succeed. Those sql statements are because I wrote them. The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.