Unable to see roles & responsibilities on EBS Home Page
My user name which not synced is “JASON” There are two methods to synchronize user data. First Method : This one is our usual method , which will be done…
Read MoreError: Transaction Log File is full at the primary Replica of the Always on Availability Group.
SQL server issue and solution Error Summary: Assume we receive 9002 error message when trying to execute a new query on one of the Always on Availability Group Databases. Reason…
Read MoreERROR:26(A network-related or instance-specific error occurred while establishing a connection to SQL Server.)
SQL server issue and solution Error summary: The users might often see the error “SQL Network Interfaces, error:26- Error Locating server/Instance Specified” This error message may prompt while connecting to…
Read MoreLoading and unloading java Jar in to database
1.For Loading jar use cmd loadjava -force -genmissing -r -user username/password@servicename -verbose jar 2.For droping jar use cmd dropjava -f -verbose -u username/password@servicename -schema schmeaname jar Jar…
Read MoreFind the session which generates more archive log
Query: select s.sid,sn.SERIAL#,n.name, round(value/1024/1024,2) redo_mb, sn.username,sn.status,substr (sn.code1,1,21) “code”, sn.type, sn.module,sn.sql_id from v$sesstat s join v$statname n on n.statistic# = s.statistic# join v$session sn on sn.sid = s.sid where n.name…
Read MoreQuery to find how many chained (and migrated) rows each table has
Query: SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0; SELECT owner_name,table_name,count(head_rowid) row_countFROM chained_rows GROUP BY owner_name,table_name
Read MoreHow to Recompile Invalid Schema Objects
When we are doing the operations like upgrades, patches, and DDL changes the associated schema objects will get invalid. So it is difficult to recompile all the user objects one…
Read MoreTablespace Level Fragmentation — Defragmentation/Shrink A Big Tablespace In Oracle
The most efficient/effective way to defrag/shrink a big tablespace in oracle is to migrate the tables/indexes to new tablespaces. Here below are the steps: Step 1. find tablespace “BMW” whether…
Read MoreHow To PLAY_SOUND in Oracle Forms
Introduction Play sound is used to play audio files in Oracle Forms, Play Sound plays the sound object in the specified sound item PLAY_SOUND examples The following plsql block you…
Read MoreError: resource-env-ref,CDI Container and disable policy
org.apache.cxf.jaxws.context.WebServiceContextResourceResolver/bus’ declared in the standard descriptor or annotation has no JNDI name mapped to it. The resource-env-ref must be mapped to a JNDI name using the resource-env-description element of the…
Read More