Help 2 Oracle

Welcome to help2ora.com Tips, tutorials, procedures The system appears to be running very slowly and defunct processes can appear. AUTO MEM: PGA getfail 13 for 38, 11, 1, 67108864, 13555990528, 2550136832, 38, 16106127360, 2 ASLR is a feature that is activated by default on some of the newer linux distributions. It is designed to load shared memory... objects in random addresses. In Oracle, multiple processes map a shared memory object at the same address across the processes. With ASLR turned on Oracle cannot guarantee the availability of this shared memory address. This conflict in the address space means that a process trying to attach a shared memory object to a specific address may not be able to do so, resulting in a failure in shmat subroutine. However, on subsequent retry (using a new process) the shared memory attachment may work. The result is a random set of failures in the alert log. You can verify whether ASLR is being used as follows: If the parameter is set to any value other than 0 then ASLR is in use. On Redhat 5 to permanently disable ASLR: You need to reboot for kernel.exec-shield parameter to take effect. Note that both kernel parameters are required for ASLR to be switched off. There may be other reasons for a process failing to start, however, by switching ASLR off, you can quickly discount ASLR being the problem. More and more issues are being identified when ASLR is in operation. First of all you need create one user (schema to test), in this example the user is scott and the language example is PORTUGUESE. GRANT EXECUTE ON CTXSYS.CTX_ADM TO SCOTT; GRANT EXECUTE ON CTXSYS.CTX_CLS TO SCOTT; GRANT EXECUTE ON CTXSYS.CTX_DDL TO SCOTT; GRANT EXECUTE ON CTXSYS.CTX_OUTPUT TO SCOTT; BEGIN ctx_ddl.create_preference ('SCOTT_LEXER', 'BASIC_LEXER'); ctx_ddl.set_attribute ('SCOTT_LEXER', 'base_letter', 'YES'); ctx_ddl.set_attribute('SCOTT_LEXER', 'printjoins', '_-'); ctx_ddl.set_attribute('SCOTT_LEXER', 'base_letter_type', 'GENERIC'); ctx_ddl.set_attribute ('SCOTT_LEXER', 'index_themes', 'NO'); ...Read More