Re: problem with dbca on Oracle 9i R2 9.2.0.1.0 Linux

From: Stu Miller <srmiller_at_xs4all.nl>
Date: Wed, 10 Mar 2004 18:17:42 +0100
Message-ID: <404f4db7$0$569$e4fe514c@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_LIST =

         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
       )


       (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.com

Received on Wed Mar 10 2004 - 11:17:42 CST