multi-org转换--求解答
************* Start of AD Administration session *************AD Administration version: 11.5.0AD Administration started at: Sat Apr 05 2008 21:19:53APPL_TOP is set to /ora11510/oracle/appvis/prodapplNLS_LANG value from the environment is : American_America.US7ASCII NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.US7ASCII You can be notified by email if a failure occurs.Do you wish to activate this feature [No] ? NoPlease enter the batchsize [1000] : 1000Please enter the name of the Oracle Applications System that thisAPPL_TOP belongs to.The Applications System name must be unique across all OracleApplications Systems at your site, must be from 1 to 30 characterslong, may only contain alphanumeric and underscore characters,and must start with a letter.Sample Applications System names are: "prod", "test", "demo" and "Development_2".Applications System Name [PROD] : PROD *NOTE: If you do not currently have certain types of files installedin this APPL_TOP, you may not be able to perform certain tasks.Example 1: If you don't have files used for installing or upgradingthe database installed in this area, you cannot install or upgradethe database from this APPL_TOP.Example 2: If you don't have forms files installed in this area, you cannotgenerate them or run them from this APPL_TOP.Example 3: If you don't have concurrent program files installed in this area,you cannot relink concurrent programs or generate reports from this APPL_TOP.Do you currently have files used for installing or upgrading the databaseinstalled in this APPL_TOP [YES] ? YES *Do you currently have Java and HTML files for HTML-based functionalityinstalled in this APPL_TOP [YES] ? YES *Do you currently have Oracle Applications forms files installedin this APPL_TOP [YES] ? YES *Do you currently have concurrent program files installedin this APPL_TOP [YES] ? YES *Please enter the name Oracle Applications will use to identify this APPL_TOP.The APPL_TOP name you select must be unique within an Oracle ApplicationsSystem, must be from 1 to 30 characters long, may only containalphanumeric and underscore characters, and must start with a letter.Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".APPL_TOP Name [realsky] : realsky *You are about to use or modify Oracle Applications product tablesin your ORACLE database 'PROD'using ORACLE executables in '/ora11510/oracle/appvis/prodora/8.0.6'.Is this the correct database [Yes] ? YesAD Administration needs the password for your 'SYSTEM' ORACLE schemain order to determine your installation configuration.Enter the password for your 'SYSTEM' ORACLE schema: ***** Connecting to SYSTEM......Connected successfully.The ORACLE username specified below for Application Object Libraryuniquely identifies your existing product group: APPLSYSEnter the ORACLE password of Application Object Library [APPS] : ***** AD Administration is verifying your username/password.Connecting to APPLSYS......Connected successfully.The status of various features in this run of AD Administration is: <-Feature version in->Feature Active? APPLTOP Data model Flags------------------------------ ------- -------- ----------- -----------CHECKFILE Yes 1 1 Y N N Y N YPREREQ Yes 6 6 Y N N Y N YCONCURRENT_SESSIONS No 2 2 Y Y N Y Y NPATCH_TIMING Yes 2 2 Y N N Y N YPATCH_HIST_IN_DB Yes 6 6 Y N N Y N YSCHEMA_SWAP Yes 1 1 Y N N Y Y YConnecting to SYSTEM......Connected successfully.Connecting to APPLSYS......Connected successfully.Identifier for the current session is 1800Reading product information from file...Reading language and territory information from file...Reading language information from applUS.txt ...Reading database to see what industry is currently installed.Reading FND_LANGUAGES to see what is currently installed.Currently, the following language is installed:Code Language Status---- --------------------------------------- ---------US American English Base Your base language will be AMERICAN.Setting up module information.Reading database for information about the modules.Saving module information.Reading database for information about the products.Connecting to SYSTEM......Connected successfully.Connecting to APPLSYS......Connected successfully.Connecting to SYSTEM......Connected successfully.Reading database for information about how products depend on each other.Connecting to APPLSYS......Connected successfully.Reading topfile.txt ...Saving product information.Connecting to SYSTEM......Connected successfully.Connecting to APPLSYS......Connected successfully.AD code level : [11i.AD.I.2]Connecting to SYSTEM......Connected successfully.Connecting to APPS......Connected successfully.Connecting to APPLSYS......Connected successfully. AD Administration Main Menu -------------------------------------------------- 1. Generate Applications Files menu 2. Maintain Applications Files menu 3. Compile/Reload Applications Database Entities menu 4. Maintain Applications Database Entities menu 5. Change Maintenance Mode 6. Exit AD AdministrationEnter your choice [6] : 4 Maintain Applications Database Entities --------------------------------------------------- 1. Validate APPS schema 2. Re-create grants and synonyms for APPS schema 3. Maintain multi-lingual tables 4. Check DUAL table 5. Convert to Multiple Reporting Currencies 6. Return to Main MenuEnter your choice [6] : 6 AD Administration Main Menu -------------------------------------------------- 1. Generate Applications Files menu 2. Maintain Applications Files menu 3. Compile/Reload Applications Database Entities menu 4. Maintain Applications Database Entities menu 5. Change Maintenance Mode 6. Exit AD Administration 由于老是错误，所以多组织转换了很多次，今天忽然发现都没有mulit-org----那个选项了。 直接从linux里面的log文件弄出来的，显示的却是有点乱。记得BOB的文档有select mulit_org_flag FROM find_product_groups语句来检查是否多组织转换成功，而我从该语句的结果如下：
页:
[1]