Category Archives: Linux - Page 5

Checking for Prerequisite Patches and Patch Levels

Posted by on March 16, 2009 No comments

In a patch’s README file, the prerequisite patches and patch levels that must be in place before that patch is applied are listed. Patches are indicated by a patch number (usually seven digits long), for example, 4712852. Patch levels  are usually of the form 11i.<PRODUCT CODE>.<LETTER>, for example, 11i.GL.H.

To determine if a particular prerequisite patch has already been applied to the system, query the AD_BUGS table.

Step 1:        Source the environment to load SQL*Plus. Either the applications tier environment or database tier environment can be sourced.

[applmgr@appslinux /]$ cd /u2/oracle/vis2appl/
[applmgr@appslinux vis2appl]$ . APPSORA.env

Step 2:        Load SQL*Plus:

[applmgr@appslinux vis2appl]$ sqlplus apps/apps

Step 3:        To determine whether a particular patch has been applied, query the BUG_NUMBER column of the AD_BUGS table for the patch number. For example, to determine if the patch 4712852 has been applied to the system, issue this SQL query:

SQL> select bug_number, creation_date from ad_bugs where bug_number = '4712852';
BUG_NUMBER                     CREATION_DATE
------------------------------ -------------
4712852                        16-MAR-07

If the query returns a row, the patch has been applied, whereas if the query does not return any rows, then the patch has not been applied.

Step 4:        To determine the patch level of a product, query the PATCH_LEVEL columns of the FND_PRODUCT_INSTALLATIONS table. For example, to determine the patch level for the GL product, issue this SQL query:

SQL> select patch_level, status from fnd_product_installations where patch_level like '%GL%';
PATCH_LEVEL                    S
------------------------------ -
11i.GL.H                       I

Unable to connect from client machine to new 11.5.10.2 instance

Posted by on December 12, 2008 No comments

Problem:

After configuring TNS names on the client, tried to connect to new 11.5.10.2 instance but failed.

Solution:

Managed SQL Access enabled. To disable, follow these steps:

Step 1:        Login to E-Business Suite with the ‘System Administrator’ Responsibility.

Step 2:        Go to : Profile –> System

Step 3:        Query the Profile “SQLNet Access’ at Site Level.

Step 4:        Set the Profile with the Value : ALLOW_ALL

Step 5:        Save and Exit Oracle Applications

Step 6:        Run Autoconfig on the 9i ORACLE_HOME

cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME

adautocfg.sh

Step 7:        Bounce the 9i SQLNet Listener :

cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME

addlnctl.sh stop <SID>

addlnctl.sh start <SID>

Metalink Reference:

Subject:  11.5.10 New Features : Managed SQL*Net Access from Hosts

Doc ID:  Note:291897.1

Could not start Service Manager

Posted by on December 10, 2008 No comments

Problem:

Concurrent manager not starting on ebusinesstest. Checked Metalink Doc ID:  Note:104452.1 (Subject:  Troubleshooting Concurrent Manager (Unix specific). Changed to /u0/oracle/testcomn/admin/log/TEST_ebusinesstest ($APPLCSF/$APPLLOG) and check last .mgr file (TEST_0424.mgr). It showed the following error message:

Starting PASMGR Concurrent Manager                 : 24-APR-2009 12:29:17
Spawned Process 18408
Could not start Service Manager FNDSM_EBUSINESSTEST_TEST. The TNS alias could not be located, the listener process on EBUSINESSTEST could not be contacted, or the listener failed to spawn the Service Manager process.
Routine AFPEIM encountered an error while starting concurrent manager PASMGR with library /u0/oracle/testappl/pa/11.5.0/bin/PALIBR.
Check that your system has enough resources to start a concurrent manager process. Contact your system admi : 24-APR-2009 12:29:17
                     Process monitor session ended : 24-APR-2009 12:29:17

Solution:

Checked Metalink for message ‘Could not start Service Manager’. Checked Metalink Doc ID:  423170.1 (Subject:  Concurrent Manager Fails to Start Because of a ‘Could not start Service Manager FNDSM__’ Error)

To implement the solution, please execute the following steps:

1. Download and apply patch 3830807: ” PATCH 3293983 NEEDS TO INCLUDE ALL THE MAKEFILES UNDER THE 8.0.6 ORACLE_HOME”.

2. Launch adadmin and choose the task to relink all product executables.

3. Startup the Concurrent Manager.

The Concurrent Manager should start without any errors. There should be no errors in the 8.0.6 listener log file.

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

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

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.

Integrating UPK With Oracle E-Business Suite Help Menu

Posted by on November 26, 2008 No comments

This documentation shows how integrate UPK content into the Help menu of Oracle E-Business Suite. Examples are drawn from the VIS4 instance; your instance may vary.

Step 1:        After creating the content in UPK Developer, publish the content to a UPK Player package. From the Tools menu, click Publish Content.

Step 2:        Choose Publish All Modules and click OK.

Step 3:        Check Deployment – Player Package and click Next.

Step 4:        Click Next.

Step 5:        Click Publish.

The modules are published.

Step 6:        In this example, the module is exported to the C:Program FilesUser Productivity KitUPK Developer 27PublishPlayer for Add New Responsibility to Existing User directory.

Rename the output directory to remove spaces.

Step 7:        The published directory (upktest in this example) must be copied onto the server. It must be copied to the $COMMON_TOP/portal/<context name> directory.

For VIS4, the upktest directory and its contents must be copied to:

/u3/oracle/vis4comn/portal/VIS4_appslinux

Step 8:        Copy the odcontenturl.js file in the hemi directory to odcustomurl.js. Modify the ORACLEHELP_URL to point to the old Oracle E-Business Suite help file (use the format “http://<oracle server>:<port> /OA_HTML/jsp/fnd/fndhelp.jsp”):

ORACLEHELP_URL=”http://appslinux.support.com:8004/OA_HTML /jsp/fnd/fndhelp.jsp?dbc=vis4″

The odcontenturl.js is located in /u3/oracle/vis4comn/portal/VIS4_appslinux /upktest/ORACLE/hemi/ directory.

Step 9:        Log on to the VIS4 instance and select the System Administrator responsibility. Navigate to Profile > System. The Find System Profile Values form appears. In the Profile field, enter %Help% and then click Find.

Step 10:   Locate the Applications Help Web Agent profile option.

Enter the following URL in the Site field:

http://appslinux.support.com:8004/upktest/ORACLE/hemi/odhelp.html?dbc=/u3/oracle/vis4appl/fnd/11.5.0/secure/VIS4_appslinux/vis4.dbc

Then click Save.

Step 11:    Finally, log off Oracle Applications and then log back on. When Help is selected, a new link (UPK) appears. When it is clicked, the custom Player content appears.

References:

Content Administration PDF (located in C:Program FilesUser Productivity KitUPK Developer 27docsReference).

[amazon asin=1849680167&template=iframe image&chan=default]     [amazon asin=1482009374&template=iframe image&chan=default]