Use this procedure to check the database physical processes such as pmon, dbw and so on, and to ensure that you can make a client connection to the database.
root@TargetGlobal# zlogin TargetS10bz [Connected to zone 'TargetS10bz' pts/2] Last login: Wed Jul 16 05:05:11 on pts/5 Oracle Corporation SunOS 5.10 Generic Patch January 2005 rootTargetS10bz# su - oracle1 Oracle Corporation SunOS 5.10 Generic Patch January 2005 oracle1@TargetS10bz $
Replace the old source host name with a new target guest domain name in the listener.ora parameter file.
oracle1@TargetS10bz$ cat $ORACLE_HOME/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = TargetS10bz)(PORT = 1521))
)
)
oracle1@TargetS10bz$ lsnrctl start LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 16-AUG-2018 06:05:08 Copyright (c) 1991, 2010, Oracle. All rights reserved. Starting /u01/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 10.2.0.5.0 - Production Log messages written to /u01/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TargetS10bz)(PORT=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 10.2.0.5.0 - Production Start Date 16-AUG-2018 06:05:08 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TargetS10bz)(PORT=1521))) The listener supports no services The command completed successfully
oracle1@TargetS10bz$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Fri Aug 16 05:06:45 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> startup ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size 2052448 bytes Variable Size 385879712 bytes Database Buffers 1207959552 bytes Redo Buffers 14721024 bytes Database mounted. Database opened.
oracle1@TargetS10bz$ lsnrctl status LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 16-AUG-2018 09:35:04 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 10.2.0.5.0 - Production Start Date 16-AUG-2018 06:05:08 Uptime 0 days 3 hr. 30 min. 04 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TargetS10bz)(PORT=1521))) Services Summary... Service "md1" has 1 instance(s). Instance "md1", status READY, has 1 handler(s) for this service... Service "md1XDB" has 1 instance(s). Instance "md1", status READY, has 1 handler(s) for this service... Service "md1_XPT" has 1 instance(s). Instance "md1", status READY, has 1 handler(s) for this service... The command completed successfully oracle1@TargetS10bz$ ptree|grep ora_|grep -v grep 24088 ora_pmon_md1 24090 ora_psp0_md1 24092 ora_mman_md1 24094 ora_dbw0_md1 .....
oracle@client-sys:$ sqlplus system/welcome1@//TargetS10bz.us.example.com:1521/md1 SQL> select name, log_mode,open_mode from v$database; NAME LOG_MODE OPEN_MODE --------- ------------ ---------- MD1 ARCHIVELOG READ WRITE SQL> select name from v$datafile union select name from v$controlfile union select member from v$logfile union select name from v$archived_log ; NAME -------------------------------------------------------------------------------- /oradata/md1/archivelog/MD1/archivelog/2018_05_25/o1_mf_1_2_fjhkyx3w_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_19/o1_mf_1_3_fo1fg0fd_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_20/o1_mf_1_4_fo5hgoso_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_22/o1_mf_1_5_fo8yhz3d_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_23/o1_mf_1_6_fofdmzqy_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_25/o1_mf_1_7_fojx3m2w_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_26/o1_mf_1_8_fonfm0cz_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_27/o1_mf_1_9_fopygmqj_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_28/o1_mf_1_10_fort6n3p_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_29/o1_mf_1_11_fow2j8gm_.arc /oradata/md1/archivelog/MD1/archivelog/2018_07_30/o1_mf_1_12_fozv6qt6_.arc /oradata/md1/control01.ctl /oradata/md1/control02.ctl /oradata/md1/control03.ctl /oradata/md1/redo01.log /oradata/md1/redo02.log /oradata/md1/redo03.log /oradata/md1/sysaux01.dbf /oradata/md1/system01.dbf /oradata/md1/undotbs01.dbf /oradata/md1/users01.dbf /u01/oracle/product/10.2.0/db_1/flash_recovery_area/MD1/archivelog/2018_05_24/o1 _mf_1_1_fjh62ty2_.arc 22 rows selected. SQL> select * from v$recover_file; no rows selected
The count should match the count from Review the Source System Configuration.
SQL> select count(*) from soe.orders ; COUNT(*) ---------- 1429790