Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status

Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status

/u01/app/applmgr/TST123/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm

-lpthread

/usr/bin/ld: cannot find /u01/prod/apps/tech_st/10.1.2/lib/stubs/libc.so.6

collect2: ld returned 1 exit status

make: *** [/u01/app/applmgr/TST123/apps/apps_st/appl/ad/12.0.0/bin/adpchnew]

Error 1

Done with link of ad executable 'adpchnew' on Thu Oct 27 22:11:12 EDT 2016

Relink of module "adpchnew" failed.

See error messages above (also recorded in log file) for possible

reasons for the failure.  Also, please check that the Unix userid

running adrelink has read, write, and execute permissions

on the directory /u01/app/applmgr/TST123/apps/apps_st/appl/ad/12.0.0/bin,

and that there is sufficient space remaining on the disk partition

containing your Oracle Applications installation.

Relinking module 'adrebase' in product ad ...

Solution:

B) Workaround

1. Source 10.1.2 OH

2. Execute the following command to edit the file:

vi $ORACLE_HOME/lib/stubs/libc.so

Update file contents from:

GROUP ( < Old ORACLE_HOME >/lib/stubs/libc.so.6 /usr/lib/libc_nonshared.a )

to:

GROUP ( < New ORACLE_HOME >/lib/stubs/libc.so.6 /usr/lib/libc_nonshared.a )

3. After this update, using the 'oracle' account, execute the following command:

