Re: ORA-12154 without SQL*NET

Oliver Belikan <ob_at_online.neurotec.de> wrote in article <01bc0dbb$a25ed2a0$7d64a8c0_at_OliverB.intern.online.neurotec.de>...
> I don´t use SQL*NET or TNS. Just connect to an database with the Server
> Manager. I read, that i have to input the name of the database into the
> field "Servicename", but ORA-12154 occur.
> The file "tnsnames.ora" isn´t existend on the machine.
>
> > I attempt to login with Server Manager an become an Error:
> >
> > ORA-12154 TNS:could not resolve service name
> >
> > Whats wrong, how can i solve the problem ?
> >
> >
> >
> >
>

   You need to configure next files:

1. Server - computer with SQL*Net Listener (and a ORACLE server as well) File /etc/listener.ora
2. Client - any computer that wants to connect to ORACLE server via SQL*Net. File /oracle/network/admin/tnsnames.ora Full path to both files can be different.