Linux Redhat AS3上安装Oracle9204的问题

Yicho

操作系统：Redhat Enterprise Linux Advanced Server3
数据库： Oracle9204

数据库文件：
ship_9204_linux_disk1.cpio.gz
ship_9204_linux_disk2.cpio.gz
ship_9204_linux_disk3.cpio.gz
补丁：
p3006854_9204_LINUX.zip
p2617419_220_GENERIC.zip
p3238244_9204_LINUX.zip

具体安装过程，参照了
http://www.chinaunix.net/jh/19/363433.html
renxiao2003 的《在RHAS3上成功安装Oracle9204》

有几个地方说明一下
1。安装过程中
环境变量
export NLS_LANG=AMERICAN
2.在数据库安装过程中，数据库字符集选中自定义的 ZHS16GBK
安装结束后，没有报错。
重新启动计算机，以oracle 帐号登陆后，
[oracle]$lsnrctl start;
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 03-NOV-2004 21:06:18

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

Starting /u01/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /u01/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /u01/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                03-NOV-2004 21:06:18
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File         /u01/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "appserv2" has 1 instance(s).
  Instance "appserv2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

//以上都正常[oracle]$sqlplus "/ as sysdba";

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Nov 3 21:07:34 2004

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

Connected to an idle instance.

SQL>; startup;
ORACLE instance started.

Total System Global Area  219223120 bytes
Fixed Size                   451664 bytes
Variable Size             201326592 bytes
Database Buffers           16777216 bytes
Redo Buffers                 667648 bytes
ORA-12709: error while loading create database character set


SQL>;
//考虑到在.bash_profile中设置客户端字符集为export  NLS_LANG=AMERICAN, 我就修改成export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle]$source .bash_profile
[oracle]$echo $NLS_LANG
AMERICAN_AMERICA.ZHS16GBK
[oracle]$sqlplus "/ as sysdba";
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Nov 3 21:14:08 2004

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

ERROR:
ORA-12705: invalid or unknown NLS parameter value specified
//很显然刚才的修改有问题，改回 NLS_LANG=AMERICAN，Sqlplus能连上，但就是不能启动数据库
Enter user-name:

哪位朋友碰到过这种问题，如何解决的，还望指点一二，谢谢先。

justinz

我也碰到这种情况，没有办法重新安装的，另外如果就生成数据库，在选字符集的时候一定小心，要选UTF8,我的参数设置就是American.然后这个错误就过去了，祝你好运气。

honk

请留意下你的ora_nls33变量

Fenng

重来一遍吧

参考：

http://www.dbanotes.net/Oracle/Install-Oracle9iR2-RHEL3.htm