Dicas ORACLE DBA

Tool to query patchset level. ftp:­/­/­ftp.­oracle.­com/­support/­outgoing/­PATCHSET_COMPARE­_TOOL/­patchsets.­sh

1. Modifying Port $GRID_HOME/bin/srvctl modify scan_listener -p 1522  (New scan listener Port) 2. Restart SCAN listener to effective new port: $GRID_HOME/bin/srvctl stop scan_listener $GRID_HOME/bin/srvctl start scan_listener 3. Verifying changes: $GRID_HOME/bin/srvctl config scan_listener Do not forget to check the local_listener database parameter!

JVM memory settings: create or replace function getMaxMemorySize return number is language java name 'oracle.aurora.vm.OracleRuntime.getMaxMemorySize() returns long'; / create or replace function getMaxRunspaceSize return number is language java name 'oracle.aurora.vm.OracleRuntime.getMaxRunspaceSize() returns long'; / create or replace function getMaxSessionSize return number is language java name 'oracle.aurora.vm.OracleRuntime.getMaxSessionSize() returns long'; / SQL> select getMaxMemorySize from dual; SQL> select getMaxSessionSize from dual; SQL> select getMaxRunspaceSize from dual; JVM usage: create or replace function getJavaStackSize return number is language java name 'oracle.aurora.vm.OracleRuntime.getJavaStackSize() returns long'; / create or replace function getJavaPoolSize return number is language java name 'oracle.aurora.vm.OracleRuntime.getJavaPoolSize() returns long'; / SQL> select getJavaStackS...

Log Message in emagent.trc 2012-05-23 14:40:29 Thread-4111846288 ERROR ssl: nmehlenv_openWallet failed 2012-05-23 14:40:29 Thread-4111846288 ERROR http: 15: Unable to initialize ssl connection with server, aborting connection attempt 2012-05-23 14:40:29 Thread-4111846288 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://hostname.com:1158/em/upload/: retStatus=-1 2012-05-23 14:40:29 Thread-4111846288 ERROR ssl: Open wallet failed, ret = 28750 Apply Patch: https://updates.oracle.com/download/8350262.html After apply patch: $ emctl secure dbconsole -reset $emctl start dbconsole

-- Create User DECLARE l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER := fnd_global.user_id; x_user_id NUMBER; l_password VARCHAR2 (2000) := ' password '; BEGIN apps.hr_user_acct_internal.create_fnd_user (p_user_name => ' denilson ', p_password => l_password, p_employee_id => NULL, p_user_id => x_user_id, p_user_start_date => SYSDATE, p_email_address => NULL, p_description => NULL, p_password_date => NULL ); DBMS_OUTPUT.put_line (x_user_id); COMMIT; END IF; END; Add "System Administrator" responsibility to User BEGIN fnd_user_pkg.addresp (username => UPPER ('DENILSON'), resp_app => 'SYSADMIN', resp_key => 'SYSTEM_ADMINISTRATOR', security_group => 'STANDARD', description => 'DESCRIPTION', start_date => SYSDATE, end_date => NULL ); COMMIT; DBMS_OUTPUT.put_line ('Responsibility Added Successfully'); EXCEPTION W...