Your company plans to upgrade from Oracle 9i Database to Oracle Database 10g software. To
test the applications running on Oracle 9i Database for the new release, you set up the Linux
machine with the following settings:
1) Oracle 9i database with ORACLE_HOME as /u02/app/oracle/product/9.2.0 and
ORACLE_SID=test
2) Oracle 10g database with ORACLE_HOME as /u02/app/oracle/product/10.2.0 and
ORACLE_SID=test1
There are some users working on the application, who would work on both the databases and
have the same usernames. What changes would you make to accomplish the task? (Choose
all that apply.)
A.
Ensure that the /etc/oratab file has an entry for both the databases.
B.
Customize the oraenv script, and then call the script from the .bashrc login script in the current
shell.
C.
Edit the dbhome file to add an entry for both the databases, and then call the script in the
.bashrc login script.
D.
Create a script that prompts for ORACLE_SID, and then call the script in the .bashrc login
script in the child shell.