Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect

Jane Wang via OracleMonster.com wrote:
> The service_name in init.ora file is set to devtest.
>
> Thanks for giving me the helpful link. I did do some research by
myself before posting the message.
>
> --
> Message posted via http://www.oraclemonster.com

If you log onto the db server and then connect locally as sysdba can you show us the service name (I expect that it will have a domain appended)

eg I'm after the output of

set ORACLE_SID=DEVTEST
sqlplus /nolog
connect / as sysdba
show parameter service
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Mon Jan 10 2005 - 10:33:08 CST