Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Wednesday, March 25, 2009

Concurrent Manager Startup Issues

Verify all the steps that are necessary to start a Service Manager successfully.
1. There should be a Service Manager defined.
Run the following statement as the APPS user:
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';
The above statement should return a value related to the CP node.

If the above does not return any value then please do the following: Go to $FND_TOP/patch/115/sql

Connect SQLPLUS as APPS user and run the following script :
afdcm037.sql.

This script will create libraries for FNDSM and create managers for preexisting nodes.

2. Verify the entries in the FND_NODES as correct.

Run the following statement as the APPS user:

select node_name "Node Name", node_mode "Mode", support_cp "C", support_web "W", support_admin "A", support_forms "F" from FND_NODES;

If the above statement returns any invalid node or IP address follow the steps provided in the following note to clean up and repopulate the table.

3. Verify entries in tnsnames.ora on CP node. The below entry should present in tnsnames.ora on CP node :

FNDSM_ORACLETEST_VIS=

(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626)) (CONNECT_DATA=
(SID=FNDSM)
)

)

FNDSM_ORACLETEST.oracle.com_VIS=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626))
(CONNECT_DATA=
(SID=FNDSM)
)
)

Where ORACLETEST is the "hostname", VIS is the "SID" and ".oracle.com" is domain.

4. Check that tnsping is successful for all entries related to FNDSM in tnsnames.ora on CP node.

$ tnsping FNDSM_ORACLETEST_VIS
TNS Ping Utility for Linux: Version 8.0.6.3.0 - (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626)) OK (50 msec)

$ tnsping FNDSM_ORACLETEST.oracle.com_VIS
TNS Ping Utility for Linux: Version 8.0.6.3.0 - (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=oracletest.idc.oracle.com)(PORT=1626)) OK (0 msec)

5. Verify that no error exists in APPS Listener log file on CP node and it is running.

APPS Listener should be up and running for Service Manager to be up and running as expected. There should not be any error in the APPS Listener log file.

If there will be any error in APPS Listener log file then the Service Manager will not start properly.

Check the APPS Listener log file.

You can find this APPS Listener log file in one directory up of $TNS_ADMIN named as "apps_&gt:SID&lt:.log".

6. Are you able to ping the host name/IP Address of the host. Host name and the related IP address should be pingable to get a connection like below :

$ hostname
ORACLETEST.oracle.com

$ ping ORACLETEST.oracle.com
PING ORACLETEST.oracle.com (10.100.100.10) 56(84) bytes of data. 64 bytes from ORACLETEST.oracle.com (10.100.100.10): icmp_seq=0 ttl=64 time=0.029 ms 64 bytes from ORACLETEST.oracle.com (10.100.100.10): icmp_seq=1 ttl=64 time=0.028 ms
--- ORACLETEST.oracle.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.028/0.028/0.029/0.005 ms, pipe 2

$ ping 10.100.100.10
PING 10.100.100.10 (10.100.100.10) 56(84) bytes of data. 64 bytes from
10.100.100.10: icmp_seq=0 ttl=64 time=0.028 ms
64 bytes from 10.100.100.10: icmp_seq=1 ttl=64 time=0.028 ms
--- 10.100.100.10 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 999ms
rtt min/avg/max/mdev = 0.028/0.028/0.028/0.000 ms, pipe 2

7. Verify FNDSM does not give the "segmentation fault" at the time of execution.

Go to $FND_TOP/bin
$ FNDSM <- Enter

It should not give any segmentation fault here.

If it is giving any segmentation fault then it means that the executable is not relinked well.

Relink the executable as below.

$ adrelink.sh force=y "fnd FNDSM"

For Linux Operating System Please follow the notes below to get correct the segmentation fault by FNDSM

Thursday, March 12, 2009

Integrating Apex 3.2 with R12 (With Oracle Application Server 10g on the other Machine)

Today, I need to blog out my experience with Apex integration with R12 E Business Suite!!!

How I did: as follows.

As you know how to install Oracle Application Server 10.1.2.0 (Database 10.1.0.4)

1. Download Application Server 10g from OTN
2. Unzip the content. It will create 4 Disks (Disk1, Disk2, Disk3 and Disk4)

3. From Disk1 run
$./runInstaller

This will bring up the welcome screen. Select the Oracle home and other requisites. Later,
Select to Oracle Application Server Infrastructure 10g (10.1.2.0.2)


