linux 安装oracle可能遇到的问题

1. bash: sqlplus: command not found

解决方法：

[oracle@dg1 ~]$ sqlplus /nolog
bash: sqlplus: command not found
[oracle@dg1 ~]$ ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
ln: creating symbolic link `/usr/bin/sqlplus' to `/bin/sqlplus': Permission deni ed
[oracle@dg1 ~]$ su - root
Password:
[root@dg1 ~]# ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
[root@dg1 ~]# su - oracle
[oracle@dg1 ~]$ sqlplus /nolog

2. 需创建listener.ora

# listener.ora Network Configuration File: \u01\oracle\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.156.227)(PORT = 1521))
      )
    )
  )

3. Oracle创建用户

(1) DBA登录

C:\Documentsand Settings\Administrator>sqlplus /nolog

SQL*Plus:Release 10.2.0.1.0 - Production on 星期六 2月26 14:47:15 2011

Copyright(c) 1982, 2005, Oracle.  All rightsreserved.

SQL>conn / as sysdba

已连接。

SQL>

(2)创建表空间

create tablespace G3DATATEST

datafile 'D:\SERVER\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\G3DATATEST.dbf'

size 100M

autoextend ON

next 10M

maxsize200M;

默认为永久性的表空间。

(3)创建临时表空间

create temporary tablespace G3DATATEST_TEMP

tempfile'D:\SERVER\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\G3DATATEST_TEMP.dbf'

size 50M

autoextend ON

next 10M

maxsize100M;

(4)创建用户

create user G3DATATEST

identified by G3DATATEST

default tablespace G3DATATEST

temporarytablespace G3DATATEST_TEMP;

(5)授权用户

grant CONNECT,RESOURCE,DBA to G3DATATEST;

(6) 提交事务

commit;