Toad World® Forums

Running script on another instance of RAC-database

Hi,

When connected to f.e. instance 1 of a RAC-database, is it possible to run a
sql-script against the other instance (2) of that database? And if yes, how?

Couldn’t find it in the docs and after googling around.

Thanx in advance.

Kind regard,

Dick Pluim

ATS NL Oracle

Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd
voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken wij
u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Aangezien de
integriteit van het bericht niet veilig gesteld is middels verzending via
internet, kan Atos Nederland B.V. niet aansprakelijk worden gehouden voor de
inhoud daarvan. Hoewel wij ons inspannen een virusvrij netwerk te hanteren,
geven wij geen enkele garantie dat dit bericht virusvrij is, noch aanvaarden wij
enige aansprakelijkheid voor de mogelijke aanwezigheid van een virus in dit
bericht. Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder
Atos Nederland B.V. goederen en/of diensten levert zijn met uitsluiting van alle
andere voorwaarden de Leveringsvoorwaarden van Atos Nederland B.V. van
toepassing. Deze worden u op aanvraag direct kosteloos toegezonden.

This e-mail and the documents attached are confidential and intended solely for
the addressee; it may also be privileged. If you receive this e-mail in error,
please notify the sender immediately and destroy it. As its integrity cannot be
secured on the Internet, the Atos Nederland B.V. group liability cannot be
triggered for the message content. Although the sender endeavours to maintain a
computer virus-free network, the sender does not warrant that this transmission
is virus-free and will not be liable for any damages resulting from any virus
transmitted. On all offers and agreements under which Atos Nederland B.V.
supplies goods and/or services of whatever nature, the Terms of Delivery from
Atos Nederland B.V. exclusively apply. The Terms of Delivery shall be promptly
submitted to you on your request.

Atos Nederland B.V. / Utrecht
KvK Utrecht 30132762

image002.gif

image002.gif

image003.gif
image001.gif

If you are selecting from v$ views and want to get instance specific
information, I think the easiest way to do that is to use the GV$ views instead,
and specify inst_id in the where clause of your queries.

To connect to a particular instance, the easiest way to do that is to add an
entry in your tnsnames file that will connect to the specific instance.

See below. The RAC entry will connect to either one, determined by Oracle. RAC1
will connect to the first instance only. RAC2 will connect to the 2nd instance
only.

RAC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.110)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.111)(PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC)))

RAC1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.110)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC) (INSTANCE_NAME =
RAC1)))

RAC2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.111)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC) (INSTANCE_NAME =
RAC2)))
image001.gif

If you are selecting from v$ views and want to get instance specific
information, I think the easiest way to do that is to use the GV$ views instead,
and specify inst_id in the where clause of your queries.

To connect to a particular instance, the easiest way to do that is to add an
entry in your tnsnames file that will connect to the specific instance.

See below. The RAC entry will connect to either one, determined by Oracle. RAC1
will connect to the first instance only. RAC2 will connect to the 2nd instance
only.

RAC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.110)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.111)(PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC)))

RAC1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.110)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC) (INSTANCE_NAME =
RAC1)))

RAC2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.111)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC) (INSTANCE_NAME =
RAC2)))
image003.gif

If you are selecting from v$ views and want to get instance specific
information, I think the easiest way to do that is to use the GV$ views instead,
and specify inst_id in the where clause of your queries.

To connect to a particular instance, the easiest way to do that is to add an
entry in your tnsnames file that will connect to the specific instance.

See below. The RAC entry will connect to either one, determined by Oracle. RAC1
will connect to the first instance only. RAC2 will connect to the 2nd instance
only.

RAC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.110)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.111)(PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC)))

RAC1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.110)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC) (INSTANCE_NAME =
RAC1)))

RAC2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.111)(PORT = 1521))

(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC) (INSTANCE_NAME =
RAC2)))
image002.gif

John,

Thanx.

Kind regards,

Dick Pluim

ATS NL Oracle


image001.gif

John,

Thanx.

Kind regards,

Dick Pluim

ATS NL Oracle


image003.gif

John,

Thanx.

Kind regards,

Dick Pluim

ATS NL Oracle


image002.gif