I thought your DBCONNECT should be a tnsnames entry?

You should be able to do these commands by hand first, and then you will
probably get them to work within the script.

-----Original Message-----
From: Choudhry Deepak
[mailto:oracledba-ezmlmshield-x20055577.[Email address protected]
Sent: Thursday, May 05, 2005 8:55 AM
To: LazyDBA Discussion
Subject: Unix Shell Script

Hi Gurus ,

I am facing a problem

I don't know what am I doing wrong

Here is the Script


#!/usr/bin/ksh


#Get Databasename


DBCONNECT='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=C360-
DW-DBPRO
.CCE.CPQCORP.NET)(PORT=1521)))(CONNECT_DATA=(SID=DWPRO)))'
# Get db schema
DBSCHEMA=vouille
# Get schema password
#DBPASSWORD=pascal
DBPASSWORD=yhnji90


ORACLE_SID=DWPRO

#export ORACLE_HOME=/crm/oracle/$ORACLE_SID/817
#export ORACLE_HOME=/crm/oracle/STGDEV/817
export ORACLE_HOME=/crm/oracle/WWFDEV/817
export PATH=$ORACLE_HOME/bin:/usr/lib:$PATH:.
export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:$SHLIB_PATH:.

# Set NLS_LANG variable
export NLS_LANG=American_America.utf8
echo "NLS_LANG = $NLS_LANG"

# USRPWD used by unloadto and plsql
export USRPWD="$DBSCHEMA/$[Email Address Removed] "USRPWD = $USRPWD"

#DATE=`date +%Y%m%d`
#for i in AT BE CZ DK FI FR GE GR HU IL IT NE NO PL PT SA SP SW SZ TR UK

#do
#echo $i
#sed "s/country/$i/g" country_age.sql > country_age_tmp.sql
/crm/oracle/WWFDEV/817/bin/sqlplus $USRPWD
@/home/cdeepak/perlsrc/Norway.sql

#done



The problem is happening while connecting to oracle and executiog the
script Norway.sql(Bold and Marked In Red)


Please help me solving the Problem .


Thanks in Advance

Deepak Choudhary



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page