Two databases in one PHD

[Robert J.M. Edis]

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.