]To:
[EMAIL PROTECTED]
on.com cc:
[EMAIL PROTECTED]
Subject: RE: ora-600
when analyzing IOT
08/07/2003 12:13
PM
Rick
Unfortunately he's rebooted so the box is probably clean.
Did all of your products relink successfully?
Are there any errors in the OS system logs?
Would any of the patches have changed you kernel settings for shared memory
or semaphores?
Can you run the HP equivalent of truss (I believe it's
Any log file output?
Mike
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: 06 August 2003 16:29
To: Multiple recipients of list ORACLE-L
Applied 250 OS patches on HP-UX 11.11 server and after that getting
ORA-3113 error message every time I do svrmgrl or sqlplus /nolog connect
ORA-16016 archived log for thread string sequence# string unavailable
Hello All
I have a standby database oracle 8.1.7.4 on win2k running in managed
recovery mode. NET8 have been transferring logs untill somehow the
primary or standby server must have rebooted and I have now have
sequence gaps
cc:
Sent by: Subject: ora-600 when
analyzing IOT
[EMAIL PROTECTED]
.com
08/07/2003 12:44
PM
First, sorry for asking this list before searching Metalink,
but I dont have access to it right now.
So, here it is:
Im getting:
ORA-00600: internal error code, arguments: [15163], [333],
[17424], [16191], [], [], [], []
when analyzing one of the index-organized tables:
ANALYZE
to acquire ST after a couple
seconds, it times out and issues ORA-01575 to the alert.log.
So, based on experiences from 6-7 years ago:
* do you have a lot of dictionary-managed tablespaces?
* do these DMT's have default PCTINCREASE non-zero, thus attacting
SMON to do coalescing?
If so, I'd
Hi all:
I'm seeing the ora-01575 error in the alert logfile.
The article on the metalink refers to the parameter
which I think is obsolete in the ORacle version we are
running (8.1.7). What does this error refer to? Any
thoughts? references?
thanks
gene
__
Do
:[EMAIL PROTECTED]Sent: Monday, July 14,
2003 10:05 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: import from 8i to 9i
/IMP-3:ORA-02298
Just to update you all...
I am not having any problems if I setup a
db link from 9i to 8i and get the data then enable
Chris,
The query is showing 99.19% of the sorts done in
memory.
thank you
Gene
--- [EMAIL PROTECTED] wrote:
Are you doing a lot of sorting with a small
sort_area_size set?
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
of the issue.
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote:
Tanel hit the nail on the head. In the past,
ORA-01575 was usually
associated with temporary tablespaces that were DMT
and not tablespace type
TEMPORARY (which started in Oracle7.3). First and
foremost, please make
sure you
been trying to get the ok to switch to LMTs on all our isntances. have gotten no so
far.
We ran into:
ORA-01693 max # extents (string) reached in lob segment string.string
Cause: A LOB segment tried to extend past MAXEXTENTS.
Action: If MAXEXTENTS is less than the system max, raise
to 0 in all tablespaces in order to get
rid of this ora 1575? Wouldn't I want to have an
automatic coalesce process for the DMTS though?
thank you
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote:
Haven't seen this error since Oracle7...
If the message is hitting the alert.log, then
chances
$sysstat a,
v$sysstat b
WHERE
a.name = 'sorts (disk)'
and b.name = 'sorts (memory)';
Regards,
Chris Gait
on 8/12/03 12:44 PM, Gurelei at [EMAIL PROTECTED] wrote:
Hi all:
I'm seeing the ora-01575 error in the alert logfile.
The article
]
on.com cc: [EMAIL PROTECTED]
Subject: RE: ora-600 when analyzing
IOT
Reserved.
ORA-03113: end-of-file on communication channel
SVRMGR
-Original Message-
Sent: Wednesday, August 06, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Any log file output?
Mike
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: 06 August 2003 16:29
To: Multiple
:
Sent by: Subject: ora-600 when analyzing IOT
[EMAIL PROTECTED
/orcl_ora_4345.trc
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [],
[]
Here is part of my procedure:
query:='select/*+ FIRST_ROWS */ from article a where a.aid=e.aid and
d.eventid=e.eventid and d.verbid=''REVW'''||chr(13)||' and d.actorid
Ok, since my original message still hasn't arrived (sent couple hours
ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code
:)
joe
[EMAIL PROTECTED] wrote:
No, There is no log generated. Below is the only message I am getting.
hp204:NAMES :/home/oracle svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
ORA-03113: end-of-file
-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 08, 2003 10:59 PM
ORA-16016 archived log for thread string sequence# string unavailable
Hello All
I have a standby database oracle 8.1.7.4 on win2k running in managed
recovery mode. NET8 have been transferring logs untill
..sounds like a IPC problem.
Check ora network and listener config.
relink client
relink utilities
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
No, There is no log generated. Below is the only
Title: RE: ora-600 when analyzing IOT
Only missing data in *_TABLES is avg_row_len which, probably, can be used for estimating hash area for hash join.
Also, columns statistics will not be generated, probably more important.
Alex.
-Original Message-
Does it mean, that if I don't
Hi,
I got this error when I run my procedure:
!-- SQL ERROR:ORA-00600: internal error code, arguments: [15212], [1], [],
[], [], [], [], [] --
Errors in file /ora817/app/oracle/admin/ORCL/udump/orcl_ora_4345.trc
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15212
cc:
Sent by: Subject: RE: ora-600 when analyzing
IOT
[EMAIL PROTECTED
- Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
ORA-03113: end-of-file on communication channel
SVRMGR
-Original Message-
Sent: Wednesday, August 06, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Any log file output?
Mike
-Original Message
Did you relink sqlplus?
Did you relink client?
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
Applied 250 OS patches on HP-UX 11.11 server and after that getting
ORA-3113 error message every time I do
Guys,
I am installing Oracle 9.2.0.1 on Win2K Adv.Server/SP3.
While database configuration asst. is creating the database,i get the error:
ORA-29838 insufficient privileges to execute the operator(s)
I found from docs that:
Cause: User does not have privileges to execute one
Hi,
Ilooked at metalink for bugs on ORA-27101 and did not find anything.
Possibly because I'm on 9i and looked for that as well.
These are my Oracle settings.
The only thing odd may be that the lkORA92 file is all capitals whereas
everything else is initCap for the sid.
Only 1 Oracle
to just run the Oracle Home Selector
that appears in the Startup-Programs-Oracle Installation
Products
menu.
It has the benefit of also modifying the PATH variable.
Jared
On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
RE: ORA-03115 (TOAD question!!)Hi,
It worked!! As suggested by Raj, I
modifying the PATH variable.
Jared
On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
RE: ORA-03115 (TOAD question!!)Hi,
It worked!! As suggested by Raj, I browsed the TOAD help on
SQL*Net
installation and found out this piece of information:
**
When Oracle connects, it will look
: ORA-03115 (TOAD question!!)
I believe I read on the TOAD list that they are working on a
major upgrade
to the free version of TOAD that will bring it up to the 7.5
code base. I
think the target date was September...
Dave
-Original Message-
From: Jesse, Rich [mailto
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 6:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-03115 (TOAD question!!)
I believe I read on the TOAD list that they are working on a
major upgrade
to the free
: Boivin, Patrice J [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-03115 (TOAD question!!)
Where can we get a list of the bugs in freeware TOAD?
Patrice.
-Original Message-
Sent: Thursday, July 31, 2003
Title: RE: ORA-03115 (TOAD question!!)
Hi,
It
worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net installation
and found out this piece of information:
**
When Oracle connects, it will look in ALL_HOMES for the
"LAST_HOME" value, which in this case is zero "0&qu
You may find it easier to just run the Oracle Home Selector
that appears in the Startup-Programs-Oracle Installation Products
menu.
It has the benefit of also modifying the PATH variable.
Jared
On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
RE: ORA-03115 (TOAD question!!)Hi,
It worked
Title: Message
I set
the value to 2147483648 and it still does the same thing.
Oracle
database is open but when trying to connect through sqlnet I get
ORA-27101.
I do
shutdown immediate and startup and the problem is gone for a
while.
I now
stopped the archiver again and see
Title: ORA-27101 RH linux 9 Oracle 9.2.0.3
Hi,
I have above setup on my homebox. Every now and then I get Oracle error 27101, and have to restart the database. I can connect / as sysdba and select * from v$database though.
Has anybody seen this happen before and may be able to help me
**
Strange indeed.
Jack
Original Message-From:
Suhen Pather [mailto:[EMAIL PROTECTED] Sent: Wednesday,
July 30, 2003 11:09 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: ORA-27101 RH linux 9 Oracle
9.2.0.3
Jack
Title: ORA-27101 RH linux 9 Oracle 9.2.0.3
Jack,
ORA-27101: shared
memory realm does not exist
Oracle probably
been aborted for some reason.
Strangehow
you can do a select * from v$database.
How much memory
and swap space you have configured.
Regards
Suhen
-Original Message
Hi Friends ,
I have a procedure which inserts around 6 million records dynamically from one
table to another . During the insertion process the oracle throwed ora 6501 program
error . There is enough table space available and enough rollback segments are also
available. Can you please
one table to another . During the insertion process the oracle throwed ora
6501 program error . There is enough table space available and enough
rollback segments are also available. Can you please elaborate what could be
the problem for this error.
Regards,
Shankar
--
Please see the official
Augusto
da Silva
Technology
Services Support
NLA Technology Services
Phone: +55 11 3398-8438
Fax: +55 11 3398-7522
-Mensagem original-
De: Jack van Zanen [mailto:[EMAIL PROTECTED]
Enviada em: quarta-feira, 30 de
julho de 2003 06:39
Para: Multiple recipients of list
ORACLE-L
Assunto: RE: ORA
: Multiple recipients of list
ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle
9.2.0.3
Have you tried to
reconnect to the instance? Does the instance shuts down or your
connection?
Try changing the
following parameters:
Oracle9i
Installation
Guide
Release 2
original-
De: Jack van Zanen [mailto:[EMAIL PROTECTED]
Enviada em: quarta-feira, 30 de
julho de 2003 09:59
Para: Multiple recipients of list
ORACLE-L
Assunto: RE: ORA-27101 RH linux 9
Oracle 9.2.0.3
Hi,
Have
tried to reconnect and get the error message 27101 (when
Title: Message
Damn
your right,
I need
new glasses :-)
Thx
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday,
July 30, 2003 3:14 PMTo: Multiple recipients of list
ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle
9.2.0.3
4:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-03115 (TOAD question!!)
7.6 is BETA. 7.5.2 is the current release. New betas appear
frequently.
Also, this version is not free. It's listed at just under
$800 US. The
freeware version is v6.x, which has the LOB bug
Hi,
I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server
and Oracle 7.3.4 client on my NT4 machine. When I connect to
remote/local databases through TOAD 6.5 (which supports LOBs) and
try to fetch a CLOB value I get the 'ORA-03115: Unsupported
network datatype or representation'.
I
Title: RE: ORA-03115 (TOAD question!!)
It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem.
Raj
Rajendra dot Jamadagni
Server, Oracle 9i Enterprise Server
and Oracle 7.3.4 client on my NT4 machine. When I connect to
remote/local databases through TOAD 6.5 (which supports LOBs) and
try to fetch a CLOB value I get the 'ORA-03115: Unsupported
network datatype or representation'.
I think that this error is due
PROTECTED]
Sent: Tuesday, July 29, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-03115 (TOAD question!!)
Not sure but this might have something to do with charset (if toad can
handle clob??? ) . what is db charset ? is it utf8 .
-ak
- Original Message
I would recommend upgrading to 7.6.x you can download it from www.quest.com
From: AK [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ORA-03115 (TOAD question!!)
Date: Tue, 29 Jul 2003 07:49:23 -0800
Not sure but this might have
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Jay Wade [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-03115 (TOAD question!!)
I would recommend upgrading to 7.6.x you
the temp seg?
8-))
hth,
Guido
[EMAIL PROTECTED] 27.07. 05.54
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help
Hi Saira,
maybe temp tablespace isn't large enough.
did you try what the doctor suggests?
Did you enlarge the temp seg?
8-))
hth,
Guido
[EMAIL PROTECTED] 27.07. 05.54
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means
4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of
ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help. The warehouse needs to be in production
tomorrow 8AM!
Thanks,
Saira
--
Please see the official ORACLE-L
enough.
did you try what the doctor suggests?
Did you enlarge the temp seg?
8-))
hth,
Guido
[EMAIL PROTECTED] 27.07. 05.54
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: 8.1.7 instance on
upgraded AIX machine - ORA-1652 all
tablespace isn't large enough.
did you try what the doctor suggests?
Did you enlarge the temp seg?
8-))
hth,
Guido
[EMAIL PROTECTED] 27.07. 05.54
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our
, straight up
from 32-bit 4.3.3?
On 2003.07.27 00:39, Saira Somani wrote:
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of
ORA-1652
which means that our application cannot commit any
transactions (or so I am finding
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help. The warehouse needs to be in production
tomorrow!
Thanks,
Saira
--
--
Please see the official ORACLE-L FAQ:
http
,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help. The warehouse needs to be in production
tomorrow!
Thanks,
Saira
--
--
Please see
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help. The warehouse needs to be in production
tomorrow!
Thanks,
Saira
--
Please see
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help. The warehouse needs to be in production
tomorrow 8AM!
Thanks,
Saira
--
Please
,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help. The warehouse needs to be in production
tomorrow 8AM!
Thanks,
Saira
--
Please see the official
From the docs...
ORA-01652 unable to extend temp segment by string in tablespace string
Cause: Failed to allocate an extent for temporary segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.
So Check your Temp TBS
means.
--- Ganesh Raja [EMAIL PROTECTED] wrote:
From the docs...
ORA-01652 unable to extend temp segment by string in
tablespace string
Cause: Failed to allocate an extent for temporary
segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement
to add one or more
files
,
allocations and alike. You are probably using 64 bit
JFS on 5L, straight up
from 32-bit 4.3.3?
On 2003.07.27 00:39, Saira Somani wrote:
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of
ORA-1652
which means that our
on both
databases.
The
problem is, at night when the batch load is running (by itself), the load fails
with a ORA-01555. The data is the same on both loads. Nothing else
is going on in the database during the load.
Any
ideas?
Ron
Ron
I'm guessing that one of the loads receives the ORA-01555 and the other
doesn't. Does the load commit occasionally? There are some pretty good
papers on Metalink for this error.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent
Ron,
Are the sizes of the data manipulated by the batch load the same?
Is the db_block_size the same on each database?
What is the size of the rbs during processing? What is the hwmsize, shrinks,
extends from v$rollstat?
You may be encountering a situation where
They are both processing the same data, the same way.
-Original Message-
Sent: Tuesday, July 22, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Ron
I'm guessing that one of the loads receives the ORA-01555 and the
other doesn't. Does the load commit occasionally
of list ORACLE-L
Ron
I'm guessing that one of the loads receives the ORA-01555 and the
other doesn't. Does the load commit occasionally? There are some pretty
good papers on Metalink for this error.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Hi,
When I run ORDSYS.ORDImage.setProperties, I got this error:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocPLSExtProc: fatal:
/others/app/oracle/product/8.1.7/lib/libordim8.so: open failed: No such file
or directory
I don't have /others/app/ dir in my disk, my
Ron - I think you are feeling that one system is good and the other is bad.
My suggestion is to consider one system at the ragged edge of failing and
the other system over the edge and in the ditch. Next week with a different
set of data, they may both well fail or both succeed. With ORA-01555
as tothe real causes of this
error. The error message text itself is sometimes
misleading.
Cheers
Lindsay
-Original Message-From: Smith, Ron L.
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 22, 2003 5:04
PMTo: Multiple recipients of list ORACLE-LSubject:
Please help with ORA
Hi,
I got this error when process blob file:
ORA-01691: unable to extend lob segment ELI.SYS_LOB025110C2$$ by
100358 in tablespace DATA2
I added new data file for DATA2, but still the same error.
Please help!
Thanks,
Jack
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
by: [EMAIL PROTECTED]
07/22/2003 12:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:ORA-01691: unable to extend lob segment
ELI.SYS_LOB025110C000
Hi,
I got this error when process blob file:
ORA
with uniform size.
Jared
Liu, Jack [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/22/2003 01:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: ORA-01691: unable to extend lob segment
PROTECTED]
cc:
Subject:ORA-29540: class oracle/plsql/net/TCPConnection does not exist
Helo all,
I have installed oracle JVM on oracle817, windows2000.
Asper the doc from metalink, i installed it
sucessfully. When i'm using the utl_smtp package from
the client forms6i, the error
Helo all,
I have installed oracle JVM on oracle817, windows2000.
Asper the doc from metalink, i installed it
sucessfully. When i'm using the utl_smtp package from
the client forms6i, the error ORA-29540: class
oracle/plsql/net/TCPConnection does not exist raised
out.
How to proceed next
Roy:
This is a cut-and-paste from the Oracle TAR.
HTH,
Mike
***
For the x_$ view not able to recompile successfully:
- issue the following query and note the object_id:
SQL select object_id, object_name from dba_objects
where
List...
OS: SunOS 5.8
Oracle: 8.1.6.1.0
I'm getting the above error in the alert file...
my db is up and running, and the trace file says that
the error was generated without user session.
I looked at metalink and it says that it can be a pga
problem or virtual memory problem...
but... my
-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July
09, 2003 11:59 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: import from 8i to 9i
/IMP-3:ORA-02298
I did that already. Please see
below..
ERROR 1:
=
IMP-00017: following statement
error message when I try to
connect though firewall (from DMZ to Network).
ORA-12535: TNS:operation timed out
Do I need to do special configuration (like cman)
around firewall?
Thanks In Advance,
Bob
__
Do you Yahoo!?
SBC
.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
You obviously do need special configuration.
You are welcome.
On 2003.07.08 17:09, Bob Robert wrote:
All,
I am getting following error message when I try to
connect though firewall (from DMZ to Network).
ORA-12535: TNS:operation timed
that the control file will accept - some
bleed into the next column which is a date field, messing up that
column, etc with ORA-01841 (full) year must be between -4713 and +,
and not be 0.
The datatype in the table is:
MODCNT NUMBER -- no precision defined
The value in the file for this field
: import from 8i to 9i
/IMP-3:ORA-02298
With all my today's trials(including
import into 8i db on Sun)I used different export file than the one I
have used other day.
I am wondering if the ftp(I did it in bin
mode only)from unix box to windows box caused something?
Anyway, I got
I suggest calling Oracle Support. Get a test case ready.
Please post how the problem gets resolved.
- Kirti
--- [EMAIL PROTECTED] wrote:
I tried it on my sun box, still same problem.
Also I tried with no compressing/uncompressing of dmp file, no luck.
-Original Message-
: Wednesday, July
09, 2003 11:14 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: import from 8i to 9i
/IMP-3:ORA-02298
I tried it on my sun box, still same
problem.
Also I tried with no
compressing/uncompressing of dmp file, no luck.
-Original
Message
When all else fails...
Log a TAR with Oracle
Sit back and wait, while enjoying a few belts of quality Kentucky sipping Bourbon
Read through the phone book and locate all the Ursulas in the greater Frankfort area...begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
I have opened TAR this morning.
Sure, will let you know.
Thank you all for your time.
Surendra
-Original Message-
Sent: Wednesday, July 09, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
I suggest calling Oracle Support. Get a test case ready.
Please post how the problem
;
No rows.
-Original
Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09, 2003
10:37 AMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: import from 8i to
9i /IMP-3:ORA-02298
Surendra,
Go back to
the 8i database
to
connect though firewall (from DMZ to Network).
ORA-12535: TNS:operation timed out
Do I need to do special configuration (like cman)
around firewall?
Thanks In Advance,
Bob
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http
are welcome.
On 2003.07.08 17:09, Bob Robert wrote:
All,
I am getting following error message when I try to
connect though firewall (from DMZ to Network).
ORA-12535: TNS:operation timed out
Do I need to do special configuration (like cman)
around firewall?
Thanks In Advance
also in
US7ASCII with UTF8, just to make sure that I won't hit any conversion
issues.
When I tried to import the data into this newly created database it is
giving me some strange ORA-02298: cannot validate (CMS.FK_OF_VS_SYSID) -
parent keys not found errors.
I have verified that the data in 8i
file of 8i database. I have
my
8i database created in US7ASCII and I have created 9i database also in
US7ASCII with UTF8, just to make sure that I won't hit any conversion
issues.
When I tried to import the data into this newly created database it is
giving me some strange ORA-02298: cannot
into this newly created database it
is
giving me some strange ORA-02298: cannot validate
(CMS.FK_OF_VS_SYSID) -
parent keys not found errors.
I have verified that the data in 8i database is valid.
I have successfully imported into an existing 8i database with no
problem.
I
am wondering
hit any conversion
issues.
When I tried to import the data into this newly created database it is
giving me some strange ORA-02298: cannot validate (CMS.FK_OF_VS_SYSID) -
parent keys not found errors.
I have verified that the data in 8i database is valid.
I have successfully imported
Title: RE: import from 8i to 9i /IMP-3:ORA-02298
What userid is exporting data and importing data? Try exporting and importing as system.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
301 - 400 of 2137 matches
Mail list logo