quiz error accessing db on different server

[Leslie Tsukamoto]

Currently I have been supporting our quiz environment on an hp9000 unix box
and an oracle 7.3.4 version database.  The database has up until now resided
on the same box as the local powerhouse quiz install and dictionary.  We are
faced with a requirement in moving that oracle database to a seperate Sun
server.  We have successfully ported the database and I have made sure that
the appropriate networking configurations have been accomplished as I can
successfully:

#1 - ping the remote server
#2 - I can access the remote server and database with sqlplus

On the new server I have renamed the database instance and I have now gone
into my dictionary definition file and added an entry for the new remote
test database:

this is the code for the two databases we are using:

database schdb & 
        type Oracle & 
        open ORACLE & 
        userid "sched1" password "xanadu" owner SCHED1

database sunschdb & 
        type Oracle & 
        open ORACLE & 
        userid "sched1@simup01" password "sunxanadu" owner SCHED1


when I recreate my dictionary with the new second database definition file I
receive no errors and everything loads fine.  However, when I then go into
quiz and attempt access a table within the new database I receive the
following error:

> access s_staff_mst in sunschdb
*E* The file S_CLS_CLIENT wasn't found in the data dictionary.
> access s_staff_mst in sunschdb
*W* SQL START DBE error (ORACLE@sched1@simup01/tstaboo)
DMS-E-GENERAL, A general exception has occurred during operation 'attach 
database'.
ORA-03106: fatal two-task communication protocol error
*E* The file S_STAFF_MST IN SUNSCHDB wasn't found in the data dictionary.
> 

Additionally, when I go into qshow and attempt to show the database this is
the error that I get as well:



 ?
1902/08/03                   /$DICT_TOP/DICTS                     Page   22
                           F I L E   R E P O R T
                    For DICTIONARY:  /u01/devdict/DICTS
    Database:           SUNSCHDB
    Organization:       RELATIONAL
    Null Values Allowed:No
    Type:               ORACLE
    Open:               ORACLE
    Owner:              SCHED1
    Userid:             sched1@simup01
*W* SQL START DBE error (ORACLE@sched1@simup01/tstaboo)
DMS-E-GENERAL, A general exception has occurred during operation 'attach 
database'.
ORA-03106: fatal two-task communication protocol error
    Records & Sizes:    ** none **



Any ideas what I may be missing??


Leslie J. Tsukamoto
Manager of Programming
CAE - SimuFlite Training International
Email: ltsukamoto@simuflite.com
Office Phone: (407)445-0226
Voice Mail: (972)456-8316
Fax: (407)295-9493