Kelvin's Oracle on centOS6.5

[url=http://blog.youkuaiyun.com/j754379117/article/details/40222467]01 新手教你centOS 6.5下面如何安装Oracle 11g(通用版)[/url]

[url=http://www.cnblogs.com/sopost/p/3240921.html]02 Oracle 12c 安装手册[/url]

[url=https://www.chenxie.net/archives/416.html]03 图文详解CentOS 6.3_x86_64系统安装+oracle10gR2安装(Alex's blog)[/url]

02 when reboot the computer reside a oracle

lsnrctl start
slqplus / as sysdba
startup #to start instance

03 create temp tablespace

create temporary tablespace kelvin_temp tempfile'/oracle/tablespaces/kelvin/kelvin_temp.dbf' size 1024m autoextend on next 100m maxsize 10240m extent management local;

04 create data tablespace

create tablespace kelvin logging datafile'/oracle/tablespaces/kelvin/kelvin.dbf' size 1024m autoextend on next 100m maxsize 10240m extent management local;

05 create a common user which special tablespace

create user c##kelvin identified by kelvin default tablespace kelvin temporary tablespace kelvin_temp;

06 authorize

grant dba to c##kelvin;

07 login

--login as OS user
connect / as sysdba

--login as common db user
connect c##kelvin/kelvin
connect c##kelvin/kelvin@servername

--login as dba
connect c##kelvin/kelvin as sysdba

08 switch user

conn anotheruser/pwd  --'conn' equal 'connect'

for reference:[url]http://blog.youkuaiyun.com/qq_35624642/article/details/52771023[/url]