It will create one new database, (10g, Version 10.1.0.4) and New OID, Oracle Application server single-sing on, metadata repository and others. (I will detailedly explain how we can configure Application server in a separate blog)

Finish the installation. This will bring you basic HTTP server (OHS managed by OPMN)

This is what we want right at the moment.

Write a profile for database as follows.
export ORACLE_HOME=/oracle/ASHOME/
export ORACLE_SID=apex
export PATH=$PATH:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_TERM=xterm
export ORACLE_OWNER=oracle
export TNS_ADMIN=$ORACLE_HOME/network/admin
export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export LDPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32

So my ORACLE_HOME is /oracle/ASHOME

Now the Application server is ready for operation. Check the Application server page correctly displays using
http://hostname:port (here my port no is 7778 ie. Apache Port from Application Server 10g)

Now, Apex Installation. Download apex_3.2.zip from here
Unzip the apex_3.2.zip into a separate direcory. It will create a folder called apex. My location is /oracle/apex

4. Connect as sys user.
5. Create a tablespace for apex. i created apex32 with datafile apex32
6. Run apexins.sql

SQL>@apexins.sql apex32 apex32 temp /i/
where apex32 is the tablespace name
where apex32 is the datafile name
temp is the temporary tablespace
/i/ is the location of the image folder to be given in the configuration file. (simply give /i/)

Successful installation will have the following content at the end.

Thank you for installing Oracle Application Express. Oracle Application Express is installed in the FLOWS_030200 schema.

The structure of the link to the Application
Express administration services is as follows: http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql) http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

The structure of the link to the Application Express development interface is as follows: http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

Installation logfile will be located under /oracle/apex as installYYYY-MM-DD_HH24-MI-SS.log.

7. Change Password for ADMIN Account
- Change directory to apex
- Connect to DB as sys user and execute
- @apxchpwd

Configure HTTP Server
1. Unlock the APEX_PUBLIC_USER account
alter user APEX_PUBLIC_USER account unlock

alter user APEX_PUBLIC_USER identified by (new password)


2. Copy APEX Images
- Copy /oracle/apex/images to /oracle/ASHOME/Apache/Apache/images/ .
This is the /i/ location where we installed our images.
$cp -rf /oracle/apex/images /oracle/ASHOME/Apache/Apache/images

Adding DAD entry in dads.conf file (in /oracle/ASHOME/Apache/modplsql/conf/)

Alias /i/ “[ Put the IMAGE_LOC Value] “ as /oracle/ASHOME/Apache/Apache/images
AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString hostname:port:SID (here my entry is genius:1521:apex (MY SID Name is apex)

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex

PlsqlDatabasePassword APEX_PASSWORD (here my entry is welcome)
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all

</Location>

Bounce the Apache Server as
/oracle/ASHOME/opmn/bin/opmnctl stopproc ias-component=HTTP_server

or if you want to stopall, then give ./opmnctl stopall. to bounce all the services.

Now Check with
http://hostname:port:/pls/apex/apex_admin (should bring you the welcome page of the Apex with images. Here my port is 7778 as installed in Application Server 10g OHS server)
if images are not coming, then further navigation is not possible. So check with the dads.conf. Please be sure to put /" at the end of the image location. I Forget that slash, later found from the error log.



If you face any errors, look into ORACLE_IAS_ORACLE_HOME/Apache/Apache/logs/error_log.xxxxxxxxxx

Now Oracle E BIZ R12 part.
Copy the apex3.2.zip file to the server where you have to install the Application Express.
Unzip the content into a directory
Source the database environment file

1. Connect as sys user from the directory where you unzipped apex files.
2. run @apexins.sql into the database (my R12 database version is 10.2.0.3)
after completion,
unlock the APEX_PUBLIC_USER account.
Change the password using @apxchpwd.sql from apex directory.

Login to the Application server 10g server.
1. Edit the dads.conf file from /Apache/modplsql/conf/
Now add the entry

<Location pls/apex_R12>
Order deny,allow
PlsqlDocumentPath docs

AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString hostname:port:SID (here my entry is fserver:1521:VIS (MY SID Name is VIS in the EBIZ server)

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$

PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex

PlsqlDatabasePassword APEX_PASSWORD (here my entry is welcome)
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all

</Location>

Now bounce the Apache of the Application server.

Test the Apex Installation by
http://hostname:port/pls/apex_r12/apex_admin


Troubleshooting is most vulnerable part here.
1. To check wwv_flow_fnd_user schema is locked or not
use
alter session set current_schema=flows_030100
/
select user_name':'account_locked':'security_group_id from wwv_flow_fnd_user
/

2.
TO change the Admin Password:
Changing the Password for the ADMIN Account
In a new installation of Oracle Application Express, or if you are converting a runtime environment to a development environment, you must change the password of the internal ADMIN account. In an upgrade scenario, the password will be preserved and carried over from the prior release.
To change the password for the ADMIN account:

1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:
On Windows:
SYSTEM_DRIVE:\ sqlplus /nolog
connect sys as sysdba

On UNIX and Linux:
$ sqlplus /nolog
connect sys as sysdba
When prompted, enter the appropriate password.
2. Run apxchpwd.sql. For example:
@apxchpwd
When prompted enter a password for the ADMIN account."

This does not require to change the password in the
ORACLE_HTTPSERVER_HOME/Apache/modplsql/conf/dads.conf File.

3. If You are getting ADMIN/ADMIN_PASSWORD as "Invalid Login Credential Error", then
run
alter user FLOWS_030200 account unlock;

connect as FLOWS_030200 and execute the procedure
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);

wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'myemail@mydomain.com',
p_web_password => 'admin2') ;

