Category Archives: ERP - Page 15

Configuring VNC to Use Gnome

Posted by on March 28, 2008 No comments

Problem: On CentOS 4.8, logging into VNC session on server for first time does not show Gnome session.

Solution: Edit the VNC xstartup file.

Edit the ~/.vnc/startup and replace the line

# xterm -geometry 80×24+10+10 -ls -title “$VNCDESKTOP Desktop” &

twm &

with

gnome-session &

When vncserver is first run, the xstartup file should be similar to the following:

[oracle@localhost ~]$ cat .vnc/xstartup
#!/bin/sh

# Uncomment the following two lines for normal desktop:
# unset SESSION_MANAGER
# exec /etc/X11/xinit/xinitrc

[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
twm &

After replacing the last line, the xstartup file should now appear as follows:

[oracle@localhost ~]$ cat .vnc/xstartup
#!/bin/sh

# Uncomment the following two lines for normal desktop:
# unset SESSION_MANAGER
# exec /etc/X11/xinit/xinitrc

[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
gnome-session &

After running vncserver, if the GNOME desktop GUI does not load when you connect with the VNC viewer, then try replacing the contents of xstartup with the following:

#!/bin/sh
# Add the following line to ensure you always have an xterm available.
( while true ; do xterm ; done ) &
# Uncomment the following two lines for normal desktop:
unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc
[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
gnome-session &

Note that you need to kill the vncserver session and restart it for the changes to take effect. For example, to kill the vncserver session 1, issue the following command:

vncserver -kill :1

Then rerun ‘vncserver’ to restart the VNC server session and reconnect with the VNC viewer.

Reference:

http://wiki.centos.org/HowTos/VNC-Server

 

Installing Oracle Applications 11i Checklist

Posted by on March 7, 2008 No comments

This is a list of steps to check for when installing Oracle Applications.

Step 1:        Ensure that hostname and IP address are in hosts file. Under Windows, ensure that in the hosts file, the hostname is in the following order:

127.0.0.1                    localhost.localdomain                       localhost

xx.xx.xx.xx               hostname.domainname                   alias

Step 2:        Ping machine. It should return:

C:> ping alias

Pinging hostname.domainname [xx.xx.xx.xx] with 32 bytes of data:

Step 3:        Create domain user applmgr and ensure that it is assigned to the Administrators group of the local machine.

Step 4:        Install Visual C++ 6.0 to C:VC98 and apply service pack 4

Step 5:        Install Cygwin to C:cygwin (see Metalink document “Using Cygwin to Maintain Release 11i on Windows” Doc ID:302859.1 for packages to download).

Step 6:        To compile GNU Make, run VCVARS.bat from Visual C++ directory and in the gnumake-3.79.1 directory, run build_w32.bat twice. Copy gnumake.exe to c:cygwinbin (or C:mksntmksnt).

Step 7:        Install Microsoft XML Parser (MSXML) 3.0 Service Pack 4 or later SDK. Copy file from Microsoft XML Parserlib to C:VC98lib.( 11.5.9)

Step 8:        Install Java SDK 1.3.1_18 (11.5.9) (or 1.3.1_15?)

Step 9:        Install Perl (download ActivePerl from http://www.perl.com) (11.5.10)

Step 10:   Copy zip.exe and unzip.exe to C:mksntmksnt

Step 11:    Ensure that all files are on the path:

which gnumake

which perl

which zip

which cc

which link

Modify path if necessary to include: C:Perlbin; C:cygwinbin;C:VC98bin.

Step 12:   Ensure correct versions of Perl and Java installed:

Perl –version

ActivePerl version should be v5.8.8

On Linux, Perl should be 5.003 or later

Java –version

Should be 1.3.1_18

Step 13:   Set TEMP and TMP environment variables for user applmgr to C:TEMP.

Step 14:   Check manual on startCD for instructions on directory structure (11.5.9).

Step 15:   Set up staging area.

Installing Oracle Applications Release 12 on Demo Laptop (OEL 5.1)

Posted by on January 8, 2008 No comments

Installing Oracle Applications Release 12 on Demo Laptop (OEL 5.1)

1. Installed OEL 5.1 on 160GB hard drive: 100MB /boot; 6GB swap; remaining space /

2. Created user applmgr on initial setup

3. Created group dba, assigned group dba to user applmgr, made dba primary (and only) group for applmgr

4. On appslinux, assigned ip address and hostname (200.65.1.57, demolinux) to /etc/hosts
On demolinux, assigned ip address and hostname (200.65.1.56, appslinux) to /etc/hosts

5. On appslinux, edited /etc/exports (as root user) to include demolinux:
/u4   200.65.1.57(rw,sync)

6. Restart nfs service (as root user) on appslinux:
service nfs restart

7. On demolinux (as root user):
mkdir /mnt/u4
mount -t nfs appslinux:/u4 /mnt/u4

8. On demolinux (as root user):
mkdir /oracle
chown applmgr:dba /oracle

9. Load the /mnt/u4/StageR12/startCD/welcome.html into Firefox
Open the Rapid Install installation PDF

10. On demolinux, ensure that /tmp is accessible by all users (chmod 777 /tmp)

11. On demolinux, ensure that required maintenance tools are present:
which ar
which ld
which gcc
which g++
which ksh
which make

12. Check Metalink Doc ID: 402310.1 to ensure

a. Ensure that OS version is supported:
Minimum: Oracle Enterprise Linux: 4.0 – Update 4 or higher (32-bit)
Current: Oracle Enterprise Linux Release 5 – Update 1 [ok]

b. Ensure that kernel version is supported
Minimum: Oracle Enterprise Linux: 2.6.9-42.0.0.0.1.EL
Current: Oracle Enterprise Linux: 2.6.18-53.elPAE [ok]

13. Manually installed the following RPMs:
compat-libstdc++-296-2.96-138.i386.rpm [CD 2]
openmotif22-2.2.3-18.i386 [CD 3]

pdksh
gnome-libs
sysstat-7.0.0-3.el5.i386 [CD 3]
compat-db-4.2.52-5.1.i386.rpm [CD 3]
xscreensaver
libaio-devel-0.3.106-3.2.i386.rpm [CD 2]

Changing Logo on OA Portal Home Page

Posted by on December 13, 2007 No comments

This documentation shows how to change the company logo on the Oracle Applications Portal Home page. This documentation uses Linux commands; substitute Windows commands as necessary.

Problem: The logo on the portal home page is the Oracle logo. The company logo is needed instead.

Solution: Locate the logo image file on the file system and replace it with the company logo.

Step 1: Create a new GIF file with the company logo. Resize the logo so that it no more than 70 pixels in height.

Step 2: Navigate to $COMMON_TOP/portal/$CONTEXT_NAME, e.g.

cd /emcb/test/testcomn/portal/TEST_utterptest

Step 3: Copy the new company logo to the above directory.

Step 4: Backup the original logo by copying it a file with extension OLD, e.g.

cp appsmed3.gif appsmed3.old

Step 5: Copy the new logo to appsmed3.gif, e.g.

cp newlogo.gif appsmed3.gif

The logo is changed on the portal home page.

Reports Developer Quirks and Tips

Posted by on November 23, 2007 No comments

1. To change the orientation of a report, navigate to Layout Model > Main Section. Bring up Property Palette. Change the Report Width and Report Height under Character Mode e.g. 132 x 66.

2. To view the output as it would appear in Oracle Applications, navigate to Data Model > System Parameters > MODE. Set the Initial Value under Parameter to Character.

3. For Oracle reports that will be registered in Oracle Applications, set the format of the date parameter in the Oracle report to Input Mask:
RRRR/MM/DD HH24:MI:SS

4. Set the corresponding parameter’s format in the Oracle Application concurrent program definition to Date (FND_STANDARD_DATE).

5. When using date parameters in the Where clause of the query, use:
LAST_UPDATE_DATE >=  :P_START_DATE
Not TO_CHAR (:P_START_DATE) or TO_DATE(:P_START_DATE)

6. Colour each frame with a different background to easily identify and distinguish them.

7. To break the page on a frame, change the property ‘Maximum Records per Page’ from 0 to 1.

8. Ensure that the Token field for the Parameter for the Concurrent program matches the user parameters for the Oracle Report.

9. To reset page numbers on a group, insert a field in the layout. Set the source at Physical page number. In the properties for the field you will see field Page Numbering below format mask field. Here you can reset the page numbers according to the group for PO.

10. To get a summary field by group name, in the Data Model view, click on the Summary Column button and then click on the group to enter it in.

11. REP-1212: Object ‘Body’ is not fully enclosed by its enclosing object ”.
Set the Output Style in the Concurrent Program definition for the report to a wider style (either Landscape or Landwide).

Installing Oracle Applications Release 11.5.9 on Linux

Posted by on September 28, 2007 No comments

Red Hat Enterprise Linux AS 3

Installation

(Red Hat Enterprise Linux AS release 3 under a Vmware virtual machine)

Refer to Metalink Doc ID:  Note: 234783.1 (Subject:  Oracle Applications 11.5.9 – Installation Update Notes for Linux x86 – B10849-01)

Step 1:        For a single-user install, create user applmgr (UID 500, GID 500) and assign it to the dba group (GID 501). Make the primary group of user applmgr ‘dba’.

Step 2:        Ensure that at least 2GB RAM is allocated and a 4GB swapfile exists. If possible, set the number of CPUs to 2.

Step 3:        Necessary packages must exist on the system (current ones shown in brackets):

  1. binutils-2.14.90.0.4-35 [binutils-2.14.90.0.4-26]
  2. compat-db-4.0.14-5 [ok]
  3. compat-gcc-7.3-2.96.122 [ok]
  4. compat-gcc-c++-7.3-2.96.122 [ok]
  5. compat-libstdc++-7.3-2.96.122 [ok]
  6. gcc-3.2.3-42 [gcc-3.2.3-20]
  7. gcc-c++-3.2.3-42 gcc-c++-3.2.3-20]
  8. glibc-2.3.2-95.27 [glibc-2.3.2-95.3]
  9. glibc-common-2.3.2-95.27 glibc-common-2.3.2-95.3]
  10. gnome-libs-1.4.1.2.90-34.1 [x]
  11. libaio-0.3.96-5 [libaio-0.3.96-3]
  12. libaio-devel-0.3.96-5 [libaio-devel-0.3.96-3]
  13. libgcc-3.2.3-42 [libgcc-3.2.3-20]
  14. libstdc++-3.2.3-42 [libstdc++-3.2.3-20]
  15. libstdc++-devel-3.2.3-42 [libstdc++-devel-3.2.3-20]
  16. make-3.79.1-17 [ok]
  17. openmotif21-2.1.30-8 [ok]
  18. pdksh-5.2.14-21 [ok]
  19. setarch-1.3-1 [ok]
  20. sysstat-4.0.7-4.EL3.3 [x]

sysstat-4.0.7-4.EL3.3 – RHEL AS 3 CD 2

gnome-libs-1.4.1.2.90-34.1 – RHEL AS 3 CD 3

Or load Add/Remove Programs and include:

  1. GNOME Software Development
  2. System Tools [sysstat]
  3. Legacy Development Tools

From Metalink Doc ID: 234783.1, the following are required RPMs:

  • compat-db-4.0.14.5 [Red Hat CD 3]
  • compat-gcc-7.3-2.96.122
  • compat-gcc-c++-7.3.2.96.122
  • compat-libstdc++-devel-7.3-2.96.122
  • openmotif21-2.1.30-8.i386.rpm [Red Hat CD 3 – MUST be installed manually]
  • setarch-1.3-1

Step 4:        Ensure that the following utilities are present by issuing it as a parameter to the ‘which’ command.

  • which ar
  • which cc
  • which ld
  • which make

Step 5:        Ensure that the JRE JDK 1.3.1_11 is installed. Download the RPM bin file from http://java.sun.com/products /archive/. Execute the .bin file to extract the RPM file (Legacy Development Tools must be installed from Add/Remove Programs). When run, the RPM creates the /usr/java/jdk1.3.1_11 directory. Create a softlink in /usr/local/bin to the /usr/java/jdk1.3.1_11/bin/java file. Verify that java works by running java –version from the terminal.

Step 6:         Insert the first CD (Start Here) and copy the CD to the staging area:

mkdir /u4/stage1159

mkdir startCD

mkdir Disk1

cd /u4/stage1159/startCD/Disk1

cp –r /media/cdrom/* .

About 33GB of disk space is required to set up the staging area.

Step 7:        Download and apply patch 3006854.

Step 8:        On the console of appslinux (not VNC), start Rapid Install by running rapidwiz (located in script /home/applmgr/setup1159.env):

unset LANG (this is EXTREMELY important!)

setarch i386

export DISPLAY=:0.0

echo $DISPLAY

cd /u0/stage1159/startCD/Disk1/rapidwiz

./rapidwiz

Follow the wizard to completion. See Metalink Doc IDs: 466544.996, 640827.995 and 234783.1.

Refer to the “Installing Oracle Applications: A Guide to Using Rapid Install Release 11i (11.5.10)” (r11510ins.pdf) for more information.

Resolving REP-3000 Error

Posted by on July 19, 2007 No comments

Problem: When the Active Users (PDF) report is run, it completes in error with the following log file:

+---------------------------------------------------------------------------+
Application Object Library: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FNDSCURSPDF module: Active Users (PDF)
+---------------------------------------------------------------------------+
Current system time is 17-JUL-2007 11:37:42
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
APPLLCSP Environment Variable set to :
XML_REPORTS_XENVIRONMENT is :
/u2/oracle/vis2ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XENVIRONMENT is set to:  /u2/oracle/vis2ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8
'.,'
Spawned Process 27647
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
Report Builder: Release 6.0.8.24.0 - Production on Tue Jul 17 11:37:53 2007
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
Enter Username:
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 3019814.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 17-JUL-2007 11:38:06
+---------------------------------------------------------------------------+

Solution: Change the DISPLAY environment variable in Oracle Applications.

Log on to Oracle Applications Manager, and navigate to Site Map > AutoConfig.

There are two context files: one for the Database tier and the other for the Applications Tier. In the Applications tier row, click Edit Parameters. Click the Environments tab. Expand oa_environment:generic_service. Under X11 Display (s_display), change ‘hostname:0.0’ to ‘:0.0’. Save the changes. Then log out of Oracle Applications Manager.

The context file for the application tier must be regenerated. On the server, source the environment, stop the application tier services (adstpall.sh), run AutoConfig on the application tier (adconfig.sh), then restart the application tier services (adstrtal.sh).

Refer to:

Metalink Doc ID: Note: 181244.1

Subject:  Configuring VNC Or XVFB As The X Server For Applications 11i

Metalink Doc ID: Note: 200474.1

Subject:  Comprehensive REP-3000 Troubleshooting and Overview Guide

Registering New Active Users Report

Posted by on July 16, 2007 No comments

This documentation illustrates how to copy an existing report to a new report and register it in Oracle Applications. The Active Users report shall be used as an example.

Step 1:        Log on to Oracle Applications and choose the System Administrator responsibility. Navigate to Concurrent > Program > Define.

Step 2:        The Concurrent Programs form appears. Press F11 and type ‘Active%’ in the Program field. Then press Ctrl+F11.

Step 3:        The Active Users program appears in the form. Click the Copy To button.

Step 4:        The Copy To form appears. Enter ‘Active Users (PDF)’ in the Program field, and ‘FNDSCURSPDF’ in the Short Name field. Then click OK.

Step 5:        The Active Users (PDF) program appears in the form. Change the Output Format field to ‘PDF’. Then click Save.

Step 6:        Navigate to Security > Responsibility > Define. The Responsibilities form appears. Press F11. Type ‘System Administrator’ in the Responsibility Name field and ‘System Administration’ in the Application field, and press Ctrl+F11.

Note the Request Group Name and Application.

Step 7:        Navigate to Security > Responsibility > Request. The Request Group form appears. Press F11 and type ‘System Administrator Reports’ in the Group field and ‘Application Object Library’ in the Application field. Then press Ctrl+F11.

Step 8:        Select the record to insert the new record under, then click New. In the Name field, select ‘Active Users (PDF)’ from the list. Then click Save.

Step 9:        The report now appears in the Concurrent Requests list under System Administrator.

Step 10:   If there are any issues viewing the PDF reports, it may be necessary to change the PDF profile options. Search for ‘PDF’ or ‘Viewer’.

Installing Oracle Application Express

Posted by on July 10, 2007 No comments

This documentation shows the steps covered in installing Oracle Application Express.

Refer to: http://www.oracle.com/technology/products/database/application_express/index.html

10gR1 Installation

Step 1:        Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.

Step 2:        Install HTML DB from Oracle Database 10g Companion CD.

Step 3:        Point browser to http://oracleserver.support.com:7777/pls/htmldb

 

10gR2 Installation

Step 1:        Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.

Issue encountered where it was not able to write to directory. It was defaulting to D:oracleoradata for the data files. This is the CD-ROM drive, so I had to do Advanced installation and specify E:oracleoradata.

Step 2:        Install HTML DB from Oracle Database 10g Companion CD.

Step 3:        Point browser to http://oracleserver.support.com:7777/pls/htmldb

VIS12 Installation

Step 1:        Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.

Step 2:        To determine products installed, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/ and source the environment

(. ./VIS12_appslinux.env).

Step 3:        Next, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/oui/bin and run runInstaller (./runInstaller)

Step 4:        Download and install the apex_3.0.zip file from Oracle.com onto any directory that applmgr owns (e.g. /u0).

Step 5:        Unzip apex_3.0.zip into the /u0 directory.

[applmgr@appslinux 9.2.0]$ cd /u0/
[applmgr@appslinux u0]$ unzip apex_3.0.zip

Step 6:        The VIS12 instance shall be used. Navigate to the VIS12 10.2.0 Oracle Home and source the environment.

[applmgr@appslinux u0]$ cd /u5/oracle/VIS12/db/tech_st /10.2.0/
[applmgr@appslinux 10.2.0]$ . ./VIS12_appslinux.env
[applmgr@appslinux apex]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 10 18:29:00 2007
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select tablespace_name from dba_tablespaces order by 1;
TABLESPACE_NAME
------------------------------
APPS_CALCLIP
APPS_OMO
APPS_TS_ARCHIVE
APPS_TS_DISCO
APPS_TS_DISCO_OLAP
APPS_TS_INTERFACE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TOOLS
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_UNDOTS1
B2B_DT
B2B_IDX
B2B_LOB
B2B_RT
BAM
CTXSYS
CWMLITE
DCM
DISCO_PTM5_CACHE
DISCO_PTM5_META
DSGATEWAY_TAB
GEOR_TBS
HTMLDB
IAS_META
MTR
NOETIX
NON_APPS_TS_DATA
OCATS
ODM_DATA
OLTS_ATTRSTORE
OLTS_BATTRSTORE
OLTS_CT_STORE
OLTS_DEFAULT
OLTS_SVRMGSTORE
OPMOR
ORABPEL
OWAPUB
PORTAL
PORTAL_DOC
SYNCSERVER
SYSAUX
SYSTEM
TEMP1
TEMP2
XDB
55 rows selected.
SQL>

VIS4 Installation

Step 7:        Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.

Step 8:        Download and install the apex_3.0.zip file from Metalink onto any directory that applmgr owns (e.g. /u0).

Step 9:        Unzip apex_3.0.zip into the /u3 directory.

[applmgr@appslinux 9.2.0]$ cd /u0/
[applmgr@appslinux u3]$ unzip apex_3.0.zip

Step 10:   The VIS4 instance shall be used. Navigate to the VIS4 9.2.0 Oracle Home and source the environment.

[applmgr@appslinux u3]$ cd /u3/oracle/vis4db/9.2.0/
[applmgr@appslinux 9.2.0]$ . ./VIS4_appslinux.env

Step 11:    Change directory to the apex working directory.

[applmgr@appslinux u3]$ cd /u0/apex
[applmgr@appslinux apex]$ ls
apex_epg_config11.sql  core
apex_epg_config.sql    coreins.sql
apexins.sql            doc
apexvalidate.sql       images
apxconf.sql            load_trans.sql
apxremov.sql           owa
apxxepwd.sql           utilities
builder                welcome.html

Step 12:   Log on to sqlplus and check if the required tablespaces exist:

[applmgr@appslinux apex]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Jun  27 10:51:04 2007
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Pro duction
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> select tablespace_name from dba_tablespaces order by 1;
TABLESPACE_NAME
------------------------------
APPS_TS_ARCHIVE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_TX_INTERFACE
APPS_UNDOTS1
CTXSYS
TABLESPACE_NAME
------------------------------
DATA
ODM
OLAP
OWAPUB
PORTAL
SYNCSERVER
SYSTEM
TEMP
19 rows selected.

Step 13:   The Temp tablespace exists, but there is no SYSAUX. This tablespace shall be created for use with APEX.

SQL> create tablespace sysaux
datafile '/u3/oracle/vis4data/sysaux.dbf' size 32M
autoextend on
maxsize unlimited
permanent
online
extent management local;
Tablespace created.

Step 14:   Run the command:

SQL> @ apexins oracle sysaux sysaux temp /i/

Step 15:   Run the command:

SQL> @apex_epg_config11 /u0

Step 16:   Run the command:

SQL> alter user anonymous account unlock;
User altered.

Step 17:   Run the command:

SQL> select dbms_xdb.gethttpport from dual;
GETHTTPPORT
-----------
0

Step 18:   Run the command:

SQL> exec dbms_xdb.sethttpport(8080);

Step 19:   Run the command:

[applmgr@appslinux ~]$ cd /u5/oracle/VIS12/apps/apps_st/ appl/
[applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env
[applmgr@appslinux appl]$ cp -rf /u0/apex/images/ /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/Apache/

To source 9.2.0 RDMBS environment:

cd /u5/oracle/VIS12/db/tech_st/10.2.0/
. ./VIS12_appslinux.env
[applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env
[applmgr@appslinux appl]$ echo $ORACLE_HOME
/u5/oracle/VIS12/apps/tech_st/10.1.2 (INCORRECT HTTPD HOME)

SQL to remove schemas after a failed new installation

drop user flows_030000 cascade;
drop user flows_files cascade;

SQL to remove Oracle Application Express from the Database

@apxremov.sql
drop user FLOWS_010500 cascade;
drop user FLOWS_020000 cascade;
select username from dba_users order by 1;
select owner, object_name, object_type, status from dba_objects where status = ‘INVALID’;

SQL to install Oracle Application Express from the Database

@apexins oracle sysaux sysaux temp1 /i/

THE BELOW IS CORRECT:

/u5/oracle/VIS12/inst/apps/VIS12_appslinux/ora/10.1.3

Location of updated dads.conf: /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/modplsql/conf

Log file:

/u5/oracle/VIS12/inst/apps/VIS12_appslinux/logs/ora/10.1.3/Apache/

To stop and start HTTP server:

/u5/oracle/VIS12/inst/apps/VIS12_appslinux/admin/scripts

ORA-06502 Saving Work Order

Posted by on June 4, 2007 No comments

Problem: The following error is occurring:

The following errors occur when trying to update operations of Firm work orders:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at “APPS.FND_MESSAGE”, line 418

ORA-06512: at “APPS.FND_MESSAGE”, line 461

ORA-06512: at “APPS.FND_MESSAGE”, line 585

ORA-06512: at “APPS.FND_MESSAGE”, line 537

ORA-06512: at “APPS.APP_EXCEPTION”, line 42

ORA-06512: at “APPS.EAM_WORKORDER_UTIL_PKG”, line 1165

ORA-06512: at “APPS.EAM_OPERATIONS_PKG”, line 347

Steps to Reproduce Issue:

  1. Log on as user operations
  2. Enterprise Asset Management
  3. Work Orders > Work Order
  4. Seattle Maintenance
  5. WO90203
  6. Click Operations
  7. When the start and end time is changed, error occurs.

Solution: Apply Patch 4432063.

Refer to Metalink Doc ID: 357568.1 (Error ‘ORA-06502’ Occurs When Saving Changes To Work Order Operation)