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...

I found this bug several times using version 10.2.0.2 until 10.2.0.5, i used to solve it just by changing the optimizer mode to RULE in the RMAN session. Solution: sql "alter session set optimizer_mode=RULE"; Execute your RMAN backup scripts.

Select /*+ ORDERED */  substr(s.ksusemnm, 1, 10) || '-' || substr(s.ksusepid, 1, 10) "ORIGIN",  substr(g.K2GTITID_ORA, 1, 35) "GTXID",  substr(s.indx, 1, 4) || '.' || substr(s.ksuseser, 1, 5) "LSESSION",  substr(decode(bitand(ksuseidl, 11),                1,                'ACTIVE',                0,                decode(bitand(ksuseflg, 4096), 0, 'INACTIVE', 'CACHED'),                2,                'SNIPED',                3,                'SNIPED',                'KILLED'),         1,         1) "S",  substr(event, 1, 10) "WAITING"   from ...