SQL Server Database in Suspect Mode
SQL server issue and solution Error Summary: Suspect is a state where database becomes inaccessible due to different reasons. These are the few reasons why the database will go to…
Read MoreAdcfgclone Fails while instantiating OHS Config
Below was the detailed error found on /u01/TEST/R12apps/fs2/inst/apps/TEST_Mars/admin/log/clone/patch/txkSetOHSConfig_01567873/provision_01567873.log Error : ======= Connecting Run file system WLS domain using t3://Mars.Jayan.int:7006 WARNING: Run file system MBeanServerConnection is invalid Looks like Run file…
Read MoreUnable 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 More