Useful Tips

Overview and installation of Oracle Database Express Edition 11g Release 2 on Windows 7

Pin
Send
Share
Send
Send


PROBLEMS SETTINGS Oracle 11g Express Edition

Emelyanova E., 3rd year student of the specialty "Information Systems"

KSU named after A. Baitursynova

Bevz I.A., Art. Lecturer at the Department of IS KSU named after A. Baitursynova

The Oracle 11g Express Edition database management system (Oracle Database XE) is one of the most powerful relational database management systems. Oracle Database XE is easy to install, easy to administer, and easy to create applications for.
In Oracle Database XE, you use an intuitive, user-friendly web interface. Oracle Database XE provides faster performance, better data protection, and application reliability. When installing Oracle 11g Express Edition, you may encounter a number of errors. Some of them are presented below.

When installing Oracle Database on a Windows machine, an error message is displayed:

OUI-10133: Invalid staging area. There are no top level components for Windows NT, Windows 2000 available for installation in this staging area.

The causes of the error can be many, but the main ones:

- The product.xml file is missing or not found. The oraparam.ini file contains an incorrect location for the product.xml file, or the product.xml file is not present at all in the distribution

- Someone accidentally deleted the product.xml file and OUI cannot find it.

- By downloading the distribution kit from e-delivery.oracle.com, which is located in several archives, each of the archives was unpacked into a separate directory.

- The distribution of the product is damaged.

- The distribution media is damaged.

1. Open the oraparam.ini file and verify that the paths are correct.

2. Verify that the location of the products.xml file is correct.

3. Go to the location of the products.xml file and verify that it exists. The main reasons for its absence may be: when copying the distribution kit, it was not completely copied, someone deleted the file, etc.

4. If you downloaded the distribution kit from e-delivery.oracle.com, and unpacked the resulting archives in different places, you need to unpack them into one directory in order to assemble the full distribution kit and restart the installation.

5. After downloading the distribution, check the checksum of the file, and compare with the amount indicated on the download page.

6. Get a new copy of the distribution.

Many people have a question, what needs to be deleted in the registry so that Oracle reappears normally?

Delete algorithm for (win):

1. Open the services folder (somewhere in the control panel).

2. We write down on paper or copy in notepad all the services in the name of which the word oracle is found.

3. Open the registry and look for branches with the names of services and delete them.

4. There, in the registry, delete the HKEY_LOCAL_MACHINE SOFTWARE ORACLE branch.

5. Delete the folder C: Program Files Oracle.

6. Delete the folder ORACLE_HOME .

7. Reboot the computer. We check the absence of Oracle records among the services.

8. If the removal was complete, then we can assume that the Oracle on your machine has never happened.

The following error may also occur during installation:

Firstly, put 64-bit ORACLE on the 64-bit axis, and also do not use paths with Russian names.

You can simply click the Ignore button, but after ignoring the error on the path and continuing the installation, ORACLE may display a message about the absence of many files.

You need to drop the contents of PATH, apparently there is no ORACLE_HOME / BIN.

During installation, a problem of the following nature may occur:

Checking operating system requirements.

Expected result: One of 5.0,5.1,5.2,6.0

Actual Result: 6.1

Check complete. The overall result of this check is: Failed

In order to get around this and install it, you need to do the following:

And add or change one of the values:

When installing oracle 11g for 32-bit on Windows 7, Home Basic 32-bit. In the beginning, before installing it, it checks the compatibility with the system. Verification fails. Writes:

Checking operating system requirements.

Expected result: One of 5.0,5.1,5.2,6.0

Actual Result: 6.1

Check complete. The overall result of this check is: Failed

Problem: Oracle Database 11g is not certified on the current operating system.

Recommendation: Make sure you are installing the software on the correct platform.

- the installer automatically creates a folder in Russian (by user name), after renaming to English, the problem is fixed.

What is Oracle Database?

Oracle Is the world's largest enterprise software company. Oracle's specialization is the development of database management systems such as Oracle Database, as well as other business applications.

Oracle Database Is an object-relational database management system (RDBMS or Relational DataBase Management System) Many of the largest companies in the world choose Oracle Database as the database.

In the name of each version, we observe the version number and letter, for example 11g, where g is “gr>. In 2013, version 12c was released, where c means cloud (cloud).

This DBMS supports many platforms, for example: Linux x86, Linux x86-64, both 32-bit Windows and 64, Solaris x86, Solaris SPARC (64-bit), Mac OS X Server and many others.

Oracle Database uses the PL / SQL programming language (Procedural Language / Structured Query Language) Is an extension of the SQL language developed by Oracle. For example, Microsoft also developed the Transact-SQL language for its DBMS. We analyzed it in detail in many articles and even compiled the Transact-SQL Reference.

