drain_hongkong.log

2021-03-09 02:52:04.840 INFO Starting drain logger - AutoUpgDrainActions.<init> 
2021-03-09 02:52:04.850 INFO Starting drain - AutoUpgDrainActions.runDrainActions 
2021-03-09 02:52:04.851 INFO - DrainProgressHelper.updateProgress 
2021-03-09 02:52:04.851 INFO Executing drain step TextFileList - AutoUpgDrainActions.runDrainActions 
2021-03-09 02:52:04.853 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.853 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.853 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 02:52:04.853 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:04.853 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:04.853 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.853 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.854 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.854 INFO Executing SQL [SELECT nvl(dbms_registry.is_loaded('CONTEXT'), 0) from sys.dual;] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 02:52:04.880 INFO Starting - TextFileList.executeStep 
2021-03-09 02:52:04.880 INFO Begin Generating Context text file list - TextFileList.executeStep 
2021-03-09 02:52:04.882 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.882 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.882 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 02:52:04.883 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:04.883 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:04.883 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.883 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.883 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:04.883 INFO Executing SQL [@/home/oracle/u03/app/oracle/product/12.2.0/db_1/ctx/admin/ctx_oh_files.sql] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 02:52:05.186 INFO Generating Context text file list /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/temp/ctx_move_text_file_list_hongkong - TextFileList.executeStep 
2021-03-09 02:52:05.187 INFO End Generating Context text file list - TextFileList.executeStep 
2021-03-09 02:52:05.187 INFO Finished - TextFileList.executeStep 
2021-03-09 02:52:05.187 INFO Executing drain step SaveDBState - AutoUpgDrainActions.runDrainActions 
2021-03-09 02:52:05.191 INFO Obtaining the CONCURRENT DBMS_STATS preference for hongkong [] - ConcurrentStat.getConcurrentValue 
2021-03-09 02:52:05.192 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:05.192 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:05.192 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 02:52:05.192 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:05.192 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:05.192 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:05.192 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:05.193 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:05.193 INFO Executing SQL [SELECT UPPER(DBMS_STATS.GET_PREFS('CONCURRENT')) FROM sys.dual;] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 02:52:05.231 INFO The CONCURRENT DBMS_STATS preference for hongkong [] is OFF - ConcurrentStat.getConcurrentValue 
2021-03-09 02:52:05.232 INFO Saving DB state - DBState.fixStateOnSource 
2021-03-09 02:52:05.232 INFO Fixing the CONCURRENT DBMS_STATS preference for hongkong - ConcurrentStat.fixConcurrentValue 
2021-03-09 02:52:05.232 INFO The CONCURRENT DBMS_STATS preference for hongkong was already set to OFF - ConcurrentStat.fixConcurrentValue 
2021-03-09 02:52:05.232 INFO Creating /home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/config_files/dbstate_hongkong file for hongkong - DBState.serialize 
2021-03-09 02:52:05.253 INFO Executing drain step PosixWork - AutoUpgDrainActions.runDrainActions 
2021-03-09 02:52:05.257 INFO Shutting down database - PosixWork.executeStep 
2021-03-09 02:52:05.257 INFO Starting - Database.shutDownDatabase 
2021-03-09 02:52:05.257 INFO Starting - ExecuteSql.doSqlCmds 
2021-03-09 02:52:05.258 INFO Begin Oracle Home=/home/oracle/u03/app/oracle/product/12.2.0/db_1 Oracle Sid=hongkong Sql*Plus Command=shutdown immediate Container Name = None Filename=None Echo=true - ExecuteSql.doSqlCmds 
2021-03-09 02:52:05.258 INFO Begin Starting Sql*Plus - ExecuteSql.doSqlCmds 
2021-03-09 02:52:05.258 INFO Starting - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO Begin /home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO Begin Validating Command - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO End Validating Command - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO Begin Calling ProcessBuilder - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO End Calling ProcessBuilder - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO Begin Calling ProcessBuilder.redirectErrorStream - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO End Calling ProcessBuilder.redirectErrorStream - ExecuteProcess.startProcess 
2021-03-09 02:52:05.258 INFO Begin Setting Oracle Environment - ExecuteProcess.startProcess 
2021-03-09 02:52:05.260 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 02:52:05.260 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:05.260 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:05.260 INFO End Setting Oracle Environment - ExecuteProcess.startProcess 
2021-03-09 02:52:05.260 INFO Begin Creating process - ExecuteProcess.startProcess 
2021-03-09 02:52:05.272 INFO End Creating process - ExecuteProcess.startProcess 
2021-03-09 02:52:05.272 INFO End /home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus - ExecuteProcess.startProcess 
2021-03-09 02:52:05.272 INFO Finished - ExecuteProcess.startProcess 
2021-03-09 02:52:05.272 INFO End Starting Sql*Plus java.lang.UNIXProcess@3a0272fa - ExecuteSql.doSqlCmds 
2021-03-09 02:52:05.272 INFO Begin Executing Sql*Plus Commands - ExecuteSql.doSqlCmds 
2021-03-09 02:52:05.272 INFO Starting - ExecuteSql.executeSql 
2021-03-09 02:52:05.272 INFO Begin Container Name = None Process = java.lang.UNIXProcess@3a0272fa - ExecuteSql.executeSql 
2021-03-09 02:52:05.272 INFO Begin Sending Commands - ExecuteSql.executeSql 
2021-03-09 02:52:05.272 INFO Begin Sending Command: set echo off heading off pagesize 0 linesize 5000 feedback off;
- ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO End Sending Command: set echo off heading off pagesize 0 linesize 5000 feedback off;
- ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO Begin Sending Command: prompt AutoUpgrade###login.sql DONE###AutoUpgrade - ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO End Sending Command: prompt AutoUpgrade###login.sql DONE###AutoUpgrade - ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO Begin Sending Command: shutdown immediate - ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO End Sending Command: shutdown immediate - ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO End Sending Commands - ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO Begin Retrieving results - ExecuteSql.executeSql 
2021-03-09 02:52:05.273 INFO Starting - ReadInputStream.asynchronousRead 
2021-03-09 02:52:05.293 INFO Starting - ReadInputStream.asynchronousRead 
2021-03-09 02:52:05.293 INFO Starting - ReadInputStream.run 
2021-03-09 02:52:05.293 INFO Begin Setting up Input Reader Stream - ReadInputStream.run 
2021-03-09 02:52:05.293 INFO End Setting up Input Reader Stream - ReadInputStream.run 
2021-03-09 02:52:05.293 INFO Begin Reading process Output Stream - ReadInputStream.run 
2021-03-09 02:52:24.380 INFO End Reading process Output Stream - ReadInputStream.run 
2021-03-09 02:52:24.380 INFO End Closing file null - ReadInputStream.run 
2021-03-09 02:52:24.380 INFO Finished - ReadInputStream.run 
2021-03-09 02:52:24.381 INFO End Retrieving results - ExecuteSql.executeSql 
2021-03-09 02:52:24.381 INFO End Container Name = None Process = java.lang.UNIXProcess@3a0272fa - ExecuteSql.executeSql 
2021-03-09 02:52:24.382 INFO Finished - ExecuteSql.executeSql 
2021-03-09 02:52:24.382 INFO End Executing Sql*Plus Commands - ExecuteSql.doSqlCmds 
2021-03-09 02:52:24.382 INFO Begin Exiting Sql*Plus process - ExecuteSql.doSqlCmds 
2021-03-09 02:52:24.383 INFO End Exiting Sql*Plus process - ExecuteSql.doSqlCmds 
2021-03-09 02:52:24.383 INFO End Oracle Home=/home/oracle/u03/app/oracle/product/12.2.0/db_1 Oracle Sid=hongkong Sql*Plus Command=shutdown immediate Container Name = None Filename=None Echo=true - ExecuteSql.doSqlCmds 
2021-03-09 02:52:24.383 INFO Finished - ExecuteSql.doSqlCmds 
2021-03-09 02:52:24.383 INFO SQL*Plus data: Database closed.
Database dismounted.
ORACLE instance shut down.
- Database.shutDownDatabase 
2021-03-09 02:52:24.383 INFO Starting - Database.getDbStatus 
2021-03-09 02:52:24.388 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:24.389 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:24.389 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 02:52:24.389 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:24.390 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 02:52:24.390 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:24.390 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:24.401 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 02:52:24.401 INFO Executing SQL [SELECT STATUS FROM SYS.V$INSTANCE;] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 02:52:25.414 INFO Query [SELECT STATUS FROM SYS.V$INSTANCE;] [hongkong] finished with the following message [[01034] ORACLE not available] - ExecuteSql$SQLClient.run 
2021-03-09 02:52:25.428 INFO Container Name[hongkong][null] - Database.getDbStatus 
2021-03-09 02:52:25.429 INFO Finished - Database.getDbStatus 
2021-03-09 02:52:25.429 INFO Finished - Database.shutDownDatabase 
2021-03-09 02:52:25.429 INFO Database shutdown - PosixWork.executeStep 
2021-03-09 02:52:25.430 INFO Executing drain step WalletCopy - AutoUpgDrainActions.runDrainActions 
2021-03-09 02:52:25.445 INFO Starting - Wallet.copyWallet 
2021-03-09 02:52:25.446 INFO Begin Copying Wallet - Wallet.copyWallet 
2021-03-09 02:52:25.446 INFO Starting - Wallet.mergeSourceSqlnetWithTarget 
2021-03-09 02:52:25.446 INFO The possible sqlnet.ora directory for [/home/oracle/u03/app/oracle/product/12.2.0/db_1] is [/home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin] - Wallet.getSqlNetFile 
2021-03-09 02:52:25.447 INFO The possible sqlnet.ora directory for [/u01/app/oracle/product/19.0.0/dbhome_1] is [/u01/app/oracle/product/19.0.0/dbhome_1/network/admin] - Wallet.getSqlNetFile 
2021-03-09 02:52:25.447 INFO The parameter in /home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin/sqlnet.ora that defines the wallet location is [null] - Wallet.getWalletParameterFromSqlNet 
2021-03-09 02:52:25.447 INFO The wallet location defined by sqlnet.ora for /home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin/sqlnet.ora is [null] - Wallet.getWalletLocationFromSqlNet 
2021-03-09 02:52:25.447 INFO Wallet location is not defined in /home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin/sqlnet.ora for database [hongkong] - Wallet.mergeSourceSqlnetWithTarget 
2021-03-09 02:52:25.447 INFO End - Wallet.mergeSourceSqlnetWithTarget 
2021-03-09 02:52:25.447 INFO The possible sqlnet.ora directory for [/home/oracle/u03/app/oracle/product/12.2.0/db_1] is [/home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin] - Wallet.getSqlNetFile 
2021-03-09 02:52:25.448 INFO The parameter in /home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin/sqlnet.ora that defines the wallet location is [null] - Wallet.getWalletParameterFromSqlNet 
2021-03-09 02:52:25.448 INFO The wallet location defined by sqlnet.ora for /home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin/sqlnet.ora is [null] - Wallet.getWalletLocationFromSqlNet 
2021-03-09 02:52:25.448 INFO The wallet location for [/home/oracle/u03/app/oracle/product/12.2.0/db_1] is [/home/oracle/u03/app/oracle/admin/hongkong/wallet] - Wallet.getWalletLocation 
2021-03-09 02:52:25.448 INFO The possible sqlnet.ora directory for [/u01/app/oracle/product/19.0.0/dbhome_1] is [/u01/app/oracle/product/19.0.0/dbhome_1/network/admin] - Wallet.getSqlNetFile 
2021-03-09 02:52:25.448 INFO The parameter in /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora that defines the wallet location is [null] - Wallet.getWalletParameterFromSqlNet 
2021-03-09 02:52:25.448 INFO The wallet location defined by sqlnet.ora for /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora is [null] - Wallet.getWalletLocationFromSqlNet 
2021-03-09 02:52:25.448 INFO The wallet location for [/u01/app/oracle/product/19.0.0/dbhome_1] is [/u01/app/oracle/admin/hongkong/wallet] - Wallet.getWalletLocation 
2021-03-09 02:52:25.448 INFO File /home/oracle/u03/app/oracle/admin/hongkong/wallet/ewallet.p12 does not exist - Wallet.copyToTargetIfNecessary 
2021-03-09 02:52:25.448 INFO File /home/oracle/u03/app/oracle/admin/hongkong/wallet/cwallet.sso does not exist - Wallet.copyToTargetIfNecessary 
2021-03-09 02:52:25.448 INFO End Copying Wallet - Wallet.copyWallet 
2021-03-09 02:52:25.448 INFO Finished - Wallet.copyWallet 
2021-03-09 02:52:25.448 INFO Executing drain step PasswordFileCopy - AutoUpgDrainActions.runDrainActions 
2021-03-09 02:52:25.461 INFO Starting - PasswordFileCopy.copyPasswordFile 
2021-03-09 02:52:25.461 INFO Begin Copying Password File - PasswordFileCopy.copyPasswordFile 
2021-03-09 02:52:25.461 INFO Copying password file from /home/oracle/u03/app/oracle/product/12.2.0/db_1/dbs/orapwhongkong to /u01/app/oracle/product/19.0.0/dbhome_1/dbs/orapwhongkong - PasswordFileCopy.copyPasswordFile 
2021-03-09 02:52:25.463 INFO Copying password file completed with success - PasswordFileCopy.copyPasswordFile 
2021-03-09 02:52:25.463 INFO End Copying Password File - PasswordFileCopy.copyPasswordFile 
2021-03-09 02:52:25.463 INFO Finished - PasswordFileCopy.copyPasswordFile 
2021-03-09 02:52:25.463 INFO - DrainProgressHelper.updateProgress
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8
Like this:

One thought on “drain_hongkong.log”
