Dicas ORACLE DBA

Change number of days to view in "Find Requests" (FNDRSRUN): alter value from profile: FND: Default Request Days

Query installed package: $rpm -qa glibc glibc-2.5-24 glibc-2.5-24 Query installed package with version and plataform: $rpm -qa --queryformat "|%{NAME}|%{VERSION}|%{RELEASE}|%{ARCH}|\n" glibc |glibc|2.5|24|x86_64| |glibc|2.5|24|i686|

Error: httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory As root create a symbolic link: ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2 Reference: Oracle Application Server 10g (10.1.2) Installation Requirements for Linux OEL 5 and RHEL 5 [ID 564174.1]

APPLICATION 1. as the APPLMGR user source the environment file: $. /u01/visappl/APPSORA.env 2. Create appsutil.zip file $perl $AD_TOP/bin/admkappsutil.pl Starting the generation of appsutil.zip Log file located at /u01/visappl/admin/log/MakeAppsUtil_05072343.log output located at /u01/visappl/admin/out/appsutil.zip MakeAppsUtil completed successfully. 3. Copy the appsutil.zip to Database ORACLE_HOME DATABASE -- Clear nodes EXEC FND_CONC_CLONE.SETUP_CLEAN; COMMIT; EXIT; $export TNS_ADMIN=$ORACLE_HOME/network/admin/ $ hostname rac1 1. Generate your Database Context File $ perl adbldxml.pl appsuser=apps appspass=oracle Starting context file generation for db tier.. Using JVM from /u01/app/oracle/product/11.2.0/db_1/jdk/jre/bin/java to execute java programs.. The log file for this adbldxml session is located at: /u01/app/oracle/product/11.2.0/db_1/appsutil/log/adbldxml_06151633.log Could not Connect to the Database with the above parameters, Please answer the Questions below Enter Hos...

BEGIN DBMS_ADVISOR.quick_tune( advisor_name => DBMS_ADVISOR.SQLACCESS_ADVISOR, task_name => 'test_tune', attr1 => 'SELECT SUM(TRANSACTION_QUANTITY) / :B5 * -1 FROM MTL_MATERIAL_TRANSACTIONS MMT, (SELECT TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID FROM MTL_TRANSACTION_TYPES WHERE ATTRIBUTE1 IN (''CONSUMO'')) MTT WHERE MMT.TRANSACTION_QUANTITY < 0 AND MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID AND MMT.TRANSACTION_ACTION_ID = MTT.TRANSACTION_ACTION_ID AND MMT.TRANSACTION_SOURCE_TYPE_ID = MTT.TRANSACTION_SOURCE_TYPE_ID AND TRUNC(MMT.TRANSACTION_DATE, ''MONTH'') >= :B4 AND TRUNC(MMT.TRANSACTION_DATE, ''MONTH'') <= :B3 AND MMT.ORGANIZATION_ID = :B2 AND MMT.INVENTORY_ITEM_ID = :B1 '); END; / Query output advisor: SET LONG 100000 SET PAGESIZE 50000 SELECT DBMS_ADVISOR.get_task_...

R12: http://ebs.company.com:8000/forms/frmservlet 11.5.10 http://ebs.company.com:8000/dev60cgi/f60cgi In R12 version is necessary change the variable " s_appserverid_authentication " value to OFF in Context File and run autoconfig . This value (OFF) is already the default in version 11.5.10 . OFF - Server security is not checked. Any application server machine can access the database. Code IDs are also not checked. Use this option on test systems or if you have full control over the software on all machines which can physically access your database. ON - Some level of trust is required to access the database. Either the application server must be registered with the database or the code must pass a module and version ID known to be trusted. Use this option only if you wish to maintain compatibility with application servers that you cannot yet patch to the code level required for best security. SECURE - Full trust is required for access to the database. Only regi...

http://blogs.oracle.com/stevenChan/resource/certifications.html

This example sends 100 concurrents " ACTIVE USERS" for testing. DECLARE G_APPLICATION_ID NUMBER; G_APPLICATION_NAME VARCHAR2(250); G_APPLICATION_SHORT_NAME VARCHAR2(10) := 'FND'; G_RESP_ID NUMBER; G_USER_ID NUMBER; G_USER_NAME VARCHAR2(400); V_REQUEST_ID NUMBER; BEGIN SELECT FA.APPLICATION_ID, FAT.APPLICATION_NAME INTO G_APPLICATION_ID, G_APPLICATION_NAME FROM FND_APPLICATION_TL FAT, FND_APPLICATION FA WHERE FAT.APPLICATION_ID = FA.APPLICATION_ID AND FAT.LANGUAGE = 'US' AND FA.APPLICATION_SHORT_NAME = G_APPLICATION_SHORT_NAME; G_USER_ID := 0; G_USER_NAME := 'SYSADMIN'; BEGIN SELECT RESPONSIBILITY_ID INTO G_RESP_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_KEY = 'SYSTEM_ADMINISTRATOR'; EXCEPTION WHEN OTHERS THEN G_RESP_ID := -1; END; FND_GLOBAL.APPS_INITIALIZE(G_USER_ID, G_RESP_ID, 1); DBMS_SESSION.SET_NLS('NLS_TERRITORY',...

Configure Hardware load-balance EBS R12 Load Balancer Entry Point: ebs.company.com Application Server 1: apps1.company.com Application Server 2: apps2.company.com Application Server 3: apps3.company.com Application Server 4: apps4.company.com Web Entry protocol: https Application Tier Web Protocol: http Application Tier Web Port: 8000 Active Web Port:443 Change the context values in all ebs nodes : Context Variable Name Context Variable Description Value s_webentryurlprotocol Protocol that desktop clients use to communicate with the web entry point server https s_webentryhost Name of the host that receives the first HTTP request from the desktop client ebs s_webentrydomain Domain name of the host that receives the first HTTP request from the desktop client company.com s_active_webport Port on the web server or load balancer that listens for HTTP reques...