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

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))
       )
     )

     (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