end;
/

Please be sure
alter user FLOWS_030200 lock;

Then try with "admin2" and "admin2" as password. This should work...

Stuffs to Read
http://download.oracle.com/docs/cd/E10513_01/doc/index.htm

To Remove the APEX installed schema from Oracle database, Run

from apex installed directory

sql>sqlplus "/as sysdba"

sql>@apxremov.sql

Hope this will help you !!!! Cheers!!!

Tuesday, March 10, 2009

500 Internal Error: oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126)

ERROR
500 Internal Server Error
java.lang.NoClassDefFoundError at
oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126) at
oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170) at com.evermind[Oracle
Containers for J2EE 10g (10.1.3.0.0)


Solution:
1. Assign an available port for "Distributed JVM cache" by using the following steps

a) Set the correct port in your Context File -> parameter "s_java_object_cache_port"

2. Run Autoconfig on all Middle Tiers

3. Make sure your System Profile "JTF_DIST_CACHE_PORT" has the same port specified

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.


But,
When I look into the alert log for details, i got ORA-00600

According to Note No. : 567554.1

The ORA-600 has no impact on the Database and is considered harmless so can be ignored, however it is an indication that it failed in the test to check if the library cache was empty.

After this Database error has occurred, it causes E-Business Suite Java Cache an issue during it's initialization phase.

Solution

Make sure that the Database was shutdown cleanly.

If an "ORA-00600 [LibraryCacheNotEmptyOnClose]" is received during a Database shutdown, then once restarted you will need to shutdown the Database again cleanly and re-start again in order to solve this problem for eBusiness Suite Java Cache

After upgrading the database to 9.2.0.8, Autoconfig fails on adcrobj.sh / afdbprf.sh on dbTier

Today, I held up with one issue in the upgraded Database, (ie) from 9.2.0.6 to 9.2.0.8.

When it is a need to run autoconfig on the database tier, it ended up in the errors that

