Eddy, March 19, 2001 - 1:10 am UTC
errors
atul, September 13, 2002 - 10:54 pm UTC
Sir,
Recently we are getting errors like
Spooled file is /tmp/pms_rcia_log.dat
ORA-24323: Message 24323 not found; product=RDBMS; facility=ORA
Message 626 not found; product=SQLPlus; facility=SP2
ERROR:
ORA-03114: not connected to ORACLE
When running a job which connect to other database run sql there..
Part of script goes like this...
echo "Generating pms rcia log file "
echo "Generating pms file ">>$LOGFILE
echo "Spooled file is /tmp/pms_rcia_log.dat"
export TWO_TASK="RDI"
sqlplus -s /
@$sprexe/p_log.sql /tmp/p1_log.dat
export TWO_TASK=OW
echo "End of pms creation procedure. Press enter to continue...\c"
export TWO_TASK=OW
What could be the reason
Thanks.
atul
September 14, 2002 - 3:10 pm UTC
Looks like your oracle home isn't set, we cannot find the message files.
A reader, October 21, 2002 - 5:32 am UTC
Hi Tom,
When I try to connect to the database, then I get the error
SQL>startup file=d:\oracle\admin\mysid\pfile\initmysid.ora
ORA-24323: value not allowed
ORA-01031: insufficient privileges
could you please tell me what's wrong with it?
October 21, 2002 - 7:47 am UTC
unchange whatever you changed in your init.ora since your last successful restart. make sure you are logged in as the person who is able to start the database as well.
Seeing as how my crystal ball is in the shop this week -- I cannot actually see what the problem might be given that much information.
ORA-03113: end-of-file on communication channel
Tony, July 31, 2003 - 2:39 am UTC
I'm running oracle8.1.6 on solaris5.8. When I execute a stored procedure from the server box itself, I get the following errors. Actually, I invoke a .sql script in which the procedure is called.
Script:
-------
spool t.txt
set severoutput on
set timing on
select to_char(sysdate,'hh24:mi:ss') from dual;
exec mis_pkg.updmis;
select to_char(sysdate,'hh24:mi:ss') from dual;
spool off
Error:
------
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR at line 1:
ORA-03114: not connected to ORACLE
Elapsed: 00:00:00.00
SP2-0042: unknown command "om dual" - rest of line ignored.
not spooling currently
ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
ORA-24323: value not allowed
ERROR:
ORA-03114: not connected to ORACLE
Please help me out to fix this problem.
July 31, 2003 - 7:11 am UTC
please contact support for something like this.
I use telnet to execute the procedure
Tony, July 31, 2003 - 2:43 am UTC
For the above question:
I use telnet to execute the procedure and get the above error
ORA -24323
Yogesh, July 31, 2003 - 1:34 pm UTC
I'm also getting same error
ORA-03113: end-of-file on communication channel
and further
ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-03114: not connected to ORACLE.
But in my case connection is not idle .. when ever I call one procedure using dblink .. its does this ...
procedure sign is
PROCEDURE UpdateTerminalRecord
(
p_Tid VARCHAR2,
p_FilledRecord Pkg_CommonUtilities.TableDefArray,
p_ErrorRecord OUT Pkg_CommonUtilities.ErrorDefArray,
p_StatusCode OUT NUMBER,
p_StatusMessage OUT VARCHAR2
)
where
TYPE FeatureDef IS RECORD
(
FeatureName VARCHAR2(50),
FeatureValue VARCHAR2(150)
);
TYPE TableDefArray IS TABLE OF FeatureDef;
TYPE ErrorDef IS RECORD
(
FeatureName VARCHAR2(50),
ErrorDesc VARCHAR2(1000)
);
TYPE ErrorDefArray IS TABLE OF ErrorDef;
Can it be due to passing these types on dblink ?
July 31, 2003 - 6:58 pm UTC
when it rains, it pours. this must be the 4th 3113 today I got - they come in spurts I guess.
3113 = "please contact support, please"
More info
Yogesh, July 31, 2003 - 2:40 pm UTC
To add more info to last query .. I don't have any firewall ... and there is one function which is returning long .. is this function causing prob?
MG, August 05, 2003 - 5:39 am UTC
Hi Tom,
When I try to startup the database, i get following error
SQL> startup mount
ORACLE instance started.
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
Then I start the service, then it is ok. Could you please tell what could be the reason.
Thanks
August 05, 2003 - 7:27 am UTC
i guess you need to start the service first....
no version
no os
no information
no background
by service I guess you mean windoze. on that os, you must have the background service running first -- before starting the database instance up.
MG, August 06, 2003 - 5:03 am UTC
Hi Tom,
I am sorry, I did't give you enough information.
My OS : Windows 2000
Version (DB) : Oracle9i Enterprise Edition Release 9.2.0.1.0
Yes I mean the Win service : OracleServiceSID
Steps:
- I started the Service
- I logged into the db as sysdba
- then I shutdown the database
- startup the database --> There I get the error
- I stop the win service 'OracleServiceSID', and restart again
- then come back to the database, it works fine.
Could you please tell me, did I missed some files or settings?
thanks
August 06, 2003 - 8:15 am UTC
don't know, don't use windows. never experienced that myself.
when forced to use windows, i use net start and net stop from the command line myself.
please contact support for assistance on this one.
connection problem
atul, April 14, 2004 - 5:54 am UTC
Hi,
While connecting to a databse using sqlplus and tnsnames.ora file
i'm getting error like
======================================================================
$ sqlplus sys/test@tgmieu12_022.world
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 14 09:40:26 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-03113: end-of-file on communication channel
====================================================
but when i connect without connect-string its going fine.
Even if i do "tnsping" its showing ok.
Also listener log shows connection is establish.
My oracle version is :8.0.5
Follwing are the entries of my tnsnames.ora,listener.ora,sqlnet.ora files.
Tnsnames.ora
tgmieu12_022.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = switch.world)
(PROTOCOL = TCP)
(Host = iade17a2-enf)
(Port = 5132)
)
)
(CONNECT_DATA = (SID = tgmieu12_022)
)
)
Listener.ora
SQLNET.AUTHENTICATION_SERVICES = None
USE_PLUG_AND_PLAY_listener_a = OFF
USE_CKPFILE_listener_a = OFF
listener_a =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = tgmieu12_022.world)
)
(ADDRESS =
(PROTOCOL =TCP )
(Host = iade17a2-enf)
(Port = 5130)
)
)
STARTUP_WAIT_TIME_listener_a = 0
CONNECT_TIMEOUT_listener_a = 60
LOG_DIRECTORY_listener_a = /peur/cre/orb0805/network/log/listener_a
TRACE_LEVEL_listener_a = OFF
SID_LIST_listener_a =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = tgmieu12_022.world)
(SID_NAME = tgmieu12_022)
(ORACLE_HOME = /peur/cre/orb0805)
(PRESPAWN_MAX = 10)
)
)
sqlnet.ora file
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 0
names.default_domain = world
name.default_zone = world
Kindly tell me whats the solution to resolve the issue.
Thanks & Regards,
ATUL
April 14, 2004 - 8:46 am UTC
when you use the tns connect string, you are connecting to an 8.0.5 database
when you do not, you are connecting to SOME OTHER database -- an 8i database (given that you are using an 8i client).
sooo, forget about that "without a connect string", it is meaningless -- different database alltogether.
look to see if a trace file is being created on the server (database server).
connection problem
atul, April 14, 2004 - 11:01 pm UTC
Hi,
I'm getting following dump file on the server while trying
to connect
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
sqlplus sys/test@tgmieu12_022.world
********** Internal heap ERROR 17112 addr=0x202ec358 *********
***** Dump of memory around addr 0x202ec358:
202EC140 5F4E4C53 5F4C5843
202EC160 49534F43 55525200 04000011 202EC148 103FF878 24000000 04000025 202EC168
202EC180 103FF878 41555448 5F4E4C53 5F4C5843 43555252 454E4359 00000000 04000015
202EC1A0 202EC178 103FF878 414D4552 49434100 04000025 202EC19C 103FF878 41555448
202EC1C0 5F4E4C53 5F4C5843 54455252 49544F52 59000000 04000015 202EC1B0 103FF878
202EC1E0 414D4552 4943414E 0400001D 202EC1D4 103FF878 41555448 5F4E4C53 5F4C584C
202EC200 414E0000 04000015 202EC1E8 103FF878 35333737 38000000 0400001D 202EC204
202EC220 103FF878 41555448 5F534552 49414C5F 4E554D00 04000011 202EC218 103FF878
202EC240 31340000 0400001D 202EC234 103FF878 41555448 5F534553 53494F4E 5F494400
202EC260 04000025 202EC244 103FF878 41555448 5F434150 4142494C 4954595F 5441424C
202EC280 45000000 04000011 202EC260 103FF878 30000000 04000021 202EC284 103FF878
202EC2A0 41555448 5F564552 53494F4E 5F535441 54555300 04000019 202EC294 103FF878
202EC2C0 31333432 33383732 31000000 0400001D 202EC2B4 103FF878 41555448 5F564552
202EC2E0 53494F4E 5F4E4F00 04000011 202EC2CC 103FF878 33000000 04000021 202EC2E8
202EC300 103FF878 41555448 5F584143 54494F4E 5F545241 49545300 04000011 202EC2F8
202EC320 103FF878 31320000 0400001D 202EC318 103FF878 41555448 5F564552 53494F4E
202EC340 5F53514C 04000019 202EC328 103FF878 2D205072 6F647563 74696F6E 04000021
202EC360 202EC344 103FF878 41555448 5F564552 53494F4E 5F535452 494E4700 04000071
202EC380 202EC35C 103FE8DC 00000060 011F0F05 0B0C030C 0C050405 0D060907 08050E05
202EC3A0 06050F02 ECEBED05 0A050505 05050823 43232308 11230811 41B02300 83000100
202EC3C0 01130000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
202EC3E0 00000000 00000000 00000000 140000C1 202EC37C 103FF6F0 0001010B 0D080A0E
202EC400 01090101 01000009 00000000 00000001 01010101 01010101 01010101 01010106
202EC420 01010101 01010101 01010101 01010101 01010001 01010101 01010201 0B000101
202EC440 01010001 01010101 01010101 01010101 0001010C 01011010 01080101 12120101
202EC460 1B010101 13131414 16161616 1A020001 02010101 02010101 01010101 01020101
202EC480 01020201 01020101 01010101 01020102 0E0E0E18 19010202 02020202 02020202
202EC4A0 02020201 0E020202 01020000 00000000 202E9430 00001030 00000000 00000000
202EC4C0 000000A2 00000000 00000000 2025CCA4 202E9150 00000013 74626F62 65753131
202EC4E0 5F303035 2E776F72 6C640000 00000000 202E9150 00000014 202EC4D8 00000000
202EC500 00000000 00000012 00000000 4553535F 202E9F80 000002A0 202ECBA0 00000150
202EC520 00000000 00000012 00000000 203D2073 00000000 00000000 00000000 00000000
202EC540 5F333232 2E776F72 6C640050 29202848 00000000 00000000
******************************************************
HEAP DUMP heap name="Alloc environm" desc=0x2025cc44
extent sz=0x1024 alt=32 het=32767 rec=0 flg=3 opc=2
parent=0 owner=0 nex=0 xsz=0x50b8
EXTENT 0
Chunk 202c29f0 sz= 20656 free " "
EXTENT 1
Chunk 202b5880 sz= 20540 free " "
Chunk 202ba8bc sz= 20 freeable assoc with mark prv=0 nxt=0
Chunk 202ba8d0 sz= 76 freeable assoc with mark prv=0 nxt=0
Chunk 202ba91c sz= 20 freeable assoc with mark prv=0 nxt=0
EXTENT 2
Chunk 202b2400 sz= 13420 free " "
EXTENT 3
Chunk 202a94a0 sz= 24 perm "perm " alo=24
Chunk 202a94b8 sz= 32 free " "
Chunk 202a94d8 sz= 300 freeable assoc with mark prv=0 nxt=0
Chunk 202a9604 sz= 352 freeable assoc with mark prv=0 nxt=0
Chunk 202a9764 sz= 276 freeable assoc with mark prv=0 nxt=0
Chunk 202a9878 sz= 564 freeable assoc with mark prv=0 nxt=0
Chunk 202a9aac sz= 1280 freeable assoc with mark prv=0 nxt=0
Chunk 202a9fac sz= 1280 freeable assoc with mark prv=0 nxt=0
Total heap size = 58840
FREE LISTS:
Bucket 0 size=272
Chunk 202a94b8 sz= 32 free " "
Bucket 1 size=528
Bucket 2 size=1040
Chunk 202b2400 sz= 13420 free " "
Chunk 202b5880 sz= 20540 free " "
Chunk 202c29f0 sz= 20656 free " "
Total free space = 54648
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Chunk 202a94a0 sz= 24 perm "perm " alo=24
Permanent space = 24
******************************************************
Hla: 0
kgepop: no error frame to pop to for error 0
Illegal instruction
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
Plz suggest
Thanks & Regards,
Atul
April 15, 2004 - 8:22 am UTC
support might be able to do something with that one. please file a tar.
Fixed my problem
Jim Farnsworth, August 24, 2005 - 12:18 pm UTC
You had the only suggestion that made any sense in my situation. I suspected a firewall timeout after 30 minutes. I set the SQLNET.EXPIRE_TIME=20 in SQLNET.ORA and --problem solved! I thank you and the entire sales department thanks you!
SQLNET.EXPIRE_TIME
nn, January 23, 2007 - 4:08 pm UTC
SQLNET.EXPIRE_TIME
Tom,
One of my customer has problem. They are login on sql*navigator.
SQLNET.EXPIRE_TIME =10 in the sqlnet.ora at client but in database server we dont have this parameter set.
Do you think If I set this parameter then it will help?
ORA-03114: not connected to ORACLE
default_sdu_size,
A reader, August 16, 2007 - 11:31 am UTC
What is DEFAULT_SDU_SIZE? When to use this?
I heard the values vary from 2KB to 32KB.
In what situation should be have higher value or a lower value or NOT use SDU at all?
Thanks,
August 20, 2007 - 10:09 pm UTC
don't touch it. It is fine out of the box.
If supports suggests to modify it, consider it then.
sqlnet.expire_time - unit of time
Yogesh, October 27, 2008 - 3:45 am UTC
What is the unit of time for sqlnet.expire_time setting ?
October 27, 2008 - 8:04 am UTC
Thanks
Yogesh, October 30, 2008 - 6:29 am UTC
Thanks, Tom.
I forgot to mention the Oracle version.
I hope it (the unit for expire_time) was the same for Oracle 8.1.7
October 30, 2008 - 8:40 am UTC
well, when you referenced the documentation.....
WHAT DID YOU SEE?
(hint, hint, big loud hint)
I just looked it up online at otn.oracle.com..... it took about 5 seconds to find it. But I cheat, because I have a direct link to the 8i (and 9iR1, 9iR2, 10gR1, 10gR2, 11gR1) documentation libraries so I can look stuff up really fast.
Yogesh, October 31, 2008 - 5:27 am UTC
I took several minutes to reach to the following link
http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/advcfg.htm#470329 (1) It does not show the unit of time ?!
(2) I think there should be 2 (two) parameters,
(2.1) At what frequency to check the connection
(2.2) After how much continues time (or how many checks) should it be broken / killed
What I understand from the doc is that "on the first instance of check, the connection may be broken" - I feel this is wriong; so, surely I am missing something.
(3) When does the parameter come into effect ? Soon after changing (& saving) the value ?
I have not done much in the field of DBA; so, please give me direct answer.
November 02, 2008 - 4:35 pm UTC
well, I went here:
http://docs.oracle.com/docs/cd/A87860_01/doc/index.htm the 8i networking stuff.
then went to
http://docs.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/index.htm the index of the net8 admin guide
and hit this
http://docs.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/params.htm#437583 which says:
Purpose:
Determines time interval to send a probe to verify the session is alive
See Also: Oracle Advanced Security Administrator's Guide
Default:
None
Minimum Value:
0
minutes Recommended Value:
10 minutes
Example:
sqlnet.expire_time=10
------------------------------------------------------------------------
let me address this:
.... I have not done much in the field of DBA; so, please give me direct answer. ...the best thing, by far, I could do is lead you almost to the answer, to the EDGE of the answer. To the side of the cliff, so that the answer is just below you - all you have to do is fall into it...
It seriously took seconds to find this again. Really. If you learn how to use the resources, you'll become a DBA
If you ask for someone to give you the answer, you'll be a middle man, forever. You'll never be a DBA, never. You'll be replaceable by a search engine, always.
(2) rethink your position. If after N minutes, it pings the connection and it is broken - it is broken, game over, you are done.
(3) parameter files are read once, upon starting. it would take a re-read of the parameter file.
Thanks
Yogesh, November 03, 2008 - 1:08 am UTC
(2) rethink your position. If after N minutes, it pings the connection and it is broken - it is broken, game over, you are done.
Still, not clear.
What I understand is after N minutes it pings "only once" and then breaks the connection, if not pingable.
OR Does it ping for few seconds ? OR few minutes ? OR few times ?
November 03, 2008 - 1:28 am UTC
if the connection does not *work*, if the client does not respond, the client is "gone"
the connected TCP/IP connection either
a) works
b) does not
Things like packet retries, dropped packets, sequencing - are all done at a lower level in TCP/IP - we use a connected socket. If you "ping" from the server to the client and get no response - the client is "dead", game over - there is no need to retry, it is gone.
ENABLE=broken
Kamal, May 15, 2012 - 11:45 am UTC