Re: configure listener.ora and tnsnames.ora

From: ekonic2 <ekonic2_at_yahoo.com>
Date: Fri, 7 Aug 2009 05:27:46 -0700 (PDT)
Message-ID: <e3203c58-5c6c-4515-95e0-16e5b24f93d0_at_q14g2000vbi.googlegroups.com>

On Aug 5, 9: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?

When my company needed part-time/backup DBA we used www.zibase.com, these folks are former Oracle Corp consultants. Received on Fri Aug 07 2009 - 07:27:46 CDT