For any business and Advertisement related queries contact us on : Admin ProgrammerWorld. Web This Site Submit search form. ProgrammerWorld DevelopersVoice Faq. Net Health. Net Tips. Installing Oracle 10g — step by step guide Introduction:. All Rights Reserved.
Government or anyone licensing it on behalf of the U. Government, the following notice is applicable:. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations.
No other rights are granted to the U. This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury.
If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation.
This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services. The bit database client runs on both bit Windows and Windows x See Also: The following Windows 8 - Pro and Enterprise Editions Windows 8.
Note: This requirement is for design-time development, deployment, and run-time. Note: These requirements are for design-time development and deployment. They are not required for run-time. For run-time, you only need to have.
Visual Studio or higher is not necessary for run-time. NET, including download and installation instructions. Oracle strongly recommends that you upgrade to one of the required operating systems identified in "System Requirements". However, if you cannot upgrade, then Oracle recommends that you enable the firewall and ensure that port or the Oracle listener port you configured during installation is blocked.
To perform a graphical user interface installation: Log on to Windows with Administrative privileges. Description of the illustration welcome1. Description of the illustration destination. The following port numbers are the default values: Oracle database listener Oracle Services for Microsoft Transaction Server HTTP port for the Oracle Database XE graphical user interface If these port numbers are not currently used, then the installation uses them automatically without prompting you.
Description of the illustration password. Check the response file and modify the settings if necessary. Run the installation executable with the appropriate response file. Note: The setup. A result code of 0 means the installation succeeded. To enable the. OracleXEClrAgnt for. NET Developer's Guide. Security Note: With remote HTTP access to Oracle Database XE, all information exchanged between the browser and the database is in clear text—that is, unencrypted—including database user names and passwords.
If this is cause for concern, do not enable remote HTTP connection to the database. Select Oracle Database 11g Express Edition. Run the setup. All generated files get deleted if XE MSI version 2. Specifies the language for displaying product messages, day names, and month names in SQL. Specifies the cultural-specific conventions for date, number, time, and monetary formatting. It also includes the client component of Oracle Database XE, so that you can connect to the database from the same computer on which you installed the server component, and then administer the database and develop Java,.
Oracle Database Client provides drivers, networking components, and tools that enable you to remotely administer the database and to develop Java,. Use this installation executable only on remote computers—that is, only on computers on which you do not install Oracle Database XE Server. You can use either of the following PHP products:.
The Oracle Database XE installation checks your system for the following kernel parameter settings. If the kernel parameters of your system are less than the values listed in Table 3 , then the installation will modify the kernel parameter setting to use the values in this table. Ensure also that cookies are enabled. The following browsers meet this requirement:. Under Category, click the Advanced category to expand it, and then select Proxies.
On a single computer, only one installation of the Oracle Database XE software can be performed. In addition, users can run only one instance of the Oracle Database XE database on each individual computer. If the user data grows beyond this limit, then an ORA error will appear. To find this value, follow these steps after you have installed Oracle Database XE:.
The Oracle Database XE Server installer creates both server and client components in one installation. If you plan to use Oracle Database XE as a standalone product, you only need to install this server component, not the client component that is described under "Installing Oracle Database XE Client". If you have an existing version of Oracle Database XE, you can save your data by exporting it to data files. After you install the new version of Oracle Database XE, you can import this data into the new database.
If you downloaded the oracle-xe-univ If you need to change the configuration settings, then you can do so by running the following command:. To perform a silent installation of Oracle Database XE Server, you need to create a response file and a wrapper shell script to perform the silent installation. The silent installation response file handles the configuration information. After downloading the installation executable described under "Procedure for Installing Oracle Database XE Server" , create a response file that contains settings for the following values:.
Yes y or no n , to specify whether you want to start Oracle Database XE automatically when the computer starts. After you complete the silent installation, set the Oracle Database XE Server environment variables, which is described next. They do not need to log on with root permissions to do so.
Oracle Database XE provides a script that sets the necessary environment variables. You may also want edit your login or profile files so that these environment variables are set properly each time you log in or open a new shell.
For Bourne, Bash, or Korn shell, enter the following line into the. For C or tcsh shell, enter the following line into the. After you install Oracle Database XE Server, its graphical user interface is only available from the local server, not remotely. Click Downloads and follow the instructions to download one of the following installation executables:. For all other supported Linux operating systems: oracle-xe-client After you have installed Oracle Database XE, the database is up and running and you can begin using it right away.
If Oracle Database XE Server is on your local computer, then you can enter localhost as the host name. If you want another user to access your Oracle Database XE installation, then provide the host name or IP address of your computer.
The person installing Oracle Database XE set this port number during configuration. Normally it is set to You learn how to start Oracle Database XE and create a small application.
To access this manual and the rest of the documentation set, click Documentation under External Links on the Database Home Page. When you deinstall Oracle Database XE, all components, including data files, the database, and the software, are removed. If you want to save your data files but remove the Oracle Database XE software and database, then first export the data by using one of the methods described in Oracle Database Express Edition 2 Day DBA before you deinstall. Because the deinstallation process removes all files from the directory in which Oracle Database XE is installed, back up any files from the directory if needed before you deinstall.
Run one of the following commands to deinstall the Universal character set version of Oracle Database XE:. If the deinstallation is interrupted, follow these steps to manually remove Oracle Database XE from your computer:.
The following steps provide a method of preserving your database data when you deinstall and then reinstall the same release of Oracle Database XE Server. Create a directory in a location that is outside the standard Oracle Database XE directory structure. This directory will be the new location for the flash recovery area.
Perform a complete backup of the database to the new flash recovery area by running the Backup Database command from the desktop.
See "Backing Up the Database," in Chapter 11, for instructions. Ensure that you see the message Backup of the database succeeded before proceeding. When the restore script prompts you for the flash recovery area location, enter the full path to the directory that you created in Step 1. If you find any security vulnerabilities with Oracle Database XE, then send a description of the problem to Oracle at the following e-mail address:.
The database is created using a multibyte AL32UTF8 character set, which is suitable for global data in any language. This section explains how to configure globalization settings for both the server and client components of Oracle Database XE. It covers the following topics:. Oracle provides globalization support that enables users to interact with a database in their preferred locale and character set settings. It sets the language and territory used by the client application and the database server.
0コメント