Below steps we have performed to recreate the mysql database.
Issue - VM was unavailable.
[root@prodvm dbbackup]# cat /u01/app/oracle/ovm-manager-3/.config
DBTYPE=MySQL
DBHOST=localhost
SID=ovs
LSNR=49500
OVSSCHEMA=ovs
APEX=8080
WLSADMIN=weblogic
OVSADMIN=admin
COREPORT=54321
UUID=0004fb000001000096b6a4ca0c480d52
BUILDID=3.4.4.1709
[root@prodvm bin]# sh /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovm_upgrade.sh --deletedb --dbuser=ovs --dbpass=******* --dbhost=localhost --dbport=49500 --dbsid=ovs
COMMAND: /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovm_upgrade.sh --deletedb --dbuser=ovs --dbpass=******* --dbhost=localhost --dbport=49500 --dbsid=ovs
Copying deleted classes files to patch path location
2018-01-31 21:15:58,532 INFO Oracle OVM Manager Upgrade Processor
2018-01-31 21:15:58,532 INFO
Jan 31, 2018 9:15:58 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Jan 31, 2018 9:16:00 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
2018-01-31 21:16:00,069 INFO Upgrade Initialization Starting
2018-01-31 21:16:00,142 INFO Oracle Distributed Object Fabric (ODOF): Copyright (C) 2007, 2016 Oracle. All rights reserved.
2018-01-31 21:16:00,142 INFO ODOF Version: 1.3.1.4
2018-01-31 21:16:00,142 INFO Initializing...
2018-01-31 21:16:00,738 INFO Initialization Complete
2018-01-31 21:16:00,740 INFO Upgrade Initialization Complete
2018-01-31 21:16:00,740 INFO Database Wipe Starting
2018-01-31 21:16:00,740 INFO Wiping Exchange
2018-01-31 21:16:00,797 INFO Initializing / Clearing Database Tables
2018-01-31 21:16:24,023 INFO Wiping Complete!
2018-01-31 21:16:24,024 INFO Database Wipe Complete
[root@prodvm bin]# service ovmm start
Starting Oracle VM Manager [ OK ]
[root@prodvm bin]# service ovmm status
Oracle VM Manager is running...
[root@prodvm bin]# export MW_HOME=/u01/app/oracle/Middleware
[root@prodvm bin]# /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovmkeytool.sh setupWebLogic
Jan 31, 2018 9:21:28 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Jan 31, 2018 9:21:30 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
Updating keystore information in WebLogic
Oracle MiddleWare Home (MW_HOME): [/u01/app/oracle/Middleware]
WebLogic domain directory: [/u01/app/oracle/ovm-manager-3/domains/ovm_domain]
WebLogic server name: [AdminServer]
WebLogic username: [weblogic]
WebLogic password: [********]
WLST session logged at: /tmp/wlst-session9182349945607884673.log
[root@prodvm bin]# sh /u01/app/oracle/ovm-manager-3/bin/configure_client_cert_login.sh
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
2018-01-31 21:24:05,924 [main] INFO ovm.wlst.commands - Connecting using URL t3://localhost:7001
2018-01-31 21:24:12,426 [main] INFO ovm.wlst.commands - Undeploying ovm_console
Undeploying application ovm_console ...
<Jan 31, 2018 9:24:13 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating undeploy operation for application, ovm_console [archive: null], to AdminServer .>
.Completed the undeployment of Application with status completed
Current Status of your Deployment:
Deployment command type: undeploy
Deployment State : completed
Deployment Message : no message
2018-01-31 21:24:17,551 [main] INFO ovm.wlst.commands - Undeploying ovm_core
Undeploying application ovm_core ...
<Jan 31, 2018 9:24:17 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating undeploy operation for application, ovm_core [archive: null], to AdminServer .>
.Completed the undeployment of Application with status completed
Current Status of your Deployment:
Deployment command type: undeploy
Deployment State : completed
Deployment Message : no message
2018-01-31 21:24:21,013 [main] INFO ovm.wlst.domainbuilder.Domain - Stopping AdminServer...
Stopping Weblogic Server...
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Connecting to t3://localhost:7001 with userid weblogic ...
Successfully connected to Admin Server "AdminServer" that belongs to domain "ovm_domain".
Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.
Shutting down the server AdminServer with force=false while connected to AdminServer ...
.........Disconnected from weblogic server: AdminServer
Exiting WebLogic Scripting Tool.
WLST lost connection to the WebLogic Server that you were
connected to, this may happen if the server was shutdown or
partitioned. You will have to re-connect to the server once the
server is available.
Disconnected from weblogic server: AdminServer
Done
Stopping Derby Server...
Derby server stopped.
2018-01-31 21:24:52,767 [main] INFO ovm.wlst.domainbuilder.Domain - Starting AdminServer...
2018-01-31 21:24:52,916 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:03,477 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:15,962 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:27,695 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:38,798 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:50,184 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:26:02,377 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:26:13,579 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:26:14,936 [main] INFO ovm.wlst.domainbuilder.Domain - Connected.
2018-01-31 21:26:14,971 [main] INFO ovm.wlst.domainbuilder.Domain - AdminServer state is RUNNING
2018-01-31 21:26:14,973 [main] INFO ovm.wlst.commands - Deploying ovm_core
Deploying application from /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_core/app/ovm_core_3.4.4.1709.ear to targets AdminServer (upload=false) ...
<Jan 31, 2018 9:26:15 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating deploy operation for application, ovm_core [archive: /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_core/app/ovm_core_3.4.4.1709.ear], to AdminServer .>
.....Completed the deployment of Application with status completed
Current Status of your Deployment:
Deployment command type: deploy
Deployment State : completed
Deployment Message : no message
Already in Domain Config Tree
Already in Domain Config Tree
2018-01-31 21:26:31,460 [main] INFO ovm.wlst.domainbuilder.Domain - Created a user named appframework
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/u01/app/oracle/ovm-manager-3/ovm_cli/lib/slf4j-log4j12.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/u01/app/oracle/Middleware/wlserver/modules/features/weblogic.server.merged.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
Jan 31, 2018 9:26:32 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Jan 31, 2018 9:26:34 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
2018-01-31 21:27:25,822 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Writing cacert.pem
2018-01-31 21:27:25,824 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Importing cacert.pem with alias ovmca
2018-01-31 21:27:26,213 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Generating key pair for appframework in /u01/app/oracle/ovm-manager-3/domains/ovm_domain/security/ovmclient.jks
2018-01-31 21:27:27,025 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Exporting clientcert.pem from /u01/app/oracle/ovm-manager-3/domains/ovm_domain/security/ovmclient.jks
2018-01-31 21:27:27,234 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Reading clientcert.pem
2018-01-31 21:27:27,236 [main] INFO com.oracle.appfw.ovm.ws.client.SSLClientUtil - Signing certificate
2018-01-31 21:27:27,588 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Writing clientcert.pem
2018-01-31 21:27:27,589 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Importing clientcert.pem with alias appframework
2018-01-31 21:27:28,132 [main] INFO com.oracle.appfw.ovm.ws.client.SSLClientUtil - Deleting cacert.pem
2018-01-31 21:27:28,132 [main] INFO com.oracle.appfw.ovm.ws.client.SSLClientUtil - Deleting clientcert.pem
2018-01-31 21:27:28,163 [main] INFO ovm.wlst.commands - Deploying ovm_console
Deploying application from /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_console/app/ovm_console_3.4.4.1709.ear to targets AdminServer (upload=false) ...
<Jan 31, 2018 9:27:28 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating deploy operation for application, ovm_console [archive: /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_console/app/ovm_console_3.4.4.1709.ear], to AdminServer .>
.....Completed the deployment of Application with status completed
Current Status of your Deployment:
Deployment command type: deploy
Deployment State : completed
Deployment Message : no message
<Jan 31, 2018 9:27:43 PM IST> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread than the one in which it was created.>
Client certificate login configuration complete
[root@prodvm bin]# service ovmm stop
Stopping Oracle VM Manager [ OK ]
[root@prodvm bin]# service ovmm start
Starting Oracle VM Manager [ OK ]
After that we have to take care few steps mentioned in Doc ID 2038168.1
Which resolved our issue.
Thanks,
Issue - VM was unavailable.
[root@prodvm dbbackup]# cat /u01/app/oracle/ovm-manager-3/.config
DBTYPE=MySQL
DBHOST=localhost
SID=ovs
LSNR=49500
OVSSCHEMA=ovs
APEX=8080
WLSADMIN=weblogic
OVSADMIN=admin
COREPORT=54321
UUID=0004fb000001000096b6a4ca0c480d52
BUILDID=3.4.4.1709
[root@prodvm bin]# sh /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovm_upgrade.sh --deletedb --dbuser=ovs --dbpass=******* --dbhost=localhost --dbport=49500 --dbsid=ovs
COMMAND: /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovm_upgrade.sh --deletedb --dbuser=ovs --dbpass=******* --dbhost=localhost --dbport=49500 --dbsid=ovs
Copying deleted classes files to patch path location
2018-01-31 21:15:58,532 INFO Oracle OVM Manager Upgrade Processor
2018-01-31 21:15:58,532 INFO
Jan 31, 2018 9:15:58 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Jan 31, 2018 9:16:00 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
2018-01-31 21:16:00,069 INFO Upgrade Initialization Starting
2018-01-31 21:16:00,142 INFO Oracle Distributed Object Fabric (ODOF): Copyright (C) 2007, 2016 Oracle. All rights reserved.
2018-01-31 21:16:00,142 INFO ODOF Version: 1.3.1.4
2018-01-31 21:16:00,142 INFO Initializing...
2018-01-31 21:16:00,738 INFO Initialization Complete
2018-01-31 21:16:00,740 INFO Upgrade Initialization Complete
2018-01-31 21:16:00,740 INFO Database Wipe Starting
2018-01-31 21:16:00,740 INFO Wiping Exchange
2018-01-31 21:16:00,797 INFO Initializing / Clearing Database Tables
2018-01-31 21:16:24,023 INFO Wiping Complete!
2018-01-31 21:16:24,024 INFO Database Wipe Complete
[root@prodvm bin]# service ovmm start
Starting Oracle VM Manager [ OK ]
[root@prodvm bin]# service ovmm status
Oracle VM Manager is running...
[root@prodvm bin]# export MW_HOME=/u01/app/oracle/Middleware
[root@prodvm bin]# /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovmkeytool.sh setupWebLogic
Jan 31, 2018 9:21:28 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Jan 31, 2018 9:21:30 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
Updating keystore information in WebLogic
Oracle MiddleWare Home (MW_HOME): [/u01/app/oracle/Middleware]
WebLogic domain directory: [/u01/app/oracle/ovm-manager-3/domains/ovm_domain]
WebLogic server name: [AdminServer]
WebLogic username: [weblogic]
WebLogic password: [********]
WLST session logged at: /tmp/wlst-session9182349945607884673.log
[root@prodvm bin]# sh /u01/app/oracle/ovm-manager-3/bin/configure_client_cert_login.sh
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
2018-01-31 21:24:05,924 [main] INFO ovm.wlst.commands - Connecting using URL t3://localhost:7001
2018-01-31 21:24:12,426 [main] INFO ovm.wlst.commands - Undeploying ovm_console
Undeploying application ovm_console ...
<Jan 31, 2018 9:24:13 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating undeploy operation for application, ovm_console [archive: null], to AdminServer .>
.Completed the undeployment of Application with status completed
Current Status of your Deployment:
Deployment command type: undeploy
Deployment State : completed
Deployment Message : no message
2018-01-31 21:24:17,551 [main] INFO ovm.wlst.commands - Undeploying ovm_core
Undeploying application ovm_core ...
<Jan 31, 2018 9:24:17 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating undeploy operation for application, ovm_core [archive: null], to AdminServer .>
.Completed the undeployment of Application with status completed
Current Status of your Deployment:
Deployment command type: undeploy
Deployment State : completed
Deployment Message : no message
2018-01-31 21:24:21,013 [main] INFO ovm.wlst.domainbuilder.Domain - Stopping AdminServer...
Stopping Weblogic Server...
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Connecting to t3://localhost:7001 with userid weblogic ...
Successfully connected to Admin Server "AdminServer" that belongs to domain "ovm_domain".
Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.
Shutting down the server AdminServer with force=false while connected to AdminServer ...
.........Disconnected from weblogic server: AdminServer
Exiting WebLogic Scripting Tool.
WLST lost connection to the WebLogic Server that you were
connected to, this may happen if the server was shutdown or
partitioned. You will have to re-connect to the server once the
server is available.
Disconnected from weblogic server: AdminServer
Done
Stopping Derby Server...
Derby server stopped.
2018-01-31 21:24:52,767 [main] INFO ovm.wlst.domainbuilder.Domain - Starting AdminServer...
2018-01-31 21:24:52,916 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:03,477 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:15,962 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:27,695 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:38,798 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:25:50,184 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:26:02,377 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:26:13,579 [main] INFO ovm.wlst.domainbuilder.Domain - Trying to connect to t3://localhost:7001...
2018-01-31 21:26:14,936 [main] INFO ovm.wlst.domainbuilder.Domain - Connected.
2018-01-31 21:26:14,971 [main] INFO ovm.wlst.domainbuilder.Domain - AdminServer state is RUNNING
2018-01-31 21:26:14,973 [main] INFO ovm.wlst.commands - Deploying ovm_core
Deploying application from /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_core/app/ovm_core_3.4.4.1709.ear to targets AdminServer (upload=false) ...
<Jan 31, 2018 9:26:15 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating deploy operation for application, ovm_core [archive: /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_core/app/ovm_core_3.4.4.1709.ear], to AdminServer .>
.....Completed the deployment of Application with status completed
Current Status of your Deployment:
Deployment command type: deploy
Deployment State : completed
Deployment Message : no message
Already in Domain Config Tree
Already in Domain Config Tree
2018-01-31 21:26:31,460 [main] INFO ovm.wlst.domainbuilder.Domain - Created a user named appframework
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/u01/app/oracle/ovm-manager-3/ovm_cli/lib/slf4j-log4j12.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/u01/app/oracle/Middleware/wlserver/modules/features/weblogic.server.merged.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
Jan 31, 2018 9:26:32 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Jan 31, 2018 9:26:34 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
2018-01-31 21:27:25,822 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Writing cacert.pem
2018-01-31 21:27:25,824 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Importing cacert.pem with alias ovmca
2018-01-31 21:27:26,213 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Generating key pair for appframework in /u01/app/oracle/ovm-manager-3/domains/ovm_domain/security/ovmclient.jks
2018-01-31 21:27:27,025 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Exporting clientcert.pem from /u01/app/oracle/ovm-manager-3/domains/ovm_domain/security/ovmclient.jks
2018-01-31 21:27:27,234 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Reading clientcert.pem
2018-01-31 21:27:27,236 [main] INFO com.oracle.appfw.ovm.ws.client.SSLClientUtil - Signing certificate
2018-01-31 21:27:27,588 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Writing clientcert.pem
2018-01-31 21:27:27,589 [main] INFO com.oracle.appfw.ovm.ws.client.KeytoolHelper - Importing clientcert.pem with alias appframework
2018-01-31 21:27:28,132 [main] INFO com.oracle.appfw.ovm.ws.client.SSLClientUtil - Deleting cacert.pem
2018-01-31 21:27:28,132 [main] INFO com.oracle.appfw.ovm.ws.client.SSLClientUtil - Deleting clientcert.pem
2018-01-31 21:27:28,163 [main] INFO ovm.wlst.commands - Deploying ovm_console
Deploying application from /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_console/app/ovm_console_3.4.4.1709.ear to targets AdminServer (upload=false) ...
<Jan 31, 2018 9:27:28 PM IST> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating deploy operation for application, ovm_console [archive: /u01/app/oracle/ovm-manager-3/ovm_wlst/deploy/ovm_console/app/ovm_console_3.4.4.1709.ear], to AdminServer .>
.....Completed the deployment of Application with status completed
Current Status of your Deployment:
Deployment command type: deploy
Deployment State : completed
Deployment Message : no message
<Jan 31, 2018 9:27:43 PM IST> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread than the one in which it was created.>
Client certificate login configuration complete
[root@prodvm bin]# service ovmm stop
Stopping Oracle VM Manager [ OK ]
[root@prodvm bin]# service ovmm start
Starting Oracle VM Manager [ OK ]
After that we have to take care few steps mentioned in Doc ID 2038168.1
Which resolved our issue.
Thanks,
No comments:
Post a Comment