IS THERE ANY ERROR IN LSNRCTL STATUS

[pava...@gmail.com]

hi
while running this lsnrctl start list i am getting The command
completed successfully
----------------------------------------------------------------------------------------------
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /apps/ora10/listener.ora
Log messages written to /apps/ora10g/prod10/network/log/rman.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=of10.dreams.com)(PORT=1536)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=of10.dreams.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias rman
Version TNSLSNR for Linux: Version 10.2.0.1.0 -
Production
Start Date 30-OCT-2007 16:17:35
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /apps/ora10/listener.ora
Listener Log File /apps/ora10g/prod10/network/log/rman.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=of10.dreams.com)
(PORT=1536)))
Services Summary...
Service "pavani.dreams.com" has 1 instance(s).
Instance "pavani", status UNKNOWN, has 1 handler(s) for this
service...
The command completed successfully
-----------------------------------------------------------------------------------------------

But when i running this statement (lsnrctl status) at $ prompt ,there
is a error ie
--------------------------------------------------------------------------------------------------
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-OCT-2007
16:17:50

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
--------------------------------------------------------------------------------------------------

After tnsping TO_RMAN
---------------------------------------------------------------------------------------------------
Used parameter files:
/apps/ora10g/prod10/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = of10.dreams.com)(PORT = 1536))) (CONNECT_DATA
= (SERVICE_NAME = pavani)))OK (0 msec)
------------------------------------------------------------------------------------------------
while doing RMAN
at $ rman catalog rman/rman target=sys/sys@TO_RMAN
I AM GETTING ERROR ie
-------------------------------------------------------------------------------------------------
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested
in connect descriptor
-------------------------------------------------------------------------------------------------------------------

[prasad pedavalli]

Pavani,

are you using any name for Listener ? Can you pls pate ur listener.ora file...i may help you to solve out ur prob.

Thanks.

 

--
Thanks & Regards
--
Prasad

[fitzj...@cox.net]

Comments embedded.

On Oct 30, 8:42 am, "prasad pedavalli" <prasad.pedava...@gmail.com>
wrote:

> Pavani,
> are you using any name for Listener ?

Yes, and were you to read the post you'd know this:

Alias rman

> Can you pls pate ur

> listener.orafile...i may help you to solve out ur prob.
> Thanks.
>

All of the information you need is posted. A:

$ lsnrctl status rman

is all that's needed to provide 'correct' and error-free output.

> On 10/30/07, pavani...@gmail.com <pavani...@gmail.com> wrote:
>
>
>
>
>
>
>
> > hi
> > while running this lsnrctl start list i am getting The command
> > completed successfully
>

> > ---------------------------------------------------------------------------­-------------------

> > ---------------------------------------------------------------------------­--------------------

>
> > But when i running this statement (lsnrctl status) at $ prompt ,there
> > is a error ie
>

> > ---------------------------------------------------------------------------­-----------------------

> > LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-OCT-2007
> > 16:17:50
>
> > Copyright (c) 1991, 2005, Oracle. All rights reserved.
>
> > Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
> > TNS-12541: TNS:no listener
> > TNS-12560: TNS:protocol adapter error
> > TNS-00511: No listener
> > Linux Error: 111: Connection refused
>

> > ---------------------------------------------------------------------------­-----------------------
>
> > After tnsping TO_RMAN
>
> > ---------------------------------------------------------------------------­------------------------

> > Used parameter files:
> > /apps/ora10g/prod10/sqlnet.ora
> > Used TNSNAMES adapter to resolve the alias
> > Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
> > (PROTOCOL = TCP)(HOST = of10.dreams.com)(PORT = 1536))) (CONNECT_DATA
> > = (SERVICE_NAME = pavani)))OK (0 msec)
>

> > ---------------------------------------------------------------------------­---------------------

> > while doing RMAN
> > at $ rman catalog rman/rman target=sys/sys@TO_RMAN
> > I AM GETTING ERROR ie
>

