oracle rac troubleshooting

Tags: RAC failover Viewing listening, using a grid user 11GRAC1:11grac1->lsnrctlstatus lsnrctlforlinux:version11.2.0.3.0- Productionon14-aug-201500:30:26 copyright (c) 1991,2011,Oracle. allrightsreserved. connectingto (description= (address= (PROTOCOL=IPC) (Key=listener)) statusofthe LISTENER------------------------alias listener version tnslsnrforlinux: version11.2.0.3.0-production startdate

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

Database Version: Oracle 10.2.0.5 rac Operating system version: CentOS 5.6-64 1. Problems: 1) there are no errors in the background alter log 2) The mmon error message is as follows: * ** KEWRAFC: Flush slave failed, AWR Enqueue Timeout* ** 2013-02-17 10:46:15. 419* ** KEWRAFC: Flush slave failed, AWR Enqueue Timeout* ** 2013-02-17 10:47:15. 598* ** KEWRAFC: Flush slave failed, AWR Enqueue Timeout* ** 2013-

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

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

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

Tags: oracle RAC DeploymentLsb_release-aVmware-vdiskmanager.exe-c-S 20000mb-a lsilogic-t 2 D:\ORACLE_RAC\OCR.VMDKVmware-vdiskmanager.exe-c-S 20000mb-a lsilogic-t 2 D:\ORACLE_RAC\OCR2.VMDKVmware-vdiskmanager.exe-c-S 20000mb-a lsilogic-t 2 D:\ORACLE_RAC\VOTINGDISK.VMDKVmware-vdiskmanager.exe-c-S 30000mb-a lsilogic-t 2 D:\ORACLE_RAC\DATA.VMDKVmware-vdiskmanager.exe-c-S 20000mb-a lsilogic-t 2 D:\ORACLE_RAC\BACK

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

In 11.2, the CRSD process is no longer one of the most critical processes in RAC. If you are familiar with 10g RAC, you should be aware of the importance of the CRSD process, and Oracle starts the process and then launches the entire cluster and database after the operating system starts. In the 11.2 RAC,

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

) (HOST = RAC1-VIP) (PORT = 1521))(ADDRESS = (PROTOCOL = TCP) (HOST = RAC2-VIP) (PORT = 1521)))ALTER SYSTEM SET remote_listener = Listeners_rac;Sometimes the reporting load process delay leads to the balance effect is not obvious, when joined Prefer_least_loaded_node=off, the server will be allocated according to the number of connections.Starting with Oracle 10.2, Oracle introduced the load Balance Advisor

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

How to download the Grid method (Oracle RAC) on the OTN website, otngrid How to download grid software required by RAC Register an account and log on to the OTN website. Go to the download options and find the "server and storage system" item. Find Grid Infrastructure from the drop-down menu. After entering, remember to click "accept license" to download the

Notes for installing Oracle 11g RAC This article is only used to record some issues that occur during the installation of Oracle RAC at ordinary times. If you encounter minor issues, we will also add them.1. HAIP hosts file dual-inline Nic configuration example: # Vi/etc/hosts127.0.0.1 localhost. localdomain localhost1

listener:listenerunixdev$[/home/grid]srvctl config asm-n unixtestwarning:- /grid/11.2. 0/gridasm Listener:listener4. Display all registered databases in OCRunixdev$[/home/grid]srvctl config Databaseunixdev4.1 Viewing the RAC database details configurationUnixdev$[/home/grid]srvctl Config database-/oracle/app/product/11.2. 0 +data/unixdev/spfileunixdev.oraDomain:Start options:openstop options:immediatedat

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