Tuesday, June 24, 2008

arabic report imp doc ids

arabic Appears As Question Marks In Reports -----key link---- Doc ID: Note:199429.1 Type: PROBLEM

9iAS: Arabic Characters Displayed Question Marks Doc ID: Note:208901.1 Type: PROBLEM
Difference between AR8MSWIN1256 and AR8ISO8859P6 characterset Doc ID: Note:260023.1 Type: BULLETIN

Question Marks (?) in Diagrammers and RON when using Arabic NLS Doc ID: Note:108973.1 Type: PROBLEM

Printing and Previewing Arabic Reports using PASTA in Oracle Applications 11i Doc ID: Note:179801.1 Type: HOWTO

Subject: How To Print Arabic Reports in PDF Format? Doc ID: Note:430774.1 Type: HOWTO

cannot connect 11i using Discoverer/ADI/TOAD

Problem cannot login through applications user using ADI/Discoverer/TOAD :

the Oracle Applications Authentication mode is defined in the the Applications context file:
$APPL_TOP/admin/_.xml context file

Look for the following context variable: s_appserverid_authentication
By default, in E-Business Suite 11.5.10, this is set to SECURE. In previous E-Business Suite 11i versions, this was set to OFF.There are 3 Modes of authentication:

* ON : Partial
* SECURE : activates full server security (SECURE mode)
* OFF : deactivates server security

As a workaround, you may set this to OFF from the default of SECURE.Run Autoconfig to instantiate the changes.
Now you should be able to access E-Business Suite 11.5.10 databases using Discoverer/ADI/TOAD.

enable all disabled triggers in 11i

query to see how many trigger disabled

select count(*)from dba_triggerswhere status = 'DISABLED' and owner !='SYS';


run this script as trig.sql as sysdba

--------------------------------------------------


set serveroutput on size 1000000set verify offset serveroutput on
DECLAREsql_cmd varchar2(1024);
cursor cur_record isselect distinct OWNER,TRIGGER_NAMEfrom dba_triggerswhere status = 'DISABLED' and owner!='SYS';
trig_rec cur_record%ROWTYPE;
BEGINDBMS_OUTPUT.PUT_LINE('START OF PROGRAM');
FOR trig_rec IN cur_record LOOP
BEGINsql_cmd := 'alter trigger 'trig_rec.owner'."'trig_rec.trigger_name'" enable ';
EXECUTE IMMEDIATE sql_cmd;
DBMS_OUTPUT.PUT_LINE('Enabled : 'trig_rec.owner'.'trig_rec.trigger_name);
EXCEPTION WHEN others THENdbms_output.put_line('Error : 'trig_rec.owner'.'trig_rec.trigger_name);dbms_output.put_line(SQLERRM);END;
END LOOP;
DBMS_OUTPUT.PUT_LINE('END OF PROGRAM');
END;
/



------------------------------------------------------------------------------

Monday, November 5, 2007

Reverse Proxy

Reverse proxy is an intermediate server that sits between a client and the actual web server and makes requests to the web server on behalf of the client.
It is generally used when configuring DMZ with Oracle applications. If it is properly configured it enhances the security level.

More post on this is on the way....