Oracle's support strategy for its products is difficult for most people to figure out, for Oracle Database 11g support cycle, a lot of friends have raised objections, refer to some of the documents mentioned below, I hope to help you understand Oracle's product support strat
Tags: when case png shang pivot Red data row goto EnglishThe existing table, the original data is as follows: Now you need to query the following results (conditions are: [80,~] Excellent, [60,80) pass, [~,60] failed):The original table is converted with UNPIVOT, and the line changes to select * from CB_SHANGCICB UNPIVOT ("language", "math", "English"), and the results are as follows: The CJ is then matched with the band TT as (select * FROM Score Unpivot (CJ-KC in ("Language", "math", "English"
mechanism on the single-instance database is also reliable on the RAC.Background processes that support GCS and GES use the private network heartbeat to communicate between instances. This network is also used by Oracle's cluster components and may be used by clustered file systems such as OCFS. GCS and GES run independently of the Oracle cluster components. However, GCS and GES rely on these cluster compo
Oracle's latest database products began to enter beta status at the end of last year, with Oracle releasing hundreds of feature improvements in the initial beta release. As one of the world's largest market share database products suppliers, Oracle's new version of the product can be described with great attention, currently can be determined that the name of this product will be
Windows 10 x64 installation and configuration of Oracle 11g process records (Graphic tutorial), Windows 10 11g
Note: I want to install an oracle exercise on my computer, but I am afraid of problems during the installation process, and oracle uninstallation is notoriously tro
availability and scalability. Oracle database 10g and ORACLERAC 10g significantly reduce operational costs and increase flexibility, giving the system greater adaptability, foresight, and flexibility. Dynamically providing nodes, storage, CPU, and memory can reduce costs by increasing utilization while achieving the required service levels.RAC Integrated cluster Components managementOracle RAC 10g provides a fully integrated cluster management soluti
-Firewall-1-INPUT -m state –state NEW -m udp -p udp –dport 177 -j ACCEPT
:wq! #Save exit
Service iptables restart #restart
Shutdown -r now #restart the system
Second, install Xmanager on the Windows client system
1. Download and install Xmanager Enterprise 3
2. After downloading the installation software, open Xmanager Enterprise
3, then open Xbrowser, as shown below:
Install Oracle 11g R2 and oracle11g in Redhat Linux
Official documents: http://docs.oracle.com/cd/E11882_01/nav/portal_11.htm
1: Basic Environment
Redhat Enterprise Linux 6.132bit
Memory: 1 GB
Disk Space: 30 GB
2: Check the packages required for Oracle 11G. If the packages are not found on the Redhat Enterprise Linux 6
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R
11g is 142. Semmns parameter: Sets the maximum number of semaphores in the system. The recommended Semmns value is set to semmsl*semmni,oracle the recommended semmns setting is not less than 32000. SEMOPM: Sets the maximum number of semaphore operations that can be run at the same time per system call. Oracle verifies that the 10.2 and 11.1 semopm are configure
) wait for the installation. 19) Pop Up the dialog box, run the script statement at each node, running the configuration scripts on each node. (Unlike the general installation, this behavior must be run under all nodes as root under the following script statement ) Open each node, log in as root, and run "orainstroot.sh". # cd/u01/app/orainventory
for World .
/u01/app/orainventory to Oinstall.
is complete. The output of the root.sh w
)----Multiple instances to open a database• Stream----Multiple Oracle servers propagate transactions to one another• Data protection----The primary database to update the standby database Determine if it is a single instance Select parallel from V$instance; --NO Single InstanceSelect Protection_level from V$database; --Standby database protection, unprotected not protected SELECT * FROM dba_streams_administrator;--has not been configured and returns n
Data files, temporary data files, and data file copies
Online redo log, archive log, and flashback log
Disaster recovery Configuration
Change tracking bitmap
Data Pump dumpset
Oracle ASM will automatically generate the name of the Oracle ASM file when creating files and tablespaces. The Oracle ASM file name uses the plus sign (+.
), captures the information associated with the event, and automatically checks the database for health and notifies the DBA. In addition, this information can be packaged and sent to the Oracle support team.
Event Packaging Services (Incident packaging service)
If you need to test further or retain relevant information, this feature can package information related to an event. And you can also send packa
Although the oracle 11g Database provides the linux x86 version, only Red Hat, Novell and Solaris versions are supported. debian and ubuntu are not supported, therefore, it is relatively troublesome to install ubuntu. Please follow the steps below to install it step by step. Do not be impatient. Every step should be done carefully (it is a little urgent when I start to install it, simplify the steps and res
Installed Ubuntu 12.04 64bit, want to install Oracle 11GR2 on the above, find a lot of documents on the Internet did not succeed, and finally fully reference the Mordicusetcubitus article.Key points for a successful installation: Install additional packages, which handles the wrong method during link.Original: Http://www.makina-corpus.org/blog/howto-install-oracle-11g
come over. In the end, we can click on the "OK" button to complete the installation of Oracle.
After Setup completes, you can open Oracle 11g and, at first, you must pass in the Java run File "Java.exe", as shown in the following illustration:
Here is a description of the file path installed by my JDK: D:\Program fil
The Oracle 11g database provides a Linux x86 version, but the supported Linux versions are only red Hat,novell and Solaris, Debian and Ubuntu are not supported, so installing under Ubuntu is relatively cumbersome, Please follow the method step-by-step installation, do not be impatient, every step must be taken seriously (I began to pretend to be a little anxious, with their own method to simplify a few step
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:
and provide relevant evidence. A staff member will contact you within 5 working days.