- 論壇徽章:
- 0
|
操作系統(tǒng)：Redhat Enterprise Linux Advanced Server3
數(shù)據(jù)庫： Oracle9204
數(shù)據(jù)庫文件：
ship_9204_linux_disk1.cpio.gz
ship_9204_linux_disk2.cpio.gz
ship_9204_linux_disk3.cpio.gz
補(bǔ)�。�
p3006854_9204_LINUX.zip
p2617419_220_GENERIC.zip
p3238244_9204_LINUX.zip
具體安裝過程，參照了
http://www.chinaunix.net/jh/19/363433.html
renxiao2003 的《在RHAS3上成功安裝Oracle9204》
有幾個地方說明一下
1。安裝過程中
環(huán)境變量
export NLS_LANG=AMERICAN
2.在數(shù)據(jù)庫安裝過程中，數(shù)據(jù)庫字符集選中自定義的 ZHS16GBK
安裝結(jié)束后，沒有報錯。
重新啟動計算機(jī)，以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中設(shè)置客戶端字符集為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能連上，但就是不能啟動數(shù)據(jù)庫
Enter user-name:
哪位朋友碰到過這種問題，如何解決的，還望指點一二，謝謝先。 |
|
免費注冊
發(fā)表于 2004-11-03 21:20
