The steps and examples in this section provide commands you can use to gather additional information about the guest domain.
As you perform this procedure, take into account the state of your guest domain and adjust or omit steps as needed.
SourceGuestDomain:/# ls /etc/hostname* hostname.vnet0 SourceGuestDomain:/# cat /etc/hostname.vnet0 SourceGuestDomain
SourceGuestDomain:/# zpool list
NAME SIZE ALLOC FREE CAP HEALTH ALTROOT
rpool 298G 39.2G 259G 13% ONLINE -
u01 149G 11.7G 137G 7% ONLINE -
SourceGuestDomain:/# zpool status
pool: rpool
state: ONLINE
scan: resilvered 9.71M in 0h0m with 0 errors on Tue Feb 13 18:56:07 2018
config:
NAME STATE READ WRITE CKSUM
rpool ONLINE 0 0 0
mirror-0 ONLINE 0 0 0
c0d0s0 ONLINE 0 0 0
c0d1s0 ONLINE 0 0 0
errors: No known data errors
pool: u01
state: ONLINE
scan: none requested
config:
NAME STATE READ WRITE CKSUM
u01 ONLINE 0 0 0
mirror-0 ONLINE 0 0 0
c0d2 ONLINE 0 0 0
c0d3 ONLINE 0 0 0
errors: No known data errors
SourceGuestDomain:/# zpool status -xv
all pools are healthy
In this example, disks listed by the format command are coming from the disks assigned from the control domain. Disks 4 and 5 are unused for the zpools. Instead they are used for the ASM disk group DATA.
SourceGuestDomain:/# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c0d0 <SUN-ZFSStorage7420-1.0 cyl 9749 alt 2 hd 254 sec 254>
/virtual-devices@100/channel-devices@200/disk@0
1. c0d1 <SUN-ZFSStorage7420-1.0 cyl 9749 alt 2 hd 254 sec 254>
/virtual-devices@100/channel-devices@200/disk@1
2. c0d2 <SUN-ZFS Storage 7420-1.0-150.00GB>
/virtual-devices@100/channel-devices@200/disk@2
3. c0d3 <SUN-ZFS Storage 7420-1.0-150.00GB>
/virtual-devices@100/channel-devices@200/disk@3
4. c0d4 <SUN-ZFS Storage 7420-1.0-200.00GB>
/virtual-devices@100/channel-devices@200/disk@4
5. c0d5 <SUN-ZFS Storage 7420-1.0-200.00GB>
/virtual-devices@100/channel-devices@200/disk@5
Specify disk (enter its number): CTRL-C
SourceGuestDomain:/# ifconfig -a
lo0: flags=2001000849<UP,LOOPBACK,RUNNING,MULTICAST,IPv4,VIRTUAL> mtu 8232 index 1
inet 127.0.0.1 netmask ff000000
vnet0: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 2
inet 192.0.2.100 netmask ffffff00 broadcast 192.0.2.255
ether 00:00:5E:00:53:9d
SourceGuestDomain:/# netstat -rn
Routing Table: IPv4
Destination Gateway Flags Ref Use Interface
-------------------- -------------------- ----- ----- ------- ---------
default 192.0.2.1 UG 1 582
192.0.2.0 192.0.2.100 U 1 130 vnet0
224.0.0.0 192.0.2.100 U 1 0 vnet0
127.0.0.1 127.0.0.1 UH 4 81 lo0
In this example, the source domain is installed with Oracle ASM and Oracle Database (12.1.0.2) with Enterprise Manager Database Express (a feature of the Oracle Database). Another system in the compute environment is deployed to run a database workload (Swingbench) against the database.
-bash-3.2$ cat /var/opt/oracle/oratab
+ASM:/u01/app/oracle1/product/12.1.0/grid:N # line added by Agent
orcl18:/u01/app/oracle1/product/12.1.0/dbhome_1:N # line added by Agent
-bash-3.2$ crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE SourceGuestDomain STABLE
ora.LISTENER.lsnr
ONLINE ONLINE SourceGuestDomain STABLE
ora.asm
ONLINE ONLINE SourceGuestDomain Started,STABLE
ora.ons
OFFLINE OFFLINE SourceGuestDomain STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE SourceGuestDomain STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE SourceGuestDomain STABLE
ora.orcl18.db
1 ONLINE ONLINE SourceGuestDomain Open,STABLE
In this example, the DATA disk group is mapped to /dev/rdsk/c0d4s0 and /dev/rdsk/c0d5s0.
You can verify this in the following ways:
select NAME,DISK_NUMBER,PATH from v$asm_disk NAME DISK_NUMBER PATH ------------------------------ ----------- -------------------- DATA_0000 0 /dev/rdsk/c0d4s0 DATA_0001 1 /dev/rdsk/c0d5s0
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 16777216 409568 259968 0 129984 0 N DATA/
ASMCMD> lsdsk -p -G DATA
Group_Num Disk_Num Incarn Mount_Stat Header_Stat Mode_Stat State Path
1 0 4113230313 CACHED MEMBER ONLINE NORMAL /dev/rdsk/c0d4s0
1 1 4113230314 CACHED MEMBER ONLINE NORMAL /dev/rdsk/c0d5s0
The LISTENER status shows the services available.
-bash-3.2$ /u01/app/oracle1/product/12.1.0/grid/bin/lsnrctl status LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 13-FEB-2018 02:32:07 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SourceGuestDomain)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 12.1.0.2.0 - Production Start Date 13-FEB-2018 10:28:30 Uptime 0 days 16 hr. 3 min. 36 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle1/product/12.1.0/grid/network/admin/listener.ora Listener Log File /u01/app/oracle1/diag/tnslsnr/SourceGuestDomain/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SourceGuestDomain)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=SourceGuestDomain)(PORT=5500)) (Security=(my_wallet_directory=/u01/app/oracle1/product/12.1.0/dbhome_1/admin/orcl18/xdb_wallet)) (Presentation=HTTP)(Session=RAW)) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "orcl18" has 1 instance(s). Instance "orcl18", status READY, has 1 handler(s) for this service... Service "orcl18XDB" has 1 instance(s). Instance "orcl18", status READY, has 1 handler(s) for this service... Service "pdborcl" has 1 instance(s). Instance "orcl18", status READY, has 1 handler(s) for this service... The command completed successfully
In this example, tables of the sales order in the user application schema housed in a pluggable database are displayed (26258963 and 70359059 are the number of rows in ORDERS and ORDERS_ITEMS). After the lift and shift process, the same query is repeated to provide a sanity check for the database (see Configure Guest Domain Database Components).
SQL> -bash-3.2$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Feb 12 02:33:53 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> set pages 1000
SQL> select * from v$pdbs ;
CON_ID DBID CON_UID GUID NAME OPEN_MODE RES OPEN_TIME CREATE_SCN TOTAL_SIZE
BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID
---------- ---------- ---------- -------------------------------- ---------- ---------- --- ---------------------
------------------------------------------------------ ---------- ---------- ---------- -------- ----------------
2 923046337 923046337 5FD409E1C9B47424E05400144FF9359D PDB$SEED READ ONLY NO 11-FEB-18 12.33.26.810 PM -08:00
2055907 775946240 8192 ENABLED 0
3 2925223297 2925223297 5FD41B67429003BEE05400144FF9359D PDBORCL READ WRITE NO 11-FEB-18 12.33.28.113 PM -08:00
2065658 6447693824 8192 ENABLED 0
SQL> alter session set container=PDBORCL ;
Session altered.
SQL> show con_id
CON_ID
------------------------------
3
SQL> connect soe/soe@pdborcl
Connected.
SQL> select table_name from user_tables ;
TABLE_NAME
------------------------------------------------------------------------------------------
CUSTOMERS
ADDRESSES
CARD_DETAILS
WAREHOUSES
ORDER_ITEMS
ORDERS
INVENTORIES
PRODUCT_INFORMATION
LOGON
PRODUCT_DESCRIPTIONS
ORDERENTRY_METADATA
11 rows selected.
SQL> select count(*) from ORDERS ;
COUNT(*)
----------
26258963
SQL> select count(*) from ORDER_ITEMS ;
COUNT(*)
----------
70359059