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

Sorry, that should have been "listener.ora", not "tnsnames.ora"

Stu

Stu Miller wrote:
> 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