Shulou(Shulou.com)06/01 Report--

1. Basic information of Oracle APP and DB

1. Application and database environment:

Application Node in Linux7.3

Database Node on Linux 7.3

2. Oracle EBS application version:

R12.2.6 on Linux7.3 xdye 86 (64bit)

3. Database information:

Oracle Database R12.1.0.2 on Linux 7.3 xylene 86 (64bit)

II. Implementation steps

1. Create a cux user in the database and authorize it. The relevant commands are as follows:

-- (1) create cux user CREATE USER CUX IDENTIFIED BY CUX DEFAULT TABLESPACE APPS_TS_TX_DATA TEMPORARY TABLESPACE TEMP1 PROFILE DEFAULT ACCOUNT UNLOCK;-- (2) authorize GRANT CONNECT and RESOURCE TO CUX; GRANT CREATE ANY CONTEXT TO CUX; GRANT CREATE ANY TYPE TO CUX; GRANT CREATE CLUSTER TO CUX; GRANT CREATE DATABASE LINK TO CUX; GRANT CREATE DIMENSION TO CUX; GRANT CREATE INDEXTYPE TO CUX; GRANT CREATE LIBRARY TO CUX; GRANT CREATE MATERIALIZED VIEW TO CUX to users who appear GRANT CREATE OPERATOR TO CUX; GRANT CREATE PROCEDURE TO CUX; GRANT CREATE PUBLIC SYNONYM TO CUX; GRANT CREATE SEQUENCE TO CUX; GRANT CREATE SYNONYM TO CUX; GRANT CREATE TABLE TO CUX; GRANT CREATE TRIGGER TO CUX; GRANT CREATE TYPE TO CUX; GRANT CREATE VIEW TO CUX;2, download patch 3636980 from the official Oracle website, patch p3636980_R12_GENERIC.zip. 3. Extract the patch p3636980_R12_GENERIC.zip and copy the following three files from p3636980_R12_GENERIC\ 3636980\ izu\ admin to the current user's desktop/. The file is as follows: izuprod.txt izuterr.txt newprods.txt4, izupord.txt renamed to cuxprod.txt,izuterr.txt, renamed to cuxterr.txt. The related commands are as follows: mv izupord.txt cuxprod.txt mv izuterr.txt cuxterr.txt 5. Open the cuxprod.txt file using a text editor, replace izu with cux, and replace IZU with CUX. % Splicer control file format 12.0.A # # $Header: newprods.txt 120.1 12:57:45 on 2006-09-20 jaobrien noship $# Section for Oracle Support Diagnostic Tools product=cux base_product_top=*APPL_TOP* oracle_schema=cux sizing_factor=100 main_tspace=APPS_TS_TX_DATA index_tspace=APPS_TS_TX_IDX temp_tspace=TEMP1 default_tspace=APPS_TS_TX_DATA # end of Oracle Support Diagnostic Tools 6, Open cuxprod.txt using a text editor Do the following: (1) replace all izu in the cuxprod.txt document with cux,IZU and CUX. (2) modify the applID of the product to more than 50000 of the APPLID that is not used. The SQL statement to check APPLID is as follows: SQL > select decode (count, 0, 'Selected number is Available',' Selected number already in use') Status & & enter_custom_applID selected_number from (select count (*) as count from (select 'x' from fnd_oracle_userid where oracle_id= & & enter_custom_applID union select 'x' from fnd_application where application_id= & & enter_custom_applID)) If you want to change 278 to 50303, type 50303 in enter_custom_applID. If Selected number is Available appears, 50303 is available.

7. Open cuxterr.txt using a text editor and do the following:

(1) replace izu with cux and IZU with CUX.

(2) modify Oracle_Support_Diagnostic_Tools to abcd_custom_appl

Copy the following three files to the $APPL_TOP/admin directory.

Cuxprod.txt

Cuxterr.txt

Newprods.txt

9. Change to the $APPL_TOP/admin directory and execute the following command

$adsplice Copyright (c) 2002, 2012 Oracle Corporation Redwood Shores, California, USA AD Splicer Version 12.2.0NOTE: You may not use this utility for custom development unless you have written permission from Oracle Corporation.Your default directory is'/ home/oraebs/apps/PROD/fs1/EBSapps/appl'.Is this the correct APPL_TOP [Yes]? AD Splicer records your AD Splicer session in a text fileyou specify. Enter your AD Splicer log file name or press [Return] to accept the default file name shown in brackets.Your default directory is'/ u01/app/oracle/fs1/EBSapps/appl'.Is this the correct APPL_TOP [Yes]? Filename [adsplice.log]: adsplice_xxont.logYou areabout to install or upgrade Oracle E-Business Suite product tablesin your ORACLE database 'D599'using ORACLE executables in' / u01/app/oracle/fs1/EBSapps/10.1.2'.Is this the correct database [Yes]? Enterthe password for Your 'SYSTEM' ORACLE schema:Enterthe ORACLE password of Application Object Library [APPS]: Pleaseenter the directory where your AD Splicer control file is located.The default directory is [/ u01/app/oracle/fs1/EBSapps/appl/admin]: Pleaseenter the name of your AD Splicer control file [newprods.txt]: Do youwish to regenerate your environment file [Yes]? Checkingif AutoConfig is enabled....RunningAutoConfig on: All products.

11. Check the results of adsplice and autoconfig execution through the following SQL statement.

Select * from fnd_application where application_short_name = 'CUX';select * from fnd_product_installations where APPLICATION_ID = 50303 X select * from dba_users where username =' CUX'

Log in to the user node and check the system environment.

$env | grep XXONTXXONT_TOP=/u01/app/oracle/fs1/EBSapps/appl/xxont/12.0.0$ ls $XXONT_TOPadmin log mesg out sql

If you are using a shared APPL_TOP, you need to perform all these procedures on one of the nodes, and then run autoconfig on the other nodes. You don't have to rerun adsplice. If the APPL_TOP is not shared, repeat steps 8, 9, 10 and 11.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.