Category Archives: Linux - Page 3

Java HotSpot(TM) Client VM Error When Running dbua

Problem:

After installing Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86, sourced the 11gR2 environment and attempted to run dbua to upgrade the 11gR1 database. The following error occurred:

[applmgr@centos53server ~]$ dbua
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x9fdf64d4, pid=3662, tid=3086928080
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
# C  [libnnz11.so+0x3c4d4]
#
# An error report file with more information is saved as hs_err_pid3662.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
#
Aborted

 

Solution:

Apply patch p8670579_112010_LINUX.zip.

Read more »

Printer No Longer Prints After Changing Ribbon

Problem: After changing the printer ribbon for the dot-matrix printer, E-Business Suite can no longer print to the printer.

Solution: The printer must be re-enabled under Linux. Log on as the root user to the machine with the Reports Server and issue the command ‘cupsenable PRINTERNAME’, where PRINTERNAME is the name of the printer as it is registered under Linux.

[amazon asin=0131855158&template=iframe image&chan=default]     [amazon asin=1449316697&template=iframe image&chan=default]     [amazon asin=0596006403&template=iframe image&chan=default]

“Compile Security” Concurrent Request completes in error

Problem: When the user runs the concurrent request for “Compile Security”, it completes with error.

Solution: On the database server, the /var directory has completely filled up and there is no free space. This directory is used by E-Business Suite as the temp directory (in reality, EBS uses/usr/tmp, which symbolically links to /var/tmp). The space is filled due to the yum daemon, which automatically downloads updates from Red Hat to the /var/cache/yum directory.

To resolve this issue, log on to the system as the root user and either delete the contents of the /var/cache/yum directory using ‘rm -f /var/cache/yum’, or execute the command ‘yum clean all’. To stop the yum-updatesd daemon, run the command ‘service yum-updatesd stop’ or ‘/etc/init.d/yum-updatesd stop’.

ORA-12913: Cannot create dictionary managed tablespace

Problem: While creating a dictionary managed tablespace in Oracle 9i, the following error appears:

SQL> r
 1  CREATE TABLESPACE data01
 2  DATAFILE '$HOME/oradata/ORCL/data01.dbf' SIZE 2M
 3* EXTENT MANAGEMENT DICTIONARY
 CREATE TABLESPACE data01
 *
 ERROR at line 1:
 ORA-12913: Cannot create dictionary managed tablespace
 Solution:

Consulting the Oracle 9i online documentation, the following cause and action is found:

Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.

Action: Create a locally managed tablespace.

As a result, the dictionary managed tablespace cannot be created in this Oracle 9i database.

Reference:

http://download.oracle.com/docs/cd/B10500_01/server.920/a96525/e12700.htm

Sample 11.5.9 to 12.1.1 Upgrade Steps

1. Preparing for the Upgrade

Apply 11i.AD.I
Back up database, Applications, and customizations
Prepare an upgrade plan for customizations
Convert to Multiple Organizations architecture
Review sizes of old and new tablespaces
Review Upgrade Tasks and Apply 11i.AD.I

Convert Oracle Alert E-mail Processing to the Workflow Notification Mailer
Financials and Procurement Tasks
Gather schema statistics for CBO
Back up the database
Run Rapid Install
Migrate or upgrade your database to Oracle 10g Release 2
Port application to Linux servers

2. Upgrading to Release 12

Disable AOL Audit Trail
Migrate database to Oracle10g Release 2
Back up the database
Apply Release 12 AD minipack
Run the American English upgrade patch driver
Run the NLS upgrade patch driver
Apply latest product patches
Synchronize NLS and American English product patches
Back up Oracle Applications

Finish the Upgrade
Configure Applications client software for forms applet (required)
Reapply customizations (conditional)
Integrate custom objects and schemas (conditional)

Finish System Administration Tasks
Complete Workflow Notification Mailer configuration (required)
Complete setup for Oracle XML Gateway (required)
Enable PDF printing (required)

3. Post-upgrade Tasks
Install online help
Update/verify custom responsibilities
Migrate custom development to new technologies
Migrate the CUSTOM library
Copy and re-customize modified scripts or reports
Review user responsibility assignments
Associate organization names with custom Alert definitions
Set operating unit mode for customizations
Assign the Report Manager Data Migration Program to a request group
Run the Data Migration Program

Update Status Monitor URLs
Synchronize Product License and Workflow BES license status
Financials and Procurement Tasks
Additional Tasks

Clearing Linux File Cache

To clear the Linux file system cache, use the following command:

sync ; echo 3 > /proc/sys/vm/drop_caches

REP-3000 Error

To resolve REP-3000 while running PDF reports, try these solutions:

1. Set ‘s_display’ in SID_server.xml using vi or using Oracle Application Manager:

a. Use the ‘uname -n’ command to determine the correct name of the server eg vision.hostname.com

b. If the ‘echo $DISPLAY’ command is set to 0.0, then the s_display parameter to this value, for example:

vision.hostname.com:0.0

c. In a Terminal window, enter ‘xhost +’

d. Do not log off the console (0.0)
OR

2. If VNC is running on port 1 on the server:ex

set s_display to vision.hostname.com:1.0 or vision:1.0

Ensure that VNC server is not killed during the day.

Or set ‘headless’ in SID_server.xml to true and DisallowTCP to false in the /etc/X11/gdm/gdm.conf

Run AutoConfig after changing any SID_server.xml parameter.

Tape Commands for Linux

To back up /etc folder:

tar -cvf /dev/st0 /etc

To list contents of tape:

