Tuesday 8 November 2016

Re set GLOGDBA user password in OTM

+++++++++++++++
 CHANGING GLOGDBA PASSWORD
 ++++++++++++++++++

 1)stop web server
 -------------------
[oracle@wlsadmin weblogic]$ cd /u01/OTM636/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]$


 2)stop app server
 -------------------
 /u01/OTM636/install/weblogic
[oracle@wlsadmin weblogic]$ ./glogapp-wl stop
Stopping WebLogic Application Server...


Step 3: Change the database passwords.
---------------------------------------
SQL> alter user glogdba identified by Abduldba;

User altered.

SQL>


Step 4
-------------

[oracle@wlsadmin install]$ pwd
/u01/OTM636/install
[oracle@wlsadmin install]$ . ./gc3env.sh
[oracle@wlsadmin install]$ java glog.util.appclass.Base64Encoding Abduldba
<QWJkdWxkYmE=>
[oracle@wlsadmin install]$




Step 5
Take the backup of glog.properties file
-------------------------

[oracle@wlsadmin config]$ ls -ltrh /u01/OTM636/glog/config/glog.properties
-rwxr-----. 1 oracle dba 15K Feb 10 14:21 /u01/OTM636/glog/config/glog.properties
[oracle@wlsadmin config]$ cp -r /u01/OTM636/glog/config/glog.properties /u01/OTM636/glog/config/glog.properties_22April2015
[oracle@wlsadmin config]$

step 6
----------
[oracle@wlsadmin config]$ ls -ltrh /u01/OTM636/glog/config/glog.properties
-rwxr-----. 1 oracle dba 15K Feb 10 14:21 /u01/OTM636/glog/config/glog.properties
[oracle@wlsadmin config]$ vi /u01/OTM636/glog/config/glog.properties
[oracle@wlsadmin config]$ diff /u01/OTM636/glog/config/glog.properties /u01/OTM636/glog/config/glog.properties_22April2015
87,88d86
< glog.database.password={eQWJkdWxkYmE=
<
[oracle@wlsadmin config]$

glog.database.password={eR0xPR0xPQUQ=

step 7
--------
starting app server

/u01/OTM636/install/weblogic
[oracle@wlsadmin weblogic]$ ./glogapp-wl start
Waiting for DB Server to finish startup
Starting WebLogic Application Server...
[oracle@wlsadmin weblogic]$


[oracle@wlsadmin ohs]$ pwd
/u01/OTM636/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 weblogic logfile
++++++++++++++++++++++++

[oracle@wlsadmin weblogic]$ ls -ltrh /u01/OTM636/logs/weblogic/console.log.0
-rw-r--r--. 1 oracle dba 715K Apr 22 15:05 /u01/OTM636/logs/weblogic/console.log.0
[oracle@wlsadmin weblogic]$ tail -f /u01/OTM636/logs/weblogic/console.log.0
INFO | 2015/04/22 15:05:23 | <Apr 22, 2015 3:05:23 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/22 15:05:23 | <Apr 22, 2015 3:05:23 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/22 15:05:23 | <Apr 22, 2015 3:05:23 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/22 15:05:23 | <Apr 22, 2015 3:05:23 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/22 15:05:23 | <Apr 22, 2015 3:05:23 PM IST> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 20.198.94.62:7001 for protocols iiop, t3, ldap, snmp, http.>
INFO | 2015/04/22 15:05:23 | <Apr 22, 2015 3:05:23 PM IST> <Notice> <WebLogicServer> <BEA-000329> <Started WebLogic Admin Server "gc3-wlsadmin" for domain "Otmv635" running in Production

Mode>
INFO | 2015/04/22 15:05:23 | <Apr 22, 2015 3:05:23 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
INFO | 2015/04/22 15:05:23 | <Apr 22, 2015 3:05:23 PM IST> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
INFO | 2015/04/22 15:05:23 | [INFO ][memory ] [YC#20] 139.582-139.619: YC 740942KB->434310KB (1048576KB), 0.037 s, sum of pauses 36.916 ms, longest pause 36.916 ms.
INFO | 2015/04/22 15:05:31 | -- OTM Event: serverReady




Checking tomcat logfile
--------------------
[oracle@wlsadmin tomcat]$ ls -ltrh /u01/OTM636/logs/tomcat/console.log.0
-rw-r--r--. 1 oracle dba 2.7M Apr 22 15:05 /u01/OTM636/logs/tomcat/console.log.0
[oracle@wlsadmin tomcat]$ tail -f /u01/OTM636/logs/tomcat/console.log.0
INFO | 2015/04/22 15:05:21 |    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
INFO | 2015/04/22 15:05:21 |    at java.util.concurrent.FutureTask.run(FutureTask.java:139)
INFO | 2015/04/22 15:05:21 |    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
INFO | 2015/04/22 15:05:21 |    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
INFO | 2015/04/22 15:05:21 |    at java.lang.Thread.run(Thread.java:680)
INFO | 2015/04/22 15:05:21 | Apr 22, 2015 3:05:21 PM org.apache.coyote.AbstractProtocol start
INFO | 2015/04/22 15:05:21 | INFO: Starting ProtocolHandler ["http-bio-127.0.0.1-8009"]
INFO | 2015/04/22 15:05:21 | Apr 22, 2015 3:05:21 PM org.apache.catalina.startup.Catalina start
INFO | 2015/04/22 15:05:21 | INFO: Server startup in 99554 ms
INFO | 2015/04/22 15:05:30 | [INFO ][memory ] [YC#16] 111.398-111.451: YC 692136KB->411973KB (1048576KB), 0.054 s, sum of pauses 53.609 ms, longest pause 53.609 ms.
INFO | 2015/04/22 15:06:55 |  : QUERYRESOURCES : 0
INFO | 2015/04/22 15:06:55 | en : QUERYRESOURCES : 969667
INFO | 2015/04/22 15:06:55 | en_US : QUERYRESOURCES : 0
INFO | 2015/04/22 15:06:56 |  : TRANSLATION : 0
INFO | 2015/04/22 15:06:56 | en : TRANSLATION : 1120776
INFO | 2015/04/22 15:06:56 | en_US : TRANSLATION : 0
INFO | 2015/04/22 15:07:09 | en_US_DBA : TRANSLATION : 0
INFO | 2015/04/22 15:07:10 | [INFO ][memory ] [YC#17] 210.512-210.555: YC 798119KB->480084KB (1048576KB), 0.044 s, sum of pauses 43.663 ms, longest pause 43.663 ms.



SQL> conn glogdba/Abduldba
Connected.
SQL> show user
USER is "GLOGDBA"
SQL>

No comments:

Post a Comment