Posts by Marimuthu Pandu

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

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

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

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

weblogic error ‘could not get the server file lock’

Down the Admin server console Clear AdminServer.lok file from tmp foleder under Admin server

Read More

The Store Record X Could Not Be Found

Shutdown manage servers and Admin server, clear below extension file on under domain home. Clear temp and cache of manage and admin servers   find . -name “*.DAT” -print find…

Read More

Schema validation errors while parsing /Weblogic/Admin/config/config.xml

While starting weblogic aAdmin server getting error as below Schema validation errors while parsing /Weblogic/Oracle/Admin/config/config.xml – Expected elements ‘administration-protocol@http://xmlns.oracle.com/weblogic/domain wldf-system-resource   Solution: set JAVA_OPTIONS=%JAVA_OPTIONS% -Dweblogic.configuration.schemaValidationEnabled=false

Read More

Script to see all lock objects

set term on; set lines 130; column sid_ser format a12 heading 'session,|serial#'; column username format a12 heading 'os user/|db user'; column process format a9 heading 'os|process'; column spid format a7…

Read More

DBA_HIST_SEG_STAT become invalid

Unpublished Base Bug 3603160 has been fixed in the patchset 10.2.0.3.0 For version 10.1.0.4 and version 10.1.0.5 oneoff patches exists for some platforms. Below is a list of available onoff…

Read More

Install oracle client via yum

CMD for Installation.   yum -y -q install oracle-instantclient18.3-basic.x86_64.

Read More