From owner-freebsd-database@FreeBSD.ORG Tue Mar 13 08:55:28 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 0703516A403 for ; Tue, 13 Mar 2007 08:55:28 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.242]) by mx1.freebsd.org (Postfix) with ESMTP id C1AB113C44B for ; Tue, 13 Mar 2007 08:55:27 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: by an-out-0708.google.com with SMTP id c24so1645762ana for ; Tue, 13 Mar 2007 01:55:27 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=qq8w3zZmlCMua6ocZ7mR2Dvaoh26coobFu9iueaBNVkzac0MrHVJXfXlqkCXcsdZ6F2o9GGk+w9v4HXOZKsDOy9vhltoAmjZWPB0Xvf90jYmDSmST1O3d7qKwkvumS691GAYV5uMiWoAY9EhFSjXdiZzTs7xDWgDJrrqoTnO25I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Owa9HSlZNFhO5TQh2U8NT0rxSAqsadb6eB04yL2Mo6uJX0TGzHvWVBTKEZT3cZzPt6ByJaPAMAwvYRqK9PSAzWABj7gODNupw7F6BB+K9E1O2T6fZGDHLuI4aaD2arMFrsOc0JipUp4lPwaB2120CJzLkFE4+Bjl0h+VgMrVUf0= Received: by 10.100.152.9 with SMTP id z9mr502257and.1173776126964; Tue, 13 Mar 2007 01:55:26 -0700 (PDT) Received: by 10.100.57.12 with HTTP; Tue, 13 Mar 2007 01:55:26 -0700 (PDT) Message-ID: Date: Tue, 13 Mar 2007 10:55:26 +0200 From: "Dan Cojocar" To: "Max Khon" In-Reply-To: <20070313085009.GA7829@samodelkin.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070313085009.GA7829@samodelkin.net> Cc: freebsd-database@freebsd.org Subject: Re: oracle8-client X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 Mar 2007 08:55:28 -0000 On 3/13/07, Max Khon 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