{"id":2992,"date":"2022-02-24T13:11:34","date_gmt":"2022-02-24T12:11:34","guid":{"rendered":"http:\/\/roglacup.com\/klaus62\/?p=2992"},"modified":"2022-05-03T05:01:05","modified_gmt":"2022-05-03T04:01:05","slug":"19c","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2022\/02\/24\/19c\/","title":{"rendered":"19c &#038;"},"content":{"rendered":"\n<p><strong>Splo\u0161en link:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/index.html\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/index.html<\/a><\/p>\n\n\n\n<p><strong>Primeri shem:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/comsc\/introduction-to-sample-schemas.html#GUID-844E92D8-A4C8-4522-8AF5-761D4BE99200\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/comsc\/introduction-to-sample-schemas.html#GUID-844E92D8-A4C8-4522-8AF5-761D4BE99200<\/a><\/p>\n\n\n\n<p>20 tips to bring more value into your Oracle Forms solutions &#8230;<\/p>\n\n\n\n<p><a href=\"https:\/\/www.doag.org\/formes\/pubfiles\/11860663\/2019-dev-frank_hoffmann-20_tipps_to_bring_more_value_into_your_oracle_forms_solutions-praesentation.pdf\">https:\/\/www.doag.org\/formes\/pubfiles\/11860663\/2019-dev-frank_hoffmann-20_tipps_to_bring_more_value_into_your_oracle_forms_solutions-praesentation.pdf<\/a><\/p>\n\n\n\n<p><strong>Forms 12 install<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/csenthilmurugan.files.wordpress.com\/2015\/12\/oracle_forms_12c_installation_for_windows.pdf\">https:\/\/csenthilmurugan.files.wordpress.com\/2015\/12\/oracle_forms_12c_installation_for_windows.pdf<\/a><\/p>\n\n\n\n<p><strong>Hasan blog<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/hasanjawaid.blogspot.com\/p\/installing-oracle-12c-weblogic.html\">https:\/\/hasanjawaid.blogspot.com\/p\/installing-oracle-12c-weblogic.html<\/a><\/p>\n\n\n\n<p>Ka<strong>j je ADR ?<\/strong> <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The ADR Directory<\/h3>\n\n\n\n<p>Much of what was stored in the admin directory in Oracle 10g and earlier has now been moved to the Automatic Diagnostic Repository,or ADR directory, in Oracle 11g.&nbsp; The ADR directory is created in $ORACLE_BASE\/diagand contains a subdirectory for each different Oracle installation type on the system and may also contain some empty directories for products which are not installed.&nbsp; Within the database, the ADR location is defined by the diagnostic_dest initialization parameter, and the background_dump_dest, user_dump_dest and similar parameters have been deprecated.<\/p>\n\n\n\n<p>The structure of ADR allows for the storage of items like listener logs and diagnostic files to be stored in a format which is not specific to a particular instance or even Oracle home on the system.&nbsp; Similarly, other aspects of Oracle like ASM have specific log locations within the ADR.<\/p>\n\n\n\n<p>Diagnostic files for a specific database on the system are stored within the ADR under $ORACLE_BASE\/diag\/database_name\/instance_name.&nbsp; In non-RAC implementations, the database and instance names are typically the same, but this format affords the flexibility needed in a RAC environment where the instance name varies from the database name.<\/p>\n\n\n\n<p>In 11g, two versions of the alert log are maintained in the ADR directory.&nbsp; One, an XML file named log.xml, can be found in the ADR directory for that instance under the alert subdirectory.&nbsp; An XML reader or web browser should allow viewing the XML version of the log.&nbsp; Another text-only version of the alert log named with the traditional alert_ORACLE_SID.log is kept in the trace subdirectory and can be viewed with a standard text editor.<\/p>\n\n\n\n<p><strong>Managing the ADR<\/strong><\/p>\n\n\n\n<p>Along with the new ADR structure, Oracle has introduced a tool called adrci&nbsp;to manage the ADR.&nbsp; Through adrci, the amount of time can be set to retain certain information and purge information older than this time.<\/p>\n\n\n\n<p>The adrci command is found in the $ORACLE_HOME\/bin directory, so if oraenv has been run, it will be part of the path.&nbsp; Once launched, issue the show homes command to show ADR repositories which can be managed, then use the set homepath command to select one.<\/p>\n\n\n\n<p>$ adrci<\/p>\n\n\n\n<p>ADR base = &#8220;\/u01\/app\/oracle&#8221;<\/p>\n\n\n\n<p>adrci&gt; show homes<\/p>\n\n\n\n<p>ADR Homes:<br>diag\/rdbms\/test\/TEST<\/p>\n\n\n\n<p>adrci&gt; set homepath diag\/rdbms\/test\/TEST<\/p>\n\n\n\n<p>With the homepath set, examine the retention period with the show control option.&nbsp; The retention period is indicated by the shortp_policy and longp_policy values and in 11g, is set in hours.<\/p>\n\n\n\n<p>adrci&gt; show control<\/p>\n\n\n\n<p>ADR Home = \/u01\/app\/oracle\/diag\/rdbms\/test\/TEST:<br>****************************************************************<br>ADRID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHORTP_POLICY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LONGP_POLICY<br>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;-<br>4124447422&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 720&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8760&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>1 rows fetched<\/p>\n\n\n\n<p>The output may wrap over several lines, but it is the second and third values that should be of interest.&nbsp; These values for shortp_policy and longp_policy are set in hours.&nbsp; Certain information like incidents and problems are retained based on the longp_policy while other information like dump files, which can be significantly larger, are deleted based on the shortp_policy.<\/p>\n\n\n\n<p>The retention periods for these policies can be set using the set control command.&nbsp; To apply the current retention policy to remove diagnostic information which is older than the policy, run the purge command.<\/p>\n\n\n\n<p>adrci&gt; set control (shortp_policy = 128)<br>adrci&gt; set control (longp_policy = 720)<br>adrci&gt; show control<\/p>\n\n\n\n<p>ADR Home = \/u01\/app\/oracle\/diag\/rdbms\/test\/TEST:<br>***************************************************************<br>ADRID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SHORTP_POLICY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LONGP_POLICY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br>4124447422&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 128&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 720<br><br>adrci&gt; purge<\/p>\n\n\n\n<p>Posted from: <a href=\"http:\/\/www.dba-oracle.com\/t_linux_oracle_adr_directory.htm\">http:\/\/www.dba-oracle.com\/t_linux_oracle_adr_directory.htm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Splo\u0161en link: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/index.html Primeri shem: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/comsc\/introduction-to-sample-schemas.html#GUID-844E92D8-A4C8-4522-8AF5-761D4BE99200 20 tips to bring more value into your Oracle Forms solutions &#8230; https:\/\/www.doag.org\/formes\/pubfiles\/11860663\/2019-dev-frank_hoffmann-20_tipps_to_bring_more_value_into_your_oracle_forms_solutions-praesentation.pdf Forms 12 install https:\/\/csenthilmurugan.files.wordpress.com\/2015\/12\/oracle_forms_12c_installation_for_windows.pdf Hasan blog https:\/\/hasanjawaid.blogspot.com\/p\/installing-oracle-12c-weblogic.html Kaj je ADR ? The ADR Directory Much of what was stored in the admin directory in Oracle 10g and earlier has now been moved to the Automatic Diagnostic&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2022\/02\/24\/19c\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">19c &#038;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[384,35],"tags":[],"class_list":["post-2992","post","type-post","status-publish","format-standard","hentry","category-computer-science","category-oracle"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/2992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=2992"}],"version-history":[{"count":5,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/2992\/revisions"}],"predecessor-version":[{"id":3087,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/2992\/revisions\/3087"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=2992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=2992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=2992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}