ORACLE 600 DATABASE WON’T OPEN

Symptom:
Cannot start Retail Pro, The TechToolkit fails to open the database during startup.
– ORA-00600 [dbkif_find_next_record_1] error is present in the ALERT_RPROODS.LOG

Cause:
Typically this is the result of a sudden system shutdown that leaves Oracle in a state where it needs to do crash recovery during startup. The error found in the alert log is an ORA-00600 with this exact string as the first argument: “[dbkif_find_next_record_1], [], [], [], [], [], [], [], [], [], [], []”
The condition occurs while Oracle is performing an internal recovery process following a crash. The database fails to open due to a bug in a component that is used by Oracle for session recovery.
REF Oracle bug # 9139693

Solution:
Oracle patch 45 for 11G, not yet deployed as a part of RetailPro9.

Workaround:
The Oracle recommended work around is to do the following.
1. Shutdown the database
2. Browse to the following folder. “Oraclediagrdbmsrproodsrproodsir” in Windows
3. Rename this file “recovery_history.ir”
4. Restart the database

Resume use of the system

Notes:
i. The above workaround is intended for this specific ORA-00600 error condition. Do not use this workaround in an attempt to recover from other “similar” situations unless directed to by support.
ii. This workaround, while it has proved to work in some situations, may not fully resolve the problem due to other issues that may be present in the database. If the application of this workaround fails to restore the database to a full working state make a cold backup of the database and contact support.

Warning:
It is advised that you make a backup of any files that are to be renamed.

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

17573

or

Schedule A Demo

Popup — Contact Us

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Comments
This field is for validation purposes and should be left unchanged.

54883

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

46274

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

17181

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Comments
This field is for validation purposes and should be left unchanged.

43057

or

Schedule A Demo

Sandy Malaney

Upon graduating with a degree in business from California State University, Sacramento, Sandy Malaney accepted a sales position from Lanier Business Products. She found her stride in outside sales, becoming Lanier’s top producer in their telecommunications division.

In 1988, Malaney joined Checkpoint Systems, selling security systems to retail companies. Malaney gained valuable information about the retail sector that would eventually lead her to her next career at a startup called Retail Technologies, Inc. (RTI) in 1990.

As vice president of sales and marketing, Malaney focused on sales, brand marketing, and expanding product line. (Today Retail Technologies is known as Retail Pro International (RPI), and is headquartered in Folsom, CA.)

Then in 1993, RTI eliminated its sales division to focus solely on software development. Sandy and her husband Mick seized the opportunity to open a software distributorship that included selling and supporting RTI’s point of sale and inventory management solution—Retail Pro.

The Malaneys didn’t need to look far for a business name. “Big Hairy Dog” described the family dog, Molly, an Old English Sheep Dog. Today, pups Dugan Finnegan and Paisley Rose continue to dutifully represent the family business.

Sandy Malaney’s varied experiences in business and in life prepared her for the rigors of owning a small technology firm. Celebrating 27 years (or—189 dog years) of success, Big Hairy Dog continues to expand in the retail market place, while providing an award-winning help desk to customers worldwide.

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

70628

TECHNICAL SUPPORT

tech@BigHairyDog.com

Support Hours

Monday – Friday: 6AM-6PM PST

PST Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

After-Hours Phone Number:
916.368.1070

Fax: 916.368.1411

3205 Ramos Circle Sacramento, CA 95827

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Phone
This field is for validation purposes and should be left unchanged.

79651

BIG HAIRY DOG

3205 Ramos Circle
Sacramento, CA 95827
800-377-7776 FAX: 916-368-1411
Info@BigHairyDog.com

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Support Hours

Monday – Friday: 6AM-6PM PST
Saturday: 9AM-5PM PST
Sunday: 9AM-2PM PST

Mick Malaney President & Co-Founder
CELL: (916) 803-3939

Sandy Malaney CEO & Co-Founder
CELL: (916) 802-3939

Sales Department

800-377-7776 | 916-368-3939
Info@BigHairyDog.com
Karen Page CELL: 503-728-8396

Felicia Casper CELL: 916-956-9727

Technical Support Department

916-368-1070
Tech@BigHairyDog.com

Customer Service/Upgrade Service

800-377-7776 | 916-368-3939
Service@BigHairyDog.com

Administration/Billing

916-368-3939
Admin@BigHairyDog.com