Pular para o conteúdo principal

Postagens

Mostrando postagens de 2012

BEA-000449

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.

Modify Scan Listener Port

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!

Memory settings and usage of the Database Java VM

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

SSL Error ret = 28750 DBCONSOLE 10.2.0.4 or 10.2.0.5

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

Creating EBS User and add System Administrator Reponsibility with PL/SQL

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

Rman Slow Performance on Exit

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.

Quem está usando dblink?

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 x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w  where g.K2GTDXCB = t.ktcxbxba    and g.K2GTDSES = t.ktcxbses    and s.addr = g.K2GTDSES    and w.sid = s.indx;

How to find candidate indexes to rebuild?

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

Database startup on Solaris 10 fails with ORA-27102

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'

Dbms_stats: Gather_stats_job encountered errors ORA-20011 ORA-29913 and KUP-11024

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