Tuesday, September 22, 2009

Oracle Apps R12 "default-web-site" range Issue

Issue

I was not able to validate oracle apps R12 self services. I noticed given below error in $INST_TOP/logs/appl/admin/log/adoacorectl.txt file while executing $INST_TOP/admin/scripts/adoacorectl.sh script to start services.

$INST_TOP/logs/appl/admin/log/adoacorectl.txt

09/22/09-17:14:46 :: adoacorectl.sh: Starting OPMN managed OACORE OC4J instance

 

opmnctl: starting opmn managed processes...

================================================================================

opmn id=ios11801e:6210

0 of 3 processes started.

 

ias-instance id=$CONTEXT_NAME.<SERVER_NAME>.<DOMAIN_NAME>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

--------------------------------------------------------------------------------

ias-component/process-type/process-set:

default_group/oacore/default_group/

 

Error

--> Process (index=1,uid=257344462,pid=0)

no port available from the port range

failed to start a managed process after the maximum retry limit

no port available from the port range

no port available from the port range

Log:

none

 

--> Process (index=2,uid=257344463,pid=0)

no port available from the port range

failed to start a managed process after the maximum retry limit

no port available from the port range

no port available from the port range

Log:

none

 

--> Process (index=3,uid=257344464,pid=0)

no port available from the port range

failed to start a managed process after the maximum retry limit

no port available from the port range

no port available from the port range

Log:

none

 

Solution

There are two solution either make sure port is free at operating system or change port range in 10.1.3 $IAS_ORACLE_HOME/opmn/conf/opmn.xml file.

<port id="default-web-site" range="21550-21554" protocol="ajp"/>

<port id="rmi" range="20050-20054"/>

<port id="jms" range="23050-23054"/>

Free up port at OS level

$ netstat -na | egrep '21550|21551|21552|21553|21554'

tcp 0 0 *.21550 *.* LISTEN

tcp 0 0 *.21551 *.* LISTEN

tcp 0 0 *.21552 *.* LISTEN

Ask your unix team to execute rmshock to free of these ports or change port rang in opmn.xml file and restart services.

Thursday, September 17, 2009

10giAS oiddas, sso login problem using orcladmin user

Problem/Issue

I noticed I was not able to login to OID (http://hostname.domain.name:<port>/oiddas) and SSO (http://hostname.domain.name:<port>/sso) URL using orcladmin user.

I was able to validate orcladmin password using given below.

$ ldapbind -h <OID_SERVER> -p <LDAPPORT> -D cn=orcladmin -w <oldorcladmin password>

bind successful

Solution

To resolve above issue I have performed following.

  1. Unlock orcladmin account

    [orassod@ios10901e] /opt02/app/oracle/ssodoid/10.1.0/ldap/bin

     

    $ $ORACLE_HOME/ ldap/bin/oidpasswd connect=SSOD unlock_su_acct=true

    OID DB user password:

    OID super user account unlocked successfully.

     

    This instance is already registered with OID Server. OID Registration will be skipped.

    Noteà Supply old orcladmin password against "OID DB user password"

  2. Uncheck "Global Lockout" to avoid future lock out issue of orcladmin password

    Start Oracle Directory Manager

    Start à Programs à Oracle Home 1 à Integrated Management Tools à Oracle Directory Manger

    Once GUI starts enter OID server hostport

     

    Navigate to "Oracle Internet Directory Servers" à "Password Management Policy" à "Password Policy for Realm"

    On right hand side click on "Account Lockout" tab and uncheck "Global Lockout" check box

     

  3. Reset orcladmin password

    Start Oracle Directory Manager

    Start à Programs à Oracle Home 1 à Integrated Management Tools à Oracle Directory Manger

    Once GUI starts enter OID server host, LDAP port

    Navigate to "Oracle Internet Directory Servers" à "Entry Management" à dc=<domain> à dc=<subdomin> à cn=Users

    Click on Search button on Right hand side and search for user orcladmin

    Double click on orcladmin search result "Entry: cn=orcladmin :" window would get open.

    Scroll down to userpassword attribute and reset orcladmin password to old password and click on "OK" button and then "Apply" button

  4. Validate orcladmin password

    http://<servername>.<domainname>:<port>/oiddas

    http://<servername>.<domainname>:<port>/sso

     

     

     

     

     

Friday, September 11, 2009

REP-0185: Bad load arguments supplied when starting up the Reports Server

My senior asked me to address oracle apps 11i report server issue. Report server was not coming up and I noticed given below error in "$COMMON_TOP/admin/log/$CONTEXT_NAME/rep60_$CONTEXT_NAME.txt" file.

Error

09/11/09-14:03:52 :: starting Reports Server for IRIST on port 7060.

REP-0185: Bad load arguments supplied when starting up the Reports Server

09/11/09-14:04:31 :: adrepctl.sh: exiting with status 0

 

Troubleshooting

 

I noticed issue could be due to MINENGINE, MAXENGINE, and INITENGINE fault configuration.

 

Reference:

Subject: Troubleshooting Reports Server service start-up errors on Windows or UNIX.

Doc ID: 223807.1

 

Solution

I moved 8.0.6 $ORACLE_HOME/reports60/server /REP60_"$TWOTASK".ora to $ORACLE_HOME/reports60/server /REP60_"$TWOTASK".ora.old and restarted apache and report server successfully.