在Solaris机器上手工配置数据库的问题

sun.betty

环境:
$ uname -a
SunOS solaris-30 5.8 Generic_108528-01 sun4u sparc SUNW,Ultra-5_10
$
Oracle version : Oracle 9.2.0
状态: 刚安装完毕想通过手工方式来建立数据库
more .profile
ORACLE_BASE=/export/home/oracle
ORACLE_SID=fsid
ORACLE_HOME=$ORACLE_BASE/product/9.2.0
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
JAVA_HOME=/usr/j2se
PATH=$ORACLE_HOME/binJAVA_HOME/bin{PATH:-/usr/bin:.}
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/libORACLE_HOME/ctx/lib
ORACLE_TERM=vt100
NLS_LANG=American_america.WE8ISO8859P1
TMPDIR=/export/home/src/tmp
TNS_ADMIN=$ORACLE_HOME/network/admin
ORA_DB=$ORACLE_HOME/dbs
NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

export ORACLE_BASE ORACLE_SID ORACLE_HOME ORA_NLS33 PATH
export LD_LIBRARY_PATH ORACLE_TERM NLS_LANG TMPDIR TNS_ADMIN ORA_DB NLS_DATE_FORMAT

DISPLAY=10.10.10.169:0.0
export DISPLAY

ORACLE_OWNER=oracle
export ORACLE_OWNER

出现情况:

$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Aug 9 19:39:34 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL>; CREATE DATABASE fsid DATAFILE '/export/home/oracle/oradata/fsid/archive/fsid_01.dbf' size 500k REUSE AUTOEXTEND OFF
  2  LOGFILE '/export/home/oracle/oradata/fsid/archive/log1.rdo' size 100k REUSE ,
  3          '/export/home/oracle/oradata/fsid/archive/log2.rdo' size 100k REUSE ,
  4          '/export/home/oracle/oradata/fsid/archive/log3.rdo' size 100k REUSE
  5  MAXDATAFILES 128
  6  MAXINSTANCES 8
  7  MAXLOGHISTORY 100
  8  MAXLOGMEMBERS 2
  9  MAXLOGFILES 64
10  CONTROLFILE REUSE
11  CHARACTER SET WE8ISO8859P1 ;
CREATE DATABASE fsid DATAFILE '/export/home/oracle/oradata/fsid/archive/fsid_01.dbf' size 500k REUSE AUTOEXTEND OFF
*
ERROR at line 1:
ORA-01034: ORACLE not available


SQL>;
查看: 错误信息
ORA-01034 ORACLE not available

Cause: Oracle was not started. Possible causes include the following:

The SGA requires more space than was allocated for it.
The operating-system variable pointing to the instance is improperly defined.
Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation.

针对第一个可能原因:
$ df -k
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/dsk/c0t0d0s0    1586070  993606  529022    66%    /
/proc                      0       0       0     0%    /proc
fd                         0       0       0     0%    /dev/fd
mnttab                     0       0       0     0%    /etc/mnttab
swap                  684000       0  684000     0%    /var/run
swap                  684008       8  684000     1%    /tmp
/dev/dsk/c0t0d0s7    6631453 4305269 2259870    66%    /export/home
$
/export/home 可用空间还有2G

针对第二个可能原因:配置文件 .profile 没有错误啊！
那位大侠知道还有什么可能的查出问题所在的线索？

Ryker

重建库吧