Oracle 11g Express

The first step in using the tool is to install the tool and configure the environment! The following is a brief introduction to the installation and simple utility of Oracle 11g Express.

A Download the installation process

Go to Oracle's official website to download the Oracle 11g Express, about 300MB, after the download is done, after opening roughly like

Open Setup to start the installation, in order to ensure the successful installation, you can right click on the setup, choose to run with administrator privileges.

Click Next;

Select the target folder non-system disk (mainly to avoid some permissions problems), and then next, accept the installation protocol;

Enter a custom system account password, the account name of this system account is "system" by default, the password is what you want to set now, you can set it at will, I set it here as "test"; next, then install

Then install a variety of things, services, wait a while;

Installation Successful

Make sure that there are no errors or warning dialogs popping up in this middle of the process!!!

Two. Configuration process:

When the installation is complete, an icon appears on the desktop, but the error dialog box may appear, as follows: ignore it.

Similarly, in the Start menu there will be

This directory, open "Run SQL command line" will appear a console, as follows:

You can make a connection test, enter "Conn System/test", (the content in quotation marks, where test is the password set at the time of installation)

If everything is right, it should be the following interface

When you get here, there's no problem with the data installation, and the next step is to create an account that will allow you to manage your own tables.

Reopen "Run SQL command line" and enter "Conn System/test as SYSDBA;" Press ENTER

The connection is then prompted for success.

Then enter "Create user guest identified by guest;" (where the first guest is the newly set user name, the second guest is the password set), press ENTER

The user is then prompted to create it.

After the creation is completed, you can not use this account directly to connect to the database, otherwise it will prompt the account does not have permissions, need to authorize

So use "conn system/test as SYSDBA;" Re-login to the system administrator account, login successfully, then use "Grant connect,resource,dba,select any table to guest;" For guest This account is authorized as follows:

This is the result of the prompt for authorization success. You can then use the Guest account to log in to the database.

Enter "Conn guest/guest;" Press ENTER

This will prompt the login success, and then you can perform some common additions and deletions in this account to change the operation.

It's basically over here. But tasting when using the database, creating tables, and so on with some graphical tools to create, do not use this command line. This type of graphical tool can be connected to an Oracle database, and a graphical interface is used to manage the database. Let me give you an example of what I am using.

I used not much, feel navicat this tool interface friendly, use is also convenient, but charges. can download cracked version. This software on 17MB, very small, direct Baidu download after installation. Open the following interface:

Click Connect in the upper-left corner, select Oracle, and then press fill

Note: IP boycott fill in 127.0.0.1 and localhost are ok, under normal circumstances, if not, Exchange try

Service name or SID this entry must be filled with XE, this is necessary. Can't change

The user name and password are the one created in the previous step and are created according to your personal circumstances.

Then click "Connect Test"

A successful connection is no problem, you can log into the database with this account. then click OK.

Next, a "Oracle" connection entry will appear on the left, and then double-click to connect to the database with the configuration you just made.

You can expand the tree in layers and see there is a tstudent in it, which is a data table created directly in the console with commands.

Specific SQL commands and the use of this tool, you are on your own!

Some additions:

1. Desktop that Oracle Database 11g Express Edition is a page shortcut, configuration problems, so can not open, direct disregard for the good, because the basic use is not;
2. The "Run SQL command line" that appears in the Start menu is actually "Sqlplus" and the Sqlplus prompt in the console does not have such a command because the environment variable path is not joined to the Sqlplus path. Add it this way: right-click on "Run SQL command line" and view the properties as follows

Copy the paths in the target, and then open the environment variables

Select the path of the user variable, click Edit, and then at the end of the copy of the path to paste in, paste before you remember to enter a ";" To facilitate isolation from the front section.

Click OK when you are done.

Then enter "Sqlplus" in Cmd and try it as follows:

It's done!

Good, tutorial complete!!!

Oracle 11g Express