Re: Cannot connect to ORACLE after changing IP address

Gunawan,

Your listener couldn't open a port on orcsda and failed to start up. Could it be you have not changed IP address in DNS? Try to ping orcsda from the server itself. Also you can trace the listener (don't remember if it's available in O8 though).

Regards,
Igor.

"Gunawan Santoso" <gunawans_at_rad.net.id> wrote in message news:<9gI67.1019$96.6140_at_news>...
> Dear all,
> I couldn't connect to my oracle 8.0.5 server after I changed the IP address
> from 172.16.x.x to 172.18.x.x. I have to change all my computers in my
> domain to 172.18.x.x. Everything is working properly after address change,
> except I couldn't connect to Oracle. I can ping to the server but I couldn't
> tnsping to it. There is error message in listener.log:
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> System parameter file is C:\orant\NET80\admin\listener.ora
> Log messages written to C:\orant\NET80\log\listener.log
>
> Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
> Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))
> Listening on: (ADDRESS=(PROTOCOL=nmp)(PIPENAME=\\ORCSDA\pipe\ORAPIPE))
> Attempted to listen on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=orcsda)(PORT=1
> 521)))
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> 32-bit Windows Error: 50: Unknown system error
>
>
> Question: How to fix this problem? What is the proper step of changing
> address for Oracle server?
>
> Now the listener service dies without giving any clue in the NT's event
> viewer. I can start it up, but after a few minutes the service will die.
>
> Thanks in advance,
>
> Gunawan Santoso
Received on Mon Jul 23 2001 - 00:19:41 CDT