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: <fitzjarrell_at_cox.net>
Date: Tue, 05 Jun 2007 13:55:15 -0700
Message-ID: <1181076915.573583.241570@h2g2000hsg.googlegroups.com>


On Jun 5, 3:19 pm, cptkirkh <k..._at_scic.com> wrote:
> After restoring my database to a new server for testing purposes i get
> the following error whe i try to logon or start the listener.
>
> TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 02-
> JUN-2007 15:40:53
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> System parameter file is F:\oracle\product\10.1.0\Db_1\network\admin
> \listener.ora
> Log messages written to F:\oracle\product\10.1.0\Db_1\network\log
> \listener.log
> Trace information written to F:\oracle\product\10.1.0\Db_1\network
> \trace\listener.trc
> Trace level is currently 0
>
> Started with pid=3308
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
> \EXTPROCipc)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
> (HOST=daffy.cic.scic.com)(PORT=1521)))
>
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> NL-00051: internal error code, arguments: [302], [1], [], [], [], [],
> []
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\
> \.\pipe\EXTPROCipc)))
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
> (HOST=daffy.cic.scic.com)(PORT=1521)))
>
> TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 02-
> JUN-2007 15:48:00
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> System parameter file is F:\oracle\product\10.1.0\Db_1\network\admin
> \listener.ora
> Log messages written to F:\oracle\product\10.1.0\Db_1\network\log
> \listener.log
> Trace information written to F:\oracle\product\10.1.0\Db_1\network
> \trace\listener.trc
> Trace level is currently 0
>
> Started with pid=1928
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
> \EXTPROCipc)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver.com)
> (PORT=1521)))
>
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> NL-00051: internal error code, arguments: [302], [1], [], [], [], [],
> []
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\
> \.\pipe\EXTPROCipc)))
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
> (HOST=daffy.cic.scic.com)(PORT=1521)))
>
> TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 05-
> JUN-2007 15:09:15
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> System parameter file is F:\oracle\product\10.1.0\Db_1\network\admin
> \listener.ora
> Log messages written to F:\oracle\product\10.1.0\Db_1\network\log
> \listener.log
> Trace information written to F:\oracle\product\10.1.0\Db_1\network
> \trace\listener.trc
> Trace level is currently 0
>
> Started with pid=6016
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
> \EXTPROCipc)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
> (HOST=daffy.cic.scic.com)(PORT=1521)))
>
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> NL-00051: internal error code, arguments: [302], [1], [], [], [], [],
> []
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\
> \.\pipe\EXTPROCipc)))
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
> (HOST=myserver.com)(PORT=1521)))
>
> TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 05-
> JUN-2007 15:09:58
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> System parameter file is F:\oracle\product\10.1.0\Db_1\network\admin
> \listener.ora
> Log messages written to F:\oracle\product\10.1.0\Db_1\network\log
> \listener.log
> Trace information written to F:\oracle\product\10.1.0\Db_1\network
> \trace\listener.trc
> Trace level is currently 0
>
> Started with pid=5644
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
> \EXTPROCipc)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver.com)
> (PORT=1521)))
>
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN
> CODE
> NL-00051: internal error code, arguments: [302], [1], [], [], [], [],
> []
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\
> \.\pipe\EXTPROCipc)))
>
> here is a copy of my listener.ora:
>
> # listener.ora Network Configuration File: F:\oracle\product
> \10.1.0\Db_1\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)
> (PROGRAM = extproc)
> (eNVS = "EXTPROC_DLLS=ANY")
> )
> (SID_DESC =
> (SID_NAME =orcl)
> (ORACLE_HOME = F:\ORACLE\PRODUCT\10.1.0\DB_1)
> )
> )
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.com)(PORT = 1521))
> )
> )
> )
>
> my tnsnames.ora:
>
> # tnsnames.ora Network Configuration File: F:\oracle\product
> \10.1.0\Db_1\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> orcl =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.com)(PORT = 1521))
> )
> (server = dedicated)
> (CONNECT_DATA =
> (SERVICE_NAME = PORKY)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> Any help would be appreciated.

Have you created the associated listener service? It appears not. I would be using the Net Configuration Assistant to correct this 'problem'.

David Fitzjarrell Received on Tue Jun 05 2007 - 15:55:15 CDT

Original text of this message

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