Prev: One question about ORION test
Next: duplicate database by using RMAN
From: bill_j_chen on 29 Apr 2010 12:16
A question regarding the RAC node.

When using TOAD connecting to the oracle 10g RAC, in the windows
titile bar, it shows which node the user is connecting to.

When I use sqlplus (same account used for TOAD), I am trying to get
the same info - which node I am connected to. But the account used
doesn't have permission to query the gv$ or v$ views.

Here are the questions -

1) Do I have a way to know inside sqlplus which node I am talking to ?
2) How TOAD know what node the account is connect to? Apparently TOAD
is not using the gv$ or v$ as the account doesn't have access to these
views. It must use something else.

Thanks.
From: Steve Howard on 29 Apr 2010 13:12
On Apr 29, 12:16 pm, "bill_j_c...(a)yahoo.com" <bill_j_c...(a)yahoo.com>
wrote:
> A question regarding the RAC node.
>
> When using TOAD connecting to the oracle 10g RAC, in the windows
> titile bar, it shows which node the user is connecting to.
>
> When I use sqlplus (same account used for TOAD), I am trying to get
> the same info - which node I am connected to.  But the account used
> doesn't have permission to query the gv$ or v$ views.
>
> Here are the questions -
>
> 1) Do I have a way to know inside sqlplus which node I am talking to ?
> 2) How TOAD know what node the account is connect to? Apparently TOAD
> is not using the gv$ or v$ as the account doesn't have access to these
> views. It must use something else.
>
> Thanks.

select sys_context('userenv','instance') from dual;
 | 
Pages: 1
Prev: One question about ORION test
Next: duplicate database by using RMAN