Date: Tue, 13 Mar 2007 10:55:26 +0200 From: "Dan Cojocar" <dan.cojocar@gmail.com> To: "Max Khon" <fjoe@samodelkin.net> Cc: freebsd-database@freebsd.org Subject: Re: oracle8-client Message-ID: <b37cb0970703130155p6ea0d29al47de63bc3c1b77e6@mail.gmail.com> In-Reply-To: <20070313085009.GA7829@samodelkin.net> References: <b37cb0970703121031w4830510du367c6ef950122ae3@mail.gmail.com> <20070313085009.GA7829@samodelkin.net>
index | next in thread | previous in thread | raw e-mail
On 3/13/07, Max Khon <fjoe@samodelkin.net> wrote:
> Hi!
>
> On Mon, Mar 12, 2007 at 07:31:35PM +0200, Dan Cojocar wrote:
>
> > I have tried oci02 on -current, 6.2-stable and 6.1-stable and I
> > receive the same error:
> >
> > ./oci02 1
> >
> > Number of tables is 1
> >
> > -- ORACLE error
> > ORA-12545: Connect failed because target host or object does not exist
> >
> > I have attached the sqlnet.log file.
> > How can I debug this problem?
>
> Do you connect via tcp/ip? Only tcp/ip protocol works at the moment.
> Please show your tnsnames.ora.
>
> /fjoe
Hello Max,
Here is my tnsnames.ora file:
SERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SERVER)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = SERVER)
(PRESENTATION = http://admin)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
192.168.100.1 is a host from my network where I have installed oracle
express 10.
I can access the web interface and it's working fine, so I think that
XE it's working properly.
Thank you,
Dan
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?b37cb0970703130155p6ea0d29al47de63bc3c1b77e6>