Oracle Log Full system disk is full, causing the database to hang up and the Archivelog log is full, but the database is not open, unable to login, fortunately, can also go to Mount state. Workaround:1. According to the error View appearance: CRS service downCrs-0184:cannot communicate with the CRS daemonDelete/var/tmp/.oracle DirectoryTo delete an Oracle ALTER L
In Oracle RAC, in addition to the TFA Method Based on the client, there is also the TFA Method Based on the server. You can regard the TFA method of the server as an upgraded version of the TFA method of the client. The TFA on the server must be configured on the server. This is done through the Service. This article mainly describes how to configure the TFA of the server through service in
Oracle RAC Load Balancing allows connections initiated from clients to be effectively allocated to instances with low listener load. There are two methods to achieve load balancing on the client. One is to configure the load_balance of the client, and the other is to configure the remote_listener parameter on the server. The two methods have their own advantages and disadvantages, and they are not mutually
In most businesses, the main business requirement for true Oracle Application cluster (RAC) configuration based on the Linux platform is the scalability of the database layer in the entire system-in this way, when the number of users increases, you can add additional instances to the cluster to distribute the load.
In Oracle
1. Clear TasksPrepare a RHEL5 PC to act as a San device, a SAN (both as a DNS and timing system)Prepare two RHEL5 PCs to act as RAC nodes, R1 and R2Install RAC on ASM disk, including OCR, voting, library2. Modify kernel parameters and shell limitations of R1 and R2On R1 and R2, respectively.Vim/etc/sysctl.conf------------------------------------------Kernel.shmmax = 4294967296Kernel.shmmni = 4096Kernel.shma
Tags: how Oracle database information is archivedOracle RAC Archive settings need to be less simple than single-instance setup, with some details to be noticed during the open processArchive Open Ideas:1: See if the database is open for archiving2: Create a shared directory (archive must be placed on shared storage)3: Set RAC to single-instance mode4: Close indiv
Environment:
Two HP ML570 Linux AS4.5 Oracle 10g
The two servers perform Oracle RAC and connect to HP MSA1000 through SAN Switch
Fault symptom:
Because the cabinet where one Oracle rac node is located is out of power, two rac
Tags: database oracle Oracle RAC Snapshot DBAStatspack is the product of the Oracle 9i ERA, and is the predecessor of AWR, which has a cross-milestone significance for monitoring and analyzing database performance. After the Oracle 10g, AWR replaced the statspack. Nonetheles
to make it easier for project team developers to use the oracle11g RAC database, install a client and configure Plsql to access the database server. Download The following three packages from Oracle official: Instantclient-basic-win32-11.2.0.1.0.zip This is the core package. Instantclient-jdbc-win32-11.2.0.1.0.zip contains the JDBC driver package Instantclient-sqlplus-win32-11.2.0.1.0.zip The simplest sqlpl
Install Oracle 10g + RAC in RedHat 5.5
The cost is relatively low, the technology is mature, and the function is powerful. This solution will become more and more favored by small and medium-sized enterprises.
I. Preparations before the experiment
Virtual Machine version: VMware server1.0.6
Linux version: RedHat 5.5 Enterprise Server version
Oracle 10g 10.2.1
RAC Local_listener, an Oracle appendix first a conversation: www.2cto.com cainiao asked: I set local_listener = 'listener1' In the parameter file, and then start the database to report an error. SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'listener1' syntax incorrect? Www.2cto.com old bird back: tnsnames to be on the se
The RAC nature is also a database, using a distributed lock manager. The DLM role is to coordinate competitive access to resources between instances, while competition within instances is the same as for single instances. In a RAC database, a node wants to modify the data, it needs to DLM send the request, through the DLM control the data access between the authorized node instances, the granularity of inst
1. Status of all instances and services
$ srvctl Status database-d ORCL
Instance ORCL1 is running on node linux1
Instance Orcl2 is running on node linux2
2, the status of a single instance
$ srvctl Status instance-d orcl-i Orcl2
Instance Orcl2 is running on node linux2
3, the state of the database global naming Service
$ srvctl Status service-d orcl-s orcltest
Service Orcltest is running on instance (s) Orcl2, ORCL1
4, the State of the node application on a specific node
$ srvctl Stat
1. Install Oracle 10g RAC in the Oracle Linux environment on the vmvm
This article references:
Http://www.oracle.com/technology/global/cn/pub/articles/chan-ubl-vmware.html
Http://www.oracle.com/technology/global/cn/pub/articles/smiley_rac10g_install.html
Precautions for installing Linux:
1. When installing Linux, install all "development" and "Legacy development"
Solutions to OUI-25031 during Oracle 10g RAC setup
The OS version is Enterprise Linux Server release 5.4.DB version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biWhen you install the clusterware component during RAC configuration, the following script execution prompt appears:
If the preceding error oc
Here a simple note, the National Day overtime recovery of a customer's 2 sets of Oracle RAC database, the entire recovery process, 2 sets of RAC similar, so here is a set of database recovery process as an example of simple analysis. Because the database is not archived, the system will not open properly due to power off and reboot.
In the normal open process, t
Tuning system time is not a trivial thing for a RAC environment, and Oracle is likely to reboot one of the nodes to ensure consistency between nodes.
The test found that if the system time is adjusted forward, no matter how long the adjustment will not cause the system to restart. However, if the system time is adjusted backwards, it will cause the whole node to reboot.
Even if you close the database, the
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.