前几天在从网上下了《颐和园》，因为是禁片，所以才很有兴趣把它看完，我自认为是看懂了导演想表达的意思，虽然我不是那个年代的人，但我大概能明白他们的痛苦；希望有一天导演可以不需要再用这么复杂的表现手法来说那段历史；

项目需要所以安装了SAP Best Practices,按照下图准备系统;

再按照如下步骤激活系统配置;

进入新公司在长安呆了数天便飞到了北京,突然的气温变化，真是让人受不了; 北京的气温虽然很低,但人文环境比广东要好;

这边的项目估计要下个月才会开始，我最近的任务就是做硬件方案,集成商评估,数据库和软件早就买了，SAP under DB2,

第一次基于DB2+LINUX安装SAP,不过还算是顺利，花了两三天时间装好了第一套IDES的系统;

只是希望今年过年前就能离开北京，因为北京的冬天太可怕了!!!

When I open the database after apply patch 10.2.0.2:

SQL> startup open;

ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced

I find the error log from $ORACLE_HOME/saptrace/alertPRD.log

Errors in file /oracle/PRD/saptrace/usertrace/prd_ora_22379.trc: ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Thu Dec 25 09:34:45 2008 Error 704 happened during db open, shutting down database

Solution:

SQL> STARTUP UPGRADE
SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql

Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended. 
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

ECC 6.0 Install on Solaris X86 64bit PC

Hard Env:

CPU: Intel Duol Core E2200

Memory: 4GB DDR

Harddisk: 500GB

Software Env:

OS: Solaris 10 u4 x86

MySAP erp 2005 sr2 (ECC 6.0)

Database: Oracle 10.2.0.2 (For Solaris X86 64bit)

JDK: Sun j2sdk 1.4.2_13 for Solaris for x86

CPU Check Result:

bash-3.00# isainfo -v
64-bit amd64 applications
cx16 mon sse3 sse2 sse fxsr mmx cmov amd_sysc cx8 tsc fpu
32-bit i386 applications
cx16 mon sse3 sse2 sse fxsr mmx cmov sep cx8 tsc fpu

Issue :

bash-3.00# ./sapinst
[==============================] / extracting... done!

Starting GuiServer using:
/usr/j2se/bin/java -cp /tmp/sapinst_exe.947.1230119416/JAR/instgui.jar:/tmp/sapinst_exe.947.1230119416/JAR/inqmyxml.jar -Djava.security.egd=file:/dev/urandom SDTServer config=jar:sdtserver.xml guiport=21212 sapinsthost=localhost sapinstport=21200 guistart=true

load resource pool /instcd/master/IM_SOLARIS_X86_64/resourcepool.xml

guiengine: no GUI connected; waiting for a connection on host recovery, port 21200 to continue with the installation

guiengine: login in process.
iauxsysex.c:317: child /tmp/sapinst_exe.947.1230119416/sapinst (pid 948) has crashed. Executable directory is /tmp/sapinst_exe.947.1230119416. Contact Support.
iaextract.c:814: child has signaled an exec error. Keeping directory /tmp/sapinst_exe.947.1230119416
bash-3.00# ls

Solution :

SAP for Solaris 10 on x64 requires at least Solaris 10 Update 1 (= Solaris 10 1/06).

Operating system patches recommended for Solaris 10 on x64
127112-05 SunOS 5.10_x86: kernel patch
120069-03 SunOS 5.10_x86: in.telnetd patch
119964-05 SunOS 5.10_x86: Shared library patch for C++_x86
120754-02 SunOS 5.10_x86: Microtasking libraries (libmtsk) patch
122033-04 SunOS 5.10_x86: Update timezones patch

在SAP 中使用DB13安排系统后台任务时，有Check and update optimizer statistics这样一个任务，SAP的NOTE上推荐是一个星期执行一次（note:132861）;

实际上这个就是ORACLE的CBO（Cost Based Optimizer基于成本的优化器），使用SQL语句：select job_name,program_name,last_start_date,next_run_date,comments from dba_scheduler_jobs;可以查询到ORACLE本身对这个任务的定义，许多朋友说但在Oracle 10.2.0.2和10.2.0.3的版本上这个JOB自动执行都会有些问题，所以还是不要用Oracle自动的模式，从SAP的DB13中就可以定义这个任务；这对整个系统的性能会有很大的帮助；

进入事务代码DB14，再选择Function IDs查询sta的结果，就是这个Update optimizer statistics的执行纪录；

