Category Archives: 11i - Page 3

EXEC FND_CONC_STAT.COLLECT Parameter Appearing in Concurrent Report Output

Posted by on July 6, 2011 No comments

Problem: After SQL*Plus concurrent job is registered and run, the concurrent job completes in error and the following message appears in the output:

Enter value for 10: EXEC FND_CONC_STAT.COLLECT;
Enter value for 20:
Enter value for 30: EXIT
     peed.start_date between to_date('EXEC FND_CONC_STAT.COLLECT;', 'RRRR/MM/DD HH24:MI:SS') and  to_date('','RRRR/MM/DD HH24:MI:SS')
                                     *
ERROR at line 18:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Solution: The parameters in the SQL script must be changed from ‘&P_Start_Date’, ‘&P_End_Date’ and ‘&P_Payroll’ to ‘&1’, ‘&2’ and ‘&3’.

Read more »

“Compile Security” Concurrent Request completes in error

Posted by on June 29, 2011 No comments

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’.

REP-3000 Error

Posted by on December 17, 2009 No comments

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.

Script To Export 11i Database

Posted by on December 15, 2009 No comments 
# 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

Unable to make a network connection

Posted by on October 6, 2009 No comments

Problem: When configuring Workflow Mailer, and no password is entered for the Inbound Mailer Server (IMAP), the instance pauses for a few seconds, then returns:

Unable to make a network connection

Solution:

If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, but invalid username and password is entered, the following message appears:

Unable to connect to the mail account. Check the host, user name and password.

If a valid mail server is entered into the Inbound Server Name under Inbound Email Account, and a valid username and password is entered, the following message appears:

Validation

Need to put a valid username and password into the Inbound Server Name.

Ensure that the Test Email Address and Reply-To email addresses are different.

e.g. dbadmin@school.com, surajini.shrivastav@school.com

Upgrading 11i EBS 9i Database to 10g

Posted by 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

You do not have a current session, please log in before visiting this URL

Posted by on September 3, 2009 No comments

Problem: After installing 11.5.9 Vision instance, the E-Business Suite logon appears, and the user is able to log on as SYSADMIN/SYSADMIN. However, after logging on, the following message appears:

You do not have a current session, please log in before visiting this URL

When trying to troubleshoot the issue with aoljtest.jsp, the user is able to login, but when trying to access all the tests, the following message appears:

"This page can only be accessed through aoljtest.jsp"

Solution:

The domain name of the machine had only one component (localdomain). This was changed to cia.org.tt (at least two components) and the instance wiped and reinstalled.

adalnctl.sh: exiting with status 127

Posted by on September 3, 2009 No comments

Problem: After installing 11.5.9 Vision instance, the apps listener exits with status 127.

Solution: Apply operating system patch 3830807

Metalink Reference:

Subject:  Attempt To Start Listener Exits With Status 127

Doc ID:  299810.1

AutoConfig is exiting with status 4 installing 11.5.9

Posted by on September 1, 2009 No comments

Problem:

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is:
<filename>  <phase>  <return code where appropriate>
[INSTANTIATE PHASE]
AutoConfig could not successfully instantiate the following files:
Directory: /u0/oracle/TEST3/test3db/9.2.0/md/demo/orascv/doc
OraSCV.asc              INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/oem_webstage/readme
emreadme.txt            INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/relnotes/em
README_EM.txt           INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/sysman/doc/readme
README_em.txt           INSTE8
AutoConfig is exiting with status 4

Solution: Unset the LANG environment variable.

Metalink Reference:

Subject:  Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt, README_EM.txt And README_em.txt While 11.5.9 Install

Doc ID:  262125.1

RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed

Posted by on May 27, 2009 1 comment

Problem:

When cloning the database tier of Illuminat HRMS Production, the process fails on 70% with error:

Beginning database tier Apply - Wed May 27 10:12:21 2009
Log file located at /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed
ERROR while running Apply...
 ERROR: Failed to execute adclone.pl
 Please check logfile.
Log file /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log showed:
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
adcrdb.sh started at Wed May 27 10:54:18 AST 2009
The environment settings are as follows ...
       ORACLE_HOME : /u0/oracle/TEST2/test2db/9.2.0
        ORACLE_SID : TEST2
          TWO_TASK :
              PATH : /u0/oracle/TEST2/test2db/9.2.0/Apache/perl/bin:/u0/oracle/TEST2/test2db/9.2.0/bin:/usr/bin:/usr/sbin:/u0/oracle/TEST2/test2db/9.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:../jre/1.3.1/bin:/u0/oracle/testdb/9.2.0/Apache/perl/bin:/usr/kerberos/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:.
   LD_LIBRARY_PATH : /u0/oracle/TEST2/test2db/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u0/oracle/TEST2/test2db/9.2.0/ctx/lib
Executable : /u0/oracle/TEST2/test2db/9.2.0/bin/sqlplus
The log information will be written to
        /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/adcrdb_TEST2.txt
Creating the control file for TEST2_ebusinesstest database ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:54:18 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Database mounted.
BEGIN dbms_backup_restore.zeroDbid(0); END;
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u0/oracle/TEST2/test2db/9.2.0/dbs/MISSING00395'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.so'
Library created.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
exit_code=0
Checking for errors ...
ORA-01119: error in creating database file
ORA-27037: unable to obtain file status
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
The database has not been successfully created. Shutting down the instance ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:57:56 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected.
ORACLE instance shut down.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
.end std out.
.end err out.
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:469)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:314)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:290)
        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131)
        at java.lang.reflect.Constructor.newInstance(Native Method)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
        at java.lang.Thread.run(Thread.java:479)

Solution:

The cloning process omits two files that were created since the last adpreclone.pl run. Therefore, run preclone scripts (adpreclone.pl) on the production instance before copying files.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]