Monthly Archives: December 2008 - Page 3

AC-50480: Internal error occurred: java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated

Posted by on December 9, 2008 No comments

Problem:

When running AutoConfig on database tier, the follow error appears in the log file:

=======================================================
[ Config tool : /u0/oracle/testdb/9.2.0/appsutil/bin/adgentns.pl ]
   Command            : /u0/oracle/testdb/9.2.0/Apache/perl/bin/perl -I /u0/oracle/testdb/9.2.0/Apache/perl/lib/5.00503:/u0/oracle/testdb/9.2.0/Apache/perl/lib/site_perl/5.005:/u0/oracle/testdb/9.2.0/appsutil/perl  /u0/oracle/testdb/9.2.0/appsutil/bin/adgentns.pl PASSWORD  contextfile=/u0/oracle/testdb/9.2.0/appsutil/TEST_ebusinesstest.xml
   Action             : execute
SCRIPT RETURNED:
#######################################################
                   Generate Tns Names
#######################################################
    Using java command: /u0/oracle/testdb/9.2.0/jdk/bin/java
    JAVA_HOME         :
    Java version      : 1.3.1_11
    Classpath         : /u0/oracle/testdb/9.2.0/jdk/jre/lib/rt.jar:/u0/oracle/testdb/9.2.0/jdk/jre/lib/i18n.jar:/u0/oracle/testdb/9.2.0/jdk/lib/dt.jar:/u0/oracle/testdb/9.2.0/jdk/lib/tools.jar:/u0/oracle/testdb/9.2.0/jdbc/lib/classes12.jar:/u0/oracle/testdb/9.2.0/appsutil/java/xmlparserv2.zip:/u0/oracle/testdb/9.2.0/appsutil/java
Loading ORACLE_HOME environment from /u0/oracle/testdb/9.2.0
Logfile: /u0/oracle/testdb/9.2.0/appsutil/log/TEST_ebusinesstest/04061541/NetServiceHandler.log
AC-50480: Internal error occurred: java.sql.SQLException: ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated
ORA-06512: at "APPS.FND_APP_SYSTEM", line 931
ORA-06512: at "APPS.FND_NET_SERVICES", line 399
ORA-06512: at "APPS.FND_NET_SERVICES", line 675
ORA-06512: at "APPS.FND_NET_SERVICES", line 1097
ORA-06512: at line 1
Error generating tnsnames.ora from the database, temperory tnsnames.ora will be generated using templates
Instantiating templates
tnsnames.ora instantiated
listener.ora instantiated
adgentns.pl exiting with status 2
ERRORCODE = 2 ERRORCODE_END

Solution:

To implement the solution, please execute the following steps:

1. Be sure to have a valid backup.

2. Open an environment shell and set the Applications Environment

3. cd $AD_TOP/bin

4. perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem

5. Open a new shell and set the Database Environment

6. Run adconfig at the dbTier

7. Open a new shell and set the Applications Environment and also run autoconfig at the appsTier

Subject:  Autoconfig Fails with:ORA-00001: unique constraint (APPLSYS.FND_TNS_ALIASES_U2) violated

Doc ID:  416182.1

CopyUpdateProject fails

Posted by on December 8, 2008 No comments

Problem:

In Change Assistant, the CopyUpdateProject step fails:

Step Failed at: Copy Update Project

Contents of E:tempsoftwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}FSCM900_MP5.log:

PeopleSoft Project Command Line
Copy From File
Project Name: FSCM900_MP5
Tools Release: 8.49.15
2008-12-08 : 10.55.54

-CT Source Database Type = MICROSFT
-CS Source Database Server =
-CD Source Database Name = FSDMO
-CO Source Database Operator = VP1
-FP File Path = E:/staging/softwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}
-CL Commit Limit = 100
-AF Keep Target Audit Flags = 1
-DDL Keep Target DDL = 1
-CFD Keep Target Chartfield PageField Display Size = 1
-CFF Keep Target Chartfield DbField Format = 1
-PPL Keep Target Portal Structure Permission List = 1
-OBJ Object Types = All
-LNG Languages = ENG,COMMON

