Problem:
On CentOS 5.8, when installing 10g OEM Grid Control, the Web Cache Configuration Assistant fails.
Solution:
ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
Category Archives: 10g
Web Cache Configuration Assistant fails, libdb.so.2: cannot open shared object file
Posted by Vasudev Seeram
on August 15, 2012
No comments
ORA-20100: File o0150175.tmp creation for FND_FILE failed
Posted by Vasudev Seeram
on December 14, 2011
No comments
Problem:
When running the Diagnostics: Apps Check from the Purchasing responsibility in Oracle Applications E-Business Suite 11i, the concurrent request completes in error and following error appears at the bottom of the output log:
declare
*
ERROR at line 1:
ORA-20100: File o0150175.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 407
ORA-06512: at “APPS.FND_FILE”, line 581
ORA-06512: at line 120
Solution:
Ran out of disk space on the db machine. The temp directory used by EBS is in the /var directory, which is only 1GB in size. The /var directory is being filled by yum updates.
As root user, execute the command ‘yum clean all’. Stop the yum updates by issuing the command ‘/etc/init.d/yum-updatesd stop’.
EBS instance running out of processes
Posted by Vasudev Seeram
on October 18, 2011
No comments
Problem:
EBS instance running out of processes. Need to increase the database PROCESSES initialization parameter.
Solution:
Change the PROCESSES init parameter in the pfile or scope=spfile. Then restart the database (using addbctl.sh, not using the database stop immediate/startup command as shown below).
netca Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Posted by Vasudev Seeram
on August 24, 2011
1 comment
Problem: When configuring the TNS settings using the Oracle Net Configuration Assistant, the follow error appears:
Connecting… ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. The test did not succeed.
Solution: Mismatch between hostnames in tnsnames.ora and listener.ora.
Tape Commands for Linux
Posted by Vasudev Seeram
on December 15, 2009
No comments
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
Backup Script for Oracle 10g
Posted by Vasudev Seeram
on December 8, 2009
No comments
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!
Upgrading 11i EBS 9i Database to 10g
Posted by Vasudev Seeram
on September 10, 2009
No comments
This document shows how to upgrade the 9i database in 11i E-Business Suite to 10g on Linux.
Metalink Reference:
Doc ID: 362203.1 (Subject: Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0))
Section 1: Upgrading an 11i Database to Oracle Database 10g Release 2 (10.2.0)
Ignore steps 1 – 5 in the Metalink document.
Begin at Step 6.
Step 6: Prepare to create the 10.2.0 Oracle home
Download Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
10201_database_linux32.zip (668,734,007 bytes) (cksum – 2737423041)
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html
http://www.oracle.com/technology/documentation/database10gr2.html
http://www.oracle.com/technology/support/metalink/index.html
Step 7: Install the base 10.2.0 software
Install Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
Refer to chapter 3, Oracle Database Installation Guide 10g Release 2 (10.2)
Unzip 10201_database_linux32.zip
Create directory: /u01/oracle/visdb/10.2.0
Ensure OS meets requirements for 10g
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Begin installation (./runInstaller)
- Advanced installation
- Choose Enterprise Edition installation type
- Do not upgrade existing database
- Install database software only
Note: You may need to increase the swap file to 4GB before installing 10g.
Step 8: Install Oracle Database 10g Products from the 10g Companion CD
Refer to section 3.5, “Installing Oracle Database 10g Products” in the Oracle Database Companion CD Installation Guide
Unzip 10201_companion_linux32.zip
Ensure OS meets requirements for 10g (should be in place)
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Begin installation (./runInstaller)
- Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
- Choose the 10g Home
Step 9: Perform 10.2.0.4 patch set pre-installation tasks
Oracle® Database Patch Set Notes
10g Release 2 (10.2.0.4) Patch Set 3 for Linux x86
Metalink Doc ID: 316900.1
Download patch 6810189 (p6810189_10204_Linux-x86.zip)
Unzip p6810189_10204_Linux-x86.zip
Ensure OS meets requirements for 10g (should be in place)
Set ORACLE_HOME=/u01/oracle/visdb/10.2.0
Set ORACLE_SID=VIS
Stop all processes (dbconsole, iSQL*Plus, database listener)
Backup Oracle Inventory, Oracle database, Oracle Home
Begin installation (./runInstaller)
- Oracle Database 10g Products 10.2.0.1.0 (not Oracle HTML DB or Oracle Database 10g Companion Products)
- Choose the 10g Home
Perform 10.2.0.4 patch set pre-installation tasks
On the database server node, as the owner of the Oracle 10g file system and database instance, unzip and extract the 10.2.0.4 patch set file for your platform. Read the patch set notes (usually README.html). Make sure you thoroughly understand the upgrade and patch set installation process before you begin. Check OracleMetaLink or contact Oracle Support Services to determine any known issues with the patch set and its interoperability with Oracle E-Business Suite.
Perform the tasks in the “Preinstallation Tasks” section of the patch set notes (if they apply to your system).
Step 10: Perform 10.2.0.4 patch set installation tasks
On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in the “Installing the Oracle Database 10g Patch Set Interactively” section of the patch set notes. Make sure that:
The ORACLE_HOME environment variable points to the new 10.2.0 Oracle home.
The PATH environment variable includes $ORACLE_HOME/bin and the directory where the new perl executable is located (usually $ORACLE_HOME/perl/bin).
The LD_LIBRARY_PATH environment variable includes $ORACLE_HOME/lib.
The PERL5LIB environment variable points to the directories where the new perl libraries are located (usually $ORACLE_HOME/perl/lib/<perl version> and $ORACLE_HOME/perl/lib/site_perl/<perl version>)
You use the runInstaller (UNIX/Linux) or the setup.exe executable (Windows) provided in the patch set to run OUI.
Step 11: Create nls/data/9idata directory
Run: perl $ORACLE_HOME/nls/data/old/cr9idata.pl script
Modify set10g.env:
export ORA_NLS10= ORACLE_HOME/nls/data/9idata
Step 12: Apply additional 10.2.0.4 RDBMS patches
Download from Metalink and apply:
6880880 or the latest OPatch version.
6521934
6600051
7496636
7497678
cd $ORACLE_HOME
unzip /u01/patches/p6880880_102000_LINUX.zip
emctl not starting Timezone mismatch agentTZRegion
Posted by Vasudev Seeram
on August 30, 2009
No comments
Problem: When starting emctl for first time after reboot on Linux, the following message appears:
Timezone mismatch: The agentTZRegion value (GMT) in /u01/app/oracle/product/10.2.0/db_1/localhost.localdomain_ORCL/sysman/config/emd.properties does not match the current environment TZ setting().
The dbconsole cannot run with this mismatch.
Solution:
Run:
emctl resetTZ agent
Then run:
emctl start dbconsole
You may need to stop the agent (but it says it is not running):
emctl stop agent
Unable to access Application Express
Posted by Vasudev Seeram
on March 10, 2009
No comments
In web browser, navigated to http://shrivastava.test.int:7777/pls/apex. Received message:
Forbidden You don't have permission to access /pls/apex/apex on this server. ---------------------------------------------------------- Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at SHRIVASTAVA.TEST.INT Port 7777
Solution:
Password in the dads.conf (C:oracleproduct10.2.0http_1Apachemodplsql confdads.conf ) file is incorrect. Confirm by logging on to SQL*Plus as user APEX_PUBLIC_USER. Correct password, then bounce Apache web server.
Recent Comments