R12: How to change the hostname/IP address of an Database Tier using AutoConfig

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: R12: How to change the hostname/IP address of Apps  Database Tier using AutoConfig

Solution:

Sometimes we have a need of changing the hostname/domainname/port on database tier. Oracle recommends the following set of action rather than simply changing the context-file and running autoconfig.

1. Deregister the current database server

perl /appsutil/bin/adgentns.pl appspass=APPSpwd \
contextfile=$CONTEXT -removeserver

2. Update the AutoConfig Context files

DB Tier: Create a new context file using the following syntax : 

cd $ORACLE_HOME/appsutil/bin

perl adclonectx.pl contextfile=$CONTEXT_FILE.

3. Shutdown the Applications Tier Services

4. Reseed the Net Services Topology Model

Run AutoConfig on the Database Tier

./adconfig.sh contextfile=$ORACLE_HOME/appsutil/$SID_new_hostname>.xml

Run AutoConfig on the Applications Tier(s)

./adautocfg.sh appspass=appspasswd

5. Shutdown the Database Listener
6. Shutdown the Database 
7. Change the machine hostname 
edit the /etc/hosts file to update the new hostname/domainname.

8. Start the Database
9. Start the DB TNS Listener
10. Start the Applications Tier Services

References:

Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1]
@Note 840828.1 - 'R12: How to change the hostname/IP address of an Applications Tier using AutoConfig'
@Note 840847.1 - 'R12: How to change the hostname and/or port of the Database Tier using AutoConfig'

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

R12: How to change the hostname/IP address of an Applications Tier using AutoConfig

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: R12: How to change the hostname/IP address of an Applications Tier using AutoConfig


Solution:


1) Deregister the instance


first run the following sql:
select NAME, SERVER_TYPE from FND_APP_SERVERS;

Then run the following plsql using the info from the above sql:
exec FND_NET_SERVICES.remove_server('<SYSTEM_NAME'>, '<SERVER_NAME>');

# (The System name is the database name [select DB_NAME from FND_DATABASES;])

This plsql will need to be run twice to remove the apps & db server_type.
Then check the system has been deregistered by rerunning the first sql.


2) Stop all app services, db & lsnr


3) Change IP (ensure /etc/hosts has been updated)


4) Start db & lsnr


5) Run autoconfig on db, then apps tiers






References:


Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1]
@Note 840828.1 - 'R12: How to change the hostname/IP address of an Applications Tier using AutoConfig'
@Note 840847.1 - 'R12: How to change the hostname and/or port of the Database Tier using AutoConfig'

Get Oracle Certifications for all Exams
Free Online Exams.com