1. Use set oracle_sid=*** to jump between different versions of Oracle instances. 2. In different oracle_home may not be able to log on to Oracle instances, at this time the home under the Network/admin/sqlnet.ora 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 07:30:36
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR: ora-12546:tns: Permission denied
3. The current path to the CMD prompt is a oracle_home,set sid for Oracle 11.1.0.1, enabling access to 11g Oracle instances, 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, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith The partitioning, OLAP, Data Mining and Rea L Application Testing Options
Sql> exit from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith The partitioning, OLAP, Data Mini NG and Real Application testing options Disconnect
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 the version of Sql*plus and uses the syntax "-V" to display the version of Sql*plus "-l" only attempts to log in once "-M <o>" using HTML flag options <o> "-R <n>" uses restricted mode <n> "-S" uses silent mode
Note: The value of the system variable path in the environment variable for Windows 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: the Sqlplus/as sysdba command under Windows is issued, the system first looks for the current directory under the Sqlplus, if not, and then from the Windows environment variables in the system variable path to find.
A little experience of installing different versions of oacle under Windows
