WINDOWS XP (32bit/64bit)

WINDOWS 2003 SERVER (32bit/64bit)

WINDOWS VISTA (32bit/64bit)

WINDOWS 2008 SERVER (32bit/64bit)

WINDOWS 7 (32bit/64bit)

1 GIG RAM MINIMUM (2 GIG RECOMMENDED)

20-21 GIGS OF DISK SPACE

What installation type has the following outcome:

Installs Retail Pro 9 applications, the Oracle database and the Oracle client automatically using the largest drive available

What installation type has the following outcome:

Installs the Oracle client automatically using the largest drive available

What installation type has the following outcome:

Installs Retail Pro 9 applications and the Oracle client automatically using the largest drive available

What installation type has the following outcome:

Installs Retail Pro 9 applications, the Oracle database and the Oracle client to a user-selected drive

What steps should be taken before installing Retail Pro 9 Server?

• DEFRAG THE SYSTEM
• SAVE INSTALLATION FILES LOCALLY (ON THE DRIVE...NOT ON THE DESKTOP)
• EXCLUDE ORACLE/RETAILPRO9 FOLDERS FROM ANTI-VIRUS
• INSTALLATION ID
• SUBSIDIARY NUMBER

• FIRST TIME YOU APPLY THE MAINTENANCE PACK
• SUBSEQUENT MAINTENANCE PACKS SHOULD NEVER DISABLE ARCHIVING

• BUG FIXES
• NEW FUNCTIONALITY
• DATABASE CHANGES
• LAYOUTS
• DOCUMENTATION
• NEW RETAIL PRO APPLICATIONS

• DEFRAG THE SYSTEM
• SAVE INSTALLATION FILES LOCALLY (ON THE DRIVE...NOT ON THE DESKTOP)
• EXCLUDE ORACLE/RETAILPRO9 FOLDERS FROM ANTI-VIRUS
• ESTABLISH A NETWORK CONNECTION BETWEEN SERVER AND CLIENT MACHINES (MAP DRIVES)
• SHARE OUT THE “RETAILPRO9” FOLDER (SERVER SIDE)
• ADD PORT 1521 (TNSLISTENER) TO FIREWALL EXCEPTIONS
• ADD ORACLE.EXE TO FIREWALL EXCEPTIONS

• SYSTEM ACCESS/AVAILIBILITY IS HIGH
• LESS USERS = HIGHER PERFORMANCE

• MORE DATABASES = MORE MAINTENANCE/ADMINISTRATION
• NOT REAL-TIME (CAN BE NEAR REAL-TIME)
• REQUIRES ECM

• REAL-TIME
• ONE DATABASE = LESS MAINTENANCE/ADMINISTRATION
• NO ECM

• PERSISTENT CONNECTION TO THE DATABASE
• ONE DATABASE = ONE POINT OF FAILURE (MITIGATED USING HIGH AVAILABILITY SERVER CLUSTERS)
• ONE DATABASE = MUST SHUT DOWN FOR SOME DB MAINTENANCE ISSUES
• MANY USERS = LOWER PERFORMANCE

SAME AS CENTRALIZED BUT ON A REGIONAL BASIS:

• REAL-TIME
• ONE DATABASE = LESS MAINTENANCE/ADMINISTRATION
• NO ECM

SAME AS CENTRALIZED BUT ON A REGIONAL BASIS:

• PERSISTENT CONNECTION TO THE DATABASE
• ONE DATABASE = ONE POINT OF FAILURE (MITIGATED USING HIGH AVAILABILITY SERVER CLUSTERS)
• ONE DATABASE = MUST SHUT DOWN FOR SOME DB MAINTENANCE ISSUES
• MANY USERS = LOWER PERFORMANCE

When adjusting Windows Processor Scheduling which option is best for client machines?

When adjusting Windows Processor Scheduling which option is best for server machines?

When adjusting Windows DEP settings what file must be modified in order to turn off DEP settings?

When adjusting Windows DEP settings if DEP settings are not turned off, what is the recommended setting? 

• ADD ORACLE.EXE TO EXCEPTIONS LIST
• ADD PORT 1521 TO EXCEPTIONS LIST

• ADD “RETAILPRO9” FOLDER TO EXCLUSIONS LIST
• ADD “ORACLE” FOLDER TO EXCLUSIONS LIST

EXPORT TECHTOOLKIT PERMISSIONS à DBSEC.DAT à MANUALLY MOVE DBSEC.DAT TO “RETAILPRO9” FOLDER

• CHECK SERVICES
• REBOOT
• CHECK DISK SPACE
• LAUNCH TOOLKIT
• CHECK ALERT LOGS / TRACE FILES
• TRY TO FIX ISSUE / RECOVER FROM BACKUP

• 1 ALERT LOG
• MANY TRACE FILES

<CTRL+END> TO GO TO BOTTOM OF THE LOG; <CTRL+F> TO LOCATE “ORA-“ ENTRIES (GOING UP THE LOG)

