tag:blogger.com,1999:blog-51037956197816552022024-03-12T19:23:41.452-07:00Rakesh Soni - Oracle DBAI am writing at my blog for future reference. I am writing Oracle related experiences and stuffs.
I have over 7 years of Oracle DBA experience, I am also Oracle 11g DBA & 10g DBA Certified Professional.
If you want to hire me on Permanent / Contract / Project basis then do contact me at rocky.soni@gmail.com or rakesh.is.ocp@gmail.com.Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.comBlogger56125tag:blogger.com,1999:blog-5103795619781655202.post-91271904765663225852012-11-05T02:38:00.000-08:002012-11-05T02:38:29.785-08:0011g DBA Certified.<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="share-body">By the Grace of GOD, Today I have passed 1Z0-050 exam Oracle Database 11g: New Features for Administrators. </span><br />
<br />
<span class="share-body">I am <b>Oracle 11g Certified DBA</b> Professional now !! </span><br />
<br />
<span class="share-body">Thanks.<br />Rakesh Kumar Soni.</span></div>
Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-13816533825454372202012-02-23T22:18:00.024-08:002012-03-23T02:14:32.397-07:00PROCESSES , SESSIONS, TRANSACTIONSIn this post I will show how Oracle automatically changes values of sessions and transactions parameters after you have changed processes parameter. What formula oracle uses to calculate new values for session and transaction parameter. We will first start with some basics of Processes, Sessions, and Transactions.<br /><span style="FONT-WEIGHT: bold"><br />PROCESSES :</span><br />PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.<br />The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to adjust the values of those derived parameters.<br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw8DFwFzDKfvVEJ7rAywKbwHPZAeY5jKt9ItOga4rS4J4fXAh1fiWzETxSrHzurt6qfZbxqMJ00dghBgCRebCSVkdGN7kklpssI9SN9J6FhJ6dCYVM7IndJSf_-750bRHIHfRjp6iwAkI/s1600/1-processes.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 195px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5712592516817090498" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw8DFwFzDKfvVEJ7rAywKbwHPZAeY5jKt9ItOga4rS4J4fXAh1fiWzETxSrHzurt6qfZbxqMJ00dghBgCRebCSVkdGN7kklpssI9SN9J6FhJ6dCYVM7IndJSf_-750bRHIHfRjp6iwAkI/s400/1-processes.JPG" /></a><br /><br /><br /><br /><br /><br /><br /><br /><span style="FONT-WEIGHT: bold"><br /></span><div><span style="FONT-WEIGHT: bold"><br /></span></div><div><span style="FONT-WEIGHT: bold"><br /></span></div><div><span style="FONT-WEIGHT: bold"><br /></span></div><div><span style="FONT-WEIGHT: bold">SESSIONS :</span><br /><strong>default value (1.1 * PROCESSES) + 5<br /></strong>SESSIONS specifies the maximum number of sessions that can be created in the system. Because every login requires a session, this parameter effectively determines the maximum number of concurrent users in the system. You should always set this parameter explicitly to a value equivalent to your estimate of the maximum number of concurrent users, plus the number of background processes, plus approximately 10% for recursive sessions.<br /><br />Oracle uses the default value of this parameter as its minimum. Values between 1 and the default do not trigger errors, but Oracle ignores them and uses the default instead.<br /><br />The default values of the ENQUEUE_RESOURCES and TRANSACTIONS parameters are derived from SESSIONS. Therefore, if you increase the value of SESSIONS, you should consider whether to adjust the values of ENQUEUE_RESOURCES and TRANSACTIONS as well. (Note that ENQUEUE_RESOURCES is obsolete as of Oracle Database 10g release 2 (10.2).)<br />In a shared server environment, the value of PROCESSES can be quite small. Therefore, Oracle recommends that you adjust the value of SESSIONS to approximately 1.1 * total number of connections.<br /><strong>In database (1.1 * 200) + 5 = 225<br /></strong><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjufD_cr7zca3sxhIIfq7VNuDGkux501CosHHwvCP8ZOI33A2VticdR-RKyi_0Cd-S9RGp4MScAtG-J-oqJ_F7vs1lVwZz721_HQasFrq1SjSbLHjxjCIZ2wDGD3H2nNMh54FwtWdUWKmg/s1600/2-sessions.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 135px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5712594261633709042" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjufD_cr7zca3sxhIIfq7VNuDGkux501CosHHwvCP8ZOI33A2VticdR-RKyi_0Cd-S9RGp4MScAtG-J-oqJ_F7vs1lVwZz721_HQasFrq1SjSbLHjxjCIZ2wDGD3H2nNMh54FwtWdUWKmg/s400/2-sessions.JPG" /></a><br /><br /><br /><br /><br /><br /><span style="FONT-WEIGHT: bold">TRANSACTIONS :</span><br /><strong>default value (1.1 * SESSIONS)<br /></strong>TRANSACTIONS specifies the maximum number of concurrent transactions. Greater values increase the size of the SGA and can increase the number of rollback segments allocated. The default value is greater than SESSIONS (and, in turn, PROCESSES) to allow for recursive transactions.<br /><strong>In database value (1.1 * 225)<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3OTancYLw73IJ3vumaCpBo_kFAgT12mHEWoJsaDs2FEjscF-7jJZTqTOlnO1qbXhfDe3zVc4S98t2frZAX_4WS4X751NohxpYcwyo39_mLEqa9u2mYn3BLN4P04_bY8mCYilgUhiD18A/s1600/3-transactions.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 89px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5712596153893491314" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3OTancYLw73IJ3vumaCpBo_kFAgT12mHEWoJsaDs2FEjscF-7jJZTqTOlnO1qbXhfDe3zVc4S98t2frZAX_4WS4X751NohxpYcwyo39_mLEqa9u2mYn3BLN4P04_bY8mCYilgUhiD18A/s400/3-transactions.JPG" /></a> = 247</strong><br /><br /><br /><strong></strong></div>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-37853552277966399512012-02-06T02:17:00.000-08:002012-02-06T04:09:00.619-08:00RMAN Restore using RMAN COLD BackupI have taken RMAN COLD Backup in my last post, In this post I am going to delete datafile and then I will try to open a database. I will write some steps to recover/restore datafile/database.<br />---------------------------------------------------------------<br /><br />Microsoft Windows [Version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp.<br />C:\Documents and Settings\Administrator>sqlplus<br />SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 6 15:27:19 2012<br />Copyright (c) 1982, 2005, Oracle. All rights reserved.<br />Enter user-name: sys as sysdba<br />Enter password:<br />Connected to an idle instance.<br /><br /><strong><span style="color:#3366ff;">SQL> startup;<br /></span></strong>ORACLE instance started.<br />Total System Global Area 612368384 bytes<br />Fixed Size 1250428 bytes<br />Variable Size 226495364 bytes<br />Database Buffers 377487360 bytes<br />Redo Buffers 7135232 bytes<br />Database mounted.<br /><br />ORA-01157: cannot identify/lock data file 7 - see DBWR trace file<br />ORA-01110: data file 7: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\IQRA10G\INDX.DBF'<br /><br /><strong><span style="color:#3366ff;">SQL> shutdown immediate;<br /></span></strong>ORA-01109: database not open<br />Database dismounted.<br />ORACLE instance shut down.<br />SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br />With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options<br /><br />C:\Documents and Settings\Administrator>rman<br />Recovery Manager: Release 10.2.0.1.0 - Production on Mon Feb 6 15:28:58 2012<br />Copyright (c) 1982, 2005, Oracle. All rights reserved.<br /><strong><span style="color:#3366ff;"></span></strong><br /><strong><span style="color:#3366ff;">RMAN> connect target<br /></span></strong>connected to target database (not started)<br />RMAN> sql 'alter database mount';<br />using target database control file instead of recovery catalog<br />RMAN-00571: ================================================<br />RMAN-00569:<br />===== ERROR MESSAGE STACK FOLLOWS =====<br />RMAN-00571: ================================================<br />RMAN-03002: failure of sql command at 02/06/2012 15:29:12<br />RMAN-06403: could not obtain a fully authorized session<br />ORA-01034: ORACLE not available<br />ORA-27101: shared memory realm does not exist<br /><br /><strong><span style="color:#3366ff;">RMAN> startup nomount;<br /></span></strong>Oracle instance started<br />Total System Global Area 612368384 bytes<br />Fixed Size 1250428 bytes<br />Variable Size 226495364 bytes<br />Database Buffers 377487360 bytes<br />Redo Buffers 7135232 bytes<br /><br /><strong><span style="color:#3366ff;">RMAN> sql 'alter database mount';<br /></span></strong>sql statement: alter database mount<br /><br /><strong><span style="color:#3366ff;">RMAN> restore tablespace indx;<br /></span></strong>Starting restore at 06-FEB-12<br />allocated channel: ORA_DISK_1<br />channel ORA_DISK_1: sid=156 devtype=DISK<br /><br />channel ORA_DISK_1: starting datafile backupset restore<br />channel ORA_DISK_1: specifying datafile(s) to restore from backup set<br />restoring datafile 00007 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\IQRA10G\INDX.DBF<br /><br />channel ORA_DISK_1: reading from backup piece<br />D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\IQRA10G\BACKUPSET\2012_02_03\O1<br />channel ORA_DISK_1: restored backup piece 1<br />piece<br />handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\IQRA10G\BACKUPSET\2012_02_03\O1_MF_NNNDF_TAG20120203T173426_7LQO<br /><br />channel ORA_DISK_1: restore complete, elapsed time: 00:00:56<br />Finished restore at 06-FEB-12<br /><br /><strong><span style="color:#3366ff;">RMAN> alter databse open;<br /></span></strong>RMAN-00571: ================================================<br />RMAN-00569:<br />===== ERROR MESSAGE STACK FOLLOWS =====<br />RMAN-00571: ================================================<br />RMAN-00558: error encountered while parsing input commands<br />RMAN-01009: syntax error: found "identifier": expecting one of: "clone, database"<br />RMAN-01008: the bad identifier was: databse<br />RMAN-01007: at line 1 column 7 file: standard input<br /><br /><strong><span style="color:#3366ff;">RMAN> recover tablespace indx;<br /></span></strong>Starting recover at 06-FEB-12<br />using channel ORA_DISK_1<br />starting media recovery<br />media recovery complete, elapsed time: 00:00:03<br />Finished recover at 06-FEB-12<br /><br /><strong><span style="color:#3366ff;">RMAN> alter databse open;<br /></span></strong>RMAN-00571: ================================================<br />RMAN-00569:<br />===== ERROR MESSAGE STACK FOLLOWS =====<br />RMAN-00571: ================================================<br />RMAN-00558: error encountered while parsing input commands<br />RMAN-01009: syntax error: found "identifier": expecting one of: "clone, database"<br />RMAN-01008: the bad identifier was: databse<br />RMAN-01007: at line 1 column 7 file: standard input<br /><br /><strong><span style="color:#3366ff;">RMAN> alter database open resetlogs;<br /></span></strong>RMAN-00571: ================================================<br />RMAN-00569:<br />===== ERROR MESSAGE STACK FOLLOWS =====<br />RMAN-00571: ================================================<br />RMAN-03002: failure of alter db command at 02/06/2012 15:37:12<br />ORA-01139: RESETLOGS option only valid after an incomplete database recovery<br /><br /><strong><span style="color:#3366ff;">RMAN> recover database;<br /></span></strong>Starting recover at 06-FEB-12<br />using channel ORA_DISK_1<br />starting media recoverymedia recovery complete, elapsed time: 00:00:00<br />Finished recover at 06-FEB-12<br /><br /><strong><span style="color:#3366ff;">RMAN> alter database open;<br /></span></strong>database opened<br />RMAN>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com1tag:blogger.com,1999:blog-5103795619781655202.post-48385301243567210542012-02-03T00:02:00.000-08:002012-02-06T01:52:02.367-08:00RMAN Cold Backup - NO Archive Log ModeMicrosoft Windows [Version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp.<br />C:\Documents and Settings\Administrator>sqlplus<br />SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 3 13:14:42 2012<br />Copyright (c) 1982, 2005, Oracle. All rights reserved.<br />Enter user-name: sys as sysdba<br />Enter password:<br /><br />Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br />With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options<br /><br /><strong><span style="color:#3366ff;">SQL> archive log list<br /></span></strong>Database log mode No Archive Mode<br />Automatic archival Disabled<br />Archive destination USE_DB_RECOVERY_FILE_DEST<br />Oldest online log sequence 54<br />Current log sequence 56<br />SQL><br />SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br />With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options<br /><br />C:\Documents and Settings\Administrator>rman<br />Recovery Manager: Release 10.2.0.1.0 - Production on Fri Feb 3 13:17:45 2012<br />Copyright (c) 1982, 2005, Oracle. All rights reserved.<br /><br /><strong><span style="color:#3366ff;">RMAN> connect target<br /></span></strong>connected to target database: STAND(DBID=183739979)<br />RMAN><br />RMAN> show all;<br />using target database control file instead of recovery catalog<br />RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default<br />CONFIGURE BACKUP OPTIMIZATION OFF; # default<br />CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default<br />CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default<br />CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default<br />CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default<br />CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br />CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br />CONFIGURE MAXSETSIZE TO UNLIMITED; # default<br />CONFIGURE ENCRYPTION FOR DATABASE OFF; # default<br />CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default<br />CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default<br />CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DB_2\DATABASE\SNCFSTAND.ORA'; # default<br /><br /><span style="color:#3366ff;"><strong>RMAN> list backup;<br /></strong></span><br /><strong><span style="color:#3366ff;">RMAN> list backup summary;</span><br /></strong><br /><span style="color:#3366ff;"><strong>RMAN> backup full database;<br /></strong></span>Starting backup at 03-FEB-12using channel ORA_DISK_1<br />channel ORA_DISK_1: starting full datafile backupset<br />channel ORA_DISK_1: specifying datafile(s) in backupset<br />RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/03/2012 13:43:08<br />ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode<br />continuing other job steps, job failed will not be re-run<br />channel ORA_DISK_1: starting full datafile backupset<br />channel ORA_DISK_1: specifying datafile(s) in backupset<br />including current control file in backupset<br />including current SPFILE in backupset<br />channel ORA_DISK_1: starting piece 1 at 03-FEB-12<br />channel ORA_DISK_1: finished piece 1 at 03-FEB-12<br />piece handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STAND\BACKUPSET\2012_02_03\O1_MF_NCSNF_TAG20120203T134307_7LQ7JXY6_.BKP tag=TAG20120203T134307 comment=NONE<br />channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02<br />RMAN-00571: ===========================================================<br />RMAN-00569:<br />===============<br />ERROR MESSAGE STACK FOLLOWS<br />===============<br />RMAN-00571: ===========================================================<br />RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/03/2012 13:43:08<br />ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode<br /><br />RMAN> shutdown immediate;<br />database closed<br />database dismounted<br />Oracle instance shut down<br /><br />RMAN> startup nomount;<br />connected to target database (not started)<br />Oracle instance started<br />Total System Global Area 612368384 bytes<br />Fixed Size 1250428 bytes<br />Variable Size 222301060 bytes<br />Database Buffers 381681664 bytes<br />Redo Buffers 7135232 bytes<br /><br /><strong><span style="color:#3366ff;">RMAN> backup full database;<br /></span></strong>Starting backup at 03-FEB-12<br />allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=157 devtype=DISK<br />RMAN-00571: ===========================================================<br />RMAN-00569:<br />===============<br />ERROR MESSAGE STACK FOLLOWS<br />===============<br />RMAN-00571: ===========================================================<br />RMAN-03002: failure of backup command at 02/03/2012 13:44:36<br />ORA-01507: database not mounted<br /><br />RMAN> alter database mount;<br />database mounted<br />released channel: ORA_DISK_1<br /><br /><span style="color:#3366ff;"><strong>RMAN> backup full database;<br /></strong></span>Starting backup at 03-FEB-12allocated channel: ORA_DISK_1<br />channel ORA_DISK_1: sid=156 devtype=DISK<br />channel ORA_DISK_1: starting full datafile backupset<br />channel ORA_DISK_1: specifying datafile(s) in backupset<br />input datafile fno=00006 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\STAND\STAND.DBF<br />input datafile fno=00007 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\STAND\INDX.DBF<br />input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\STAND\SYSTEM01.DBF<br />input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\STAND\SYSAUX01.DBF<br />input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\STAND\UNDOTBS01.DBF<br />input datafile fno=00005 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\STAND\EXAMPLE01.DBF<br />input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\STAND\USERS01.DBF<br />channel ORA_DISK_1: starting piece 1 at 03-FEB-12<br />channel ORA_DISK_1: finished piece 1 at 03-FEB-12<br />piece handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STAND\BACKUPSET\2012_02_03\O1_MF_NNNDF_TAG20120203T134503_7LQ7NJHZ_.BKP tag=TAG20120203T134503 comment=NONE<br />channel ORA_DISK_1: backup set complete, elapsed time: 00:03:35<br />channel ORA_DISK_1: starting full datafile backupset<br />channel ORA_DISK_1: specifying datafile(s) in backupset<br />including current control file in backupset<br />including current SPFILE in backupset<br />channel ORA_DISK_1: starting piece 1 at 03-FEB-12<br />channel ORA_DISK_1: finished piece 1 at 03-FEB-12<br />piece handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STAND\BACKUPSET\2012_02_03\O1_MF_NCSNF_TAG20120203T134503_7LQ7V9WJ_.BKP tag=TAG20120203T134503 comment=NONE<br />channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03<br />Finished backup at 03-FEB-12<br /><br /><strong><span style="color:#3366ff;">RMAN> backup current controlfile;<br /></span></strong>Starting backup at 03-FEB-12<br />allocated channel: ORA_DISK_1<br />channel ORA_DISK_1: sid=156 devtype=DISK<br />channel ORA_DISK_1: starting full datafile backupset<br />channel ORA_DISK_1: specifying datafile(s) in backupset<br />including current control file in backupset<br />channel ORA_DISK_1: starting piece 1 at 03-FEB-12<br />channel ORA_DISK_1: finished piece 1 at 03-FEB-12<br />piece handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\STAND\BACKUPSET\2012_02_03\O1_MF_NCNNF_TAG20120203T140027_7LQ8KDTF_.BKP tag=TAG20120203T140027 comment=NONE<br />channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 03-FEB-12<br /><br /><strong><span style="color:#3366ff;">RMAN> sql 'alter database backup controlfile to trace';<br /></span></strong>sql statement: alter database backup controlfile to trace<br /><br /><strong><span style="color:#3366ff;">RMAN> sql 'create pfile from spfile';<br /></span></strong>sql statement: create pfile from spfile<br />RMAN>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-6931486530086589742011-11-25T21:27:00.000-08:002011-11-30T23:18:13.429-08:00PFILE or SPFILE ..<span style="FONT-WEIGHT: bold">How will I know if my database is using a PFILE or SPFILE:</span><br />Execute the following query to see if your database was started with a PFILE or SPFILE:<br />SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit09WExSwwRK3PoEENtpFYhsNHf9sc3HT0CaqdMYZmDXJ450eFwvRYzFGt3TYNbBULrUDJ7zywXA59m4OfihE7hsnaPdW8RzgCmuyN1HTDr1IvQ3tnAcXx7ZbDhj1z4gtdPqsL29VVqno/s1600/spfile+or+pfile.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 221px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5681055502979150082" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit09WExSwwRK3PoEENtpFYhsNHf9sc3HT0CaqdMYZmDXJ450eFwvRYzFGt3TYNbBULrUDJ7zywXA59m4OfihE7hsnaPdW8RzgCmuyN1HTDr1IvQ3tnAcXx7ZbDhj1z4gtdPqsL29VVqno/s400/spfile+or+pfile.JPG" /></a><br /><br /><br /><br /><br /><p><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDTQuB90jvUd_E52NWza2_TP1Xom3QXI-27QAVuSajliXhaDkcmZcUQpiXcL-d0jUFXXAByZ8OM7jMwqKbz3JvDDmQhyfi8Juk9khCWx-IBsCryEIg8tvQNbyUfAQ4Mq8eJnfq1MTo8B4/s1600/spfile.JPG"></a></p><br /><br /><br /><br /><p><br /></p>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-79614675527864454292011-10-05T02:15:00.000-07:002011-10-06T23:08:48.030-07:00Oracle Database 11g Release 2 Installation Steps on WindowsIn this post I will describe the installation steps of Oracle database 11g Release 2 (32-bit) on Windows Server 2003 (32-bit).<br />--------------------------------------<br />- Download Oracle Database 11g release 2.<br />- Run the setup.exe <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <w:worddocument> <w:view>Normal</w:View> <w:zoom>0</w:Zoom> <w:punctuationkerning/> <w:validateagainstschemas/> <w:saveifxmlinvalid>false</w:SaveIfXMLInvalid> <w:ignoremixedcontent>false</w:IgnoreMixedContent> <w:alwaysshowplaceholdertext>false</w:AlwaysShowPlaceholderText> <w:compatibility> <w:breakwrappedtables/> <w:snaptogridincell/> <w:wraptextwithpunct/> <w:useasianbreakrules/> <w:dontgrowautofit/> </w:Compatibility> <w:browserlevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:latentstyles deflockedstate="false" latentstylecount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFMsWroSYcCx-FZzWoeVcQ1qDapyYTllX9bObtrjfur_BoP8Oymwfc_NYz2yVms3AeHyy72-ooglu0ETkkUsudVArw0PZ0Vk2asgvrwfXhHGH06J8s6iDk5JvzJK5lRwaRy-oXq8N0LlY/s1600/step+11.bmp"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 186px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFMsWroSYcCx-FZzWoeVcQ1qDapyYTllX9bObtrjfur_BoP8Oymwfc_NYz2yVms3AeHyy72-ooglu0ETkkUsudVArw0PZ0Vk2asgvrwfXhHGH06J8s6iDk5JvzJK5lRwaRy-oXq8N0LlY/s400/step+11.bmp" alt="" id="BLOGGER_PHOTO_ID_5659985747631746658" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />- Press Run button.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKlj1HlRbWQiV19Jrux8kwWPch-LXRltjULGSTMCbeJrs_mtoXi-CG_KEZJcw0XohZSUblaalkt8kNl_6pR5z5avAYhmUteMh5IEyFg-LTOaGPenPSSuuwob1quSncrXhrzaZ5H9gQg2c/s1600/step2.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKlj1HlRbWQiV19Jrux8kwWPch-LXRltjULGSTMCbeJrs_mtoXi-CG_KEZJcw0XohZSUblaalkt8kNl_6pR5z5avAYhmUteMh5IEyFg-LTOaGPenPSSuuwob1quSncrXhrzaZ5H9gQg2c/s400/step2.JPG" alt="" id="BLOGGER_PHOTO_ID_5659986401225828562" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Provide your email address to be informed of security issues, install the product and initiate Manager.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6IGL5KSJzxGkVp83tnR2qrgrfyJB6wpCRiAe6XsGL5Dd6BgBZl5XCUJVUOsQ-6B8rXXCW5ZZRlKuvSoyiyDx0sbN9Ndu4LyFitKpmmT_JnbgUZXXdKv1TJldsjIh81HYzbaJiEVibNlw/s1600/step3.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6IGL5KSJzxGkVp83tnR2qrgrfyJB6wpCRiAe6XsGL5Dd6BgBZl5XCUJVUOsQ-6B8rXXCW5ZZRlKuvSoyiyDx0sbN9Ndu4LyFitKpmmT_JnbgUZXXdKv1TJldsjIh81HYzbaJiEVibNlw/s400/step3.JPG" alt="" id="BLOGGER_PHOTO_ID_5659988538591245794" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Select any of the following install steps.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVOu-GRykPC2VECz47CMHS2aOEQS2fRuPqLZHVP5FkhXYT3pdamuvXwTn63Vn5rkf2ie7REzkspTt8nvhLw2YULpSPXa7jNRu4ArcVHmqJ59DCclIHjk9sTMdIeGRvdYkS9PX23T3JM_8/s1600/step4.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVOu-GRykPC2VECz47CMHS2aOEQS2fRuPqLZHVP5FkhXYT3pdamuvXwTn63Vn5rkf2ie7REzkspTt8nvhLw2YULpSPXa7jNRu4ArcVHmqJ59DCclIHjk9sTMdIeGRvdYkS9PX23T3JM_8/s400/step4.JPG" alt="" id="BLOGGER_PHOTO_ID_5660597134157073410" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Oracle Database 11g Release 2 introduces a new option that enables you to specify the type of system on which the database is installed. If you are installing on a laptop or a desktop, then select the Desktop Class option; otherwise, select the Server Class option to install on a server. These options are available on the System Class screen.<br /><br />There is no difference in the software that gets installed after you select any one option but the Desktop Class option installs a single instance database without the advanced configuration options.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWGvPHwqNm6hrGtvcOMRs1bu4vKhVnWJa5bq54ZHjmptjbzFFnSj8YUZDZCpe4lT2d8uFGwqs_pBGi2JHRWUobhimE2SsTnIkFM8eZb4wu39OGGa2Hqi4typNHE_wCHNnWi-sn69FO3Lc/s1600/5.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWGvPHwqNm6hrGtvcOMRs1bu4vKhVnWJa5bq54ZHjmptjbzFFnSj8YUZDZCpe4lT2d8uFGwqs_pBGi2JHRWUobhimE2SsTnIkFM8eZb4wu39OGGa2Hqi4typNHE_wCHNnWi-sn69FO3Lc/s400/5.JPG" alt="" id="BLOGGER_PHOTO_ID_5660598883028303394" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Typical install configuration.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyffmSWJQ6yDl7H7U_OCzGgpCpPDwiVHtjLcI9SJOsbkrg-QJs75Rn3EBpSiGTNwQn3o3ORGwdDIpd-jL9iuCQjNScMle86zI-b_bYOeYx81OqrVfPb8_VNdof6zt3MjS2fi5FjTNPyVM/s1600/6.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyffmSWJQ6yDl7H7U_OCzGgpCpPDwiVHtjLcI9SJOsbkrg-QJs75Rn3EBpSiGTNwQn3o3ORGwdDIpd-jL9iuCQjNScMle86zI-b_bYOeYx81OqrVfPb8_VNdof6zt3MjS2fi5FjTNPyVM/s400/6.JPG" alt="" id="BLOGGER_PHOTO_ID_5660604022538121250" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Prequisite Checks<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhffsoRIQjsv4HvyPPFpc2hfAqj61utOz4pGhQkMFKvf8wUUDguJhRvfKYj6xEWmCyikAvxK8wJInMrYSHkwtc8JRGJ26WzPYnMYZGJwWMq-z82tkp3xEb0gKGylwK_YfRzF85RT_212M0/s1600/7.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 342px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhffsoRIQjsv4HvyPPFpc2hfAqj61utOz4pGhQkMFKvf8wUUDguJhRvfKYj6xEWmCyikAvxK8wJInMrYSHkwtc8JRGJ26WzPYnMYZGJwWMq-z82tkp3xEb0gKGylwK_YfRzF85RT_212M0/s400/7.JPG" alt="" id="BLOGGER_PHOTO_ID_5660604932906101874" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Installation Progress<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM6fjbpO1dBypO60F0jQrY9J4XjMjqj3AieGKT_5x2Lli8-5ENIpQZaWTYm_x2-cSOzjfFIy-B4X8UlbJG5GOIRi8DMDdrGaRWqEGFvDTjzZ_0CXmGPjb9cRuGjuGgNNF_eyrkQv4G6r8/s1600/8.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 342px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM6fjbpO1dBypO60F0jQrY9J4XjMjqj3AieGKT_5x2Lli8-5ENIpQZaWTYm_x2-cSOzjfFIy-B4X8UlbJG5GOIRi8DMDdrGaRWqEGFvDTjzZ_0CXmGPjb9cRuGjuGgNNF_eyrkQv4G6r8/s400/8.JPG" alt="" id="BLOGGER_PHOTO_ID_5660605560306483010" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Installation error<br /><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >File not found C:\app</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >\Administrator\Pro</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >ducts</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >\1</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >1.2.0</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >\dbhome_1\oc4j\j2</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >ee</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >\oc4j_applications</span><span style="font-weight: bold; font-style: italic;font-family:Tahoma;font-size:7.5pt;color:black;" >\applications\em\em.ear</span><br /><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >File not found C:\app</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\Administrator\Products</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\11.2.0</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\dbhome_1</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\o</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >c4j\j2ee</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\oc4j_applications</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\applications\em\em.war</span><br /><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >File not found C:\app</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\Administrator\Products</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\11.2.0\dbhome_1\oc4j\j2e</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >e</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\OC4J_DBConsole\config</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\system-</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >application.xml</span><br /><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >File not found C:\</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >app</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\Administrator\Products</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\11.2.0</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\dbhome_1</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\oc4j\j2ee</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\\OC4J_DBConsole\c</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >onfig</span><span style="font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >\system-</span><span style=" font-weight: bold;font-family:Tahoma;font-size:7.5pt;color:black;" >jazn-data.xml</span><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3qGxjZCcHbxrJtw2ZM2Mb7tW5-xFV2Oa-cxFvRjhlfE0vkTwiPtQ2MygyCMA2yDw8KyhmsQWHGjQzqZv2jDQH_4BGWo9w9VnkWuQ89ehH96t9bYhSxtLox3iGXSEwSxZdwO_ZUdh3o-g/s1600/9.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 303px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3qGxjZCcHbxrJtw2ZM2Mb7tW5-xFV2Oa-cxFvRjhlfE0vkTwiPtQ2MygyCMA2yDw8KyhmsQWHGjQzqZv2jDQH_4BGWo9w9VnkWuQ89ehH96t9bYhSxtLox3iGXSEwSxZdwO_ZUdh3o-g/s400/9.JPG" alt="" id="BLOGGER_PHOTO_ID_5660606488184721922" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />The above errors came because I didn't unzip the 2 files in the same folder.<br /><br />Download the Oracle <span style=";font-family:Tahoma;font-size:7.5pt;color:black;" ><span style="font-weight: bold;">win32_11gR2_database</span></span><span style=" ;font-family:Tahoma;font-size:7.5pt;color:black;" ><span style="font-weight: bold;">_1of2.zip </span></span>and<span style=";font-family:Tahoma;font-size:7.5pt;color:black;" > <span style="font-weight: bold;">win32_11gR2_database</span></span><span style=" ;font-family:Tahoma;font-size:7.5pt;color:black;" ><span style="font-weight: bold;">_2of2.zip</span> </span>unzip both files in same folder and then run the setup again.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFAPo6z7DjS_yF5YVmfHTrIWrW30tWCdn96D9ZwkxDPXsfoHarbSK3FeoxgToWWXLVoqmbxRDU3lY9Zbc2-AONKRUF6g1sH_sQB65M0Zhr1weoh5ZBt93os3toxEp4aGFW0BNMSZWOhIM/s1600/10.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFAPo6z7DjS_yF5YVmfHTrIWrW30tWCdn96D9ZwkxDPXsfoHarbSK3FeoxgToWWXLVoqmbxRDU3lY9Zbc2-AONKRUF6g1sH_sQB65M0Zhr1weoh5ZBt93os3toxEp4aGFW0BNMSZWOhIM/s400/10.JPG" alt="" id="BLOGGER_PHOTO_ID_5660621485231855810" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Installation of Oracle Database was successfull.<br />Enterprise Manager Database Control URL - (rakesh11g)<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioKiqH17XlCf-5hLKyX3llRptkpRImHvOuFO6WxlfkDas7g1B4Om8Xd6g6T4PjbI8flaDG0LewQhi8xdY8KRvk_hydIaP7juRUQdrOIt2ZYlB7Fx1DWGB0qJ214OqooAkiy2nC1Gvqd8c/s1600/11.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioKiqH17XlCf-5hLKyX3llRptkpRImHvOuFO6WxlfkDas7g1B4Om8Xd6g6T4PjbI8flaDG0LewQhi8xdY8KRvk_hydIaP7juRUQdrOIt2ZYlB7Fx1DWGB0qJ214OqooAkiy2nC1Gvqd8c/s400/11.JPG" alt="" id="BLOGGER_PHOTO_ID_5660623223601867010" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Sql*Plus of 11g Release 2.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5xqpnwXw94NAy4vwH6-RrMC3zq3UMrwoEpGvZ31vZavNuvfSACE9rC8Ukd-jnvGMbNv9mn2WA2Qi0kj7lqatEklS1rD5oFnFWt95al8t5t2bRI-jN2mb5WLMusfwJMpG1rEUy8NmRrSM/s1600/12+sqlplus+of+11g.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 224px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5xqpnwXw94NAy4vwH6-RrMC3zq3UMrwoEpGvZ31vZavNuvfSACE9rC8Ukd-jnvGMbNv9mn2WA2Qi0kj7lqatEklS1rD5oFnFWt95al8t5t2bRI-jN2mb5WLMusfwJMpG1rEUy8NmRrSM/s400/12+sqlplus+of+11g.JPG" alt="" id="BLOGGER_PHOTO_ID_5660626110765593154" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioKiqH17XlCf-5hLKyX3llRptkpRImHvOuFO6WxlfkDas7g1B4Om8Xd6g6T4PjbI8flaDG0LewQhi8xdY8KRvk_hydIaP7juRUQdrOIt2ZYlB7Fx1DWGB0qJ214OqooAkiy2nC1Gvqd8c/s1600/11.JPG"></a><div></div>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com8tag:blogger.com,1999:blog-5103795619781655202.post-27677009796218646042011-07-01T02:13:00.000-07:002011-07-23T00:42:08.226-07:00Deleting DISK from DISKGROUPLets see how we can delete an ASM disk in DISKGROUP.<br />Currently, we have 3 disks in DATA diskgroup.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQk9c6u1E8v_93v_35QoxCqCveX8B4EBFJ795QuYlwLyIwENWiX2Z5y2aOtvPirMd6-y3ghB82IPpnie1EOYOX2HkmHYI7OazB_5uPxt5pLYlyMLnoipS3dgoifqe3Ywgzy6cQzi4effU/s1600/1.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 160px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5624351124424236562" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQk9c6u1E8v_93v_35QoxCqCveX8B4EBFJ795QuYlwLyIwENWiX2Z5y2aOtvPirMd6-y3ghB82IPpnie1EOYOX2HkmHYI7OazB_5uPxt5pLYlyMLnoipS3dgoifqe3Ywgzy6cQzi4effU/s400/1.JPG" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />I want to drop disk1 from DATA diskgroup.<br /><br />SQL> alter diskgroup data drop disk 'D:\ASMDISKS\DISK1';<br />alter diskgroup data drop disk 'D:\ASMDISKS\DISK1'<br />*<br />ERROR at line 1:<br />ORA-15032: not all alterations performed<br />ORA-15054: disk "D:\ASMDISKS\DISK1" does not exist in diskgroup "DATA"<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZyRuEpik7K7NGwGXjw2N9capDDtgs7QlvXrkiKV7i3T6FV2CW-6FgBFS2ZCqRHWJYoQibHgYsTW2amnmszAV2D6Fwd7f7SM_1zzswBgZ8Cza2SzwjXSmmze7Vua5qRd-3CTDpgIYH6DQ/s1600/2.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 155px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5624352239881404274" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZyRuEpik7K7NGwGXjw2N9capDDtgs7QlvXrkiKV7i3T6FV2CW-6FgBFS2ZCqRHWJYoQibHgYsTW2amnmszAV2D6Fwd7f7SM_1zzswBgZ8Cza2SzwjXSmmze7Vua5qRd-3CTDpgIYH6DQ/s400/2.JPG" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="FONT-WEIGHT: bold">SOLUTION :</span> ONE has to use the name that has been designated in ASM, not as we have given it as disk1.<br /><br />SQL> select path,name from v$asm_disk where group_number=1;<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOBsO6B5M0PRyANR0wCJmQsgrSDuNU86I7jAfsDFQ23aRR2mckIrAdJjY_Sqr2J4qKyMRlbo35JOrIgcssQhumfaMLvaCbT1-Bvrlxb0g2-_-xge6gNBIyhRWY_VNvBPOUiy_LV3Uq4mg/s1600/3+query.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 123px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5624353511602301906" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOBsO6B5M0PRyANR0wCJmQsgrSDuNU86I7jAfsDFQ23aRR2mckIrAdJjY_Sqr2J4qKyMRlbo35JOrIgcssQhumfaMLvaCbT1-Bvrlxb0g2-_-xge6gNBIyhRWY_VNvBPOUiy_LV3Uq4mg/s400/3+query.JPG" /></a><br /><br /><br /><br /><br /><br /><br /><br />Here, Disk1 name is DATA_0000. Alter diskgroup data drop disk DATA_0000 will work;<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjldpBjegOwYzprL05U435UhNr7w7zSr7Nzj12TxsnOzJNTssIurJPGbRF8ZOUz5sDXVYBVa6rZ66JDhSZfcKvPpZyeS3mXv_HSCQCMqEVLdRP04FJI8VKF3uKNX70rw7fT7LzEmAeVOUQ/s1600/deleted.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 84px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5624357303472865586" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjldpBjegOwYzprL05U435UhNr7w7zSr7Nzj12TxsnOzJNTssIurJPGbRF8ZOUz5sDXVYBVa6rZ66JDhSZfcKvPpZyeS3mXv_HSCQCMqEVLdRP04FJI8VKF3uKNX70rw7fT7LzEmAeVOUQ/s400/deleted.JPG" /></a><br /><br /><br /><br /><br /><br /><br />DISK 1 deleted.<br />Lets check whether DISK1 deleted or not.<br />select path,name from v$asm_disk where group_number=1;<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXT3_xvWhFo_XhB1s27-tRnNDgQA3pSZfrOk9dLsZdXADXUTvJYVWLJQvEvPIAU3mCc4p2T0a79MAlHeWumGz8e7iHF_Nrzb3QbVaJ6386VptmWPIefZ9PxRwem7WZjWmsVbt9OIBmeT4/s1600/chk+disks.JPG"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 103px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5624358643493650274" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXT3_xvWhFo_XhB1s27-tRnNDgQA3pSZfrOk9dLsZdXADXUTvJYVWLJQvEvPIAU3mCc4p2T0a79MAlHeWumGz8e7iHF_Nrzb3QbVaJ6386VptmWPIefZ9PxRwem7WZjWmsVbt9OIBmeT4/s400/chk+disks.JPG" /></a><br /><br /><br /><br /><br /><br /><br /><br />The DISK1 is no more in DATA diskgroup.Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-75167685272700494272011-07-01T01:15:00.000-07:002011-07-01T02:00:26.810-07:00Adding DISK in DISKGROUPI have two disks, disk1 and disk2, I want to add new disk3 to diskgroup DATA.<br /><br />SQL> select disk_number, name, path from v$ASM_DISK;<br /><br />DISK_NUMBER NAME PATH<br />----------- ------------------------------ --------------------<br /> 0 DATA_0000 D:\ASMDISK\DISK1<br /> 1 DATA_0001 D:\ASMDISK\DISK2<br /><br />When I execute the below command for adding disk3, i get below error.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHQ9i4jMDF3PDofhlkXFFlAZ0Xcuchb8zyb09QxZ466Hx796hEHTXpydSRTvTvzAV_HJ4SkM-Jw_uzTT_5RYmUdu_tELO-j3TZBIabW0J2TAr0W6ex2itHPIDCgD8uuyVVQ8u3t-p4cqw/s1600/disk+adding+error.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 211px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHQ9i4jMDF3PDofhlkXFFlAZ0Xcuchb8zyb09QxZ466Hx796hEHTXpydSRTvTvzAV_HJ4SkM-Jw_uzTT_5RYmUdu_tELO-j3TZBIabW0J2TAr0W6ex2itHPIDCgD8uuyVVQ8u3t-p4cqw/s400/disk+adding+error.JPG" alt="" id="BLOGGER_PHOTO_ID_5624298397683478418" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />The error :<br /><div class="jive-table"> <div class="jive-messagebox"> <table summary="Message" border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody> <tr id="jive-message-9699871" class="jive-even" valign="top"> <td class="jive-last" width="99%"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody> <tr> <td colspan="4"> <table style="width: 681px; height: 54px;" class="jive-message-body-wrapper" border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td> <div class="jive-message-body">ORA-15031: disk specification 'D:\asmdisk\disk3' matches no disk<br /><br /></div></td><td style="vertical-align: top;"><br /></td><td style="vertical-align: top;"><br /></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></div></div>I realized that I need to create a disk physically, then I should create the disk3 with above command.<br />asmtool -create d:\asmdisk\disk3 1024<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXdJFVmsoPpDwWb4Tdja4UiK509TelQbar_W-JpcyPsJUGHF4mDmfhBFEa2tTeyfl_Iutd2OWESfASbBDKzcFu48Nu7n_shkHfcDG4MfzrrICMf9W8_zLHW-3WIQS2jYiFFc13xdriJxM/s1600/disk3.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 86px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXdJFVmsoPpDwWb4Tdja4UiK509TelQbar_W-JpcyPsJUGHF4mDmfhBFEa2tTeyfl_Iutd2OWESfASbBDKzcFu48Nu7n_shkHfcDG4MfzrrICMf9W8_zLHW-3WIQS2jYiFFc13xdriJxM/s400/disk3.JPG" alt="" id="BLOGGER_PHOTO_ID_5624300397499764530" border="0" /></a><br /><br /><br /><br /><br /><br />SQL> alter diskgroup data add disk 'D:\asmdisk\disk3';<br /><br />Diskgroup altered.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5gXJ9OwjIo54B9SQw2ew5QZBRJZxMd0vS9wQvNGK6ztRw1FAPnXMyf40pt-hOTl8seWrp3U6Ce9p8O5ttarQc7jYXfLw8XEoYNDCR-iM5eoZ-chiKkB0IVoXspZprPr8jJWH8AiIPjbA/s1600/disk+added.JPG"><img style="float: left; margin: 0pt 10px 10px 0pt; cursor: pointer; width: 400px; height: 34px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5gXJ9OwjIo54B9SQw2ew5QZBRJZxMd0vS9wQvNGK6ztRw1FAPnXMyf40pt-hOTl8seWrp3U6Ce9p8O5ttarQc7jYXfLw8XEoYNDCR-iM5eoZ-chiKkB0IVoXspZprPr8jJWH8AiIPjbA/s400/disk+added.JPG" alt="" id="BLOGGER_PHOTO_ID_5624301456046197906" border="0" /></a><br /><br /><br />SQL> select disk_number, name, path from v$ASM_DISK;<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx-BmLnkh7wbFyVnxWh_ChyeLAKLsdbhsJ_NIzVwBpA2xojYBRJguVnP5UfjbQhT2z2seipQIKNI2xoHt7a51bSh5gkMjIitBs0ufp3SluPw8jZREbGpvMKGDDbUOi_tiZAWZIMI6m0js/s1600/query.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 155px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx-BmLnkh7wbFyVnxWh_ChyeLAKLsdbhsJ_NIzVwBpA2xojYBRJguVnP5UfjbQhT2z2seipQIKNI2xoHt7a51bSh5gkMjIitBs0ufp3SluPw8jZREbGpvMKGDDbUOi_tiZAWZIMI6m0js/s400/query.JPG" alt="" id="BLOGGER_PHOTO_ID_5624302878341225314" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />In my Next, post I will delete disk, diskgroup from ASM.Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-69562914606687192402011-06-19T23:20:00.000-07:002011-06-20T01:29:36.855-07:00ASM views on ASM instance after database InstallationI have created new database with ASM based filesystem, I will execute some queries to check the result. The result will be different from my last post <a style="font-weight: bold;" href="http://rakeshocp.blogspot.com/2011/06/asm-views-on-asm-instance.html">ASM views before database installation</a>.<br /><br /><code><span style="font-weight: bold;">V$ASM_ALIAS:</span> </code>Displays a row for each alias present in every disk group mounted by the ASM instance.<br />SQL> select * from v$ASM_ALIAS;<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjluVuUaK6IzUNEUfnXpYKpfDl67O1cSvsSpr9YSCmQ7x-8kRe5Qpug4tUmVt_wXcA1HCWyQQd1hlhArezOIteehat6wJHxOCGarFYQXTNFzVYSzOmeBszRjmCzgoEkyToSZO0AlHcrgZ0/s1600/asm_alias.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 182px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjluVuUaK6IzUNEUfnXpYKpfDl67O1cSvsSpr9YSCmQ7x-8kRe5Qpug4tUmVt_wXcA1HCWyQQd1hlhArezOIteehat6wJHxOCGarFYQXTNFzVYSzOmeBszRjmCzgoEkyToSZO0AlHcrgZ0/s400/asm_alias.JPG" alt="" id="BLOGGER_PHOTO_ID_5620192264616062450" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><code style="font-weight: bold;"></code><code style="font-weight: bold;">V$ASM_CLIENT: </code>Displays a row for each database instance using a disk group managed by the ASM instance.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT9m0hg7YiDsMjPmBer2kbUu6dD-Kh4eohoIcnp-z_9Gq2b2BQ6BR66yg5l8Gxe85mRzDlJ9RNJLN5Kf-BpOsmWZgy0P_YZXpWvR27jGWXxRhQYZh9ZULZEjeiO1IHjxbrlj9kSnW9-ys/s1600/asm_client.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 105px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT9m0hg7YiDsMjPmBer2kbUu6dD-Kh4eohoIcnp-z_9Gq2b2BQ6BR66yg5l8Gxe85mRzDlJ9RNJLN5Kf-BpOsmWZgy0P_YZXpWvR27jGWXxRhQYZh9ZULZEjeiO1IHjxbrlj9kSnW9-ys/s400/asm_client.JPG" alt="" id="BLOGGER_PHOTO_ID_5620194763509106130" border="0" /></a><br /><br /><br /><br /><br /><code><br /><br /><span style="font-weight: bold;">V$ASM_DISK</span></code><span style="font-weight: bold;">:</span> Displays a row for each disk discovered by the ASM instance, including disks which are not part of any disk group.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiavfIM4QZ4L8y6ybmzPRg9YiWVyBGsTk6ZZXp71jhDLwb0PjSN2ecLL97RHOwv-Q2yp0D51h0jJLPf0tryYmfR-uStb1aWE18ySYOpawGu2L0Bc543ABQgAfvTZTJUBPaysCrrY5sWy4c/s1600/ASM_DISK.bmp"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 77px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiavfIM4QZ4L8y6ybmzPRg9YiWVyBGsTk6ZZXp71jhDLwb0PjSN2ecLL97RHOwv-Q2yp0D51h0jJLPf0tryYmfR-uStb1aWE18ySYOpawGu2L0Bc543ABQgAfvTZTJUBPaysCrrY5sWy4c/s400/ASM_DISK.bmp" alt="" id="BLOGGER_PHOTO_ID_5620196943616370306" border="0" /></a><br /><br /><br /><br /><br /><code style="font-weight: bold;">V$ASM_DISKGROUP:</code> Displays a row for each disk group discovered by the ASM instance.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf9_AbltRkc2A1R8IDZomVzIQigJpbwkk9zgLtjrIGxen6oWuq7nCwoRf_Mh_-Q05g8s5I8Iel1i1iz0rZmClX6TFRozaDBMQ6CTxRWSrN7PMyAE9ExXXbjA6N9GQir9bCD4zwnrwpR9I/s1600/ASM_DISKGROUP.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 80px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhf9_AbltRkc2A1R8IDZomVzIQigJpbwkk9zgLtjrIGxen6oWuq7nCwoRf_Mh_-Q05g8s5I8Iel1i1iz0rZmClX6TFRozaDBMQ6CTxRWSrN7PMyAE9ExXXbjA6N9GQir9bCD4zwnrwpR9I/s400/ASM_DISKGROUP.JPG" alt="" id="BLOGGER_PHOTO_ID_5620198737850545330" border="0" /></a><br /><br /><br /><br /><br /><code style="font-weight: bold;">V$ASM_FILE: </code>Displays a row for each file for each disk group mounted by the ASM instance.<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb0Re-6-1Jgd5AKewzAmyB-ar_p2gWlR-s5IJMPwDD4QR506NzcmlBSYvsvsh59sXO-cNsbIYYg7xJ2oNEqeu2NtNF0kmbLEs9e6Ecj-CboskDmUnBI8rPYLp9QxkuUuLqAZENl2JEK-M/s1600/asm_file.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 174px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb0Re-6-1Jgd5AKewzAmyB-ar_p2gWlR-s5IJMPwDD4QR506NzcmlBSYvsvsh59sXO-cNsbIYYg7xJ2oNEqeu2NtNF0kmbLEs9e6Ecj-CboskDmUnBI8rPYLp9QxkuUuLqAZENl2JEK-M/s400/asm_file.JPG" alt="" id="BLOGGER_PHOTO_ID_5620209455998471138" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><code style="font-weight: bold;">V$ASM_OPERATION: </code>Displays a row for each file for each long running operation executing in the ASM instance.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5kAU0fcCLCzPv2Wk0HKYkOZkn1LgBux5HdELIkpuT3WzIl3CIQK08237utGF1UswjXb9rDAMoYMfO7d358iu0_WsLDVturzOBiEQqKAdiEus8GRe3rO9_h-F0JVIcGEdEw7jM7evzs9E/s1600/asm_operation.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 174px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5kAU0fcCLCzPv2Wk0HKYkOZkn1LgBux5HdELIkpuT3WzIl3CIQK08237utGF1UswjXb9rDAMoYMfO7d358iu0_WsLDVturzOBiEQqKAdiEus8GRe3rO9_h-F0JVIcGEdEw7jM7evzs9E/s400/asm_operation.JPG" alt="" id="BLOGGER_PHOTO_ID_5620211512345326834" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><code style="font-weight: bold;">V$ASM_TEMPLATE: </code>Displays a row for each template present in each disk group mounted by the ASM instance.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvCYMn7mTNJytrI7nznydl_OQk3MaPnNpZey1-G45Yqy-723gbtQGMIXtrGD-sXtOe8Ud12_yZvByAuj6zZG2-UKOJ1xKowQ2DJ1v4cnooeOQeUMMLlFEN1q89QpnJy_VTRgEyiPW6n5c/s1600/asm_template.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 174px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhvCYMn7mTNJytrI7nznydl_OQk3MaPnNpZey1-G45Yqy-723gbtQGMIXtrGD-sXtOe8Ud12_yZvByAuj6zZG2-UKOJ1xKowQ2DJ1v4cnooeOQeUMMLlFEN1q89QpnJy_VTRgEyiPW6n5c/s400/asm_template.JPG" alt="" id="BLOGGER_PHOTO_ID_5620213454629724114" border="0" /></a>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-43938403484129999772011-06-09T21:23:00.000-07:002011-06-10T02:11:50.120-07:00Creating Database with ASM File SystemI am creating database using DBCA, and specify Automatic Storage Management as FileSystem.<br />Welcome screen of DBCA (Database Configuration Assistant)<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwtawuA7DpxSyDnKBhT6qfSs8infq_pcSq63fP9kTgQhjyDVCCxMUcwg_bRvi1uVf5CmOThHaEkAmrRTUhiImbN-94j9RugS-vG53zKmiiIULwtsi1w2mlaeM7m9PdLp0uCECDX-uTJRI/s1600/welcome.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 284px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwtawuA7DpxSyDnKBhT6qfSs8infq_pcSq63fP9kTgQhjyDVCCxMUcwg_bRvi1uVf5CmOThHaEkAmrRTUhiImbN-94j9RugS-vG53zKmiiIULwtsi1w2mlaeM7m9PdLp0uCECDX-uTJRI/s400/welcome.JPG" alt="" id="BLOGGER_PHOTO_ID_5616459297004966706" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Step one of DBCA, Here we will select the Create a Database option.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjzJYEGvky_PiiKP5DqoFFoUygZi9mt5-J4urjNCbcLqqR3iEVJJj6aYILD_4M15PTNx12QsX59VsP5tfgI8GQ8TtyfGEmKBzblR3KdnWB37bPptJvVmp92tvqp7F1MPvjHPfIscX8g5o/s1600/1+of+12.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 283px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjzJYEGvky_PiiKP5DqoFFoUygZi9mt5-J4urjNCbcLqqR3iEVJJj6aYILD_4M15PTNx12QsX59VsP5tfgI8GQ8TtyfGEmKBzblR3KdnWB37bPptJvVmp92tvqp7F1MPvjHPfIscX8g5o/s400/1+of+12.JPG" alt="" id="BLOGGER_PHOTO_ID_5616456372241102066" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Step three, My database name and sid is "RAKESH"<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx9QZTptZTcYic6DnfKN_IVSAphd41ZbE0Zt4WF4QhMDbZSzGD6poqYQLQVuLp0mxtbwmU2F2MM9UtJ5nchURfxKRB_kw-t_EJCSfba68a6wvMXHAfidHq4q268xJdifVk-GpVpCdtqkU/s1600/3+of+12.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 283px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx9QZTptZTcYic6DnfKN_IVSAphd41ZbE0Zt4WF4QhMDbZSzGD6poqYQLQVuLp0mxtbwmU2F2MM9UtJ5nchURfxKRB_kw-t_EJCSfba68a6wvMXHAfidHq4q268xJdifVk-GpVpCdtqkU/s400/3+of+12.JPG" alt="" id="BLOGGER_PHOTO_ID_5616458869387417426" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Step 6 of 13<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijBVZvc7oYnPFg3wS7pUTVtho4BoPWWcew8WSgtPsnHfxS3l9gcKodnaVAjGgdmE9OD09XTTrvrSrJrxi6PhhgKjIoD1DtIHue_5ohPReaMDf8cI4gkLYpVZUkwReoVLRpcq66fENA5XU/s1600/6+of+13.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 283px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijBVZvc7oYnPFg3wS7pUTVtho4BoPWWcew8WSgtPsnHfxS3l9gcKodnaVAjGgdmE9OD09XTTrvrSrJrxi6PhhgKjIoD1DtIHue_5ohPReaMDf8cI4gkLYpVZUkwReoVLRpcq66fENA5XU/s400/6+of+13.JPG" alt="" id="BLOGGER_PHOTO_ID_5616461264479949874" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />After pressing the next button, window will prompt for sys ASM password<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEh9nj5gtRczHdAJrWFJ5Tnk4yvL87ds0utDExY2EGCiTiNgk2OqlmY9vbe52_JokVqcS0x9XPvTw4W5aRmBOVTSeBqZH62vcKDgocriiT8K2Y2xg7NEKV0Gx6zli1VzZ4jfqt4aQpkeQ/s1600/6b+of+13+.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 281px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEh9nj5gtRczHdAJrWFJ5Tnk4yvL87ds0utDExY2EGCiTiNgk2OqlmY9vbe52_JokVqcS0x9XPvTw4W5aRmBOVTSeBqZH62vcKDgocriiT8K2Y2xg7NEKV0Gx6zli1VzZ4jfqt4aQpkeQ/s400/6b+of+13+.JPG" alt="" id="BLOGGER_PHOTO_ID_5616463347335019170" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />In next step, It will ask for the diskgroup that to be used for the Storage, As I have created only one diskgroup DATA, I will select it only.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkvxgumWCvdtFHRQdXuEcr3X0sZ3CljQW2n2tHNQ5iJtJrAxMtclwrLjM_FfYRfk28MXJklQJgy4cQRQqBQzvfyVKtx_7h6qkEkL8yij1AOwM_jKhToazut3znmEmp8B76z6pXM0EHQDs/s1600/7+of+13.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 283px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkvxgumWCvdtFHRQdXuEcr3X0sZ3CljQW2n2tHNQ5iJtJrAxMtclwrLjM_FfYRfk28MXJklQJgy4cQRQqBQzvfyVKtx_7h6qkEkL8yij1AOwM_jKhToazut3znmEmp8B76z6pXM0EHQDs/s400/7+of+13.JPG" alt="" id="BLOGGER_PHOTO_ID_5616465238336037650" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />In next step I specified the files should be OMF Files<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQVCuch29olgkgIJomI81YR9ifBcFcH7osSisA8As92fjjK2K-Ag7HvtxIhg3NwmfJqvC49GalQEotr_WjZEBiUgF7GVHerrYQj0WLvHTLpoj4b3i58RYXCQxoIRptZx8Pk-dj5cWRTOU/s1600/8+of+13.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 283px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQVCuch29olgkgIJomI81YR9ifBcFcH7osSisA8As92fjjK2K-Ag7HvtxIhg3NwmfJqvC49GalQEotr_WjZEBiUgF7GVHerrYQj0WLvHTLpoj4b3i58RYXCQxoIRptZx8Pk-dj5cWRTOU/s400/8+of+13.JPG" alt="" id="BLOGGER_PHOTO_ID_5616467154770976626" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Step 9 of 13: Flash Recovery Area,<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDUeBN_PnqXF-q7VLHXISGnHtD-EmBTmjZ2nC7lUFB01FxX0KGBREFSL-zljqSVFh7DewHpOvMmCdjH8ZgEyxOHnk1mQL2Yzt_OUXKW0l5uRJ5CMP7Tgm6wJiwmAfDxwGiiqwlnUts21k/s1600/9+of+13.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 283px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDUeBN_PnqXF-q7VLHXISGnHtD-EmBTmjZ2nC7lUFB01FxX0KGBREFSL-zljqSVFh7DewHpOvMmCdjH8ZgEyxOHnk1mQL2Yzt_OUXKW0l5uRJ5CMP7Tgm6wJiwmAfDxwGiiqwlnUts21k/s400/9+of+13.JPG" alt="" id="BLOGGER_PHOTO_ID_5616483186196536770" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />After the successful installation of Oracle Database with ASM File system, I log in at Enterprise Manager to verify datafiles storage. On the main page of Oracle EM, I got new link for ASM instance, check below image.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4SiUqcMUvdvZj_Bu1HLCVvJsK9hsXcLum4zxnKxHKnPNg3QDvH_CqKYtl81jRv8wWQQyP81-M4v1Cg95LLhJPmbMaqMN6F9HYozIOgq1Pwf4rgPr2W6yv3BG6kwtCAzPo8npxun-5ViQ/s1600/ASM+in+EM.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 327px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4SiUqcMUvdvZj_Bu1HLCVvJsK9hsXcLum4zxnKxHKnPNg3QDvH_CqKYtl81jRv8wWQQyP81-M4v1Cg95LLhJPmbMaqMN6F9HYozIOgq1Pwf4rgPr2W6yv3BG6kwtCAzPo8npxun-5ViQ/s400/ASM+in+EM.JPG" alt="" id="BLOGGER_PHOTO_ID_5616497904494018018" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />After clicking on the +ASM_standby link, I was directed to a below ASM page in EM. .<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx6uc0yIFJ-aTShrOGY9ZgiqGMASkPqF5ClU5cS2JHWqwf8rp9MdiP6Eg9NF5gtTyo80Q1U94Qx-H-anRMHdSMbThaITH0UVUjPZsJ7BUX1xZ-kw4f0sUmKPuELtWf5jDI52xLMH_j5pk/s1600/3.+ASM+Data+in+EM.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 243px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx6uc0yIFJ-aTShrOGY9ZgiqGMASkPqF5ClU5cS2JHWqwf8rp9MdiP6Eg9NF5gtTyo80Q1U94Qx-H-anRMHdSMbThaITH0UVUjPZsJ7BUX1xZ-kw4f0sUmKPuELtWf5jDI52xLMH_j5pk/s400/3.+ASM+Data+in+EM.JPG" alt="" id="BLOGGER_PHOTO_ID_5616510427788000194" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><span style="display: block;" id="formatbar_Buttons"><span onmouseover="ButtonHoverOn(this);" onmouseout="ButtonHoverOff(this);" onmouseup="addImage();" onmousedown="CheckFormatting(event);;ButtonMouseDown(this);" class=" on" style="display: block;" id="formatbar_Add_Image" title="Add Image"><img src="http://www.blogger.com/img/blank.gif" alt="Add Image" class="gl_photo" border="0" /></span></span><br />Data Files in ASM<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaDvJFG9j7NlYw3qmsEjK-35TxRxqxSCOU3O6Fq3OaqqHmb3UJEOP98GM7Dk2VeC6RUPNCd1pWsD-jH5-G7nQAHi2ZW1D4zrHv-iMqnJs7o1PR04v_9vTSfQx645FSWdOEOMZ-n08u1XA/s1600/Data+Files.JPG"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 259px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaDvJFG9j7NlYw3qmsEjK-35TxRxqxSCOU3O6Fq3OaqqHmb3UJEOP98GM7Dk2VeC6RUPNCd1pWsD-jH5-G7nQAHi2ZW1D4zrHv-iMqnJs7o1PR04v_9vTSfQx645FSWdOEOMZ-n08u1XA/s400/Data+Files.JPG" alt="" id="BLOGGER_PHOTO_ID_5616513891353914034" border="0" /></a>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-56455064332385716152011-06-08T22:56:00.000-07:002011-06-19T23:12:04.573-07:00ASM views on ASM Instance before database Installation.As in my previous post <a href="http://rakeshocp.blogspot.com/2011/06/asm-basic-configuration-at-local-disk.html">ASM basic configuration</a> I created an ASM instance, now I will execute some queries to get some more detail & get some experience on ASM instance. I have not created database yet, its simple ASM instance creation without having database instance, So queries result can be different from the one with ASM based filesystem. I will create ASM database in my next post.<br /><br />A very good article has been given on <a href="http://www.oracle-base.com/articles/10g/AutomaticStorageManagement10g.php">ASM 10g at ORACLE-BASE </a>website, and list of v$views has been given in this article, I will execute them at ASM instance one by one.<br /><br />The ASM configuration can be viewed using the v$ASM_, which often contain different information depending on whether they are queried from the ASM instance, or a dependent database instance.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ9i2ArqYL7HheQPRQZ7hbkwncVzr8hXuSW_1lu_p8SkI6TihsWT0fd9y9KD1-czmFMW7BniBdZvZJcGCPGNqNFXw3G-bxLPMF-XcI8N_XrWQenxnLhmGuIaXTFifcp8ysEspKXM2_-50/s1600/3+ASM+start.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 251px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616097987879040898" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ9i2ArqYL7HheQPRQZ7hbkwncVzr8hXuSW_1lu_p8SkI6TihsWT0fd9y9KD1-czmFMW7BniBdZvZJcGCPGNqNFXw3G-bxLPMF-XcI8N_XrWQenxnLhmGuIaXTFifcp8ysEspKXM2_-50/s400/3+ASM+start.bmp" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><code style="FONT-WEIGHT: bold">V$ASM_ALIAS : </code>Displays a row for each alias present in every disk group mounted by the ASM instance. Here the ASM_ALIAS will not return any rows, because we have not created any database that use this ASM as filesystem.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnh6Z8YdsUzw2KJrdL74vmOqG_a6NbuejX2ODmJzeGtGTyF5u7DvBTp5hy5ScOqvMtKOGJYUKnC6SxEeWp9e-zQZblFuuQyJ5pYgCKWBMf_xIuc9GOKffFqffJz3Ca4mT05lKhhxlUFGw/s1600/ASM_ALIAS.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 109px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616099658573491602" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnh6Z8YdsUzw2KJrdL74vmOqG_a6NbuejX2ODmJzeGtGTyF5u7DvBTp5hy5ScOqvMtKOGJYUKnC6SxEeWp9e-zQZblFuuQyJ5pYgCKWBMf_xIuc9GOKffFqffJz3Ca4mT05lKhhxlUFGw/s400/ASM_ALIAS.bmp" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><code style="FONT-WEIGHT: bold">V$ASM_CLIENT: </code>Displays a row for each database instance using a disk group managed by the ASM instance.<br />As we have not created any database yet, who can use this diskgroup (data) in ASM, so query will not result any rows at this time.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc_I0vAEHzkTnTQWni9wD-bBl8d0JJixaLNIE5syTQxuRsGsTzVYOUeWGhq0OwezlTPLQ3hKa3Z1f09SIJMvOHtY-RHd_aUJcz22nfR_HZbO2NmW6pdES4wsl3dv2mBvtJVRH_iFrA02o/s1600/ASM_CLIENT.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 138px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616100624631964834" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc_I0vAEHzkTnTQWni9wD-bBl8d0JJixaLNIE5syTQxuRsGsTzVYOUeWGhq0OwezlTPLQ3hKa3Z1f09SIJMvOHtY-RHd_aUJcz22nfR_HZbO2NmW6pdES4wsl3dv2mBvtJVRH_iFrA02o/s400/ASM_CLIENT.bmp" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><code style="FONT-WEIGHT: bold">V$ASM_DI</code><code style="FONT-WEIGHT: bold">SK : </code>Displays a row for each disk discovered by the ASM instance, including disks which are not part of any disk group.<br />As, I have created two disks, then query should return two rows for each disk.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfiCe20l-x0mIVr5omn57yZpVitJjlOAk-0hXrSMtItbsedAD37l8s-MmhnlPfEX8nrLUQ8ZequynKcDrRlJCfB71eTE6VRUXQNihAUH1h_9jL40BYG1-ouAmKbVL7nkQYFxICAnjTuUA/s1600/ASM_DISK.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 77px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616102069788292322" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfiCe20l-x0mIVr5omn57yZpVitJjlOAk-0hXrSMtItbsedAD37l8s-MmhnlPfEX8nrLUQ8ZequynKcDrRlJCfB71eTE6VRUXQNihAUH1h_9jL40BYG1-ouAmKbVL7nkQYFxICAnjTuUA/s400/ASM_DISK.bmp" border="0" /></a><br /><br /><br /><br /><br /><code><span style="FONT-WEIGHT: bold">V$ASM_DISKGROUP :</span> </code>Displays a row for each disk group discovered by the ASM instance.<br />I have created only one diskgroup DATA, query should return one row only.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg58yFf_JAue_K_M9e1ljDNFzwWBxMixZlh9c8uVKK6yBxPCLaGBlnbN_VvIZGAvFwgQPgXn94IaBPRrGO5ha7_qNgPcfvYve3PekKSlhJTCZpwvOWV9mcwHKA15YTg_fJ0FCmSpueQhec/s1600/ASM_DISKGROUP.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 111px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616104630893984786" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg58yFf_JAue_K_M9e1ljDNFzwWBxMixZlh9c8uVKK6yBxPCLaGBlnbN_VvIZGAvFwgQPgXn94IaBPRrGO5ha7_qNgPcfvYve3PekKSlhJTCZpwvOWV9mcwHKA15YTg_fJ0FCmSpueQhec/s400/ASM_DISKGROUP.bmp" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><code style="FONT-WEIGHT: bold">V$ASM_FILE : </code>Displays a row for each file for each disk group mounted by the ASM instance.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp6TPj8YF3t5GWk4_hljt6HTwdvQroCSNFhLdkD0mReL0SHMUiDcZmTPu8jbB-6bRCo0nnusF0PA15uVeubyLkYFSQXgVEMIkOm5i2SjFBj3jacR3yzInHDKi4cyTigCdsHQzwmyPFaoQ/s1600/ASM+FILE.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 126px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616106330653390994" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp6TPj8YF3t5GWk4_hljt6HTwdvQroCSNFhLdkD0mReL0SHMUiDcZmTPu8jbB-6bRCo0nnusF0PA15uVeubyLkYFSQXgVEMIkOm5i2SjFBj3jacR3yzInHDKi4cyTigCdsHQzwmyPFaoQ/s400/ASM+FILE.bmp" border="0" /></a><br /><br /><br /><br /><span style="TEXT-DECORATION: underline"><br /><br /><br /><br /></span><code style="FONT-WEIGHT: bold">V$ASM_OPERATION :</code> Displays a row for each file for each long running operation executing in the ASM instance.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaPccGB9s_A_Yl79SEdkytx8GHbq0f25S1JEzjtvPICa22gOdMlBeiqAwVcQPnLQH4GwN_Lns8fUV7cAm62Y3S8JfvLvfkH1mJpJiNP5eSVXd3DURgqjnTcVzp6LemFO8e8nZ4Vzlixfg/s1600/ASM_OPERATION.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 150px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616107377915162786" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaPccGB9s_A_Yl79SEdkytx8GHbq0f25S1JEzjtvPICa22gOdMlBeiqAwVcQPnLQH4GwN_Lns8fUV7cAm62Y3S8JfvLvfkH1mJpJiNP5eSVXd3DURgqjnTcVzp6LemFO8e8nZ4Vzlixfg/s400/ASM_OPERATION.bmp" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><code style="FONT-WEIGHT: bold">V$ASM_TEMPLATE: </code>Displays a row for each template present in each disk group mounted by the ASM instance.<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWL-ce5aUgYplyoUtVVu7DhrjQFCqZ6_bNQC6iHJwbnRMiZjBjnAVodOIHqbKHv4zBd1AkIiurIc7uV1ppGZ9-J-hkgDWtwCslqgvDmXU6UZPzP0At-t_pvv8uXqL9FTXK5jzQhU7sBy8/s1600/ASM_TEMPLATE.bmp"><img style="MARGIN: 0px 10px 10px 0px; WIDTH: 400px; FLOAT: left; HEIGHT: 222px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5616108372188117586" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWL-ce5aUgYplyoUtVVu7DhrjQFCqZ6_bNQC6iHJwbnRMiZjBjnAVodOIHqbKHv4zBd1AkIiurIc7uV1ppGZ9-J-hkgDWtwCslqgvDmXU6UZPzP0At-t_pvv8uXqL9FTXK5jzQhU7sBy8/s400/ASM_TEMPLATE.bmp" border="0" /></a>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-83328801758719853122011-06-06T03:08:00.000-07:002011-06-08T00:31:09.579-07:00ASM basic configuration at LOCAL DISK<span style="font-weight: bold; color: rgb(0, 0, 153);">I am writing below steps to create a ASM instance, ASM diskgroup and ASM disks on local machine, as I dont have RAW device, it will be on LOCAL DISK (NTFS) D drive, Once, the ASM instance is created, I will use</span><span style="font-weight: bold; color: rgb(0, 0, 153);"> DBCA to create database and specify Automatic Storage management as filesystem.</span><br />ONE:Creating disk for ASM Instance, I am creating three disk of 1GB size.<br /><br />D:\>mkdir asmdisk<br /><br />D:\>asmtool -create d:\asmdisk\disk1 1024<br /><br />D:\>asmtool -create d:\asmdisk\disk2 1024<br /><br />D:\><br />I have created a folder asmdisk, and two disks each size of 1GB. Now, we can use these disks to create ASM disk group.<br /><br /><div style="text-align: left;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxVgSjARvPhA4JHwV4KLg4p7xc76nvYDDXzOZgOp6vPXtuCF8rZzTneomGeNTxz-x0Hf6nl4F8-Bub0bV6SqrSlkibM4Lzwtfc8-AV5kRButFdyJjn8aANhIW0Jk4KBE-FoZ5V6CtZ5B4/s1600/asm+disks.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 143px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxVgSjARvPhA4JHwV4KLg4p7xc76nvYDDXzOZgOp6vPXtuCF8rZzTneomGeNTxz-x0Hf6nl4F8-Bub0bV6SqrSlkibM4Lzwtfc8-AV5kRButFdyJjn8aANhIW0Jk4KBE-FoZ5V6CtZ5B4/s400/asm+disks.JPG" alt="" id="BLOGGER_PHOTO_ID_5615716910091459650" border="0" /></a><br />2 : Creating an ASM instance<br /><br />We need to configure Cluster Synchronization Services.<br />The Cluster Synchronization Services is required to enable synchronization between ASM and its client database.<br /><br />2.a- Configuration of CSS ( Cluster Synchronization Servie )<br /><br />C:\oracle\product\10.2.0\db_2\BIN>localconfig add<br />Step 1: creating new OCR repository<br />Successfully accumulated necessary OCR keys.<br />Creating OCR keys for user 'administrator', privgrp ''..<br />Operation successful.<br />Step 2: creating new CSS service<br />successfully created local CSS service<br />successfully added CSS to home<br /><br />C:\oracle\product\10.2.0\db_2\BIN><br /><br />When we check services <span style="font-weight: bold;">OracleCSService</span> is created and started.<br /><br />2.b :We need to create a init pfile (init.+ASM.ora) for ASM instance<br /><br />INSTANCE_TYPE=ASM<br />DB_UNIQUE_NAME=+ASM<br />LARGE_POOL_SIZE=8M<br />ASM_DISKSTRING='D:\asmdisk\*'<br />_ASM_ALLOW_ONLY_RAW_DISKS=FALSE<br /><br />2.c : we need to create a password file for ASM instance, and its password is soni.<br /><br />C:\oracle\product\10.2.0\db_2\BIN>orapwd file=C:\oracle\product\10.2.0\db_2\database\PWD+ASM.ora password=soni<br /><br />C:\oracle\product\10.2.0\db_2\BIN><br /><br />2.d : we need to create Oracle ASM instance<br /><br />C:\oracle\product\10.2.0\db_2\BIN>oradim -NEW -ASMSID +ASM -STARTMODE auto<br />Instance created.<br /><br />THREE: Creating an ASM disk group.<br /><br />SQL> select path, mount_status from v$asm_disk;<br /><br />PATH MOUNT_S<br />---------------------------------------- -------<br />D:\ASMDISK\DISK1 CLOSED<br />D:\ASMDISK\DISK2 CLOSED<br /><br />SQL> create diskgroup data external redundancy disk<br />2 'D:\ASMDISK\DISK1', 'D:\ASMDISK\DISK2';<br /><br />Diskgroup created.<br /><br />SQL> select path, mount_status from v$asm_disk;<br /><br />PATH MOUNT_S<br />---------------------------------------- -------<br />D:\ASMDISK\DISK1 CACHED<br />D:\ASMDISK\DISK2 CACHED<br /><br />SQL> create spfile from pfile;<br /><br />File created.<br /><br />SQL> startup force;<br />ASM instance started<br /><br />Total System Global Area 79691776 bytes<br />Fixed Size 1247396 bytes<br />Variable Size 53278556 bytes<br />ASM Cache 25165824 bytes<br />ORA-15110: no diskgroups mounted<br /><br /><br />SQL> alter system set asm_diskgroups= data scope=spfile;<br /><br />System altered.<br /><br />SQL> startup force;<br />ASM instance started<br /><br />Total System Global Area 79691776 bytes<br />Fixed Size 1247396 bytes<br />Variable Size 53278556 bytes<br />ASM Cache 25165824 bytes<br />ASM diskgroups mounted<br />SQL><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5H1TLlzJb7emNtWkJ_IAIiaPx9EcO4VOxT8hFafGnsC2TvpSImW0IczMKWCOzpib1IPnaqYzmSngmvINtQQeUDSLFk54eDtcJfW8fWLlqXlOfDXDfwShLwyDWfCZoD4cyJ3SiUopkvSQ/s1600/asm+diskgroup.bmp"><br /></a><br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsyZhb9LinMKnuSKxIYV-FhEeQ4Uu8uKYxycuiSaPldk04OF-7vCXSGNZYKeBFZLNeQtrixq49HdRw-TMCqqSm0qWH9SF2Ibo2E0ystLOIQDCwwEHr5pMQwpkdYahTQdAnGHmWzxMogfA/s1600/asm+diskgroup.bmp"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 397px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsyZhb9LinMKnuSKxIYV-FhEeQ4Uu8uKYxycuiSaPldk04OF-7vCXSGNZYKeBFZLNeQtrixq49HdRw-TMCqqSm0qWH9SF2Ibo2E0ystLOIQDCwwEHr5pMQwpkdYahTQdAnGHmWzxMogfA/s400/asm+diskgroup.bmp" alt="" id="BLOGGER_PHOTO_ID_5615744993262852450" border="0" /></a><br /><span style="color: rgb(0, 0, 0);">I will use</span><span style="color: rgb(0, 0, 0);"> DBCA to create database and specify Automatic Storage management as filesystem.</span><br /><br /></div>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-30451402468843530792011-01-03T23:13:00.000-08:002011-01-07T02:29:41.575-08:00Enterprise Manager issuesI have installed Oracle 10g software and then created database using DBCA, When I was configuring Enterprise Manager, and checking it's status with "emctl status dbconsole" I was getting below errors.<br /><> OC4j DB console sid not found<br /><> Unable to determine local host from URL REPOSITORY_URL=http://iu-test:%EM_UPLOAD_PORT%/em/upload<br />I dropped the repository with " emca -deconfig dbcontrol db -repos drop "<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTL-SbRCCCybU_SU0kGMc_UB87gcv6ShmmXC-rUbnhn3JirxhztcQR6Kj8Iyv0Y9kIXfUSfi-SmrEUtIP3HyZPQF9KwRolQReg1fvkO_MsGJ-Zyip4RDOd61MtxjJuhD1Ofs-A-lpm3nU/s1600/1+drop.JPG"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 400px; DISPLAY: block; HEIGHT: 207px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5559385146589303394" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTL-SbRCCCybU_SU0kGMc_UB87gcv6ShmmXC-rUbnhn3JirxhztcQR6Kj8Iyv0Y9kIXfUSfi-SmrEUtIP3HyZPQF9KwRolQReg1fvkO_MsGJ-Zyip4RDOd61MtxjJuhD1Ofs-A-lpm3nU/s400/1+drop.JPG" /></a><br /><div>Then I created the repository with " emca -config dbcontrol db -repos create "</div><div></div><div></div><br /><div></div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEju6D5fl8QhPAeKZXyTY6N4PnWzjCd_mQVBuctIWsvEFSO4_NbatkxNN_jDQ_DV718W7GBq5_egpGmc2xbmvpwaW3Ccy66MilGUCepH6Z6z94M4y1lIRRQ-Gk_oAB9UIeW8sB604XJVQas/s1600/2+create.JPG"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 400px; DISPLAY: block; HEIGHT: 235px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5559383999994406018" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEju6D5fl8QhPAeKZXyTY6N4PnWzjCd_mQVBuctIWsvEFSO4_NbatkxNN_jDQ_DV718W7GBq5_egpGmc2xbmvpwaW3Ccy66MilGUCepH6Z6z94M4y1lIRRQ-Gk_oAB9UIeW8sB604XJVQas/s400/2+create.JPG" /></a><br /><div>Enterprise manager is now configured and working. !!!!!<br /><div><div></div><div></div><div></div><div></div><div></div><div></div><div> </div></div></div></div>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-58689436274296487622010-10-13T00:41:00.000-07:002010-10-13T01:21:43.192-07:00R12 APPS DBA + R12 SYS ADMIN<span class="Apple-style-span"><span class="Apple-style-span" style="font-size: 11px;">I have recently started ORACLE APPS DBA (R12) TRAINING with 2 below mentioned courses.</span></span><div><span class="Apple-style-span"><span class="Apple-style-span" style="font-size: 11px;"><br /></span></span><div><span class="Apple-style-span"><span class="Apple-style-span" style="font-size: 11px;"><> R12 Oracle: Install, Patch, and Maintain Oracle Applications and</span></span></div><div><span class="Apple-style-span"><span class="Apple-style-span" style="font-size: 11px;"><> R12 Oracle Applications System Administrator.</span></span></div><div><span class="Apple-style-span"><span class="Apple-style-span" style="font-size: 11px;"><br />We have learned how to install R12 EBS in our training session. The installation consist on number of DVDs and we need to create a STAGE directory, it requires over 150GB Hard Disk space, 4GB RAM (recommended) and installtion took couple of hours to complete.<br /><br />I will write complete installation steps in my next post.<br /><br /><br /></span></span></div></div>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-64903342973287645032010-06-24T22:32:00.000-07:002010-06-28T00:11:25.633-07:00crontab doesnt execute bash profile..Crontab doesnt execute bash profile.....check below errors and then solution with examples......<br />I have created a bash script rakesh.sh<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />#!bin/bash<br />export DATE=$(date +"%m_%d_%y_%H:%M:%S_%p")/u01/app/oracle/product/10.2.0/db_1/bin/exp <a href="mailto:rakesh/rakesh@rockdb">rakesh/rakesh@rockdb</a> file=/home/oracle/backups/rakesh$DATE.dmp log=/home/oracle/backups/rakesh$DATE.log statistics=none<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />The script is runing perfectly fine from commandline. ./rakesk.sh<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />[oracle<a href="mailto:oracle@oraclelinux">@oraclelinux</a> bin]$ crontab -e SHELL=/bin/bash<br />PATH=/sbin:/bin:/usr/sbin:/usr/bin<br />MAILTO=oracle<br />HOME=/<br />*/5 * * * * sh /home/oracle/rakesh.sh<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />The above crontab command is failed when we check the /var/spool/mail/oracle file, the log file says:<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />Invalid format of Export Utility name<br />verify that ORACLE_HOME is properly set<br />Export terminiated unsuccessfully<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />Solution: CRON does not execute .bash_profile or .profile. We need to set environment variables in the script. I have modified the script as below, and now its working fine, runing every five minutes..<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />#!/bin/bash<br />export ORACLE_SID=db<br />export PATH=$PATH:/usr/local/bin<br />ORAENV_ASK=NO<br />. oraenv<br />ORAENV_ASK=YES<br />export DATE=$(date +"%m_%d_%y_%H:%M:%S_%p")/home/oracle/oracle/product/10.2.0/db_1/bin/exp <a href="mailto:rakesh/rakesh@rockdb">rakesh/rakesh@rockdb</a> file=/home/oracle/backups/test$DATE.dmp log=/home/oracle/backups/test$DATE.log statistics=none<br />- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -<br />Now its working :) :)Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-26921420534510883662010-06-17T22:32:00.000-07:002010-06-17T23:10:40.299-07:00Automating Oracle DB startup in LinuxI am writing steps that will auto start Oracle Database along with linux OS startup.<br /><br />1. connect with Oracle user and edit the "/etc/oratab" file setting flag to 'Y'. soni:/home/oracle/oracle/product/10.2.0/db_1:Y<br />2. connect wih root user- created empty file (/etc/init.d/dbora) and write:<br /><br /><br /><p align="center"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCfxfii3l9apDW3HAtj2rvh5UEmaYHQciAwIlhFQdwvRcY8MgRcLHwVtJ2cX07rHU7S9eQEMWt-_GnUrsI-W91kXgd4-W7mikkfzcPpTAbowY9PnAn1A61k2sTEOiTmLi8GmqLEVcswRs/s1600/image+-+Auto+start+DB+in+Linux.bmp"><img id="BLOGGER_PHOTO_ID_5483986967600159314" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 381px; CURSOR: hand; HEIGHT: 400px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCfxfii3l9apDW3HAtj2rvh5UEmaYHQciAwIlhFQdwvRcY8MgRcLHwVtJ2cX07rHU7S9eQEMWt-_GnUrsI-W91kXgd4-W7mikkfzcPpTAbowY9PnAn1A61k2sTEOiTmLi8GmqLEVcswRs/s400/image+-+Auto+start+DB+in+Linux.bmp" border="0" /></a></p><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />3. chmod 750 /etc/init.d/dbora<br />4. chkconfig --add dbora<br />5 check whether dbora is working or not.. as root issue /etc/init.d/dbora start<br /># /etc/init.d/dbora start<br />Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr<br />Processing Database instance "soni": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log<br /><br />We got any error in listner settings... This is due to a hard coded path in the dbstart script. To correct this, connect with Oracle user, edit the "$ORACLE_HOME/bin/dbstart" script and replace the following line (approximately line 78): ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle with <strong>ORACLE_HOME_LISTNER=$ORACLE_HOME </strong>and then check<br /># /etc/init.d/dbora start<br />Processing Database instance "soni": log file /home/oracle/oracle/product/10.2.0/db_1/startup.log<br />---------------<br />Congratz you are DONE :)Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-19315223431202337162010-06-13T22:47:00.000-07:002010-11-03T01:29:42.051-07:00Oracle Installation in LinuxAfter Linux Installation, I have installed Oracle10g 2 in Linux machine. I followed steps given at below link.<br /><a href="http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html">http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html</a><br /><a href="http://www.oracle.com/technetwork/articles/smiley-10gdb-install-092939.html">http://www.oracle.com/technetwork/articles/smiley-10gdb-install-092939.html</a><br />Check "Part II: Configuring Linux for Oracle"Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-58529320565648400992010-06-11T09:26:00.000-07:002010-06-11T09:31:10.348-07:00Linux Installation<strong>Installing Linux<br /></strong>>Boot from RHEL4 disc1<br />>press enter for graphical install<br /> ** Need at least 512MB RAM / 2.5GB Space **<br />>Manually partition your hard drive with Disk Druid<br /> /tmp = 512MB ext3 fixed size<br /> /boot = 128MB ext3 fixed size<br /> Swap = 1024MB fixed size<br /> / = fill to maximum allowable sizeRakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-17475323891697457452010-06-09T01:48:00.001-07:002010-06-09T05:51:56.623-07:00Oracle LinuxThese days, I am working on Linux OS, migrating Oracle10g database from Windows to Linux.<br />I have installed Oracle10g in Linux. I will post the steps of "Oracle10g installation in Linux", soon.Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-77224075547237017472010-03-25T01:31:00.000-07:002010-05-19T02:30:16.677-07:00Auditing database users..We have enabled auditing for database users (ERP) with below parameters.<br /><br />- AUDIT_TRAIL = 'db, extended'<br />- AUDIT ALL BY erp BY ACCESS<br />- Audit update table, delete table, insert table by erp by access;<br /><br />DB users <span style="FONT-WEIGHT: bold">batch file</span>, which is scheduled. check below post for batch file.<br /><span style="FONT-WEIGHT: bold"><a href="http://rakeshocp.blogspot.com/2010/03/dbusersbat.html">http://rakeshocp.blogspot.com/2010/03/dbusersbat.html</a><br /><br /></span>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-64569338453416942502010-03-25T01:24:00.001-07:002010-03-25T04:25:52.320-07:00DB_USERS.bat<span style="font-weight: bold;">DB_USER.bat</span><br /><br />@echo off<br /><p>for /f "tokens=1,2,3,4 delims=/ " %%a in ('date /t') do set fdate=%%a_%%c_%%b_%%d<br /><br />for /f "tokens=1,2,3,4,5,6 delims=: " %%i in ('time /t') do set HHMMSS=_%%i%%j%%k%%l%%m%%n<br /><br />sqlplus "<a href="mailto:sys/****@abamco-db">sys/****@dblive</a> as sysdba" @D:\dblog_LIVE\audit_query_for_SYS_DB_usr.txt<br /><br />zip.exe audit_log_users.zip audit_log_users.log<br />rename D:\dblog_LIVE\audit_log_users.zip audit_log_users_%fdate%_%HHMMSS%.zip<br />-------------------------------------------------------------------------<br /></p><p>Check below post for Query returning the data from the database. <a href="http://rakeshocp.blogspot.com/2010/03/backupauditqueryforsysdbusers.html">http://rakeshocp.blogspot.com/2010/03/backupauditqueryforsysdbusers.html</a><br /></p><p><br /></p><br /><span style="font-weight: bold;"></span>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-73843751762996441722010-03-08T03:22:00.000-08:002010-03-21T22:33:19.039-07:00audit_query_for_SYS_DB_users<div>set linesize 500</div><div>set pagesize 500</div>COLUMN username FORMAT A10<br />COLUMN owner FORMAT A10<br /><div>COLUMN obj_name FORMAT A32</div>COLUMN os_username FORMAT A16<br />COLUMN userhost FORMAT A18<br />COLUMN sql_text FORMAT A300<br />COLUMN sql_bind FORMAT A300<br />COLUMN extended_timestamp FORMAT A35<br /><br /><div>column tm new_value file_time noprint<br /></div><br /><div>select to_char(sysdate, 'fmDD-MON-YYYY') tm from dual;<br /><br />prompt&file_time<br /><br />spool D:\dblog_LIVE\audit_log_users.log </div><br />select username, TO_CHAR(EXTENDED_TIMESTAMP,'fmDd-MM-YYYY HH:MI:SS AM') time, owner, obj_name, os_username, userhost, sql_text, sql_bind fromDBA_audit_trailwhere to_char(extended_timestamp, 'fmDd-MM-YYYY') = to_char(SYSDATE, 'fmDd-MM-YYYY')and username not in ('sys', 'SYS', '/')and username = 'ERP_LIVE'and owner not in ('sys', 'SYS', '/')order by time;<br /><br /><div>spool off;<br /><br />EXIT;</div>Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-8551449880703431962010-03-03T00:12:00.000-08:002010-03-08T03:55:57.810-08:00DATA PUMP - Parallel Import/ExportData pump performance can be improved by using the PARALLEL parameter. This should be used in conjunction with the "%U" wildcard in the DUMPFILE parameter to allow multiple dumpfiles to be created or read.<br /><br />H:\>expdp <a href="mailto:hr/hr@rock">hr/hr@rock</a> directory=hrdir parallel=2 dumpfile=hr_hr_%U.dmp logfile=hr1_hr2.log<br /><br />Export: Release 10.2.0.1.0 - Production on Wednesday, 03 March, 2010 12:05:47<br />Copyright (c) 2003, 2005, Oracle. All rights reserved.<br />Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br />With the Partitioning, OLAP and Data Mining options<br />FLASHBACK automatically enabled to preserve database integrity.<br /><br />Starting "HR"."SYS_EXPORT_SCHEMA_01": <a href="mailto:hr/********@rock">hr/********@rock</a> directory=hrdir parallel=2 dumpfile=hr_hr_%U.dmp logfile=hr1_hr2.log<br /><br />Estimate in progress using BLOCKS method...<br />Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA<br /><br />Total estimation using BLOCKS method: 1.25 MB<br /><br />. . exported "HR"."FUND_NAV_EMAIL" 228.4 KB 7875 rows<br />. . exported "HR"."TEST_HWM" 81.27 KB 2676 rows<br />. . exported "HR"."A" 5.710 KB 10 rows<br />. . exported "HR"."AB" 4.929 KB 1 rows<br />. . exported "HR"."B" 5.695 KB 10 rows<br />. . exported "HR"."COUNTRIES" 6.093 KB 25 rows<br />. . exported "HR"."DEPARTMENTS" 6.640 KB 27 rows<br />. . exported "HR"."EMPLOYEES" 15.78 KB 107 rows<br />. . exported "HR"."EMPLOYEES_TEST" 15.71 KB 106 rows<br />. . exported "HR"."JOBS" 6.617 KB 19 rows<br />. . exported "HR"."JOB_HISTORY" 6.593 KB 10 rows<br />. . exported "HR"."LOCATIONS" 7.718 KB 23 rows<br />. . exported "HR"."REGIONS" 5.296 KB 4 rows<br />. . exported "HR"."TEST2" 4.937 KB 4 rows<br />. . exported "HR"."TEST3" 4.914 KB 1 rows<br />. . exported "HR"."TEST" 0 KB 0 rows<br />Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA<br />Processing object type SCHEMA_EXPORT/TABLE/TABLE<br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX<br />Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT<br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS<br />Processing object type SCHEMA_EXPORT/TABLE/COMMENT<br />Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE<br />Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE<br />Processing object type SCHEMA_EXPORT/VIEW/VIEW<br />Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT<br />Processing object type SCHEMA_EXPORT/TABLE/TRIGGER<br />Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS<br />Master table "HR"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded<br />******************************************************************************<br /><br />Dump file set for HR.SYS_EXPORT_SCHEMA_01 is:<br />D:\HR_DIR\HR_HR_01.DMP<br />D:\HR_DIR\HR_HR_02.DMP<br />Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:06:56<br />------------------------------------------------------------------------------------------<br />The two dumpfiles has been created with above export data pump command. I have deleted the HR tables, and now will import data from both dumpfiles with a single parameter, check below.<br /><br />H:\>impdp <a href="mailto:hr/hr@rock">hr/hr@rock</a> directory=hrdir parallel=2 dumpfile=hr_hr_%U.dmp logfile=hr1_hr2_IMPORT.log<br /><br />Import: Release 10.2.0.1.0 - Production on Wednesday, 03 March, 2010 12:19:12<br />Copyright (c) 2003, 2005, Oracle. All rights reserved.<br />Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br /><br /><br />With the Partitioning, OLAP and Data Mining options<br />Master table "HR"."SYS_IMPORT_FULL_01" successfully loaded/unloaded<br />Starting "HR"."SYS_IMPORT_FULL_01": <a href="mailto:hr/********@rock">hr/********@rock</a> directory=hrdir parallel=2 dumpfile=hr_hr_%U.dmp logfile=hr1_hr2_IMPORT.log<br />Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA<br />Processing object type SCHEMA_EXPORT/TABLE/TABLE<br />Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA<br />. . imported "HR"."FUND_NAV_EMAIL" 228.4 KB 7875 rows<br />. . imported "HR"."TEST_HWM" 81.27 KB 2676 rows<br />. . imported "HR"."A" 5.710 KB 10 rows<br />. . imported "HR"."AB" 4.929 KB 1 rows<br />. . imported "HR"."B" 5.695 KB 10 rows<br />. . imported "HR"."COUNTRIES" 6.093 KB 25 rows<br />. . imported "HR"."DEPARTMENTS" 6.640 KB 27 rows<br />. . imported "HR"."EMPLOYEES" 15.78 KB 107 rows<br />. . imported "HR"."EMPLOYEES_TEST" 15.71 KB 106 rows<br />. . imported "HR"."JOBS" 6.617 KB 19 rows<br />. . imported "HR"."JOB_HISTORY" 6.593 KB 10 rows<br />. . imported "HR"."LOCATIONS" 7.718 KB 23 rows<br />. . imported "HR"."REGIONS" 5.296 KB 4 rows<br />. . imported "HR"."TEST2" 4.937 KB 4 rows<br />. . imported "HR"."TEST3" 4.914 KB 1 rows<br />. . imported "HR"."TEST" 0 KB 0 rows<br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX<br />Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT<br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS<br />Processing object type SCHEMA_EXPORT/TABLE/COMMENT<br />Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE<br />ORA-31684: Object type PROCEDURE:"HR"."ADD_JOB_HISTORY" already exists<br />ORA-31684: Object type PROCEDURE:"HR"."SECURE_DML" already exists<br />Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE<br />Processing object type SCHEMA_EXPORT/VIEW/VIEW<br />ORA-31684: Object type VIEW:"HR"."EMP_DETAILS_VIEW" already exists<br />Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT<br />Processing object type SCHEMA_EXPORT/TABLE/TRIGGER<br />ORA-39082: Object type TRIGGER:"HR"."TRG_FUND_NAV_EMAIL_HISTORY" created with compilation warnings<br />ORA-39082: Object type TRIGGER:"HR"."TRG_FUND_NAV_EMAIL_HISTORY" created with compilation warnings<br />Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS<br />Job "HR"."SYS_IMPORT_FULL_01" completed with 5 error(s) at 12:23:08<br />H:\><br />-------------------------------------------------------------------------<br /><span style="color:#3366ff;"><strong>Without parallel clause, all data has been imported from both dumpfiles.</strong></span><br />-------------------------------------------------------------------------<br />H:\>impdp <a href="mailto:hr/hr@rock">hr/hr@rock</a> directory=hrdir dumpfile=hr_hr_%U.dmp logfile=hr1_hr2_IMPORT_2.log<br />Import: Release 10.2.0.1.0 - Production on Wednesday, 03 March, 2010 15:27:05<br />Copyright (c) 2003, 2005, Oracle. All rights reserved.<br />Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br />With the Partitioning, OLAP and Data Mining options<br />Master table "HR"."SYS_IMPORT_FULL_01" successfully loaded/unloaded<br />Starting "HR"."SYS_IMPORT_FULL_01": <a href="mailto:hr/********@rock">hr/********@rock</a> directory=hrdir dumpfile=hr_hr_%U.dmp logfile=hr1_hr2_IMPORT_2.log<br />Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA<br />Processing object type SCHEMA_EXPORT/TABLE/TABLE<br />Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA<br />. . imported "HR"."FUND_NAV_EMAIL" 228.4 KB 7875 rows<br />. . imported "HR"."TEST_HWM" 81.27 KB 2676 rows<br />. . imported "HR"."A" 5.710 KB 10 rows<br />. . imported "HR"."AB" 4.929 KB 1 rows<br />. . imported "HR"."B" 5.695 KB 10 rows<br />. . imported "HR"."COUNTRIES" 6.093 KB 25 rows<br />. . imported "HR"."DEPARTMENTS" 6.640 KB 27 rows<br />. . imported "HR"."EMPLOYEES" 15.78 KB 107 rows<br />. . imported "HR"."EMPLOYEES_TEST" 15.71 KB 106 rows<br />. . imported "HR"."JOBS" 6.617 KB 19 rows<br />. . imported "HR"."JOB_HISTORY" 6.593 KB 10 rows<br />. . imported "HR"."LOCATIONS" 7.718 KB 23 rows<br />. . imported "HR"."REGIONS" 5.296 KB 4 rows<br />. . imported "HR"."TEST2" 4.937 KB 4 rows<br />. . imported "HR"."TEST3" 4.914 KB 1 rows<br />. . imported "HR"."TEST" 0 KB 0 rows<br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX<br />Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT<br />Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS<br />Processing object type SCHEMA_EXPORT/TABLE/COMMENT<br />Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE<br />ORA-31684: Object type PROCEDURE:"HR"."ADD_JOB_HISTORY" already exists<br />ORA-31684: Object type PROCEDURE:"HR"."SECURE_DML" already exists<br />Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE<br />Processing object type SCHEMA_EXPORT/VIEW/VIEWORA-31684: Object type VIEW:"HR"."EMP_DETAILS_VIEW" already exists<br />Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT<br />Processing object type SCHEMA_EXPORT/TABLE/TRIGGER<br />ORA-39082: Object type TRIGGER:"HR"."TRG_FUND_NAV_EMAIL_HISTORY" created with compilation warnings<br />ORA-39082: Object type TRIGGER:"HR"."TRG_FUND_NAV_EMAIL_HISTORY" created with compilation warnings<br />Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS<br />Job "HR"."SYS_IMPORT_FULL_01" completed with 5 error(s) at 15:27:22<br />----------------------------------------------------------------------------------------------Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-321924169677461072010-02-23T21:25:00.000-08:002010-02-23T22:09:54.164-08:00audit_trail = 'xml,extened' + DB user audit all by access error..We have enabled auditing for SYS user by<br />1- audit_file_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN\ICPORA\ADUMP<br />2- audit_sys_operations = TRUE<br />3- audit_trail = XML, EXTENDED<br /><br />The sys user was being audited properly, later we wanted to audit ERP (db users). so we set auditing for erp_live user:<br /><br />1-AUDIT ALL BY erp_live BY ACCESS;<br />2-AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY erp_live BY ACCESS;<br /><br />after that we faced below issues<br />-The export of ERP_LIVE schema aborts, and ERP users application hangs and users complain that their sessions are automatically logging off. When I disabled auditing for ERP users, everything works fine.<br />later we found that there is bug in oracle 10g.2 with parameter 'xml, extended' and audit db user with by access.<br />To resolve the problem I disabled auditing for DB users and export and ERP application works fine, check my post at oracle forums.<br /><br /><a href="http://forums.oracle.com/forums/thread.jspa?messageID=4094724&#4094724">http://forums.oracle.com/forums/thread.jspa?messageID=4094724&#4094724</a><br /><br />Now our requirement is audit database users first and SYS user later.<br />In my next post I will write all the steps to audit db users.Rakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0tag:blogger.com,1999:blog-5103795619781655202.post-7324406947037218682009-11-06T03:21:00.000-08:002009-11-10T23:19:31.433-08:00crontab - scheduling a shell script (for oracle export)Cron is a time-based job scheduler in Unix-like computer operating systems. 'cron' is short for Chronograph. Cron enables users to schedule jobs (commands or <a title="Shell script" href="http://en.wikipedia.org/wiki/Shell_script">shell scripts</a>) to run automatically at a certain time or date.<br /><br />> connected with oracle user.<br />[oracle<a href="mailto:oracle@oraclelinux">@oraclelinux</a> bin]$ pwd<br />/bin<br /><br />crontab -e - opens the user's crontab file for viewing/editing<br /><br />crontab -l - simply lists the crontab file's contents for the user. Think of it as a "cat" function for the crontab.<br /><br />-------------------------------<br />[oracle<a href="mailto:oracle@oraclelinux">@oraclelinux</a> bin]$ crontab -e<br /><br />SHELL=/bin/bash<br />PATH=/sbin:/bin:/usr/sbin:/usr/bin<br />MAILTO=oracle<br />HOME=/<br />*/5 * * * * sh /home/oracle/rakesh.sh<br /><br />-----------------------------------------<br />The script will execute every five minute.<br /><br /><a href="http://en.wikipedia.org/wiki/Cron">http://en.wikipedia.org/wiki/Cron</a><br /><a href="http://www.crontabrocks.org/">http://www.crontabrocks.org/</a><br /><br />--------------------------------------------------<br />rakesh.sh shell script :<br />--------------------------------------------------<br />#!bin/bash<br />#PATH=$PATH:$HOME/bin;export PATH<br />unset USERNAME<br />#DISPLAY=10.142.200.141:0.0; export DISPLAY<br />#Oracle Settings<br />TMP=/tmp; export TMP<br />TMPDIR=$TMP; export TMPDIR<br /><br />ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1; export ORACLE_HOME<br />ORACLE_SID=jsildb; export ORACLE_SID<br />ORACLE_HOME_LISTENER=LISTENER; export ORACLE_HOME_LISTENER<br />ORATAB=/etc/oratab; export ORATAB<br />#ORACLE_TERM=xterm; export ORACLE_TERM<br />export PATH=/u01/app/oracle/product/10.2.0/db_1/bin:$PATH<br />export PATH=/usr/sbin/:$PATH<br />LD_LIBRARY_PATH=$ORACLE_HOME/lib:lib:usr/lib; export LD_LIBRARY_PATH<br />CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH<br />#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL<br />export DATE=$(date +"%m_%d_%y_%H:%M:%S_%p")<br /><br />exp <a href="mailto:rakesh/rakesh@jsildb">rakesh/rakesh@jsildb</a> file=/home/oracle/erp_backups/rakesh_$DATE.dmp log=/home/oracle/erp_backups/rakesh_$DATE.log statistics=noneRakesh Kumar Sonihttp://www.blogger.com/profile/09941861995685929269noreply@blogger.com0