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 "
<Paul.Vincent To: <oracle-l@(protected) >
@(protected) > 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 (See ORA-12203.ora-code.com): 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
