AskDBA.org Forum » Topic: Executing SQL from Shell Script

AskDBA.org Forum » Topic: Executing SQL from Shell Script http://www.forum.askdba.org/ AskDBA.org Forum » Topic: Executing SQL from Shell Script en Fri, 30 Jul 2010 08:54:21 +0000 deepika.dhamija@gmail.com on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-114 Thu, 24 Dec 2009 10:50:40 +0000 deepika.dhamija@gmail.com 114@http://www.forum.askdba.org/ Thanks Amit. I was able to execute the SQL using the command sqlplus <username>/<password>@<orcl_sid> Amit Bansal on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-113 Thu, 24 Dec 2009 06:59:48 +0000 Amit Bansal 113@http://www.forum.askdba.org/ Deepika, Please find response below 1) Your first script has mistake. Should be like export ORACLE_SID=+ASM1 sqlplus / as sysdba <<EOF select name, path from v$asm_disk; exit EOF 2) node_list=<code>olsnodes</code> node1=<code>echo $node_list|awk '{print $1}'</code> node2=<code>echo $node_list|awk '{print $2}'</code> echo "Node 1 is " $node1 echo "Node 2 is " $node2 Hope this helps deepika.dhamija@gmail.com on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-112 Wed, 23 Dec 2009 07:25:14 +0000 deepika.dhamija@gmail.com 112@http://www.forum.askdba.org/ Hi, I have a two node RAC Cluster Setup (10R2) and I want to execute sql queries from a shell script, to be run as root. I have the foll test.sh script #! /bin/bash echo "In BASH" sqlplus / <<+ENDOFSQL+ select name, path from v$asm_disk; exit +ENDOFSQL+ echo "Back to Bash" exit and I get the foll O/P In BASH SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 23 07:25:32 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12546: TNS:permission denied Enter user-name: SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / Enter user-name: Enter password: ERROR: ORA-12546: TNS:permission denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus Back to Bash What permissions should for this? 2) Also I need to know the node names of the nodes that form the clustre. I add the foll lines to my script NODE_NAMES=<code>olsnodes</code> echo $NODE_NAMES ad I get O/P linux-1 linux-2 Is it possible to store these space separated node names in diff variables that can then be used. (the number of nodes are variable) Any suggestion/advise is appreciated. Thanks