asm commands in oracle 11g

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

/orainventory/2)./orainstroot.sh3) cd/opt/oracle/app/product/11.2.0/dbhome_1/4)./root.sh (When the "enter the full pathname of the local bin Directory:[/usr/local/bin]:" When the Enter)End the installation of Oracle. It is best to restart the server after the installation is complete.Oracle Common Commands# su–oracle$s

... ThecommandcompletedsuccessfullyFourth step: Add the Automatic delete log file script[[emailprotected]~] #su -oracle [[emailprotected]] $CP /media/linux/ deletearchivelogs.sh/media/linux/rman_cmd/home/oracle#/media/linux/ Represents a directory on a USB flash drive where the pasted position is/home/oracle [[emailprotected]] $chmod +x/home/

message.3. Kill all Sessions First, "Ps-ef|grep $ORACLE _sid|grep-v ora_|grep Local=no|awk ' {print $} ' |xargs kill ' can also be used in other ways. Then log in to the database with Sqlplus. The commands are: "Sqlplus/nolog"-"Connect/as sysdba", and finally the Oracle database "shutdown immediate" is closed with a command. When you close the command, you need

Common maintenance commands for Oracle 10g RAC: status of all instances and services [oracle @ vzwc1 ~] $ Srvctl status database-d zwc Instance zwc1 is running on node vzwc1 Instance zwc2 is running on node vzwc2 status of a single Instance [oracle @ vzwc1 ~] $ Srvctl status instance-d zwc-I zwc1 Instance zwc1 is runni

of datafile 5 todatafile copy/home/oradata/powerdes/powerdesk01.dbf. Elapsed Time:0:39:12Checkpoint is 11029786628Last deallocation SCN is 110294384482.2 After successful data extraction, create a control fileAssuming you don't know how to create a controlfile command, you can generate trace files onlineGeneral default control file is binary, open to is garbled, backup a trace out can open see statement, $ORACLE _base/admin/$

/group_4.266.685491921 Name---------------------------+ Rac_disk/novadb/tempfile/temp.263.685491617 12 rows selected. SQL> All ASM disks belonging to the "rac_disk" disk group SQL> select path from V $ asm_disk where group_number in (select group_number from V $ asm_diskgroup where name = 'rac _ disk '); Path---------------------------/Dev/raw/raw3/Dev/raw/raw4Orcl: nova3 Start/stop a RAC cluster Make sure that you log on with an

failedora-01200:actual file size of 128679 Issmaller than correct size of 340480BlocksOra-01110:data file 2: '/HOME/ORADATA/POWERDES/SYSAUX01.DBF 'Workaround:DD if=/dev/zeroof=/home/oradata/powerdes/sysaux01.dbf bs=8192 count=1 seek=340480 ----------------------------------------------------------------------------------------------------------- -----Original Blog address: http://blog.itpub.net/26230597/viewspace-1484099/Hara Douglas Fir (MCHDBA)-------------------------------------------------

[Oracle] Some Common commands in RAC (1) Node layer: Olsnodes -N: displays the number of each node. [Oracle @ rac1 ~] # Olsnodes-n Rac1 1 Rac2 2 2 -P: displays the name of the network interface used by each node for private interconnect. [Oracle @ rac1 ~] # Olsnodes-p Rac1 rac1-priv Rac2 rac2-priv -I: displays the VIP

Today, a strange problem has been found that the SRVCTL and Crs_start commands cannot start an Oracle RAC instance, but with Sqlplus it can start normally. The final reason for this is that the state of the database becomes disable in OCR, and this state is changed to enable after it returns to normal. The following is a simulation example: [emailprotected]:~ $> crs_stat-tname Type Target State Host--------

the "orcl_data1" disk group SELECT Path From V$asm_disk WHERE group_number in (select Group_number From V$asm_diskgroup where name = ' orcl_data1 '); PATH ---------------------------------- Orcl:vol1 Orcl:vol2 14. Start/Stop RAC cluster Make sure that you are logged on as an Oracle UNIX user. We will run all commands from the RAC1 node: # su–oracle

Common scenarios: When you back up the Oracle database from the server and restore the Oracle database to a local machine, you will often encounter inconsistency in the character encoding of the database. Common scenarios: When you back up the Oracle database from the server and restore the Oracle database to a local m

/ xxxxxx; is connected. SQL>Select*From User_users; USERNAME user_id Account_status------------------------------ ---------- --------------------------------lock_date expiry_date default_tablespace-------------- -------------- ------------------------------temporary_tablespace CREATED Initial_rsrc_consumer_group------------------------------ -------------- ------------------------------External_name--------------------------------------------------------------------------------Gd_base theOPEN --

SGA plus the PGA.alter system set memory_target=500m; The value of--memory_target setting is either greater than memory_max_targetI4, the new initialization parameter Memory_max_target defines the maximum achievable value for memory_target.Alter system set memory_max_target=900m Scope=spfile; --The next launch takes effect, Scope=spfile can't omit or errori5, note: If you use AMM, the values for Sga_target and pga_aggregate_target should be set to 0.Show parameter sga_target;Show parameter page

Oracle RAC Common maintenance tools and commands 1-node Layer olsnodes 2 Network Layer Oifcfg 3 Cluster layer Crsctl,ocrcheck,ocrdump,ocrconfig 4 Application Layer Srvctl,onsctl 1) [Grid@node1 ~]$ olsnodes-n-i-s-T Node1 1 Node1-vip Active unpinned 2) [Grid@node1 ~]$ oifcfg getif Eth0 192.168.6.0 Global Public eth1 10.10.10.0 Global Cluster_interconnect 3 Configure CRS to start /etc/inittab recording CR

://www.cnblogs.com/HondaHsu/p/4054277.htmlBuild oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build the environment-2.10. Configure User ntf ServicesHttp://www.cnblogs.com/HondaHsu/p/4054333.htmlBuild oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Install Oracle RAC-3.1. Install and configure ASM driversHttp://www.cnblogs.com/HondaHsu/p/4054367.html

Method One: The version number is displayed when you log in [[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.3.0 Production on aweary Juan 7?20 17:51:14 2015CopYright (c) 1982, Oracle. All rights reserved. Method Two:sql> select * from V$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g