tag:blogger.com,1999:blog-27317947117194723972024-03-08T10:47:40.638+02:00DBA Story<b>SQL> ALTER DATABASE OPEN;</b>Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.comBlogger93125tag:blogger.com,1999:blog-2731794711719472397.post-91247823390901450452016-04-14T11:09:00.001+03:002016-04-14T16:30:25.981+03:00Audit Trail for Custom Table in Oracle Apps - Step By Step<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Hi All ...</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Here the step by step for Audit Trail for Custom Table in Oracle Apps</b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><span style="color: #660000;">1. Register
Custom Schema</span><span style="color: #404040;"> </span></b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="color: #404040;">Navigate to System Administrator Menu/</span><span style="color: #404040;">Security/ORACLE/Register</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-C4pqrDYMuZI/Vw9JTspu-aI/AAAAAAAAa6g/Q0Dk0xJ5x7sReMtjqP_W7jP6ol-HtlEOgCLcB/s1600/cust1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="180" src="https://4.bp.blogspot.com/-C4pqrDYMuZI/Vw9JTspu-aI/AAAAAAAAa6g/Q0Dk0xJ5x7sReMtjqP_W7jP6ol-HtlEOgCLcB/s320/cust1.jpg" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>2. <span style="text-align: center;">Ensure that Audit on the Application is Enabled</span></b></span></div>
<div align="center" class="MsoNormal" style="direction: ltr; text-align: center; unicode-bidi: embed;">
<b><span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></span></b></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="color: #404040;">Navigate
to System Administrator Menu Security/AuditTrail/Install<br />
<br />
The owner of table XX_TABLE is XX_SCHEMA. Hence query on </span><span style="color: #404040;">XX_SCHEMA </span><span style="color: #404040;">to
ensure that Audit is enabled for this Application.<o:p></o:p></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #404040; font-family: "arial" , "helvetica" , sans-serif;"><a href="https://1.bp.blogspot.com/-HtVsRt-CpE0/Vw9KTRWtabI/AAAAAAAAa6s/-g97VMv1EWA93UVjw7jkcqK-tDbcHXQ9gCLcB/s1600/cust2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="46" src="https://1.bp.blogspot.com/-HtVsRt-CpE0/Vw9KTRWtabI/AAAAAAAAa6s/-g97VMv1EWA93UVjw7jkcqK-tDbcHXQ9gCLcB/s320/cust2.jpg" width="320" /></a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #404040; font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>3. Register
table,columns and primary key</b></span></div>
<span style="color: #404040; font-family: arial, helvetica, sans-serif;">Here the procedure to register the custom able,columns and primary key in Oracle Applications. Install the procedure on your DB and run the following:</span><br />
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #404040; font-family: "arial" , "helvetica" , sans-serif;"><b><br /></b></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>begin<o:p></o:p></b></span></div>
<b style="color: #660000; font-family: arial, helvetica, sans-serif;">register_table('XX_TABLE','XX_SCHEMA'); /* (table name, table owner) */</b><br />
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>commit;</b></span></div>
<div class="separator" style="clear: both;">
</div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><span style="color: #660000;">end;</span></b><o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Procedure <span style="color: #660000;">"</span><b><span style="color: #660000;">register_table"</span>:</b></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></b></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>CREATE
OR REPLACE PROCEDURE register_table (<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>table_name
VARCHAR2,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>application_short_name
VARCHAR2<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>)<span dir="RTL" lang="HE"><o:p></o:p></span></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>AS<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>status
VARCHAR2 (10);<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>CURSOR
c_columns ( p_table_name all_tab_columns.table_name%TYPE )<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>IS<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>SELECT
column_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>data_type,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>data_length,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>nullable,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>ROWNUM,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>data_precision,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>data_scale<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>FROM
all_tab_columns<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>WHERE
table_name = p_table_name;<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>CURSOR
c_constraints (p_table_name all_tab_columns.table_name%TYPE,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_application_short_name
all_tab_columns.owner%TYPE )<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>IS<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>SELECT
constraint_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>table_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>status<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>FROM
all_constraints<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>WHERE
table_name = p_table_name AND owner = p_application_short_name AND
constraint_type = 'P';<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>CURSOR
c_constraint_columns (<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_table_name
all_tab_columns.table_name%TYPE,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_application_short_name
all_tab_columns.owner%TYPE<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>)<span dir="RTL" lang="HE"><o:p></o:p></span></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>IS<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>SELECT
acc.constraint_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>acc.column_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>acc.POSITION<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>FROM
all_cons_columns acc, all_constraints ac<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>WHERE
ac.constraint_name = acc.constraint_name<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>AND
ac.table_name = p_table_name<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>AND
ac.constraint_type = 'P'<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>AND
ac.owner = p_application_short_name;<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>BEGIN<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>DBMS_OUTPUT.put_line
('Registering Table '|| table_name ||'in application ' ||
application_short_name);<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>ad_dd.register_table
(p_appl_short_name => application_short_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_tab_name
=> table_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_tab_type
=> 'T'<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>);<span dir="RTL" lang="HE"><o:p></o:p></span></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>FOR
r_columns IN c_columns (table_name)<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>LOOP<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>DBMS_OUTPUT.put_line
('Registering Column '|| r_columns.column_name);<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>ad_dd.register_column
(p_appl_short_name => application_short_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_tab_name
=> table_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_col_name
=> r_columns.column_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_col_seq
=> r_columns.ROWNUM,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_col_type
=> r_columns.data_type,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_col_width
=> r_columns.data_length,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_nullable
=> r_columns.nullable,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_translate
=> 'N',<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_precision
=> r_columns.data_precision,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_scale
=> r_columns.data_scale<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>);<span dir="RTL" lang="HE"><o:p></o:p></span></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>END
LOOP;<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>FOR
r_constraints IN c_constraints (table_name, application_short_name)<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>LOOP<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>DBMS_OUTPUT.put_line
('Creating Primary Key Constraint ' || r_constraints.constraint_name);<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>SELECT
DECODE (r_constraints.status,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>'ENABLED',
'Y',<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>'N'<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>)<span dir="RTL" lang="HE"><o:p></o:p></span></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>INTO
status<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>FROM
DUAL;<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>ad_dd.register_primary_key
(p_appl_short_name => application_short_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_key_name
=> r_constraints.constraint_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_tab_name
=> table_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_description
=> 'Primary Key for Table '|| table_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_key_type
=> 'D',<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_audit_flag
=> 'Y',<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_enabled_flag
=> status<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>);<span dir="RTL" lang="HE"><o:p></o:p></span></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>END
LOOP;<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>FOR
r_constraint_columns IN c_constraint_columns (table_name,
application_short_name)<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>LOOP<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>DBMS_OUTPUT.put_line
( 'Registering Primary Key Column '||<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>r_constraint_columns.column_name||<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>'
for Constraint '||<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>r_constraint_columns.constraint_name);<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>ad_dd.register_primary_key_column
(p_appl_short_name => application_short_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_key_name
=> r_constraint_columns.constraint_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_tab_name
=> table_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_col_name
=> r_constraint_columns.column_name,<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>p_col_sequence
=> r_constraint_columns.POSITION<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>);<span dir="RTL" lang="HE"><o:p></o:p></span></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>END
LOOP;<o:p></o:p></i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><i>END
register_table;</i></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></div>
<span style="color: #404040; font-family: "arial" , "helvetica" , sans-serif;"></span><br />
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #404040; font-family: "arial" , "helvetica" , sans-serif;"><b><br /></b></span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span><br />
<div class="separator" style="clear: both; color: #404040; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">
</span>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><span style="color: #660000;">4. Create Audit Group</span></b></span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">
<div class="separator" style="clear: both; color: #404040; text-align: left;">
Once you table registered,navigate to System
Administrator Menu Security/AuditTrail/Groups </div>
<div class="separator" style="clear: both; color: #404040; text-align: left;">
<br /></div>
Application Name: XX Custom Schema<br />
Audit Group: XX Audit<br />
Group State: Enabled<br />
<br />
Now, add audit tables to this group[you can add as many tables]<br />
User Table Name: XX_TABLE<br />
<div class="separator" style="clear: both; color: #404040; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; color: #404040; text-align: center;">
<a href="https://4.bp.blogspot.com/-yetxdFYlXBM/Vw9MjDRu_eI/AAAAAAAAa64/G14s4hpdc8sjun3qaOOMDQkZo2la621wwCLcB/s1600/cust3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="174" src="https://4.bp.blogspot.com/-yetxdFYlXBM/Vw9MjDRu_eI/AAAAAAAAa64/G14s4hpdc8sjun3qaOOMDQkZo2la621wwCLcB/s320/cust3.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; color: #404040; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<b><span style="color: #660000;">5. <span style="text-align: center;">Run Concurrent program “AuditTrail Update Tables”</span></span></b></div>
<b><span style="color: #404040;"><br />
</span></b><span style="color: #404040;">This process can be run from
System Administrator responsibility. It has no parameter. Running this process
will create the Audit tables and the triggers that manage Audit data.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-mEh5M1i7XGI/Vw9M4vo1VqI/AAAAAAAAa68/VOeZNF9zQLwXf1gBodOPtqUQqFkgiqxuQCLcB/s1600/cust4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="75" src="https://4.bp.blogspot.com/-mEh5M1i7XGI/Vw9M4vo1VqI/AAAAAAAAa68/VOeZNF9zQLwXf1gBodOPtqUQqFkgiqxuQCLcB/s320/cust4.jpg" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>6. Ensure that Audit Tables have been created as expected</b></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">SELECT object_name, object_type</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">FROM all_objects</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">WHERE object_name LIKE 'XX_TABLE_A%'</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">OBJECT_NAME OBJECT_TYPE</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">-------------------------- --------------------------</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_A TABLE</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_A SYNONYM</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AC TRIGGER</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AC1 VIEW</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AD TRIGGER</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_ADP PROCEDURE</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AH TRIGGER</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AI TRIGGER</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AIP PROCEDURE</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AT TRIGGER</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AU TRIGGER</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AUP PROCEDURE</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">XX_TABLE_AV1 VIEW</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Fine, this proves that the concurrent program in Step 5 did its job.</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Optionally, you may run concurrent process “AuditTrail Report for Audit Group Validation” to validate the success of Audit Table/Trigger creation.</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both;">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>7. Add further columns for Audit Trail</b></span></div>
<div class="separator" style="clear: both;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;">By default Oracle will Audit
Trail on all columns that are a part of first available Unique Index on
XX_TABLE.<br />
However further columns can be added to the Audit Trail. Lets say you wish to
Audit Trail on Column Meaning too.<br />
Navigate to System Administrator Menu Security/AuditTrail/Tables</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-7mMso4ZiBbw/Vw9OSUf-nKI/AAAAAAAAa7M/mPPYXB_n0oABVym9_B44_p1AhwSMySbGwCLcB/s1600/cust5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="246" src="https://4.bp.blogspot.com/-7mMso4ZiBbw/Vw9OSUf-nKI/AAAAAAAAa7M/mPPYXB_n0oABVym9_B44_p1AhwSMySbGwCLcB/s320/cust5.jpg" width="320" /></span></a></div>
<div class="separator" style="clear: both;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;">You can
add additional columns to audit trail and re-execute Step 5.<br />
Please note that adding columns for Audit could have been done immediately
after Step 4.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;">You are DONE...</span></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>Usefull notes:</b></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040; font-family: "arial" , "helvetica" , sans-serif;">How To Enable Auditing On A Table (Doc ID 1359749.1)</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
</div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040; font-family: "arial" , "helvetica" , sans-serif;">Unable to Enable Audit Trail for Custom Objects (Doc ID 433527.1)</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="color: #404040;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Good Luck ...</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-4-E-XTOMrA0/Vw9PId25YwI/AAAAAAAAa7Y/1DreZkOUg84nzdRB5BDOUno74R5g4H1wwCLcB/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://1.bp.blogspot.com/-4-E-XTOMrA0/Vw9PId25YwI/AAAAAAAAa7Y/1DreZkOUg84nzdRB5BDOUno74R5g4H1wwCLcB/s1600/my_vote.gif" /></a></div>
<div>
<br />
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<b><span style="color: #404040; font-family: "microsoft sans serif" , "sans-serif";"><o:p></o:p></span></b></div>
</div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com9tag:blogger.com,1999:blog-2731794711719472397.post-56980682758024344632016-01-14T13:57:00.000+02:002016-05-05T10:40:05.197+03:00Configure Shared Appl Top in EBS R12 - Step by Step<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Hi All ...</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Here the step by step of configure <b><span style="color: #660000;">Shared Appl Top</span></b> in EBS R12:</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">1. Run adpreclone procedure in DB and APPL (on Main server):</span><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="MsoListParagraphCxSpFirst" style="margin-left: 1.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: "arial" , "helvetica" , sans-serif;">·<span style="font-stretch: normal;">
</span><!--[endif]--><span dir="LTR"></span><b>On DB Tier:<o:p></o:p></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-stretch: normal;"> </span><span style="font-stretch: normal;"> </span><!--[endif]--><span dir="LTR"></span>cd
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-stretch: normal;"> </span>perl
adpreclone.pl dbTier<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: "arial" , "helvetica" , sans-serif;">·<span style="font-stretch: normal;">
</span><!--[endif]--><span dir="LTR"></span><b>On APPL Tier:<o:p></o:p></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-stretch: normal;"> </span><!--[endif]--><span dir="LTR"></span>cd $INST_TOP/admin/scripts<o:p></o:p></span></div>
<br />
<div class="MsoListParagraphCxSpLast" style="margin-left: 1.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-stretch: normal;"> </span><!--[endif]--><span dir="LTR"></span> perl adpreclone.pl appsTier<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 1.25in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">2. Stop APPL_TIER (<b>on Main server</b>)</span><br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">3. Add the F5 ip hosname.domain hostname to /etc/hosts on all servers.</span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">4. Connect the mount of the application tier to second appl server. </span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">5. Add node (<b>run the commands on second applserver</b> ).</span><br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"> cd $COMMON_TOP/clone/bin; <b>(take a path from main appl node)</b></span></div>
<div>
<div class="MsoListParagraph">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> perl adclonectx.pl addnode
contextfile=<<b>echo $CONTEXT_FILE from main node</b>><o:p></o:p></span></div>
<div class="MsoListParagraph">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> <b><span style="color: red;">*All servers need to be enabled</span></b></span></div>
<div class="MsoListParagraph">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><span style="color: red;"> </span></b>perl <<b>echo $AD_TOP/bin</b> <b>from main node</b> >/adconfig.pl contextfile=<<b>specify the path to the new
context file from previous step</b>></span></div>
<div class="MsoListParagraph">
<span style="font-family: "arial" , "helvetica" , sans-serif;"> Edit .bash_profile to point to new env files.</span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">6. Run AutoConfig in both nodes (<b>main node need to be run as the last one</b>).</span><br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></b></div>
<div class="MsoListParagraph">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: .75in; mso-add-space: auto;">
<b><span style="color: red;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></span></b></div>
</div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">7. Edit Context file for 2 nodes</span><br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></b></div>
<div class="MsoListParagraph">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span><br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; margin-left: .5in; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr>
<td style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_applcsf </div>
</td>
<td style="border-left: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
Same on all nodes</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_fndreviverpiddir </div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
Same on all nodes</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
APPLDCP </div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
ON</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_appltmp </div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
Same on all nodes</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_temp</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
Same on all nodes</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_custom_file</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
Same is in main node</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_webentryhost </div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
F5 host</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_login_page </div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
F5 host</div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 167.6pt;" valign="top" width="223">
<div class="MsoListParagraphCxSpFirst" style="margin: 0in 0in 0.0001pt;">
s_external_url </div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 239.2pt;" valign="top" width="319">
<div class="MsoListParagraphCxSpLast" style="margin: 0in 0in 0.0001pt;">
F5 host</div>
</td>
</tr>
</tbody></table>
</div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">8. Run AutoConfig in both nodes (<b>main node need to be run as the last one</b>).</span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">9. Start APPL tier in both nodes (<b>main and after that secondary</b>).</span><br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></b></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">10. Enable Internal Monitor Managers for both nodes:</span><br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Go to Concurrent manager > Define > Look for Internal Monitor% > Work Shiftes</span><br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><o:p></o:p></span></b></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-DLEm3RgYlzM/VpeLsaU5WjI/AAAAAAAAYk4/U8bgbh4MDeM/s1600/s2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="190" src="https://2.bp.blogspot.com/-DLEm3RgYlzM/VpeLsaU5WjI/AAAAAAAAYk4/U8bgbh4MDeM/s320/s2.jpg" width="320" /></span></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"> Work Shift:Standard</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"> Processes: 1 > Save</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-YUP-Ogc35Dg/VpeLsv_q7NI/AAAAAAAAYk8/NSUsrg2MLtY/s1600/s3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="139" src="https://4.bp.blogspot.com/-YUP-Ogc35Dg/VpeLsv_q7NI/AAAAAAAAYk8/NSUsrg2MLtY/s320/s3.jpg" width="320" /></span></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"> Do the same for the second one</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-UnBP7D2oJh4/VpeLtGh25FI/AAAAAAAAYlE/P0oCGRW4BHI/s1600/s4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="191" src="https://4.bp.blogspot.com/-UnBP7D2oJh4/VpeLtGh25FI/AAAAAAAAYlE/P0oCGRW4BHI/s320/s4.jpg" width="320" /></span></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-IHJ_ITufE8U/VpeLtAUAQVI/AAAAAAAAYlI/E5ptZwhRJUk/s1600/s5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="141" src="https://2.bp.blogspot.com/-IHJ_ITufE8U/VpeLtAUAQVI/AAAAAAAAYlI/E5ptZwhRJUk/s320/s5.jpg" width="320" /></span></a></div>
<div class="MsoListParagraph">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Activate both managers.<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "arial" , "helvetica" , sans-serif; margin-left: 1em; margin-right: 1em;"><a href="http://3.bp.blogspot.com/-UZDpNaUDyAk/VpeLsetq3aI/AAAAAAAAYk0/DRLJ2jjAGnk/s1600/s1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="31" src="https://3.bp.blogspot.com/-UZDpNaUDyAk/VpeLsetq3aI/AAAAAAAAYk0/DRLJ2jjAGnk/s320/s1.jpg" width="320" /></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal">
<span style="line-height: 115%;"><span style="font-family: Arial, Helvetica, sans-serif;">Query which user session is on
which application servers:<span style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: teal; font-weight: bold;"><o:p></o:p></span></span></span></div>
<div class="MsoNormal">
<span style="background: white; color: teal; line-height: 115%;"><o:p><span style="font-family: Arial, Helvetica, sans-serif;"> </span></o:p></span><span style="background: white; color: teal; font-family: Arial, Helvetica, sans-serif; line-height: 115%;">select</span><span style="background: white; color: navy; font-family: Arial, Helvetica, sans-serif; line-height: 115%;">
nodes.node_name,usr.user_name,usr.user_id,ses.function_type</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: white; color: teal; line-height: 115%;">from</span><span style="background: white; color: navy; line-height: 115%;">
icx_sessions ses,<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="background: white; color: navy; line-height: 115%;"><span style="font-family: Arial, Helvetica, sans-serif;"> fnd_nodes nodes,<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="background: white; color: navy; line-height: 115%;"><span style="font-family: Arial, Helvetica, sans-serif;"> fnd_user usr<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: white; color: teal; line-height: 115%;">where</span><span style="background: white; color: navy; line-height: 115%;">
ses.node_id=nodes.node_id <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: white; color: teal; line-height: 115%;">and</span><span style="background: white; color: navy; line-height: 115%;">
ses.guest=</span><span style="background: white; color: blue; line-height: 115%;">'N'</span><span style="background: white; color: navy; line-height: 115%;"><o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: white; color: teal; line-height: 115%;">and</span><span style="background: white; color: navy; line-height: 115%;">
ses.user_id=usr.user_id<o:p></o:p></span></span></div>
<div class="separator" style="clear: both;">
</div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background: white; color: teal; line-height: 115%;">order</span><span style="background: white; color: navy; line-height: 115%;"> </span><span style="background: white; color: teal; line-height: 115%;">by</span><span style="background: white; color: navy; line-height: 115%;">
usr.user_id,nodes.node_name</span></span><span style="font-size: 12.0pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;"><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">You are done.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Good luck ...</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Useful documents:</b></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Sharing The Application Tier File System in Oracle E-Business Suite Release 12 (Doc ID 384248.1)</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Using Load-Balancers with Oracle E-Business Suite Release 12 (Doc ID 380489.1).</span></div>
<div class="separator" style="clear: both;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-32Ie58eBcsw/VpeM0BNCG6I/AAAAAAAAYlg/PGgOEgN7Y-E/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" src="https://1.bp.blogspot.com/-32Ie58eBcsw/VpeM0BNCG6I/AAAAAAAAYlg/PGgOEgN7Y-E/s1600/my_vote.gif" /></span></a></div>
</div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com2tag:blogger.com,1999:blog-2731794711719472397.post-41193087128893059162015-07-21T15:35:00.000+03:002015-07-21T15:35:22.587+03:00How to download Oracle Software from Edelivery or Oracle Metalink by script<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All ...</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the step by step guide <b><span style="color: #660000;">how to download Oracle software with script</span></b>.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Many of you already tried to do it from <span style="color: #660000;"><b>Oracle Edelivery</b></span> site and know that you need to download one by one and it can take a lot of time. Also there are some scripts that can do it for you , but need to install some plug-ins to google chrome or Mozilla to collect the cookies.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">This is the guide that I got from Oracle Support (thanks guys) and hope will make you life a little bit easy.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">1. Log-in to http://support.oracle.com </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">2. Go to Certifications tab</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-H2RNmdxiXwE/Va45A53_d9I/AAAAAAAAVno/FL17HoJpOVw/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="47" src="http://4.bp.blogspot.com/-H2RNmdxiXwE/Va45A53_d9I/AAAAAAAAVno/FL17HoJpOVw/s320/1.png" width="320" /></span></a></div>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">3. Choose the software,release and platform that you want to download and press Search</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">In my I want to download EBS 12.2.4 installation release for Oracle Linux 5</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-TTNpN84PvPo/Va45A6TAwtI/AAAAAAAAVns/S1kEEDb1BJk/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="65" src="http://2.bp.blogspot.com/-TTNpN84PvPo/Va45A6TAwtI/AAAAAAAAVns/S1kEEDb1BJk/s320/2.png" width="320" /></span></a></div>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">4. Click on Version on Number of Releases / Versions column</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-8o8TpeLVaUU/Va45A0HEijI/AAAAAAAAVnw/qgr50-_7-os/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="111" src="http://1.bp.blogspot.com/-8o8TpeLVaUU/Va45A0HEijI/AAAAAAAAVnw/qgr50-_7-os/s320/3.png" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"> 5. Choose the release. At this time you can re-choose another release</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-hszr_lSO91s/Va45BPc1lFI/AAAAAAAAVn0/MmRaOvN806M/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="95" src="http://2.bp.blogspot.com/-hszr_lSO91s/Va45BPc1lFI/AAAAAAAAVn0/MmRaOvN806M/s320/4.png" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"> 6. Select the Product and press Download</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-kmD8BkO-G2A/Va45BbJ2VMI/AAAAAAAAVn4/ovBEv68xsOk/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="120" src="http://2.bp.blogspot.com/-kmD8BkO-G2A/Va45BbJ2VMI/AAAAAAAAVn4/ovBEv68xsOk/s320/5.png" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"> 7. Accept the Agreement and press Next</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-5xt_-XOmZY4/Va45Booo88I/AAAAAAAAVok/BLDA_SFn05s/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="212" src="http://2.bp.blogspot.com/-5xt_-XOmZY4/Va45Booo88I/AAAAAAAAVok/BLDA_SFn05s/s320/6.png" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">8. Now you will get the all zips that you can download. You can download it one by one or just press on WGET options </span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-UsfNB0Tw82w/Va45BzOqppI/AAAAAAAAVoA/doNnTSrgQDI/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="209" src="http://4.bp.blogspot.com/-UsfNB0Tw82w/Va45BzOqppI/AAAAAAAAVoA/doNnTSrgQDI/s320/7.png" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"> 9. Press on Download.sh to get the scripts and save it. Please pay attention, the script will work only for 8 hours after the creation</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-AqdRxJpEzc4/Va45COJTtII/AAAAAAAAVoE/0oG4suT9AMk/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="210" src="http://1.bp.blogspot.com/-AqdRxJpEzc4/Va45COJTtII/AAAAAAAAVoE/0oG4suT9AMk/s320/8.png" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">10. That's it. Just enter you oracle account password and you can start downloading.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-WhrM-VBpD6Y/Va45ClGPTpI/AAAAAAAAVoM/UZ5g8-HBelI/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="117" src="http://1.bp.blogspot.com/-WhrM-VBpD6Y/Va45ClGPTpI/AAAAAAAAVoM/UZ5g8-HBelI/s320/9.png" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">TIP: the release can include alot of file that you will not use, so just remove or remark the WGET line form the script (for example all NLS packages) </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif; margin-left: 1em; margin-right: 1em;"><a href="http://1.bp.blogspot.com/-XtuasoMlEBg/Va479OaqlVI/AAAAAAAAVo0/MrezehGj_Ck/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-XtuasoMlEBg/Va479OaqlVI/AAAAAAAAVo0/MrezehGj_Ck/s1600/my_vote.gif" /></a></span></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com5tag:blogger.com,1999:blog-2731794711719472397.post-1702153459627332122015-07-16T12:59:00.002+03:002016-03-10T10:57:33.948+02:00How to collect Discoverer Plus and Viewer statistics<br />
Hi All .<br />
<br />
Here the step by step <b><span style="color: #660000;">How to collect Discoverer Plus and Viewer statistics</span></b>.<br />
<br />
<b><span style="color: #660000;">1.Navigate to the 'util' directory and edit the pref.txt file:</span></b><br />
<br />
-- For 4i, it is $ORACLE_HOME/discwb4/util<br />
-- For 10g, it is $ORACLE_HOME/discoverer/util<br />
-- For 11g, it is: $ORACLE_HOME/discoverer/config/pref.txt<br />
<br />
$ORACLE_HOME refers to the top level AS home (Linux/Unix Example - /do2/Oracle/Middleware/as_1). Your actual ORACLE_HOME name may differ, but should follow similar directory/path.<br />
<b><span style="color: #660000;">2.Navigate to the [Application] section:</span></b><br />
<b><span style="color: #660000;">3. Set the parameters</span></b><br />
<br />
<b>QPPEnable = 1</b><br />
<b>QPPCreateNewStats = 1 </b><br />
<br />
(Although QPPCreateNewStats is not available by default in 11g, it still applies to 11g as well)<br />
<br />
<b><span style="color: #660000;">4. Save the pref.txt file.</span></b><br />
<b><span style="color: #660000;">5. Now we need to update the preference registry file:</span></b><br />
<br />
-- For 4i and 10g, Unix/Linux, run: ./applypreferences.sh<br />
-- For 4i and 10g, Windows run: applypreferences.bat<br />
-- For 11g, Unix/Linux, run: $ORACLE_INSTANCE/Discoverer/Discoverer_asinst_1/util/applypreferences.sh<br />
-- For 11g, Windows, run: $ORACLE_INSTANCE\Discoverer\Discoverer_asinst_1\util\applypreferences.bat<br />
<br />
$ORACLE_INSTANCE refers to the instance home in the WLS/Discoverer home (Example - /do2/Oracle/Middleware/asinst_1). Your actual ORACLE_INSTANCE may differ, but should follow similar directory/path.<br />
Your ORACLE_INSTANCE may also differ if your environment includes multiple instances as may occur with clustered environments.<br />
<br />
These settings will take effect for new sessions launched, but not existing sessions.<br />
You may optionally, restart the Discoverer to force/kill all existing sessions.<br />
<br />
<span style="color: #660000;">P.S</span> <b>If you are using the Oracle BI Discoverer Plus Version 11.1.1.6.0/11.1.1.4.0 , you need to apply patch 11784475 (DISCO 11G PLUS/VIEWER QUERY STATS NOT WORKING IN APPS 12I EUL/64 BIT OS)</b><br />
<br />
Good Luck ...<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-dcy9XVc0KFk/Vad_Yy2sZeI/AAAAAAAAVko/kCMHMelPrbU/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://2.bp.blogspot.com/-dcy9XVc0KFk/Vad_Yy2sZeI/AAAAAAAAVko/kCMHMelPrbU/s1600/my_vote.gif" /></a></div>
<br />Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com1tag:blogger.com,1999:blog-2731794711719472397.post-1524615660870454102015-06-29T16:25:00.003+03:002016-01-14T11:21:32.485+02:00How to re-open EXPIRED & LOCKED user with the same password <div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
Hi All ...<br />
<br />
Here the fast way to re-open the DB users when it in EXPIRED & LOCKED status and you don't want to change the password and not remember the old one.<br />
<br />
Run the following with "/as sysdba" :<br />
<br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 1394px;">
<colgroup><col style="mso-width-alt: 50980; mso-width-source: userset; width: 1046pt;" width="1394"></col>
</colgroup><tbody>
<tr height="19" style="height: 14.25pt;">
<td class="xl64" height="19" style="height: 14.25pt; width: 1046pt;" width="1394"><span style="color: #660000;"><b>1. Change the </b><b>FAILED_LOGIN_ATTEMPTS profile to UNLIMITED.</b></span><br />
alter profile default limit failed_login_attempts unlimited password_life_time unlimited;<br />
<b><br /><span style="color: #660000;">2. Sql to change the status from LOCKED to OPEN (copy the result and run in sqlplus).</span></b><br />
select
'alter user '|| username || ' account unlock;' <br />
from dba_users where account_status =
'LOCKED'</td>
</tr>
<tr height="19" style="height: 14.25pt;">
<td class="xl64" height="19" style="height: 14.25pt;"><br />
<b><span style="color: #660000;">3. Sql to remove the expired status </span></b><b><span style="color: #660000;">(copy the result and run in sqlplus).</span></b><br />
select 'alter user ' ||
su.name || ' identified by values' || ' ''' || spare4 || ';' || su.password
|| ''';' <br />
from sys.user$ su join dba_users du on ACCOUNT_STATUS like
'EXPIRED%' <br />
and su.name = du.username;<br />
<br />
<br />
Good Luck ...<br />
<br />
<a href="http://4.bp.blogspot.com/-7wSgIJPIvsg/VZFG0Jqw-mI/AAAAAAAAVW4/4sSBRRy1BWg/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="http://4.bp.blogspot.com/-7wSgIJPIvsg/VZFG0Jqw-mI/AAAAAAAAVW4/4sSBRRy1BWg/s1600/my_vote.gif" /></a></td>
</tr>
</tbody></table>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-76474560001638851482015-06-25T14:17:00.002+03:002015-06-25T14:17:57.649+03:00UPK to EBS R12 - Step By Step.<span style="font-family: Arial, Helvetica, sans-serif;">Hi All</span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Here the step by step guide how to connect the Oracle EBS R12 to use UPK help.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>1. Add the UPK to CUSTOM.pll file:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•</span><span class="Apple-tab-span" style="font-family: Arial, Helvetica, sans-serif; white-space: pre;"> </span><span style="font-family: Arial, Helvetica, sans-serif;">Backup the CUSTOM.plx before installation.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Copy the attached ODPN.pll file to $AU_TOP/resource.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Compile the ODPN.pll using:</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">frmcmp_batch </span><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;">userid=apps/apps module=ODPN.pll module_type=LIBRARY </span> </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>make sure that the ODPN.plx was created.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Convert the CUSTOM.pll to text file (ECM_CUSTOM.pld)</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">frmcmp_batch </span><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;">userid=apps/apps module= CUSTOM.pll module_type=LIBRARY script=Ye</span>s</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Open the CUSTOM.pld</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Add the fillowing line at the begining of the file:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">.attach LIBRARY ODPN END NOCONFIRM</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">right after the last attached pll</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Add the following at the end of the Event procedure (before the line with "end event;"), save and close the file:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">/*************** UPK Module ****************************************/</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">gkod_event(event_name, 'SPECIAL20');</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">/*******************************************************************/</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Convert the ECM_CUSTOM.pld from text file to pll file (binary) using:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">frmcmp_batch userid=apps/apps module= CUSTOM.pld module_type=LIBRARY parse=Yes (make sure that the CUSTOM.pll was created).</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Compile the CUSTOM.pll using:</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">frmcmp_batch </span><span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;">userid=apps/apps module= CUSTOM.pll module_type=LIBRARY</span> (make sure that the CUSTOM.plx was created).</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><b>2.<span class="Apple-tab-span" style="white-space: pre;"> </span>Copy the content of directory</b> - Create Requisition Publish\Publishing content\PlayerPackage to<span style="color: #660000;"><b> $INST_TOP/portal/upk</b></span> (or use windows shared directory so you need to mount directory and create a soft link </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">cd </span><b style="color: #660000; font-family: Arial, Helvetica, sans-serif;">$INST_TOP/portal</b><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ln -s <shared directory> upk ).</span><br />
<span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>3.<span class="Apple-tab-span" style="white-space: pre;"> </span>Login to Oracle Application and update Applications Help Web Agent profile with the following string</b>:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">http://<hostname>:<port>/upk/oracle/hemi/oracle_gateway.html</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><b>4.<span class="Apple-tab-span" style="white-space: pre;"> </span>Restart Apache service</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>5.<span class="Apple-tab-span" style="white-space: pre;"> </span>Now you can use the UPK to EBS functionality from EBS help menu.</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif; margin-left: 1em; margin-right: 1em;"><a href="http://3.bp.blogspot.com/-5lIlLXerweY/UJel29e78KI/AAAAAAAAAbw/qVPtm8lClSo/s1600/UPK1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="http://3.bp.blogspot.com/-5lIlLXerweY/UJel29e78KI/AAAAAAAAAbw/qVPtm8lClSo/s320/UPK1.JPG" width="320" /></a></span></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
Good Luck ...</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-ezTXPzX2O6s/UJemFjmPxyI/AAAAAAAAAb4/PkSO8n01e08/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-ezTXPzX2O6s/UJemFjmPxyI/AAAAAAAAAb4/PkSO8n01e08/s1600/my_vote.gif" /></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-28384886655973037062014-11-25T12:20:00.001+02:002014-11-25T12:23:53.189+02:00Refreshing IQY file from discoverer 11g<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All ...</span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Here the new issue that I have found in Discoverer 11g during the refreshing <span style="color: #660000;"><b>IQY file</b></span>.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Open discoverer plus report <o:p></o:p> --> export</span></div>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-h0nTcXBL0wY/VHRWCbEB9fI/AAAAAAAAKfs/DTFVq0R5BSc/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://4.bp.blogspot.com/-h0nTcXBL0wY/VHRWCbEB9fI/AAAAAAAAKfs/DTFVq0R5BSc/s1600/1.jpg" height="170" width="320" /></span></a></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">change format to IQY:<o:p></o:p></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-pqYyj-4RH3A/VHRVV4Xs_rI/AAAAAAAAKfE/PBPRGHo_6DY/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://1.bp.blogspot.com/-pqYyj-4RH3A/VHRVV4Xs_rI/AAAAAAAAKfE/PBPRGHo_6DY/s1600/2.jpg" height="291" width="320" /></span></a></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Next.. next…..next<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Open file and run from your computer:</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><o:p></o:p></span></div>
<div class="MsoListParagraph" style="text-indent: -.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;">1 Enter your password when required<o:p></o:p></span></div>
<div class="MsoListParagraph" style="text-indent: -.25in;">
<span style="font-family: Arial, Helvetica, sans-serif;">2 Enter:<o:p></o:p></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-inbsl9sZeKI/VHRVhix6UPI/AAAAAAAAKfY/6DWle7W4cDg/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://2.bp.blogspot.com/-inbsl9sZeKI/VHRVhix6UPI/AAAAAAAAKfY/6DWle7W4cDg/s1600/3.png" height="160" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"> <span style="text-indent: -24px;">Enter:</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-IHG5zXayjLs/VHRVhUAi8BI/AAAAAAAAKfc/fnWHGtdyuU0/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://3.bp.blogspot.com/-IHG5zXayjLs/VHRVhUAi8BI/AAAAAAAAKfc/fnWHGtdyuU0/s1600/4.png" height="173" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Get the error:</span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-wpa_bLOuo_Y/VHRVhTkDpAI/AAAAAAAAKfU/O6uEL-g95rI/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://3.bp.blogspot.com/-wpa_bLOuo_Y/VHRVhTkDpAI/AAAAAAAAKfU/O6uEL-g95rI/s1600/5.png" height="139" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: #fafafa;"> </span><br style="background-color: #fafafa;" /><b><span style="color: #660000;"><span style="background-color: #fafafa;">The application encounters an invalid state. . </span><br style="background-color: #fafafa;" /><span style="background-color: #fafafa;">#NAME? </span><br style="background-color: #fafafa;" /><span style="background-color: #fafafa;">- Java heap space </span><br style="background-color: #fafafa;" /><span style="background-color: #fafafa;">Oracle BI Discoverer Viewer cannot find the data necessary to display the results of this event. Correct any errors, and try again. </span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><b>Reason:</b></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;">It appears that the managed server <b><span style="color: #660000;">WLS_DISCO</span></b> is running out of <span style="color: #660000;">heap space</span>. </span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><b>Solution:</b></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: #fafafa;">You need to increase the maximum heap space.</span><br style="background-color: #fafafa;" /><span style="background-color: #fafafa;">How to increase the maximum<span style="color: #660000;"> java heap memory </span>allowed for the managed server WLS_DISCO ( </span><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?id=1592078.1" style="background-color: #fafafa;" target="_blank" title="View article in a new browser tab">Doc ID 1592078.1</a><span style="background-color: #fafafa;"> ) </span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: #fafafa;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<span style="font-family: Arial, Helvetica, sans-serif;"> Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-JLUX0yQMNn4/VHRXPQQ40NI/AAAAAAAAKf4/-yzeRq6a1dc/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://3.bp.blogspot.com/-JLUX0yQMNn4/VHRXPQQ40NI/AAAAAAAAKf4/-yzeRq6a1dc/s1600/my_vote.gif" /></span></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-72914563640974545102014-08-07T13:03:00.000+03:002014-08-07T13:03:11.699+03:00Using GMail's SMTP and IMAP servers in Oracle Notification Mailer (Workflow Mailer )<span style="background-color: white; color: #555555; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span>
<span style="background-color: white; color: #555555; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">Hi All ...</span></span><br />
<span style="background-color: white; color: #555555; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">Here the step by step guide how to use Gmail account with Oracle Workflow mailer.</span></span><br />
<span style="background-color: white; color: #555555; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">Tested it in couple of customer sites and it working perfect...</span></span><br />
<span style="background-color: white; color: #555555; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span>
<span style="background-color: white; color: #555555; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">Overview</span></span><br />
<div class="entry-body" style="background-color: white; line-height: 18px;">
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">GMail offers free, reliable, popular SMTP and IMAP services, because of which many people are interested to use it. GMail can be used when there are no in-house SMTP/IMAP servers for testing or debugging purposes. This blog explains how to install GMail SSL certificate in Concurrent Tier, testing the connection using a standalone program, running Mailer diagnostics and configuring GMail IMAP and SMTP servers for Workflow Notification Mailer Inbound and Outbound connections.</span></div>
<h3 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">GMail servers configuration</span></h3>
<h4 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">SMTP server </span></h4>
<table border="1" cellpadding="1" cellspacing="1" style="color: #555555; height: 188px; width: 357px;"><tbody>
<tr><td style="width: 172px;"><b><span style="font-family: Arial, Helvetica, sans-serif;">Host Name</span></b></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"> smtp.gmail.com</span></td></tr>
<tr><td style="width: 172px;"><b><span style="font-family: Arial, Helvetica, sans-serif;">SSL Port</span></b></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"> 465</span></td></tr>
<tr><td style="width: 172px;"><b><span style="font-family: Arial, Helvetica, sans-serif;">TLS/SSL required</span></b></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"> Yes</span></td></tr>
<tr><td style="width: 172px;"><b><span style="font-family: Arial, Helvetica, sans-serif;">User Name</span></b></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"> Your full email address (including @gmail.com or @your_domain.com)</span></td></tr>
<tr><td style="width: 172px;"><b><span style="font-family: Arial, Helvetica, sans-serif;">Password</span></b></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"> Your gmail password</span></td></tr>
</tbody></table>
<h4 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;"> IMAP server</span></h4>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
</div>
<table border="1" cellpadding="1" cellspacing="1" style="color: #555555; height: 168px; width: 357px;"><tbody>
<tr><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"><b> Host Name</b></span></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;">imap.gmail.com </span></td></tr>
<tr><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"><b> SSL Port</b></span></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;">993 </span></td></tr>
<tr><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"><b>TLS/SSL Required</b> </span></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;">Yes </span></td></tr>
<tr><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"><b> User Name</b></span></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;"> Your full email address (including @gmail.com or @your_domain.com)</span></td></tr>
<tr><td style="width: 172px;"><b><span style="font-family: Arial, Helvetica, sans-serif;"> Password</span></b></td><td style="width: 172px;"><span style="font-family: Arial, Helvetica, sans-serif;">Your gmail password</span></td></tr>
</tbody></table>
<h3 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">GMail SSL Certificate Installation</span></h3>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">The following is the procedure to install the GMail SSL certificate</span></div>
<ul style="color: #555555; margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">Copy the below GMail SSL certificate in to a file eg: gmail.cer</span></li>
</ul>
<ol style="color: #555555; margin: 10px 0px 10px 17px;"></ol>
<div style="margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;">-----BEGIN CERTIFICATE-----<br />MIIDWzCCAsSgAwIBAgIKaNPuGwADAAAisjANBgkqhkiG9w0BAQUFADBGMQswCQYD<br />VQQGEwJVUzETMBEGA1UEChMKR29vZ2xlIEluYzEiMCAGA1UEAxMZR29vZ2xlIElu<br />dGVybmV0IEF1dGhvcml0eTAeFw0xMTAyMTYwNDQzMDRaFw0xMjAyMTYwNDUzMDRa<br />MGgxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpDYWxpZm9ybmlhMRYwFAYDVQQHEw1N<br />b3VudGFpbiBWaWV3MRMwEQYDVQQKEwpHb29nbGUgSW5jMRcwFQYDVQQDEw5pbWFw<br />LmdtYWlsLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAqfPyPSEHpfzv<br />Xx+9zGUxoxcOXFrGKCbZ8bfUd8JonC7rfId32t0gyAoLCgM6eU4lN05VenNZUoCh<br />L/nrX+ApdMQv9UFV58aYSBMU/pMmK5GXansbXlpHao09Mc8eur2xV+4cnEtxUvzp<br />co/OaG15HDXcr46c6hN6P4EEFRcb0ccCAwEAAaOCASwwggEoMB0GA1UdDgQWBBQj<br />27IIOfeIMyk1hDRzfALz4WpRtzAfBgNVHSMEGDAWgBS/wDDr9UMRPme6npH7/Gra<br />42sSJDBbBgNVHR8EVDBSMFCgTqBMhkpodHRwOi8vd3d3LmdzdGF0aWMuY29tL0dv<br />b2dsZUludGVybmV0QXV0aG9yaXR5L0dvb2dsZUludGVybmV0QXV0aG9yaXR5LmNy<br />bDBmBggrBgEFBQcBAQRaMFgwVgYIKwYBBQUHMAKGSmh0dHA6Ly93d3cuZ3N0YXRp<br />Yy5jb20vR29vZ2xlSW50ZXJuZXRBdXRob3JpdHkvR29vZ2xlSW50ZXJuZXRBdXRo<br />b3JpdHkuY3J0MCEGCSsGAQQBgjcUAgQUHhIAVwBlAGIAUwBlAHIAdgBlAHIwDQYJ<br />KoZIhvcNAQEFBQADgYEAxHVhW4aII3BPrKQGUdhOLMmdUyyr3TVmhJM9tPKhcKQ/<br />IcBYUev6gLsB7FH/n2bIJkkIilwZWIsj9jVJaQyJWP84Hjs3kus4fTpAOHKkLqrb<br />IZDYjwVueLmbOqr1U1bNe4E/LTyEf37+Y5hcveWBQduIZnHn1sDE2gA7LnUxvAU=<br />-----END CERTIFICATE-----</span></span></div>
<ul style="color: #555555; margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">Install the SSL certificate into the default JRE location or any other location using below command</span></li>
</ul>
<blockquote style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<ul style="margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">Installing into a dfeault JRE location in EBS instance</span></li>
</ul>
</blockquote>
<span style="color: #555555; font-family: Arial, Helvetica, sans-serif;"> # keytool -import -trustcacerts -keystore $AF_JRE_TOP/lib/security/cacerts -storepass changeit -alias gmail-lnx_chainnedcert -file gmail.cer<br /></span><blockquote style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<ul style="margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">Install into a custom location</span></li>
</ul>
</blockquote>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;"> # keytool -import -trustcacerts -keystore <customLocation> -storepass changeit -alias gmail-lnx_chainnedcert -file gmail.cer<br /> <customLocation> -- directory in instance where the certificate need to be installed</span></div>
<blockquote style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<ul style="margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">After running the above command you can see the following response</span></li>
</ul>
</blockquote>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;"> Trust this certificate? [no]: yes<br /> Certificate was added to keystore </span></div>
<h3 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Running Mailer Command Line Diagnostics</span></h3>
<ul style="color: #555555; margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">Run Mailer command line diagnostics from conccurrent tier where Mailer is running, to check the IMAP connection using the below command</span></li>
</ul>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dserver=imap.gmail.com -Dport=993 -Dssl=Y -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=<gmail username> -Dpassword=<password> -Dconnect_timeout=120 -Ddebug=Y -Dlogfile=GmailImapTest.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer</span></div>
<ul style="color: #555555; margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">Run Mailer command line diagnostics from concurrent tier where Mailer is running, to check the SMTP connection using the below command </span></li>
</ul>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;"> $AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dserver=smtp.gmail.com -Dport=465 -Dssl=Y -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=<gmail username> -Dpassword=<password> -Dconnect_timeout=120 -Ddebug=Y -Dlogfile=GmailSmtpTest.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer </span></div>
<h3 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Standalone program to verify the IMAP connection</span></h3>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">Run the below standalone program from the concurrent tier node where Mailer is running to verify the connection with GMail IMAP server. It connects to the GMail IMAP server with the given GMail user name and password and lists all the folders that exist in that account. If the GMail IMAP server is not working for the Mailer check whether the PROCESSED and DISCARD folders exist for the GMail account, if not create manually by logging into GMail account.</span></div>
<span style="color: #555555; font-family: Arial, Helvetica, sans-serif;">Sample <a href="https://blogs.oracle.com/oracleworkflow/resource/GmailSSLCert/GmailIMAPTest.java" style="color: black;" target="_blank" title="program">program </a>to test GMail IMAP connection</span><div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
</div>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;"> The standalone program can be run as below</span></div>
<pre style="color: #555555; margin-bottom: 10px; margin-top: 10px;"><span style="font-family: Arial, Helvetica, sans-serif;"> $java GmailIMAPTest GMailUsername GMailUserPassword </span></pre>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
</div>
<h3 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Standalone program to verify the SMTP connection</span></h3>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">Run the below standalone program from the concurrent tier node where Mailer is running to verify the connection with GMail SMTP server. It connects to the GMail SMTP server by authenticating with the given user name and password and sends a test email message to the give recipient user email address.</span></div>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">Sample <a href="https://blogs.oracle.com/oracleworkflow/resource/GmailSSLCert/GmailSMTPTest.java" style="color: black;" target="_blank" title="program">program </a>to test GMail SMTP connection</span></div>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">The standalone program can be run as below </span></div>
<pre style="color: #555555; margin-bottom: 10px; margin-top: 10px;"><span style="font-family: Arial, Helvetica, sans-serif;"> $java GmailSMTPTest GMailUsername GMailPassword recipientEmailAddress </span></pre>
<div style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
</div>
<h4 style="color: #555555; margin-bottom: 10px; margin-top: 10px;">
<span style="font-family: Arial, Helvetica, sans-serif;">Warnings</span></h4>
<ul style="color: #555555; margin: 10px 0px 10px 17px; padding: 0px;">
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">As gmail.com is an external domain, the Mailer concurrent tier should allow the connection with GMail server</span></li>
<li style="margin-left: 15px;"><span style="font-family: Arial, Helvetica, sans-serif;">Please keep in mind when using it for corporate facilities, that the e-mail data would be stored outside the corporate network</span></li>
</ul>
<div style="color: #555555;">
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span></div>
<div class="separator" style="clear: both; color: #555555; text-align: center;">
<a href="http://3.bp.blogspot.com/-1kp8kwjxfLA/U-NOnXSitaI/AAAAAAAAGIw/SvXAo5tIDKI/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-1kp8kwjxfLA/U-NOnXSitaI/AAAAAAAAGIw/SvXAo5tIDKI/s1600/my_vote.gif" /></a></div>
<div style="color: #555555;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
</div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-46198836412600820632014-08-04T16:55:00.000+03:002014-08-04T16:55:00.959+03:00 FNDCPPUR - Purge Concurrent Request and/or Manager Data - run forever<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All ...</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">This is the issue that found after upgrade 11i instance with Base Line.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">The <b><span style="color: #660000;">Purge Concurrent Request and/or Manager Data</span></b> run <b><span style="color: #660000;">forever</span></b>.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>Here the action plan:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">1. Stop the concurrent manager.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">2. Connect to sqlplus as APPS user : </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">SQL> truncate table APPLSYS.FND_CONCURRENT_PROCESSES;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">SQL> truncate table APPLSYS.FND_ENV_CONTEXT;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">3. cd $FND_TOP/bin </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">adrelink.sh force=y link_debug=y "fnd<b><span style="color: #660000;"> FNDCPPUR</span></b>"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">4. Start the concurrent manager.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">5. Retest the issue after running the concurrent program "<b><span style="color: #660000;">Purge Concurrent Request and/or Manager Data</span></b>".</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/--Q8LxHUdyXY/U9-QeOdUFeI/AAAAAAAAGIY/fnghwoA76C4/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/--Q8LxHUdyXY/U9-QeOdUFeI/AAAAAAAAGIY/fnghwoA76C4/s1600/my_vote.gif" /></a></div>
<br />Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-33606956521221424312014-07-17T13:57:00.000+03:002014-07-17T13:57:03.865+03:00 All Java SE Downloads on MOS<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I'm getting the notifications from Oracle about a new certification products.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">One of the notification is New Java version certification for EBS.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">There was a link to previous java versions in www.oracle.com.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Right now all Java versions can be downloaded from <b><span style="background: white;"><span style="color: #660000;">All Java SE Downloads on MOS (Doc ID 1439822.1)</span></span></b></span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">For example , you want to download<span style="color: #660000;"><b> </b></span></span><span style="color: #660000;"><b>jre-6u81-windows-i586.exe</b></span>:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-aGtcvXFW5ks/U8erH9wlIYI/AAAAAAAAFqk/g97xMiDRAkg/s1600/java1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://3.bp.blogspot.com/-aGtcvXFW5ks/U8erH9wlIYI/AAAAAAAAFqk/g97xMiDRAkg/s1600/java1.png" height="55" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">This patch include JDK and JRE.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Just download it and install the relevant.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span><br />
<span style="font-family: Tahoma, sans-serif;"><b><br /></b></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-RWgMXbKY02I/U8ervE8VNFI/AAAAAAAAFqs/I5wMyNWc770/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-RWgMXbKY02I/U8ervE8VNFI/AAAAAAAAFqs/I5wMyNWc770/s1600/my_vote.gif" /></a></div>
<b><span style="background: white; font-family: Tahoma, sans-serif;"><br /></span></b>
<b><span style="background: white; font-family: Tahoma, sans-serif;"><br /></span></b>
<b><span style="background: white; font-family: Tahoma, sans-serif;"><br /></span></b>
<div class="MsoNormal">
<b><span style="background: white; font-family: Tahoma, sans-serif;"><o:p></o:p></span></b></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com4tag:blogger.com,1999:blog-2731794711719472397.post-26989222950386845552014-06-23T12:32:00.001+03:002014-06-23T12:32:37.229+03:00R12 Purchase Order Preference Form Errors With "APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch rows more than requested number of rows"<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All ...</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I Have got the following error in my R12 upgraded instance:</span><br />
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">APP-PO-14142: get_po_parameters-10: ORA-01422: exact fetch rows more than requested number of rows</span></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-WZyF2-2edO8/U6fyryVFiUI/AAAAAAAAE2o/jTlGbl6H75o/s1600/Grant.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://3.bp.blogspot.com/-WZyF2-2edO8/U6fyryVFiUI/AAAAAAAAE2o/jTlGbl6H75o/s1600/Grant.jpg" height="245" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">SELECT count(*) FROM
po_document_types;</span></b><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Right now the select show : 378
rows</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Action Plan:</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">1. Connect /as sysdba</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">2. <o:p></o:p><b><span style="color: #660000;">Revoke EXEMPT ACCESS POLICY from
APPS;</span></b></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">3. Re-connect with APPS user and rerun <b><span style="color: #660000;">SELECT count(*) FROM
po_document_types;</span></b></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">4.<b> </b>Your issue would be resolved if this returns zero records.</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">5. Re-check the issue.</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Good luck ...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-cmJtLOmnN6M/U6fzqbhvI4I/AAAAAAAAE20/Z7USD_0B0es/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://4.bp.blogspot.com/-cmJtLOmnN6M/U6fzqbhvI4I/AAAAAAAAE20/Z7USD_0B0es/s1600/my_vote.gif" /></span></a></div>
<div class="MsoNormal">
<br /></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-50300393048377964812014-06-10T13:12:00.000+03:002014-06-10T13:12:18.109+03:00Adcfgclone on DB tier fail with ouicli.pl <span style="font-family: Arial, Helvetica, sans-serif;">Hi All ... </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the issue that I have found during the clone <span style="color: #660000;">DB tier</span>:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">AutoConfig could not successfully execute the following
scripts:<o:p></o:p></span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b> Directory:
/clone/oracle/product/11.2.0/perl/bin/perl -I
/clone/oracle/product/11.2.0/perl/lib/5.8.3 -I /clone/oracle/product/11.2.0/perl/lib/site_perl/5.8.3
-I /clone/oracle/product/11.2.0/appsutil/perl
/clone/oracle/product/11.2.0/appsutil/clone</b><b><o:p></o:p></b></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><span dir="RTL"></span><b><span dir="RTL" lang="HE"><span dir="RTL"></span>
</span>ouicli.pl
INSTE8_APPLY 255</b><b><o:p></o:p></b></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>AutoConfig is exiting with status 1</b><b><o:p></o:p></b></span></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">RC-50013: Fatal: Instantiate driver did not complete
successfully.</span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Action Plan:</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">1. Change the DB CONTEXT_FILE<span style="color: #660000;"> <b>PERL5LIB</b></span> parameter
from <span style="color: #660000;"><b>5.8.3</b></span> to <b><span style="color: #660000;">5.10.0</span> </b></span></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">2. Change the <b><span style="color: #660000;">$ORACLE_HOME/appsutil/template/adxdbctx.tmp</span> </b>as
well as env file.</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">3. Run <b><span style="color: #660000;">autoconfig</span></b> on DB node</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">4. Run <span style="color: #660000;"><b>adpreclone</b></span> procedure on DB tier</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">5. Copy the data to clone instance and rerun <b><span style="color: #660000;">adcfgclone</span></b>.</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-dvrQqg4MKYE/U5bZuWnxSuI/AAAAAAAAEvU/f3lYqkGH_I4/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-dvrQqg4MKYE/U5bZuWnxSuI/AAAAAAAAEvU/f3lYqkGH_I4/s1600/my_vote.gif" /></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-8242835267898700452014-05-21T13:52:00.001+03:002014-05-21T13:52:21.710+03:00Find FND_PROFILE's changed by specific USER<span style="font-family: Arial, Helvetica, sans-serif;">Hi All ...</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the small sql that will help you to find which <b><span style="color: #660000;">FND_PROFILE</span></b>'s were changed by specific <b><span style="color: #660000;">USER</span></b> on your <b><span style="color: #660000;">EBS </span></b>instance.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">select
fpot.user_profile_option_name , decode(fpov.level_id,10001,'SITE'<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
,10002,'APPLICATION'<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
,10003,'RESPONSIBILITY'<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
,10004,'USER') Profile_Level , fpov.profile_option_value ,
fpov.last_update_date<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
from fnd_profile_options fpo<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
, fnd_profile_options_tl fpot<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
, fnd_profile_option_values fpov<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
where fpo.profile_option_name = fpot.profile_option_name<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
and fpo.profile_option_id = fpov.profile_option_id<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
and fpov.last_updated_by = (select user_id from fnd_user<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">
where user_name = '&USERNAME')<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-yKmtRPADtdI/U3yFIDln_KI/AAAAAAAAEhA/vjSU_ilqvIA/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-yKmtRPADtdI/U3yFIDln_KI/AAAAAAAAEhA/vjSU_ilqvIA/s1600/my_vote.gif" /></a></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-64617177435422612052014-05-08T10:28:00.002+03:002014-05-08T11:38:38.241+03:00Recover corrupted datafile - step by step.<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All ...</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the step by step how to recover corrupted datafile.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">I got the following error after DB crush:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">ORA-01110</span></b>: data file 12: '/oraprd/prddata/sysaux02.dbf'</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ORACLE Instance PRD (pid = 12) - Error 376 encountered while recovering transaction (115, 24) on object 373247.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Errors in file /oraprd/prddb/diag/rdbms/prd/PRD/trace/PRD_smon_21693.trc:</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>ORA-00376: file 11 cannot be read at this time</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">ORA-01110</span></b>: data file 11: '/oraprd/prddata/sysaux01.dbf'</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Action Plan:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">1. alter database datafile '/oraprd/prddata/sysaux01.dbf' offline;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> alter database datafile '/oraprd/prddata/sysaux02.dbf' offline;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">2. alter system switch logfile; (do it 10 times to be sure)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">3. shutdown abort;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">4. startup mount;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">5. recover datafile '/oraprd/prddata/sysaux02.dbf';</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ORA-00279: change 1306769 generated at 05/05/2014 22:54:48 needed for thread 1</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ORA-00289: suggestion : /oraprd/archive/817T001S02245.arc</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ORA-00280: change 1306769 for thread 1 is in sequence #2245</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Specify log: {=suggested | filename | AUTO | CANCEL}</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>AUTO</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Log applied.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Media recovery complete.</span><br />
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">--- Do it for all your corrupted files</span></b><br />
<span style="font-family: Arial, Helvetica, sans-serif;">6. alter database open;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">7.<b style="color: #660000;"> </b>alter database datafile '/oraprd/prddata/sysaux01.dbf' online;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">8. select tablespace_name, file_name, status from dba_data_files;</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>--- All files need to be with AVAILABLE status.</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-knk9nHoBTrk/U2oo3deTBKI/AAAAAAAAEQA/UN2x0ak_Biw/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-knk9nHoBTrk/U2oo3deTBKI/AAAAAAAAEQA/UN2x0ak_Biw/s1600/my_vote.gif" /></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-56306884557230644902014-05-07T15:37:00.002+03:002016-04-20T15:45:45.932+03:00Script to compile APPS schema without running adadmin<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Hi All ...</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Here the Script to compile <b><span style="color: #660000;">APPS schema</span></b> without running <b><span style="color: #660000;">adadmin</span></b>.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">As the appl user in linux, define both env vars :</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">export APPS_PASS=xxxx</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">export</span><span style="font-family: "arial" , "helvetica" , sans-serif;"> </span><span style="font-family: "arial" , "helvetica" , sans-serif;">SYSTEM_PASS=xxxx</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Then Run:</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">#R12</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">sqlplus
-s APPS/<b><span style="color: #660000;">$APPS_PASS</span></b> @$AD_TOP/sql/adutlrcmp.sql APPLSYS<span style="color: #660000;"> <b>$APPS_PASS</b></span><b> </b>APPS<b><span style="color: #990000;">
</span><span style="color: #660000;">$APPS_PASS $SYSTEM_PASS</span></b> 0 0 NONE FALSE</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<br /></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">#11i</span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">sqlplus
-s APPS/<b><span style="color: #660000;">$APPS_PASS</span></b> @$AD_TOP/admin/sql/adutlrcmp.pls APPLSYS <b><span style="color: #660000;">$APPS_PASS</span></b> APPS
<span style="color: #660000;"><b>$APPS_PASS $SYSTEM_PASS</b></span> 0 0 NONE FALSE<o:p></o:p></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal" style="direction: ltr; unicode-bidi: embed;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Good Luck ...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-knk9nHoBTrk/U2oo3deTBKI/AAAAAAAAEP8/e1UdWBPtgDk/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-knk9nHoBTrk/U2oo3deTBKI/AAAAAAAAEP8/e1UdWBPtgDk/s1600/my_vote.gif" /></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-38819189620910626352014-04-30T15:03:00.002+03:002014-05-01T12:07:27.156+03:00R12 Restart Apache + Clear Cache Concurrent <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All,</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the step by step guide for creating<b><span style="color: #660000;"> Concurrent to Restart Apache + Clear Cache in R12 EBS instance</span></b>.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Hope that it will save your time during upgrade cycles and users tests.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here we go....</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">1. Login to EBS with <b><span style="color: #660000;">System Administrator</span></b> responsibility.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">2. Go to Concurrent --> Program --> Executable.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-3sBih8fj1bM/U2Diw279nrI/AAAAAAAAECA/FeZ6qhdAuTA/s1600/11.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://4.bp.blogspot.com/-3sBih8fj1bM/U2Diw279nrI/AAAAAAAAECA/FeZ6qhdAuTA/s1600/11.JPG" height="150" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">Executable</span></b> : <span style="color: #660000;"><b>XX</b></span>_RESTART_APACHE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b>Short Name</b></span> : <span style="color: #660000;"><b>XX</b></span>_RESTART_APACHE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b>Application </b></span>: Your XX Custom Application</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b>Description</b></span> : Restart Apache</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b>Execution Method</b></span> : Host</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Execution File Name</b> : Restart_Apache</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">3. Save your changes.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">4. Go to Concurrent --> Program --> Define</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-GTUOhSJTx4M/U2Dj3qoGYhI/AAAAAAAAECI/DgcvGZ3qhF8/s1600/22.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://1.bp.blogspot.com/-GTUOhSJTx4M/U2Dj3qoGYhI/AAAAAAAAECI/DgcvGZ3qhF8/s1600/22.JPG" height="266" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">Program</span></b> : <span style="color: #660000;">XX</span> Restart Apache</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b>Short Name</b></span> : <span style="color: #660000;"><b>XX</b></span>_RESTART_APACHE</span></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b>Application </b></span>: Your XX Custom Application</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">Description </span></b>: Restart Apache</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>In Executable Section</b>:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">Name</span></b> : XX_RESTART_APACHE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b>Method</b></span> : Host</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">5. Save your changes.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">6. Create <span style="color: #660000;"><b>Restart_Apache.prog</b></span> under your <span style="color: #660000;"><b>CUSTOM_TOP/bin</b></span> directory:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">########################################################</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">#!/bin/ksh</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">ORIG_CONC_OUTPUT_FILE=$1</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">COPIES=$2</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">TITLE=$3</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">REQUEST_ID=`echo $TITLE | awk -F"." '{ print $NF }'`</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">LOG_DIR=$APPLCSF/$APPLLOG</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">OUT_DIR=$APPLCSF/$APPLOUT</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">LOG_FILE=l${REQUEST_ID}.req</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">OUT_FILE=o${REQUEST_ID}.out</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">USER_LOG_FILE=$LOG_DIR/$LOG_FILE # this is the log file that the user see</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">echo log file is $LOG_DIR</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">echo out file is $OUT_DIR</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">echo user log file is $USER_LOG_FILE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">$ADMIN_SCRIPTS_HOME/adoacorectl.sh stop 2>&1 $LOG_FILE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sleep 5</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">$ADMIN_SCRIPTS_HOME/adoacorectl.sh status 2>&1 $LOG_FILE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sleep 5</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">echo "Before clear cash"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">rm -Rf $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence/* >> $LOG_FILE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">echo "After clear cash"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">$ADMIN_SCRIPTS_HOME/adoacorectl.sh start 2>&1 $LOG_FILE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sleep 5</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">$ADMIN_SCRIPTS_HOME/adoacorectl.sh status 2>&1 $LOG_FILE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">########################################################</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">7. chmod +x <<b><span style="color: #660000;">YOUR CUTOM_TOP</span></b>>/bin/Restart_apache.prog</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">8. Create soft link </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ln -s $FND_TOP/bin/fndcpesr <<span style="color: #660000;"><b>YOUR CUTOM_TOP</b></span>>/bin/Restart_apache</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">9. Add you concurrent to request group under the <b>System Administrator</b>.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">That's all...</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ... </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-i-YlNjXwHh4/U2DlsxvlYtI/AAAAAAAAECU/g6MrXSMXUYk/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://3.bp.blogspot.com/-i-YlNjXwHh4/U2DlsxvlYtI/AAAAAAAAECU/g6MrXSMXUYk/s1600/my_vote.gif" /></span></a></div>
<br />Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-49385842706963934922014-04-27T15:52:00.003+03:002014-05-08T13:44:19.123+03:00The Upgrade Assistant failed in bringing up the database .<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Got this error during the upgrading the database to 11.2.0.4 (DBUA step 2-3) :</span><br />
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">The Upgrade Assistant failed in bringing up the database ....</span></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-mPkP_b0ga-0/U1z8aS47TgI/AAAAAAAAD_Y/Y0piMceFSjo/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://1.bp.blogspot.com/-mPkP_b0ga-0/U1z8aS47TgI/AAAAAAAAD_Y/Y0piMceFSjo/s1600/2.jpg" height="257" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Here the action for fix the issue.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">1. Remove all spfile from Old <span style="color: #660000;"><b>ORACLE HOME/dbs</b></span> (copy them or change there names).</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">2. Remove all from <b><span style="color: #660000;">$ORACLE_BASE</span></b>/cfgtoollogs/dbua</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">*** <b><span style="color: #660000;">ORACLE_BASE - base directory given by you during software installation</span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">3. Re-run the DBUA: cd $ORACLE_HOME/bin; ./dbua</span></div>
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><br /></span></b>
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><br /></span></b>
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-lYXlq5ix2Ow/U1zsgKNquCI/AAAAAAAAD_E/1h1nDHZE8Tc/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-lYXlq5ix2Ow/U1zsgKNquCI/AAAAAAAAD_E/1h1nDHZE8Tc/s1600/my_vote.gif" /></a></div>
<br />Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com10tag:blogger.com,1999:blog-2731794711719472397.post-23862744700969104392014-04-27T14:41:00.002+03:002016-05-11T16:32:52.308+03:00[INS-32025] The chosen installation conflicts with software already installed in the given Oracle home<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Hi All ,</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Some times we can got the following error :</span><br />
<b><span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;">[INS-32025] The chosen installation conflicts with software already installed in the given Oracle home.</span></b><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">while re-installing the DB on the same machine.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-SgnJajm8nss/U1zsrwnsCyI/AAAAAAAAD_I/CIHz9aIYhY0/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="290" src="https://4.bp.blogspot.com/-SgnJajm8nss/U1zsrwnsCyI/AAAAAAAAD_I/CIHz9aIYhY0/s1600/1.png" width="400" /></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="color: #660000; font-family: "arial" , "helvetica" , sans-serif;"><b>This is the step by step to fix the issue quickly:</b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">1. cat /etc/oraInst.loc </span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">2 cd <oraInventory path>/oraInventory/ContextXML (</span><span style="background-color: white; font-size: 13px; line-height: 18.2px; text-align: justify;"><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>In windows you can find the inventory.xml in C:\Program Files\Oracle\Inventory\ContentsXML</b></span></span><span style="font-family: arial, helvetica, sans-serif;">)</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">3. vi inventory.xml</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">4. Remove the line that contain the new ORACLE Home</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">5. Exit and re-run the installer.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><a href="http://4.bp.blogspot.com/-lYXlq5ix2Ow/U1zsgKNquCI/AAAAAAAAD_A/MmN_-gC6EXM/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://4.bp.blogspot.com/-lYXlq5ix2Ow/U1zsgKNquCI/AAAAAAAAD_A/MmN_-gC6EXM/s1600/my_vote.gif" /></a></span></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com94tag:blogger.com,1999:blog-2731794711719472397.post-17228588665183845982014-04-24T11:52:00.001+03:002014-04-24T11:52:27.710+03:00How to update patch adwork process manually<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All,</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the way to update patch adwork process manually when the process is stuck during the patch apply:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">1. Update the worker status :</span></b><br />
<span style="font-family: Arial, Helvetica, sans-serif;">UPDATE applsys.fnd_install_processes</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">SET status = 'F' <span style="color: #660000;"> <b> --- F = Failed</b></span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">WHERE worker_id = 1<span style="color: #660000;"> <b>--- Number of stuck adworker process</b></span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;"><b><br /></b></span>
<span style="color: #660000;"><b>2. Find the SID and the SERIAL# of </b></span><b style="color: #660000;">stuck adworker process</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">select sid,serial# from v$session where sid=xxx;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">3. Kill the session</span></b><br />
<span style="font-family: Arial, Helvetica, sans-serif;">alter system kill session 'xxx,yyy';</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="background-color: white; color: #660000; line-height: 18.200000762939453px;"><b><span style="font-family: Arial, Helvetica, sans-serif;">Useful documentation:</span></b></span><br />
<span style="background-color: white; text-align: right;"><span style="font-family: Arial, Helvetica, sans-serif;">Inadvertently Closing a Session of Adpatch Causes 'Unable to find job ' Error (Doc ID 257505.1)</span></span><br />
<span style="background-color: white; font-weight: bold; text-align: right;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ....</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-K0i7KYJpUgc/U1jQmUuQ92I/AAAAAAAAD5o/tVfNr40iWAU/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://1.bp.blogspot.com/-K0i7KYJpUgc/U1jQmUuQ92I/AAAAAAAAD5o/tVfNr40iWAU/s1600/my_vote.gif" /></span></a></div>
<br />Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com5tag:blogger.com,1999:blog-2731794711719472397.post-59456955237908631102013-08-26T12:56:00.000+03:002013-08-26T13:31:05.853+03:00Unable to see the another user request_id output after changing Concurrent:Report Access Level profile option<span style="font-family: Arial, Helvetica, sans-serif;">Hi All,</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">After changing<b><span style="color: #660000;"> Concurrent:Report Access Level</span></b> profile option on<b><span style="color: #660000;"> User Level</span></b> with "<span style="color: #660000;"><b>Responsibility</b></span>" according the <b> How to View the Output of a Request Launched by Someone Else (Doc ID <span style="color: #660000;">413382.1</span>).</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">And I'm still not able to see the another user request_id output.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-7kTCQDM3GkQ/UhskiuBncTI/AAAAAAAAAn0/6kTPN323xvw/s1600/Conc_acc.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="122" src="http://1.bp.blogspot.com/-7kTCQDM3GkQ/UhskiuBncTI/AAAAAAAAAn0/6kTPN323xvw/s320/Conc_acc.jpg" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">This is the bug in 11i.....</span><br />
<br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>Here the Action Plan:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>1.</b> Backup your instance.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>2.</b> Apply Patch <b><span style="color: #660000;">8579398</span></b> - CAN'T VIEW REQUEST'S OUTPUT SUBMITTED BY OTHERS AFTER PATCH 7202163.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>*** The patch address the issue that users cannot view output files from other</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>users under the same responsibility when profile option, report access level,</b></span><br />
<b><span style="font-family: Arial, Helvetica, sans-serif;"></span></b><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>is set to responsibility.</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>3.</b> Re-check the issue.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>4.</b> If the issue was resolved, move the patch to PROD instance.</span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-nEFoJT7sh5k/UhsmF4bBzQI/AAAAAAAAAoA/c5jaoIKmQ9A/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-nEFoJT7sh5k/UhsmF4bBzQI/AAAAAAAAAoA/c5jaoIKmQ9A/s1600/my_vote.gif" /></a></div>
<br />Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-25308520082697846342013-08-22T13:45:00.003+03:002013-10-27T09:53:10.614+02:00APEX installation on Linux - Step by Step<span style="font-family: Arial, Helvetica, sans-serif;">Hi All,</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the step by step for APEX installation on Linux.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">You can download the latest Apex version from:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html" target="_blank">http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html</a></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">1. Copy the apex_4.2.2_en.zip to $ORACLE_HOME:</span></b> </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">cp apex_4.2.2_en.zip $ORACLE_HOME</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>2. Extract apex_4.2.2_en.zip : </b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">cd $ORACLE_HOME; unzip apex_4.2.2_en.zip;cd $ORACLE_HOME/apex</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>3. Create a new tablespace for Apex objects:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">create TABLESPACE APEX </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> DATAFILE '/full_path_for_data_directory/apex01.dbf'</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> SIZE 1000M</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> AUTOEXTEND ON</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> NEXT 100M</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> MAXSIZE 8000M;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>4. Start APEX installation:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "/as sysdba" @apexins.sql APEX APEX TEMP /i/</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Arguments:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b> </b>Position 1: Name of tablespace for Application Express application user</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Position 2: Name of tablespace for Application Express files user</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Position 3: Name of temporary tablespace or tablespace group</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Position 4: Virtual directory for APEX images</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Example:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">1)Local</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "sys/syspass as sysdba" @apexins SYSAUX SYSAUX TEMP /i/</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">2)With connect string</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "sys/syspass@10g as sysdba" @apexins SYSAUX SYSAUX TEMP /i/</span><br />
<br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>5. Change ADMIN account password:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "/as sysdba" @apxchpwd.sql</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">*** The password must contain at least one punctuation character: (!”#$%&()“*+,-/:;?_).</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>6. Run the Embedded PL/SQL Gateway configuration (EPG):</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "/as sysdba" @apex_epg_config.sql $ORACLE_HOME (full path)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>7. Update the APEX images with those from the new release:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "/as sysdba" @apxldimg.sql $ORACLE_HOME (full path)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>8. Make sure that the following accounts are unlocked and not expired:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>If EXPIRED</b> - Change password for following users : ANONYMOUS,XDB,APEX_PUBLIC_USER,FLOWS_FILES,APEX_040200.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>IF LOCKED</b> - Unlock:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ALTER USER ANONYMOUS ACCOUNT UNLOCK;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ALTER USER XDB ACCOUNT UNLOCK;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ALTER USER FLOWS_FILES ACCOUNT UNLOCK;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ALTER USER APEX_040200 ACCOUNT UNLOCK;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>9. Enable network services (ACL) and XML DB HTTP server:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "/as sysdba"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">exec dbms_xdb.sethttpport(8080);</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>Verify the port:</b></span><br />
<span style="background-color: white; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 13px; line-height: 18px;">SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>10. Enable remote HTTP connections:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "/as sysdba"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">exec dbms_xdb.setlistenerlocalaccess(l_access => false);</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>11. Grant connect privileges to any host for the APEX_040200 database user:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">sqlplus "/as sysdba"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">DECLARE</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">ACL_PATH VARCHAR2(4000);</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">BEGIN</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">-- Look for the ACL currently assigned to '*' and give APEX_040200</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">-- the "connect" privilege if APEX_040200</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">-- does not have the privilege yet.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">'connect') IS NULL THEN</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">'APEX_040200', TRUE, 'connect');</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">END IF;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">EXCEPTION</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">-- When no ACL has been assigned to '*'.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">WHEN NO_DATA_FOUND THEN</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">'ACL that lets power users to connect to everywhere',</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">'APEX_040200', TRUE, 'connect');</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">END;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">/</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">COMMIT;</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">run also the following command:</span><br />
<span style="background-color: white; line-height: 19px;"><span style="font-family: Arial, Helvetica, sans-serif;">Alter system set shared_servers=10;</span></span><br />
<span style="background-color: white; line-height: 19px;"><span style="font-family: Arial, Helvetica, sans-serif;">*add </span></span><span style="background-color: white; font-family: Arial, Helvetica, sans-serif; line-height: 19px;">hared_servers=10 to your spfile/pfile.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>12. Check that Apex was installed:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">COMP_NAME VERSION STATUS</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">------------------------------ ------------------------------ -----------</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Oracle Application Express 4.2.2.00.11 VALID</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>13. Login first time. You will be asked to change ADMIN password:</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">http://localhost:8080/apex/apex_admin</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;">14. Workspace login page:</span></b> </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">http://localhost:8080/apex</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Workspace</b>: INTERNAL</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Username</b>: ADMIN</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b>Password</b>: Your new admin password</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-b6x6ydfuTD8/UhXrx4HG3gI/AAAAAAAAAnk/lmE7TGGWL8M/s1600/APEX_LOGIN.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="166" src="http://1.bp.blogspot.com/-b6x6ydfuTD8/UhXrx4HG3gI/AAAAAAAAAnk/lmE7TGGWL8M/s400/APEX_LOGIN.jpg" width="400" /></a></div>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-LIjjs0ThCqA/UhXrVlJopvI/AAAAAAAAAnc/CPzHIh_Ucfw/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-LIjjs0ThCqA/UhXrVlJopvI/AAAAAAAAAnc/CPzHIh_Ucfw/s1600/my_vote.gif" /></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com35tag:blogger.com,1999:blog-2731794711719472397.post-53473837899297633192013-03-31T10:36:00.000+03:002013-03-31T10:52:50.529+03:00How to run mod_plsql with Release 12 (unsupported)<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All,</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">We just finished the big upgrade project for R12.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">One of the problem was how to migrate the mod_plsql procedures from 11i to R12.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>With Release 12, mod_plsql is no longer Supported or recommended with eBiz and is disabled by default. This is explained in the Blog article "Mod_plsql Not Supported in Release 12" (<a href="http://blogs.oracle.com/stevenChan/entry/new_whitepaper_mod_plsql_and_e_1" target="_blank">http://blogs.oracle.com/stevenChan/entry/new_whitepaper_mod_plsql_and_e_1</a>) </b></span><br />
<b><span style="color: #660000;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Some customers have not been able to re-implement their Release 11i mod_plsql custom code in OA Framework but still want to migrate to Release 12. </span></span></b><br />
<b><span style="color: #660000;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">In this case, the only official suggestion is to implement a standalone OracleAS 10g instance running mod_plsql which then interfaces to Rel 12. This proposed solution is still considered a temporary workaround until the customer is able to re-implement customizations in OA Framework, which is the only Supported solution. Option A below lists the steps to implement this option. Option B is also listed but is not currently considered a good solution for Production environments as it introduces security risks.</span></span></b><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">If you still decided to do that, here the action plan:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>A. Install standalone AS10g instance, or utilise existing instance if available</b></span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">This can be Infrastructure (SSO) or Middle Tier (Portal) installation as both types will have mod_plsql already installed.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">1. Create new DAD entry</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">a. Login to Application Server Control and select the "HTTP_Server" link under "System Components"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">b. Select "Administration" link then "PL/SQL Properties"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">c. Under the DADs section you have the button to "Create" new DAD entry</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">d. Select DAD type of "General" and enter the following information</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> DAD Name or Location For example "/pls/r12vis"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Username <b>Enter "APPS"</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Password <b>Enter APPS user password</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Connect String For example, <b>myRDBMSHost.domain.com:1521:VIS</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Connect String Format SIDFormat</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Authentication Mode Set this to the blank entry (no value)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">e. Click "Apply" button to save these changes</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">2. Restart HTTP Server for the changes to take effect</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">3. You can then test your change by using the URL as below</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> http://myAS10gHost.domain.com:PORT/pls/r12vis/fnd_web.ping</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">This should return the FND_WEB ping output page showing the SYSDATE, DATABASE_VERSION, etc</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><b>B. Re-introduce mod_plsql into Release 12 Apache listener</b></span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>This is not a recommended option, as it introduces additional security risks to your environment so should only be used for TEST environments as a temporary workaround.</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">1. Modify the $ORACLE_CONFIG_HOME/../10.1.3/Apache/Apache/conf/oracle_apache.conf file to add the following lines at the end of the file</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"> <b># begin custom</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b> include "<span style="color: #660000;"><>/Apache/modplsql/conf/plsql.conf</span>"</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b> # end custom</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">where <> is the explicit directory for the $IAS_ORACLE_HOME variable</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>*** Pay attention, this change will be remove after next autoconfig run</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">NOTE - on Microsoft platforms this will be located in a directory location similar to "DRIVE:\<ORACLE_BASE>\inst\apps\<CONTEXT_MACHINE>\ora\10.1.3\Apache\Apache\conf" For example "E:\oracle\inst\apps\VIS_TESTBOX\ora\10.1.3\Apache\Apache\conf\oracle_apache.conf"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">2. Update the $IAS_ORACLE_HOME/Apache/modplsql/conf/dads.conf file to add an appropriate entry for your Release 12 RDBMS</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">For Example</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> <Location <b><span style="color: #660000;">/pls/r12vis</span></b>></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> SetHandler pls_handler</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Order deny,allow</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Allow from all</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> AllowOverride None</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> PlsqlDatabaseUsername apps</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> PlsqlDatabasePassword <b> <span style="color: #660000;">apps</span></b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> PlsqlDatabaseConnectString <b><span style="color: #660000;">myRDBMSHost.domain.com:1521:VIS</span></b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> PlsqlDefaultPage fnd.web.ping</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> </Location></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">3. Use dadTool.pl to obfuscate the clear text passwords in the dads.conf file</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> perl dadTool.pl -o</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">4. Restart HTTP Server for these changes to take effect</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">5. You can then test your change by using the URL as below</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> http://myRel12Host.domain.com:PORT/pls/r12vis/fnd_web.ping</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Additional Note :</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Once implemented, you can only launch PLSQL directly via URL if the package/procedure is registered as trusted. To register PLSLQ processes or procedures you can go to System Admin Responsibility--> Security--> "Web PL/SQL" in which you can register your own PLSQL. </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Alternatively you can directly update the underlying table</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> insert into fnd_enabled_plsql values ('PROCEDURE', 'MY_PROCEDURE_NAME', 'Y', sysdate, 1, sysdate, 1, 1,'');</span><br />
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/--A4yCgsVUxA/UVfnJdvzTeI/AAAAAAAAAgQ/mY16eNuuilE/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/--A4yCgsVUxA/UVfnJdvzTeI/AAAAAAAAAgQ/mY16eNuuilE/s1600/my_vote.gif" /></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-54960464767777777392013-01-13T17:05:00.004+02:002013-02-27T10:33:17.086+02:00Hebrew data not shown correct in Oracle Reports with Text format<span style="font-family: Arial, Helvetica, sans-serif;">Hi All,</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the new issue that was found during the upgrade R11 to R12.1.3.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">After the upgrade all reports in Text format not show the Hebrew correct.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">The columns are right to left with data left to right.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Here the simple action plan to fix this issue - <b><span style="color: #660000;">VPASTA</span></b>!!!!</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">1. Log-in to Oracle Application > System Administrator > Install > Viewer Options </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">2. Add the following line:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">File Format: <b><span style="color: #660000;">Text</span></b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Mime Type: <span style="color: #660000;"><b>apps/bidi</b></span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Description: <b><span style="color: #660000;"> Pasta Viewer for bidi</span></b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><b><span style="color: #660000;"><br /></span></b></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-yK5OkunpCEs/UPLM2AybnTI/AAAAAAAAAd0/9DBN3EboTjM/s1600/VPasta1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="177" src="http://4.bp.blogspot.com/-yK5OkunpCEs/UPLM2AybnTI/AAAAAAAAAd0/9DBN3EboTjM/s400/VPasta1.JPG" width="400" /></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">3. Go to Profile > System and look for "Viewer: Application for Text:</span></div>
<div class="" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">4. Choose the <b style="color: #660000;">Pasta Viewer for bidi </b>in SITE level.</span></div>
<div class="" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-X1Xd-ygFiqg/UPLM2KNRu3I/AAAAAAAAAdw/T7CAdWMN30w/s1600/VPasta2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="176" src="http://3.bp.blogspot.com/-X1Xd-ygFiqg/UPLM2KNRu3I/AAAAAAAAAdw/T7CAdWMN30w/s400/VPasta2.JPG" width="400" /></a></div>
<div class="" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<span style="font-family: Arial, Helvetica, sans-serif;">5. Add the following lines to your custom*.env file or to .bash_profile / .profile</span><br />
<br />
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>TK_LOCALE="bidi"</b></span></div>
<div class="MsoNormal">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>export TK_LOCALE</b></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">6. Add the following lines to $FND_TOP/reports/<your_file>.prt</span></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">nls locale "arabic"</span></b></div>
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">nls datastorageorder "logical"</span></b></div>
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">nls contextuallayout "no"</span></b></div>
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">nls contextualshaping "yes</span></b></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">* You can find the needed <b><span style="color: #660000;">prt </span></b>file according the concurrent name and it's style</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">7. Re-login with appl user and restart concurrent manager.</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">$INST_TOP/admin/scrips/adcmctl.sh stop</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">$INST_TOP/admin/scrips/adcmctl.sh start</span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Oracle Notes:</span></div>
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">How to Setup EBS, VPasta, And Pasta for BIDI Languages [ID 839520.1]</span></b></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">HOW TO CONFIGURE PASTA FOR ARABIC? (Doc ID 816879.1)</span></b></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-XeKLamhikoo/UPLMM6hfYGI/AAAAAAAAAdo/Q7DtenvQrJQ/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" src="http://2.bp.blogspot.com/-XeKLamhikoo/UPLMM6hfYGI/AAAAAAAAAdo/Q7DtenvQrJQ/s1600/my_vote.gif" /></span></a></div>
<br />
<br />Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com1tag:blogger.com,1999:blog-2731794711719472397.post-82555127186437978702012-11-05T13:45:00.005+02:002012-11-05T13:51:56.331+02:00UPK to EBS 11i - Step By Step.<span style="font-family: Arial, Helvetica, sans-serif;">Hi All</span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Here the step by step guide how to connect the Oracle EBS 11i to use UPK help.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">1.<span class="Apple-tab-span" style="white-space: pre;"> </span>Create <b><span style="color: #660000;">$XX_TOP/upk</span></b> folder</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">2.<span class="Apple-tab-span" style="white-space: pre;"> </span>Create<span style="color: #660000;"><b> $XX_TOP/upk/XX</b></span> folder</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">3.<span class="Apple-tab-span" style="white-space: pre;"> </span>Create <span style="color: #660000;"><b>$XX_TOP/upk/conf</b></span> folder</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">4.<span class="Apple-tab-span" style="white-space: pre;"> </span>Edit the <b><span style="color: #660000;">CUSTOM.pll</span></b> file to start using UPK functionality:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Backup the CUSTOM.plx before installation.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Copy the attached ODPN.pll file to $AU_TOP/resource.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Compile the ODPN.pll using:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;">f60gen userid=apps/apps module=ODPN.pll module_type=LIBRARY </span> </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>make sure that the ODPN.plx was created.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Convert the CUSTOM.pll to text file (ECM_CUSTOM.pld)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;">f60gen userid=apps/apps module= CUSTOM.pll module_type=LIBRARY script=Ye</span>s</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Open the CUSTOM.pld</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Add the fillowing line at the begining of the file:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">.attach LIBRARY ODPN END NOCONFIRM</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">right after the last attached pll</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Add the following at the end of the Event procedure (before the line with "end event;"), save and close the file:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">/*************** UPK Module ****************************************/</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">gkod_event(event_name, 'SPECIAL20');</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">/*******************************************************************/</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Convert the ECM_CUSTOM.pld from text file to pll file (binary) using:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">f60gen userid=apps/apps module= CUSTOM.pld module_type=LIBRARY parse=Yes (make sure that the CUSTOM.pll was created).</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Compile the CUSTOM.pll using:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="color: #660000;">f60gen userid=apps/apps module= CUSTOM.pll module_type=LIBRARY</span> (make sure that the CUSTOM.plx was created).</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">5.<span class="Apple-tab-span" style="white-space: pre;"> </span>copy the content of directory - Create Requisition Publish\Publishing content\PlayerPackage to<span style="color: #660000;"><b> $XX_TOP/upk/XX</b></span> (or use windows shared directory).</span><br />
<span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">6.<span class="Apple-tab-span" style="white-space: pre;"> </span>Edit<span style="color: #660000;"><b> $IAS_ORACLE_HOME/Apache/Apache/conf/oracle_apache.conf</b></span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"># Begin customizations</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">include <span style="color: #660000;"><b>$XX_TOP/upk/conf/xx_upk.conf</b></span> "</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"># End customizations</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">(**** Need to enter full path)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">8.<span class="Apple-tab-span" style="white-space: pre;"> </span>Create $XX_TOP/upk/conf/xx_upk.conf</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Alias /upk/ “<span style="color: #660000;"><b>$XX_TOP/upk/</b></span>"</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><Location /upk/></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Order allow,deny</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"> Allow from all</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"></Location></span><br />
<b><span style="color: #660000; font-family: Arial, Helvetica, sans-serif;">(**** Need to enter full path)</span></b><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">9.<span class="Apple-tab-span" style="white-space: pre;"> </span>Login to Oracle Application and update Applications Help Web Agent profile with the following string:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">http://<hostname>:<port>/upk/XX/oracle/hemi/oracle_gateway.html?dbc=<span style="color: #660000;"><b>$FND_TOP/secure/</b></span><hostname_sidname>.dbc</span><br />
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>(**** Need to enter full path)</b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">10.<span class="Apple-tab-span" style="white-space: pre;"> </span>Restart Apache service</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">11.<span class="Apple-tab-span" style="white-space: pre;"> </span>Now you can use the UPK to EBS functionality from EBS help menu.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif; margin-left: 1em; margin-right: 1em;"><a href="http://3.bp.blogspot.com/-5lIlLXerweY/UJel29e78KI/AAAAAAAAAbw/qVPtm8lClSo/s1600/UPK1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="http://3.bp.blogspot.com/-5lIlLXerweY/UJel29e78KI/AAAAAAAAAbw/qVPtm8lClSo/s320/UPK1.JPG" width="320" /></a></span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Good Luck ...</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-ezTXPzX2O6s/UJemFjmPxyI/AAAAAAAAAb4/PkSO8n01e08/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-ezTXPzX2O6s/UJemFjmPxyI/AAAAAAAAAb4/PkSO8n01e08/s1600/my_vote.gif" /></a></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com0tag:blogger.com,1999:blog-2731794711719472397.post-16708617557088883452012-10-14T10:25:00.002+02:002012-10-14T10:27:16.202+02:00Discoverer 10g installation Guide - Step by Step<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Hi All</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Here the Step by Step guide for installation Discoverer 10g on Linux.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">1. Create an Linux user for your discoverer installation</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">2. Edit .bash_profile by adding ORACLE_HOME,TNS_ADMIN and TMP parameters</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">*** Pay attention, the TMP parameter need to be set before the starting Discoverer installation.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-_xqp6xMuQ2k/UHp2tHtMmgI/AAAAAAAAAZo/S9FcIsYAiOg/s1600/Disco1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="201" src="http://3.bp.blogspot.com/-_xqp6xMuQ2k/UHp2tHtMmgI/AAAAAAAAAZo/S9FcIsYAiOg/s320/Disco1.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif; margin-left: 1em; margin-right: 1em;"></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">3. Login with created discoverer user to Linux</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">4. Download and extract the Discoverer 10g installation on Linux server.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">(<b><span style="color: #660000;">as_linux_x86_bi_101202_disk1.cpio and as_linux_x86_bi_101202_disk2.cpio</span></b>)</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">To extract <b>*.cpio</b> files you can use the following command: <span style="color: #660000;"><b>cpio -idmv < file.cpio</b></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">5. Go to Disk1 folder and run : <span style="color: #660000; font-weight: bold;">./runInstaller -ignoreSysPrereqs</span> .</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">6. In Destination section give the Name and Path for ORACLE_HOME from the previous steps.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-7veWcxQkEiQ/UHplZn9F8YI/AAAAAAAAAW0/5hJAYXMYH0k/s1600/Disco2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://1.bp.blogspot.com/-7veWcxQkEiQ/UHplZn9F8YI/AAAAAAAAAW0/5hJAYXMYH0k/s320/Disco2.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">7. Next</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-Y1XyerABPQ4/UHplkm6eclI/AAAAAAAAAXE/yCPGqLWpZNY/s1600/Disco3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="249" src="http://2.bp.blogspot.com/-Y1XyerABPQ4/UHplkm6eclI/AAAAAAAAAXE/yCPGqLWpZNY/s320/Disco3.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">8. Next (need to fix any prerequisite issues if exists ).</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">9. Add the relevant languages --> Next.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-gkyWdh0lXAA/UHplpI-MqtI/AAAAAAAAAXM/zSqWM5DIePI/s1600/Disco4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://1.bp.blogspot.com/-gkyWdh0lXAA/UHplpI-MqtI/AAAAAAAAAXM/zSqWM5DIePI/s320/Disco4.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">10. Choose the automatic Port Configuration --> Next.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-8TqR75no4Vw/UHplrQOdKkI/AAAAAAAAAXU/Y21QxInB9nw/s1600/Disco5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://3.bp.blogspot.com/-8TqR75no4Vw/UHplrQOdKkI/AAAAAAAAAXU/Y21QxInB9nw/s320/Disco5.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">11. If you wan't to configure mail server you can leave it blank --> Next.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-xT24uSSPTTw/UHpltYBcNRI/AAAAAAAAAXc/-iPCQFVSVlc/s1600/Disco6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://2.bp.blogspot.com/-xT24uSSPTTw/UHpltYBcNRI/AAAAAAAAAXc/-iPCQFVSVlc/s320/Disco6.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">12. Specify name and password for ias_admin.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">*** Remember the password. It will be on use on Upgrade to <span style="background-color: white;"><span style="color: #660000;"><b>10.1.2.3 PATCH SET RELEASE.</b></span></span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-qAcvBnnFvK4/UHplvOy1U8I/AAAAAAAAAXk/gXGxSeXcaGQ/s1600/Disco7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="249" src="http://3.bp.blogspot.com/-qAcvBnnFvK4/UHplvOy1U8I/AAAAAAAAAXk/gXGxSeXcaGQ/s320/Disco7.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">13. Install</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-_t1XXl2aUKg/UHpl2vcEweI/AAAAAAAAAXs/3ftlFVw8070/s1600/Disco8.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://2.bp.blogspot.com/-_t1XXl2aUKg/UHpl2vcEweI/AAAAAAAAAXs/3ftlFVw8070/s320/Disco8.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-AqfSOjrGVyk/UHpl489Zb-I/AAAAAAAAAX0/rlDJm3pL-u8/s1600/Disco9.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="249" src="http://2.bp.blogspot.com/-AqfSOjrGVyk/UHpl489Zb-I/AAAAAAAAAX0/rlDJm3pL-u8/s320/Disco9.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">14. Run $ORACLE_HOME/root.sh with root user --> OK.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-pixkuyoA6UI/UHpl62QkqRI/AAAAAAAAAX8/jYEyWx8I6hA/s1600/Disco10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://1.bp.blogspot.com/-pixkuyoA6UI/UHpl62QkqRI/AAAAAAAAAX8/jYEyWx8I6hA/s320/Disco10.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Lt6nrNSlNK8/UHpl9P7RdKI/AAAAAAAAAYE/Esdb3QV-2KU/s1600/Disco11.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://1.bp.blogspot.com/-Lt6nrNSlNK8/UHpl9P7RdKI/AAAAAAAAAYE/Esdb3QV-2KU/s320/Disco11.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-FdkWNYlWclM/UHpmHZQ1mQI/AAAAAAAAAYM/2rBvo9OY4R4/s1600/Disco12.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://4.bp.blogspot.com/-FdkWNYlWclM/UHpmHZQ1mQI/AAAAAAAAAYM/2rBvo9OY4R4/s320/Disco12.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #660000;"><span style="background-color: white;"><b><span style="font-family: Arial, Helvetica, sans-serif;">Upgrade the discoverer to 10.1.2.3 </span></b></span><span style="font-family: Arial, Helvetica, sans-serif;"><b>PATCH SET</b></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Download and extract Patch <b><span style="color: #660000;">5983622</span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Go to Disk1 directory and run:</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>./runInstaller -ignoreSysPrereqs</b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">1.<b style="color: #660000;"> </b>Choose the existed Name from the previous installation --> Next.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-7veWcxQkEiQ/UHplZn9F8YI/AAAAAAAAAW0/5hJAYXMYH0k/s1600/Disco2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://1.bp.blogspot.com/-7veWcxQkEiQ/UHplZn9F8YI/AAAAAAAAAW0/5hJAYXMYH0k/s320/Disco2.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">2. Choose the <span style="color: #660000;"><b>Oracle Applicatio Server and Developer Site 10g Rel2 Software Upgrade</b></span> section. --> Next.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-04VvFVgAvvQ/UHpmJSUZn-I/AAAAAAAAAYU/ct6GDLhH2KA/s1600/Disco13.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="249" src="http://1.bp.blogspot.com/-04VvFVgAvvQ/UHpmJSUZn-I/AAAAAAAAAYU/ct6GDLhH2KA/s320/Disco13.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">3. Enter the <span style="color: #660000;"><b>ias_admin</b></span> password from the previous installation. --> Next.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-04VvFVgAvvQ/UHpmJSUZn-I/AAAAAAAAAYU/ct6GDLhH2KA/s1600/Disco13.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-TK20LS2AUAM/UHpmpi4ywiI/AAAAAAAAAYc/h9nA71-GIg8/s1600/Disco14.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="249" src="http://2.bp.blogspot.com/-TK20LS2AUAM/UHpmpi4ywiI/AAAAAAAAAYc/h9nA71-GIg8/s320/Disco14.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;">4. Install.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-gHPBxZQoxqQ/UHpmr6a6CjI/AAAAAAAAAYg/EwAmom8roWk/s1600/Disco15.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="251" src="http://4.bp.blogspot.com/-gHPBxZQoxqQ/UHpmr6a6CjI/AAAAAAAAAYg/EwAmom8roWk/s320/Disco15.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-cpZeKMo2iZk/UHpmuPGhccI/AAAAAAAAAYs/GFKLRcTFfC8/s1600/Disco16.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://4.bp.blogspot.com/-cpZeKMo2iZk/UHpmuPGhccI/AAAAAAAAAYs/GFKLRcTFfC8/s320/Disco16.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">5. Run $ORACLE_HOME/root.sh with root user --> OK.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-1jwLlmZcOtQ/UHpm66204AI/AAAAAAAAAY0/rt3w44Xyg7E/s1600/Disco17.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://2.bp.blogspot.com/-1jwLlmZcOtQ/UHpm66204AI/AAAAAAAAAY0/rt3w44Xyg7E/s320/Disco17.JPG" width="320" /></span></a></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-jEfRvhCNCd4/UHpm8x9i8kI/AAAAAAAAAY8/JX1cIkPrpPc/s1600/Disco18.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://1.bp.blogspot.com/-jEfRvhCNCd4/UHpm8x9i8kI/AAAAAAAAAY8/JX1cIkPrpPc/s320/Disco18.JPG" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">6. Exit.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-KS6s4JEHeLM/UHpm-5Z0xoI/AAAAAAAAAZE/A-hPM9R1UVg/s1600/Disco19.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif;"><img border="0" height="250" src="http://3.bp.blogspot.com/-KS6s4JEHeLM/UHpm-5Z0xoI/AAAAAAAAAZE/A-hPM9R1UVg/s320/Disco19.JPG" width="320" /></span></a></div>
<div style="text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>Install the latest Discoverer CP(cumulative patch).</b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">1. Download and extract the latest Discoverer CP (For example CP10 - Parch 11674847)</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">2. Go to <span style="color: #660000;"><b>11674847</b></span> folder</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">3. Run the following command for patch installation:</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #660000; font-family: Arial, Helvetica, sans-serif;"><b>$ORACLE_HOME/OPatch/opatch apply</b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">4. Go to $ORACLE_HOME/opmn/bin directory</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">5. <span style="color: #660000;"><b>./opmnctl stopall</b></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">6. <b><span style="color: #660000;">./opmnctl startall</span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">7. Update the <b><span style="color: #660000;">$TNS_ADMIN/tnsnames.ora</span></b> with instance tns names.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">8. Enter to Discoverer page (default: http:<hostname>:7777/)</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">Good Luck ...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif; margin-left: 1em; margin-right: 1em;"><a href="http://4.bp.blogspot.com/-4Th21X9VOPQ/UHp2ZVLWczI/AAAAAAAAAZg/Ccac2wvCXEE/s1600/my_vote.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-4Th21X9VOPQ/UHp2ZVLWczI/AAAAAAAAAZg/Ccac2wvCXEE/s1600/my_vote.gif" /></a></span></div>
Arty Boruliahttp://www.blogger.com/profile/10777456025511719021noreply@blogger.com1