Problem:
When mount -t nfs ebusinesstest:/u0/oracle/testdata /mnt/testdata/ executed, the following error is returned:
mount: mount to NFS server ‘ebusinesstest’ failed: RPC Error: Program not registered.
Solution:
Run:
service nfs restart
on source and target machines.
Problem: Newly installed Linux is not able to access the Internet.
Solution: Route not configured to the gateway.
At a Terminal window, enter:
route add default netmask 0.0.0.0 gw 200.65.1.7 eth1
Configuration for PC in Software Services Area
The network port used by Linux is the one on the main board, not the Ethernet card that is used by Windows.
[root@enterprise ~]# route Kernel IP routing table Destination Gateway Genmask Flags Metric Ref Use Iface 200.65.1.0 * 255.255.255.0 U 0 0 0 eth1 169.254.0.0 * 255.255.0.0 U 0 0 0 eth1 default 200.65.1.7 0.0.0.0 UG 0 0 0 eth1
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 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))
)
)
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)
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)
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]
(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):
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:
From Metalink Doc ID: 234783.1, the following are required RPMs:
Step 4: Ensure that the following utilities are present by issuing it as a parameter to the ‘which’ command.
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.
This documentation covers some basic Linux commands used with Oracle.
In these examples, the example file name is filename.ext. Substitute the correct filename as necessary.
1. To list files in a directory:
ls
2. To list files in a directory in list format:
ls –l
3. To change directory to the oracle directory under /u0:
cd /u0/oracle
4. To change to the parent directory:
cd ..
5. To rename file1 to file2:
mv file1 file2
6. To remove a file:
rm filename.ext
7. To remove a directory, together with subdirectories:
rm –r directory
8. To get disk space free for all mounted file systems:
df -h
9. To change permissions on a file:
chmod 777 filename.ext
10. To change ownership of a file to applmgr and group dba (you may need to do this as root user):
chown applmgr:dba filename.ext
11. To create a symbolic link name /usr/bin/java to file /usr/local/jdk1.3.1_19 /bin/java
ln –s /usr/local/jdk1.3.1_19/bin/java /usr/bin/java
12. To tar all files in directory (to create one file contains all files in the directory):
tar cvf * filename.tar
13. To untar all files in directory:
tar xvf * filename.tar
This documentation covers Linux commands that are useful as they pertain to Oracle Applications.
1. To change prompt to display the time:
PS1='[u@h W] t $ ‘
alias settime=’PS1=”'[u@h W] t $ ””
alias settime=”PS1='[u@h W] t $ ‘”
Modify the /etc/bashrc file as root to add alias for all terminal windows.
2. To list the free disk space on all drives:
df -h
3. To display the disk space used by a directory:
du oracle -csh
4. To display lines in files with the word ‘oracle’:
for i in `ls -a`; do grep -Hnr oracle $i; done;
-H, –with-filename
Print the filename for each match.
-n, –line-number
Prefix each line of output with the line number within its
inputfile.
-R, -r, –recursive
Read all files under each directory, recursively; this is
equivalent to the -d recurse option.
5. To create a symbolic link to another directory:
ln -s stage11i10/ stage11510
For example: [root@appslinux u1]# ln -s stage11i10/ stage11510
ln [OPTION]… TARGET… DIRECTORY
Note that this command may need to be executed as the root user.
6. To delete directories one at a time while noting the time started:
for i in `ls`; do echo –n ‘Deleting ‘ $i ‘: Started ‘ ; date ; rm -r $i /u4/oracle/; done
7. To copy directories one at a time while noting the time started:
for i in `ls`; do echo –n ‘Copying ‘ $i ‘: Started ‘ ; date ; cp -r $i /u4/oracle/; done
8. How to Set the Date:
date -s “09/03/2006 14:09:00”
This sets the date to 03-SEP-2006, time 13:17. Note: this command is executed as root. Note: format is “mm/dd/yyyy”
9. To test all zip files in a directory:
for i in `ls *.zip`; do unzip -qt $i; done;
10. To get the size of directories one at a time:
for i in `ls`; do echo -n ‘Size of ‘ $i ‘: ‘ ; du $i -sh ; done ; du -sh
11. To get the total size of a directory:
du -sh
12. To search all files with AP_ACCOUNTING_MAIN_PKG:
for i in `find . -type f`; do grep -Hin AP_ACCOUNTING_MAIN_PKG $i; done;
Recent Comments