Shulou(Shulou.com)06/01 Report--

1. Install oracle11g database:

Before the Winserver 2012 R2 operating system installs the oracle database, you need to start the .net framework3.5 service feature local to the system. Note that instead of downloading the .net framework3.5 installation, the system comes with the service, but is disabled. Specific steps to start the server. Net framework3.5: server Manager-- > add features and roles-- > next, default to the function item, and choose to start. Net framework3.5.

Next, follow the normal steps to install oracle.

II. Oracle custom tablespace and data table creation

/ / first step: check the database tablespace location select t1.namenotet2.name from v$tablespace T1 direction vuplodatafile T2 where t1.ts# = t2.tsspaces; / / step 2: create temporary and default tablespaces 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 'first step path\ tablespacename.DBF' size 50m autoextend on next 50m maxsize 20480m extent management local; / / step 3: create the user and specify the tablespace create user username identified by password default tablespace spacename temporary tablespace spacename_temp; / / step 4: grant the user permission grant dba,connect,resource to username

The above is the winserver 2012R2 installation oracle and table creation process introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.