When I import BASIS support package SAPKB70015&SAPKB70016 together,meet the error "Runtime Error UNCAUGHT_EXCEPTION"

"Exception CX_SFW_EXISTENCE";

Error analysis
An exception occurred that is explained in detail below.
The exception, which is assigned to class 'CX_SFW_EXISTENCE', was not caught in
procedure "INIT" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated that the
exception would occur, the current program is terminated.
The reason for the exception is:
Object SFBS EA-DFP does not exist

Solution:

please refer sap note 1160050.

create the report used Transaction SE38 and execute it.

REPORT ZBFSDEL.
tables:
sfw_bs,
sfw_active_b1.
* if Parameter Start = 'X' delete entry
parameters: start type char1.
* Delete entry from table sfw_bs
select * from sfw_bs where bset = 'EA-DFP'.
if sy-subrc is initial and start = 'X'.
delete from sfw_bs where bset = 'EA-DFP'.
if sy-subrc is initial.
write:/ 'Business Function Set EA-DFP deleted'.
endif.
endif.
endselect.
* Delete entry from table sfw_active_b1
select * from sfw_active_b1 where bset = 'EA-DFP'.
if sy-subrc is initial and start = 'X'.
delete from sfw_active_b1 where bset = 'EA-DFP'.
if sy-subrc is initial.
write:/ 'Active Business Function Set EA-DFP deleted'.
endif.
endif.
endselect.

HD Env: SUN SPARC 64bit

DB Env: Oracle 10.2.0.2

Message in alertPRD.log

ORA-00600: internal error code, arguments: [kdtdelrow-2], [208], [208], [], [], [], [], []

Errors in file /oracle/PRD/saptrace/usertrace/prd_ora_2248.trc:

Solve solution:

Refer SAP Note: 1001930 - ORA-600 [kcbnew_3] / [KCBZ_CHECK_OBJD_TYP_3] / [kdtdelrow-2]

The solution to Oracle Bug 5376783 is contained in the kts mergefix 5667736.

See SAPNet Note 1002062 for information on the availability of patches.

This week,I had a training about SAP BASIS,following is the course list;

ADM100 SAP Web AS Administration I;

ADM102 SAP Web AS Administration Ⅱ;

ADM505 Database Administration Oracle I;

ADM506 Database Administration Oracle II;

Last weekend,I installed the DR system, There is a SAP DEV system on this server exsit already;

Hard env: SUN M4000 CPU:4*4 Memory:32GB

OS env: Solaris 64bit on SPARC

Oracle Version: 10g Realse 2

SAP Version: MySAP ERP 2005 SR2

The two system used different file system;(e.g. /sapmnt;/usr/sap;/usr/sap/trans;/oracle),and there are used different resource control item;

DR system was installed all right;Then I umount the file system for DR system, and mount the file system for DEV system,and startup ORACLE and SAP DEV system;

At this time, I cannot logon to the DEV system;By many try hard, at last,used the tool("sappfpar check") check the profile,and modify the wrong parameter,and the problem was solved;following is the result for SAPPFPAR:

erpdev:devadm 19% sappfpar check pf=DEV_DVEBMGS06_erpdev


================================================================================
== Checking profile: DEV_DVEBMGS06_erpdev
================================================================================



***WARNING: Unexpected parameter: j2ee/dbhost =erpdev
***WARNING: Unexpected parameter: j2ee/dbname =DEV
***WARNING: Unexpected parameter: j2ee/dbtype =ora
***WARNING: Unexpected parameter: jstartup/vm/home =/usr/j2se

***ERROR: Size of shared memory pool 10 too small
================================================================
SOLUTIONS: (1) Locate shared memory segments outside of pool 10
with parameters like: ipc/shm_psize_<key> =0

SOLUTION: Increase size of shared memory pool 10
with parameter: ipc/shm_psize_10 =178000000

***ERROR: Size of shared memory pool 40 too small
================================================================
SOLUTIONS: (1) Locate shared memory segments outside of pool 40
with parameters like: ipc/shm_psize_<key> =0

SOLUTION: Increase size of shared memory pool 40
with parameter: ipc/shm_psize_40 =238000000

Shared memory disposition overview
================================================================
Shared memory pools
Key: 10 Pool
Size configured.....: 124000000 ( 118.3 MB)
Size min. estimated.: 175451010 ( 167.3 MB)
Advised Size........: 178000000 ( 169.8 MB)

