Home > Developer > Mobile Develop

EBS Add custom Application Cux:custom application

Source: Internet
Author: User
Tags failover
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
<span id="Label3"></p><p><p><strong>1. Create database files and Accounts</strong></p></p> <p><p>[email protected] oracle]# su-oracle<br>[email protected] ~]$ Sqlplus/as sysdba</p></p> <p><p>Sql*plus:release 11.1.0.7.0-production on Sun 24 10:13:48 2015</p></p> <p><p>Copyright (c) 1982, the Oracle. All Rights Reserved.</p></p> <p><p><br>Connected to:<br>Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production<br>With the partitioning, OLAP, Data Mining and Real application testing options</p></p> <p><p>sql> Create tablespace cux_data datafile '/d01/oracle/vis/db/apps_st/data/cux_data01.dbf ' size 200M reuse autoextend On next 100M;</p></p> <p><p>Tablespace Created.</p></p> <p><p>sql> Create tablespace cux_index datafile '/d01/oracle/vis/db/apps_st/data/cux_index01.dbf ' size 200M reuse Autoextend on Next 100M;</p></p> <p><p>Tablespace Created.</p></p> <p><p>sql> Create temporary tablespace cux_temp tempfile '/d01/oracle/vis/db/apps_st/data/cux_temp01.dbf ' size 200M;</p></p> <p><p>Tablespace Created.</p></p> <p><p>Sql> create user Cux identified by cux default tablespace cux_data temporary tablespace cux_temp;</p></p> <p><p>User Created.</p></p> <p><p>Sql> Grant resource to cux;</p></p> <p><p>Grant Succeeded.</p></p> <p><p>Sql> Grant Connect to cux;</p></p> <p><p>Grant Succeeded.</p></p> <p><p>Sql> grant CREATE table to cux;</p></p> <p><p>Grant Succeeded.</p></p> <p><p>Sql> Grant CREATE view to cux;</p></p> <p><p>Grant Succeeded.</p></p> <p><p>Sql> Grant Create package to cux;<br>Grant Create package to Cux<br>*<br>ERROR at line 1:<br>Ora-00990:missing or invalid privilege</p></p> <p><p><br>Sql> Grant create synonym to cux;</p></p> <p><p>Grant Succeeded.</p></p> <p><p>Sql> Grant create sequence to cux;</p></p> <p><p>Grant Succeeded.</p></p> <p><p></p></p> <p><p><strong>2. Create a custom application file directory structure (ref. inv_top)</strong></p></p> <p>[email protected] ~]# Su-applmgr<br>[email protected] ~]$ CD $APPL _TOP/INV<br>[[email protected] inv]$ Find. -type d-exec mkdir-p $APPL _top/cux/{} \;<br>[email protected] inv]$ CD.<br>[email protected] appl]$ CD Cux<br>[email protected] cux]$ du<br>8./12.0.0/help/us<br>8./12.0.0/help/zhs<br>/12.0.0/help.<br>8./12.0.0/html<br>8./12.0.0/reports/us<br>8./12.0.0/reports/zhs<br>/12.0.0/reports.<br>8./12.0.0/log<br>8./12.0.0/lib<br>8./12.0.0/out<br>8./12.0.0/patch/115/import/us<br>8./12.0.0/patch/115/import/zhs<br>/12.0.0/patch/115/import.<br>8./12.0.0/patch/115/odf<br>8./12.0.0/patch/115/xdf<br>8./12.0.0/patch/115/irep/patch/115/import/us<br>/12.0.0/patch/115/irep/patch/115/import.<br>8./12.0.0/patch/115/irep/patch/115/odf<br>8./12.0.0/patch/115/irep/patch/115/sql<br>/12.0.0/patch/115/irep/patch/115.<br>/12.0.0/patch/115/irep/patch.<br>8./12.0.0/patch/115/irep/java/ebi/item/server<br>/12.0.0/patch/115/irep/java/ebi/item.<br>/12.0.0/patch/115/irep/java/ebi.<br>/12.0.0/patch/115/irep/java.<br>/12.0.0/patch/115/irep.<br>8./12.0.0/patch/115/xml/us<br>8./12.0.0/patch/115/xml/zhs<br>/12.0.0/patch/115/xml.<br>8./12.0.0/patch/115/driver<br>8./12.0.0/patch/115/publisher/templates/us<br>8./12.0.0/patch/115/publisher/templates/zhs<br>/12.0.0/patch/115/publisher/templates.<br>8./12.0.0/patch/115/publisher/defs<br>/12.0.0/patch/115/publisher.<br>8./12.0.0/patch/115/sql<br>216./12.0.0/patch/115<br>224./12.0.0/patch<br>8./12.0.0/java/make<br>8./12.0.0/java/jar<br>/12.0.0/java.<br>8./12.0.0/xml/orc115<br>/12.0.0/xml.<br>8./12.0.0/forms/us<br>8./12.0.0/forms/zhs<br>/12.0.0/forms.<br>8./12.0.0/mds/lov/webui/zhs<br>/12.0.0/mds/lov/webui.<br>8./12.0.0/mds/lov/consign/webui/zhs<br>/12.0.0/mds/lov/consign/webui.<br>/12.0.0/mds/lov/consign.<br>/12.0.0/mds/lov.<br>8./12.0.0/mds/wshtxn/server/zhs<br>/12.0.0/mds/wshtxn/server.<br>/12.0.0/mds/wshtxn.<br>8./12.0.0/mds/consign/webui/zhs<br>/12.0.0/mds/consign/webui.<br>/12.0.0/mds/consign.<br>8./12.0.0/mds/rcv/server/zhs<br>/12.0.0/mds/rcv/server.<br>/12.0.0/mds/rcv.<br>8./12.0.0/mds/attributesets/zhs<br>/12.0.0/mds/attributesets.<br>8./12.0.0/mds/txnui/webui/zhs<br>/12.0.0/mds/txnui/webui.<br>8./12.0.0/mds/txnui/lotdetails/webui/zhs<br>/12.0.0/mds/txnui/lotdetails/webui.<br>/12.0.0/mds/txnui/lotdetails.<br>8./12.0.0/mds/txnui/serialdetails/webui/zhs<br>/12.0.0/mds/txnui/serialdetails/webui.<br>/12.0.0/mds/txnui/serialdetails.<br>/12.0.0/mds/txnui.<br>216./12.0.0/mds<br>8./12.0.0/bin<br>8./12.0.0/mesg<br>8./12.0.0/admin/driver<br>8./12.0.0/admin/sql<br>/12.0.0/admin.<br>8./12.0.0/sql<br>640./12.0.0<br>648.</p><p><p></p></p><p><p><strong>3. Add custom app to automatic configuration file</strong></p></p> <p><p> [[email protected] ~]# su-applmgr <br> [[email protected] ~]$ cd $APPL _top <br> [[email protected] appl]$ Find. -name "*.env" <br>./ad/12.0.0/admin/template/appsora_ux.env <br>./ad/12.0.0/admin/template/adiasnt.env <br>./ad/ 12.0.0/admin/template/ad80nt.env <br>./ad/12.0.0/admin/template/install/template/db/ad8idbux.env <br>./ad/12.0.0 /admin/template/install/template/db/ad8idbnt.env <br>./ad/12.0.0/admin/template/applsys_nt.env <br>./ad/12.0.0/ Admin/template/applsys_ux.env <br>./ad/12.0.0/admin/template/adovars_nt.env <br>./ad/12.0.0/admin/template/ Adiasux.env <br>./ad/12.0.0/admin/template/appsora_nt.env <br>./ad/12.0.0/admin/template/adovars_ux.env <br>./ad/ 12.0.0/admin/template/ad80ux.env <br>./asg/12.0.0/admin/template/asgovars_nt.env <br>./asg/12.0.0/admin/template /asgovars_ux.env <br>./fnd/12.0.0/fndenv.env <br>./fnd/12.0.0/usrxit/devenv.env <br>./appsvis_ebs12vis.env <br>. Vis_ebs12vis.env <br>./admin/adovars.env <br> [[email protected] appl]$ vi vis_ebs12vis.env </p></p> <p><p>#!/bin/sh<br>#<br># $Header: applsys_ux.env 120.29.12010000.3 2009/01/11 17:35:23 mmanku ship $<br>#<br># ###############################################################<br>#<br># This file was automatically generated by AutoConfig. It would be read and<br># Overwritten. If you were instructed to edit the this file, or if your is not<br># able to use the settings created by AutoConfig, refer to Metalink Note<br># 387859.1 for Assistance.<br>#<br># ###############################################################</p></p> <p><p>#</p></p> <p><p>############################<br># Set The variables required<br>############################</p></p> <p><p>afjsmarg= "-server-xmx384m-xx:newratio=2-xx:+useserialgc-doracle.apps.fnd.common.pool.leak.mode=stderr:off- Verbose<br>gc<br>Export Afjsmarg</p></p> <p><p>afjcparg= "-client"<br>Export Afjcparg</p></p> <p><p>applrgf= "/d01/applmgr/vis/inst/apps/vis_ebs12vis/logs/appl/rgf"<br>Export APPLRGF</p></p> <p><p>cntl_break= "on"<br>Export Cntl_break</p></p> <p><p>Oracle_term= "vt220"<br>Export Oracle_term</p></p> <p><p>/context_file<br># Define Apps_jdbc_url<br>######################</p></p> <p><p>Apps_jdbc_url= "jdbc:oracle:thin:@ (description= (address_list= (load_balance=yes) (failover=yes) (ADDRESS=) (PROTOCOL =tcp) (HOS<br>T=ebs12vis.oracle.com) (port=1521))) (connect_data= (service_name=vis))) "<br>Export Apps_jdbc_url</p></p> <p><p>##########################################<br># Define Ad_apps_jdbc_url for AD Utilities<br>##########################################</p></p> <p><p>Temp_apps_jdbc_url= "jdbc:oracle:thin:@ (description= (address_list= (load_balance=yes) (FAILOVER=YES) (ADDRESS= ( Protocol=tcp<br>(host=ebs12vis.oracle.com) (port=1521))) (connect_data= (service_name=vis))) "<br>Ad_apps_jdbc_url= ' echo $TEMP _apps_jdbc_url | Cut-d "@"-f2 '<br>Export Ad_apps_jdbc_url</p></p> <p><p>####################################################################<br># The Context_file variable stores the location of the CONTEXT FILE.<br>####################################################################</p></p> <p><p>Context_file= "/d01/applmgr/vis/inst/apps/vis_ebs12vis/appl/admin/vis_ebs12vis.xml"<br>Export Context_file</p></p> <p><p>####################################################################<br># The Context_name variable stores the value for the current CONTEXT<br>####################################################################</p></p> <p><p>Context_name= "vis_ebs12vis"<br>Export Context_name</p></p> <p><p>########################################################<br># The APPLFENV variable is the filename of this file.<br># If You rename the This file and you should the change of this Value.<br>########################################################<br>[email protected] ~]$ CD $INST _top/appl/admin<br>[email protected] appl]$ VI vis_ebs12vis.xml</p></p> <p><p><au_top oa_var= "s_autop" oa_type= "prod_top" oa_enabled= "FALSE" >/d01/applmgr/vis/apps/apps_st/appl/au/12.0.0 </AU_TOP><br><cux_top oa_var= "s_cuxtop" oa_type= "prod_top" oa_enabled= "FALSE" >/d01/applmgr/vis/apps/apps_st/appl/cux/ 12.0.0</cux_top><br><gwyuid oa_var= "s_gwyuid" >APPLSYSPUB/PUB</GWYUID><br></p></p> <p><p><strong>Application Developer ==> <strong>application </strong>==> Register</strong></p></p> <p><p></p></p> <p><p><strong>System Administrator ==> Security ==> ORACLE ==> Register</strong></p></p> <p><p></p></p> <p><p><strong>System Administrator ==> Security ==> ORACLE ==> datagroup</strong></p></p> <p><p></p></p> <p><p></p></p> <p><p><strong>Alter Manager ==> System ==> installations</strong></p></p> <p><p></p></p> <p><p></p></p> <p><p><strong>4. Custom Application Cux application apps_ddl, APPS_ARRAY_DDL</strong></p></p> <p><p>sql> @ $AD _top/admin/sql/adaaddls.pls system_pword Custom_schema Custom_schema_pword<br>sql> @ $AD _top/admin/sql/adaaddlb.pls system_pword Custom_schema Custom_schema_pword</p></p> <p><p></p></p> <p><p><strong>5. Restart the EBS Application layer service</strong></p></p>[email protected] ~]$ CD $INST _home/admin/scripts<br>[email protected] appl]$ sh adstpall.sh apps/apps<br>[email protected] cux]$ sh adstrtal.sh apps/apps<p><p>EBS Add custom Application Cux:custom application</p></p></span>

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
how to add application in iis 7 uart application tag application render application pha application claires application mtp application

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More