Selecting an Instance with Environment Variables (18)
Before you attempt to use SQL*Plus to connect locally to an Oracle instance, you must
ensure that environment variables are set properly. When multiple database instances
exist on one server, or when an Automatic Storage Management (ASM) instance exists
on the same server as one or more database instances, the environment variables
determine which instance SQL*Plus connects to. (This is also true when there is only
one Oracle instance on a server.)
For example, each Oracle instance (database or ASM) has a unique system identifier
(SID). To connect to an instance, you must at a minimum set the ORACLE_SID
environment variable to the SID of that instance. Depending on the operating system,
you may need to set other environment variables to properly change from one instance
to another.
Refer to the Oracle Database Installation Guide or administration guide for your
operating system for details on environment variables and for information on
switching instances.
使用环境变量选择实例
1. 环境变量决定了sqlplus连接哪个实例
2. 设置 ORACLE_SID 后环境变量后 , 相当于指向了那个实例(SID)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-994012/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002849
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
