GP 5.25 删除营运中心&新建营运中心说明
一、删除营运中心(demo:删除jbjmt营运中心)
1.以DBA的权限连入Oracle数据库，注意选择的数据库SID
登入DB服务期,用sysdba登陆DB：
</u2/oracle/product/11.2.0/dbhome_1> sqlplus sys/sys@toptest as sysdba
2.再次确定当前登入的SID
SQL> select name from v$database; 或SQL> select instance_name from v$instance;NAME---------TOPTEST
3.查询当前SID数据库里面所有的用户信息
SQL> select * from all_users;
4.aooi931删除集团架构资料 ->会自动删除aooi901对应的营运中心资料
4.1. aooi931根据需要删除集团架构资料
4.2. aooi930根据需要删除法人基本资料
ps:如果提示删除FGLPROFILE里面的资料失败,则你需手动删除FGLPROFILE里面对应的营运中心连接信息
否则下次如果新建的营运中心如与此次同名,则会新建英语中心失败
如下demo：mark jbjmt营运中心(vi 直接修改FGLPROFILE,你也可以echoFGLPROFILE查看配置文件到底在什么目录)
vi $FGLPROFILE #dbi.database.jbjmt.source = "topprod" ## DVM320#dbi.database.jbjmt.username = "jbjmt"## DVM320#dbi.database.jbjmt.password = "jbjmt" ## DVM320#dbi.database.jbjmt.schema = "jbjmt"## DVM320#dbi.database.jbjmt.ora.prefetch.rows = 1 # Add by Raymon 02/02/015.数据库删除用户drop user jbjmt cascade; --执行时间有点长commit;
二、新建营运中心(demo:新建jbjmt营运中心)
6.aooi930最后再重新建营运中心
建立营运中心的日志文件保存在/u1/topprod/tiptop/tmp/日期_ods.log文件中
--如果你是udm7登陆GP ERP的,AP后台也可以看到新建营运中心的信息过程. . importing table "ZXV_FILE"0 rows imported. . importing table "ZYW_FILE"0 rows imported. . importing table "ZZD_FILE"0 rows importedImport terminated successfully without warnings.accept the password of user system : stty: standard input: Invalid argumentstty: standard input: Invalid argumentSQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 28 09:15:58 Copyright (c) 1982, , Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> create profile tiptopgp limit PASSWORD_LIFE_TIME unlimited*ERROR at line 1:ORA-02379: profile TIPTOPGP already existsSQL> User altered.SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options==========================================DB: [ jbjmt creation succesfully! ]==========================================jbjmt:insert into azwd_filejbjmt:update default vaule(azw01) datajbjmt:update default vaule(azw01) finish.jbjmt:grant select,index to odsjbjmt:grant select,index to ods finishjbjmt:insert into zta_filep_zta 'Y' 'ztaimport' 'jbjmt' '2'INFO: TIPTOP GP System Exists 36 / 45 User(s) Online. (Connection In the List)g_bgjob:Yg_argv2:ztaimportg_argv3:jbjmtg_argv4:2SESSIONID:4427144 PLANT:01HZJM DBNAME:hzjmINFO: Your Plant (01HZJM) is setting in GMT+8 time zone.No idle controltiptop : tiptop dbag_dir.top=/u1/topprod/tiptopg_dir.tempdir=/u1/out-- ztaimport start --TABLE COUNT: 2084SYNONYM COUNT: 236VIEW COUNT:0IMPORT zta_file table start:09:17:51IMPORT zta_file table END:09:18:05IMPORT zta_file synonym START:09:18:05IMPORT zta_file synonym END:09:18:07-- ztaimport end --jbjmt:insert into zta_file finishEND:jbjmtcreating ods viewsods include:dsods include:ds1ods include:ds2ods include:ds3ods include:ds4ods include:ds5ods include:ds6ods include:dsallods include:hzbmods include:hzbmtods include:hzjmods include:jbjmtods include:jxilods include:kplods include:kpltods include:kpmods include:maksunods include:mkstods include:mrpods include:xpcods include:xpctcreate ods views finishSESSIONID:4427208 PLANT:01HZJM DBNAME:hzjm
以上完毕！
转自：/yihuiworld
