2 Replies Latest reply: Apr 4, 2013 4:27 AM by Felix_GG RSS

    On which host am i ?

    Felix_GG
      Dear all,

      i have a simple Question i think:

      I connect to a Database, which uses Dataguard, with the following command:

      sqlplus 'user/password@(DESCRIPTION = (ADDRESS_LIST = (FAILOVER=ON)(LOAD_BALANCE=OFF)(ADDRESS =(PROTOCOL = TCP) (HOST = primaryhost) (PORT = 1521)) (ADDRESS =(PROTOCOL = TCP) (HOST = backuphost) (PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = PRODDB_PRIMARY.world)))'

      This works fine.

      My question now:
      After the successfull login, how can i see on which host i am ? On the primary or on the backuphost ?