tag:blogger.com,1999:blog-153588292024-03-21T21:24:43.264-07:00Technical Reference NotesUnknownnoreply@blogger.comBlogger9125tag:blogger.com,1999:blog-15358829.post-54393327551377200432013-07-11T12:45:00.001-07:002013-07-11T12:45:05.211-07:00Active Data Guard - 12c (enhanced features)<span style="font-size: medium;"><span style="font-family: Georgia, "Times New Roman", serif;">Active Data Guard - 12c (enhanced features)</span><br /></span><span style="font-size: small;"><span style="font-family: Georgia, "Times New Roman", serif; font-size: small;">Active Data Guard is an Oracle Database Enterprise Edition option. It includes all of the Data Guard functionality described to this point, as well as the following capabilities: </span></span><span style="font-size: small;"><span style="font-family: Georgia, "Times New Roman", serif;">Real-Time Query – Performance and ROI </span></span><br />
<span style="font-size: small;"><span style="font-size: small;"><span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Automatic Block Repair – High Availability </span><br />
<span style="font-size: small;"><span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Far Sync - Zero Data Loss Protection at any Distance: <span style="font-size: small;">Active Data Guard Far Sync, a new capability for Oracle Database 12, eliminates compromise by extending zero data loss protection to any standby database located at any distance from a primary database, and doing so at minimal expense and without additional complexity. </span></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><span style="font-size: small;"></span></span><span style="font-size: small;"><span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Database Rolling Upgrades using Active Data Guard: <span style="font-size: small;">Database Rolling Upgrades using Active Data Guard, a new capability for Oracle Database 12, addresses concerns for complexity by replacing forty-plus manual steps required to perform a transient logical rolling upgrade with three PL/SQL packages that automate much of the process. </span></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><span style="font-size: small;"></span></span><br />
<span style="font-size: small;"><span style="font-family: Georgia, "Times New Roman", serif;">Application Continuity - <span style="font-size: small;">Application Continuity is a new application-independent capability for Oracle Database 12that recovers incomplete requests from an application perspective and masks many system, communication, and hardware failures, and storage outages from the end-user. It also ensures that end-user transactions are executed no more than once. </span></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><span style="font-size: small;"> </span></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><span style="font-size: small;"></span></span><span style="font-size: small;"><span style="font-family: Georgia, "Times New Roman", serif;">Global Data Services - <span style="font-size: small;">Oracle Global Data Services (GDS) is a new capability for Oracle Database 12that extends familiar RAC-style connect-time and run-time load balancing, service failover and workload management capabilities to a collection of replicated databases, be it within a single datacenter or across multiple datacenters. </span></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><span style="font-size: small;"></span></span></span></span></span></span></span></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-10778476365961240562013-06-20T09:43:00.000-07:002013-06-20T09:46:17.958-07:00BI Apps with DI products (ODI & GG)<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;">ODI</span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;">Oracle BI Applications leverages the advantages of </span><b style="font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;">Oracle Data Integrator Enterprise Edition (ODI)</b></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 10pt; line-height: 14px;">ODI helps to integrate</span><b style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;"></span></b><span style="font-family: Arial, Verdana, sans-serif; font-size: 10pt; line-height: 14px;"> data end-to-end across the full BI Applications architecture, supporting capabilities such as data-lineage which helps business users identify report-to-source capabilities. And while Oracle has re-architectured the solution to use ODI, major concepts still remain the same. For example, mappings and the data warehouse still supports multiple sources, full and incremental loads, slowly changing dimensions, and can be customized.</span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 10pt; line-height: 14px;"><br /></span>
<span style="font-family: Arial, Verdana, sans-serif; font-size: 10pt; line-height: 14px;">GG</span></span><br />
<span style="background-color: white; font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;">Customers can choose the option to replicate their data in real-time using Oracle GoldenGate.</span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;"><br /></span>
<span style="font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;">There are five key elements that differentiate Oracle Data Integration from other data integration offerings and make it the logical strategic choice as the foundation for Oracle BI Applications:</span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;">1. </span><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">Completeness: Real-time, Bulk data movement, transformation, DQ, data federation</span></span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 10pt; line-height: 14px;">2. </span><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">Best in class performance, availability, and reliability. - EL-T architecture</span></span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">3. </span></span><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">Fast time to value - Declarative Design</span></span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">4. </span></span><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">Open and standards-based</span></span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">5. </span></span><span style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px;"><span style="font-size: 10pt; line-height: 14px;">Low total cost of ownership, no </span></span><span style="font-family: Arial, Verdana, sans-serif; font-size: x-small;"><span style="line-height: 14px;">midtier apps server, can scale with DW</span></span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: x-small;"><span style="line-height: 14px;"><br /></span></span>
<span style="font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;">Oracle BI Applications are optimized to work especially with two Oracle Engineered Systems. Exalytics and the Exadata Database Machine. Especially for Exadata, where there’s an even greater advantage for using Oracle Data Integration products with Oracle BI Applications.</span></span><br />
<span style="background-color: white;"><span style="font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;"><br /></span>
</span><br />
<div class="MsoListParagraph" style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 10px; margin-left: 0.25in; margin-top: 10px;">
<span style="background-color: white;"><b><span style="font-family: Arial, sans-serif; font-size: 10pt;">New</span></b><span style="color: windowtext; font-family: Arial, sans-serif; font-size: 10pt;"> <b>Oracle Data Integration: </b>BI Apps are completely re-architected to leverage Oracle Data Integrator and Oracle GoldenGate. </span><span style="font-family: Arial, sans-serif; font-size: 10pt;"></span></span></div>
<div class="MsoListParagraph" style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 10px; margin-left: 0.5in; margin-top: 10px; text-indent: -0.25in;">
<span style="background-color: white;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><span style="font-family: Arial, sans-serif; font-size: 10pt;">BI Applications is now available with next-generation Data Integration. Oracle Data Integrator (ODI) delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs—even across heterogeneous systems, and improves productivity.</span></span></div>
<div class="MsoListParagraph" style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 10px; margin-left: 0.5in; margin-top: 10px; text-indent: -0.25in;">
<span style="background-color: white;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><span style="font-family: Arial, sans-serif; font-size: 10pt;">Functional Setup Manager provides a Web based Administrative User Interface to track and manage implementation projects and their required functional setup steps</span></span></div>
<div class="MsoListParagraph" style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 10px; margin-left: 0.5in; margin-top: 10px; text-indent: -0.25in;">
<span style="background-color: white;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><span style="font-family: Arial, sans-serif; font-size: 10pt;">Configuration Manager provides a centralized Web based administrative user interface to simplify the setup and maintenance of Oracle Business Intelligence Applications.</span></span></div>
<div class="MsoListParagraph" style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 10px; margin-left: 0.5in; margin-top: 10px; text-indent: -0.25in;">
<span style="background-color: white;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><span style="font-family: Arial, sans-serif; font-size: 10pt;">A new optional pre-packaged solution, that leverages GoldenGate, eliminates the need for an ETL batch window and minimizes the impact on OLTP systems, while providing near real-time reporting and enabling more reliable change data capture and delete support.</span><span style="color: windowtext; font-family: Arial, sans-serif; font-size: 10pt;"></span><span style="font-family: Arial, sans-serif; font-size: 10pt;"></span></span></div>
<div class="MsoListParagraph" style="font-family: Arial, Verdana, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 10px; margin-left: 0.5in; margin-top: 10px; text-indent: -0.25in;">
<span style="background-color: white;"><span style="font-family: Symbol; font-size: 10pt;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><span style="color: windowtext; font-family: Arial, sans-serif; font-size: 10pt;">Customers may continue alternatively to use Oracle BI Apps 7.9.6.x and Informatica ETL.</span></span></div>
<br />
<b style="background-color: white; color: #555555; font-family: Arial, Verdana, sans-serif; font-size: 13px; line-height: 14px;"><br /></b>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-20281776516478340292013-05-28T07:57:00.004-07:002013-05-28T08:09:31.600-07:00Check which tables have supplemental log groups<br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<b><span style="font-size: 11pt;"><span style="font-family: Georgia, "Times New Roman", serif;"><span style="color: #444444;"><u>Tables that have supplemental logs:<o:p></o:p></u></span></span></span></b></div>
<span style="font-size: 11pt;"><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;"></span></span></span><br />
<span style="font-size: 11pt;"><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">SELECT <o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;"> OWNER,<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;"> LOG_GROUP_NAME, <o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;"> TABLE_NAME, <o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;"> DECODE(ALWAYS,<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;">
'ALWAYS', 'Unconditional',<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;">
'CONDITIONAL', 'Conditional') ALWAYS,<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;"> LOG_GROUP_TYPE<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;"> FROM DBA_LOG_GROUPS;<o:p></o:p></span></span></span><br />
<span style="color: #444444;"></span><br />
<span style="color: #444444;"></span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="font-size: 11pt;"><span style="font-family: Georgia, "Times New Roman", serif;"><span style="color: #444444;">OR tables by schema, that do not have supplemental log groups:<o:p></o:p></span></span></span></div>
<span style="color: #444444; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: #444444; font-family: Georgia, "Times New Roman", serif;"></span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<b><span style="color: #444444; font-family: Georgia, "Times New Roman", serif; font-size: 11pt;"> <u>Tables by schema that do not have supplemental log groups:</u></span></b></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<b><span style="font-family: "Calibri","sans-serif"; font-size: 11pt;"><o:p></o:p></span></b><span style="color: #444444;"> </span></div>
<span style="font-size: 11pt;"><span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">select owner, table_name from dba_tables<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;">where owner = 'SCHEMA_NAME' and table_name not in<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;">(SELECT <o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;"> TABLE_NAME FROM DBA_LOG_GROUPS)<o:p></o:p></span></span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: #444444;">
<span style="font-size: 11pt;">order by table_name;<o:p></o:p></span></span></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-4555132091142792412013-04-11T08:38:00.001-07:002013-04-11T08:38:54.617-07:00Scripts that are run at Linux Startup and Shell login<span style="font-family: Georgia, "Times New Roman", serif;">FOR LINUX:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Sometimes when you go into a shell, there are certain env variables that may be already set. Or you may want to run something at boot or when you login to a new shell.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">There are several places to put those commands:</span><br />
<span style="font-family: Georgia;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><u>At bootup:</u></span><br />
<span style="font-family: "Courier New", Courier, monospace;">/etc/rc.d/rc.local</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/etc/rc.d/init.d/<username> - this file is execute for the user</username></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><u>At login</u> (in this order) - these are in the $HOME dir of the user:</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/home/oracle/.bashrc</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/home/oracle/.bash_profile</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/home/oracle/.bach_login</span><br />
<span style="font-family: "Courier New", Courier, monospace;">(also check if these files call another file, like /etc/bashrc or /etc/profile)</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-2314880983474526242013-04-10T15:16:00.005-07:002013-04-10T15:20:04.451-07:00DBMS_REDEFINITION & GG<span style="font-family: Georgia, "Times New Roman", serif;">There is some confusion if dbms_redefinition can be used on a database where GoldenGate is configured.</span><br />
<span style="font-family: Georgia;"></span><br />
<span style="font-family: Georgia;">First, let's see what online Table Redefinition can be used for:</span><span style="font-family: Georgia;"></span><br />
<span style="font-family: Georgia;"></span><br />
<span style="font-family: Georgia;"></span><br />
<span style="font-family: Georgia;"><ul class="bb-list" style="list-style-type: circle;">
<li>Add, remove, or rename columns from a table</li>
<li>Converting a non-partitioned table to a partitioned table and vice versa</li>
<li>Switching a heap table to an index organized and vice versa</li>
<li>Modifying storage parameters</li>
<li>Adding or removing parallel support</li>
<li>Reorganize (defragmenting) a table</li>
<li>Transform data in a table</li>
</ul>
Let's use these example tables:<br />
Move EMP table to EMP_PARTITIONED_TEMP table<br />
<br />
<u>Here are the very high-level steps of online redefinition:</u><br />
1) Create an interim table: CTAS EMP as EMP_PARTITIONED_TEMP (partitioned)<br />
<br />
<span style="color: red;">If GG DDL replication is enabled, then the interim table will also get replicated and created in the target.</span><br />
<br />
2) Start redefinition - During this phase Oracle will copy (and partition) the data from the EMP to the EMP_PARTITIONED_TEMP. Oracle will also create a materialized view (snapshot) log on the table to track DML changes<br />
<br />
<span style="color: red;">At this point EMP's ObjID is 101 & EMP_PARTITIONED_TEMP's ObjID is 201</span><br />
<span style="color: red;">GG does not replicate any DDL executed by the dbms_redefinition pkg - so there is no mv snapshot taken on the target</span><br />
<span style="color: red;">The DML for both tables is replicated to the target (but this will be useless at the end)</span><br />
<br />
3) Finish redefinition - During this step Oracle will lock both tables in exclusive mode, swap the names of the two tables in the data dictionary, and enable all foreign key constraints<br />
<br />
<span style="color: red;">In this step, Oracle swaps the ObjIDs of the 2 tables, so EMP becomes 201, and EMP_PARTITIONED_TEMP becomes 101.</span><br />
<span style="color: red;">GG does not replicate any DDL executed by the dbms_redefinition pkg - so the swap of the ObjIDs is not replicated to the target</span><br />
<br />
4) Remember to drop the original table afterwards. One can also consider renaming the constraints back to their original names (e.g.: alter table EMP rename constraint SYS_C001806 to emp_fk).<br />
<br /></span><span style="color: red; font-family: Georgia, "Times New Roman", serif;">When the interim table is dropped, the 'drop table' is replicated to the target. But since the ObjIDs were not replicated to the target, the interim table is dropped. There was no affect of the redefinition on the target</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-73144697119069197262013-04-10T09:13:00.004-07:002013-04-10T12:20:47.457-07:00Shared Folders on VBox<div style="clear: both; text-align: left;">
<span style="font-family: Georgia, "Times New Roman", serif;">To share a folder between the host and the guest in VBox...</span></div>
<div style="clear: both; text-align: left;">
<span style="font-family: Georgia, "Times New Roman", serif;"> </span></div>
<div style="clear: both; text-align: left;">
<span style="font-family: Georgia, "Times New Roman", serif;">1. Go to Settings/Devices > Shared Folders > Add a new Machine Folder</span><br />
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUjPH-7FNbAjj7Hs5K-qg3rdu8Qg6wuflmn9EFIBV0Ngs_PshYbMy5tVrlDEi2XFjWlTevtuc71lyPKtvfMLAwBkqln5uwwChiR4ihIsVq_XEaU8y5uM5m8kfH6xB2AL5p6tzckw/s1600/1.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUjPH-7FNbAjj7Hs5K-qg3rdu8Qg6wuflmn9EFIBV0Ngs_PshYbMy5tVrlDEi2XFjWlTevtuc71lyPKtvfMLAwBkqln5uwwChiR4ihIsVq_XEaU8y5uM5m8kfH6xB2AL5p6tzckw/s1600/1.PNG" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Georgia, "Times New Roman", serif;">(Recommended) If you would like to auto-mount this shared folder, click on Auto-mount and Make Permanent</span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicmn7lVQ7bIMJNnZKld2KgA_AjjUNldEqzy5iM1C4I79PCvRN_e1_8m2XKaQsiJ6HcQVVtoF-3Vq9OydhOb2uQKLGKVJZEbHxNMf0XLZ8Ejc9dMR6Kpcvixzc65WZC4t6M2BcTtg/s1600/2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicmn7lVQ7bIMJNnZKld2KgA_AjjUNldEqzy5iM1C4I79PCvRN_e1_8m2XKaQsiJ6HcQVVtoF-3Vq9OydhOb2uQKLGKVJZEbHxNMf0XLZ8Ejc9dMR6Kpcvixzc65WZC4t6M2BcTtg/s1600/2.PNG" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div style="text-align: left;">
<span style="font-family: Georgia, "Times New Roman", serif;">2. At this point restart the VM for the shared folder to get auto-mounted:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[oracle@localhost ~]$ df -k<br />Filesystem 1K-blocks Used Available Use% Mounted on<br />/dev/hda1 10504124 2387488 7574444 24% /<br />/dev/hdb1 12184796 7522868 4032988 66% /home<br />tmpfs 1815936 290720 1525216 17% /dev/shm<br />/dev/mapper/vg00-apps--fs<br /> 9805144 153084 9153988 2% /u01<br /><span style="color: yellow;">Shared_VM_ODI12c 224776188 147399704 77376484 66% /media/sf_Shared_VM_ODI12c</span></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">3. On the Guest, login as root, and add 'oracle' user to the vboxsf group so that the user has access to the shared file system:</span><br />
<span style="font-family: Georgia;"></span><br />
<span style="color: yellow; font-family: Georgia;">root# /usr/sbin/usermod -G vboxsf -a oracle</span><br />
<span style="font-family: Georgia;"></span><br />
<span style="font-family: Georgia;">4. Now restart the VM to inherit the vboxsf group privs, and you should be able to cd into the shared folder:</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">[oracle@localhost sf_temp_share]$ id<br />uid=500(oracle) gid=500(oracle) groups=500(oracle),54323(davfs2),<span style="color: yellow;">54324(vboxsf)</span></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, "Times New Roman", serif;"> </span><br />
<span style="color: red; font-family: Georgia;"><em>THERE IS NO NEED TO DO 'mount -t vboxsf shared_folder /shared_folder' -since we auto-mounted the file system.</em></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, "Times New Roman", serif;"> </span></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-53582125560527898082013-04-10T08:26:00.003-07:002013-04-10T22:18:42.312-07:00Flashback & GoldenGate<span style="font-family: Georgia, "Times New Roman", serif;">Goldengate supports the flashback of committed transactions, but does not support flashback at the database or dropped table levels.
</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><strong><u>Supported</u></strong>
</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">flashback table ... to SCN ...
</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">flashback table ... to TIMESTAMP ...
</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">flashback table ... to RESTORE POINT ...
</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">
<strong><u>Not Supported</u></strong> </span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">
flashback table ... to BEFORE DROP ...
</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">flashback DATABASE ... to ...
</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"> </span><br />
<u><span style="font-family: Georgia, "Times New Roman", serif;">Quick test with flashback table:</span></u><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Pre-requisites: set these parameters:</span><br />
<ol>
<li><span style="font-family: Georgia, "Times New Roman", serif;">
db_flashback_retention_target</span></li>
<li><span style="font-family: Georgia, "Times New Roman", serif;">db_recovery_file_dest</span></li>
<li><span style="font-family: Georgia, "Times New Roman", serif;">db_recovery_file_dest_size</span></li>
</ol>
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">sql> grant flashback any table to <gg_user>;</gg_user></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">sql> alter table schema.table enable row movement;</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Use any table to do this test:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">1) Get the current SCN#:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">sql> SELECT current_scn FROM v$database;</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">CURRENT_SCN<br />-----------<br /> 15286586</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">1 row selected.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">2) Make some DML changes to the test table</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">3) sql> SELECT current_scn FROM v$database;</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">CURRENT_SCN<br />-----------<br /> 15286648</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">1 row selected.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">4) Flashback test table to before the latest changes:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">sql> flashback table emp to scn 15286586;</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Flashback complete.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Select from the test table, confirm that the table has been flashed back</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Now check on the target; GG replicated the changes made with the flashback table command - tables should be in sync</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">5) Now flashback again to after the latest changes:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">sql> flashback table emp to scn 15286648;</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Flashback complete.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Source table should be restored to after the changes; and GG should have also replicated the changes.</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-64923999967740601662013-04-10T08:22:00.002-07:002013-04-10T08:54:14.727-07:00Enable Archivelog mode - in Oracle DB<span style="font-family: "Courier New", Courier, monospace;">CONN / AS SYSDBA
ALTER SYSTEM SET log_archive_dest_1='location=d:\oracle\oradata\DB10G\archive\' SCOPE=SPFILE;
</span><br />
<span style="font-family: "Courier New", Courier, monospace;">ALTER SYSTEM SET log_archive_format='ARC%S_%R.%T' SCOPE=SPFILE;</span><br />
<span style="font-family: "Courier New", Courier, monospace;">
SHUTDOWN IMMEDIATE
</span><br />
<span style="font-family: "Courier New", Courier, monospace;">STARTUP MOUNT
</span><br />
<span style="font-family: "Courier New", Courier, monospace;">ALTER DATABASE ARCHIVELOG;
</span><br />
<span style="font-family: "Courier New", Courier, monospace;">ALTER DATABASE OPEN;</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-15358829.post-28049986539308036082013-04-10T07:32:00.002-07:002013-04-10T11:31:20.878-07:00Add a new file system/mount point in linux (in a VBox VM)<span style="font-family: Georgia, "Times New Roman", serif;">This post is about how to add a file system in a linux guest running on VBox (or any Linux host)</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">1. Stop the Guest, and add the hard disk to the VBox image, under Settings > Storage > Controller</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAv3Fp46M3cgKTbppmtcBYwGlrkIh5nYWGD-_NvHKpSRsXVu1LvNCWcefKXYbgvAheplU8mZnWaVqvBC5KGtMr6er9MU3CRJvSEYzTOpZqUewC1c6vLT1zcDZtfViGCJ_02P-fZw/s1600/3.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAv3Fp46M3cgKTbppmtcBYwGlrkIh5nYWGD-_NvHKpSRsXVu1LvNCWcefKXYbgvAheplU8mZnWaVqvBC5KGtMr6er9MU3CRJvSEYzTOpZqUewC1c6vLT1zcDZtfViGCJ_02P-fZw/s1600/3.PNG" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd3OIooDwMRtn8VI9yDmL3HgBnLmLoo3QfVLO3Nr7B-WzVIL0t_sqHw5HUIPFhte835B6X4uHiZzX7p-JuSDkoaWhS9LjavfBCOiInkfyweHiJFTV1cL8kD9aBZgrPlFBXEh4jTg/s1600/4.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgd3OIooDwMRtn8VI9yDmL3HgBnLmLoo3QfVLO3Nr7B-WzVIL0t_sqHw5HUIPFhte835B6X4uHiZzX7p-JuSDkoaWhS9LjavfBCOiInkfyweHiJFTV1cL8kD9aBZgrPlFBXEh4jTg/s1600/4.PNG" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTTmK9S7iO_1O1DKjqggGmcLiq_DowV9iRgH_28Qw0kZDZEGvXlAE-83eklTtsPdgHZVA3AsjB2f3IBgEa3FY38duam8r5L61_8WkoJBMRE0FJD7urzB7_U0QXABAlWQ214XD24g/s1600/5.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTTmK9S7iO_1O1DKjqggGmcLiq_DowV9iRgH_28Qw0kZDZEGvXlAE-83eklTtsPdgHZVA3AsjB2f3IBgEa3FY38duam8r5L61_8WkoJBMRE0FJD7urzB7_U0QXABAlWQ214XD24g/s1600/5.PNG" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHzxR04gROaXvIPYewWKHG-KIn20cTGhHCnXTMK2ZqQCFrSqDdTWlEPGmW3Wz6_b5JOytCBmwqYcfm7IafRQuZ_3hGQj7u3yxmv9eKGY_3_zv4C6Tut5PhLblYVSGPDsN6hLz-Uw/s1600/6.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHzxR04gROaXvIPYewWKHG-KIn20cTGhHCnXTMK2ZqQCFrSqDdTWlEPGmW3Wz6_b5JOytCBmwqYcfm7IafRQuZ_3hGQj7u3yxmv9eKGY_3_zv4C6Tut5PhLblYVSGPDsN6hLz-Uw/s1600/6.PNG" /></a></div>
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">2. Then start the VM, login as root and confirm that the device is listed under fdisk -l</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# <span style="color: yellow;">fdisk -l</span></span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Disk /dev/hda: 12.8 GB, 12884901888 bytes</span><br />
<span style="font-family: "Courier New", Courier, monospace;">255 heads, 63 sectors/track, 1566 cylinders</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Units = cylinders of 16065 * 512 = 8225280 bytes</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Device Boot Start End Blocks Id System</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/dev/hda1 * 1 1350 10843843+ 83 Linux</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/dev/hda2 1351 1566 1735020 82 Linux swap / Solaris</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Disk /dev/hdb: 12.8 GB, 12884901888 bytes</span><br />
<span style="font-family: "Courier New", Courier, monospace;">255 heads, 63 sectors/track, 1566 cylinders</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Units = cylinders of 16065 * 512 = 8225280 bytes</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Device Boot Start End Blocks Id System</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/dev/hdb1 * 1 1566 12578863+ 83 Linux</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="color: yellow; font-family: "Courier New", Courier, monospace;">Disk /dev/hdd: 10.7 GB, 10737418240 bytes</span><br />
<span style="color: yellow; font-family: "Courier New", Courier, monospace;">16 heads, 63 sectors/track, 20805 cylinders</span><br />
<span style="color: yellow; font-family: "Courier New", Courier, monospace;">Units = cylinders of 1008 * 512 = 516096 bytes</span><br />
<span style="color: yellow; font-family: "Courier New", Courier, monospace;"></span><br />
<span style="color: yellow; font-family: "Courier New", Courier, monospace;">Disk /dev/hdd doesn't contain a valid partition table</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">3. Create the physical volume with pvcreate:</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# <span style="color: yellow;">pvcreate /dev/hdd Physical volume "/dev/hdd"</span> successfully created</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">4. Create a volume group vg00 with vgcreate:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# <span style="color: yellow;">vgcreate vg00 /dev/hdd</span></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Volume group "vg00" successfully created</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">5. Create a logical volume with lvcreate:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# <span style="color: yellow;">lvcreate -L 9.5g -n apps-fs vg00</span></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Logical volume "apps-fs" created</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">6. Now review with pvs, vgs, lvs:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# pvs</span><br />
<span style="font-family: "Courier New", Courier, monospace;">PV VG Fmt Attr PSize PFree </span><br />
<span style="font-family: "Courier New", Courier, monospace;">/dev/hdd vg00 lvm2 a- 10.00G 10.00G</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# vgs</span><br />
<span style="font-family: "Courier New", Courier, monospace;">VG #PV #LV #SN Attr VSize VFree </span><br />
<span style="font-family: "Courier New", Courier, monospace;">vg00 1 0 0 wz--n- 10.00G 10.00G</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# lvs</span><br />
<span style="font-family: "Courier New", Courier, monospace;">LV VG Attr LSize Origin Snap% Move Log Copy% Convert</span><br />
<span style="font-family: "Courier New", Courier, monospace;">apps-fs vg00 -wi-a- 9.50G </span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">7. Now make a file system with mkfs...</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost ~]# <span style="color: yellow;">mkfs.ext3 /dev/vg00/apps-fs</span> </span><br />
<span style="font-family: "Courier New", Courier, monospace;">mke2fs 1.39 (29-May-2006)</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Filesystem label=</span><br />
<span style="font-family: "Courier New", Courier, monospace;">OS type: Linux</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Block size=4096 (log=2)</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Fragment size=4096 (log=2)</span><br />
<span style="font-family: "Courier New", Courier, monospace;">1245184 inodes, 2490368 blocks</span><br />
<span style="font-family: "Courier New", Courier, monospace;">124518 blocks (5.00%) reserved for the super user</span><br />
<span style="font-family: "Courier New", Courier, monospace;">First data block=0</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Maximum filesystem blocks=2550136832</span><br />
<span style="font-family: "Courier New", Courier, monospace;">76 block groups</span><br />
<span style="font-family: "Courier New", Courier, monospace;">32768 blocks per group, 32768 fragments per group</span><br />
<span style="font-family: "Courier New", Courier, monospace;">16384 inodes per group</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Superblock backups stored on blocks: </span><br />
<span style="font-family: "Courier New", Courier, monospace;">32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">Writing inode tables: done </span><br />
<span style="font-family: "Courier New", Courier, monospace;">Creating journal (32768 blocks): done</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Writing superblocks and filesystem accounting information: done</span><br />
<span style="font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">This filesystem will be automatically checked every 25 mounts or</span><br />
<span style="font-family: "Courier New", Courier, monospace;">180 days, whichever comes first. Use tune2fs -c or -i to override.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">8. Then create a directory to attach the file system:</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost /]# <span style="color: yellow;">mkdir -m 755 /u01</span></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost /]# ls -ld /u01</span><br />
<span style="font-family: "Courier New", Courier, monospace;">drwxr-xr-x 2 root root 4096 Apr 10 10:38 /u01</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">9. Now add an entry in /etc/fstab to auto-mount the new file system at reboot:</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost /]# vi /etc/fstab</span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost /]# cat /etc/fstab </span><br />
<span style="font-family: "Courier New", Courier, monospace;">LABEL=/ / ext3 defaults 1 1</span><br />
<span style="font-family: "Courier New", Courier, monospace;">LABEL=/home /home ext3 defaults 1 2</span><br />
<span style="font-family: "Courier New", Courier, monospace;">...</span><br />
<span style="color: yellow; font-family: "Courier New", Courier, monospace;">/dev/vg00/app-fs /u01 ext3 defaults,usrquota 0 2</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="color: red; font-family: Georgia, "Times New Roman", serif;">10. Test to make sure there are no errors in the /etc/fstab file with "mount -a". If there is no output, then there are no errors:</span><br />
<br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost /]# mount -a</span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost /]# </span><br />
<span style="font-family: Courier New;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;">[root@localhost /]# df -h</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Filesystem Size Used Avail Use% Mounted on</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/dev/hda1 11G 2.3G 7.3G 24% /</span><br />
<span style="font-family: "Courier New", Courier, monospace;">/dev/hdb1 12G 7.2G 3.9G 66% /home</span><br />
<span style="font-family: "Courier New", Courier, monospace;">tmpfs 1.8G 284M 1.5G 17% /dev/shm</span><br />
<span style="font-family: "Courier New", Courier, monospace;">Shared_VM_ODI12c 215G 141G 74G 66% /media/sf_Shared_VM_ODI12c</span><br />
<span style="color: yellow; font-family: "Courier New", Courier, monospace;">/dev/mapper/vg00-apps--fs 9.4G 150M 8.8G 2% /u01</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />
<span style="font-family: Georgia, "Times New Roman", serif;"></span><br />Unknownnoreply@blogger.com0