quiz error accessing db on different server

[Ibarra-Hansen Kjeld]

HI

We had the same problem on AIX. 
Upgrade to PH823.d7 and use ORACLE 8 client to access the databases. 
After doing this we have no problem anymore.
Remember, that you have to declare both databases in the tnsnames.ora.
Best, 

__________________________________
Kjeld Ibarra-Hansen

WM-data eApplications
Lautrupvang 10
2750  Ballerup
DK-Denmark
Tel.: (+45) 4478 4000, direkte: (+45) 4483 8405, mobil (+45) 21 71 72 27
Fax: (+45) 4468 5263 / (+45) 4483 8485
mailto:kjian@wmdata.com
http://www.wmdata.dk



-----Original Message-----
From: Leslie Tsukamoto [mailto:leslie.tsukamoto@cae.com]
Sent: 3. august 2002 23:07
To: 'powerh-l@lists.swau.edu'
Subject: quiz error accessing db on different server


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


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.