Sunday, October 23, 2011

Failed to start HTTP listener

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem Description: 


While trying to start agent installation on Active/passive environment ( using VIP), I am getting:
Starting agent failed ....... failed
Failed to start HTTP listener



+ emagent.trc


2010-12-13 13:43:49,532 Thread-1 ERROR http: snmehl_allocateListenerPort: failed to get host info. Could not resolve name


+ emagent.nohup
----- Mon Dec 13 13:43:52 2010::Checking status of EMAgent : 25414 -----
----- Mon Dec 13 13:43:52 2010::EMAgent exited at Mon Dec 13 13:43:52 2010 with return value 55. -----
----- Mon Dec 13 13:43:52 2010::EMAgent has exited due to initialization failure. -----



Solution:


  1) set the ORACLE_HOSTNAME parameter to vip Hostname
    2) Put an entry of vip Hostname in /etc/hosts file on both the active/passive host in pattern
         <IP Address>         <Hostname>.<DomainName>            <Hostname>
    3) Start the Agent
        emctl start agent



Further more :


1) Confirm the Hostname and port to which Agent is configured.
          1.1) Search for EMD_URL in $AGENT_HOME/sysman/config/emd.properties file
                 grep 'EMD_URL' $AGENT_HOME/sysman/config/emd.properties
          1.2) From the EMD_URL parameter value, we will get Hostname and port details
      2) nslookup <hostname in EMD_URL in emd.properties file>
      3) nslookup <IP Address> ,where <IP Address> we will get as a result of step - 2)
      4) export ORACLE_HOSTNAME=<hostname in EMD_URL in emd.properties file>
      5) export EMCTL_DEBUG=true
      6) $AGENT_HOME/bin/emctl start agent
      7) Please provide the output of each step as well as $AGENT_HOME/sysman/log/*
          As we debugging the emctl command, so will have more information in log/trc file and so we are requesting to send the "$AGENT_HOME/sysman/log/*" again.



Try Also:


The parameter EMD_URL in emd.properties file should have the Host using which the Agent has been configured.
Below are the steps to verify and correct the issue.

1. Understand Agent is installed with Physical hostname or Virtual Hostname
2. Run ifconfig to check whether there are multiple NICs
3. Check emd.properties file for parameter ListenOnAllNICs. Set it to False (as you have already done)
4. If Agent is installed with Physical hostname,
    Run the command "hostname" and check if it returns the same value
    If yes, then start the Agent.
    $AGENT_HOME/bin/emctl start agent
5. If Agent is installed with virtual hostname,
    set ORACLE_HOSTNAME=<emd_url host>
    start Agent
    $AGENT_HOME/bin/emctl start agent



Confirm the below:


Please confirm the few point regarding your setup/installation.


1. Is this location "/oradg2/orasys/Grid10g/agent10g" is shared location among both adsun4 and adsun5 nodes of active/passive setup ?
    (as per doc its prereqs)
2. Have yo installed agent on physical node to monitor the local services of physical node ?
3. What is the command used to install agent with virtual name ?
    Have you used the following command to install agent with virtual name ?
         $./runInstaller -invPtrLoc <shared location>/oraInst.loc ORACLE_HOSTNAME=adp2-lh.auh.police –debug
    if not , please could you paste the exact command used during agent installation ?
4. Exepcetd /etc/hosts entries should be as below:

****
127.0.0.1   localhost.localdomain  localhost
z.z.z.z.   adp2-lh.auh.police adp2-lh
x.x.x.x   adsun4.auh.police   adsun4
y.y.y.y   adsun5.auh.police   adsun5

&

on another node also entry shld be

127.0.0.1   localhost.localdomain  localhost
z.z.z.z.   adp2-lh.auh.police   adp2-lh
x.x.x.x   adsun4.auh.police   adsun4
y.y.y.y   adsun5.auh.police   adsun5

*****

5. Are you able to resolve the virtual hostname from each node with properr entry in /etc/hosts file ?
    Verify the following From active node :

 $hostname
 $more /etc/hosts | grep adp2-lh
 $ping adp2-lh.auh.police
 $nslookup adp2-lh.auh.police

6. Oracle recommend to follow the steps mentioned in the doc 406014.1
    Upload the following details from both the nodes ( zip files as node1 and node2)

$AGENT_HOME/config/emd.properties
$AGENT_HOME/emd/targets.xml
$AGENT_HOME/cfgtoolllogs/*
/etc/hosts


Get Oracle Certifications for all Exams
Free Online Exams.com

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:


rman target / catalog rman1/rman1@rman debug trace c:\debug.trace

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 10 11:02:57 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN-06005: connected to target database: BMC1 (DBID=3542203146)
RMAN-06008: connected to recovery catalog database

RMAN> list backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/10/2011 11:03:07
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set

RMAN>

AND FROM THE DEBUG FILE

DBGMISC: Finished cleanup at 10-JAN-11 [11:03:08.767]
DBGMISC: EXITED krmice [11:03:08.767] elapsed time [00:00:00:01.454]
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/10/2011 11:03:07
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . translateArchivedLogSCNRange ( thread# => NULL , fromscn => 0 , toscn => 281474976710655 + 1 , pattern => NULL , statusMask => :statusMask , online => :online , duplicates => :duplicates , needstby => :getstby , onlyrdf => :onlyrdf ) ; end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 21779
DBGMISC: ENTERED krmkursr [11:03:08.782]



Solution:




After bouncing the RMAN cataqlog database, issue resolved



Get Oracle Certifications for all Exams
Free Online Exams.com

Exception 300 (): table or view does not exist

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:


Checking again the first files rwEng-0.trc from the zip Reports Upload1
======================================================
Error 1
=========
[2011/1/24 10:4:31:692] (rwfdt:rwfdtgcf_GenCachefile) Cache file is D:\oracle\FR_AS\reports\cache\FN_R7011597774.pdf
..
...
[2011/1/24 10:4:31:723] Error 50103 (C Engine): 10:04:31 ERR ORA-00942: table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtprint): 10:04:31 ERR Error occurred sending Job output to cache
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): running
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): quit
[2011/1/24 10:4:31:739] Debug 50103 (EngineImpl:run): CRunReport returns: 300
[2011/1/24 10:4:31:754] Debug 50103 (EngineImpl:run): Quit
[2011/1/24 10:4:31:754] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

Error 2
===========
[2011/1/24 10:4:38:692] Error 50103 (rwfdt:rwfdtgcf_GenCachefile): Cache file is D:\oracle\FR_AS\reports\cache\FN_R7021055655.pdf
...

[2011/1/24 10:4:38:723] Error 50103 (C Engine): 10:04:38 ERR ORA-00942: table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtprint): 10:04:38 ERR Error occurred sending Job output to cache
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): running
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): quit
[2011/1/24 10:4:38:739] Debug 50103 (EngineImpl:run): CRunReport returns: 300
[2011/1/24 10:4:38:739] Debug 50103 (EngineImpl:run): Quit
[2011/1/24 10:4:38:739] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

Error 3
==========
2011/1/24 10:5:15:5] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)





Solution
Confirmed that the problem was a database permission issue.




1. Open your RDF file and verify which table will be used.
2. Now verify if your application user has the permission to select the table.
(For instance use SQL * Plus session to login to the database and try to execute a select statement with the same application user that will be used when you start Forms or Reports)
Get Oracle Certifications for all Exams
Free Online Exams.com

CCP:oradism functionality

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem Description: oradism process is not running


oradism file permission is as below
-r-sr-s--- 1 oracle dba oradism



not -rwsr-xr-x root dba oradism


grep -i dism /etc/security/exec_attr
returns nothing.



Explanation:


The use of DISM requires that the ora_dism process starts. The process will not start unless SGA_MAX_SIZE is greater than sum total of all SGA components.
This means that in case you use SGA_TARGET. you specify size of SGA_MAX_SIZE greater than SGA_TARGET


Please refer Doc ID 778777.1(When Will DISM Start On Oracle Database)

Please check the below parameter is enabled

_use_ism= TRUE



select a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value",
a.KSPPDESC "Describtion"
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and a.ksppinm like '_use_ism';





Dynamic intimate shared memory (DISM) is a unique feature of Solaris. It achieves dynamic memory management. On other OSs, When you specify SGA_MAX_SIZE, then the complete size of SGA_MAX_SIZE is reserved from your memory (reserved from Swap not from physical RAM) at instance startup. Then you can dynamically increase SGA_TARGET size until you reach SGA_MAX_SIZE. On Solaris, however, and due to DISM feature, SGA_MAX_SIZE is not reserved from the memory at instance startup but it is allocated when needed. This presents a great value since you do not reserve memory you are not using.

If DISM is not used then SGA_MAX_SIZE is reserved from your memory (reserved from Swap not from physical RAM).

By default, SGA_MAX_SIZE is not set during database installation and hence it takes the same value as SGA_TARGET. The use of SGA_TARGET is not a necessity to use DISM. Oracle will use DISM instead of ISM if SGA_MAX_SIZE is set larger than the total of the database buffers (in particular, db_cache_size dynamic SGA resizing is not supported with the older db_block_buffers parameter), the shared pool, the redo buffers, the large pool, the Java pool, the fixed size. In this case you will need to check the total of following parameters:

* db_cache_size
* java_pool_size
* large_pool_size
* log_buffer
* shared_pool_size
* streams_pool_size
* db_keep_cache_size
* db_recycle_cache_size

The difference between the total and the SGA_MAX_SIZE is so small that it can be approximated in calculations related to Granule size, so DISM should not be started, otherwise the ora_dism process will be started. .

Use of DISM does not depend on whether you use pfile or spfile.You can use DISM with pfile.







References:
 notes 1205673.1 and 1018855.1
Get Oracle Certifications for all Exams
Free Online Exams.com

multiple frmweb.exe processes are consunming all cpu and memory resources

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: 100% CPU utilization of Application Server Forms & Reports


application.log

=== ODM Data Collection ===
11/01/17 11:34:38 formsweb: Forms session <2094> exception stack trace:
java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)



Solution:



You are using webcache to run forms. It normally cause the performance problem when the number of users go high.


1) So you can disable webcache and run with HTTP Listen port (7778) in the URL.
2) Set "KeepAlive" directive in httpd.conf file to "Off" as below and restart the services and test. This will improve the performance.

KeepAlive Off

Note: You can set this parameter if you use forms application only. If you use any other applications like Portal then do not set this, try the first option.
Get Oracle Certifications for all Exams
Free Online Exams.com

oracle.apps.fnd.common.PoolException: Exception creating new Poolable object

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem Description: Exception creating new Poolable object




Login to application gives :


500 Internal Server Error
oracle.apps.fnd.cache.CacheException
at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:228)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1485)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:354)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1259)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1114)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1083)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1050)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1037)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:593)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:292)
at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1081)
at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:539)
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:120)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2232)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) .server.http.HttpApplication.findServlet(HttpApplication.java:4622)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4546) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2822) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:740) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230) at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error in IAS Cache: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object. at oracle.apps.jtf.cache.IASCacheProvider.get(IASCacheProvider.java:833) at oracle.apps.jtf.cache.CacheManager.getInternal(CacheManager.java:4802) at oracle.apps.jtf.cache.CacheManager.get(CacheManager.java:4624) at oracle.apps.fnd.cache.AppsCache.get(AppsCache.java:216) ... 33 moreCaused by: oracle.apps.jtf.base.resources.FrameworkException: An exception occurred in the method CacheAccess.getnullThe base exception is:Exception creating new Poolable object. at oracle.apps.jtf.base.resources.FrameworkException.convertException(FrameworkException.java:607) at oracle.apps.jtf.base.resources.FrameworkException.addException(FrameworkException.java:585) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:66) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:88) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:202) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:218) at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:249) ... 37 more



access_log.1306800000
10.1.25.56 - - [31/May/2011:10:27:09 +0400] "GET /OA_HTML/AppsLogin HTTP/1.1" 500 5672 229 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)"
10.1.25.56 - - [31/May/2011:10:47:04 +0400] "GET /OA_HTML/AppsLogin HTTP/1.1" 500 5672 152 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)"

debug.log
[May 31, 2011 10:25:19 AM GST]:1306823119991:-1:-1:erptest-temp.auh.police:130.130.100.135:oacore.default_group.2:412373572:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-ApplicationServerThread-1,5,RequestThreadGroup]:130.130.100.135:58850:1306823010799:4:STATEMENT:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.instantiateProfileStore(): s_constructorExtendedProfileStore=public oracle.apps.fnd.profiles.ExtendedProfileStore(oracle.apps.fnd.common.AppsContext)
[May 31, 2011 10:44:34 AM GST]:1306824274840:-1:-1:erptest-temp.auh.police:130.130.100.135:oacore.default_group.1:412373571:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-ApplicationServerThread-1,5,RequestThreadGroup]:130.130.100.135:11086:1306824274840:4:PROCEDURE:[fnd.common.WebAppsContext]:oracle.apps.fnd.common.WebAppsContext.makeConnectionManager(class oracle.apps.fnd.security.AppsConnectionManager): : BEGIN

javacache.log
[2011-05-31T09:23:28.435+04:00] [ias] [ERROR] [] [cache] [host: erptest-temp.auh.police] [nwaddr: 130.130.100.135] [tid: 10] [userId: appltest] [ecid: 130.130.100.135:38039:1306819169749:0,7] [[
oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1286)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1027)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:583)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:297)
...
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1423)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1215)
...
... 62 more
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
..
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1410)
... 72 more



Explanation:


Failed to change apps password by providing wrong apps password using FNDCPASS


log file shows


FNDCPASS was not able to decrypt password for user 'GCC' during applsys password change.
FNDCPASS was not able to decrypt password for user 'APPS' during applsys password change.
FNDCPASS was not able to decrypt password for user 'APPLSYS' during applsys password change.

. . . 


Solution:


RUn FNDCPASS using the right apps password
Get Oracle Certifications for all Exams
Free Online Exams.com

Login Fails After Changing The 'GUEST' Password To Either Mixed / Lowercase

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Explanation:


1. Please run the following SQL to check the GUEST password:
select fnd_profile.value('GUEST_USER_PASSWORD') from dual;
select fnd_web_sec.validate_password('GUEST','<Your Password Here>') from dual;
select fnd_message.get from dual;

select
user_id,
user_name,
to_char(start_date, 'DD-MON-RRRR') start_date,
decode(end_date,NULL,'*** NULL ***',to_char(end_date, 'DD-MON-RRRR') ) end_date,
decode(encrypted_foundation_password, 'EXTERNAL', 'EXTERNAL', 'LOCAL_LOGIN')
encrypted_foundation_password,
decode(encrypted_user_password,'EXTERNAL', 'EXTERNAL', 'LOCAL_LOGIN') encrypted_user_password,
decode(user_guid,NULL, '*** NULL ***',user_guid) user_guid
from fnd_user
where user_name = 'GUEST'
order by user_name


2. Please check the dbc files ( $FND_SECURE/*.dbc)

3. Please check the XML context file from apps tier:
$APPL_TOP/admin/<Context>.xml





GUEST password should match on the locations on the past 3 points


Solution:


1. Shutdown application services.

2. Please run the following as apps from SQL Plus:

exec fnd_user_pkg.EnableUser(username=>'GUEST');
commit;

3.



cd $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/
vi oc4j.properties
earch for LONG_RUNNING_JVM=true, replace for LONG_RUNNING_JVM=false.
Save the changes and bounce oacore container as follows:
cd $INST_TOP/admin/scripts
adoacorectl.sh stop
<wait some minutes>
adoacorectl.sh start



3. Please start the services, and check if the application is now accessible.


References:


Login Fails After Changing The 'GUEST' Password To Either Mixed / Lowercase In R12 (Doc ID 602425.1)
R12: One Stop Shop for all Login Issue after 'GUEST' Password Changes (Doc ID 744098.1)
Get Oracle Certifications for all Exams
Free Online Exams.com