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.
|
|
|