Project FSCM900_MP5 already exists, continuing processing, switch set to overwrite.
Transforming XML. Please be patient.
Processing Language : English
Processing Language : COMMON

Records Application Upgrade Copy started: 2008-12-08-10.58.38

Contents of E:tempsoftwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}FSCM900_MP5_CA.log

Command Line: E:PSOFTFS900binclientwinx86pside.exe -CT MICROSFT -CS -CD FSDMO -CO VP1 -CP * -PJFF FSCM900_MP5 -FP E:/staging/softwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05} -LF E:tempsoftwareupdateFSCM900_MP5{bb2f249c-b59c-11dd-aaa1-aa1d90f67f05}FSCM900_MP5.log -CL 100 -AF 1 -DDL 1 -OBJ All -LNG ENG,COMMON -PPL 1 -CFD 1 -CFF 1 -HIDE -QUIET -SS NO -SN NO

Solution:

1. Batch server was running. Stopped batch server and restarted the CopyUpdateProject step.
2. Batch server started, and then restarted the CopyUpdateProject step.
3. Application server was running, stopped it and then restarted the CopyUpdateProject step.

(Advised by consultant) Skipped this step as it was previously deployed under IBM WebSphere.

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management

Posted by on December 8, 2008 No comments

Problem:

When running AutoConfig on application tier:

AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.
Restored the Context file in :
        /u0/oracle/testappl/admin/TEST_ebusinesstest.xml
Aborting the running of Context Value Management
Error occured before Context Value Management could be completed
ERROR: Context Value Management Failed.
Terminate.

Solution:

LD_ASSUME_KERNEL not set.

export LD_ASSUME_KERNEL=2.4.19

Error updating master archive

Posted by on December 7, 2008 No comments

Problem:

When applying patch 4104924, the following error appears:

AutoPatch error:
ERROR
[code language="1"][/code]
[/code]
 Running adjopy.class
AutoPatch error:
Error updating master archive

Solution:

LD_ASSUME_KERNEL not set

export LD_ASSUME_KERNEL=2.4.19

Unable to initialize threads

Posted by on December 6, 2008 No comments

Problem:

Running adstpall.sh returns the following error:
[applmgr@ebusinesstest TEST_ebusinesstest]$ ./adstpall.sh apps/apps
You are running adstpall.sh version 115.17
/u0/oracle/testcomn/util/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM
Check logfile /u0/oracle/testcomn/admin/log/TEST_ebusinesstest/04061425.log for details
Exiting with status 1
[applmgr@ebusinesstest TEST_ebusinesstest]$

Solution:

Subject:        GLIBC_2.0 not defined in file libc.so.6

Note:275161.1

export LD_ASSUME_KERNEL=2.4.19

Cannot complete applications logon

Posted by on December 5, 2008 No comments

Problem:

Cannot complete applications logon.  You may have entered an invalid applications password, or there may have been a database connect error.

Solution:

Use Metalink Doc ID: 153053.1 to reset the SYSADMIN password to WELCOME.

Internal Server Error

Posted by on December 4, 2008 No comments

Problem:

Internal Server Error when trying to log in to Oracle Applications

Solution:

Ran out of tablespace. Checked alert log to tablespaces to extend.

Installing PSEM Agent as Windows Service

Posted by on December 3, 2008 No comments

1) Update the configuration.properties file.

2) Open Command Prompt, navigate to PS_HOMEbinclientwinx86 and enter:
PSEMAgentService /install PS_HOMEPSEMAgent

3) In Control Panel > Administrative Tools > Services, a new service called PeopleSoft Environment Management Agent-8.46.xx appears.

4) Adjust the logon parameters by right-clicking the service and choosing Properties.

5) To uninstall the service, open Command Prompt and type:
PSEMAgentService /uninstall

Reference:
http://www.erpassociates.com/peoplesoft-corner-wiki/peoplesoft-administration/change-assistant.html

AutoConfig taking long on database tier

Posted by on December 3, 2008 No comments

Problem:

Running AutoConfig on the database tier of the ebusinesstest machine takes long (over 20 minutes).

Solution:

Log file (/u0/oracle/testdb/9.2.0/appsutil/log/TEST_ebusinesstest/03161419/adconfig.log) showed:

