TNS:listener could not resolve SERVICE_NAME given in connect descriptor

From: Eric <chaeri01_at_borabora.crchul.ulaval.ca>
Date: Fri, 31 Aug 2001 16:10:56 GMT
Message-ID: <3B8FB6D2.3CA3C324@borabora.crchul.ulaval.ca>

When i try to run dbora (script) to start the Oracle database(murin) i received this message

SQL> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

Help will be appreciated !!!

Thank's in advence !!!

Here is my script :
#!/bin/sh

# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to excute dbstart and dbshut;
# 
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORA_HOME=/u01/app/oracle/product/9.0.1
ORA_OWNER=oracle

if [! -f $ORA_HOME/bin/dbstart]
then

        echo "Oracle startup: cannot start"
        exit

fi

case "$1" in

        'start')

# Start the Oracle database:
# The following command assumes that the Oracle login
# will not prompt the user for any value

        su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
        ;;

        'stop')


                # Stop the Oracle database:

                # The following command assumes that the oracle login

                # will not prompt the user for any values


        su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
        ;;

esac

-- 
****************************************************
Eric Chamberland
Ingenieur de systemes
Centre de recherche du CHUL
2705 Blv laurier
Ste-Foy,Que
G1V 4G2
courriel: chamby_at_borabora.crchul.ulaval.ca
tel: (418) 656-4141 ext 6331
Fax: (418) 654-2761

Received on Fri Aug 31 2001 - 11:10:56 CDT