kewastUnPackStats(): bad magic 1 (0x2b7d38d08c06, 0) on alert.log

kewastUnPackStats(): bad magic 1 (0x2b7d38d08c06, 0) warning on 11gr2 database's alert.log.


This is a bug which is documented in bug no: 8730312


patch 8730312 is available for 11.2.0.1

Useful apps DBA scripts

• Who is connected, when

sql> select user_name,to_char(last_logon_date,’DD-MON-YYYY HH24:MI:SS’)
from apps.fnd_user
where to_char(last_logon_date,’DD-MON-YYYY’)=to_char(sysdate,’DD-MON-YYYY’);

• Which resposibility is used

sql> select distinct fu.user_name User_Name,fr.RESPONSIBILITY_KEY Responsibility from fnd_user fu,
fnd_responsibility fr, icx_sessions ic
where fu.user_id = ic.user_id AND
fr.responsibility_id = ic.responsibility_id AND
ic.disabled_flag=’N’ AND
ic.responsibility_id is not null AND
ic.last_connect like sysdate;

• Number of user connected to EBS

sql> SELECT COUNT (DISTINCT d.user_name)
FROM apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d
WHERE     b.paddr = c.addr
AND a.pid = c.pid
AND a.spid = b.process
AND d.user_id = a.user_id
AND (d.user_name = ‘USER_NAME’ OR 1 = 1)

• EBS gather stats

sql> execute fnd_stats.gather_table_stats(‘AR’,'RA_CUSTOMER_TRX_ALL’);

• CUSTOM.pll compile: (copy CUSTOM pll under $AU_TOP/resource and compile)

f60gen CUSTOM.pll apps/apps_password module_type=LIBRARY compile_all=YES

• How to change apps password on 11i

• Shutdown all apps services on all nodes.

• Backup these tables                             

                         sql>    create table xxx_fnd_user as select * from FND_USER

                         sql>    create table xxx_FND_ORACLE_USERID asselect * from FND_ORACLE_USERID

• Connect as apps user on sqlplus and run:

                          $ FNDCPASS apps/apps_old 0 Y system/password SYSTEM APPLSYS apps_new

• Edit passwords in these files on all nodes:

                         $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

                        $ORACLE_HOME/reports60/server/CGIcmd.dat

• How to change module passwords on 11i

$ FNDCPASS apps/apps_password 0 Y system/system_password ORACLE AR new_password

table import with Oracle SQL Loader (sqlldr)

Samlpe sql loader command:

sample 1:

sqlldr \'SYS/password AS SYSDBA\' control=/data1/dump/control2.ctl log=/data1/dump/test2.log

sample 2:

sqlldr userid=xxx/xxx control=/data01/DEV/control.ctl log=/data01/DEV/test.log

control file content:

OPTIONS (SKIP=0)

LOAD DATA

INFILE "/data1/dump/XXX_TABLE_NAME.txt"

BADFILE "/data1/dump/aaa.bad"

DISCARDFILE "/data1/dump/aaa.dsc"

TRUNCATE

INTO TABLE "XXX"."TABLE_NAME"

FIELDS TERMINATED BY "|"

trailing nullcols

(

SOURCE_SYSTEM_KEY CHAR(4000),

NAME_SURNAME CHAR(4000),

WORK_TEL CHAR(4000),

MOBILE_TEL CHAR(4000),

EMAIL CHAR(4000),

STATE CHAR(4000),

CITY CHAR(4000),

SSN CHAR(4000),

SSN2 CHAR(4000),

SEX CHAR(4000),

DATE_OF_BIRTH CHAR(4000),

NOTES CHAR(4000),

ADRESS CHAR(4000),

SOURCE_SYSTEM2 CHAR(200)

)