ORA-600 errors possibly points to hard disk corruption.  What Oracle tool can be used to verify this?

Retail Pro cannot be launched (Unable to Communicate with Database) so you access Technician’s Toolkit and you receive a “Database Not Mounted” error.  What could this indicate?

• DATABASE PROBLEM
• CONTROL FILE ISSUE

Retail Pro cannot be launched (Unable to Communicate with Database) so you access Technician’s Toolkit and all tools are available.  What could this indicate?

Retail Pro cannot be launched (Unable to Communicate with Database) so you access Technician’s Toolkit and only a few tools are available.  What could this indicate?

Retail Pro cannot be launched (Unable to Communicate with Database) so you access Technician’s Toolkit and when checking the Data File Recovery area, you notice a specific data file has a ZERO size.  What could this indicate?

• DATA FILE ISSUE
• DATA FILE COULD NOT BE FOUND à CHECK AUDIT LOG
• DATA FILE IS CORRUPT à CHECK AUDIT LOG à CHECK DBVERIFY
• DATA FILE IS OUT OF DATE

Retail Pro cannot be launched (Unable to Communicate with Database) so you access Technician’s Toolkit and when checking the Data File Recovery area, you notice there are no data files listed at all.  What could this indicate?

What does this DOS command do:

C:\> find /I “ORA-“ /n C:\Oracle\diag\rdbms\rproods\trace\alert*.* >error.txt

What does this DOS command do: ADRCI>show alert?

• RPROODS (ORACLE.EXE)
• TNSLISTENER (TNSLSNR.EXE)
• LICENSING (LICENSESERVER.EXE)

1. NETSTAT –A –N –O
2. CHECK PIDS FOR PORT 1521
3. CHECK TASK MANAGER TO SEE WHICH PROGRAMS = PIDS

What Backup Type requires the database to be shut down?

What Backup Type does not require the database to be shut down?

What Recovery Option restores the system from a specific complete Backup?

What Recovery Option restores the system to the state immediate before the failure point?

What Recovery Option restores the system to a specified date/time prior to the failure point?

Determine which ECM Program is responsible for the task/item below:

Establish all communications-related settings

Determine which ECM Program is responsible for the task/item below:

Initiate the movement of data (i.e. the Send/Receive” function)

Determine which ECM Program is responsible for the task/item below:

Prepare data for movement

Determine which ECM Program is responsible for the task/item below:

Update Retail Pro with newly-received data

Determine which ECM Program is responsible for the task/item below:

Compresses/decompresses data

Determine which ECM Program is responsible for the task/item below:

Set up as a windows service and must be running for the Send/Receive function to work properly

Determine which ECM Program is responsible for the task/item below:

Determine which ECM Program is responsible for the task/item below:

Generates XML files

Determine which ECM Program is responsible for the task/item below:

Create and managed ECM stations

Determine which ECM Program is responsible for the task/item below:

Associated with the /out and /in command-line parameters

Determine which ECM Program is responsible for the task/item below:

Associated with the /exchange command-line parameter

• DISK POLLING
• FTP
• INTERNET
• MODEM

• HELP SETUP NEW ECM STATIONS (WITH CONSISTENT PROFILE CHECKLIST/TOOLS)
• ALSO USED FOR HANDLING MID-DAY COMMUNICATION INSTRUCTIONS

• PROCESS OUT KEY INFORMATION (PREFERENCES, CUSTOMERS, EMPOYEES, INVENTORY, SECURITY, PRICING, DOCUMENTS, SUBLOCATION)
• SYSTEM CRASHES AND YOU NEED TO SEND THEM KEY INFORMATION (W/O DISTURBING THE DEFAULT PROFILE CHECKLIST)
• SEND NEW STATION KEY INFORMATION (W/O DISTURBING THE DEFAULT PROFILE CHECKLIST)

• HISTORY DOCUMENTS
• INVENTORY
• CUSTOMERS
• PLANNING DOCUMENTS
• MARKDOWNS

• 20,000 (DEFAULT) – SET IN ECM W/S PREFERENCES
• CAN BE MODIFIED IF NEEDED VIA ECM W/S PREFERENCES (WILL UPDATE ECMEXCHANGE SERVICE)

CLIENT ID

ACTIVATION PASSWORD

• TCP/IP (INTERNET)
• FILE DROP

• PLSàOPS (ONCE/YEAR)
• SLSàPLS (ONCE/MONTH)

LOCATION OF MERCHANISE (PHYSICAL OR LOGICAL)

OR

INSTALLATION OF THE RETAIL PRO DATABASE (SERVER)

5 SITES (5 DB > 2 LOCATIONS OF MERCHANDISE)

9 SEATS (CONCURRENT CONNECTIONS TO ALL POTENTIAL DB)

• PORT 6469 (SLSàPLS)
• PORT 80 (PLSàOPS)

• DEACTIVATE BEFORE MAKING HWR CHANGES
• DEACTIVATE (FORCED DEACTIVATION) TO FREE UP SITES/SEATS FROM A SLS