Winserver 2012r2 Install Oracle and create a table process ____oracle

First, install the ORACLE11G database:
Before you install the Oracle database on the Winserver R2 operating system, you need to start the system-Local. NET framework3.5 service feature, and note that instead of downloading the. NET framework3.5 installation, the system takes the service itself, but is disabled. The specific steps to start the server. NET framework3.5: Server Manager--> Add features and Roles--> Next, default to feature items, select Start. NET framework3.5.
Next, install Oracle in the usual steps.
Oracle Custom table space and datasheet creation
First step: View database table Space location
Select T1.name,t2.name from V$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#;

Step two: Create temporary and default table spaces
Create temporary tablespace spacename_temp
Tempfile ' E:\APP\ADMINISTRATOR\ORADATA\ORCL\spacename. DBF '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

Create Tablespace Spacename
Logging
DataFile ' The first step of the path \tablespacename. DBF '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

Step three: Create the user and specify the table space
Create user username identified by password
Default Tablespace spacename
Temporary tablespace spacename_temp;

Step Fourth: Grant permissions to users
Grant Dba,connect,resource to username;