DBMS_METADATA in 10.2

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

DBMS_METADATA in 10.2

DBMS_METADATA in 10.2

2005-08-01 - By Mladen Gogala

Reply: 1 2 3 4

DBMS_METADATA in 10.2 returns interesting results in alert log. Metalink, of
course, doesn't
even list 10.2 among the versions with patches, which probably means that 10.2
is bug-free.
I cannot open a TAR as the company that I work for doesn't have any 10.2
databases and I doubt
that my boss would be thrilled by my opening a TAR for my home database. How do
I tell oracle
that they have a problem with 10.2?

Mon Aug 1 18:11:33 2005
Errors in file /oracle/product/10g/admin/10G/bdump/10g_s000_3981.trc:
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [1234], [], [], [], [], [], [], []
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [729], [69008], [space leak], [], []
, [], [], []

Here is the detail from the trace file:

INSTANTIATION OBJECT: object=0x28bbe458
type=""[92] lock=(nil) handle=(nil) spec=0x2ff38a1c level=-923109122
flags=SHR/BDY/NBD/CGA/[28bb] executions=1
sqltxt(0x324cb56c)=select dbms_metadata.get_ddl('TABLESPACE',tablespace_name)
SQL
from dba_tablespaces
where tablespace_name !='SYSTEM'
and tablespace_name like upper(:PATT)
order by contents,tablespace_name
hash=60a071a8c83b5d57d3d3734caaf854a6
parent=0x2ff9b7fc maxchild=01 plk=0x3071fb58 ppn=n
cursor instantiation=0x28bbe458
child#0(0x32609778) pcs=0x2ff9ba00
clk=0x30784a7c ci=0x2ff38a1c pn=0x307bf110 ctx=0x2fbbba90
kgsccflg=0 llk[0x28bbe45c,0x28bbe45c] idx=0
xscflg=c0110476 fl2=5200009 fl3=52222008 fl4=0
Frames pfr 0x28bba578 siz=7100 efr 0x28bba5c0 siz=6724
kxscphp 0x28bc39f8 siz=1000 inu=976 nps=668
kxscdfhp 0x28bc3e18 siz=1000 inu=56 nps=0
kxscehp 0x28bc3974 siz=1000 inu=116 nps=44
kxscwhp 0x28bc3b00 siz=12220 inu=10024 nps=400

--
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l