How to install different versions of oracle in windows
1. Use set oracle_sid = *** to redirect between oracle instances of different versions. 2. You may not be able to log on to the oracle instance in different oracle_home, and the network/admin/sqlnet. ora under this home is working;
I: \ oracle \ product \ 10.2.0 \ client_1 \ BIN> set oracle_sid = ora11g
I: \ oracle \ product \ 10.2.0 \ client_1 \ BIN> sqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Sunday August 12 07:30:36 2012
Copyright (c) 1982,200 5, Oracle. All rights reserved.
ERROR: ORA-12546: TNS: Permission denied
3. the current path of the cmd prompt is an oracle_home in oracle 11.1.0.1. After setting sid, you can enter the oracle instance of 11 GB. F: \ app \ Administrator \ product \ 11.1.0> set oracle_sid = ora11g F: \ app \ Administrator \ product \ 11.1.0> cd db_1 \ BIN
F: \ app \ Administrator \ product \ 11.1.0 \ db_1 \ BIN> sqlplus/as sysdba
SQL * Plus: Release 11.1.0.6.0-Production on Sunday August 12 07:28:16 2012
Copyright (c) 1982,200 7, Oracle. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
F: \ app \ Administrator \ product \ 11.1.0 \ db_1 \ BIN>
Cd ..
F: \ app \ Administrator \ product \ 11.1.0 \ db_1> Sqlplus/as sysdba usage: SQLPLUS [[<option>] [<logon>] [<start>] Where <option> :: =-H |-V | [[-L] [-M <o>] [-R <n>] [-S] <logon> :: = <username> [/<password>] [@ <connect_string>] |/NOLOG <start >::=@ <URI >|< filename> [. <ext>] [<parameter>...] "-H" displays SQL * Plus version labels and Syntax "-V" displays SQL * Plus version labels "-L" only attempts to log on once "-M <o>" use the HTML flag option <o> "-R <n>" uses restricted mode <n> "-S" uses silent mode
Note: The path value of the system variable in the windows environment variable is as follows:
F: \ oracle \ ora92 \ bin; C: \ Program Files \ Oracle \ jre \ 1.3.1 \ bin; C: \ Program Files \ Oracle \ jre \ 1.1.8 \ bin; D: \ oracle \ product \ 10.2.0 \ db_1 \ BIN; c: \ windows \ system32; C: \ Program Files \ IBM \ SQLLIB \ BIN; D: \ oracle \ product \ 10.2.0 \ db_1 \ bin; D: \ oracle \ product \ 10.2.0 \ db_1; C: \ Program Files \ Common Files \ Thunder Network \ KanKan \ Codecs; d: \ Program Files \ Sybase \ PowerDynamo \ win32
Combined with the experimental phenomena of 2 and 3, the following conclusions are drawn: When the sqlplus/as sysdba command in windows is issued, the system first looks for the sqlplus in the current directory. If not, find the system variable path in the windows environment variable.