Key: 40 Pool for database buffers
Size configured.....: 224000000 ( 213.6 MB)
Size min. estimated.: 235055040 ( 224.2 MB)
Advised Size........: 238000000 ( 227.0 MB)

Shared memories inside of pool 10
Key: 11 Size: 500000 ( 0.5 MB) Factory calender buffer
Key: 12 Size: 6000000 ( 5.7 MB) TemSe Char-Code convert Buf.
Key: 13 Size: 60500000 ( 57.7 MB) Alert Area
Key: 16 Size: 22400 ( 0.0 MB) Semaphore activity monitoring
Key: 17 Size: 2672386 ( 2.5 MB) Roll administration
Key: 51 Size: 3200000 ( 3.1 MB) Extended memory admin.
Key: 52 Size: 40000 ( 0.0 MB) Message Server buffer
Key: 54 Size: 51453952 ( 49.1 MB) Export/Import buffer
Key: 55 Size: 8192 ( 0.0 MB) Spool local printer+joblist
Key: 57 Size: 1048576 ( 1.0 MB) Profilparameter in shared mem
Key: 58 Size: 4096 ( 0.0 MB) Enqueue ID for reset

hared memories inside of pool 40
Key: 42 Size: 35392992 ( 33.8 MB) DB TTAB buffer
Key: 43 Size: 101014392 ( 96.3 MB) DB FTAB buffer
Key: 44 Size: 21142392 ( 20.2 MB) DB IREC buffer
Key: 45 Size: 11926392 ( 11.4 MB) DB short nametab buffer
Key: 46 Size: 20480 ( 0.0 MB) DB sync table
Key: 47 Size: 12289024 ( 11.7 MB) DB CUA buffer
Key: 48 Size: 300000 ( 0.3 MB) Number range buffer
Key: 49 Size: 2968344 ( 2.8 MB) Spool admin (SpoolWP+DiaWP)

hared memories outside of pools
Key: 1 Size: 2500 ( 0.0 MB) System administration
Key: 2 Size: 6021400 ( 5.7 MB) Disp. administration tables
Key: 3 Size: 13714400 ( 13.1 MB) Disp. communication areas
Key: 4 Size: 517048 ( 0.5 MB) statistic area
Key: 6 Size: 1064960000 (1015.6 MB) ABAP program buffer
Key: 7 Size: 14838 ( 0.0 MB) Update task administration
Key: 8 Size: 67108964 ( 64.0 MB) Paging buffer
Key: 9 Size: 134217828 ( 128.0 MB) Roll buffer
Key: 14 Size: 4400000 ( 4.2 MB) Presentation buffer
Key: 18 Size: 917604 ( 0.9 MB) Paging adminitration
Key: 19 Size: 30000000 ( 28.6 MB) Table-buffer
Key: 30 Size: 26624 ( 0.0 MB) Taskhandler runtime admin.
Key: 31 Size: 4806000 ( 4.6 MB) Dispatcher request queue
Key: 33 Size: 10240000 ( 9.8 MB) Table buffer, part.buffering
Key: 34 Size: 16777216 ( 16.0 MB) Enqueue table
Key: 41 Size: 25010000 ( 23.9 MB) DB statistics buffer
Key: 62 Size: 85983232 ( 82.0 MB) Memory pipes
Key: 63 Size: 409600 ( 0.4 MB) ICMAN shared memory
Key: 64 Size: 4202496 ( 4.0 MB) Online Text Repository Buf.
Key: 65 Size: 4202496 ( 4.0 MB) Export/Import Shared Memory
Key: 1002 Size: 400000 ( 0.4 MB) Performance monitoring V01.0
Key: 58900106 Size: 4096 ( 0.0 MB) SCSA area

Nr of operating system shared memory segments: 24

Shared memory resource requirements estimated
================================================================
Total Nr of shared segments required.....: 24
System-imposed number of shared memories.: 252
Shared memory segment size required min..: 1064960000 (1015.6 MB)
System-imposed maximum segment size......: 86973087744 (82944.0 MB)

Swap space requirements estimated
================================================
Shared memory....................: 1804.3 MB
..in pool 10 118.3 MB, 141% used !!
..in pool 40 213.6 MB, 104% used !!
..not in pool: 1405.7 MB
Processes........................: 324.2 MB
Extended Memory .................: 8184.0 MB
------------------------------------------------
Total, minimum requirement.......: 10312.5 MB
Process local heaps, worst case..: 1908.0 MB
Total, worst case requirement....: 12220.5 MB

Errors detected..................: 2
Warnings detected................: 4
erpdev:devadm 20%