Chinaunix

标题: dbca 建库成功，但是在键入sys、system口令以后按下exit键时报错 [打印本页]

作者: rolentolch 时间: 2004-03-09 17:39
标题: dbca 建库成功，但是在键入sys、system口令以后按下exit键时报错
dbca建库100%成功，但是在键入sys与system口令以后按下exit键却报ora-00922错。

http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90202/e900.htm#ERRMG102

ORA-00922 missing or invalid option
Cause: An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error.
Action: Correct the syntax. Remove the erroneous option or length specification from the column or storage specification.

但是我不知道为什么会有这一个错，请各位帮忙，谢谢。

以下我的环境是9i on solaris8 sparc
[/etc/system]
set shmsys:shminfo_shmmax=1073741824
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=310 # 2*process+10
set semsys:seminfo_semmni=110 # process+10

[.profile]
PATH=/usr/ccs/bin

PATH:.

HOME/bin:/bin:/sbin:/usr/bin/:/usr/sbin:/usr/local/bin:/usr/local/sbin:ORACLE_HOME/bin

HOME/bin:/home/oracle/9.2.0.1/bin:/usr/local/SUNWappserver/jdk/bin;export PATH
unset LANGUAGE
unset LC_ALL
unset NLS_LANG
NLS_LANG=AMERICAN_AMERICA.we8iso8859p1;export NLS_LANG
LANG=C;export LANG

ORACLE_BASE=/home/oracle;export ORACLE_BASE
ORACLE_HOME=/home/oracle/9.2.0.1;export ORACLE_HOME
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_SID=ora9201;export ORACLE_SID
ORACLE_TERM=xterm;export ORACLE_TERM
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data;export ORA_NLS33
TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN
LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/sqlj/lib/runtime.zip

ORACLE_HOME/JRE

ORACLE_HOME/jlib

ORACLE_HOME/rdbms/jlib

ORACLE_HOME/network/jlib;export CLASS_PATH

JAVA_HOME=/usr/local/SUNWappserver/jdk ; export JAVA_HOME
PATH=$PATH:ORACLE_HOME/bin

HOME/bin:/home/oracle/9.2.0.1/bin:/usr/local/SUNWappserver/jdk/bin;export PATH
umask 022

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)