一、场景：
早上在已装了10.2.0.1.0的数据库上，再装了个11.2.0.1.0的数据库.
10g默认的监听端口是1521,11g的默认监听端口是1522
oracle用户下的.bash_profile环境变量的设置我配成11g的。在shell环境下设置10g的$ORACLE_SID和$ORACLE_HOME,并且试图通过sqlplus / as sysdba 连接10g的数据库，出现下面的问题：
二、问题：
[oracle@localhost ~]$ cp bash_profile_11g .bash_profile
[oracle@localhost ~]$ su - oracle
口令：
[oracle@localhost ~]$ export ORACLE_BASE=/home/oracle/oracle;
[oracle@localhost ~]$ export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
[oracle@localhost ~]$ export ORACLE_SID=steel;
[oracle@localhost ~]$ sqlplus / as sysdba
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
SP2-1503:无法初始化oracle调用界面
SP2-1502: oracle 不能正常工作
三、解决办法：
1. 启动10g:
[oracle@localhost ~]$ cp bash_profile_10g .bash_profile
[oracle@localhost ~]$ su - oracle
口令：
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 24 15:07:04 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
2.启动11g:
SP2-0152: ORACLE may not be functioning properly
[oracle@localhost ~]$ cp bash_profile_11g .bash_profile
[oracle@localhost ~]$ su - oracle
口令：
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 24 15:08:44 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
阅读(754) | 评论(0) | 转发(0) |