tar -tf /dev/st0

To restore data from tape:

tar -xvf /dev/st0

Script To Export 11i Database

# expprod.sh
#
# Exports the Oracle E-Business Suite HRMS Production database
# which will then be copied over to the backup server
#
# source the environment
. /u0/oracle/proddb/9.2.0/PROD_ebusiness.env
# stop, then restart the production instance
# to overcome 'snapshot too old' error
# (commented out, as users on the system at 6:00 P.M. will be kicked off)
# cd /u0/oracle/proddb/9.2.0/appsutil/scripts/PROD_ebusiness/
# ./addbctl.sh stop immediate
# ./addbctl.sh start
# get name of log file and dump file
export LOGFILE=expprod_`date +%F_%k-%M-%S`.log
export DUMPFILE=expprod.dmp
export BACKUPDIR=/mnt/prodbkup
export EXPORTDIR=/u0/prodbkup
export ZIPFILE=expprod.tar.gz
export ZIPFILE2=expprod_`date +%F_%k-%M-%S`.tar.gz
# remove existing dump file
rm $EXPORTDIR/$DUMPFILE
rm $EXPORTDIR/$ZIPFILE
# export the ONT schema (for testing purposes)
# exp system/manager file=$EXPORTDIR/$DUMPFILE log=$EXPORTDIR/$LOGFILE owner=ONT
# export the database
exp system/manager file=$EXPORTDIR/$DUMPFILE log=$EXPORTDIR/$LOGFILE full=y consistent=y
# tar and gzip export file
tar -czvf $EXPORTDIR/$ZIPFILE $EXPORTDIR/$DUMPFILE
# remove the previous export dump from the test server, then copy the new one
# rm $BACKUPDIR/$DUMPFILE
# rm $BACKUPDIR/$ZIPFILE (Commented out by VS 10-Sep-09)
# copy the zip file and log file to the backup directory (remote NFS directory on ebusinesstest)
cp $EXPORTDIR/$ZIPFILE $BACKUPDIR/
cp $EXPORTDIR/$LOGFILE $BACKUPDIR/
# rename the zip file in the remote directory to reflect today's date
mv $BACKUPDIR/$ZIPFILE $BACKUPDIR/$ZIPFILE2
# rename the zip file in the local directory to reflect today's date (as an archive copy)
mv $EXPORTDIR/$ZIPFILE $EXPORTDIR/$ZIPFILE2

Backup Script for Oracle 10g

Sample script to backup an Oracle 10g database on Linux.

#!/bin/sh
 # orahotbkup.sh
 #
 # Copies Oracle database data files to backup directory on disk
 # and individually gzips them
 #
# set up environment variables
 # need to export the Oracle environment variables
 export ORACLE_SID=orcl
 export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
 export PATH=$ORACLE_HOME/bin:$PATH
FMT_DATE=`/bin/date +%Y%m%d`
 BACKUP_BASE=/u01/app/oracle/oradata/backup/orcl
SCRIPT_LOC=/u01/app/oracle/admin/$ORACLE_SID/scripts/backup
 LOG_LOC=/u01/app/oracle/admin/$ORACLE_SID/scripts/log
 BACKUP_LOC=$BACKUP_BASE/$FMT_DATE
SCRIPT_FILE=$SCRIPT_LOC/dbf$FMT_DATE.sh
 LOG_FILE=$LOG_LOC/$FMT_DATE.log
# make destination directories
 mkdir -p $LOG_LOC
 mkdir -p $SCRIPT_LOC >> $LOG_FILE
 mkdir -p $BACKUP_LOC >> $LOG_FILE
# generate bash script file to copy database data files to destination
 sqlplus / as sysdba <
select '#!/bin/sh ' from dual;
 select 'sqlplus / as sysdba <<EOF'||chr(10)||
 'alter tablespace '||tablespace_name||
 ' begin backup; '||chr(10)||
 'exit'||chr(10)||
 'EOF'||chr(10)||chr(10)||
 'cp '||file_name||' $BACKUP_LOC/'||substr(file_name,instr(file_name,'/',-1)+1)
 ||chr(10)||chr(10)||
 'sqlplus / as sysdba <<EOF'||chr(10)||
 'alter tablespace '||tablespace_name||
 ' end backup; '||chr(10)||
 'exit'||chr(10)||
 'EOF'
 from dba_data_files
 order by file_id
spool $SCRIPT_FILE
/
spool off
 exit
 EOF
# change permission modes on script file to make it executable
 chmod 755 $SCRIPT_FILE
# execute the script file to copy the database data files
 $SCRIPT_FILE
# set name of second script file
 SCRIPT_FILE=$SCRIPT_LOC/arc$FMT_DATE.sh
# generate bash script file to copy archive logs to destination
 sqlplus / as sysdba <
alter system switch logfile;
 alter system switch logfile;
 alter system switch logfile;
alter database backup controlfile to '$BACKUP_LOC/control01.dbf';
select '#!/bin/sh ' from dual;
 select
 'cp '||name||' $BACKUP_LOC/'||substr(name,instr(name,'/',-1)+1)
 ||chr(10)||chr(10)
 from v$archived_log
 where completion_time > sysdate - 1.1
 order by completion_time
spool $SCRIPT_FILE
/
spool off
 exit
 EOF
# change permission modes on script file to make it executable
 chmod 755 $SCRIPT_FILE
# execute the script file to copy the archive log files
 $SCRIPT_FILE
# gzip each database file in the $BACKUP_LOC directory
 gzip $BACKUP_LOC/*
echo All done!