Reset OC4J Admin Password for OAS

 Source - http://www.dbuggr.com/milly/steps-reset-oc4j-admin-password/

 Steps on how to reset OC4J Admin Password

If you lost your oc4jadmin password (Oracle Application Server admin), follow the steps below to update the password - 

Follow the steps below to reset oc4jadmin user: 

Stop OC4J and the Application Server Control. (opmnctl stopall)

1. Edit system-jazn-data.xml file with text editor

(UNIX) $OAS_HOME/j2ee/home/config/system-jazn-data.xml

(Windows) $OAS_HOME\j2ee\home\config\system-jazn-data.xml

Search for “oc4jadmin” user in system-jazn-data.xml. You’ll see something similar to this:

      

        oc4jadmin

        OC4J Administrator

        492DECF0CF0B11DEBF5CAF614F0D6C07

        OC4J Administrator

        {903}54k7kX7gDQLsdOnXAgEq1+GCKi20hhGH

      

2. Replace the encrypted password string between tag to the password you desire. Make sure you prefix the password with an exclamation point (!) and also follow the password requirements for OAS. For example:

      

        oc4jadmin

        OC4J Administrator

        492DECF0CF0B11DEBF5CAF614F0D6C07

        OC4J Administrator

        !mynewpassword1

      

3. Delete everything under persistence directory (do not delete persistence directory itself):

(UNIX) $OAS_HOME/j2ee/oc4j_soa/persistence/

(Windows) $OAS_HOME\j2ee\oc4j_soa\persistence\

4. Start OC4J and the Application Server Control. (opmnctl startall)

Open Source Application Server

The open source application servers compared in this article, with descriptions from their respective Web sites, will be:

• Geronimo. "The goal of the Geronimo project is to produce a server runtime framework that pulls together the best Open Source
  alternatives to create runtimes that meet the needs of developers and system administrators."

• GlassFish. "GlassFish is an open source, production-ready, Java EE-compatible application server. GlassFish version 3 provides a small footprint, fully-featured implementation of Java EE 6."

• JBoss. "JBoss Enterprise Application Platform balances innovation with enterprise class stability by integrating the most popular
  clustered Java EE application server with next generation application frameworks."

• Jetty. "Jetty provides a Web server and javax.servlet container, plus support for Web Sockets, OSGi, JMX, JNDI, JASPI, AJP and many
  other integrations."

• JOnAS. "JOnAS is a leading edge Java EE 5 certified Open Source OSGi Enterprise Server developed by Bull and OW2."

• Resin. "Resin is a smoking hot Java EE 6 web server. It is built on our distributed-agent technology for the elastic cloud."

• Tomcat. "Apache Tomcat is an open source software implementation of the Java Servlet and JavaServer Pages technologies."

Web Dev Feature SQL

Forgot adding Web Dev Feature in Full Package Assemble and build.

Shot cut to add feature in assembly after Package build.

1.) INSERT INTO JDE900.SY900.F9631 VALUES('C','WEBDEVOC4J','DVF001','DV910',' ',' ',' ','1',' ','P9601','DEP1',114092,123027.000000,'JDE')

Here
Full package - DVF0001
Environment - DV910
Machine - DEP1

2.)  Add following line in end of  E:\JDEdwards\E910\PACKAGE_INF\DVF001.inf

[FEATURE]

WEBDEVOC4=\\DEP1\E910\package_inf\feature_inf\WEBDEVOC4J.INF

After this you can install Full package on Fat Client and Web Dev Feature will install.

Purge WorkCenter Message

Purge Bulk Work Center using SQL :-


Purging WorkCenter Message first time is too time consuming as there are millions of record.  Use below select statement to count records and then using delete purge them.


Note: -The Order of SQL is important, because data are inter-dependent on each other.

SELECT COUNT(*) from PRODDTA.F00166 where GTOBNM='GT01131'
AND GTTXKY IN (SELECT ZZSERK from PRODDTA.F01131 where ZZDTI lt 113170);

SELECT COUNT(*) from PRODDTA.F00165 where GDOBNM='GT01131'
AND GDTXKY IN (SELECT ZZSERK from PRODDTA.F01131 where ZZDTI lt 113170);

SELECT COUNT(*) from  proddta.F01131T where
ZCSERK in (SELECT zzserk)from PRODDTA.F01131 where ZZDTI lt 113170);

SELECT COUNT(*) from PRODDTA.F01131M where ZMDTI lt 113170;

SELECT COUNT(*) from  proddta.F01133 where
ZTSERK in (SELECT zzserk from PRODDTA.F01131 where ZZDTI lt 113170);

SELECT COUNT(*)  from PRODDTA.F01131 where ZZDTI lt 113170;

 Clear Orphaned Record R01131M with Data Selection  on ZMDTI


Now do your regular maintenance to Purge Work Center message with R01131P

Question 1:  In what tables are the Work Center Messages stored?

Answer 1: The Work Center is the hub of all messages within EnterpriseOne. Work Center messages are stored in the following tables:

•     F01131        PPAT Message Control File
•     F01133        PPAT Message Detail File
•     F01131M     JDEM Multi Level Message
•     F01131T      Message Attachment Tag File
•     F00165        Media Object Storage (identified under GT01131)
•     F00166        Media Object Categories (identified under GT01131)

