NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Validating Font End user password in Oracle Apps

No comments
If we need to validate the front end user password is working fine or not then we can fire the below query to check the authentication of password.

Login to Database as Apps user.

SQL> select fnd_web_sec.validate_login('GUEST','welcome') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','WELCOME')
--------------------------------------------------------------------------------
Y

If the output is Y  then password is correct and if it is N then it invalid.

No comments :

Post a Comment

Finding Debug Enabled on Profiles at DB level

No comments
Below query can be useful for finding the Debug Enabled on Profiles at Site,Application,Responsibilty and User Level.

select fpot.user_profile_option_name profile_name
, 'Site' lo
, 'SITE' lov
, fpov.profile_option_value pov
from applsys.FND_PROFILE_OPTIONS_TL fpot
, applsys.FND_PROFILE_OPTIONS fpo
, applsys.FND_PROFILE_OPTION_VALUES fpov
, applsys.FND_USER fu
where
(fpo.profile_option_name like '%DEBUG%' or
 fpo.profile_option_name like '%TRACE%' or
 fpo.profile_option_name like '%DIAG%' or
 fpo.profile_option_name like '%SQL%')
and fpot.profile_option_name = fpo.profile_option_name
and fpo.application_id = fpov.application_id
and fpo.profile_option_id = fpov.profile_option_id
and fpo.created_by = fu.user_id
and fpot.language = Userenv('Lang')
and fpov.level_id = 10001 /* Site Level */
and fpo.end_date_active is null
union all
select fpot.user_profile_option_name profile_name
, 'Apps' lo
, fa.application_name lov
, fpov.profile_option_value pov
from applsys.FND_PROFILE_OPTIONS_TL fpot
, applsys.FND_PROFILE_OPTIONS fpo
, applsys.FND_PROFILE_OPTION_VALUES fpov
, applsys.FND_USER fu
, applsys.FND_APPLICATION_TL fa
where
(fpo.profile_option_name like '%DEBUG%' or
 fpo.profile_option_name like '%TRACE%' or
 fpo.profile_option_name like '%DIAG%' or
 fpo.profile_option_name like '%SQL%')
and fpot.profile_option_name = fpo.profile_option_name
and fpo.profile_option_id = fpov.profile_option_id
and fpo.created_by = fu.user_id
and fpot.language = Userenv('Lang')
and fpov.level_id = 10002 /* Application Level */
and fpov.level_value = fa.application_id
and fpo.end_date_active is null
union all
select fpot.user_profile_option_name profile_name
, 'Resp' lo
, frt.responsibility_name lov
, fpov.profile_option_value pov
from applsys.FND_PROFILE_OPTIONS_TL fpot
, applsys.FND_PROFILE_OPTIONS fpo
, applsys.FND_PROFILE_OPTION_VALUES fpov
, applsys.FND_USER fu
, applsys.FND_RESPONSIBILITY_TL frt
where
(fpo.profile_option_name like '%DEBUG%' or
 fpo.profile_option_name like '%TRACE%' or
 fpo.profile_option_name like '%DIAG%' or
 fpo.profile_option_name like '%SQL%')
and fpot.profile_option_name = fpo.profile_option_name
and fpo.profile_option_id = fpov.profile_option_id
and fpo.created_by = fu.user_id
and frt.language = Userenv('Lang')
and fpot.language = Userenv('Lang')
and fpov.level_id = 10003 /* Responsibility Level */
and fpov.level_value = frt.responsibility_id
and fpov.level_value_application_id = frt.application_id
and fpo.end_date_active is null
union all
select fpot.user_profile_option_name profile_name
, 'User' lo
, fu2.user_name lov
, fpov.profile_option_value pov
from applsys.FND_PROFILE_OPTIONS_TL fpot
, applsys.FND_PROFILE_OPTIONS fpo
, applsys.FND_PROFILE_OPTION_VALUES fpov
, applsys.FND_USER fu
, applsys.FND_USER fu2
where
(fpo.profile_option_name like '%DEBUG%' or
 fpo.profile_option_name like '%TRACE%' or
 fpo.profile_option_name like '%DIAG%' or
 fpo.profile_option_name like '%SQL%')
and fpot.profile_option_name = fpo.profile_option_name
and fpo.profile_option_id = fpov.profile_option_id
and fpo.created_by = fu.user_id
and fpov.level_id = 10004 /* User Level */
and fpov.level_value = fu2.user_id
and fpot.language = Userenv('Lang')
and fpo.end_date_active is null
order by profile_name, lo, lov;

No comments :

Post a Comment

Finding Trace Enabled on Concurrent Program at DB level

No comments
We can use the below query to find the trace enabled at DB level.

 Select user_concurrent_program_name
 from applsys.fnd_concurrent_programs fp,
 applsys.fnd_concurrent_programs_tl fct
 where fp.concurrent_program_id = fct.concurrent_program_id
 and enable_trace <> 'N';

No comments :

Post a Comment

ERROR: Invalid java version found

2 comments
ERROR: Invalid java version found:
JVMJ9CL005E Incompatible class library version: requires VM v11, found v5
JVMJ9VM015W Initialization error for library jclscar_24(14): JVMJ9VM009E J9VMDllMain failed
Could not create the Java virtual machine.

Error in getting Java Command
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.


Result             : FAILED
===========================================================================
AC-50207: Fatal: Failed to execute one or more of the config tools during Context Value Management
Deactivating Context Value Management System.
System Exit Status: 1


If this error arises then that means the java is corrupted .

Even when we try to do fir command
java -version
if will bounce the same error.

ERROR: Invalid java version found:
JVMJ9CL005E Incompatible class library version: requires VM v11, found v5
JVMJ9VM015W Initialization error for library jclscar_24(14): JVMJ9VM009E J9VMDllMain failed
Could not create the Java virtual machine.

This might occur as a part of post clone steps and the steps will fail at that point.

Solution:

1. Run command "which java" in your terminal.
2. It will return a path as "/opt11/app/oracle/DEV/tech_st/10.1.3/appsutil/jdk/jre/bin/java".
3. The we will go to directory "/opt11/app/oracle/Prod/tech_st/10.1.3/appsutil" and take the backup for the current jdk version.
4. Now copy the full jdk directory from some working for Production system.
5. Then try to retest the issue.


2 comments :

Post a Comment

Autoconfig Completing with Error AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

7 comments
Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
Web tnsnames.ora instantiated

adgentns.pl exiting with status 2
ERRORCODE = 2 ERRORCODE_END
.end std out.

.end err out.



Explanation:

If this Error is occurring while running the Autoconfig then that means the autoconfig is not able to create the tnsnames.ora file.

The issue bounces when the post clone steps were not performed properly or the autoconfig was not run.
After this error a tnsnames.ora file will be generated but it will be only based on the template with wrong entry which makes the rest of steps of autoconfig fail.
Even the dbc file will be created only using the template.

Solution:

Start "sqlplus" and execute following commands :

    1. $ sqlplus apps/<Password>
    2. SQL> exec fnd_conc_clone.setup_clean

    3. Open a new terminal or shell and source the DB-Tier Environment. ($ORACLE_HOME/<SID>.env)

    4. Execute Autoconfig on the DB Tier. ($ORACLE_HOME/appsutil/bin/adconfig.sh)

    5. Switch back to the APPS environment or start a new terminal and source the APPS environment.

    6. Execute Autoconfig at the Apps Tier. ($AD_TOP/bin/adconfig.sh)

    7. Check the Autoconfig log for any errors and ensure that the services start correctly.

If you have multitier environment then perform autoconfig on all the DB Tiers first then on Apps Tiers

7 comments :

Post a Comment