Troubleshooting instance after cloning

Posted by on May 29, 2008 No comments

Situation: After reinstalling Red Hat Enterprise Linux AS 4 on the server and restoring Oracle Applications, the instance is started.

Problem: When accessing page http://ebusiness.support.com:8001/oa_servlets/AppsLogin, the following error is encountered:

Internet Explorer cannot display the webpage

   Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.

   What you can try:
     Diagnose Connection Problems  

     More information 

This problem can be caused by a variety of issues, including: 

Internet connectivity has been lost.
The website is temporarily unavailable.
The Domain Name Server (DNS) is not reachable.
The Domain Name Server (DNS) does not have a listing for the website's domain.
If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section. 

For offline users

You can still view subscribed feeds and some recently viewed webpages.
To view subscribed feeds 

Click the Favorites Center button , click Feeds, and then click the feed you want to view. 

To view recently visited webpages (might not work on all pages) 

Click Tools , and then click Work Offline.
Click the Favorites Center button , click History, and then click the page you want to view.

Solution: Apply patch 4198954. Create a directory 4198954, copy the patch into this directory and extract the patch (two RPMS and README). Install the RPMS using rpm -ivh … . The RPMS install without issue

Then reran patch 3830807. Relink Application files using adadmin, use all defaults for the relink (takes about ten minutes).
Did not work.

Updated /etc/hosts

Checked Apache logs

/u0/oracle/testora/iAS/Apache/Apache/logs/error_log
/u0/oracle/testora/iAS/Apache/Jserv/logs/mod_jserv.log

See Metalink Doc ID: Note: 231137.1 “Troubleshooting the Self Service Framework with Oracle Applications”

Search for: File does not exist: /oa_servlets/AppsLogin
See Metalink Doc ID: Note: 344379.1  “Subject:  File Not Found /oa_servlets/AppsLogin”

http://ebusiness.support.com:8001/pls/TEST/fnd_web.ping

http://ebusiness.support.com:8001/OA_HTML/US/ICXINDEX.htm

ftp /usr/java/j2sdk-1_3_1_11-linux-i586.rpm.bin from 200.65.1.86 into the /usr/java (make this directory if necessary)
chmod a+x j2sdk-1_3_1_11-linux-i586.rpm.bin
Unzips jdk-1.3.1_11.i586.rpm
rpm -ivh jdk-1.3.1_11.i586.rpm

SUCCESS! Page appears.

Installing Oracle Applications Release 11.5.10.2 on Demo Laptop (Windows 2000 Pro)

Posted by on May 29, 2008 No comments

Installing Oracle Applications Release 11.5.10.2 on Demo Laptop (Windows 2000 Pro)
———————————————————————————-

See Metalink Doc ID:  Note: 316806.1 (Subject: Oracle Applications Installation Update Notes, Release 11i (11.5.10.2))

1. Installed Windows 2000 Pro on 160GB hard drive: C: 160GB
Formatting C: as NTFS took about 1 hour
Setup copied all files on hard drive

2. Under Personalize Your Software:
Name: applmgr
Organization: Illuminat

3. Under Computer Name and Administrator Password
Computer name: APPSWINDOWS
Administrator password: <leave blank>

4. Install Windows 2000 Service Pack 4.

5.
******************************************
THIS WORKS: ENABLE LOOPBACK ADAPTER & DISABLE NETWORK ADAPTER
SET LOOPBACK ADAPTER TO STATIC IP ADDRESS
IP: x.x.x.x
GATEWAY: 255.255.255.0

PRIMARY DNS: x.x.x.x
SECONDARY DNS: x.x.x.x
******************************************

6. Install a printer (any printer will do, for example EPSON FX-80)

7. Make directory C:TEMP. Point environment variable to TEMP, TMP and TMPDIR to C:TEMP.

8. Install MKS Toolkit to C:mksnt.

9. Install Microsoft Visual C++ 6.0 to C:VC98. Apply Visual Studio Service Pack 3.

