rac configuration oracle 11g

Tags: Oracle CRSFor unknown processes to crs_stop-f the process nameStart againCRS failed to start Crs_start-all Crs-0184:cannot communicate with the CRS daemon.Because Crs_start is an application-level directive, it fails when it starts CRS[Email protected] ~]$ Crs_start-allCrs-0184:cannot communicate with the CRS daemon.[Email protected] ~]$ crs_stat-tCrs-0184:cannot communicate with the CRS daemon.Ps-ef |grep InitCRS has a high possible process to

Tags: Oracle RAC Archive1. Modify the archive Path parameterSqlplus/as SYSDBASql> alter system set log_archive_dest_1= ' Location=+asmarch ' scope=spfile sid= ' * ';2. Close the database and all nodes are closedSrvctl Stop database-d racdb3. Boot a node database to mount State 5 and modify the database's archive mode and start the databaseSrvctl start instance-d racdb-i racdb2-o Mountsql> ALTER DATABASE Arc

'*.diagnostic_dest= '/u01/app/oracle '*.dispatchers= ' (protocol=tcp) (SERVICE=BBDGXDB) '*.fal_client= ' BBDG '*.fal_server= ' Bbsvri1 '#*.log_archive_config= ' dg_config= (BBSVR,BBDG) '#*.log_archive_dest_1= ' Location=use_db_recovery_file_dest valid_for= (all_logfiles,all_roles) db_unique_name= BBDG '#*.log_archive_dest_2= ' Service=bbsvr valid_for= (online_logfiles,primary_role) Db_unique_name=bbsvri1 '*.log_archive_format= ' Arc_%t_%s_%r.arc '*.l

After a new Oracle 11g RAC is installed, do you know what caused the CRSD on the second node to fail to start? The error message is Crs-4535:cannot communicate with Cluster Ready Services. Its specific error message also needs to see the Crsd.log log to know. 1. Environment [Root@linux2 ~]# Cat/etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Ca

, all named directories in the software location path would acquire root ownership. This could create problems for subsequent installations into the same Oracle base.Action:specify software location outside of Oracle baseWorkaround:My current directory is: Oracle_base=/home/gridOracle_home=/home/grid/11.2.0/gridThis directory is not correct, because the Oracle_base and Oracle_home directories to separate, O

, performance settings, respectively, configure the two server DEP, need to restart after the effective (2) In the Control Panel, user accounts, respectively, configure the two servers UAC, need to restart after the effective. 2.1.6 Configuration to modify virtual memory (1) Desktop computers/attributes/Advanced, performance Settings/Advanced/virtual memory, changes. (2) Custom virtual memory size, usually twice times the memory, or set for

1, through the root user into the grid oracle_home[[Email protected]]# source/home/grid/.bash_profile[[Email protected]]# cd $ORACLE _home/crs/install/2, run for example the following two scripts (only one node running, the root user)[Email protected]]#./rootcrs.pl-verbose-deconfig-force[Email protected]]#./crsconfig_params3, switch to the grid user, run deinstall to uninstall, according to the prompt is complete, and then go to another node as prompt

1, through the root user into the grid oracle_home[[Email protected]]# source/home/grid/.bash_profile[[Email protected]]# cd $ORACLE _home/crs/install/2. Execute the following two scripts (only one node executes, root user)[Email protected]]#./rootcrs.pl-verbose-deconfig-force[Email protected]]#./crsconfig_params3, switch to the grid user, perform deinstall to uninstall, follow the prompts to complete, and then go to another node as prompted to execut

bytesdatabasemounted. databaseopened. sql>archiveloglist;databaselogmodeArchiveModeAutomaticarchival enabledarchivedestination+archoldest onlinelogsequence4Nextlogsequenceto archive5currentlogsequence 5 Open Other nodes ...Turn on database flashback:[[Emailprotected]~]$srvctlstopdatabase-dmecbssql>startup mount;oracleinstancestarted. totalsystemglobalarea776646656bytesfixedsize 2257272bytesVariableSize541068936bytesDatabase buffers230686720bytesredobuffers2633728 bytesdatabasemounted. Sql>alter

Several important parameters in Oracle 11g RAC Par num describ ------------------------------------------------------------------------- _ Lm_lms 2Number of background gcs server processes to start _ Lm_lms_waittime 3Default wait time for lms in centiseconds _ Lm_lms_spin FALSEMake lms not sleep _ Interconnect_checksum TRUEIf TRUE, checksum interconnect blo

Tags: Oracle ORA.CRF too largeFind/-type f-size +500m | Xargs Du-hm | Sort-nrThe ORA.CRF service is a service for cluster health Monitor (CHM), which is used to automatically collect the usage of the operating system's resources (CPU, memory, SWAP, process, I/O, and network, etc.). Because the bug 10165314,ORA.CRF service generated files (all the crf*.bdb and $hostname.ldb in the $HOMENAME/directory of the $GI _home/crf/db/), it is stressful for $gi_h

racnode2 ora....de2.gsd application OFFLINE OFFLINE ora. .. De2.ons application Online online racnode2 ora....de2.vip ora....t1.type online online racnode2 ora. .. Ry.acfs ora....fs.type Online online racnode1 ora.scan1.vip ora....ip.type online online racnode1Try to specify the node to start againSrvctl Start instance-d prod-i prod1Check Again[[emailprotected] ~]# crs_stat-tname Type Target State Host--------------------- ---------------------------------------Ora. ARCH.DG ora....up.type Onlin

View the operating system version: [Root @ rac1 ~] # Cat/etc/issueEnterprise Linux AS release 4 (October Update 7)Kernel \ r on an \ m View the kernel version: [Root @ rac1 ~] # Cat/proc/versionLinux version 2.6.9-78.0.0.0.1.ELsmp (mockbuild@ca-build15.us.Oracle.com) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-10) #1 SMP Fri Jul 25 14:41:56 EDT 2008 Vi/etc/hosts127.0.0.1 localhost192.168.10.11 rac1192.168.10.12 rac1-vip10.10.10.11 rac1-priv192.168.10.21 rac2192.168.10.22 rac2-vip10.10.10.21 rac2

In Oracle 11g RAC, the Discovery oc4j and the GSD service are in the offline state, which is the Oracle 11g RAC default scenario. Even so, it does not affect the use of the database because OC4J is a resource for WLM and WLM is av

Oracle 11g RAC Production environment Deployment detailsTian Yi ([email protected])Basic planningEquipment selection1, server: Dell R620 two units. CPU 8 core, Memory 64g,600g 15000-turn SAS hard drive, dual power supply, HBA card piece, connect storage cable (connect HBA card and shared storage).2, Storage: Dell MD3200 one. Dual controller, 12 600G 15000-turn SA

Tags: oracle11g listenerThe Oracle 11g RAC Listener has a listening process offline after adjusting the network, and frequent switching between the two nodes, viewing the log/var/log/message found frequent registration revocation action.Listening Log/u01/app/oracle/diag/tnslsnr/rac1/listener/trace/listener.logListening