Re: problem with dbca on Oracle 9i R2 9.2.0.1.0 Linux
Date: Wed, 10 Mar 2004 18:17:42 +0100
Message-ID: <404f4db7$0$569$e4fe514c_at_news.xs4all.nl>
The problem likely comes from installing on a server via a remote
x-terminal (as I did).
The solution is to edit the tnsnames.ora file and add a 'host' entry to
the 'address' entry of your listener.
e.g.:
---before----
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521))
)
)
)
---after---
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS_LIST =
(ADDRESS = (HOST=hostname)(PROTOCOL = TCP)(PORT = 1521))
)
)
)
When I added this, and returned to the DBCA, it was able to continue.
Hope this works for others.
Stuart
Rob Ward wrote:
> Hi Oguz, > > > > I'm seeing exactly the same problem on a Solaris machine running Oracle > 9.2.0.1. Did you find a solution to this? Thanks, > > > > Rob. > > > > > > __________________ > > Rob Ward > > 724 Solutions Inc., Bahnhofstrasse 16, CH-5600 Lenzburg, Switzerland. > > > -- > Posted via http://dbforums.comReceived on Wed Mar 10 2004 - 18:17:42 CET