Connecting db using shell script by passing db credentials from shell

Question

Hi I am trying to connect my database using shell script and by passing the db credentials from shell. I am getting "ORA-12162: TNS:net service name is incorrectly specified". Please find the script below.

#!/bin/bash
DB_CREDENTIALS=$1

mkdir -p $PWD/logs

sqlplus -silent $DB_CREDENTIALS <<EOFSQL

set echo on
set timing on
set heading on
set feedback on
set linesize 5000
SET PAGESIZE 0
SET TRIMSPOOL ON


@teshscrpt.sql


EOFSQL

And the error is :

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


SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Can somebody help me out kindly.

Thanks, sudhir.

I am trying to call my script from shell like "bash-4.2$ dbcheck.sh" — Sudheer Inamana
– Sudheer Inamana, Commented Dec 23, 2014 at 12:18

Sylvain Leroux · Accepted Answer · 2014-12-23 12:22:46Z

1

First, you should take the habit of quoting your variables:

#!/bin/bash
DB_CREDENTIALS="$1"                         # HERE

mkdir -p "$PWD"/logs                        # HERE

sqlplus -silent "$DB_CREDENTIALS" <<EOFSQL  # HERE

Then:

I am trying to call my script from shell like bash-4.2$ dbcheck.sh

Obviously, your script take the connection parameters as first argument. you should invoke it like that:

bash-4.2$ dbcheck.sh username/[email protected]

answered Dec 23, 2014 at 12:22

Sylvain Leroux

52.3k8 gold badges114 silver badges136 bronze badges

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

1 Comment

Sudheer Inamana Over a year ago

Thanks alot Sylvalin Leroux.

podwysoc · Accepted Answer · 2014-12-23 12:22:34Z

0

You need to put correct credentials. Launch it like this:

dbcheck.sh username/password@database

Have you read the correct sqlplus syntax?

answered Dec 23, 2014 at 12:22

podwysoc

513 bronze badges

Collectives™ on Stack Overflow

Connecting db using shell script by passing db credentials from shell

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related