The database team just patched the Oracle database with the latest and
greatest security patch. Since they patched it, my application has not been
stable. My application uses ODP 10.1.0.4 and C#. The majority of the database
calls are in stored procedures. The error that is thrown by Oracle is
"ORA-6550: line 0, column 0:PLS:00907: cannot load library unit PKG_PRODUCT
(referenced by )" along with "ORA-04068: existing state of packages has been
discarded" though the packages have not been changed in serveral months. We
have tried recompiling them just in case. The application has worked till the
patch was applied. The database team rolled back the patch, but the
application is still having problems. Bouncing the instances of the database
does bring us back up, but only temporarily. The periods of us being up have
ranged from 5 minutes to 6 hours. The average is about 2.5 to 3 hours, but we
are getting worse. I'm in the process of upgrading to ODP 10.2.0.2.21, but am
not convinced that this will correct the problem and am afraid that it may
make things worse. We have a tar open with Oracle, but they have not yet
responded. None of the other applications that do not user the ODP are having
problems (they are java), but my application is a lot more database reliant.
I created a test application that uses a stored procedure and inline SQL and
the SQL queries do work even when the stored procedures do not. We are
getting very frustrated as are our users. Any ideas? 1 2233
"Susan" <Su***@discussi ons.microsoft.c omwrote in message
news:2F******** *************** ***********@mic rosoft.com...
The database team just patched the Oracle database with the latest and
greatest security patch. Since they patched it, my application has not
been
stable. My application uses ODP 10.1.0.4 and C#. The majority of the
database
calls are in stored procedures. The error that is thrown by Oracle is
"ORA-6550: line 0, column 0:PLS:00907: cannot load library unit
PKG_PRODUCT
(referenced by )" along with "ORA-04068: existing state of packages has
been
discarded" though the packages have not been changed in serveral months.
We
have tried recompiling them just in case. The application has worked till
the
patch was applied. The database team rolled back the patch, but the
application is still having problems. Bouncing the instances of the
database
does bring us back up, but only temporarily. The periods of us being up
have
ranged from 5 minutes to 6 hours. The average is about 2.5 to 3 hours, but
we
are getting worse. I'm in the process of upgrading to ODP 10.2.0.2.21, but
am
not convinced that this will correct the problem and am afraid that it may
make things worse. We have a tar open with Oracle, but they have not yet
responded. None of the other applications that do not user the ODP are
having
problems (they are java), but my application is a lot more database
reliant.
I created a test application that uses a stored procedure and inline SQL
and
the SQL queries do work even when the stored procedures do not. We are
getting very frustrated as are our users. Any ideas?
http://www.google.com/search?hl=en&q...=Google+Search This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: simianphile |
last post by:
OK, I had a problem that I've now fixed but I can't really understand
what was causing it in the first place. I have an intranet site that
uses basic authentication to allow users to view and update information
from an Oracle DB (ver 8.1.6 -- ancient, I know). Anyway, the site
worked fine as long as the machine accessing the ASP page was running
Win 2k but when an XP machine tried to view the page, the client got an
error:
Microsoft...
|
by: Harry |
last post by:
Using Oracle 8i enterprise on win 2000 (sp3)
Installed the standard configuration & whenever I make a connection it
takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason
there for slowness.
Once I'm connected the queries work pretty much instantanously but to
connect using SQLPLUS, Toad, ODBC, OLEDB all take about 10 secs. I
connect using OLEDB from Visual Basic development environment & after
the 1st connection...
|
by: Phil Hindmoor |
last post by:
Hi,
I am sure if anyone can help me, you guys can!
I am an Informix Developer, moving to Oracle 8i and later databases.
I am struggling to find the Oracle equivelant to many of the useful
Informix features that I have come to rely upon.
I have looked through the Oracle/Infomix groups and some helpful
users have posted some solutions, but many of them seem to be very
complex work-arounds for features that were readily available in
|
by: SerGioGio |
last post by:
Hello,
I am going nuts. I am trying to connect to my local ORACLE instance using
ODBC.
It used to work few weeks ago, but it fails now.
Connection with:
- SQL*plus: connection works!
- DataDirect 5.0 Oracle Wire protocol (3rd party ODBC driver): connection
works when I hit the driver's "test connection"
|
by: Ellen K. |
last post by:
Hi all,
Being that so far I didn't get an answer to my below problem on the
Oracle newsgroup, I figured it couldn't hurt to try here.
While at my current job I've been working with mostly SQL Server, now
I need to connect to our Oracle Financials running on HP-UX. The
Oracle DBA set me up as a user and installed the Oracle client on my
box and I have the tnsnames file, but I still can't establish a
connection to the database from my...
| |
by: Ellen K |
last post by:
Hi all,
I set up our Oracle Financials as a linked server to one of my SQL
Server boxes. On running a test query, I got the following error
message:
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
OLE DB error trace .
The Oracle datatype of the column with the supposedly inconsistent
|
by: Nick Palmer |
last post by:
Hi all,
Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two
DB2 databases and I need to get access to the tables in one from the other.
In Oracle I would just create a DB Link between the two instances. Is such
a thing possible between two DB2 databases ?
Thanks in advance,
Nick
|
by: Steve Foo |
last post by:
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it.
I have contacted Singapore Microsoft support regarding the problem .Unfortunately they are not able to help me and eventually direct me here
i'm not 100% sure if this problem is due to ODP.net provider or asp.net IIS setting
Hopefully Microsoft Experts here can help me up. Thx
Introduction...
|
by: Chris Botha |
last post by:
The machine is running XP Pro with all the latest service packs, etc. I must
access an Oracle database so I installed the Oracle client stuff. I can
query Oracle from a Windows app, no problem. Using the exact same code (copy
and paste) into a Web app I get the following error "Error while trying to
retrieve text for error ORA-01019". Security I thought, so I use
Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
|
by: Ruslan A Dautkhanov |
last post by:
Hello !
I'm about to install O9i on FreeBSD box.
uname -a:
FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2:
Fri Apr 23 19:19:43 KRAST 2004
rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386
uname -a under oracle user :
Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23
19:19:43 KRAST 2004 i686 unknown
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |