Re: about setting connection to local database from EM DBControl configure program through IPC

>On Jun 13, 5:00 pm, sybra..._at_hccnet.nl wrote:
>> On Sat, 13 Jun 2009 10:10:23 -0700 (PDT), riverdance
>>
>>
>>
>>
>>
>> <esthershe..._at_yahoo.com> wrote:
>> >hi,
>>
>> >I'm new in oralce world.
>>
>> >I tried to setup Oracle EM DB Control.
>> >it seems I had problem to connect to local database by TCP...so I set
>> >IPC in my tnsnames.ora, and I could tnsping my service name, and I
>> >could sqlplus to connect to my local database by IPC.  I hope EM DB
>> >control configure program could use that to connect to local database.
>>
>> >I try to do emca -deconfig dbcontrol db -repos drop..
>>
>> >but from listener.log file, it seems EM still keep on trying  to use
>> >TCP to connect to local database, and I had no idea where it get
>> >connection information from...
>>
>> >all the connection info in my tnsnames.ora is only specified IPC ..
>> >not TCP..
>>
>> >any suggestion is very appreciated.
>>
>> >Thanks.
>>
>> Db control is fully TCP/IP based.
>> Maybe your unknown problem results from running on a DHCP assigned
>> address, and ignoring the admonition during installation to install a
>> local loopback adapter.
>> As you don't provide any details, and are calling in for crystal
>> balls, more help is not possible.
>>
>> ---
>> Sybrand Bakker
>> Senior Oracle DBA- Hide quoted text -
>>
>> - Show quoted text -
>
>HI, Thanks for your reply.
>sorry did not explain my environment first.
>
>it's a DHCP machine, but I have installed local loopback adapter, and
>set IP to fix IP on that adapter.
>
>but it seems when I tried to TNSPING using tcp , it works, but using
>SQLPLUS , it hung..
>
>from the listener log, I found the connection was established on some
>port.. but why SQLPLUS is hung..
>
>I think that is the reason, when I tried to configure EM , got hung
>using TCP..
>
>but I don't know what caused that hung thourhg SQLPLUS..
>
>
>any suggestion is appreciated.. thanks.
>

The usual path for such problems is to enable sqlnet tracing on level 16.
How to do this is explained in the documentation,which no one, including you, reads, and in numerous posts of myself, which also no one reads.
Posts like this one make me consider disappearing of this group completely. The pest of wanna-be DBAs not reading Oracle documentation, not even trying to troubleshoot a problem themselves will never end.

-- 
Sybrand Bakker
Senior Oracle DBA