Re set GLOGLOAD user password in OTM

++++++++++++++++++++++++++++++++++++++++++++++
How to change the password of glogload?
++++++++++++++++++++++++++++++++++++++++++++++++
Step 1: Shutdown OTM application services.
a) Stop the Web Server
---------------------------
/u01/OTM636/otm/install/ohs
[oracle@wlsadmin ohs]$ ./glogweb-wl stop
Stopping Oracle HTTP Server
opmnctl stopall: stopping opmn and all managed processes...
Stopping Tomcat Web Container...
[oracle@wlsadmin ohs]$



b) Stop the Application Server
-----------------------------
[oracle@wlsadmin weblogic]$ pwd
/u01/OTM636/otm/install/weblogic
[oracle@wlsadmin weblogic]$ ./glogapp-wl stop
Stopping WebLogic Application Server...
[oracle@wlsadmin weblogic]$
[oracle@wlsadmin weblogic]$


Step 2: Change the database passwords.
---------------------------------------

SQL> alter user glogload identified by Rockon11g;

User altered.

SQL>


Step 3: Encode the password for GLOG.
-------------------------------------------
[oracle@wlsadmin install]$ pwd
/u01/OTM636/otm/install
[oracle@wlsadmin install]$ . ./gc3env.sh
[oracle@wlsadmin install]$ java glog.util.appclass.Base64Encoding Rockon11g
<Um9ja29uMTFn>
[oracle@wlsadmin install]$



ii)
Backup  glog.properties.
-----------------------------
[oracle@wlsadmin config]$ cp -r glog.properties glog.properties_29april2015
[oracle@wlsadmin config]$ ls -ltrh glog.properties glog.properties_29april2015
-rwxr-----. 1 oracle dba 15K Apr 29 09:35 glog.properties
-rwxr-----. 1 oracle dba 15K Apr 29 13:28 glog.properties_29april2015
[oracle@wlsadmin config]$


iii)
Update glog.properties

remove <> and add with the password {e as per OTM DOC.
[oracle@wlsadmin config]$ diff glog.properties glog.properties_29april2015
92d91
< glog.database.load.password={eUm9ja29uMTFn
[oracle@wlsadmin config]$


Step 4: Start application services for OTM.
starting weblogic server
--------------------------
[oracle@wlsadmin weblogic]$ pwd
/u01/OTM636/otm/install/weblogic
[oracle@wlsadmin weblogic]$ ./glogapp-wl start
Waiting for DB Server to finish startup
Starting WebLogic Application Server...
[oracle@wlsadmin weblogic]$


starting tomcat server
-----------------------
/u01/OTM636/otm/install/ohs
[oracle@wlsadmin ohs]$ ./glogweb-wl start
Starting Tomcat Web Container...
Starting Oracle HTTP Server
opmnctl startall: starting opmn and all managed processes...
[oracle@wlsadmin ohs]$


Checking logfies for weblogic
-------------------------------
[oracle@wlsadmin weblogic]$ tail -f console.log.0
INFO | 2015/04/29 13:38:53 | <Apr 29, 2015 1:38:53 PM IST> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "OU=Security Communication RootCA2,O=SECOM Trust Systems

CO.\,LTD.,C=JP". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
INFO | 2015/04/29 13:38:53 | <Apr 29, 2015 1:38:53 PM IST> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=VeriSign Universal Root Certification Authority,OU=(c)

2008 VeriSign\, Inc. - For authorized use only,OU=VeriSign Trust Network,O=VeriSign\, Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX:

Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
INFO | 2015/04/29 13:38:53 | <Apr 29, 2015 1:38:53 PM IST> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=KEYNECTIS ROOT CA,OU=ROOT,O=KEYNECTIS,C=FR". The loading

of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
INFO | 2015/04/29 13:38:53 | <Apr 29, 2015 1:38:53 PM IST> <Notice> <Security> <BEA-090898> <Ignoring the trusted CA certificate "CN=GeoTrust Primary Certification Authority - G3,OU=(c)

2008 GeoTrust Inc. - For authorized use only,O=GeoTrust Inc.,C=US". The loading of the trusted certificate list raised a certificate parsing exception PKIX: Unsupported OID in the

AlgorithmIdentifier object: 1.2.840.113549.1.1.11.>
INFO | 2015/04/29 13:38:53 | <Apr 29, 2015 1:38:53 PM IST> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 20.198.xx.xx:7001 for protocols iiop, t3, ldap, snmp, http.>
INFO | 2015/04/29 13:38:53 | <Apr 29, 2015 1:38:53 PM IST> <Notice> <Server> <BEA-002613> <Channel "DefaultSecure" is now listening on 20.198.xx.xx:7002 for protocols iiops, t3s, ldaps,

https.>
INFO | 2015/04/29 13:38:53 | <Apr 29, 2015 1:38:53 PM IST> <Notice> <WebLogicServer> <BEA-000329> <Started WebLogic Admin Server "gc3-wlsadmin" for domain "Otmv636" running in Production

Mode>
INFO | 2015/04/29 13:38:55 | <Apr 29, 2015 1:38:55 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
INFO | 2015/04/29 13:38:55 | <Apr 29, 2015 1:38:55 PM IST> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
INFO | 2015/04/29 13:39:59 | -- OTM Event: serverReady



Checking logfile for tomcat
---------------------------
[oracle@wlsadmin tomcat]$ tail -f /u01/OTM636/otm/logs/tomcat/console.log.0
INFO | 2015/04/29 13:37:20 |    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
INFO | 2015/04/29 13:37:20 |    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
INFO | 2015/04/29 13:37:20 |    at java.util.concurrent.FutureTask.run(FutureTask.java:139)
INFO | 2015/04/29 13:37:20 |    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
INFO | 2015/04/29 13:37:20 |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
INFO | 2015/04/29 13:37:20 |    at java.lang.Thread.run(Thread.java:680)
INFO | 2015/04/29 13:37:20 | Apr 29, 2015 1:37:20 PM org.apache.coyote.AbstractProtocol start
INFO | 2015/04/29 13:37:20 | INFO: Starting ProtocolHandler ["http-bio-127.0.0.1-8009"]
INFO | 2015/04/29 13:37:20 | Apr 29, 2015 1:37:20 PM org.apache.catalina.startup.Catalina start
INFO | 2015/04/29 13:37:20 | INFO: Server startup in 262120 ms




[oracle@wlsadmin ~]$ sqlplus GLOGLOAD/Rockon11g

SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 29 15:01:32 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,created from v$database;

NAME                        CREATED
--------------------------- ---------------
OTMTEST                     10-FEB-15

SQL> show user
USER is "GLOGLOAD"
SQL>