Alibabacloud.com offers a wide variety of articles about oracle 11g end of support, easily find your oracle 11g end of support information here online.
1, download Oracle 11g R2 for Windows version
Download Address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
This includes two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip
2, the two compressed packets to the same directory, that is, "database", and then click the Extract directory under the "setup.exe" file:
Des
used and that the different invocations of the statement use the same execution plan. A bound peek is no longer useful for generating a valid execution plan if different invocations of the statement derive significant benefits from different execution plans.
A schedule does not always apply to all bound values, and in order to resolve this problem as much as possible, Oracle Database 11g introduces adapti
Oracle Data Guard is an important component of the Oracle HA Architecture system and a key technical solution for Maximum Availability Architecture. With the Switchover and Failover features of Data Guard, we can achieve high availability requirements for O M systems and minimize planned and unplanned downtime.Data Guard is built on the Database software and hardware and Data redundancy policies. It builds
) (PORT = 1521)) (connect_data = nbsp; (SERVER = dedicated) (service_name = oracle.bak) ) oracle Home is the Oracle client path, mine is e:\oracle\instantclient _12_1,oci Library is e:\oracle\instantclient_12_1 \oci.dll. With these two things you should be able to access someone else's
Oracle 11g Data guard based on the same host
1. Restrictions on logical standby DatabasesThere are many restrictions on the logical standby database. For example, some special data types such as object, nested table, rowid, object type, and custom data type are not supported, andIt supports segment compression and does not support a lot of things such as some s
localhost Localhost.localdomain Localhost6 localhost6.localdomain6Add the last line in the/etc/hosts file:192.168. 121.159 Bogon2, the establishment of script build.sh,# vim build.sh #注意以root登陆执行Paste the following code in:#!/bin/bash#安装基本依赖库Yum-y Install UnixODBC yum-y install unixodbcyum-y install unixodbc-devel yum-y Install Unixodbc-develYum-y Install Elfutils-libelf-develYum-y Install LIBXP #注意: Need to install LIBXP This library, this must be installed, otherwise install
Install Oracle 11G Release 2 (11.2) on Centos Linux 7This article presents what to install the Oracle 11G on Centos Linux 7.read following article How to install CentOS Linux 7:install CentOS Linux 7
(for comfort set 2G memory for your vsan before proceeding with Oracle
Tags: Oracle Linux due to project requirements, the need to install Oracle 11g on 64-bit Linux systems, a lot of content on the Internet, combined with their own practical experience, finally installed successfully, recorded, and shared to the needy comrades. First, installation Preparation If you are using a text-interface Linux, install the Linux GUI first. Bec
New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp in the Development Library
2. Delete the Test Database User
3. Use imp to import exported data to the Test Database
T
path above, find the executable installation file "setup.exe" double-click the installation. There will be a test process in the middle: 2. Detailed installation steps begin: (1) Install first step: Configure security updates. This step can fill in your e-mail address (or you can not fill in, just received some useless mail only). Cancel the "I want to accept security update (W) through my Oracle support
Installing Oracle 11g R2 in LinuxI. installation environment
Linux Server: CentOS 6.4 64-bit
Oracle Server: Oracle 11gR2 64-bitIi. System Requirements
Requirements for installing Oracle in Linux
System Requirements
Description
Memory
Physical memor
enter a short password that you normally use, and you don't have to add numbers to the 8-bit size that Oracle recommends. Oh. Note: Sys/system, also modify the new password, confirm the password. 15. Similarly, passwords that do not conform to the rules are prompted. Don't worry about it, continue Y. 16. The installation is successful and complete. It's simple, hehe. three. After installation, access to the test can be done by starting, "
for many sites. ASM can be managed through Sql*plus, Enterprise Manager (Dbconsole), or DBCA. In Oracle 11g Release 2, ASM is now part of the grid infrastructure, whether in a single-instance or RAC environment. A new configuration Assistant ASMCA accepts and expands the functionality provided in the 11.1 dbca. ASM can no longer be launched from outside the RDBMS Oracl
Kernel.shmmax = 2147483648 Kernel.shmmni = 4096 Kernel.sem = 32000 Net.ipv4.ip_local_port_range = 9000 65500 Net.core.rmem_default = 4194304 Net.core.rmem_max = 4194304 Net.core.wmem_default = 262144 Net.core.wmem_max = 1048576
5) Edit/etc/profile, enter the command: Vi/etc/profile, Press the I key to enter the editing mode, the following content to join the file.
if [$USER = "Oracle"]; The
1. directpath reads description
In versions earlier than Oracle 11g, if a full table scan is performed on a large table, the wait event is: DB file scattered read; in 11g, if a full table scan is performed on a large table, wait event is: direct path read; that is, in 11 GB, full table scan of large tables directly reads data blocks into the PGA region of the se
will appear when the Java exception# to log on as the root user/usr/sbin/Groupadd dba/usr/sbin/Groupadd Oper/usr/sbin/groupadd oinstall# Adding Oracle user useradd Oracle/usr/sbin/usermod-g Oinstall-G dba oracle# add password to Oracle user Passwdecho passwd|PASSWD--stdin oracle
of the Oracle database is completed. Finally, the installation interface of Oracle is as follows:
Now we have completely completed the installation of Oracle 11g. At this time, we found the "password management" button. in Oracle 11g
data sourceGo to Control Panel/Administrative Tools/Data source (ODBC)/System DSNClick Add, select MicroSoft ODBC for Oracle, and then pop up a dialog box to fill in the following.1, data source name: MYORACLESRC can be casually up, the client program will use it.2, Description: A description of the text, you can read it.3, User name: Mytestuser the user name recognized by the database that you end up need
"Introduction to this article"Recently, because of the needs of a project, from zero to learn from Oracle, now learn to share a record of things.The first is the installation, in the WIN8 installed 10G has failed, online various methods have tried, and finally have to give up, choose 11G.The installation of 11G is very simple, basically is "next"-"complete" mode, this article just describes which steps need
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.