10. Unzip GnuMake to a temporary directory (e.g. C:TEMP). (No need to install Zip/Unzip and Java. Run ‘which unzip.exe’). Recompile GNU Make by running VCVARS32.bat and then changing to the GNU Makebin directory and running build_w32.bat (TWICE). Change to the WinRel directory and copy gnumake.exe to c:mksntmksnt.

Installing Oracle Database 10g Release 2 (10.2) for Linux x86

Posted by on May 27, 2008 No comments

Installing Oracle Database 10g Release 2 (10.2) for Linux x86

1. Download the 10201_database_linux32.zip file from the Oracle web site

22d23ab01a8013500313ff92f65d0fe5  10201_database_linux32.zip  668734007KB

2. Unzip the zip file in an appropriate directory.

3. Open the welcome.html file from the database directory.

4. Click the Documentation tab, then click on the Quick Installation Guide HTML link. Follow the steps to begin installation

———-

1. Log on as root user and execute the commands:

# xhost +

# grep MemTotal /proc/meminfo

# grep SwapTotal /proc/meminfo

# free

# df -k /tmp

# df -k

# grep “model name” /proc/cpuinfo

2. Ensure that the following packages (or later versions) are installed for Red Hat Enterprise Linux 4.0:

* make-3.79.1 [make-3.80-6.EL4 found]
* gcc-3.2.3-34 [gcc-3.4.6-3.1 found]
* glibc-2.3.2-95.20 [glibc-2.3.4-2.25 found]
* compat-db-4.0.14-5 [compat-db-4.1.25-9 found]
* compat-gcc-7.3-2.96.128 [not found]
* compat-gcc-c++-7.3-2.96.128 [not found]
* compat-libstdc++-7.3-2.96.128 [not found]
* compat-libstdc++-devel-7.3-2.96.128 [not found]
* openmotif21-2.1.30-8 [not found]
* setarch-1.3-1 [setarch-1.6-1 found]

To update these packages, navigate to Add or Remove Packages and check Legacy Software Development. Then click Update.

3. Issue more commands:

cat /etc/issue

uname -r

4. Set up Oracle user and groups

# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba

# id oracle

# /usr/sbin/useradd -g oinstall -G dba oracle
or
# /usr/sbin/usermod -g oinstall -G dba oracle

# id nobody

5. Update kernel parameters. Edit /etc/sysctl.conf and add the following parameters:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
rmem_default = 262144
rmem_max = 262144
wmem_default = 262144
wmem_max = 262144

6. Prerequisite Check Errors

Error Encountered:
—————–
Checking operating system package requirements …
Checking for make-3.79; found make-1:3.80-6.EL4.    Passed
Checking for binutils-2.14; found binutils-2.15.92.0.2-21.    Passed
Checking for gcc-3.2; found gcc-3.4.6-3.1.    Passed
Checking for libaio-0.3.96; found Not found.    Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: Some packages required for the Oracle Database 10g to function properly are missing (see above).

Solution:
——–
Install libaio-0.3.105-2.i386.rpm from CD 3

Error Encountered:
—————–
Checking kernel parameters
Checking for semmsl=250; found semmsl=250.    Passed
Checking for semmns=32000; found semmns=32000.    Passed
Checking for semopm=100; found semopm=100.    Passed
Checking for semmni=128; found semmni=128.    Passed
Checking for shmmax=536870912; found shmmax=2147483648.    Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=2097152.    Passed
Checking for file-max=65536; found file-max=65536.    Passed
Checking for VERSION=2.6.9; found VERSION=2.6.9-42.0.0.0.1.EL.    Passed
Checking for ip_local_port_range=1024 – 65000; found ip_local_port_range=1024 – 65000.    Passed
Checking for rmem_default=262144; found rmem_default=110592.    Failed <<<<
Checking for rmem_max=262144; found rmem_max=131071.    Failed <<<<
Checking for wmem_default=262144; found wmem_default=110592.    Failed <<<<
Checking for wmem_max=262144; found wmem_max=131071.    Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.

