-none-

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

-none-

-none-

2004-06-13 - By -not available-

Reply: << 101 102 103 104 105 106 107 108 109 110 >>

is responsibility of each type of thread, at the moment.
c) In addition there is garbage collector process.
There is many information in the Web regarding this type of process.
For example
http://java.sun.com/docs/hotspot/gc1.4.2
http://java.sun.com/docs/hotspot/gc1.4.2/faq.html
http://www.cons.org/cmucl/doc/gc-tuning.html
etc.
-verbose:gc parameter usage is helpful in diagnostic process.

II. The TOP parameters you need to look on is:
a)
File $OH/opmn/conf/opmn.xml
numProcs=3D "1 "
<java-option value=3D "-Xms1024M -Xmx1024M "/ >
<log-file path=3D "$OH//opmn/logs/ipm.log " level=3D "3 "/ >
<log-file path=3D "$OH/opmn/logs/ons.log " level=3D "3 "/ >
b)
File $OH/j2ee/ <component name >/config/server.xml
<global-thread-pool min=3D "100 " max=3D "200 " queue=3D "120 " keepAlive=3D "6000=
00 "=20
cx-min=3D "100 " cx-max=3D "200 " cx-que ue=3D "120 " cx-keepAlive=3D "600000 "=20
debug=3D "true " / >
taskmanager-granularity=3D "9000000 "
transaction-config timeout=3D "500000 "
c)
File $OH/j2ee/ <component name >/config/oc4j.properties
If you use BC4J.
jbo.pers.max.active.nodes=3D1000
jbo.pers.max.rows.per.node=3D1000
jbo.doconnectionpooling=3Dtrue
jbo.initpoolsize=3D1
jbo.maxpoolsize=3D550
jbo.poolminavailablesize=3D0
jbo.poolmaxavailablesize=3D600
jbo.poolmonitorsleepinterval=3D600000
jbo.poolmaxinactiveage=3D600000
jbo.ampool.initpoolsize=3D1
jbo.ampool.maxpoolsize=3D550
jbo.ampool.minavailablesize=3D0
jbo.ampool.maxavailablesize=3D100
jbo.ampool.monitorsleepinterval=3D600000
jbo.ampool.maxinactiveage=3D600000

Hope this information will help you.
--=_alternative 005E7C4FC2256EB2_=
Content-Type: text/html; charset= "windows-1257 "
Content-Transfer-Encoding: quoted-printable

 OC4J Process Architecture 
 
 1 year ago, management of the company
I am working for decided to switch all development projects to J2EE archite=
cture
(OC4J). 
 
 Within the year, we have running in
many technical problems connected to OC4J (stability hanging, java deadlock=
s,
performance problems etc). We have logged many (~10) long (100KB of text,
2-4 mount) TARs to Oracle support. Generally there no many help from Oracle
side. I have filling there no strong competence from Oracle analyst=92s
side ;( 
 
 We have learned a lot about OC4J arc=
hitecture,
parameters etc. during this time (see information below). But at the moment
I still have filling that we are working in the dark, using black box metho=
d. 
 
 I will try to explain that I mean, by
comparing Oracle Database & Oracle OC4J. 
 There excellent documentation regard=
ing
Oracle Database architecture (Oracle Concepts). There is good description
about each Database process PMON, SMON, etc, there is one process per conne=
ction
(in dedicated configuration), there is many diagnostic possibilities etc.
If I have performance issue with Oracle Database, first of all I will take
a look on TOP CPU consumers from OS respective, then I=92ll go forward to
Oracle statistics or switching 10046 event etc. 
 
 As opposite, take a look on OC4J. Th=
ere
is no any information like mentioned above regarding OC4J, not in Oracle
documentation, not in the Web ;(. There is just one process, which represent
OC4J from OS. If there is performance issue with OC4J, we can=92t say a
lot regarding which process/activity/piece of code takes CPU etc. 
 
 My question is: 
 - Do you know any good information s=
ource
about OC4J architecture; there will be described internals (processes,
communications flows etc); 
 - Do you know good courses regarding
this theme? 
 - Information about any related book
is welcomed? 
 - Can you share you experience worki=
ng
on OC4J problems? 
 
 Thank you in advance, 
 Jurijs 
 
 
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 
 I would like to share information th=
at
we have regarding OC4J architecture (see below). 
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 
 
 I. 
 Processes/Threads 
 As I mentioned above OC4J from OS lo=
oks
like one process, which consume HW resources. OC4J use threads architecture
for endow concurrency. You can see threads dump in the Java output (in
$OH opmn/logs/<component name>.default=5Fisland.1 log file by
default) by running 
 a) 
 kill =963 <oc4j pid> 
 command (this is any java process be=
havior,
I believe). 
 From dump we can see main threads li=
st,
as well as information about java deadlocks if any. 
 b) Below is thread types list you can