> > ---------------------------------------------------------------------------­----------------------

> > RMAN-00571:
> > ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> > ===============
> > RMAN-00571:
> > ===========================================================
> > RMAN-00554: initialization of internal recovery manager package failed
> > RMAN-04005: error from target database:
> > ORA-12514: TNS:listener does not currently know of service requested
> > in connect descriptor
>

> > ---------------------------------------------------------------------------­----------------------------------------

>
> --
> Thanks & Regards
> --

> Prasad- Hide quoted text -
>
> - Show quoted text -

David Fitzjarrell

[prasad pedavalli]

Hi David,

yes if we r having any alias for listener we need to use the the following

lsnrctl <option> <alias>. i know that.

Any way thanks,may be havent study well the pavani's post.

 

> > (PROTOCOL = TCP)(HOST = of10.dreams.com )(PORT = 1536))) (CONNECT_DATA

[pavani m]

yes, i gave the alias name while running the rman,

<listener name> is rman where as in <tns name> i have given to_rman.

so while running in client side ie

 

sqlplus scott/tiger@to_rman
it is not running at all.

 

 

can u plz tel me how to get demobld.sql,

i dont have oracle 9i to get demobld.sql from there.

i search this file ,but i did not find this file at all.

 

On 10/30/07, fitzj...@cox.net <fitzj...@cox.net> wrote:

> > (PROTOCOL = TCP)(HOST = of10.dreams.com )(PORT = 1536))) (CONNECT_DATA

[prasad pedavalli]

Pavani,

See the below link......

http://www.oracle.com/technology/sample_code/tech/sql_plus/htdocs/demobld.html

 

U may copy this as demobld.sql and run it in ur database under your Schema.

 

Regards,

Prasad.

 

> > (HOST= of10.dreams.com )(PORT=1536)))

[fitzj...@cox.net]

On Nov 4, 7:02 am, "pavani m" <pavani...@gmail.com> wrote:
> yes, i gave the alias name while running the rman,
> <listener name> is rman where as in <tns name> i have given to_rman.
> so while running in client side ie
>
> sqlplus scott/tiger@to_rman
> it is not running at all.
>
> can u plz tel me how to get demobld.sql,
> i dont have oracle 9i to get demobld.sql from there.
> i search this file ,but i did not find this file at all.
>

> > > > (PROTOCOL = TCP)(HOST = of10.dreams.com)(PORT = 1536))) (CONNECT_DATA

> > > > = (SERVICE_NAME = pavani)))OK (0 msec)
>
> > ---------------------------------------------------------------------------­­---------------------
> > > > while doing RMAN
> > > > at $ rman catalog rman/rman target=sys/sys@TO_RMAN
> > > > I AM GETTING ERROR ie
>
> > ---------------------------------------------------------------------------­­----------------------
> > > > RMAN-00571:
> > > > ===========================================================
> > > > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> > > > ===============
> > > > RMAN-00571:
> > > > ===========================================================
> > > > RMAN-00554: initialization of internal recovery manager package failed
> > > > RMAN-04005: error from target database:
> > > > ORA-12514: TNS:listener does not currently know of service requested
> > > > in connect descriptor
>
> > ---------------------------------------------------------------------------­­----------------------------------------
>
> > > --
> > > Thanks & Regards
> > > --
> > > Prasad- Hide quoted text -
>
> > > - Show quoted text -
>

> > David Fitzjarrell- Hide quoted text -

>
> - Show quoted text -

The listener is running, but not on the port you have defined in the
tnsnames.ora for the to_rman alias. The listener is configured on
port 1536:

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=of10.dreams.com)(PORT=1536)))

and your tnsnames.ora entry is looking for a listener at port 1521:

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

There is no listener running on port 1521; as I said earlier it's on
1536. Change your tnsnames.ora file to use the correct port.

David Fitzjarrell