开始服务器上装的9i,然后装oracle10g软件用dbua工具升级9i,在升级成功后,在服务器上不能正常登录数据库了
安装配置如下:
oracle9i 的安装目录:
/u01/oracle/product/9.2.0
oracle10g 的安装目录:
/u02/oracle/product/10g
升级前的.bashrc文件配置:
[oracle@DB2 ~]$ cat .bashrc
# .bashrc
# User specific aliases and functions
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/product/9.2.0
export ORACLE_SID=ora9i
export NLS_LANG=american_america.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export PATH=$PATH:/usr/sbin:/etc:$ORACLE_HOME/bin
export LANG=en_US
#export LANG=zh_CN.GB18030
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
升级前的.bashrc文件配置:
[oracle@DB2 ~]$ cat .bashrc
# .bashrc
# User specific aliases and functions
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
export ORACLE_BASE=/u02/oracle
export ORACLE_HOME=/u02/oracle/product/10g
export ORACLE_SID=ora9i
export NLS_LANG=american_america.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export PATH=$PATH:/usr/sbin:/etc:$ORACLE_HOME/bin
export LANG=en_US
#export LANG=zh_CN.GB18030
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
我用有升级前和升级后的.bashrc环境变量登录都会失败:
升级前:
[oracle@DB2 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue May 4 13:30:07 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
升级后:
[oracle@DB2 ~]$ sqlplus "/as sysdba"
Message 133 not found; product=SQLPlus; facility=SP2
: Release 9.2.0.4.0 - Production on Tue May 4 13:32:22 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified
Enter user-name:
我不知道是哪的原因?应该怎么设置.bashrc环境变量才正确?