1. [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during eachphase of its execution. Errors are grouped by directory and phase.
The report format is:
[APPLY PHASE]

AutoConfig could not successfully execute the following scripts: Directory: /oracle/Apps/visdb/9.2.0/appsutil/install/VIS_moonserver
adcrobj.sh INSTE8_APPLY 1

2. [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during eachphase of its execution. Errors are grouped by directory and phase.
The report format is:

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts: Directory: /oracle/Apps/visdb/9.2.0/appsutil/install/VIS_moonserver
afdbprf.sh INSTE8_PRF 1


AutoConfig is exiting with status 1

But the original error is
-------------------ADX Database Utility Finished---------------
Verifying connection to the Database : Could not be stablished

No Restore Profile file created.

Working towards the fix for the issue:

Metalink Note: ID: 415335.1
SymptomsRunning Autoconfig on the RDBMS Oracle Home fails to run adcrobj.sh - the error message may vary by platform.

Here is the error message on HP-UX 64 bit :

adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
O/S Message: Not a typewriter

Manual running of the adcrobj.sh did not seem to show this error, but failed to connect as "/ as sysdba" via SQL*PLUS.

The cause of this problem is documented in unpublished
Bug 5449623 - 'AUTOCONFIG FAILS ON DB TIER DUE TO ERROR IN EXECUTING ADCROBJ.SH'

FIX:

1.) Please download and apply Patch 5495695 corresponding to your platform. This is a one-off Patch for 9.2.0.8

To apply this patch:
a. Take care to include the OPatch in the PATH
b. Shutdown the database and Listener
c. opatch apply

Before patch application
Back up the iSQL*Plus executable:
## % cp $ORACLE_HOME/bin/sqlplus $ORACLE_HOME/bin/sqlplus_pre5495695

After applying the patch
mv $ORACLE_HOME/sqlplus/lib/sqlplus $ORACLE_HOME/bin/sqlplus

Rerun the autoconfig.

It should be completed successfully.

Monday, March 09, 2009

Oracle error &ERRNO: &REASON has been detected in &ROUTINE.

We will be unable to login using none of the seeded users nor custom users. Applications will not allow any user to be logged in.

For a VISION instance(only), if the Profile option "MO: Operation Unit" (short name for this profile options is ORG_ID) is changed to any other value apart from "Vision Operations", we encounter the above specified error.

Another place where we can check the error is when we run adstrtal.sh or adstpall.sh scripts. The following errors can be found in the log file:

Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit has been detected in FND_GLOBAL.INITIALIZE.
Solution

Following are steps to change the profile option from backend:

1. Get the Profile option ID using the following query:

SQL> Select PROFILE_OPTION_ID,PROFILE_OPTION_NAME from fnd_profile_options
where PROFILE_OPTION_NAME ='ORG_ID';

Example:
SQL> Select PROFILE_OPTION_ID,PROFILE_OPTION_NAME from fnd_profile_options
where PROFILE_OPTION_NAME ='ORG_ID';

2
PROFILE_OPTION_ID
-----------------
PROFILE_OPTION_NAME
--------------------------------------------------------------------------------
1991

ORG_ID


2. Run the following procedure which changes the profile option: Use 1991 as the PROFILE_ID

DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('ORG_ID',(enter the Profile ID from above query), 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;

3) Restart the apache server

Thursday, March 05, 2009

APP-FND-00738 SETUP_DESCR_VSETS, APP-FND-00706 and APP-FND-00770 Error While Setting Up An Organization

To implement the solution, please execute the following steps:
1. Go into the responsibility: System Administrator
2. Submit the concurrent process : Generate Messages
3. Enter parametersLanguage associated to your legislation
Application = Human Resources
and then run the process again for PayrollMode = DB_TO_RUNTIME
4. Restart Oracle Applications

HRMS - New Employee creation Errors out ORA-29861

Cause'PER_ADDRESSES_SPT' Index status is failed.
It should be valid.
unpublished bug 4440568 GET TRIGGER ERRORS ENTERING PEOPLE AND LOCATIONS IN HRMS
Reported issue points to a root cause of oracle spatial not being correctly installed on this environment.

Please fix your environment, re-run the index script noted above and recommence your testing.

Solution
To implement the solution, please execute the following steps in your test instance first:


1) ) Run $ORACLE_HOME/md/admin/mdinst.sql from 9iR2 Oracle_home.
connect as system/manager.

2) Forcefully drop the indexes.
connect apps/apps

drop index hr.HR_LOCATIONS_SPT force;
drop index HR.PER_ADDRESSES_SPT force;

3) Delete the entries from sdo_index_metadata_table
connect mdsys/mdsys

delete from sdo_index_metadata_table where sdo_index_name='HR_LOCATIONS_SPT';
delete from sdo_index_metadata_table wheresdo_index_name='PER_ADDRESSES_SPT';
commit;

4) rebuild the indexes.

sqlplus apps/apps @@$PER_TOP/patch/115/sql/irctxloc.sql HR applsys apps CTXSYS
sqlplus apps/apps @@$PER_TOP/patch/115/sql/irctxadr.sql HR applsys apps CTXSYS(
note : HR applsys apps CTXSYS are 4 parameters to the sql)

5) Verify that the index is valid by running

SQL > select DOMIDX_STATUS, DOMIDX_OPSTATUS from dba_indexes whereINDEX_NAME = 'PER_ADDRESSES_SPT';


BUT NONE OF THESE WORKED FOR ME. I DELETED THE INDEXES AND RETESTED THE ISSUE.. THE ISSUE GOT RESOLVED... :)
Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments