Home » Infrastructure » Windows » intermittent ora-06550 after exp/imp
intermittent ora-06550 after exp/imp [message #101142] Mon, 24 May 2004 18:43
Michael Murphy
Messages: 1
Registered: May 2004
Junior Member
Original Set up on one box_1:
OS: Win 2000 Server
DBMS: Oracle 8.1.7
App: ASP front/VB middle in COM+/stored procedures in packages.
Data Access: Microsoft OLEDB for Oracle. Registry settings in place to allow transactions.
This app has been in production for 2 years.

Trigger event:
To relieve resource issues, a new box_2 was built with Oracle 8.1.7. Exp schema from box_1 and then imp to box_2. No errors/warnings on import. Updated tnsnames.ora and shutdown box_1 DBMS.

Result:
Unit testing was fine. Under load, ora-06550 and pls-03500(?) errors (invalid params/wrong type-number/pl-sq errors) thrown intermittently.

I did not build box_2, but verified same init.ora parameters were used.

Any ideas more than welcome.
Thanks.
Previous Topic: Connecting to a Database
Next Topic: Windows 4 GT Feature
Goto Forum:
  


Current Time: Fri Nov 22 13:53:27 CST 2024