Re: starting up a rac node via sqlplus?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sat, 30 May 2009 05:43:57 -0700 (PDT)
Message-ID: <41fa78f3-5d7c-46c7-aa62-cf49a1f799b3_at_y9g2000yqg.googlegroups.com>

On May 30, 3:22 am, m..._at_pixar.com wrote:
> oops, accidentally posted this to .misc...
>
> In sqlplus you can shutdown a node in a rac cluster via
>
>     connect sys_at_node3
>     shutdown immediate
>
> Is there a way to start up a node as well?
>
> I am scripting some regression tests related to node failover
> and it would be great if I did not have to script ssh'ing into
> the server but could keep everything at the sqlplus level.
>
> TIA!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios

We normally start our instances by logging onto the node in question as Oracle and then running a script that just sets the Oracle environment for the target database and invokes sqlplus with the startup command:

. set_ora_environ dbname
sqlplus /nolog <<EOF
connect / as sysdba
startup
_at_scripts_to_run_on_startup
exit
EOF If a password file is set up then you can get a sysdba connection remotely and just issue the startup command. We do not allow remote sysdba, but lots of sites do.

HTH -- Mark D Powell -- Received on Sat May 30 2009 - 07:43:57 CDT