Re: configure listener.ora and tnsnames.ora

From: ddf <oratune_at_msn.com>
Date: Wed, 5 Aug 2009 06:49:43 -0700 (PDT)
Message-ID: <bdf0e1b4-9237-4b69-b87b-4c417250dd11_at_a13g2000yqc.googlegroups.com>

On Aug 5, 8:45 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> hy, my system have a Database Oracle on a server Linux distro Suse
> with Oracle Entarprise Manager 10g
>
> I'm doing a little programm in Visual c++ that do a query on the
> database from an other pc with windows in a network with the linux pc.
>
> But i have a problem with the connection to the Db, infact when i open
> the database i have this error on oracle Db:
>
> ORA-12505: TNS:listner does not currently know of SID given in connect
> descriptor (DBD ERROR: OCI ServerAttach)
>
> and my software connect to database only sometimes.....
>
> so i think that my file listener and tnsname are wrong...
>
> the listener.ora is empty, end the tnsname.ora is:
>
> # tnsnames.ora Network Configuration File: /opt/oracle/product/10.2/
> db_1/network/admin/tnsnames.ora
> # Generated by Oracle configuration tools.
>
> AFTIDI =
>   (DESCRIPTION =
>     (ADDRESS = (PROTOCOL = TCP)(HOST = linux-gle.Id)(PORT = 1521))
>     (CONNECT_DATA =
>       (SERVER = DEDICATED)
>       (SERVICE_NAME = AFTIDI)
>     )
>   )
>
> EXTPROC_CONNECTION_DATA =
>   (DESCRIPTION =
>     (ADDRESS_LIST =
>       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
>     )
>     (CONNECT_DATA =
>       (SID = AFTIDI)
>       (PRESENTATION = RO)
>     )
>   )
>
> can you help me?

From a command prompt what does the command

lsnrctl status

display?

David Fitzjarrell Received on Wed Aug 05 2009 - 08:49:43 CDT