Oracle Learning Note-1 Win7 installation of Oracle 10g

Source: Internet
Author: User
Tags sqlplus

SOURCE program AcquisitionDownload Oracle 10g from Oracle's official website:
    • 10203_vista_w2k8_x86_production_db.zip;==> Server (required)
    • 10203_vista_w2k8_x86_production_client.zip;==> client (useless, can not download);
Configuring Refhost.xml File Modification Decompression10203_vista_w2k8_x86_production_db.zip,find a refhost.xml under/db/disk1/stage/prereq/db. Under <CERTIFIED_SYSTEMS>, add a node with the following content.
  
 
  1. <!--Microsoft Windows 7-->
  2. <OPERATING_SYSTEM>
  3. <VERSION VALUE="6.1"/>
  4. </OPERATING_SYSTEM>
Similarly, there is a refhost.xml in/db/disk1/stage/prereq/db_prereqs/db, and the same changes are made to it.
Oraparam.ini File ConfigurationUnder/db/disk1/install There is a Oraparam.ini, find #windows=4.0,5.0,5.1,5.2 modified to #windows=4.0,5.0,5.1,5.2,6.1 at the end to add the following:
  
 
  1. [Windows-6.1-required]
  2. #Minimum display colours for OUI to run
  3. MIN_DISPLAY_COLORS=256
  4. #Minimum CPU speed required for OUI
  5. #CPU=300
  6. [Windows-6.1-optional]
Special Note: you will find[Windows-5.0-Required]and the[Windows-5. 1-Required]when the # is commented out, according to the process, if you find that the system is dependent on the 5.1 or 5.0, you need to delete the "#", so there will be no error. Oui.ui Error: You need to copy the installation files to a path that does not contain Chinese; specific installation
    1. Locate the setup application in the Oracle installation file, right-click, open the Compatibility troubleshooter, click on "Try suggested settings" and select "Start Program";
    2. Continue with the previous step of installation, install Oracle 10g until the Setup program finishes.
Possible error 1. Based on the installation of the above steps, Oracle is probably not working properly, at least at the end of my installation, my sqlplus will not work properly, this situation is related to the issue of permissions. This can be resolved by: a) Open the path of the Oracle program you have installed "\oracle\product\10.2.0\db_1\bin", click the Sqlplus.exe application, right-click-Properties, select compatibility, click " Run this program in compatibility Mode "Radio box, select" Windows XP Service Pack3 ", continue to click on the" Run this program as Administrator "box, and then click Apply-OK. b) So sqlplus can be used normally. 2. For some users who need remote access to the database, this configuration will also encounter a situation where the net configuration Assistant cannot be started, which requires finding "\oracle\product\10.2.0\db_1\bin" The Launch.exe application under the path, specifically configured as above 4. 3. In combination with the above configuration, the Oracle 10g database can be used normally. 4. For database developers, it is sometimes necessary to use database tools to manipulate databases, such as using the Plsql Developer tool. If you take advantage of the above Oracle installation configuration, you may not be able to use Plsql developer, which involves permissions issues, you can set compatibility and permissions for the "Plsqldev.exe" application. Specific operation, such as the last 4, after the installation of Oracle, you will be able to find that the boot is very slow, so it's okay, as long as the service to all Oracle services are set to Manual on the line, and so you need to use Oracle to start the service. Control Panel → system and security → management tools → services. Where ORACLEJOBSCHEDULERXSCJ is disabled by default, it is no longer set to manual. If you use only SQL Plus, then you just need to start ORACLESERVICEXSCJ and Oracleoradb10g_home1tnslistener. If you still need to use the web version of the OEM can restart ORACLEDBCONSOLEXSCJ, if you need to use Isql*plus, you can start Oracleoradb10g_home1isql*plus. So that we can do my job with the fewest resources.

From for notes (Wiz)

List of attachments

    Oracle Learning Note-1 Win7 installation of Oracle 10g

    Related Article

    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.