$ rm -fr /tmp/* (all oracle owned files)

4. Source the APPS Envrionment, then apply the following steps:

  a) Execute the script $IAS_ORACLE_HOME/appsutil/clone/adlnkweboh.sh

  b) Execute the script $ORACLE_HOME/appsutil/clone/adlnktools.sh

Ref Note:

After Cloning Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status (Doc ID 1275418.1)

Find out HRMS Family Pack level upto RUP9

SELECT 'HR_PF.' ||
DECODE (BUG_NUMBER,'2115771' ,'A(2115771)',
'2268451' ,'B(2268451)',
'2502761' ,'C(2502761)',
'2632500' ,'D(2632500)',
'2803988' ,'E(2803988)',
'2968701' ,'F(2968701)',
'3116666' ,'G(3116666)',
'3233333' ,'H(3233333)',
'3127777' ,'I(3127777)',
'3333633' ,'J(3333633)',
'3500000' ,'K(3500000)',
'5055050' ,'K RUP1(5055050)',
'5337777' ,'K RUP2(5337777)',
'6699770' ,'K RUP3(6699770)',
'7666111' ,'K RUP4(7666111)',
'9062727' ,'K RUP5(9062727)',
'10015566' ,'K RUP6(10015566)',
'12807777', 'K RUP7(12807777)',
'14488556', 'K RUP8(14488556)',
'17774746','.K RUP9(17774746)') ||
' patchset is installed ' "HR Family Pack",
to_char(last_update_date,'DD-MON-YYYY HH24:MI:SS') "DATE APPLIED"
FROM AD_BUGS
WHERE BUG_NUMBER in ('2115771','2268451','2502761','2632500','2803988',
'2968701','3116666','3233333','3127777','3333633','3500000', '5055050',
'5337777','6699770','7666111','9062727','10015566','12807777','14488556','17774746')
ORDER BY to_number(BUG_NUMBER) DESC
/

Ref Note: SQL: HRMS Products Installation Status (Doc ID 414631.1)

Find out ATG RUP level patches information upto RUP7

select
substr(bug_number,1,10) BUG,
decode(bug_number,
'3438354','ATG_PF.H',
'4017300','ATG_PF.H RUP 1',
'4125550','ATG_PF.H RUP 2',
'4334965','ATG_PF.H RUP 3',
'4676589','ATG_PF.H RUP 4',
'5473858','ATG_PF.H RUP 5',
'5903765','ATG_PF.H RUP 6',
'6241631','ATG_PF.H RUP 7') PATCH,
creation_date Applied_date
FROM apps.ad_bugs
WHERE bug_number IN
(
'3438354',
'4017300',
'4125550',
'4334965',
'4676589',
'5473858',
'5903765',
'6241631')
order by bug_number desc
/

Source: How To Find Which Release Update Pack (RUP) Patches Have Been Applied For Release 12 (Doc ID 560498.1)

Unable To Create New Legal Entities - ORA-06512: at "CTXSYS.DRVDML" , ORA-06512: at "HR.DR$HR_LOCATIONS_N1TC

Unable To Create New Legal Entities - ORA-06512: at "CTXSYS.DRVDML" , ORA-06512: at "HR.DR$HR_LOCATIONS_N1TC

Solution:

Disable the trigger

HR.DR$HR_LOCATIONS_N1TC

Note: (Doc ID 1516486.1)

BI Publisher (formerly XML Publisher) Requests Are Failing With Error "OPP Error Oracle.apps.xdo.XDOException: Error Creating Lock File

BI Publisher (formerly XML Publisher) Requests Are Failing With Error "OPP Error Oracle.apps.xdo.XDOException: Error Creating Lock File

Error

oracle.apps.xdo.XDOException: Error creating lock file
        at oracle.apps.xdo.oa.util.FontCacheManager.createLockFile(FontCacheManager.java:363)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFromDB(FontCacheManager.java:412)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFilePath(FontCacheManager.java:221)
        at oracle.apps.xdo.oa.util.FontHelper.createFontProperties(FontHelper.java:432)
        at oracle.apps.xdo.oa.util.ConfigHelper.getFontProperties(ConfigHelper.java:166)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5817)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:179)
[9/10/14 4:28:52 AM] [493966:RT178323863] Output file was found but is zero sized - Deleted
[9/10/14 4:28:52 AM] [UNEXPECTED] [493966:RT178323863] oracle.apps.xdo.XDOException: Error creating lock file
        at oracle.apps.xdo.oa.util.FontCacheManager.createLockFile(FontCacheManager.java:363)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFromDB(FontCacheManager.java:412)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFilePath(FontCacheManager.java:221)
        at oracle.apps.xdo.oa.util.FontHelper.createFontProperties(FontHelper.java:432)
        at oracle.apps.xdo.oa.util.ConfigHelper.getFontProperties(ConfigHelper.java:166)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5817)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:179)

Troubleshooting

1. Check the error in OPP logs. Log file location is

cd $APPLCSF/$APPLLOG
ls --ltr FNDOPP* | tail

Solution

1. Login to Front End, Goto XML Publisher Administrator -> Administration -> General Tab -> Temporary directory

2. Make sure the Temporary directory path is set correctly as mentioned in the above

3. Make sure that this directory can be written to by applmgr from the node that the OPP is running on. You can use the touch command to test this.

4. Set the temporary directory to it's own directory at least 20x larger than the largest data file used by XMLP. Start off with at least 5GB.

5. Try resetting the diretory to a different directory on the same mount as the OPP

6 Bounce Concurrent Manager

7. Retest the issue

Reference: Doc ID 1512691.1

Find out APPS/SYSADMIN password in Oracle Apps R12 if you lost or forgotten

Step to Find APPS PASSWORD :

Step #1

sqlplus> sqlplus system/system_password
sqlplus / as sysdba

Step#2:  Create Function to decrypt the encrypted password

SQL> create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
/
Function created.

Step#3: Query for password

set linesize 200 long 300

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';

ENCRYPTED_FOUNDATION_PASSWORD

--------------------------------------------------------------------------------

ZG379C5C883FF56235BE975D075A6FD2E7A749279B7BFCE331530B443E86F41A1966E3E4B1864519DB88BC07D58666AD837B

Step#4:  Get the Apps password using encrypted guest password

SQL> SELECT apps.decrypt_pin_func('GUEST/ORACLE','ZG379C5C883FF56235BE975D075A6FD2E7A749279B7BFCE331530B443E86F41A1966E3E4B1864519DB88BC07D58666AD837B') from dual;

APPS.DECRYPT_PIN_FUNC('GUEST/ORACLE','ZG379C5C883FF56235BE975D075A6FD2E7A749279B

--------------------------------------------------------------------------------

APPS123

Step#5: Test apps password

SQL> conn apps/APPS123;

Connected.

Step to Find SYSADMIN PASSWORD :

Step# 1:

SQL> conn apps/APPS123;

Connected.

Step#2:

SQL> CREATE OR REPLACE PACKAGE get_pwd AS

FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)

RETURN VARCHAR2;

END get_pwd;

/ 

Package created.

Step# 3:

SQL>

 CREATE OR REPLACE PACKAGE BODY get_pwd  AS

 FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)

 RETURN VARCHAR2

 AS  LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String'; END get_pwd;

 /

Package body created.

Step# 4:

SQL> SELECT usr.user_name,

       get_pwd.decrypt

  2    3            ((SELECT (SELECT get_pwd.decrypt

  4                                (fnd_web_sec.get_guest_username_pwd,

  5                                 usertable.encrypted_foundation_password

  6                                )

  7                        FROM DUAL) AS apps_password

  8                FROM fnd_user usertable

  9               WHERE usertable.user_name =

 10                        (SELECT SUBSTR

 11                                    (fnd_web_sec.get_guest_username_pwd,

 12                                     1,

 13                                       INSTR

 14                                            (fnd_web_sec.get_guest_username_p

 15                                             '/'

 16                                            )

 17                                     - 1

 18                                    )

 19                           FROM DUAL)),

 20             usr.encrypted_user_password) PASSWORD

  FROM fnd_user usr

 WHERE usr.user_name = '&USER_NAME';

Enter value for user_name: SYSADMIN

old  23:  WHERE usr.user_name = '&USER_NAME'

new  23:  WHERE usr.user_name = 'SYSADMIN'

USER_NAME                                     PASSWORD

------------------------                        -----------------

SYSADMIN                                        SYSADMIN123

Step#5 :  Bellow sql will help you to validate SYSADMIN Password

SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN123) from dual;

FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN123')

--------------------------------------------------------------------------------

Y

Unable to determine SMTP server to use: set FND_SMTP_HOST

Outpost Processor has encountered the below error.

This error can be found in OPP logs:
----------------------------------------
[GC 14000K->8905K(20284K), 0.0074280 secs]
ProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST
        at oracle.apps.fnd.cp.opp.EmailDeliveryProcessor.deliver(EmailDeliveryProcessor.java:66)
        at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
----------------------------------------

Solution:

1. Log into System Administrator responsibility.
2. Navigate to Profile - System.
3. Query up the %smtp% profiles.
4. Set the following profile values to the defined host and port:
FND:smtp Host (Hostname or IP)
FND:smtp Port (Default is 25)

Ref : R12: "PostProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST" Error In OPP manager log file When Selecting Delivery Opts in FNDRSRUN to Send Email Notifications (Doc ID 1240768.1)