DBAComp 1.1 and Oracle9i (version 9.0)

(all of these problems are solved in Oracle version 9.2)

Using DBAComp version 1.1 in an Oracle9i-only environment should not cause any problems. That is you can take the DBAComp source code, compile it in an Oracle9i environment and connect to an Oracle9i database. I have done this and it works.

You will however get problems when you try to work across Oracle versions with Oracle9i being involved. So if for example you compile DBAComp in an Oracle9i environment and try to connect to an Oracle8i database. The other way around is also causing problems. These problems are all caused by known bugs in the Oracle software. These bugs are platform independant.

The following matrix summarizes this situation:

 

connect to 7.3

connect to 8.0

connect to 8i

connect to 9i

compiled with 8.0

OK

OK

OK

OK

compiled with 8i (up to 8.1.7.2)

OK

OK

OK

ISSUE 1

compiled with 8i (8.1.7.3)

OK

OK

OK

ISSUE 2

compiled with 9i

OK

ISSUE 3

ISSUE 3

OK

 

ISSUE 1

Description: 

When you compile DBAComp using an Oracle8i environment (up to 8.1.7.2) and try to connect to an Oracle9i database you will get a coredump and the following output in your window:

********** Internal heap ERROR 17177 addr=0x0 *********
******************************************************
HEAP DUMP heap name="Alloc statemen" desc=0x692cac
extent sz=0x1024 alt=32767 het=32767 rec=0 flg=2 opc=2
parent=682134 owner=0 nex=0 xsz=0xaf4
EXTENT 0
Chunk 69a6ac sz= 1416 perm "perm " alo=16
Chunk 69ac34 sz= 1236 free " "
Chunk 69b108 sz= 88 freeable assoc with mark prv=0 nxt=0
Chunk 69b160 sz= 56 freeable assoc with mark prv=0 nxt=0
Total heap size = 2796
FREE LISTS:
Bucket 0 size=272
Bucket 1 size=528
Bucket 2 size=1040
Chunk 69ac34 sz= 1236 free " "
Total free space = 1236
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Chunk 69a6ac sz= 1416 perm "perm " alo=16
Permanent space = 1416
******************************************************
Hla: 0
**** Recursive heap error: 17113 addr=0x0, ds=0
Bus Error (core dumped)

 

Oracle Bug No:

2018989

 

Solution/Workaround:

1) Recompile oraconnect using the following Pro*C precompiler option: prefetch=0.

Go to the proc directory and edit the Makefile. Look for a line starting with 'PROCPPFLAGS' (should be line 33) and change it to the following:

PROCPPFLAGS= code=cpp prefetch=0 $(CCPSYSINCLUDE)

Now recompile dbacomp.

2) Upgrade oracle environment to 8.1.7.3. I tried this but it brings you to ISSUE2.

3) Upgrade oracle environment to 8.1.7.4 (when available).

 

 

 

ISSUE 2

Description:

When you compile DBAComp using an Oracle8i 8.1.7.3 environment and connect to an Oracle9i database you will get a coredump when you try to access certain screens of DBAComp (e.g. the Users screen). Other screens work. You may also get ORA-24371 instead of a crash.

 

Oracle Bug No:

2241608

 

Solution/Workaround:

1) Same as for ISSUE1:

Recompile oraconnect using the following Pro*C precompiler option: prefetch=0.

Go to the proc directory and edit the Makefile. Look for a line starting with 'PROCPPFLAGS' (should be line 33) and change it to the following:

PROCPPFLAGS= code=cpp prefetch=0 $(CCPSYSINCLUDE)

Now recompile dbacomp.

2) Upgrade oracle environment to 8.1.7.4 (when available).

 

 

 

ISSUE 3

Description:

When you compile DBAComp in a 9i environment and try to connect to an Oracle8 or Oracle8i database you get an ORA-24374.

 

Oracle Bug No:

2023714

 

Solution/Workaround:

No solution or workaround for the moment. According to Oracle a specific fix will be developed for 9.0.1.3.