Oracle Database is shipped in the following editions:

  • Oracle Database Enterprise Edition
  • Oracle Database Standard Edition
  • Oracle Database Standard Edition One,
  • Oracle Database Personal Edition,
  • Oracle Cloud File System,
  • Oracle Database Mobile Server,
  • Oracle Database Express Edition.

Oracle Database Express Edition

Oracle Database Express Edition (Oracle Database XE) Is a free version of the Oracle Database for beginners and administrators who, if they master this DBMS, can easily upgrade to the full version.

Since this version is free, it naturally has limitations:

  • She will use no more than 1 gigabyte of RAM,
  • It will also use only one processor,
  • Just one database no larger than 11 gigabytes in size,
  • It can only be installed on Windows x32, Windows x64, and Linux x86-64.

At the moment, the latest version is Oracle Database Express Edition 11g Release 2, so it’s what we will install, but first, let's find out where to get this software.

Comparison of Oracle XE 10 and XE 11.

XE 10

XE 11

Windows x86, Linux x86

Windows x86, Linux x64

Western European 1252, Unicode

Number of processors used RAM Number of database instances User data * Embedded Java Machine ** Oracle Support

* - the restrictions also apply to the physical size of the database (without TEMP and UNDO table spaces), the value is not exactly defined (about 12 GB).
** - A complete list of options not included can be found in the Licensing Information.

Notes before installation.

  • All database administration tasks, according to Oracle documentation, are performed using sqlplus and SQL Developer. Through APEX, you can only view information about disk space usage (Storage), current sessions (Sessions) and database parameters (Parameters).
  • The current version of APEX is 4.1 (09.2011), used in Database Express Edition is 4.0.2.
  • The recreated database will be installed instead of the pre-installed one, so as not to configure the listener (OracleXETNSListener) and Oracle Net, and not to create a new directory structure.
  • The recreated database will use pfile instead of spfile, the options for archiving online logs and database files will be disabled

2. Deleting a preinstalled database instance:

- Launch the console (Start, Run, cmd) (if Vista and higher, then run as Administrator).

- Set variables for working with an XE instance

- Delete XE instance

CMD> oradim -delete -sid XE

- Delete password file

- Do not close the console, it will be used in the future.

3. Create a parameter file for the new XE instance.

Example Instance Parameter File init.ora located in% ORACLE_HOME% config scripts

Rename the file to initXE.ora and copy instead of the existing one in the% ORACLE_HOME% database folder

Example initXE.ora file (changed and added parameters are highlighted in red):
open_cursors = 300
db_name = XE
control_files = ("C: oraclexe app oracle oradata XE control.dbf")
job_queue_processes = 4
compatible = 11.2.0.0.0
diagnostic_dest = C: oraclexe app oracle .
memory_target = 1G
sessions = 100
audit_file_dest = C: oraclexe app oracle admin XE adump
remote_login_passwordfile = EXCLUSIVE
dispatchers = "(PROTOCOL = TCP) (SERVICE = XEXDB)"
shared_servers = 4
undo_management = AUTO
undo_tablespace = UNDOTBS1
DB_RECOVERY_FILE_DEST_SIZE = 10G
DB_RECOVERY_FILE_DEST = C: oraclexe app oracle fast_recovery_area
nls_language = "RUSSIAN"
nls_territory = "RUSSIA"

4. Creating a new XE instance

CMD> oradim -new -sid% ORACLE_SID% -intpwd admin -startmode auto -srvcstart system

After creation, you need to verify that the OracleServiceXE service is created and the password file% ORACLE_HOME% database Pwdxe.ORA

Stop the instance and delete the database files that will be recreated when the database is created:

CMD> sqlplus / nolog
SQL> connect sys / admin as sysdba,
SQL> shutdown immediate,
SQL> exit
CMD> del% ORACLE_BASE% oradata XE CONTROL.DBF

5. Creating a database.

To create, use the createXE.cmd command file, in which environment variables are set, and the createXE.sql database creation script is called.

CreateXE.cmd batch example

- The Workspace Manager and JServer options that are not supported by the XE edition are not included in this scenario compared to a regular database.

- There is no APEX, which in this version is not used for administrative purposes, as it was in version 10g. Information about the use of disk space (Storage), current sessions (Sessions) and database parameters (Parameters) provided by APEX can be replaced by the following queries (from the sys user session):

- You can install the current version of Application Express for your APEX applications.

6. Installing SQL Developer Application

- Download the distribution "Oracle SQL Developer for 32-bit Windows includes the JDK "from the Oracle site.

(The “Oracle Database Express Edition 11g Release 2 for Windows x86” also includes a 32-bit client, which only 32-bit SQL Developer will work with).

- Unpack the archive, for example, in the directory C:

- In order to prevent the error "ORA-12705 cannot access NLS data files or invalid environment specified", add the following lines to the sqldeveloper.conf configuration file:
AddVMOption -Duser.language = en
AddVMOption -Duser.region = US

- Set up a connection to the XE database for the administrator (sys)

Pin
Send
Share
Send
Send