core dump [ttci2u()+2356] and ORA-03113 at clientend

2003-11-13 Thread Seema Singh
) and some error on client box(Linux). Sun box (DB error) ORA-07445: exception encountered: core dump [ttci2u()+2356] [SIGSEGV] [Address not mapped to object] [0] [] [] On Linux box(Client box) exception 3113, ora8.c:2161:ora_get_row: error in `OCILobRead ()': ORA-03113: end-of-file

Re: ORA-03113: end-of-file ... during Oracle Streams setup

2003-10-26 Thread Mladen Gogala
Well, it's easy. You're doing shutdown immediate during the procedure execution. do shutdown abort and you'll get rid of the error message. On 2003.10.26 16:14, [EMAIL PROTECTED] wrote: Hi List I am in the process of setting up Oracle Streams and getting the following error *** 2003-10-26

Re: ORA-03113: end-of-file ... during Oracle Streams setup

2003-10-26 Thread tamizh
No. I did not shutdown the oracle DB. It is an oracle bug. Problem:- BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee = 'STRMADMIN', grant_option = TRUE); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege

ORA-03113: end-of-file ... during Oracle Streams setup

2003-10-26 Thread tamizh
Hi List I am in the process of setting up Oracle Streams and getting the following error *** 2003-10-26 17:01:38.417 *** SESSION ID:(11.18) 2003-10-26 17:01:37.836 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted ORA-00448:

Re: ORA-03113: end-of-file ... during Oracle Streams setup

2003-10-26 Thread Mladen Gogala
This is the error message: ORA-01089: immediate shutdown in progress - no operations are permitted. Either you shut the database down or somebody else did. You didn't buy a Halloween edition of oracle, did you? If you think it's a bug, you'll have to show the trace file of the failed

ORA-03113 on using create_stored_outlines

2003-09-09 Thread bulbultyagi
* from scott.emp ; create table test as select * from scott.emp * ERROR at line 1: ORA-03113: end-of-file on communication channel (And I get a core dump file ) The same thing happens irrespective of the category name I use in alter session set create_stored_outlines , even when i specify

RE: Dedicated Server problem ORA-03113

2003-06-30 Thread Denham Eva
of their resource intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections

RE: Dedicated Server problem ORA-03113

2003-06-30 Thread Kirtikumar Deshpande
dedicated server because of their resource intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected

RE: Dedicated Server problem ORA-03113

2003-06-30 Thread Denham Eva
. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have seen up to nine dedicated server

Dedicated Server problem ORA-03113

2003-06-28 Thread Denham Eva
: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have seen up to nine dedicated server connections before. Anyone

Re: Dedicated Server problem ORA-03113

2003-06-28 Thread Tanel Poder
intensive sql etc just cann't connect. We get this error: ORA-03113: end-of-file on communication channel I have tried reloading, stopping and starting the Listener, but to no avail. There are only two dedicated sessions connected to the server and it still refuses any connections, and I have

RE: ORA-03113 After Pathc 8.1.7.4

2003-06-07 Thread Ramon E. Estevez
])' Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

ORA-03113 After Pathc 8.1.7.4

2003-06-06 Thread Ramon E. Estevez
Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

FW: ORA-03113 After Pathc 8.1.7.4

2003-06-06 Thread Ramon E. Estevez
Platform suse linux professional 7.2 Sorry :-( Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Friday, June 06, 2003 7:14 PM To: 'DBA List ([EMAIL PROTECTED])' Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113

RE: ORA-03113 After Pathc 8.1.7.4

2003-06-06 Thread Richard Ji
- Sent: Friday, June 06, 2003 7:14 PM To: 'DBA List ([EMAIL PROTECTED])' Hi list, I installed the patch 8.1.7.4 and now when trying to start the instance I get ORA-03113 after like 1 minute. I followed the steps in the readme file of the patch. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809

ORA-03113: End of File on Communication Channel

2003-02-12 Thread Ovidiu Maftei
Hello guys, I have an unexpected problem with this error. It appears when I executeand select statement showing bellow. The strange things isuntil nowI don't catch itnevermore. I use two RDBMS: Oracle 8.1.7 EE for Windows NT4 andOracle 8.1.7 EE for HPUX. The select statemen is: select

ORA-03113 solved .....

2002-10-17 Thread Johnson, Michael
After several tests on different machines we found that it was not a version problem, but a environment problem. What happened is that one of our DBAs had created a Unix alias to bring the instance up in her profile and that did not set up the environment properly even though the database came

Drop snapshot ORA-03113

2002-10-16 Thread Vladimir Barac
- but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET

Drop snapshot ORA-03113 - part 2

2002-10-16 Thread Vladimir Barac
DBA_JOBS shows that there is job associated with phantom refresh group. Can't remove job because user that owns it does not exist (remember fromuser/touser). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network

AW: Drop snapshot ORA-03113

2002-10-16 Thread v . schoen
snapshot ORA-03113 Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong

RE: Drop snapshot ORA-03113 - part 2

2002-10-16 Thread John . Hallas
Have you tried execute sys.dbms_ijob.remove(xx); An undocumented provedure that I picked up on from this list a few weeks ago John -Original Message- Sent: 16 October 2002 17:04 To: Multiple recipients of list ORACLE-L DBA_JOBS shows that there is job associated with phantom refresh

RE: Drop snapshot ORA-03113 - part 2

2002-10-16 Thread Naveen Nahata
See if SYS.DBMS_IJOB.REMOVE(job_id) or SYS.DBMS_IJOB.DROP_USER_JOBS('USERNAME') works Regards Naveen -Original Message- Sent: Wednesday, October 16, 2002 9:34 PM To: Multiple recipients of list ORACLE-L DBA_JOBS shows that there is job associated with phantom refresh group. Can't

RE: Drop snapshot ORA-03113

2002-10-16 Thread Johnson, Michael
to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA

RE: How to fix ORA-03113 error

2002-10-15 Thread Nguyen, David M
... There seems to be some known bugs in this area... Check Note:1069812.6 on Metalink... Tim -Original Message- Sent: Monday, October 14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix

RE: How to fix ORA-03113 error

2002-10-15 Thread Johnston, Tim
14, 2002 8:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE

Re: How to fix ORA-03113 error

2002-10-15 Thread Tim Gorman
ry created around the same time? Hopefully, the first thing you did was log a TAR on MetaLink, right? - Original Message - From: "Nguyen, David M" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 9:54 A

RE: How to fix ORA-03113 error

2002-10-15 Thread Johnson, Michael
with it. fwiw. Mike -Original Message- Sent: Monday, October 14, 2002 5:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR

How to fix ORA-03113 error

2002-10-14 Thread Nguyen, David M
I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total

Re: How to fix ORA-03113 error

2002-10-14 Thread Jared . Still
] cc: Subject:How to fix ORA-03113 error I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area

RE: How to fix ORA-03113 error

2002-10-14 Thread Johnston, Tim
database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area

RE: Help on ORA-03113 error and 7445 in the trace file.

2002-10-11 Thread Johnson, Michael
Title: RE: Win2000/8.1.7.3.0/SQL Update ... we dont see this problem if we rlogin to the server via a Sun Solaris client box. -Original Message-From: Johnson, Michael Sent: Friday, October 11, 2002 10:38 AMTo: '[EMAIL PROTECTED]'Subject: Help on ORA-03113 error and 7445

Help on ORA-03113 error and 7445 in the trace file.

2002-10-11 Thread Johnson, Michael
... SQL Create user blah identified by blah default ts blah temporary ts blah; SQL Drop user blah; ORA-03113 end of file blah blah blah The server thread process is disconnected and we have to reconnect. ORA-07445 shows up in the trace file. After reconnecting we do indeed see

RE: ORA-03113 with dbms_output and sysdate

2002-09-25 Thread Nirmal Kumar Muthu Kumaran
Your current session's DB has been gone out. Here is the scanario, Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL SET SERVEROUT ON SQL BEGIN 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD

RE: ORA-03113 with dbms_output and sysdate

2002-09-25 Thread Inka Bezdziecka
Seems like not a network then. Have you read a note 1020463.6 (mind you, it is a bit dated)? inka -Original Message- Sent: Tuesday, September 24, 2002 11:08 PM To: Multiple recipients of list ORACLE-L I will try that. The confusing part is I can run : select TO_CHAR(SYSDATE, 'DY,

Re: ORA-03113 with dbms_output and sysdate

2002-09-25 Thread Ramon E. Estevez
SET SERVEROUTPUT ON BEGIN dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY')); END; / WED, SEP 25 10:20:10002 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:38 AM Your current session's DB

ORA-03113 with dbms_output and sysdate

2002-09-24 Thread Steve Perry
Has anyone seen this cause an error before. I can run this script on other datbases (same version) without any problems. This database was rebuilt from production. I can select the to_char... into a varchar2 variable and then print the variable and it works. I've bounced the database also, but

RE: ORA-03113 with dbms_output and sysdate

2002-09-24 Thread Mercadante, Thomas F
Steve works fine for me on 8171 on WinNT Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set serveroutput on SQL DECLARE 2 3BEGIN 4 5dbms_output.put_line(TO_CHAR(SYSDATE,

RE: ORA-03113 with dbms_output and sysdate

2002-09-24 Thread Inka Bezdziecka
It is neither dbms_output nor sysdate. Try a loopback. This error is related to the network and I am sure that there is a lot on MetaLink. inka -Original Message- Sent: Tuesday, September 24, 2002 2:05 PM To: Multiple recipients of list ORACLE-L Steve works fine for me on 8171 on

Re: ORA-03113 with dbms_output and sysdate

2002-09-24 Thread Todd . R . Thompson
Check your ORA_NLS_33 parameter and make sure it is valid... Steve Perry [EMAIL PROTECTED] on 09/24/2002 01:48:25 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Has anyone seen this cause an error before. I can run this

Re: ORA-03113 with dbms_output and sysdate

2002-09-24 Thread Steve Perry
I will try that. The confusing part is I can run : select TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') into datevar from dual; dbms_output.put_line( datevar); and it works fine. I can run all my other sql scripts without error. I'd be surprised if it was a network error, but I'm willing to

ORA-03113 will creating db

2002-09-05 Thread Pawan Dalmia
Hi All, I am Installed Oracle 8.1.7 on Solaris 8 on sun sparc machine(1 gb Ram) . Installation went off sucessfully without any Problem. But at time of creation of database through DB Assist it is giving ORA-03113 end-of-file on communication channel.I have even tried to create database

ORA-03113: end-of-file on communication channel. HELP !

2002-07-25 Thread arul . kumar
. ERROR: ORA-03113: end-of-file on communication channel Enter user-name: / @dcclive Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Why ? Please note that Oracle login has

RE: ORA-03113: end-of-file on communication channel. HELP !

2002-07-25 Thread kkennedy
), it DOES NOT connects to the database. To connect now, i have to use TNS Alias as seen below. uid=1037(dcclive) gid=101(dba) kitchen% sqlplus / SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jul 25 12:07:36 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-03113

More info About RAC, LINUX and ORA-03113

2002-07-02 Thread Jack van Zanen
Oracle version 9i release 2 LINUX RH7.3 === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze

ORA-03113: end-of-file on communication channel

2002-05-06 Thread John Weatherman
All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now

Re: ORA-03113: end-of-file on communication channel

2002-05-06 Thread Ray Stell
Doc ID: 17613.1 On Mon, May 06, 2002 at 12:18:18PM -0800, John Weatherman wrote: All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink

RE: ORA-03113: end-of-file on communication channel

2002-05-06 Thread Chen, Brian
: Multiple recipients of list ORACLE-LSubject: ORA-03113: end-of-file on communication channel All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open

Re: ORA-03113: end-of-file on communication channel

2002-05-06 Thread DBarbour
: Sent by: Subject: ORA-03113: end-of-file on communication channel [EMAIL PROTECTED

Re: ORA-03113: end-of-file on communication channel

2002-05-06 Thread Manh Tran
Hi, Kill -9 PID of pmon process and wait for 10 seconds, everything will be cleaned for you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manh Tran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: ORA-03113

2002-04-23 Thread reger
OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix

RE: ORA-03113

2002-04-22 Thread Jamadagni, Rajendra
3113 is a tough beast to resolve. We have some java processes that feed out spores to our clients. Recently at about 5:30pm and 6pm they all started throwing 3113 errors (with corresponding Exception 11 dump files on the server bdumps and cores too). Mind it well, the server trace file just tells

Re: ORA-03113

2002-04-22 Thread reger
, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem. Even better

Re: ORA-03113

2002-04-22 Thread Anjo Kolk
Rajendra, The coredumping is ofcourse a bug in Oracle. However, not producing a stack trace and error stack also sounds like an bug to me. What is the response from Oracle Support on this ? You are using AIX and what version of Oracle ? Thanks, Anjo. - Original Message - To: Multiple

RE: ORA-03113

2002-04-22 Thread Jamadagni, Rajendra
Anjo, me think it is something related to bind values and we use cursor_sharing=force. There is a bug already logged in and colleague of mine is working on it. In the mean time, I noted it here, because a shared_pool flush worked. I am on 9012 on AIX 4.3 64 bit. I think this is where I was told

ORA-03113

2002-04-21 Thread ltiu
Hello Guys, Linux 2.4.18 Pentium III both Oracle 9i and 8i used netca and netmgr to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file

Re: ORA-03113

2002-04-21 Thread Jared Still
init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email

Re: ORA-03113

2002-04-21 Thread Ray Stell
and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some

Re: ORA-03113

2002-04-21 Thread Joe Testa
OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem could be but not a solution. Could someone on this list email be some suggestions on how to fix this problem

RE: ORA-03113

2002-04-21 Thread Wong, Bing
to configure listener listener is configured and listening off port 1521 init.ora is ready and in under OracleHome/dbs in sqlplus, the command startup nomount gives me this error: ORA-03113 end-of-file on communication channel I've read the 9i ErrorCodes documentation, it explains what the problem

LogMiner and ORA-03113

2002-01-18 Thread Walter K
I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a new and start prior to running the query. This process that I am going through works on some log files

Re: LogMiner and ORA-03113

2002-01-18 Thread Joe Testa
whats your blocksize, anything other than 2K has been know to cause all kinds of problems. joe Walter K wrote: I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I

Re: LogMiner and ORA-03113

2002-01-18 Thread Walter K
getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a new and start prior to running the query. This process that I am going through works on some log files but not on others. The log files aren't corrupted because I can

Re: LogMiner and ORA-03113

2002-01-18 Thread Joe Testa
of problems. joe Walter K wrote: I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a new and start prior to running the query. This process that I am going through works

RE: ORA-03113

2001-11-29 Thread Koivu, Lisa
Title: RE: ORA-03113 Why don't you want to want to take all the oracle processes down? I thought that's what you wanted to accomplish with shutdown immediate? Go ahead and issue Mladen's command and restart the database. It's the only way you can bring it down if you can't connect

ORA-03113

2001-11-29 Thread Greg Faktor
Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 different databases. This command was posted some time back by Mladen: ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 It's will take all oracle

RE: ORA-03113

2001-11-29 Thread Troiano, Paul (CAP, GEFA)
Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 -Original Message- Sent: Thursday, November 29, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can

RE: ORA-03113

2001-11-29 Thread Mohan, Ross
grep, then, for the instance you DO want to take down. or, ask Mladen again. I understand he likes taking things down! ;-) -Original Message- Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10

Re: RE: ORA-03113

2001-11-29 Thread Greg Faktor
: Thursday, November 29, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03113 Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 different databases. This command was posted some time

RE: RE: ORA-03113

2001-11-29 Thread Koivu, Lisa
Title: RE: RE: ORA-03113 Yes, you are right. If you have multiple instances change the command to something like this, assuming your sid name is SID ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9 Try it without the xargs kill -9 to verify it's choosing what you need

RE: RE: ORA-03113

2001-11-29 Thread Rao, Maheswara
Title: RE: RE: ORA-03113 Lisa, ps -fu oracleSID - command would not work. The reason is when you -u option with ps, it looks for the user by name mentioned. In this case, there would not be any user by name oracleSID (most likely). All the oracle processes would be owned by the user

RE: RE: ORA-03113

2001-11-29 Thread Ball, Terry
-Original Message- From: Greg Faktor [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03113 Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance

RE: RE: ORA-03113

2001-11-29 Thread Koivu, Lisa
Title: RE: RE: ORA-03113 Thanks Rao for correcting me. Like I confessed earlier, I am unix savvy, not an expert :) -Original Message- From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE

Re: ora-03113 ora-03114

2001-11-19 Thread A. Bardeen
several tables/indexes on a v7.3.3 database on nt 4.0 sp4. Most to all of the table rebuilds included changing the initial extent. A fews days later we started experiencing ora-03113/03114 errors on the client side. This is a small database/applications which serves a small user base, 10 - 15

ora-03113 ora-03114

2001-11-17 Thread Shaw, Donnie
I recently rebuild several tables/indexes on a v7.3.3 database on nt 4.0 sp4. Most to all of the table rebuilds included changing the initial extent. A fews days later we started experiencing ora-03113/03114 errors on the client side. This is a small database/applications which serves a small

ORA-03113 DURING DATABASE STARTUP

2001-11-02 Thread Harvinder Singh
Hi, We have just created the database on solaris unix box and we are able ro run all applications. But when we reboot the sun box and try to start database we are getting error ORA-03113. I tried all the points which are specified in metalink articles.. Following one of the articles i

Re: ORA-03113 DURING DATABASE STARTUP

2001-11-02 Thread Seema Singh
Did u check shared memory and unix parameter?If UNIX parameters are ok then please try to start with mount options. -Seema From: Harvinder Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORA-03113 DURING DATABASE STARTUP

RE: ORA-03113 DURING DATABASE STARTUP

2001-11-02 Thread Chepuri Pramo (AP/QSW3, AB/QSW3)
-Original Message- Sent: Friday, November 02, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Hi, We have just created the database on solaris unix box and we are able ro run all applications. But when we reboot the sun box and try to start database we are getting error ORA-03113. I

ORA-24323 ORA-03113 ORA-01034 ORA-27101 errors

2001-10-05 Thread Okan CIMEN
: value not allowed ORA-03113: end-of-file on communication channel When I try to log on as any user I get these messages; SQL connect anyuser Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I am still

Re: ORA-24323 ORA-03113 ORA-01034 ORA-27101 errors

2001-10-05 Thread tday6
by: rootcc: Subject: ORA-24323 ORA-03113 ORA-01034 ORA-27101 errors 10/05/2001

Re: ORA-24323 ORA-03113 ORA-01034 ORA-27101 errors

2001-10-05 Thread C.S.Venkata Subramanian
ORA-24323: value not allowed ORA-03113: end-of-file on communication channel When I try to log on as any user I get these messages; SQL connect anyuser Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory I am

Re: ORA-03113 when executing the initjvm script

2001-10-02 Thread Beatriz Martínez Jiménez
Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1

ORA-03113 when executing the initjvm script

2001-10-01 Thread Beatriz Martínez Jiménez
Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA

Re: ORA-03113 when executing the initjvm script

2001-10-01 Thread Christian Trassens
of the 3113 in the init.ora: event=3113 trace name errorstack level 10 REGARDS. --- Beatriz Martínez Jiménez [EMAIL PROTECTED] wrote: Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp

RE: ORA-03113 when executing the initjvm script

2001-10-01 Thread Christopher Spence
the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA-03113: end-of-file

RE: ORA-03113 when executing the initjvm script

2001-10-01 Thread K Gopalakrishnan
Chris, Basically the error 3113 is bit different from the other errors. Most of the errors (if not all ORA errors other than 3113 and 1041 I think) are generated from rdbms kernel where as 3113 is generated from the client side, You won't be able to get an error stack trace or

RE: ORA-03113 when executing the initjvm script

2001-10-01 Thread Jamadagni, Rajendra
Gopal, I have tried it many times (dumping errorstack at level 3 on 3113) but somehow it didn't give the analyst any clue. I don't know why ... and neither did he (the analyst). Of course none of my errors are related to JVM, we haven't started putting JAVA in our DB, that's for 9i

Urgent: ORA-03113

2001-07-24 Thread Sadzakovic Slavica
Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might be possible reason? Software installation went without problems. Please help -- Please see the official ORACLE-L FAQ: http

Re: Urgent: ORA-03113

2001-07-24 Thread k johnson
You missed some of the parameter or environmental settings. --- Sadzakovic Slavica [EMAIL PROTECTED] wrote: Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might

ORA-03113 end of file comm. error - Why???

2001-07-16 Thread Csillag Zsolt
Hi, I have a program that converts records from d-base to Oracle 8.1.7. I works perfectly but about once a week it gives the Ora-03113 error and the whole Oracle freezes, we have to restart the whole server. There is no logic in it since if I repeat the converting procedure 100 times

RE: ORA-03113 end of file comm. error - Why???

2001-07-16 Thread MacGregor, Ian A.
recipients of list ORACLE-L Hi, I have a program that converts records from d-base to Oracle 8.1.7. I works perfectly but about once a week it gives the Ora-03113 error and the whole Oracle freezes, we have to restart the whole server. There is no logic in it since if I repeat the converting

RE: URGENT ORA-03113

2001-07-13 Thread Christian Trassens
installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora I checked previous messages. Someone suggested to reduce the size of kernel

URGENT ORA-03113

2001-07-12 Thread Helen rwulfjeq
Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.o

Re: URGENT ORA-03113

2001-07-12 Thread Christian Trassens
has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora I checked previous

RE: URGENT ORA-03113

2001-07-12 Thread Jon Walthour
6:45:22 AM Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV/pfile/initDEV.ora

Re: URGENT ORA-03113

2001-07-12 Thread Helen rwulfjeq
8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora" I checked previous messages. Someone suggested

RE: URGENT ORA-03113

2001-07-12 Thread Helen rwulfjeq
AIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: 7/12/01 6:45:22 AM Hi ALL:Anybody has any luck to install oracle 8.1.7 on Solaris 8. Iinstalled 8.1.5 on same OS without any problem. When I run dbassist, I got ORA-03113 error message. Actually It happened whe

RE: URGENT ORA-03113

2001-07-12 Thread Gogala, Mladen
[EMAIL PROTECTED] wrote: On Thu, Jul 12, 2001 at 02:45:22AM -0800, Helen rwulfjeq wrote: Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you

RE: URGENT ORA-03113

2001-07-12 Thread Helen rwulfjeq
lt;[EMAIL PROTECTED]>Date: 7/12/01 6:45:22 AM Hi ALL:Anybody has any luck to install oracle 8.1.7 on Solaris 8. Iinstalled 8.1.5 on same OS without any problem. When I run dbassist, I got ORA-03113 error message. Actually It happened when youexecute the command:startup nomount pfile="/u01/app

RE: URGENT ORA-03113

2001-07-12 Thread Mohammad Rafiq
] Date: 7/12/01 6:45:22 AM Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: startup nomount pfile=/u01/app/oracle/admin/DEV