Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: listener troubles after restore to new server.

Re: listener troubles after restore to new server.

From: <sybrandb_at_hccnet.nl>
Date: Wed, 20 Jun 2007 23:30:56 +0200
Message-ID: <g17j739af2asi4j4ij3prkisdqq9jjul8p@4ax.com>


On Wed, 20 Jun 2007 20:34:34 -0000, cptkirkh <khill_at_scic.com> wrote:

>On Jun 20, 3:28 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> cptkirkhwrote:
>> > On Jun 20, 2:09 pm, sybra..._at_hccnet.nl wrote:
>> >> On Wed, 20 Jun 2007 18:14:47 -0000,cptkirkh<k..._at_scic.com> wrote:
>> >>> I did but it gives me the error that "Could not create listener"
>> >> Usually such message signify there is further information in an
>> >> associated log file, in this case -obviously- listener.log. Did you
>> >> look into it? If you didn't please do, and post the results.
>>
>> >> --
>> >> Sybrand Bakker
>> >> Senior Oracle DBA
>>
>> > I managed to get the service to start. I deleted the service from
>> > windows and then deleted the listener.ora and then recreated the
>> > listener. Now when i try to connect this is what i get in the
>> > listener log file.
>> > 20-JUN-2007 14:55:15 * (CONNECT_DATA=(SERVICE_NAME=porky)
>> > (CID=(PROGRAM=F:\oracle\product\10.1.0\Db_1\jdk\jre\bin\java.exe)
>> > (HOST=DAFFY)(USER=servop))) * (ADDRESS=(PROTOCOL=tcp)
>> > (HOST=192.168.1.55)(PORT=1390)) * establish * porky * 12500
>> > TNS-12500: TNS:listener failed to start a dedicated server process
>> > TNS-12560: TNS:protocol adapter error
>> > TNS-00530: Protocol adapter error
>>
>> Define "deleted the service from windows" ... what did you do?
>>
>> Define "recreated the listener" ... what did you do?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>
>> - Show quoted text -
>
>I removed the service for the listener from the windows registry.
>Then I user the net config asst. to create a new listener.

Which was clearly not what I advised and also utterly stupid. But I agree it is the common Mickeysoft troubleshoot method: first ruin everything and then start from 0.
Just because reading manuals is asked too much.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Jun 20 2007 - 16:30:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US