Oracle installation experience, we share, if not the place, please point out to

1. Install \oracle\10201_database_win32.zip;

A) installation diagram: http://jingyan.baidu.com/article/5d6edee228308899eadeec3f.html

b) Note: the compatibility settings for the setup.exe executable file are as follows:

2. Install the Plsqldev8.0.zip tool.

a) Note: The installation directory can not have Chinese or parentheses, such as: (x86), etc.

Registration code:

Product CODE:JTLHLJ6FLZRWD4DNWWPJU2Y8ZA89VB8R8YEHXA32QVFV

Serial number:2049878599

Password:xs374ca

Product Code:4vj6rhs6wf5c844tfcpqqqzg5uprd29pax5tz4ln75

Serial number:368600710

Password:xs374ca

Product code:khleqwl9ksfrghw9eh7ffwcn7fndjzt9sbsyw556

Serial number:53696408

Password:xs374ca

Product Code:jtkjljsvlx2mcl6sbbbxapgdhx9zhjhnd7xvpcuzu7m6
Serial number:2064414062
Password:xs374ca

3. After installing Plsqldev8.0.zip, to log in to Oracle also do the following steps, found in the Oracle installation directory

A) \product\10.2.0\db_1\bin\sqlplus.exe files, executed, such as:

In its user name enter : Conn/as sysdba do not enter the password (enter), you can log in.

B). as entered below, the purpose is to create an account and set permissions for the account.

Website: http://blog.chinaunix.net/uid-20802110-id-4235570.html

CREATE USER test identified by VALUES ' test '

DEFAULT tablespace Test_data

Temporary tablespace TEMP

Profile DEFAULT

Account UNLOCK;

----- caused by this trip, generally use identified by Direct plus password!!

Identied by values for encryption-specific passwords, typically

A string of non-readable characters, if the password is specified in clear text,

You can use Dentied by password .

--3 Roles for test

GRANT CONNECT to test;

GRANT DBA to test;

GRANT RESOURCE to test;

ALTER USER test DEFAULT ROLE all;

--2 System privileges for test

GRANT CREATE any TABLE to test; -- CREATE TABLE function

GRANT CREATE any VIEW to test; -- CREATE VIEW function

Grant create any trigger to test; -- Create a trigger

Grant Create any procedure to test; -- Create a stored procedure

GRANT UNLIMITED tablespace to test;

4. Complete the above three steps, you can use the Plsql developer, the user name is test, password is test account login.

Oracle installation experience, we share, if not the place, please point out to