:
@softhome.net Subject: Starting Database from OEM 9.2
gives ORA-12500 Failed to start a dedicated
Sent by:
ml-errors
Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
Sent by:
ml-errors
01/29/2004 06:14
PM
Please respond
to ORACLE-L
Hey all
Subject: Starting Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
Sent by:
ml-errors
01/29/2004 06:14
PM
Please respond
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
Dharminder,
Changes the service to AutoStart when the machine reboots. As Thomas said,
the NT service has to be running for you
There is not enough memory to start a dedicated connection. sochange the server mode from dedicated to shared, (you can do it change some parameters in init_sid.ora file see oracle documentation).
If you are going to change the server mode to shared and you have two databaseon the same machine,
, 2004 12:39 PMTo: Multiple
recipients of list ORACLE-LSubject: Re: Starting Database from OEM
9.2 gives ORA-12500 Failed to start a dedicated
There is not enough memory to start a dedicated connection.
sochange the server mode from dedicated to shared, (you can do it change
some
To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
dharminder cc:
@softhome.net Subject: Starting Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
Sent
Subject: RE: Starting Database from OEM
9.2 gives ORA-12500 Failed to star
Sent by:
ml-errors
To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
dharminder cc:
@softhome.net Subject: Starting Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
Sent
[EMAIL PROTECTED]
dharminder cc:
@softhome.net Subject: Starting
Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
Sent by:
ml-errors
-Original Message-
Igor Neyman
OracleServiceSID starts the database automatically, because by default
the registry key ORA_SID_AUTOSTART IN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 is set to TRUE.
If you don't want your OracleServiceSID to start the database
automatically, change
To: Multiple
recipients
of list ORACLE-L [EMAIL PROTECTED]
dharminder cc:
@softhome.net Subject: Starting
Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
Sent
Yes, I'm sure.
If in the services control panel you change OracleServiceSID starup
properties, it does not affect ORA_SID_AUTOSTART key in
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 (and does not change the way
the database is started when the service is started).
What it does, it changes the
.
The POVAGRMTLN.VEN_AGRMT_REF
field is char(30).
ORA-01722 invalid number
Cause: The attempted conversion of a character string to a
number failed because the character string was not a valid numeric literal. Only
numeric fields or character fields containing numeric data may be used in
arithmetic functions
.
The POVAGRMTLN.VEN_AGRMT_REF field is char(30).
ORA-01722 invalid number
Cause: The attempted conversion of a character string to a number failed
because the character string was not a valid numeric literal. Only numeric
fields or character fields containing numeric data may be used in
arithmetic functions
have
| any clue why this happen, I read about this error but the help
| don't seem to fit on this case.
| The POVAGRMTLN.VEN_AGRMT_REF field is char(30).
|
| ORA-01722 invalid number
|
| Cause: The attempted conversion of a character string to a number
| failed because the character string
and then try to start the other
database, but it does not start the DB, instead I get
ORA-12500 Failed to start a dedicated
OEM doc says that with OEM, you can start/shutdown the database using OEM.
Can someone point to me what I am doing wrong. I am using sys
username/password for the startup
more then 30 minutes finally
it crashes agaIN
VU_2exec testarray( 1 );
begin testarray( 1 ); end;
*
ERROR at line 1:
ORA-06500: PL/SQL: storage error
ORA-06512: at VRIJ_UIT.TESTARRAY, line 14
ORA-06512: at line 1
U_2select pool, sum(bytes) from v$sgastat group by pool;
POOL SUM(BYTES
When required I did it through a logon trigger ... wait I still do it.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
...
So the problem could be the listener ...
But if a try TNSPING extproc_connection_data, I got OK
Here is the copy of my listener file
SID_LIST_EXTPROCLISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME
/ as sysdba) and ran into
ORA-12540: TNS: internal limit restriction exceeded.
Where is this limit set? Is it possible to change the setting?
Here is some additional information
The application that connects to this db is java based...In the past when
we were seeing lot of 4030 errors in the alert log
Murali,
Have you checked the OS event logs like the system log? Sounds like you
have hit an OS limit. Please post the rest of the error stack that followed
the ORA-12450 as this gives more information on what is the root cause of
this failure? You can find this in the listener.log at the time
:
|
| Subject: Re: ORA-12540: TNS: internal limit restriction exceeded
|
| ||
|-+
---
---|
|
|
| To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] |
| cc:
|
| Subject: Re: ORA-12540: TNS: internal limit restriction
exceeded
|
| ||
|-+
---
---|
|
|
| To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: ORA-12540: TNS: internal
limit restriction
exceeded
so that's clear now.
What still bothers me is that my original program works fine
with pga_target = 0 and wa-size-policy=manual
When I try this with this test-program it fails (see below)
VU_2exec testarray(1);
begin testarray(1); end;
*
ERROR at line 1:
ORA-00604: error
name. No problem... or so I thought. :( All seems well
under
OEM and SQL+, but I have a developer who consistently gets an ORA-904
error
(invalid column name) when trying to access the new table under TOAD.
I can't think of anything weird about this table, except that the
original
has some
name. No problem... or so I thought. :( All seems well
under
OEM and SQL+, but I have a developer who consistently gets an ORA-904
error
(invalid column name) when trying to access the new table under TOAD.
I can't think of anything weird about this table, except that the
original
On 01/20/2004 02:59:35 PM, Tanel Poder wrote:
Hi!
Note that when you set an event with alter system, it will only apply
for
new sessions created, not for any existing ones.
And that, exactly is the problem. First, when you set event using
alter system, the setting is system wide. Second, if you
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him
But you can't set events with it :(
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 10:39 PM
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
For that, there is DBMS_SYSTEM.SET_EV. ;-)
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
Sent: Tuesday,
One thing I've been looking for is a way to set a string parameter in
another session, The two you mention handle INTEGER and BOOLEAN. I want
a way to set TRACEFILE_IDENTIFIER to a string in another session to make
it easier to identify trace files.
Any ideas?
Stephen
[EMAIL PROTECTED]
Ok, yeap I confused this with READ_EV, which can't read event from other
sessions...
Great job ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:19 PM
For that, there is DBMS_SYSTEM.SET_EV. ;-)
-Mark
Mark
WhoopsMeant to send this to the list, not just Stephen.
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
Sent:
On 01/20/2004 03:39:25 PM, Bobak, Mark wrote:
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
Thanks, Mark! I've learned something from you today! Who says
that one cannot teach an old bear new tricks.
--
Please see the official
below)
VU_2exec testarray(1);
begin testarray(1); end;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to
allocate 8144 bytes
(cursor
work he,qesaQBInit:buffer)
ORA-06508: PL/SQL: could not find
scripts for an in-house application, which
includes renaming an existing table, and creating a new version using the original
name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I
have a developer who consistently gets an ORA-904 error (invalid column name) when
trying
an existing table, and creating a new version using
the original name. No problem... or so I thought. :( All seems well under
OEM and SQL+, but I have a developer who consistently gets an ORA-904 error
(invalid column name) when trying to access the new table under TOAD.
I can't think of anything weird
Dear DBAs,
Good Morning. Using PL/SQL procedure I am trying to spool out
Japanese Characters with VARCHR2(3600) size and I am getting this error.
Here is my code. For your information it is Japanese Characters
Spool c:\test.log
Declare
cursor c1 is select
Dear Friends,
(B
(BThank you so much. Yes i was able to solve this issue..
(B
(BFYI ... I used CONVERT function
(B
(B
I'm having an ora-1555 under Oracle9 database and not
sure what I can do to get rid of it. I had some
recollecions from Oracle8 days , but the things like
adding a new rollback segment or shrinking the
segments I don't think are applicable under the auto
undo management. Besides separating
We're developing some schema update scripts for an in-house application, which
includes renaming an existing table, and creating a new version using the original
name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I
have a developer who consistently gets an ORA-904
]
Sent by: [EMAIL PROTECTED]
01/16/2004 16:09
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:ORA-904 after table rename
We're developing some schema update scripts for an in-house application,
which includes
Hi all:
I'm having an ora-1555 under Oracle9 database and not
sure what I can do to get rid of it. I had some
recollecions from Oracle8 days , but the things like
adding a new rollback segment or shrinking the
segments I don't think are applicable under the auto
undo management. Besides
Success! I've now learnt, from our network security admin guy, that the
Firewall Manager on the new network is configured by default to timeout
inactive connections after 60 minutes. Even though all the user clients
are inside the firewall, the server is specially ringfenced because the
is that my original program works fine
with pga_target = 0 and wa-size-policy=manual
When I try this with this test-program it fails (see below)
VU_2exec testarray(1);
begin testarray(1); end;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process
Have you considered enabling DCD? This causes oracle to send pseudo-keepalive packets
periodically, which should keep your sessions active from the firewall's perspective.
You enable this by adding
sqlnet.expire_time = ??
to sqlnet.ora on the DB server, where ?? is the frequency (in
Two custom views [DDFS_TOTAL on DBA_DATA_FILES,
and FSH_TOTAL on DBA_FREE_SPACE]
which I create in the DBSNMP schema are now failing with
ORA-00942 after having set O7_DICTIONARY_ACCESSIBILITY=FALSE.
The database is 8.1.7.4 32-bit on Solaris8.
These views used to work
--- Norris, Gregory T [ITS]
[EMAIL PROTECTED] wrote:
Have you considered enabling DCD?
Greg,
short of migrating to *nix, dead connection detection
does not work on win32. not in 8.1.7.4, not in
9.2.0.4.
possibly in 10g? ;)
Pd
This causes
oracle to send pseudo-keepalive packets
' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 10:34 PM
Hi,
I followed you advice and made small testprogram see below:
I only get the ora-06500 which I have had before
-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 10:34 PM
Hi,
I followed you advice and made small testprogram see below:
I only get the ora
In the UGA, I should think (which also means the
SGA if you are running MTS). It can't be in the
PGA (ignoring the fact that the UGA is in the PGA
for non-MTS) or you couldn't have global pl/sql
tables that persist across database calls.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
I have seen people bulk collect into pl/sql tables so much data that you
cannot even connect to the server. So I'm assuming that ones the UGA fills
up, Oracle will allocate whatever unused memory is left on the server for
pl/sql tables?
- Original Message -
To: Multiple recipients of list
to satisfy the
demands, the user's session will encounter ORA-4031.
In dedicated server, the UGA is allocated in the PGA. The user's session
will allocate more private memory (by growing the PGA heap) from system
memory. If/when the PL/SQL table grows so large as the process can no longer
allocate
://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 10:34 PM
Hi,
I followed you advice and made small testprogram see below:
I only get the ora-06500 which I have had before in the original
Hi,
I followed you advice and made small testprogram see below:
I only get the ora-06500 which I have had before in the original program as
A followup error so to me it seems to be reproducible.
In manuals I only find that the index
Of a pl/sql table cannot be more than 2**31, which
reporting ORA-3113 errors (end of file on communiation channel). In
every case, this happens after the user's connection has been inactive
for somewhat over an hour. There are no messages in the database alert
log, no trace files or dump files in the bdump, cdump or udump
locations, and no messages
connect to the databases, and all appeared well. Until our users started
reporting ORA-3113 errors (end of file on communiation channel). In
every case, this happens after the user's connection has been inactive
for somewhat over an hour. There are no messages in the database alert
log, no trace files
Hi Paul,
I'd start with reading Anita Bardeen's paper,
available on the NYOUG site:
http://www.nyoug.org/presentations.htm
ORA-3113's, 600's and 7445's Oh My!
Are these connections local, like on the same subnet,
or is there a firewall or router in between that could
be performing network
to see if they
match. If not, it's probably a soft corruption.
Or get Peter Gram to look at such stuff. He's crazy.
Mogens
Nguyen, David M wrote:
I got ORA-01578 error while querrying info for below table. How do I
fix this error?
SQLSelect count(*) from GATEWAYCALLSTATS;
*
ERROR at line
, David M wrote:
I got ORA-01578 error while querrying info for below table. How do I
fix this error?
SQLSelect count(*) from GATEWAYCALLSTATS;
*
ERROR at line 2:
ORA-01578: ORACLE* data block corrupted* (file # 3, block # 2683299)
ORA-01110: data file 3: '/apps/oracle
Hi,
I have posted a problem before
which I can only solve with a workaround but because I'm not getting
satisdactory answers from Oracle I'm trying
alternatives.
-
problem is a batch pl/sql package which ends
with ora-4030
-
batch runs fine on oracle 7.3.4, we migrated to oracle
06, 2004 2:54 PM
Hi,
I have posted a problem before which I can only solve with a workaround
but
because I'm not getting
satisdactory answers from Oracle I'm trying alternatives.
- problem is a batch pl/sql package which ends with ora-4030
- batch runs fine on oracle 7.3.4
Title: ORA-01578 data block corrupted
I got ORA-01578 error while querrying info for below table. How do I fix this error?
SQLSelect count(*) from GATEWAYCALLSTATS;
*
ERROR at line 2:
ORA-01578: ORACLE data block corrupted (file # 3, block # 2683299)
ORA-01110: data file 3: '/apps
When I increase the pga_aggregate_target to 2Gb and the
smm_max_size also the program fails around the following numbers from
pgastat
I'm not advocating fiddling with hidden parameters here, but there is one
more parameter which limits PGA usage, it's _pga_max_size and defaults to
200M.
o man to compensate him for what he is not, and a sense of humor was
provided to console him for what he is." --Unknown
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004
11:05 AMTo: Multiple recipients of list ORACLE-LSubject:
Title: ORA-01578 data block corrupted
Run dbv on the datafile.
Also there is a document on Metalink which describes how to handle data
block corruption.
Use the folliwng query to get segment name
SELECT TABLESPACE_NAME, SEGMENT_TYPE, OWNER, SEGMENT_NAMEFROM
DBA_EXTENTSWHERE FILE_ID
:
Sent by: Subject: ORA-01578 data block
corrupted
[EMAIL PROTECTED
, January 06, 2004 11:05 AM
*To:* Multiple recipients of list ORACLE-L
*Subject:* ORA-01578 data block corrupted
I got ORA-01578 error while querrying info for below table. How
do I fix this error?
SQLSelect count(*) from GATEWAYCALLSTATS;
*
ERROR at line 2:
ORA
Hi.
I getting ora-01548 error trying to drop an old undo
tablespace under oracle 9204. I have shut down the
database and brought it back (as metalink
recommended), but I still see some segments created in
the old undo tablespace and therefore I can't drop it.
What could be the reason, does anyone
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC
Hi there,
I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied the 9.2.0.3.0
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC
Hi there,
I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied the 9.2.0.3.0
Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC
Have you looked up on Metalink? there is ton of information out
there.
Raj
Rajendra dot Jamadagni at nospamespn dot
Hi,
I have an ora-4030 problem
related to pga memory
allocation, at least I have concluded sofar
This program is batch written
in pl/sql and after an hour or so it crashes. PGA allocated is slowly exceeding
2Gb and when I monitor with
top I see the process size rising uptill 2 Gb
Yesterday, wereceived the below message in our alert log.
Normally, we do not see such messages in an alert log.It might be a
spurious message since in the associated trace file it first says: FATAL
ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error.
Maybe just had a
Yesterday, wereceived the below message in our alert log.
Normally, we do not see such messages in an alert log.It might be a
spurious message since in the associated trace file it first says: FATAL
ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error.
Maybe just had a
this memory except there is a major bug some where, which I
doubt!
Please keep us
updated.
Thanks
Waleed
-Original Message-From: Jeroen van Sluisdam
[mailto:[EMAIL PROTECTED]Sent: Tuesday, December 23,
2003 10:24 AMTo: Multiple recipients of list
ORACLE-LSubject: ora-4030 pga
recipients of list ORACLE-LSubject:
ora-942 message in alert log
Yesterday, wereceived the below message in our alert log.
Normally, we do not see such messages in an alert log.It might be
a spurious message since in the associated trace file it first says:
FATAL ERROR IN TWO-TASK
I'm using auto pga allocation on 9.2.0.3 without any problem.
You don't mention which version.
You can turn it off with 'alter system set workarea_size_policy=manual;
Jared
On Tue, 2003-12-23 at 07:24, Jeroen van Sluisdam wrote:
Hi,
I have an ora-4030 problem related to pga memory
Hi,
I'm using oracle 9.2.0.4. I put it off tonight with the statement
You mentioned and unfortunately no success.
Maybe interesting to know that I started without the event 4030 set
And I get the following ora-600 in my alert file:
Tue Dec 23 16:46:42 2003
Errors in file /var/opt/oracle/product
Hi.
I'm getting ora 6000 error with the kdibc3position
argument in a prod DB. I have read some information on
that issue on the metalink, but the only workaround
that I seem to have found was to drop and rebuild
the bitmap indices on the table. I couldn't see any
info as to how to prevent
--_=_NextPart_001_01C3C583.D0824CB6
Content-Type: text/plain
hey everyone ...
The developers are loading blobs over database links. One of the 24 subsets
of data is failing with the following error:
ORA-1652: unable to extend temp segment by 512 in tablespace SYSTEM
The subset
of this message may not be legible.
--_=_NextPart_001_01C3C583.D0824CB6
Content-Type: text/plain
hey everyone ...
The developers are loading blobs over database links. One of the 24 subsets
of data is failing with the following error:
ORA-1652: unable to extend temp segment by 512
-Type: text/plain
hey everyone ...
The developers are loading blobs over database links. One of the 24 subsets
of data is failing with the following error:
ORA-1652: unable to extend temp segment by 512 in tablespace SYSTEM
The subset that is failing is reading a large amount of MRP data
...
The developers are loading blobs over database links. One of the 24 subsets
of data is failing with the following error:
ORA-1652: unable to extend temp segment by 512 in tablespace SYSTEM
The subset that is failing is reading a large amount of MRP data. The error
occurs in the instance
it?
Exception in thread main java.sql.SQLException: ORA-12154: TNS:could not resolve
service name
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.init(Compiled Code
or on a webserver. This program opens many simultaneous connections to the database.
The following error occurs on or near the 257th connection:
java.sql.SQLException: ORA-12154: TNS:could not resolve service name
All of the following symptoms apply:
- Solaris OS
- Oracle JDBC/OCI driver
- ORA
is easily reproducible bt
writing simple java program and keep creating connections(do not close it).
Did anyone encounter this kind of issue and how did you solve it?
Exception in thread main java.sql.SQLException: ORA-12154: TNS:could not
resolve service name
Hmm...my first thought is that this could be an OS/network configuration limitation on
the client side? Though it does seem odd to raise an ORA-12154, after many successful
connections
What OS is the client?
-Original Message-
Sent: Tuesday, December 16, 2003 2:39 PM
To: Multiple
in the neck. Hopefully, I will be
better off.
On 12/16/2003 02:59:33 PM, Bobak, Mark wrote:
Hmm...my first thought is that this could be an OS/network configuration limitation
on the client side? Though it does seem odd to raise an ORA-12154, after many
successful connections
What OS
it).
Did anyone encounter this kind of issue and how did you solve it?
Exception in thread main java.sql.SQLException: ORA-12154: TNS:could not
resolve service name
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code
.
The following error occurs on or near the 257th connection:
java.sql.SQLException: ORA-12154: TNS:could not resolve service name
All of the following symptoms apply:
- Solaris OS
- Oracle JDBC/OCI driver
- ORA-12154 Error
- Failure occurs on 257th connection between JDBC client and Oracle server.
- Same
it?
Exception in thread main java.sql.SQLException: ORA-12154: TNS:could not
resolve service name
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.init(Compiled Code
for certain session time limt...
Regards
Rafiq
Bug 2556295 SDO_INTERSECTION fails with large GEOMETRIES (ORA-21779)
This note gives a brief overview of bug 2556295.
Affects:
Product (Component) Oracle Spatial (SDO)
Range of versions believed to be affected Versions 10G
Versions confirmed
GEOMETRIES (ORA-21779)
This note gives a brief overview of bug 2556295.
Affects:
Product (Component) Oracle Spatial (SDO)
Range of versions believed to be affected Versions 10G
Versions confirmed as being affected 9.2.0.3
9.2.0.4
Platforms affected Generic (all / most platforms affected)
Fixed
for this
sesion which may be avoided...meaning have you assigned any profile to that
user running export for certain session time limt...
Regards
Rafiq
Bug 2556295 SDO_INTERSECTION fails with large GEOMETRIES (ORA-21779)
This note gives a brief overview of bug 2556295.
Affects:
Product (Component
got an Oracle 8.1.7 installation on Sun Solaris 8 (sparc). We use
some
database management software which gegerates several select-statements
going
over ten database users. After some seconds (everytime in another db-user
and
another table), the system prints out the following error:
ORA-02045
and
another table), the system prints out the following error:
ORA-02045: too many local sessions participating in global transaction
ORA-02063: preceding line from STGTSU
What's up here?
greetz
Elmar
--
+++ GMX - die erste Adresse für Mail, Message, More +++
Neu: Preissenkung für MMS und FreeMMS
Running dbua to upgrade 8.1.7 to 9.2.0 database produces:
ORA-12545: Connect failed because target host or object does not exist.
Very annoying because looking at logs under .../assistants subdirectories and
../admin/upgrade/logs or the alert log - directories doesn't show what the missing
1 - 100 of 2137 matches
Mail list logo
