Dicas ORACLE DBA

https://blogs.oracle.com/supportportal/entry/use_of_wget_instead_of_downloa

cd $MW_HOME/Oracle_WT1/instances/instance1/bin ./opmnctl registerinstance -adminHost weblogic_host -adminPort 7001 -adminUsername weblogic

1. log-in to Admin Server  Console 2. In left pane of console, expand Environment and select Servers. 3. On the Summary of Servers page,select Managed Server instance i.e EMGC_OMS1 4. To enable tunneling of connections,       On the Protocols > General tab: Check Enable tunneling.       Click Save.

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

set linesize 300 set serveroutput on size 100000 set feedback off set timing on set term off set head off spool rebuild.log begin dbms_output.enable('9999999'); for rIndex in (select s.owner,s.segment_name,sum(s.bytes/1024/1024) from dba_segments s , dba_indexes i where s.segment_type = 'INDEX' and s.segment_name = i.index_name and s.owner = i.owner and i.index_type = 'NORMAL' and s.owner not in ('SYS','SYSTEM','SYSMAN','SYSAUX','APPLSYS') group by s.owner,s.segment_name having sum(bytes/1024/1024) > 100) loop execute immediate 'analyze index '||rIndex.owner||'.'||rIndex.segment_name||' validate structure'; end loop; dbms_output.put_line('--- Reorganizando os indices ---'); for rRebuild in(SELECT name, height, lf_rows, owner FROM INDEX_STATS st, dba_indexes di where st.name = di.index_name) loop execute immediate 'alter index '||rRebuild.owner||'....

Error: SQL> startup ORA-27102: out of memory SVR4 Error: 22: Invalid argument And the alert log shows something similar to the following. WARNING: EINVAL creating segment of size 0x000000002a000000 fix shm parameters in /etc/system or equivalent Solution: For example, a sample /etc/system entry setting SHMMAX = 6GB. set shmsys:shminfo_shmmax=6442450944 (6*1024*1024*1024) set semsys:seminfo_semmni=1024 set semsys:seminfo_semmsl=1024 set shmsys:shminfo_shmmni=100 (see note id:  169706.1 for solaris requeriments ) Database started with above settings ok, and missing project settings in this case were the following. 1. # projadd -c "Oracle" 'user.oracle' 2. # projmod -s -K "project.max-shm-memory=(privileged,6GB,deny)" 'user.oracle'

Drop datapump external tables: select OWNER,OBJECT_NAME,OBJECT_TYPE, status, to_char(CREATED,'dd-mon-yyyy hh24:mi:ss') created ,to_char(LAST_DDL_TIME , 'dd-mon-yyyy hh24:mi:ss') last_ddl_time from dba_objects where object_name like 'ET$%' / select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE from dba_external_tables order by 1,2 / Doc. ID:  1274653.1