Two databases in one PHD

[Bert de Nooij]

Blue,

Your syntax is correc, we are doing similar things (on VMS)
Are the logicals VORA1 and VORA2 set correct?

Try substiting the logicals by the username and password to see if something's wrong with the logicals.


regards,


Bert


-----Oorspronkelijk bericht-----
Van:	Robert J.M. Edis [SMTP:robert.edis@creatcomp.com]
Verzonden:	woensdag 23 februari 2000 17:49
Aan:	'powerh-l@list.swau.edu'
Onderwerp:	Two databases in one PHD

G'day all

Environment: HP/UX 10.20, PH 7.33.D3, Oracle 7.3.4

I am trying to put two database contections in the same PHD.  Both RDBMS's
have the same structure, including table and columns names but a for
different organisations.

My environment variables ORACLE_SID, ORACLE_TERM, ORACLE_HOME and TNS_ADMIN
are set correctly.  The PATH points to .../oracle.7.3.4/bin etc.

My PHD declarations are:

Database DB1 type ORACLE open ORACLE@$VORA1@DB1/$VORA2 owner xxx
Database DB2 type ORACLE open ORACLE@$VORA1@DB2/$VORA2 owner xxx

The tnsnames.ora entries are:

DB1.world =
  (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS =
        (COMMUNITY = tcp.world)
        (PROTOCOL = TCP)
        (Host = 4.56.211.59)
        (Port = 1521)
      )
      (ADDRESS =
        (COMMUNITY = tcp.world)
        (PROTOCOL = TCP)
        (Host = 4.56.211.59)
        (Port = 1526)
      )
   )
     (CONNECT_DATA = (SID = DB1)
  ))
DB2.world =
  (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS =
        (COMMUNITY = tcp.world)
        (PROTOCOL = TCP)
        (Host = 4.56.211.59)
        (Port = 1521)
      )
      (ADDRESS =
        (COMMUNITY = tcp.world)
        (PROTOCOL = TCP)
        (Host = 4.56.211.59)
        (Port = 1526)
      )
   )
     (CONNECT_DATA = (SID = DB2)
  ))

Problem:

> acc table1 in db1
*W* SQL START DBE error (ORACLE@$VORA1@DB1/$VORA2)
DMS-E-GENERAL, A general exception has occurred during operation 'attach 
database'.
ORA-12154: TNS:could not resolve service name
*E* The file TABLE1 IN DB1 wasn't found in the data dictionary.
> acc table1 in db2
*W* SQL START DBE error (ORACLE@$VORA1@DB2/$VORA2)
DMS-E-GENERAL, A general exception has occurred during operation 'attach 
database'.
ORA-12154: TNS:could not resolve service name
*E* The file TABLE1 IN DB2 wasn't found in the data dictionary.
>

I looked at the knowledgebase at the Cognos support site and that is how I
derived the logic above (document: KB57519CS).  The document has some
typograhpical errors but I worked around those.

Anyone have an idea as to why this is not working?

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