Shell script to connect to database on solaris server

Question

var=$(sqlplus -s username/pwd$@SID <<EOF
set heading on
set trimspool off
set linesize 200
set feedback off
SET MARKUP HTML ON
spool output.htmL
SELECT * FROM V$SESSION where username='FSUSER' and PROGRAM='SQL Developer' and OSUSER  NOT IN ('username');
spool off;
exit;
EOF)
echo "$var" > output.txt
exit 0

but the output files shows as ORA error , manual connect is working without any issues from same server .

ERROR: ORA-12162: TNS:net service name is incorrectly specified

SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]] where ::= [/][@<connect_identifier>] ::= [][/][@<connect_identifier>]

Any help here is appreciated

Walter A · Accepted Answer · 2021-03-24 10:44:50Z

2

With a here-document (the construction <<EOF ... EOF) the end-tag should be the only characters on the line. Therefor replace

EOF)

with

EOF
)

Your code has another problem: The $ in V$SESSION is evaluated/parsed, resulting in errors. Parsing can be avoided with a backslash V\$SESSION or by putting quotes around your start-tag EOF:

var=$(sqlplus -S /nolog << 'EOF'
....
EOF
)

answered Mar 24, 2021 at 10:44

Walter A

20.2k2 gold badges29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Shell script to connect to database on solaris server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related