关于oraenv的用法

chenghuaming

[oracle@station36 ~]$ lsnrctl  service
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-NOV-2016 17:41:25
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "orcl.example.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB.example.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:972 state:ready
         DISPATCHER <machine: station36.example.com, pid: 6586>
         (ADDRESS=(PROTOCOL=tcp)(HOST=station36.example.com)(PORT=10244))
Service "rcat.example.com" has 1 instance(s).
  Instance "rcat", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "rcatXDB.example.com" has 1 instance(s).
  Instance "rcat", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:972 state:ready
         DISPATCHER <machine: station36.example.com, pid: 6578>
         (ADDRESS=(PROTOCOL=tcp)(HOST=station36.example.com)(PORT=38114))
The command completed successfully
[oracle@station36 ~]$
-------------------------------[root@station36 ~]# ls
aboutApplication  anaconda-ks.cfg  Desktop  install.log.syslog
[root@station36 ~]# . oraenv
ORACLE_SID = [root] ? orac
ORACLE_HOME = [/home/oracle] ?
[root@station36 ~]# su - oracle
[oracle@station36 ~]$ . oraenv
ORACLE_SID = [orcl] ? rcat
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@station36 ~]$ . oraenv
ORACLE_SID = [rcat] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
----------------
这两个实例都在，sqlplus这两库都可以正常使用，为什么还要通过. oraenv选择SID？

botang

是为了在这样的服务器上使用：
该服务器上运行着两个Oracle数据库服务器

在该服务器上登录后
.  oraenv用来方便地改ORACLE_HOME 和 ORACLE_SID这两个变量。
该命令的原理是：根据/etc/oratab中的信息，然后把这个信息翻译成ORACLE_HOME 和 ORACLE_SID这两个变量，之后改。

/etc/oratab中的信息是dbca写进去的。

如果你的服务器上只有一个Oracle数据库服务器，的确没有什么机会用到oraenv。（进+ASM也会用到oraenv）

chenghuaming

我已经建了orcl和rcat 两个库，这算两个数据库服务器吧，我不是对oraenv的怎么修改配置有疑问，我想知道oraenv选择orcl后，是rcat这个实例不能用，还是是其他的后果，区别在哪里

botang

chenghuaming 发表于 2016-11-18 12:36
我已经建了orcl和rcat 两个库，这算两个数据库服务器吧，我不是对oraenv的怎么修改配置有疑问，我想知道ora ...

rcat仍然可用，只是Linux shell登录默认进哪个的问题。