Finally managed to fix my problem. Thanks to Charlie Mengler, Christian
Trassens, Djordje, Riyaj Shamsudeen, Ross Mohan, Terry Ball and Trivedi
Hitarth who gave me many points to check (SQL*net config,
$ORACLE_HOME/rdbms/audit space and protection, TWO Task etc etc).
It turns out that the problem was caused because I had somehow incorrectly
specified the unix group at installation... of course in my post I
specifically stated that this could not be the cause because I know how to
install oracle!... never assume anything...
As can be seen from the config.s file, something got messed up during
install on 8.1.6...
$ diff /Volumes/app/oracle/product/8.1.6/rdbms/lib/config.s
/Volumes/app/oracle/product/8.1.7/rdbms/lib/config.s
23c23
< /* 0x0008 15 */ .ascii "%s_dbaGroup%\0"
---
> /* 0x0008 15 */ .ascii "dba\0"
28c28
< /* 0x0014 22 */ .ascii "%s_operGroup%\0"
---
> /* 0x0014 22 */ .ascii "dba\0"
I changed it to the same as 8.1.7 and relinked...
dba816 $ cd $ORACLE_HOME/rdbms/lib
dba816 $ make -f ins_rdbms.mk ioracle
- Linking Oracle
rm -f /Volumes/app/oracle/product/8.1.6/rdbms/lib/oracle
ld -o /Volumes/app/oracle/product/8.1.6/rdbms/lib/oracle
-L/Volumes/app/oracle/product/8.1.6/rdbms/lib/ -L/Volumes/app/oracle/produ
mv -f /Volumes/app/oracle/product/8.1.6/bin/oracle
/Volumes/app/oracle/product/8.1.6/bin/oracleO
mv /Volumes/app/oracle/product/8.1.6/rdbms/lib/oracle
/Volumes/app/oracle/product/8.1.6/bin/oracle
chmod 6751 /Volumes/app/oracle/product/8.1.6/bin/oracle
All seems to be working perfectly now. Two really good metalink docs on the
subject...
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=69642.1
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=1012572.6
Thanks again for all the help.
Ken
_________________________________________
Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346
Email: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fowler, Kenneth R
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
