Tag Archives: Setup - Page 3

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 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]

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.

Oracle Database 10.2 Upgrade Information Utility Output

Posted by on August 30, 2007 No comments

SQL> @ utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 08-30-2007 18:57:10
.
**********************************************************************
Database:
**********************************************************************
–> name: PROD
–> version: 9.2.0.8.0
–> compatible: 9.2.0
–> blocksize: 8192
.
**********************************************************************
Logfiles: [make adjustments in the current environment]
**********************************************************************
–> The existing log files are adequate. No changes are required.
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 7139 MB
–> CTXD tablespace is adequate for the upgrade.
…. minimum required size: 17 MB
–> APPLSYSD tablespace is adequate for the upgrade.
…. minimum required size: 18597 MB
–> CCTD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> ARD tablespace is adequate for the upgrade.
…. minimum required size: 268 MB
–> OKCD tablespace is adequate for the upgrade.
…. minimum required size: 33 MB
–> AMVD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> XNPD tablespace is adequate for the upgrade.
…. minimum required size: 9 MB
–> XDPD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> IEOD tablespace is adequate for the upgrade.
…. minimum required size: 4 MB
–> IBUD tablespace is adequate for the upgrade.
…. minimum required size: 1 MB
–> IEMD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> JTFD tablespace is adequate for the upgrade.
…. minimum required size: 63 MB
–> ASOD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
–> APPS_UNDOTS1 tablespace is adequate for the upgrade.
…. minimum required size: 286 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: –> “streams_pool_size” is not currently defined and needs a value of
at least 50331648
WARNING: –> “session_max_open_files” needs to be increased to at least 20
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
— No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
–> “optimizer_max_permutations”
–> “row_locking”
–> “undo_suppress_errors”
–> “log_archive_start”
–> “max_enabled_roles”
–> “enqueue_resources”
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
–> JServer JAVA Virtual Machine [upgrade] VALID
…The ‘JServer JAVA Virtual Machine’ JAccelerator (NCOMP)
…is required to be installed from the 10g Companion CD.
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [install]
–> Real Application Clusters [upgrade] INVALID
–> Oracle interMedia [upgrade] VALID
…The ‘Oracle interMedia Image Accelerator’ is
…required to be installed from the 10g Companion CD.
–> Spatial [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: –> Passwords exist in some database links.
…. Passwords will be encrypted during the upgrade.
…. Downgrade of database links with passwords is not supported.
WARNING: –> Deprecated CONNECT role granted to some user/roles.
…. CONNECT role after upgrade has only CREATE SESSION privilege.
WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 10g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS
…. CTXSYS
…. ORDSYS
…. MDSYS
WARNING: –> Database contains INVALID objects prior to upgrade.
…. USER APPS has 4 INVALID objects.
…. USER DISCOVERER has 1 INVALID objects.
…. USER PERFSTAT has 1 INVALID objects.
…. USER SPOTLIGHT has 2 INVALID objects.
…. USER SYS has 5 INVALID objects.
…. USER VTAS_I3_ORCL has 40 INVALID objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
–> New “SYSAUX” tablespace
…. minimum required size for database upgrade: 500 MB
.

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> spool off

Patch List – Production Upgrade

Posted by on August 12, 2007 No comments
Sno Patch Number Description Remarks
1 4238286 Tums
2 4712852 AD.i.4 Patch Got An issue while applying on
Apps Node while Relinking Refer
Log Notes
3 5107107 AutoConfig Update
Patch
4 4318672 Technology Stack
Utility Patch
5 9iAS Installation This Patch will Install This Step includes set of
iAS and Developer Patches which is same in Main
Project Plan
6 9i Upgrade Database Upgrade This steps includes set of
Patches which is same in Main
Project Plan
Note : After Database Upgrade Process
Got an issue while Starting up the Instance
Refer log Notes
7 3180164 New Product and New TBS
8 3480000 Maintenance Patch Got an Issue while applying on Admin Node
refer to Log Notes and also it took 3 days on
admin node
9 3275245 Online Help Patch This Patch Will be Applied after Go-Live
10 5117525 Jinitiator Upgrade Patch This patch should apply as a Part of Jinitiator
11 JDK Upgrade
12 5759055 TXK and ADX patch This Patch is should be applied as part of 10g
Upgrade as Pre-Reqs
13 4653225 10g Upgrade This Patch should as 10g pre-req Upgrade
14 10g Upgrade Actual 10g upgrade process
15 5753621 Receivables Patch
16 3636980 Diagnostic Patch
17 5529008 Diag Support Patch

Setting Up Custom GL Menus and Functions

Posted by on July 23, 2007 No comments

Step 1: Navigate to Security > Responsibility > Request. Enter a new record with a new Group, Application, and Code. Then enter a new Request type.

Step 2: Next, navigate to Application > Function. Press F11 and search for CS%FND%. Locate CS_FNDRSRUN. Click the Form tab. Copy and paste the Parameters value to text file.

Step 3: Insert a new record in Form Functions named MFGL_FNDRSRUN. Paste the copied value into the Parameters field and modify the APPL_SHORT_NAME.

Step 4: Get menu name: GL_SUPERUSER

Navigate to Security > Responsibility > Define. Search for the custom responsibility by pressing F11 and entering the searching string, then press Ctrl+F11.

Step 5: Navigate to Application > Menu. We want to modify the Import Journals and review data Menu. Pull up GL_SUPERUSER menu and click View Tree. Navigate to Journals, then Import. Right-click and choose Properties. Alternatively, search for GL%IMPORT%.

Step 6: The GL_SU_J_IMPORT menu appears. Insert a new menu line together with its Prompt and Function Name. Then Save.

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

Adding New User

Posted by on August 14, 2006 No comments

Go to Control Panel > Administrative Tools > Computer Management.

Click Action, and then click New User.

Enter the new user and password.

Navigate to Control Panel > User Accounts to change the group membership.

Setting Up Cash Management Open Interface

Posted by on July 27, 2005 No comments

In SQL*Plus, execute script ce_999_int.sql as user apps to create the interface table.
Ensure that the view was not changed before running script.
After running script, ensure that there are no invalid objects for owner CE.

#ce_999_int.sql
 create table ce.CE_999_INTERFACE
 (
 TRX_ID Number(15) unique,
 BANK_ACCOUNT_ID NUMBER(15) not null,
 TRX_TYPE VARCHAR2(20) not null,
 TRX_TYPE_DSP VARCHAR2(80) not null,
 TRX_DATE DATE not null,
 CURRENCY_CODE VARCHAR2(15) not null,
 STATUS VARCHAR2(15) not null,
 STATUS_DSP VARCHAR2(80) not null,
 AMOUNT NUMBER(17,2) not null,
 GL_DATE DATE not null,
 CREATION_DATE DATE not null,
 CREATED_BY NUMBER(15) not null,
 LAST_UPDATE_DATE DATE not null,
 LAST_UPDATED_BY NUMBER(15) not null,
 TRX_NUMBER VARCHAR2(15),
 EXCHANGE_RATE_TYPE VARCHAR2(30),
 EXCHANGE_RATE_DATE DATE,
 EXCHANGE_RATE NUMBER(17,2),
 CLEARED_AMOUNT NUMBER(17,2),
 CHARGES_AMOUNT NUMBER(17,2),
 ERROR_AMOUNT NUMBER(17,2),
 ACCTD_AMOUNT NUMBER(17,2),
 ACCTD_CLEARED_AMOUNT NUMBER(17,2),
 ACCTD_CHARGES_AMOUNT NUMBER(17,2),
 ACCTD_ERROR_AMOUNT NUMBER(17,2),
 CLEARED_DATE DATE
 )
 /
create or replace view apps.CE_999_INTERFACE_V
 as select
 ROWID ROW_ID,
 TRX_ID,
 BANK_ACCOUNT_ID,
 TRX_TYPE,
 TRX_TYPE_DSP,
 TRX_NUMBER,
 TRX_DATE,
 CURRENCY_CODE,
 STATUS,
 STATUS_DSP,
 AMOUNT,
 GL_DATE,
 CREATION_DATE,
 CREATED_BY,
 LAST_UPDATE_DATE,
 LAST_UPDATED_BY,
 EXCHANGE_RATE_TYPE,
 EXCHANGE_RATE_DATE,
 EXCHANGE_RATE,
 CLEARED_AMOUNT,
 CHARGES_AMOUNT,
 ERROR_AMOUNT,
 ACCTD_AMOUNT,
 ACCTD_CLEARED_AMOUNT,
 ACCTD_CHARGES_AMOUNT,
 ACCTD_ERROR_AMOUNT,
 CLEARED_DATE
 from CE.CE_999_INTERFACE
 /
 accept database char prompt 'Enter database to connect to: '
 connect apps/apps@&database
 rem compile all invalid database objects
 alter view CE_999_RECONCILED_V compile
 /
 alter view CE_999_TRANSACTIONS_V compile
 /
 alter view CE_AVAILABLE_TRANSACTIONS_V compile
 /
 alter view CE_RECONCILED_TRANSACTIONS_V compile
 /
 alter package CE_AUTO_BANK_CLEAR compile body
 /
 alter package CE_AUTO_BANK_MATCH compile body
 /

2. Start Enterprise Manager
On the database server, change directory to db/9.2.0
Source the database environment
run $oemapp dbastudio

Select the APPS schema
Select the CE_999_PKG body
Enable the clear and unclear procedures
Compile procedure bodies