Solution:
——–
/etc/sysctl.conf should read (last four parameters different):

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Error Encountered:
—————–
Checking available swap space requirements …
Expected result: 2274MB
Actual Result: 1983MB
Check complete. The overall result of this check is: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.

Solution:
——–
Create a new swap partition.

fdisk /dev/hdb

Delete old partition, create a new /dev/hdb1 and /dev/hdb2, with /dev/hdb2 at least 2275MB
Edit /etc/fstab and add new swap device
mount -a
swapon -a

Set environment variables for ORACLE_BASE, ORACLE_HOME and SID before starting dbca

SID should be in lowercase e.g. orcl

Set Global Database Identifier same as SID i.e. orcl

After installing, run lab_02_05.sh script to create listener. Or create it manually.
Configure a TNS Listener using netca

Configure orcl entry in tnsnames.ora using netca >

Start dbconsole using emctl start dbconsole: gave error about

Timezone mismatch: The agentTZRegion value (GMT) in
/u1/app/oracle/product/10.2.0/db_1/enterprise.support.com_orcl/sysman/config/emd.properties
does not match the current environment TZ setting().
The dbconsole cannot run with this mismatch.

If GMT is the correct timezone, set your timezone environment variable to GMT and repeat the ’emctl start dbconsole’ operation.

If GMT is not the correct timezone, make sure that the timezone in your environment is correct, and then run the following command in your local Oracle Home: ’emctl resetTZ agent’

The output of this command will include detailed instructions to follow, to correct the mismatch.

[oracle@enterprise admin]$ emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Updating /u1/app/oracle/product/10.2.0/db_1/enterprise.support.com_orcl/sysman/config/emd.properties…
Time zone set to America/Anguilla.

To complete this process, you must either:

connect to the database served by this DBConsole as user ‘sysman’, and execute:

SQL> exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’)

— or —

connect to the database served by this DBConsole as user ‘sys’, and execute:

SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’)

sqlplus sys/oracle
alter session set current_schema = SYSMAN;

exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’);

Error Encountered:
—————–
Unable to connect using service (orcl) as in sqlplus system/oracle@orcl

Solution:
——–
Added the following lines to the listener.ora file:

(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(SID_NAME = orcl)
)

The listener.ora file now reads:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(SID_NAME = orcl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = enterprise.support.com)(PORT = 1521))
)
)

Answering adadmin Prompts

Posted by on May 16, 2008 No comments

This section shows the typical responses for an adadmin session. Note that in this example, the VIS2 instance is used. The directories shown may differ for another instance. Note that pressing Enter for the responses uses the default answer, shown in brackets ([]).

[applmgr@appslinux ~]$ cd /u2/oracle/vis2appl/
[applmgr@appslinux vis2appl]$ . APPSORA.env
[applmgr@appslinux vis2appl]$ adadmin logfile=adadmin_20080516a.log
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                     Oracle Applications AD Administration
                                 Version 11.5.0
NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.
Your default directory is '/u2/oracle/vis2appl'.
Is this the correct APPL_TOP [Yes] ? <Press Enter> 
************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Fri May 16 2008 13:30:01
APPL_TOP is set to /u2/oracle/vis2appl
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? <Press Enter>
Please enter the batchsize [1000] : <Press Enter>
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, 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 [VIS2] : VIS2 *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate 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 database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in 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 Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [appslinux] : appslinux *
You are about to use or modify Oracle Applications product tables
in your ORACLE database 'VIS2'
using ORACLE executables in '/u2/oracle/vis2ora/8.0.6'.
Is this the correct database [Yes] ? <Press Enter>
AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema: manager
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] : <Press Enter>
AD Administration is verifying your username/password.
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 Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
Identifier for the current session is 33937
Reading 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.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [11i.AD.I.6]

