asm commands in oracle 11g

can modify the parameters of the main library by using the following commands. After modification, create Pfile.ora = '/backup/pfile.ora from spfile= '/oracle/product/11.2.3/dbs/initjlprojct1.ora '; sql> ALTER SYSTEM SET log_archive_dest_1= ' Location=+arch/jlprojct/archivelog valid_for= (all_logfiles,all_roles) Db_unique_name=jlprojct '; System altered. sql> ALTER SYSTEM SET log_archive_dest_2= ' serv

Online Rac1 ora.oc4j Ora.oc4j.type OFFLINE OFFLINE Ora.ons ora.ons.type Online Online Rac1 Ora ..... Sm1.asm Application Online Online Rac1 Ora ..... C1.lsnr Application Online Online Rac1 ORA.RAC1.GSD Application OFFLINE OFFLINE Ora.rac1.ons Application Online Online Rac1 Ora.rac1.vip ora....t1.type Online Online Rac1 Ora ..... Sm2.asm Application Online Online RAC2 Ora ..... C2.lsnr Application Online On

2015-01-08 20:58:13.842000 +08:00 44574 ORA 445 2015-01-08 on 21:12:58.866000 +08:00 44679 ORA 445 2015-01-08 2 1:15:43.893000 +08:00 44575 ORA 445 2015-01-09 0 1:03:26.299000 +08:00 44683 ORA 445 2015-01-09 0 1:10:24.094000 +08:00 rows fetched adrci> IPs Create package incident 31358 dia-48448:this command does not Support multiple ADR Homes adrci> Show Homes ADR Homes:diag/tnslsnr/rhel63single/listener diag/rdbms/test/test ADRC I> set HomeP

space be deleted without an active sort operation. Starting with Oracle DATABASE11G version 1, you can use the Alter tablespaceshrink Space command to shrink temporary tablespaces, or you can use the ALTER tablespace shrinktempfile command to shrink temporary files. For both commands, you can specify an optional keep clause that defines the lower bound of the table space/temp file to shrink to. If you omi

responsible of resolving IN-DOUBT transactions when Oracle was participating in distributed transactions with M Icrosoft Transaction Server. List of programs:From the Start menu, you will find the newly installed Oracle program:These procedures include: Start and Stop Database is used to control the Oracleservicexe service Backup and Restore Database is scripts for backing up or restoring

"title=" Image038.png "alt=" Wkiol1stzndihgzyaajjby1iatw467.jpg "/>Tip You are currently required to continue with the following script after the root user has executed these scripts until the final prompt for installation is complete.650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/2D/wKioL1STzOyhfR9vAAHBx7LfVVA350.jpg "style=" float: none; "title=" Image039.png "alt=" Wkiol1stzoyhfr9vaahbx7lfvva350.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/30/wKiom1STzE

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

version of a range partition (Rangepartitioning) that automatically creates a partition of the same size, if necessary. range partitions and interval partitions can exist in a single table, and the range partition can be converted to an interval partition. 9, Automatic memory optimization (Auto Memory tuning) In 9i, automatic PGA optimization was introduced, and automatic SGA optimization was introduced in 10g. To 11g, all memory can be automatical

Install Oracle 11G Single-instance database on Linux under VM virtual machine1. Environment and pre-installation planning: virtual machines and OS as followsEnvironment: VMware wordstation Ace Edition 6.0.2Operating system: Oraclelinux-r5-u8-server-i386-dvd 3.2GTo install the operating system, it is important to note that there is enough disk space to reserve.My plan is to:The virtual machine allocates 1024

execution)[Email protected]]$ exit[[Email protected]]# rm-rf/etc/orainst.loc5. Format ASM Disk header.[[email protected]] DD If=/dev/zero count=10 bs=512 of=/dev/sde1You can also simply delete all the contents of the installation directory and kill all the processes:rm-rf/app/grid/*Rm-rf/etc/orainst.locRm-rf/app/orainventoryRm-rf/etc/oracle/ocr.locExecute (The following command must be executed, otherwise

Routine basic maintenance commands for Oracle RAC Status of all instances and services $ Srvctl status database-d orclInstance orcl1 is running on node linux1Instance orcl2 is running on node linux2 Status of a single instance $ Srvctl status instance-d orcl-I orcl2Instance orcl2 is running on node linux2 The status of the global Naming Service in the database $ Srvctl status service-d orcl-s orcltestServi

Sun Microsystems sun4u Sun Fire E6900 Oracle 11.1.0.7.0 ASM Database The system time is modified, causing the Oracle 11g database instance to go down. Both the ASM and ORACLE instances are unmounted. Tue Jul 14 20:11:00 1970Errors

The mofei theorem verifies everything that exists, so the Oracle 11g installed on RedHat is hit. I was careful when installing the machine and did not dare to restart the machine (because it was my first installation, so I was particularly worried). I was afraid of problems, so I did not close the machine after the installation was successful. Just a few days ago, the power was cut off due to data center re

• Describes the options for restoring data faults • use the new RMAN data repair command to perform the following operations: -List faults-receive repair suggestions-repair faults • Perform preventive fault checks • query the data recovery guidance View Data fault repair • Data Guard provides failover to the standby database so that the operation is not affected by the downtime. • Data Recovery guide is a new feature of Oracle Database

Memlock 60397977* Hard Memlock 60397977This value is greater than the SGA requirement and is harmless.If the Exadata machine, please refer to document 1284261.1 for parameter requirements.2). re-login to root and Oracle user, check Memlock limit$ ulimit-l603979773). If you use 11G and later versions, AMM (automatic memory management) is turned on by default, but AMM and hugepagesis incompatible (because Hu

Oracle 11g RAC manually uninstall grid, no deinstall, griddeinstall1. log on to the ORACLE_HOME page of the grid as the root user. [Root @ db01] # source/home/grid/. bash_profile[Root @ db01] # cd $ ORACLE_HOME/crs/install/ 2. Execute the following two scripts (only run on one node, root User) [Root @ db01] #./rootcrs. pl-verbose-deconfig-force [Root @ db01] #./crsconfig_params 3. Switch to the grid

Basic Import and Export commands for Oracle10g/11g: ExpUser Name/User Password@ Service name File=Save path. dmp Buffer=8192Filesize=10000 m feedback=1000 imp username/user password @ service name file = file path. dmp full = y Generally, data export (including triggers and stored procedures) under a specified user can be completely exported (imported) within 10 Gb ). In addition, you can also export th

Only one DG can be designated for storage during the 11g installation: CRS, voting But Oracle's official recommendation is to configure this: 1, when OCR does not configure the mirror, or redundant storage of at least 3 OCR. If the underlying storage is not raid, Oracle recommends mirroring OCR and mirroring avoids a single point of failure. At least two OCR locations if OCR-configured on a

corner, select Oracle, and then press fillNote: IP boycott fill in 127.0.0.1 and localhost are ok, under normal circumstances, if not, Exchange tryService name or SID this entry must be filled with XE, this is necessary. Can't changeThe user name and password are the one created in the previous step and are created according to your personal circumstances.Then click "Connect Test"A successful connection is no problem, you can log into the database wi

Show parameter diagnostic_dest;Sql> Show Parameter Diagnostic_destNAME TYPE VALUE------------------------------------ ----------- ------------------------------Diagnostic_dest String/opt/oracle/appThe Linux commands are viewed as follows:ll/u01/app/oracle/diag/rdbms/orcl/orcl/trace/Sql> show parameter dump;NAME TYPE VALUE------------------------------------ -----