The correct output is:
/var/TKLC/lsms/free/data/npacftp/<region>
An example command line follows:
$ ftp 208.143.38.10200 PORT command successful. 150 Opening ASCII mode data connection for file list. 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 0000000-9999990.07-11-2004023849.07-10-2004023849.07-11-2004023849 LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 SPID.07-11-2000023849 226 Transfer complete. 70 bytes received in 0.026 seconds (2.6 Kbytes/s)
200 PORT command successful. 150 Opening ASCII mode data connection for file list. 0000000-9999990.07-11-2004023849.07-10-2004023849.07-11-2004023849 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 226 Transfer complete. 20 bytes received in 0.026 seconds (2.6 Kbytes/s)
Output similar to the following appears:
Interactive mode off
ftp> mget *
ftp> mget 909860*
ftp> mget 123860*
ftp> mget 124860*
ftp> mget 0000000-9999999*
ftp> mget NPANXXX*
200 PORT command successful. 150 Opening BINARY mode data connection for 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 (17979 bytes). ### 226 Transfer complete. local: 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 remote: 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 17979 bytes received in 0.18 seconds (le+02 Kbytes/s) 200 PORT command successful. 150 Opening BINARY mode data connection for 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 (17979 bytes). ### 226 Transfer complete. local: 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 remote: 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 17979 bytes received in 0.18 seconds (le+02 Kbytes/s) 200 PORT command successful. 150 Opening BINARY mode data connection for LRN.07-10-2000023849 (17979 bytes). ### 226 Transfer complete. local: LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 remote: LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 17979 bytes received in 0.18 seconds (le+02 Kbytes/s) 200 PORT command successful. 150 Opening BINARY mode data connection for NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 (124831 bytes). ################ 226 Transfer complete. local: NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 remote: NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 124831 bytes received in 1 seconds (1.2e+02 Kbytes/s) 200 PORT command successful. 150 Opening BINARY mode data connection for NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 (124831 bytes). ################ 226 Transfer complete. local: NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 remote: NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 124831 bytes received in 1 seconds (1.2e+02 Kbytes/s) 200 PORT command successful. 150 Opening BINARY mode data connection for SPID.07-10-2004023849 (479 bytes). # 226 Transfer complete. local: SPID.07-10-2004023849 remote: 07-10-2004023849 479 bytes received in 0.018 seconds (27 Kbytes/s)
Output similar to the following appears (the example shows only Time Range BDD files for downloading):
total 3188358 -rw-r-r- 1 lsmsadm lsms 1608000001 Jul 11 02:38 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 -rw-r-r- 1 lsmsadm lsms 1608000001 Jul 11 02:38 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 -rw-r-r- 1 lsmsadm lsms 780001 Jul 11 02:38 LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 -rw-r-r- 1 lsmsadm lsms 6440001 Jul 11 02:38 NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 -rw-r-r- 1 lsmsadm lsms 6440001 Jul 11 02:38 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 -rw-r-r- 1 lsmsadm lsms 239990 Jul 11 02:38 SPID.07-10-2000023849
$ mkdir /var/TKLC/lsms/free/data/npacftp/<region>/save
1892 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 0 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 892 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 0 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 250 LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 0 LRN.07-10-2004023849.07-11-2004023849 23 NPANXX.07-10-2004023849.07-11-2004023849 0 NPANXX.07-10-2004023849.07-11-2004023849 12 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 0 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 0 SPID.07-10-2004023849
$ cat orig_file_from_NPAC | tr "\015" "\012" > new_file_for_import
(The file name must be changed. Oracle recommends that you append a few characters, such as .tr, to the end of the file name. Maintaining most of the file name will make it easier to rename the files to the original file names, as instructed in 23) For example:$ cat 000000-999999.07-10-2000023849 | tr "\015" "\012" > 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr $ cat 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 | tr "\015" "\012" > 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr $ cat LRN.07-10-2000023849 | tr "\015" "\012" > LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr $ cat NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 | tr "\015" "\012" > NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr $ cat NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 | tr "\015" "\012" > NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr $ cat SPID.07-10-2004023849 | tr "\015" "\012" > SPID.07-10-2004023849.tr
For example:
$ rm 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ rm 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ rm LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ rm NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ rm NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ rm SPID.07-10-2004023849
For example:
$ mv 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ mv 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ mv LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ mv NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ mv NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849.tr NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 $ mv SPID.07-10-2004023849.tr SPID.07-10-2004023849
000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849: ASCII text 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849: ASCII text 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849: ASCII text 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849: ASCII text LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849: ASCII text LRN.07-10-2004023849.07-11-2004023849: ASCII text NPANXX.07-10-2004023849.07-11-2004023849: ASCII text NPANXX.07-10-2004023849.07-11-2004023849: ASCII text NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849: ASCII text NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849: ASCII text SPID.07-10-2004023800: ASCII text SPID.07-10-2004023849: ASCII text
Log into the active server and run both of the following commands:
$ $LSMS_DIR/npac_db_setup remove <region>
$ $LSMS_DIR/npac_db_setup_create <region>
For example:
$ $LSMS_DIR/import -c MidAtlantic
The -c option allows the import to continue on to the next line of the file even if errors occur. Output similar to the following indicates the progress of the LSMS processing:
If such an error occurs, be sure to perform the substeps shown in 30.
NPAC FTP directory: /var/TKLC/lsms/free/data/npacftp/Midwest The following NPAC download file(s) are available for import: LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 SPID.07-10-2004023849 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 Import LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 (Yes/No/All/Quit)?all The following NPAC download files have been chosen to be imported: SPID.07-10-2004023849 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 Do you want to continue (Yes/No)?yes Beginning Delete Process for SPID.07-10-2004023849 Delete Process Completed for SPID.07-10-2004023849 Beginning Download Process for SPID.07-10-2004023849 1000 ServiceProvNetwork instances written to MidwestDB 2000 ServiceProvNetwork instances written to MidwestDB 2351 ServiceProvNetwork instances written to MidwestDB Import completed successfully. Download Process Completed for SPID.11-07-2001145342 Beginning Delete Process for NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 Delete Process Completed for NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Download Process for NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 1000 ServiceProvNPA_NXX_X instances written to MidwestDB 2000 ServiceProvNPA_NXX_X instances written to MidwestDB 3000 ServiceProvNPA_NXX_X instances written to MidwestDB 4000 ServiceProvNPA_NXX_X instances written to MidwestDB … 30000 ServiceProvNPA_NXX_X instances written to MidwestDB 30860 ServiceProvNPA_NXX_X instances written to MidwestDB Import completed successfully. Download Process Completed for NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Delete Process for NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 Delete Process Completed for NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Download Process for NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 90 ServiceProvNPA_NXX instances written to MidwestDB 1090 ServiceProvNPA_NXX instances written to MidwestDB Import completed successfully. Download Process Completed for NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Delete Process for LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 Delete Process Completed for LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Download Process for LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 1000 ServiceProvLRN instances written to MidwestDB 2000 ServiceProvLRN instances written to MidwestDB 3000 ServiceProvLRN instances written to MidwestDB 4000 ServiceProvLRN instances written to MidwestDB 4700 ServiceProvLRN instances written to MidwestDB 5700 ServiceProvLRN instances written to MidwestDB Import completed successfully. Download Process Completed for LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Delete Process for 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 Will drop instances of: Drop instances of class `SubscriptionVersion' DROPPING INSTANCES. Delete Process Completed for 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Download Process for 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 1000 SubscriptionVersion instances written to MidwestDB 2000 SubscriptionVersion instances written to MidwestDB 3000 SubscriptionVersion instances written to MidwestDB 4000 SubscriptionVersion instances written to MidwestDB 4500 SubscriptionVersion instances written to MidwestDB Import completed successfully. Download Process Completed for 000000-999999.11-07-2001145342 Beginning Delete Process for 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 Will drop instances of: Drop instances of class `NumberPoolBlock' DROPPING INSTANCES. Delete Process Completed for 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 Beginning Download Process for 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 1000 NumberPoolBlock instances written to MidwestDB 2000 NumberPoolBlock instances written to MidwestDB Import completed successfully. Download Process Completed for 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 Script completed.
If you answered Y when prompted for any failure during the import process in 29, perform these substeps:
For example:
$ vi /var/TKLC/lsms/free/data/npacftp/Midwest/SPID.07-10-2000023849
If you specified the -c option in 29, perform these substeps:
For example:
$ vi /var/TKLC/lsms/free/data/npacftp/Midwest/SPID.07-10-2000023849_FAILED
NPAC Bulk Load File |
LSMS Database Object Class |
---|---|
000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 |
SubscriptionVersion |
0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 |
NumberPoolBlock |
LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 |
ServiceProvLRN |
NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 |
ServiceProvNPA_NXX |
NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 |
ServiceProvNPA_NXX_X |
SPID.07-11-2004023849 |
ServiceProvNetwork |
Output similar to the following appears:
1892 000000-999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 892 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 250 LRN.07-11-2004023849.07-10-2004023849.07-11-2004023849 23 NPANXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 12 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849 5 SPID.07-10-2004023849
892 0000000-9999999.07-11-2004023849.07-10-2004023849.07-11-2004023849 12 NPANXXX.07-11-2004023849.07-10-2004023849.07-11-2004023849
Output similar to the following appears:
$ lsmsdb -c counts -d MidwestDB 892 ........... MidwestDB.NumberPoolBlock 250 ........... MidwestDB.ServiceProvLRN 23 ............ MidwestDB.ServiceProvNPA_NXX 12 ............ MidwestDB.ServiceProvNPA_NXX_X 5 ............. MidwestDB.ServiceProvNetwork 1,892 ......... MidwestDB.SubscriptionVersion #
$ chglct -r <region> -s <YYYYMMDDhhmmss>
Where <region> is the name of the NPAC for which you are performing the download and <YYYYMMDDhhmmss> is the timestamp embedded in the file name as shown in the files displayed in 16. For more information about the chglct command, see “chglct”.If necessary, the My Oracle Support (MOS) will help the customer reassociate LSMS with the NPAC and perform manual time range resynchronizations.
For example:
$ $LSMS_DIR/start_mgui