ORACLE 11g 2 研究，redhat5.4

1、安装oracle（参考官方英文文档）

安装的时候，把redhat5.4的版本号改为4.5

(root 权限登录，vi /etc/redhat-release)

SQLPLUS 登录

sqlplus /nolog

conn / as sysdba

 conn zkeco/zkeco2012

2、listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =localhost.domain)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1/)
      (SID_NAME = ORCL)
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

tnsnames.ora :

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.domain)(PORT = 1521))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.domain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

/etc/host

127.0.0.1               test.localdomain test
192.168.10.178          localhost.domain localhost
::1             localhost6.localdomain6 localhost6

3、//创建临时表空间

create temporary tablespace test_temp
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

//创建数据表空间
create tablespace test_data
logging
datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

//创建用户并指定表空间
create user user_test identified by 123456
default tablespace test_data
temporary tablespace test_temp;

//给用户授予权限

grant connect,resource to user_test;

//以后以该用户登录，创建的任何数据库对象都属于test_temp 和test_data表空间，这就不用在每创建一个对象给其指定表空间了。