JVM JAS to run on different timezone

Setup JVM to run on different Time Zone then the Time Zone on Machine

Add JVM arguments at smae place where you have other arguments like Xmx, Xms etc ...

For eg JVM running on India Time Zone.

-Duser.timezone=GMT+09:30

F00165 Change Media Object Location

Media Object Change Location

1. Change New Location in P98MOQUE
2. Copy Media Object File to new Location
3. Update F00165 Table


UPDATE PRODDTA.F00165 SET GDGTFILENM = REPLACE(RTRIM(GDGTFILENM),'\\OldMachine\E900\MEDIAOBJ\HTMLUpload\','\\OldMachine\E900\MEDIAOBJ\HTMLUpload\') WHERE GDGTFILENM LIKE '%\\OldMachine\E900\MEDIAOBJ\HTMLUpload\%';

Weblogic Start Admin Server and managed Server on Reboot

#!/bin/bash
#
# oracle Init file for starting and stopping WLS
# Created by Vivek Jain
# chkconfig: 35 80 30
# description: Oracle WLS startup script
# Source function library
# chmod 755 /etc/init.d/wls
# chkconfig --add wls --level 0356
# nodemanager properties CrashRecoveryEnabled=true,StartScriptEnabled=true


. /etc/rc.d/init.d/functions

ORACLE_OWNER="oracle"
MW_HOME="/u01/app/Oracle/Middleware"
DOMAIN_HOME="/u01/app/Oracle/Middleware/user_projects/domains/E1_HTTP_PD"

case "$1" in
start)
echo -n $"Starting WLS:"
su - $ORACLE_OWNER -c "nohup /u01/JDE_HOME/SCFHA/bin/startAgent > /dev/null &"
su - $ORACLE_OWNER -c "nohup $MW_HOME/wlserver_10.3/server/bin/startNodeManager.sh > $MW_HOME/wlserver_10.3/common/nodemanager/nodemanager.out 2>&1 &"
su - $ORACLE_OWNER -c "nohup $DOMAIN_HOME/bin/startWebLogic.sh > $DOMAIN_HOME/servers/AdminServer/logs/AdminServer.out 2>&1 &"
echo "OK"
;;
stop)
echo -n $"Stopping WLS:"
su - $ORACLE_OWNER -c "nohup $DOMAIN_HOME/bin/stopWebLogic.sh > $DOMAIN_HOME/servers/AdminServer/logs/AdminServer.out 2>&1 &"
ps -ef | grep NodeManager | grep -v grep | awk '{system("kill -9 "$2)}'
su - $ORACLE_OWNER -c "nohup /u01/JDE_HOME/SCFHA/bin/stopAgent > /dev/null &"
echo "OK"
;;
restart)
echo -n $"Re-Starting WLS:"
stop
sleep 3
start
;;
*)
echo $"Usage: $0 {start|stop|restart}"
esac

Reset Weblogic admin password

 How to change WEBLOGIC Console admin password for 11g (10.3)

1-First set environment variables
export BEAHOME=/u01/app/oracle/product/middleware
export DOMAIN_HOME=$BEAHOME/user_projects/domains/base_domain
export CLASSPATH=$CLASSPATH:$BEAHOME/wlserver_10.3/server/lib/weblogic.jar
cd $DOMAIN_HOME/bin
. ./setDomainEnv.sh

2- Now execute the command below to create the new password
cd ../security
mv DefaultAuthenticatorInit.ldift oldDefaultAuthenticator
java weblogic.security.utils.AdminAccount weblogic new_password . --DON'T FORGET THE "."


3- If it exists remove boot.properties file

cd ../servers/AdminServer
mv data data_old
cd security/
mv boot.properties oldboot.properties

4- Restart Weblogic server

cd $DOMAIN_HOME./startWebLogic.sh

How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile

Accident may happens, even though it’s costly one. This is especially the case in Oracle database, which stores the database objects physically in data files on hard disk. Fast hand administrators may accidentally delete some of the datafiles, or the datafiles may get corrupted or unreadable on hard disk failure. You may get also some missing datafiles after database recovery process. In any case, missing a or a few datafiles will cause Oracle database to fail to startup, rendering the whole DB inaccessible.

The solution to the missing datafiles is to drop the affected tablespace where has incomplete datafiles, and then recreate the tablespace and import the data into the tablespace from backup. However, the steps are not so straight forward.

1. Run SQL*Plus.
2. Connect to database as SYSDBA with this query: CONNECT / AS SYSDBA
   
3. Mount the database instead of starting it up: STARTUP MOUNT;
   
4. Issue the following command to bring the missing datafile offline so that Oracle won’t trying to connect and access the datafile anymore: ALTER DATABASE DATAFILE ‘’ OFFLINE DROP;
   Repeat the command for every datafiles that unaccounted for.
5. Now start the database proper: ALTER DATABASE OPEN;
   
6. As the tablespace has damaged, drop it to recreate from fresh backup. DROP TABLESPACE INCLUDING CONTENTS;
   
7. Ensure the other datafiles for the tablespace has been deleted, if not, remove them manually from the operating system. Tip: How to check datafiles that belong to tablespace.
8. Continue with the recovery process.