Tuesday, September 28, 2010

Configure Oracle dbconsole...

For a 10g database I wanted to check something in the database console. When trying to start this console, I received the following error : OC4J Configuration issue. Oracle/ora102/oc4j/j2ee/OC4J_DBConsole_.local_ not found

The ORACLE_HOME is a shared one, meaning different databases use the same ORACLE_HOME. So, because of this there were some other directories but not the one I needed. I decided to configure the dbconsole for this database using the emca tool. ./emca -config dbcontrol db

STARTED EMCA at Sep 27, 2010 10:38:38 AM

EM Configuration Assistant, Version 10.2.0.1.0 Production

Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information:

Database SID:

Listener port number: 1521

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:  

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /oracle/ora102 Database hostname ................

Listener port number ................ 1521

Database SID ................

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ............... -----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y

Sep 27, 2010 10:43:24 AM

oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /oracle/ora102/cfgtoollogs/emca/wtcgo/emca_2010-09-27_10-38-38-AM.log. Sep 27, 2010 10:43:27 AM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ... Sep 27, 2010 10:45:02 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully Sep 27, 2010 10:45:02 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is http://host.domain:5503/em <<<<<<<<<<<

Enterprise Manager configuration completed successfully

FINISHED EMCA at Sep 27, 2010 10:45:02 AM

After this the dbconsole was running and I was able to check something for the customer.

Thursday, September 09, 2010

Oracle webcache and Oracle eBS 11i....

I have installe Oracle webcache 10.1.2.3.0 to act as a reverse proxy server for our Oracle eBS environments.
After installing the webcache, I used note 380486.1 to configure webcache for our R12 environments. Now, we can use the webcache url to enter the R12 application.
For our 11i environments I used note 306653.1
Using the webcache I am able to login the 11i application, but when starting a forms session I see the following error

'You don't have permission to access /pls//fnd_icx_launch.launch on this server.'

What is going on here ???