Exception in TimedProcess

Posted by on March 28, 2008 No comments

Problem: When attempting to start or stop the Oracle instance, the following message is returned:

Executing service control script:

/u3/oracle/vis4comn/admin/scripts/VIS4_appslinux/adcmctl.sh stop

script returned:

****************************************************

ERROR :

Exception in TimedProcess…Failed to  execute command =

/u3/oracle/vis4comn/admin/scripts/VIS4_appslinux/adcmctl.sh stop apps/apps

****************************************************

Solution: You are not logged on as the Oracle user (most likely as root). Log on as the Oracle user (applmgr or oracle)

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

 

11i Installation Troubleshooting

Posted by on March 17, 2008 No comments

Installation of 11i instance on Windows Server 2003

1. Installed Visual C++ 6.0 and Visual Studio Service Pack 4

2. Set IP address in hosts file

3. Installed ActivePerl and Microsoft XML Parser

4. Started staging process:
cd
perl E:Disk1rapidwizadautocfg.pl

Error Encountered:
—————–
Only 12-13 files copied from Start CD

5. Uninstalled MKS Toolkit from C:Program Files and reinstalled it to C:mksnt

6. Changed TEMP environment variables to C:TEMP

7. Retried staging process:

Error Encountered:
—————–

Failed to copy adautocfg.pl to C:TEMPstaging

8. Determined which perl was being executed:
which perl

perl from MKS Toolkit being executed, because it is ahead of ActivePerl on path.

9. Uninstalled and reinstalled ActivePerl.

10. Retried staging process. Same error (Failed to copy adautocfg.pl to C:TEMPstaging)

11. Modified PATH environment variable so that ActivePerl (C:PERLbin) ahead of MKS Toolkit in path

12. Retried staging process. Staging progressing without errors.

13. Started installation by running rapidwiz

Error Encountered:
—————–

‘which’ not found

Solution:
——–

In Rapid Install, set MKS Directory to C:mksntmksnt

Error Encountered:
—————–

‘gnumake’ not found

Solution:
——–

Unzip make3.81 tar, set VC environment (VCVARS.bat), compiled gnumake (build_w32.bat) and copied gnumake.exe to C:Windowssystem32. Check that gnumake is in path by typing ‘which gnumake’

14. No errors encountered while installing. Post-install steps completed successfully.

15. After installing, logged on to application and submitted concurrent job. ‘Inactive Manager’

Error Encountered:
—————–

Active Users report completed on error:

ERR REP-3002: Error initializing printer. Please make sure a printer is installed.

Solution:
——–

Checked Metalink Doc ID: Note:365267.1 (Subject: All Requests End In Error With REP-3002: Error Initializing Printer)

Installed a local printer (Epson FX-80)

Error Encountered:
—————–

Internet Explorer crashing when forms are loaded.

Solution:
——–

Deinstall JInitiator and reinstall it.

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.

Invalid MIT-MAGIC-COOKIE-1 key

Posted by on February 8, 2008 No comments

Problem: When the Statement of Account report (a PDF-output report) is run, it gives the following error message:

Spawned Process 6276
Xlib: connection to "oradata:0.0" refused by server
Xlib: Invalid MIT-MAGIC-COOKIE-1 key
Xlib: connection to "oradata:0.0" refused by server
Xlib: Invalid MIT-MAGIC-COOKIE-1 key
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.

Solution: Set the DISPLAY environment variable and run xhost +.

root@ORADATA # echo $DISPLAY
root@ORADATA # xhost
xhost:  unable to open display ""
root@ORADATA # DISPLAY=10.0.240.13:0.0
root@ORADATA # xhost
xhost:  unable to open display ""
root@ORADATA # export DISPLAY
root@ORADATA # xhost
access control enabled, only authorized clients can connect
root@ORADATA # xhost +
access control disabled, clients can connect from any host
root@ORADATA #

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]