From oracle-l-bounce@freelists.org Thu Jun 17 10:58:07 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5HFvqb28188 for ; Thu, 17 Jun 2004 10:58:02 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5HFvg628156 for ; Thu, 17 Jun 2004 10:57:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9CDA972DC1D; Thu, 17 Jun 2004 10:42:06 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18028-43; Thu, 17 Jun 2004 10:42:06 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE2D572C471; Thu, 17 Jun 2004 10:42:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 17 Jun 2004 10:40:35 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C9E7572D692 for ; Thu, 17 Jun 2004 10:40:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17669-29 for ; Thu, 17 Jun 2004 10:40:34 -0500 (EST) Received: from amer-mta01.csc.com (amer-mta01.csc.com [20.137.2.247]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A9BF72CF20 for ; Thu, 17 Jun 2004 10:40:34 -0500 (EST) Received: from csc.com (va-fch34.csc.com [20.6.39.227]) by amer-mta01.csc.com (Switch-3.1.2/Switch-3.1.0) with ESMTP id i5HFxI4q011001 for ; Thu, 17 Jun 2004 12:04:24 -0400 (EDT) Subject: Re: Problem upgrading from Windows 2000 Oracle 8.0.6 to Oracle 9.2.0.1.0 To: oracle-l@freelists.org X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-ID: From: Thomas Day Date: Thu, 17 Jun 2004 10:55:53 -0400 X-MIMETrack: Serialize by Router on VA-FCH34/SRV/CSC(Release 6.0.3|September 26, 2003) at 06/17/2004 12:09:53 PM MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2887 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tday6@csc.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Check the TNSNAMES.ORA entry under your 9.2.0.1.0 home. You'll probably need to copy the entry from the 8.0.6 home TNSNAMES.ORA "Paul Vincent" @uce.ac.uk> cc: Sent by: Subject: Problem upgrading from Windows 2000 Oracle 8.0.6 to Oracle 9.2.0.1.0 oracle-l-bounce 06/17/2004 10:37 AM Please respond to oracle-l Hi everybody, I've just installed Oracle 9.2.0.1.0 onto a Windows 2000 server which was currently running Oracle 8.0.6 with a single instance on it. I noticed that during the installation, I wasn't presented with the Upgrading An Existing Database screen. This may be significant! I didn't think anything of it, since I intended to run the Database Upgrade Assistant independently after installing 9.2. The installation went smoothly. I then checked that the 8.0.6 db instance was still up and running, by connecting to it from my office workstation. Yes, fine. Back to the server, and I fired up Database Upgrade Assistant from the Oracle 9.2 program group. After the Welcome screen it showed the panel which did indeed list my 8.0.6 database. I selected it, gave a userid with the necessary SYSDBA privileges, and a password, and clicked on next. Then I got an error message: ORA-12203: TNS unable to connect to destination. Now, presumably this means I've got something wrongly configured on the server, such that it can't connect to its own local database. Any ideas at all, as to where I should start looking, would be very greatly appreciated! Best regards, Paul Vincent Database Administrator University of Central England ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------