背景
近况:
数据库与业务分别设立在不同的单板上(suse10 + ora11g)
调整:
把数据库切换到AIX机器上,业务单板稳定。
表示图如下:
数据迁徙流程图
操作过程
数据库A应用数据全表导出
脚本:
shell
- #!/bin/sh
- #定义备份时间
- backupdate=`date +'%Y%m%d_%H%M%S'`
- #定义备份路径
- BakPath=/opt/oracle/oracle_table_bak
- if [ ! -d $ORACLE_BASE/oracle_table_bak ];then
- mkdir -p $ORACLE_BASE/oracle_table_bak
- fi
- # 定义oracle用户名和密码
- ACCOUNT=mmsg #用户名称
- PASSWORD=mmsg #用户密码
- SID=mmsgdb #数据库别名
- echo "Please input user name,password and SID to connect to oracle"
- #读入用户名
- echo "username(mmsg)"
- read U_INPUT
- if [ "x$U_INPUT" != "x" ]; then
- ACCOUNT=$U_INPUT
- fi
- #读入密码
- echo "password(mmsg)"
- read U_INPUT
- if [ "x$U_INPUT" != "x" ]; then
- PASSWORD=$U_INPUT
- fi
- #读入SID
- echo "SID( mmsgdb)"
- read U_INPUT
- if [ "x$U_INPUT" != "x" ]; then
- SID=$U_INPUT
- fi
- #系统所在路径
- APPHOME=`dirname $0`
- if [ $APPHOME = "." ]; then
- APPHOME=`pwd`
- fi
- cd $APPHOME
- #执行导出操作
- exp $ACCOUNT/$PASSWORD@$SID file=${ORACLE_BASE}/oracle_table_bak/fullbak_$backupdate.dmp log=${ORACLE_BASE}/oracle_table_bak/fullbak_$backupdate.log full=y
复制代码 导出
1、oracle用户上传fullbak_mmsg.sh脚本,并为fullbak_mmsg.sh脚本增加可实行权限
chmod +x fullbak_mmsg.sh
2、使用oracle用户实行fullbak_mmsg.sh脚本
sh fullbak_mmsg.sh
3、导出过程日志信息片段如下
shell
- Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Export done in ZHS16GBK character set and UTF8 NCHAR character set
- About to export the entire database ...
- . exporting tablespace definitions
- . exporting profiles
- . exporting user definitions
- . exporting roles
- . exporting resource costs
- . exporting rollback segment definitions
- . exporting database links
- . exporting sequence numbers
- . exporting directory aliases
- . exporting context namespaces
- . exporting foreign function library names
- . exporting PUBLIC type synonyms
- . exporting private type synonyms
- . exporting object type definitions
- . exporting system procedural objects and actions
- . exporting pre-schema procedural objects and actions
- . exporting cluster definitions
- . about to export SYSTEM's tables via Conventional Path ...
- . . exporting table DEF$_AQCALL 0 rows exported
- . . exporting table DEF$_AQERROR 0 rows exported
- . . exporting table DEF$_CALLDEST 0 rows exported
- . . exporting table DEF$_DEFAULTDEST 0 rows exported
- …………………………………………………………………………………………
- . . exporting table VPNUNITECORPID 1 rows exported
- . exporting synonyms
- . exporting views
- . exporting referential integrity constraints
- . exporting stored procedures
- . exporting operators
- . exporting indextypes
- . exporting bitmap, functional and extensible indexes
- . exporting posttables actions
- . exporting triggers
- . exporting materialized views
- . exporting snapshot logs
- . exporting job queues
- . exporting refresh groups and children
- . exporting dimensions
- . exporting post-schema procedural objects and actions
- . exporting user history table
- . exporting default and system auditing options
- . exporting statistics
- Export terminated successfully without warnings.
复制代码 大概出现的题目解决方法
ORA-06550、EXP-00008、PLS-0020、ORA-06512错误
在导出过程中假如出现如下错误:
shell
- EXP-00008: ORACLE error 6550 encountered
- ORA-06550: line 1, column 19:
- PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
- ORA-06550: line 1, column 7:
- PL/SQL: Statement ignored
- ORA-06512: at "SYS.DBMS_SQL", line 1575
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
- ORA-06512: at line 1
- . . exporting table DEF$_AQERROR
- EXP-00008: ORACLE error 6510 encountered
- ORA-06510: PL/SQL: unhandled user-defined exception
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
- ORA-06512: at line 1
- . . exporting table DEF$_CALLDEST
- EXP-00008: ORACLE error 6550 encountered
- ORA-06550: line 1, column 19:
- PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
- ORA-06550: line 1, column 7:
- PL/SQL: Statement ignored
- ORA-06512: at "SYS.DBMS_SQL", line 1575
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
- ORA-06512: at line 1
- . . exporting table DEF$_DEFAULTDEST
- EXP-00008: ORACLE error 6510 encountered
- ORA-06510: PL/SQL: unhandled user-defined exception
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
- ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
- ORA-06512: at line 1
复制代码 请使用如下方法解决:
1、将DBMS_EXPORT_EXTENSION和DBMS_DEFER_IMPORT_INTERNAL实行权限赋予导出用户
shell
- grant execute on DBMS_EXPORT_EXTENSION to 导出用户;
- grant execute on DBMS_DEFER_IMPORT_INTERNAL to 导出用户;
复制代码 2、成功赋予权限后,实行应用全表导出操作
shell
应用全表导入到数据库B
注:
- 在将数据库A中表数据导入到数据库B中 之前,请务必先备份数据库B中数据,备份操作请参考“数据库A应用数据全表导出”部分内容。
1、删除原有数据库中全部应用表
注:
- 本段的操作,必须是在正确完成上述应用数据库B中数据的导出工作后进行!
删除原有数据库中全部应用表操作步调
A、准备存储过程
新增一存储过程drop_tbl_table,sql脚本代码如下:
shell
- create or replace procedure drop_tbl_table(tname in varchar)
- is
- v_sql varchar(100); -- 动态SQL语句
- v_count number(10); -- 数据库中drop过的表数
- begin
- v_count := 0;
-
- for v1 in (select * from all_tables where owner = 'MMSG')
- loop
- v_sql := 'drop table ' || v1.table_name;
- v_count := v_count + 1;
- execute immediate v_sql;
- end loop;
- dbms_output.put_line(v_count);
- end drop_tbl_table;
- /
复制代码 将上述脚本拷贝到文件中,以asc方式上传到oracle数据库某节点下,并将该文件定名为ora_proc_drop_tbl_tables.sql,如下:
注:
- sql脚本中select * from all_tables where owner = 'MMSG' 的 MMSG为表的属主,请根据现网环境选择正确属主,否则会造成误删不相干的表,造成数据丢失。
B、创建存储过程
oracle用户成功登录终端,以应用用户(如数据库应用用户mmsg)与数据库建立连接,实行ora_proc_drop_tbl_tables.sql脚本
shell
- oracle@mmsg:~> cat ora_proc_drop_tbl_tables.sql | sqlplus mmsg/mmsg@mmsgdb
- SQL*Plus: Release 11.1.0.7.0 - Production on 星期一 7月 12 18:08:17 2010
- Copyright (c) 1982, 2008, Oracle. All rights reserved.
- 连接到:
- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
- 过程已创建。
- SQL> 从 Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
- oracle@mmsg:~>
复制代码 C、实行存储过程
实行存储过程,删除全部应用表。
shell
- oracle@mmsg:~> sqlplus mmsg/mmsg@mmsgdb
- SQL*Plus: Release 11.1.0.7.0 - Production on 星期一 7月 12 17:52:44 2010
- Copyright (c) 1982, 2008, Oracle. All rights reserved.
- 连接到:
- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- SQL> exec drop_tbl_table(0)
- PL/SQL 过程已成功完成。
- SQL>
复制代码 注意事项:
- 1、存储过程的实行过程必要一定的时间(尤其应用表数量较多时),请耐心等待。切勿实行退出命令,否则会导致表删除不全。
- 2、存储过程实行完毕后,输入sqlplus中输入如下命令查看表是否删除完毕:select count(0) from all_tables where owner = 'MMSG';
假如查询效果是0,则 表删除完毕。
2、导入
imp username/passwd@sid file=XXX.dmp ignore=y commit=y full=y
大概
imp username/passwd@dbname fromuser=XXX touser=XXX file= XXX.dmp ignore=y commit=y full=y
此中:
- fromuser 该选项用于指定从导出文件中摘取并导入特定用于的对象;
- touser 该选项用于指定将特定方案对象导入到其他用户。
比方:
shell
- imp wyz/wyz@iagw fromuser=mmsg touser=wyz file=./fullbak_20100507_091121.dmp ignore=y commit=y log= fullbak_20100506_194731.log
复制代码 假如导入导出的用户名一致,可以直接使用如下命令进行导入:
shell
- imp mmsg/mmsg@mmsgdb file=./ fullbak_20100507_091121.dmp ignore=y commit=y full=y
复制代码 注:
- .dmp文件必须以bin方式从数据库A ftp到数据库B
大概出现的题目解决方法
假如在导入过程中并未出现下列题目,请跳过下列步调,直接验证导入后数据完备性。
IMP-00013错误
假如在导入过程中出现IMP-00013错误,如下:
shell
- % imp wyz/wyz@iagw fromuser=mmsg touser=wyz file=./fullbak_20100506_200334.dmp ignore=y commit=y
- Import: Release 11.1.0.6.0 - Production on 星期四 5月 6 20:13:59 2010
- Copyright (c) 1982, 2007, Oracle. All rights reserved.
- Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
- With the Partitioning, Oracle Label Security, OLAP, Data Mining,
- Oracle Database Vault and Real Application Testing option
- Export file created by EXPORT:V11.01.00 via conventional path
- IMP-00013: only a DBA can import a file exported by another DBA
- IMP-00000: Import terminated unsuccessfully
- %
复制代码 原因:
导入用户不具有dba权限
解决方法:
赋予导入用户dba和imp_full_Database权限
操作如下:
shell
- % sqlplus / as sysdba
- SQL*Plus: Release 11.1.0.6.0 - Production on 星期五 5月 7 09:54:40 2010
- Copyright (c) 1982, 2007, Oracle. All rights reserved.
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
- With the Partitioning, Oracle Label Security, OLAP, Data Mining,
- Oracle Database Vault and Real Application Testing options
- SQL> grant dba to wyz;
- Grant succeeded.
- SQL> grant imp_full_Database to wyz;
- Grant succeeded.
- SQL> exit
复制代码 IMP-00003、ORA-01658错误
重新实行导入操作,假如在导入过程中出现如下错误
shell
- IMP-00003: ORACLE error 1658 encountered
- ORA-01658: 无法为表空间 MMSG 中的段创建 INITIAL 区
复制代码 原因:
1、表空间WYZ不足;
2、数据从A数据库导入到B数据库,但是没有使用B数据库对应的表空间。
解决方法如下:
1、请确保被导入数据的数据库所对应的表空间充足大,假如表空间不足,请使用如下方法进行相应的表空间扩展。
Suse平台扩展Oracle表空间操作
当按照安装规划创建的表空间无法顺应于当前性能测试必要时,可以通过如下方法扩大相应逻辑卷,增加空间。
Suse操作系统下扩展Oracle表空间一样平常情况我们通过扩展裸设备巨细的操作,而不是通过增加裸设备个数的操作来实现。由于Suse中的裸设备raw**是必要跟lv文件进行绑定的,该绑定操作必要在系统重启的时候实行。而绑定关系是设置在启动文件中的(该部分可以参考安装指南)。假如增加了裸设备还必要修改绑定关系,为了减少操作,我们一样平常使用修改lv/裸设备巨细的方式进行。
假设临时表空间必要扩展表空间,步调如下:
扩展lv巨细。先找出临时表空间用到哪个裸设备,假设为raw2,然后在安装文档或/etc/raw文件中找到raw2对应绑定的lv的名称,假设为/dev/datavg/lvora_temp1,那么可以将该lv增大2G。
# lvextend -L +2G /dev/datavg/lvora_temp1
datafile是针对一样平常表空间
当扩展的是临时表空间时,更换成tmpfile
扩展表空间
当表空间已经满时,实行数据库操作数据库会报错,比方:
shell
- ORA-01653: 表 MMSG.TMP_BASE_RESULT 无法通过 8 (在表空间 MMSG 中) 扩展
- ORA-06512: 在 "MMSG.LOG2DB_UTIL", line 92
- ORA-06512: 在 line 1
- 需要扩展表空间
- ORA-01653
- node1:oracle:mmsgdb > oerr ora 01653
- 01653, 00000, "unable to extend table %s.%s by %s in tablespace %s"
- // *Cause: Failed to allocate an extent of the required number of blocks for
- // a table segment in the tablespace indicated.
- // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
- // files to the tablespace indicated.
- node1:oracle:mmsgdb >
复制代码 扩展操作命令如下:
shell
- alter database datafile '/opt/oracle/admin/mmsgdb/mmsgdata/mmsgdata01' AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
复制代码 下面的两个命令也可以:
shell
- alter tablespace mmsg add datafile '/opt/oracle/admin/mmsgdb/mmsgdata/mmsgdata01' size 1024M reuse;
- alter database datafile '/opt/oracle/admin/mmsgdb/mmsgdata/mmsgdata01' resize 2048M;
复制代码 扩展后重启实例,查看相干表空间是否已经扩展,
shell
- select * from dba_tablespace_usage_metrics;
复制代码 Oracle用imp导入用户表时选择表空间的题目
当前表空间为WYZ,但是提示信息显示无法为表空间 MMSG 中的段创建 INITIAL 区,说明数据固然导入到了wyz用户下,但是使用的表空间依然是MMSG,而我们所必要的是表空间WYZ,而非MMSG,解决方法如下:
shell
- % sqlplus / as sysdba
- SQL*Plus: Release 11.1.0.6.0 - Production on 星期五 5月 7 11:08:51 2010
- Copyright (c) 1982, 2007, Oracle. All rights reserved.
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
- With the Partitioning, Oracle Label Security, OLAP, Data Mining,
- Oracle Database Vault and Real Application Testing options
- SQL> grant resource,connect to wyz;
- Grant succeeded.
- SQL> grant dba to wyz; // 赋 DBA 权限
- Grant succeeded.
- SQL> revoke unlimited tablespace from wyz; // 撤销此权限
- Revoke succeeded.
- SQL> alter user wyz quota 0 on system; //将用户在 System 表空间的配额置为 0
- User altered.
- SQL> alter user wyz quota unlimited on wyz; //设置用户在 wyz 表空间配额不受限。
- User altered.
- SQL> exit
复制代码 上述题目解决后,重新实行数据导入操作
数据导入
shell
- imp wyz/wyz@iagw fromuser=mmsg touser=wyz file=./fullbak_20100507_091121.dmp ignore=y commit=y log=imp_20100507_091121.log
复制代码 导入验证
日志信息
shell
验证过程
数据完备性验证
应用数据导入到数据库B后,数据完备性验证。
重要操作是查询导入后的数据信息,比方通过PLSQL Developer工具查询雷同的表,前后进行数据对比操作。
TNS设置
使用oracle用户,在MMSG单板侧增加tns信息,即修改 $ORACLE_HOME/network/admin/tnsnames.ora文件
比方:
shell
- vi $ORACLE_HOME/network/admin/tnsnames.ora
- MMSGDB62 =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.167.62)(PORT = 1523))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = iagw)
- )
- )
复制代码 注:
- 蓝色部分为增加的TNS信息,请根据实际情况进行增加。
MMSG与切换后的数据库连接验证
使用MMSG用户登录单板,验证网关与切换后的数据库的连接是否正常
操作如下
1、使用tnsping大概sqlplus命令验证
tnsping dbname N
此中:
- dbname为TNS中增加的数据库的别名
- N 体现一个正整数
2、使用sqlplus命令验证
shell
- sqlplus username/passwd@dbname
复制代码 此中:
- username体现切换数据库后应用用户名
- passwd 体现切换数据库后应用用户的密码
- dbname 体现 TNS中增加的数据库名(示例中为MMSGDB62)
验证如下
shell
修改MMSG侧设置文件
注:
- 在修改MMSG侧设置文件前,请先停止正在运行的网关。
修改$MMS_HOME/cfg目录下下列文件信息
shell
- cshrc
- mms.cfg
- log2db.cfg
- vpn.cfg
复制代码 shell
- vi cshrc
- #The SID for accessing the Oracle database must be consistent with the contents in the tnsname.ora configuration file of the Oracle client
- setenv ORACLE_SID mmsgdb62 //请根据实际情况进行修改,示例中TNS为mmsgdb62
复制代码 shell
- vi mms.cfg
- //Note: This configuration file is used for setting the database access mode of the MMSC.
- //Other settings are stored in the database. You can set the configuration items on the Web management page.
- [Database]
- DBName = mmsgdb62
- DBUserName =wyz
- DBPassword = wyz
- DBType = oracle
- DBUrl = jdbc:oracle:thin:@10.71.167.62:1523:iagw
- DBJdbcClass=oracle.jdbc.driver.OracleDriver
- MMS_LOCAL_FLOATIP = 10.137.49.114
复制代码 shell
- vi log2db.cfg
- //Log2db configuration file
- [Database]
- //Database user name
- DBUser = wyz
- //Database password
- DBPassword = wyz
- //URL used by the database JDBC
- DBUrl = jdbc:oracle:thin:@10.71.167.62:1523:iagw
- //DBUrl = jdbc:db2://10.164.78.178:50003/mmsgdb
- //DBUrl = jdbc:microsoft:sqlserver://127.0.0.1:1433
- //Drive used by the database JDBC
- DBDriver = oracle.jdbc.driver.OracleDriver
- //DBDriver = com.ibm.db2.jcc.DB2Driver
- //DBDriver = com.microsoft.jdbc.sqlserver.SQLServerDriver
复制代码 shell
- vi vpn.cfg
- [DataBase]
- #Database connection information. This parameter is valid only when VpnDbMode is set to 0 indicating to connect to the WEBSMS.
- #Oracle database
- DBUrl=jdbc:oracle:thin:@10.71.167.62:1523:iagw
- DBDriver=oracle.jdbc.driver.OracleDriver
- #DB2 database
- #DBUrl=jdbc:db2://10.164.75.87:50001/iagdb1
- #DBDriver=com.ibm.db2.jcc.DB2Driver
- DBUser=wyz
- DBPassword=wyz
复制代码 注:
- 1、蓝色部分信息请根据实际情况进行修改。
- 2、修改后重新source一下cfg目录下cshrc文件
- 3、它设置信息,如后台命令实行的备份脚本等不必要做任何改动,当mms.cfg文件发生修改后,在某时候后台实行定时使命时候会重新读取这个设置文件,故而相干的定时使命不做任何变动。
- 4、假如在原数据库上进行了数据库的备份计谋,请将备份计谋在切换后的AIX 11g数据库上重新进行。
遇见题目 Get DB Connection is null
假如出现如下错误(Get DB Connection is null),请检查cfg目录下相干设置文件(重要是cfg目录下cshrc、mms.cfg、log2db.cfg三个文件)是否正确修改。
shell
- 91 mmsg [mmsg] :/home/mmsg/mms_home/cfg>Get DB Connection is null
- Exception in thread "main" java.lang.NullPointerException
- at com.huawei.mms.common.conf.ModulesData.getModuleNameByID(ModulesData.java:83)
- at com.huawei.mms.common.log.Alarmer.<init>(Alarmer.java:61)
- at com.huawei.mms.common.log.Alarmer.getInstance(Alarmer.java:74)
- at com.huawei.mms.common.dbproxy.DBProxyJDBCImp.query(DBProxyJDBCImp.java:351)
- at com.huawei.mms.common.dbproxy.DBProxyJDBCImp.query(DBProxyJDBCImp.java:271)
- at com.huawei.mms.common.conf.CfgMgr.reload(CfgMgr.java:107)
- at com.huawei.mms.init.HttpAgentData.init(HttpAgentData.java:131)
- at com.huawei.mms.init.MMSCClientInitiator.initCfgData(MMSCClientInitiator.java:155)
- at com.huawei.mms.init.Initiator.initSystem(Initiator.java:97)
- at com.huawei.mms.mm7agent.MMSCClient.main(MMSCClient.java:49)
复制代码 启动网关
使用mms start命令启动数据库切换后的网关。
假如在启动过程中出现如下信息,请修改端标语,以server主调度模块为例
shell
- [05-07 15:22:37 511][INFO][ServerApp][serverapp.cpp 263][-140986064]***************** Initialize Static Data Successfully!! ******
- **************
- [05-07 15:22:37 511][FINE][Platform][mms_acceptor.cpp 85][-140986064]Tcp Server start fail!ip address is:10.137.49.114, port no is:5
- 2233
- [05-07 15:22:37 511][WARNING][ServerApp][serverapp.cpp 492][-140986064]Open Socket Server Failed, Exit System...!ServerIP = 10.137.4
- 9.114, ListenPort = 52233
- [05-07 15:22:37 511][FINE][Platform][appmanager.cpp 173][-140986064]OnInit() return -1
复制代码 server模块启动失败
shell
- 144 mmsg [mmsg] :/home/mmsg/mms_home/log/server_1/run>netstat -an | grep 52233
- tcp 0 0 10.137.49.114:52277 10.137.49.114:52233 ESTABLISHED
- tcp 0 0 10.137.49.114:52233 10.137.49.114:52277 ESTABLISHED
复制代码 解决方法如下
1、server端口信息
shell
- update modules set listenport =52239 where MODULENAME='MMSServer';
复制代码 2、重启server模块
shell
流程验证
网关各个模块启动后,验证流程是否通畅。
注:
- 必要修改portal设置信息,由于数据库已经发生切换。本文不做先容。
下行流程,不支持DR优化
计费话单
shell
- 0507155553800800011020000,008613810243001,,0,822000,008613810243001,,2,1,3,0,0,0,0,1,2,0,1000,800800,910000,822000,7800,121000,,2010
- 0507155553,20100507155558,,00000,1,1,1,0,0,0,050708001402708220010,
复制代码 统计话单
shell
- 0507155553800800011020000,008613810243001,,0,822000,008613810243001,,2,1,3,0,0,0,0,1,2,0,0100,800800,910000,822000,7800,121000,,2010
- 0507155553,20100507155553,,00000,1,1,1,0,0,0,,,1,
- 0507155553800800011020000,008613810243001,,0,822000,008613810243001,,3,1,3,0,0,0,0,1,2,0,1000,800800,910000,822000,7800,121000,,2010
- 0507155553,20100507155558,,00000,1,1,1,0,0,0,,1,1,
复制代码 Vaspserver日志片段
shell
SVC日志片段
shell
- [2010-05-07 15:55:53 339][LgTp:FRSMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:2][SessID:0110000000001100507155553][MsgID:050715555380080001102][TransID:tid100000000][ExMsgID:][MPRP:MM7][MsgType:MM7_SUBMIT_REQ][AfrAtrbt:RCV][AfrStat:OK]; SV:NULL; MsgCls:NULL; DR:YES; RR:NULL; MsgSz:0 Byte(s); VASPID:822000; VASID:7800; SrvCd:121000; DispMsgID:;
- [2010-05-07 15:55:53 340][LgTp:SRVMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:2][SessID:0110000000001100507155553][MsgID:050715555380080001102][TransID:tid100000000][ExMsgID:][MPRP:MM7][MsgType:MM7_SUBMIT_RES][AfrAtrbt:SND][AfrStat:OK]; MM7RspStat:SUCCESS; DispMsgID:;
- [2010-05-07 15:55:53 345][LgTp:OFLWVR][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SessID:0110000000001100507155553][MsgID:050715555380080001102][ExMsgID:][FlwCls:NORMAL]; FlwOvrStat:SUBMIT_OK; FlwOvrStatCode:0100; DtlCd:STAT_SUBMIT_SUCCESS; DlvrTimer:0 Second(s);
- [2010-05-07 15:55:53 346][LgTp:ENTRLS][SessID:0110000000001100507155553][MsgID:050715555380080001102][ExMsgID:][EntAct:SUBMIT_SESSION_RELEASE]; RealFlwCls:NORMAL;
- [2010-05-07 15:55:53 346][LgTp:SRVMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:-1][SessID:0110000000002100507155553][MsgID:050715555380080001102][TransID:0110000000002100507155553001][ExMsgID:][MPRP:MM7][MsgType:MM7_SUBMIT_REQ][AfrAtrbt:SND][AfrStat:OK]; SV:NULL; MsgCls:PRSL; DR:YES; RR:NO; MsgSz:0 Byte(s); VASPID:800100; VASID:7788; SrvCd:822001;
- [2010-05-07 15:55:53 470][LgTp:SRVMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:0][SessID:0110000000002100507155553][MsgID:050715555380080001102][TransID:0110000000002100507155553001][ExMsgID:050708001402708220010][MPRP:MM7][MsgType:MM7_SUBMIT_RES][AfrAtrbt:RCV][AfrStat:OK]; MM7RspStat:SUCCESS;ResOriginStat:1000;
- [2010-05-07 15:55:58 638][LgTp:SRVMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:2][SessID:0110000000002100507155553][MsgID:050715555380080001102][TransID:tid00001003][ExMsgID:050708001402708220010][MPRP:MM7][MsgType:MM7_DELIVERY_REPORT_REQ][AfrAtrbt:RCV][AfrStat:OK]; FtchStat:RETRIEVED;
- [2010-05-07 15:55:58 638][LgTp:SRVMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:2][SessID:0110000000002100507155553][MsgID:050715555380080001102][TransID:tid00001003][ExMsgID:050708001402708220010][MPRP:MM7][MsgType:MM7_DELIVERY_REPORT_RES][AfrAtrbt:SND][AfrStat:OK]; MM7RspStat:SUCCESS;
- [2010-05-07 15:55:58 638][LgTp:TFLWVR][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SessID:0110000000002100507155553][MsgID:050715555380080001102][ExMsgID:050708001402708220010][FlwCls:NORMAL]; FlwOvrStat:DELIVER_OK; FlwOvrStatCode:1000; DtlCd:STAT_FRWRD_SNDR_ADDR_IN_FRWRD_RCVR_USER_BLKLST; RealFlwCls:NORMAL;
- [2010-05-07 15:55:58 638][LgTp:SRVMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:-1][SessID:0110000000002100507155553][MsgID:050715555380080001102][TransID:0110000000002100507155553303][ExMsgID:050708001402708220010][MPRP:MM7][MsgType:MM7_DELIVERY_REPORT_REQ][AfrAtrbt:SND][AfrStat:SNDING]; FtchStat:RETRIEVED; DispMsgID:;
- [2010-05-07 15:55:58 657][LgTp:SRVMSG][AfOrgn:][Sndr:7800121000][Rcvr:+8613810243001][FwdAddr:][SqncNum:0][SessID:0110000000002100507155553][MsgID:050715555380080001102][TransID:0110000000002100507155553303][ExMsgID:050708001402708220010][MPRP:MM7][MsgType:MM7_DELIVERY_REPORT_RES][AfrAtrbt:RCV][AfrStat:OK]; MM7RspStat:SUCCESS;
- [2010-05-07 15:55:58 657][LgTp:ENTRLS][SessID:0110000000002100507155553][MsgID:050715555380080001102][ExMsgID:050708001402708220010][EntAct:DELIVER_SESSION_RELEASE]; RealFlwCls:NORMAL;
- [2010-05-07 15:55:58 657][LgTp:ENTRLS][MsgID:050715555380080001102][ExMsgID:][EntAct:ORIGINMSG_RELEASE];
复制代码 CS日志片段
shell
- m_ucAreaFlag = 0
- m_ucRoamingStatus = 255
- m_strIMSI =
- m_strVisitedSGSN =
- m_addrXMmsSenderAddress end:
- m_strXMmsSenderActaulProperties =
- m_strXMmsResulText = 处理成功
- m_listRecipientAddress Start:
- m_strXMmsTransactionIDofPPS = 011000000999910050715555300011
- m_addrXMmsRecipientAddress Start:
- m_strAddress = +8613810243001
- m_iAddressType = 0
- m_iAddressSendType = 0
复制代码 Mmscclient日志片段
shell
- [2010-05-07 15:55:53.321] [FINER] [mmscclient_5401] [ConnectionManager.java:333] [ ] [Update SocketConnection's Load]
- Update module[1]'s state to 0
- [2010-05-07 15:55:53.347] [FINEST] [mmscclient_5401] [SocketConnection.java:539] [ ] [Receive Message]
- Receive message from module[1], binary stream:
- 15:55:53.346(Tools.java:374) byte[297] @16747636 {
- [HEX] 0 1 2 3 4 5 6 7- 8 9 a b c d e f | 0123456789abcdef
- ----------------------------------------------------------------------------
- 00000000: 00 00 00 c5 17 40 00 00.ff ff ff ff ff ff 00 03 | .....@..........
- 00000010: 00 01 10 01 00 01 00 4a.15 19 00 00 00 00 ff ff | .......J........
- 00000020: ff ff 8c c0 98 30 31 31.30 30 30 30 30 30 30 30 | .....01100000000
- 00000030: 30 32 31 30 30 35 30 37.31 35 35 35 35 33 30 30 | 0210050715555300
- 00000040: 31 00 f1 30 35 30 37 31.35 35 35 35 33 38 30 30 | 1..0507155553800
- 00000050: 38 30 30 30 31 31 30 32.00 ea 38 32 32 30 30 30 | 80001102..822000
- 00000060: 00 eb 37 38 30 30 00 ec.31 32 31 30 30 30 00 d5 | ..7800..121000..
- 00000070: 02 06 30 d8 38 30 30 31.30 30 00 d9 37 37 38 38 | ..0.800100..7788
- 00000080: 00 85 04 4b e3 c7 89 97.2b 38 36 31 33 38 31 30 | ...K....+8613810
- 00000090: 32 34 33 30 30 31 00 d7.38 32 32 30 30 31 00 96 | 243001..822001..
- 000000a0: 54 68 69 73 20 69 73 20.61 20 74 65 73 74 2e 00 | This is a test..
- 000000b0: 8a 80 88 06 80 04 4b e3.c7 c5 86 80 90 81 d6 03 | ......K.........
- 000000c0: 0d e2 b0 . | ...
- }
- [2010-05-07 15:55:53.347] [FINER] [mmscclient_5401] [MMSCProcessor.java:56] [ ] [MMSG to MMSC]
- Begin to dispose message from MMSGserver!
- [2010-05-07 15:55:53.348] [FINER] [mmscclient_5401] [MMSCProcessor.java:124] [ ] [MMSG to MMSC]
- PDU message detail is:
- MessageType = MM7-Submit.req
- TransactionID = 0110000000002100507155553001
- MM7Version = 6.3.0
- To = [+8613810243001]
- Date = 2010-05-07 15:55:53 +0800
- DeliveryReport = YES
- Expiry = 2010-05-07 15:56:53 +0800
- MessageClass = Personal
- ReadReply = NO
- Subject = This is a test.
- MMSCID = 910000
- VASPID = 800100
- VASID = 7788
- ServiceCode = 822001
- MMSGMessageID = 050715555380080001102
- RealVASPID = 822000
- RealVASID = 7800
- RealServiceCode = 121000
- [2010-05-07 15:55:53.348] [FINER] [mmscclient_5401] [MMSCProcessor.java:240] [ ] [MMSG to MMSC]
- MMSC Don't Support DR Optimization
- [2010-05-07 15:55:53.348] [FINER] [mmscclient_5401] [MMSCProxyHTTPImp.java:461] [ ] [MMSG to MMSC]
- MMSCURL(soap) is: http://10.137.48.60:1190/mmsc
- [2010-05-07 15:55:53.382] [FINEST] [mmscclient_5401] [MMSCProxyHTTPImp.java:778] [ ] [MMSG to MMSC]
- Get response from MMSC, detail:
- <?xml version="1.0"?><env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header><mm7:TransactionID xmlns:mm7="http://www.3gpp.org/ftp/Specs/archive/23_series/23.140/schema/REL-6-MM7-1-0">0110000000002100507155553001</mm7:TransactionID></env:Header><env:Body><SubmitRsp xmlns="http://www.3gpp.org/ftp/Specs/archive/23_series/23.140/schema/REL-6-MM7-1-0"><MM7Version>6.3.0</MM7Version><Status><StatusCode>1000</StatusCode></Status><MessageID>050708001402708220010</MessageID></SubmitRsp></env:Body></env:Envelope>
- [2010-05-07 15:55:53.382] [FINER] [mmscclient_5401] [MMSCProxyHTTPImp.java:1140] [ ] [MMSCProxyHTTPImp]
- get response from MMSC, detail:
- MessageType = MM7-Submit.res
- TransactionID = 0110000000002100507155553001
- MM7Version = 6.3.0
- MessageID = 050708001402708220010
- StatusCode = 1000
- [2010-05-07 15:55:53.443] [FINEST] [mmscclient_5401] [MMSCProcessor.java:665] [ ] [insert data successful. MMSGMessageID = 050715555380080001102, MMSCMessageID = 050708001402708220010 tableName:MMSGMMSCMsgIDMap04 , current time is: Fri May 07 15:55:53 CST 2010]
- [2010-05-07 15:55:53.469] [FINER] [mmscclient_5401] [MMSCProcessor.java:449] [ ] [MMSCProxyHTTPImp]
- Send response to Server, detail:
- MessageType = MM7-Submit.res
- TransactionID = 0110000000002100507155553001
- MM7Version = 6.3.0
- MessageID = 050708001402708220010
- StatusCode = 1000
复制代码 上行流程
SVC日志片段
shell
- [2010-05-07 16:00:16 177][LgTp:FRSMSG][AfOrgn:][Sndr:+8613810243001][Rcvr:7800121000][FwdAddr:][SqncNum:3][SessID:0120000000003100507160016][MsgID:050716001680080001203][TransID:tid00001004][ExMsgID:][MPRP:MM7][MsgType:MM7_DELIVER_REQ][AfrAtrbt:RCV][AfrStat:OK]; SV:NULL; MsgCls:NULL; DR:NULL; RR:NULL; Expiry:-1 Second(s); MsgSz:0 Byte(s); VASPID:; VASID:; SrvCd:; DlvrType:; SessType:Normal;
- [2010-05-07 16:00:16 177][LgTp:SRVMSG][AfOrgn:][Sndr:+8613810243001][Rcvr:7800121000][FwdAddr:][SqncNum:3][SessID:0120000000003100507160016][MsgID:050716001680080001203][TransID:tid00001004][ExMsgID:][MPRP:MM7][MsgType:MM7_DELIVER_RES][AfrAtrbt:SND][AfrStat:OK]; MM7RspStat:SUCCESS;
- [2010-05-07 16:00:16 182][LgTp:OFLWVR][Sndr:+8613810243001][Rcvr:7800121000][FwdAddr:][SessID:0120000000003100507160016][MsgID:050716001680080001203][ExMsgID:][FlwCls:NORMAL]; FlwOvrStat:SUBMIT_OK; FlwOvrStatCode:0400; DtlCd:STAT_SUBMIT_SUCCESS; DlvrTimer:0 Second(s);
- [2010-05-07 16:00:16 182][LgTp:ENTRLS][SessID:0120000000003100507160016][MsgID:050716001680080001203][ExMsgID:][EntAct:SUBMIT_SESSION_RELEASE]; RealFlwCls:NORMAL;
- [2010-05-07 16:00:16 183][LgTp:SRVMSG][AfOrgn:][Sndr:+8613810243001][Rcvr:7800121000][FwdAddr:][SqncNum:-1][SessID:0120000000004100507160016][MsgID:050716001680080001203][TransID:0120000000004100507160016001][ExMsgID:][MPRP:MM7][MsgType:MM7_DELIVER_REQ][AfrAtrbt:SND][AfrStat:SNDING]; SV:SHOW; MsgCls:PRSL; DR:NO; RR:NO; Expiry:100 Second(s); MsgSz:0 Byte(s); VASPID:822000; VASID:7800; SrvCd:121000; DlvrType:NORMAL; SessType:Normal;
- [2010-05-07 16:00:16 203][LgTp:SRVMSG][AfOrgn:][Sndr:+8613810243001][Rcvr:7800121000][FwdAddr:][SqncNum:0][SessID:0120000000004100507160016][MsgID:050716001680080001203][TransID:0120000000004100507160016001][ExMsgID:][MPRP:MM7][MsgType:MM7_DELIVER_RES][AfrAtrbt:RCV][AfrStat:OK]; MM7RspStat:SUCCESS;ResOriginStat:1000;
- [2010-05-07 16:00:16 203][LgTp:TFLWVR][Sndr:+8613810243001][Rcvr:7800121000][FwdAddr:][SessID:0120000000004100507160016][MsgID:050716001680080001203][ExMsgID:][FlwCls:NORMAL]; FlwOvrStat:DELIVER_OK; FlwOvrStatCode:1100; DtlCd:STAT_FRWRD_SNDR_ADDR_IN_FRWRD_RCVR_USER_BLKLST; RealFlwCls:NORMAL;
- [2010-05-07 16:00:16 207][LgTp:ENTRLS][SessID:0120000000004100507160016][MsgID:050716001680080001203][ExMsgID:][EntAct:DELIVER_SESSION_RELEASE]; RealFlwCls:NORMAL;
- [2010-05-07 16:00:16 207][LgTp:ENTRLS][MsgID:050716001680080001203][ExMsgID:][EntAct:ORIGINMSG_RELEASE];
复制代码 批价鉴权
验证了AOMT和MOAT批价鉴权流程,流程通畅。
二次确认流程
工具日志片段
shell
- [2010-05-08 16:19:54:447] 收到HTTP主动请求 AuthPriceReq, TransactionID=8008000000000007
- [2010-05-08 16:19:54:447] 返回响应 AuthPriceResp, hRet = 0
- [2010-05-08 16:19:59:447] 开始发送OnDemandReq
- [2010-05-08 16:19:59:447] 收到响应OnDemandRes, hRet = 0
复制代码 计费话单
shell
- 0507161533800800011060000,008613810243001,,0,008613810243001,822000,,5,1,4,0,3,0,0,1,2,0,1100,910000,800800,822000,7800,121000,,2010
- 0507161533,20100507161538,,00000,1,6,0,0,0,0,,
复制代码 统计话单
shell
- 0507161533800800011060000,008613810243001,,0,008613810243001,822000,,0,1,4,0,3,0,0,1,2,0,0400,910000,800800,822000,7800,121000,,20100507161533,20100507161538,,00000,1,6,0,0,0,0,,1,1,0507161533800800011060000,008613810243001,,0,008613810243001,822000,,5,1,4,0,3,0,0,1,2,0,1100,910000,800800,822000,7800,121000,,2010
- 0507161533,20100507161538,,00000,1,6,0,0,0,0,,
- ,1,
复制代码 支持DR优化
流程正常
Mmsclient日志片段
shell
- [2010-05-07 16:18:18.985] [FINEST] [mmscclient_5401] [SocketConnection.java:539] [ ] [Receive Message]
- Receive message from module[1], binary stream:
- 16:18:18.985(Tools.java:374) byte[297] @15430449 {
- [HEX] 0 1 2 3 4 5 6 7- 8 9 a b c d e f | 0123456789abcdef
- ----------------------------------------------------------------------------
- 00000000: 00 00 00 c5 17 40 00 00.ff ff ff ff ff ff 00 03 | .....@..........
- 00000010: 00 01 10 01 00 02 00 4a.15 19 00 00 00 00 ff ff | .......J........
- 00000020: ff ff 8c c0 98 30 31 32.30 30 30 30 30 30 30 30 | .....01200000000
- 00000030: 31 32 31 30 30 35 30 37.31 36 31 38 31 38 30 30 | 1210050716181800
- 00000040: 31 00 f1 30 35 30 37 31.36 31 38 31 38 38 30 30 | 1..0507161818800
- 00000050: 38 30 30 30 31 32 30 37.00 ea 38 32 32 30 30 30 | 80001207..822000
- 00000060: 00 eb 37 38 30 30 00 ec.31 32 31 30 30 30 00 d5 | ..7800..121000..
- 00000070: 02 06 30 d8 38 30 30 31.30 30 00 d9 37 37 38 38 | ..0.800100..7788
- 00000080: 00 85 04 4b e3 cc ca 97.2b 38 36 31 33 38 31 30 | ...K....+8613810
- 00000090: 32 34 33 30 30 31 00 d7.38 32 32 30 30 31 00 96 | 243001..822001..
- 000000a0: 54 68 69 73 20 69 73 20.61 20 74 65 73 74 2e 00 | This is a test..
- 000000b0: 8a 80 88 06 80 04 4b e3.cd 06 86 80 90 81 d6 03 | ......K.........
- 000000c0: 0d e2 b0 . | ...
- }
- [2010-05-07 16:18:18.986] [FINER] [mmscclient_5401] [MMSCProcessor.java:56] [ ] [MMSG to MMSC]
- Begin to dispose message from MMSGserver!
- [2010-05-07 16:18:18.986] [FINER] [mmscclient_5401] [MMSCProcessor.java:124] [ ] [MMSG to MMSC]
- PDU message detail is:
- MessageType = MM7-Submit.req
- TransactionID = 0120000000012100507161818001
- MM7Version = 6.3.0
- To = [+8613810243001]
- Date = 2010-05-07 16:18:18 +0800
- DeliveryReport = YES
- Expiry = 2010-05-07 16:19:18 +0800
- MessageClass = Personal
- ReadReply = NO
- Subject = This is a test.
- MMSCID = 910000
- VASPID = 800100
- VASID = 7788
- ServiceCode = 822001
- MMSGMessageID = 050716181880080001207
- RealVASPID = 822000
- RealVASID = 7800
- RealServiceCode = 121000
- [2010-05-07 16:18:18.986] [FINER] [mmscclient_5401] [MMSCProcessor.java:231] [ ] [MMSG to MMSC]
- MMSC Support DR Optimization
- [2010-05-07 16:18:18.986] [FINER] [mmscclient_5401] [MMSCProxyHTTPImp.java:461] [ ] [MMSG to MMSC]
- MMSCURL(soap) is: http://10.137.48.60:1190/mmsc
- [2010-05-07 16:18:19.022] [FINEST] [mmscclient_5401] [MMSCProxyHTTPImp.java:778] [ ] [MMSG to MMSC]
- Get response from MMSC, detail:
- <?xml version="1.0"?><env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header><mm7:TransactionID xmlns:mm7="http://www.3gpp.org/ftp/Specs/archive/23_series/23.140/schema/REL-6-MM7-1-0">050716181880080001207</mm7:TransactionID></env:Header><env:Body><SubmitRsp xmlns="http://www.3gpp.org/ftp/Specs/archive/23_series/23.140/schema/REL-6-MM7-1-0"><MM7Version>6.3.0</MM7Version><Status><StatusCode>1000</StatusCode></Status><MessageID>050708224000108220010</MessageID></SubmitRsp></env:Body></env:Envelope>
- [2010-05-07 16:18:19.023] [FINER] [mmscclient_5401] [MMSCProxyHTTPImp.java:1140] [ ] [MMSCProxyHTTPImp]
- get response from MMSC, detail:
- MessageType = MM7-Submit.res
- TransactionID = 050716181880080001207
- MM7Version = 6.3.0
- MessageID = 050708224000108220010
- StatusCode = 1000
- [2010-05-07 16:18:19.023] [FINER] [mmscclient_5401] [MMSCProcessor.java:449] [ ] [MMSCProxyHTTPImp]
- Send response to Server, detail:
- MessageType = MM7-Submit.res
- TransactionID = 0120000000012100507161818001
- MM7Version = 6.3.0
- MessageID = 050708224000108220010
- StatusCode = 1000
复制代码 要求包月计费
shell
- [2010-05-08 17:04:28:277] 收到HTTP主动请求 AuthPriceReq, TransactionID=8008000000000003
- [2010-05-08 17:04:28:277] 返回响应 AuthPriceResp, hRet = 0
- [2010-05-08 17:04:28:480] 收到HTTP主动请求 RequireMonthFeeReq, TransactionID=8008000000000004
- [2010-05-08 17:04:28:480] 返回响应 RequireMonthFeeReq, hRet = 0
复制代码 计费话单
shell
- 0507170006800800012030000,008613810243001,,0,822000,008613810243001,,2,1,3,0,3,0,0,1,2,0,1000,800800,910000,822000,7800,121000,,2010
- 0507170006,20100507170007,,00000,1,1,1,0,0,0,042803088220010000035,
复制代码 统计话单
shell
- 0507170006800800012030000,008613810243001,,0,822000,008613810243001,,2,1,3,0,3,0,0,1,2,0,0100,800800,910000,822000,7800,121000,,2010
- 0507170006,20100507170006,,00000,1,1,1,0,0,0,,,1,
- 0507170006800800012030000,008613810243001,,0,822000,008613810243001,,3,1,3,0,3,0,0,1,2,0,1000,800800,910000,822000,7800,121000,,2010
- 0507170006,20100507170007,,00000,1,1,1,0,0,0,,1,1,
复制代码 业务日志查询
来源: Transcendent
文章作者: Gavin Wang
文章链接: 联通数据库切换验证 | Transcendent
本文章著作权归作者全部,任何形式的转载都请注明出处。
免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!更多信息从访问主页:qidao123.com:ToB企服之家,中国第一个企服评测及商务社交产业平台。 |