How to install different oracle versions in windows

Source: Internet
Author: User

How to install different oracle versions 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.