rac configuration oracle 11g

/Local/bin]: thefile "Dbhome"already existsinch/usr/Local/bin. Overwriteit? (y/n) [n]: y Copying dbhome to/usr/Local/bin ... Thefile "Oraenv"already existsinch/usr/Local/bin. Overwriteit? (y/n) [n]: y Copying oraenv to/usr/Local/bin ... Thefile "Coraenv"already existsinch/usr/Local/bin. Overwriteit? (y/n) [n]: y Copying coraenv to/usr/Local/bin ... Entries'll be added to the/etc/oratabfile asNeeded byDatabase Configuration Assistant when a database

Starting to test Oracle 11g rac, the current performance is limited, so a single node rac is installed. The procedure is as follows: Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts by binding the NIC * I will not talk more here Configure Xmanager connection Vi/usr/share/TPD/de

Label:before closing the backup control file/parameter file:Sqlplus/as Sysdbaalter Database backup controlfile to '/home/oracle/control.ctl.bak '; Create pfile= '/home/oracle/init lt; instance name >.ora ' from SPFile;One, Oracle 11g RAC shutdown sequence1. Stop the EM Servi

remains until650) this.width=650; "Width=" 475 "height=" 355 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>Start the installation after pressing done650) this.width=650; "width=" 470 "height=" 348 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.g

1) Check the cluster status: [Grid @ rac02 ~] $ Crsctl check ClusterCRS-4537: Cluster ready services is onlineCRS-4529: Cluster synchronization services is onlineCRS-4533: event manager is online. 2) All Oracle instances (Database status ):[Grid @ rac02 ~] $ Srvctl status database-D racdbInstance racdb1 is running on node rac01Instance racdb2 is running on node rac02 3) Check the status of a single instance:[Grid @ rac02 ~] $ Srvctl status insta

1.6 Oracle Installation Prerequisites The following actions are logged on to the RacNode1 node with root. If you do not use DNS, you must configure the/etc/hosts file as follows Note: Even if the scan address is defined in the/etc/hosts file, you still need to define DNS to cycle between 3 addresses in the same subnet as the public IP address. DNS server configuration refer to the DNS

The most recent Oracle 11g RAC installation ran into a INS-30507 error, that is, when the grid was installed to create the ASM Disk Group, no candidate disks were found, and Google did not find any clues to the N-Multiple installation instructions. If you encounter this problem, you might as well look down. 1. Error message and explanation SEVERE: [FATAL] [INS-

1), check the cluster status: [GRID@RAC02 ~]$ crsctl Check Cluster Crs-4537:cluster Ready Services is online Crs-4529:cluster Synchronization Services is online Crs-4533:event Manager is online 2, all Oracle instances-(database state): [Grid@rac02 ~]$ srvctl status database-d racdb Instance RACDB1 is running on node RAC01 Instance RACDB2 is running on node RAC02 3), check the status of a single instance: [Grid@rac02 ~]$ srvctl status instance-d racd

 Oracle 10g RAC Start-Stop archive modeIf the Oracle database is running in archive mode, you may need to pause the archive of the database when you perform database maintenance, and then restart the archive mode after maintenance is complete.You can convert from archive mode to non-archive mode by using the following steps:The following steps operate on a sing

To modify the Host Name of Oracle 10g RAC, refer: Related platforms:Aix 6106 + oracle 11203Modify host name:First node: change from dbrac1 to dbrac100Second node: change from dbrac2 to dbrac200 1. Uninstall CRS firstRun/oracle/asm/crs/install/rootcrs. pl-verbose-deconfig-force on a non-last Node Using

-EUKjGFgdAAKO6mSCyZQ534.png-wh_500x0-wm_ 3-wmp_4-s_2267512842.png "style=" Float:none; "title=" 12.png "alt=" Wkiol1j-eukjgfgdaako6mscyzq534.png-wh_50 "/>650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/92/4F/wKiom1j-EUOi9XXZAALcDY249CU130.png-wh_500x0-wm_ 3-wmp_4-s_2509605691.png "style=" Float:none; "title=" 13.png "alt=" Wkiom1j-euoi9xxzaalcdy249cu130.png-wh_50 "/>650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M02/92/4E/wKioL1j-EUSiId_DAAKazKmupFM566.png-wh_500x0-wm_ 3-wmp

Oracle 11g modifies the rac scan ip address in 11gR2 and introduces the SCAN (Single Client Access Name) feature. The advantage of this feature is that between the database and the Client, A virtual service layer is added, that is, the scan ip address and scan ip listener. on the client side, you only need to configure the tns information of the scan ip address a

Tags: oracle RAC PlanningEnvironment Description:System: rhel6.4 X64bitOracle:oracle 11.2.0.4Database server, generally conditional, storage using raid1+0 mode, followed by Raid6, again raid5!Oracle Database Backup principles:Sunday full, Monday to Saturday differential incremental backup with a retention period of one monthsOracle

.lsnr application 0/5 0/0 Online online db1 ora.db1.gsd application 0/5 0/0 OFFLINE OFFLINE ora.db1.ons application 0/3 0/0 online online db1 ora.db1.vip ora....t 1.type 0/0 0/0 online online db1 ora .... SM2.ASM application 0/5 0/0 online online db2 ora .... B2.lsnr application 0/5 0/0 Online online DB2 ORA.DB2.GSD application 0/5 0/0 OFFLINE OFFLINE ora.db2.ons application 0/3 0/0 Online online DB2 ora.db2.vip ora....t 1.type 0/0 0/0 Online online db2 ora.gsd ora.gsd.type 0/5 0

you, and the new file name needs to be determined.asmcmd> pwd+flash/devdb/controlfile/Asmcmd> lscurrent.303.956019293 > Not the same as you assigned.5. Modify the control file path in Sqlplus, and after the modification is complete, close the databaseSql> alter system set control_files= ' +data/devdb/controlfile/current.260.936769367 ', ' +flash/devdb/controlfile/ current.256.936769367 ', ' +flash/devdb/controlfile/current.303.956019293 ' scope=spfile sid= ' * ';sql> shutdown immediate;Ora-0150

System version:Oracle Linux Server Release 5.7Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-productionCORE 11.2.0.3.0 ProductionTNS for Linux:version 11.2.0.3.0-productionNlsrtl Version 11.2.0.3.0-productionTo view the character set:Sql>select userenv (' language ') from dual;USERENV (' LANGUAGE ') American_america. Al32utf8Close one of the RAC