see in the java output by running kill =963 command: 
 =3D=3D=3D 
 AJPConnectionListener [0.0.0.0/0.0.0=
.0:3001] 
 ApplicationServerThread-0 
 Finalizer 
 JMSServer 
 OC4JMonitorThread 
 Reference Handler 
 RMIServer [0.0.0.0/0.0.0.0:3101] cou=
nt:2 
 Signal Dispatcher 
 Suspend Checker Thread 
 TaskManager 
 Thread 
 VM Periodic Task Thread 
 VM Thread 
 =3D=3D=3D 
 Unfortunately I don=92t have informa=
tion
about algorithms of work and what is responsibility of each type of thread,
at the moment. 
 c) In addition there is garbage coll=
ector
process. 
 There is many information in the Web
regarding this type of process. 
 For example 
 http://java.sun.com/docs/hotspot/gc1=
.4.2 
 http://java.sun.com/docs/hotspot/gc1=
.4.2/faq.html 
 http://www.cons.org/cmucl/doc/gc-tun=
ing.html 
 etc. 
 -verbose:gc parameter usage is helpf=
ul
in diagnostic process. 
 
 II. The TOP parameters you need to l=
ook
on is: 
 a) 
 File $OH/opmn/conf/opmn.xml 
 numProcs=3D"1" 
 <java-option value=3D"-Xms10=
24M
-Xmx1024M "/> 
 <log-file path=3D"$OH//opmn/=
logs/ipm.log"
level=3D"3"/> 
 <log-file path=3D"$OH/opmn/l=
ogs/ons.log"
level=3D"3"/> 
 b) 
 File $OH/j2ee/<component name>=
/config/server.xml 
 <global-thread-pool min=3D"1=
00"
max=3D"200" queue=3D"120" keepAlive=3D"600000"
cx-min=3D"100" cx-max=3D"200" cx-que ue=3D"120&quo=
t;
cx-keepAlive=3D"600000" debug=3D"true" /> 
 taskmanager-granularity=3D"9000=
000" 
 transaction-config timeout=3D"5=
00000" 
 c) 
 File $OH/j2ee/<component name>=
/config/oc4j.properties 
 If you use BC4J. 
 jbo.pers.max.active.nodes=3D1000 </fo=
nt >
 jbo.pers.max.rows.per.node=3D1000 </f=
ont >
 jbo.doconnectionpooling=3Dtrue 
 jbo.initpoolsize=3D1 
 jbo.maxpoolsize=3D550 
 jbo.poolminavailablesize=3D0 
 jbo.poolmaxavailablesize=3D600 
 jbo.poolmonitorsleepinterval=3D60000=
0 
 jbo.poolmaxinactiveage=3D600000 </fon=
t >
 jbo.ampool.initpoolsize=3D1 
 jbo.ampool.maxpoolsize=3D550 
 jbo.ampool.minavailablesize=3D0 </fon=
t >
 jbo.ampool.maxavailablesize=3D100 </f=
ont >
 jbo.ampool.monitorsleepinterval=3D60=
0000 
 jbo.ampool.maxinactiveage=3D600000 </=
font >
 
 Hope this information will help you.=

--=_alternative 005E7C4FC2256EB2_=--
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --