We will share our experiences on installing ORACLE. If this is not the case, let's point it out and share it with oracle.

We will share our experiences on installing ORACLE. If this is not the case, let's point it out and share it with oracle.

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 execution file are as follows:

2. Install plsqldev8.0.zip.

A) Note: The installation directory cannot contain Chinese characters or parentheses, such as (x86 ).

Registration Code:

Product code: jtlhlj6flzrwd4dnwwpju2y8za89vb8r8yehxa32qvfv

Serial number: 2049878599

Password: xs374ca

Product code: 4vj6rhs6wf5c844tfcpqqqzg5uprd29pax5tz4ln75

Serial number: 368600710

Password: xs374ca

 

Product code: khleqwl9ksfrghw9e0000ffwcn7fndjzt9sbsyw556

Serial number: 53696408

Password: xs374ca

Product code: jtkjljsvlx2mcl6sbbbxapgdhx9zhjhnd7xvpcuzu7m6
Serial number: 2064414062
Password: xs374ca

3. After plsqldev8.0.zip is installed, log on to oracle and perform the following steps. Find

A) run the \ product \ 10.2.0 \ db_1 \ BIN \ sqlplus.exe file, for example:

Enter conn/as sysdba in the user name to log on without entering the password (Press ENTER.

B) enter the following information to create an account and Set permissions for the account.

Web: 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;

----- This line may result in the use of identified by to directly add a password !!

Identied by values is applicable to password specified in encryption mode.

A string of 16 unreadable characters. If the password is specified in plain text,

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 a TABLE

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. After completing the above three steps, you can log on to the account with the username test and password test in PLSQL Developer.