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
Tuesday, June 24, 2008
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.
the Oracle Applications Authentication mode is defined in the the Applications context file:
$APPL_TOP/admin/
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;
/
------------------------------------------------------------------------------
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....
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....
Subscribe to:
Posts (Atom)