Oracle installation experience, everyone to share, assuming that the wrong 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 run file are as follows:

2. Install the Plsqldev8.0.zip tool.

a) Note: The installation folder cannot have Chinese or parentheses. such as: (x86) etc.

Manual 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, you will need to log in to Oracle to do the following steps, for example. found under the Oracle installation folder

A) \product\10.2.0\db_1\bin\sqlplus.exe file. Run, for example, with:

Enter in its username name : conn/as sysdba do not enter password (carriage return), you can log in.

B). press the input below. The goal is to create an account and set permissions for that 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, general use identified by Direct plus password can!

！

Identied by Values apply to encryption by specifying password, typically

A string of non-readable characters is forbidden. Assuming clear text specifies password,

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. Can be used in Plsql Developer, username for test, password for test account login.

Oracle installation experience, everyone to share, assuming that the wrong place, please point out to