Starting synchronization of file system Context file and its templates with those in the database
Database connection     : Failed
OAM Context editing support feature: Unverified
OAM Customization support feature  : Unverified
File system template    : /u0/oracle/testdb/9.2.0/appsutil/template/adxdbctx.tmp
Checking for customizations to Context template
Warning: Unable to connect to Database.
If the system is OAM enabled, this may result in loss of customizations.
Looking for custom template at : /u0/oracle/testdb/9.2.0/appsutil/template/custom/adxdbctx.tmp
Custom template         : Not available
Customizations found    : None
----------------------------------------------------------------
File system Context file :/u0/oracle/testdb/9.2.0/appsutil/TEST_ebusinesstest.xml
Checking the Context file for possible updates from the Database
Warning: Unable to connect to Database.
If the system is OAM enabled, this may result in loss of customizations and the Context files in DataBase and in the file system may be unsynchronized

Edited context file (/u0/oracle/testdb/9.2.0/appsutil/TEST_ebusinesstest.xml) and changed domain name of machine from (s_domainname) ‘support.com’ to ‘illuminatnm.com’.

Reran AutoConfig on the database tier and it completed under one minute. ‘illuminatnm.com’ domain remains in context file.

Insufficient privileges for current operation

Posted by on December 2, 2008 No comments

Problem:

When logging on to HRMS Production instance as SYSADMIN, the following message is displayed:

You have insufficient privileges for the current operation

Solution:

Log on to the HRMS Production server. Check the alert log for any ORA errors by issuing the following commands:

[applmgr@ebusiness /]$
[applmgr@ebusiness bdump]$ cd /u0/oracle/proddb/9.2.0/admin/PROD_ebusiness/bdump/
[applmgr@ebusiness bdump]$ tail alert_PROD.log
Current log# 2 seq# 33933 mem# 1: /u0/oracle/proddata/log02b.dbf
Tue Dec  2 09:46:30 2008
Completed checkpoint up to RBA [0x848d.2.10], SCN: 0x056d.102174e9
Tue Dec  2 10:00:40 2008
Beginning log switch checkpoint up to RBA [0x848e.2.10], SCN: 0x056d.1021d85e
Thread 1 advanced to log sequence 33934
Current log# 1 seq# 33934 mem# 0: /u0/oracle/proddata/log01a.dbf
Current log# 1 seq# 33934 mem# 1: /u0/oracle/proddata/log01b.dbf
Tue Dec  2 10:15:50 2008
ORA-1654: unable to extend index ICX.ICX_SESSIONS_N1 by 35 in tablespace              ICXX
[applmgr@ebusiness bdump]$
[applmgr@ebusiness 9.2.0]$ sqlplus apps/********
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Dec 2 10:25:25 2008
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:
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
SQL> desc dba_data_files
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
FILE_NAME                                          VARCHAR2(513)
FILE_ID                                            NUMBER
TABLESPACE_NAME                                    VARCHAR2(30)
BYTES                                              NUMBER
BLOCKS                                             NUMBER
STATUS                                             VARCHAR2(9)
RELATIVE_FNO                                       NUMBER
AUTOEXTENSIBLE                                     VARCHAR2(3)
MAXBYTES                                           NUMBER
MAXBLOCKS                                          NUMBER
INCREMENT_BY                                       NUMBER
USER_BYTES                                         NUMBER
USER_BLOCKS                                        NUMBER
SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX';
TABLESPACE_NAME FILE_NAME                      BYTES/1024/1024
--------------- ------------------------------ ---------------
ICXX            /u0/oracle/proddata/icxx01.dbf              20
SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M;
alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> connect system/********
Connected.
SQL> alter tablespace icxx add datafile '/u0/oracle/proddata/icxx02.dbf' size 20M;
Tablespace altered.
SQL>  select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'ICXX';
TABLESPACE_NAME FILE_NAME                      BYTES/1024/1024
--------------- ------------------------------ ---------------
ICXX            /u0/oracle/proddata/icxx01.dbf              20
ICXX            /u0/oracle/proddata/icxx02.dbf              20

Log on to SYSADMIN and confirm that the issue no longer exists.