[askdba] Re: Archieves and no listener
- From: Nisar Tareen <ntareen@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Sun, 2 Sep 2007 08:51:37 -0700 (PDT)
Basic question , Check the services they are up.
NT
----- Original Message ----
From: Thiagoo <thiagoodba@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Sent: Saturday, September 1, 2007 1:52:39 AM
Subject: [askdba] Re: Archieves and no listener
Drumil Narayan,
1. I think you're connecting from the machine, where the database resides,Pls
try to connect to this database from some other machine. In this way, it
ensures that listener is up and running!
2. Check whether tnsnames.ora has the right database name, server name & port#
and whether tnsping works fine. Check whether listener has proper
configurations.
3.check, lsnrctl status, stop and start and see whether listener is up and
running.
4.How many versions of Oracle are running in that machine, if there are
multiple versions running, you should start the listener with the highest
version of oracle/listener. For ex, if u hv 8i,9i,10g running, set oracle sid
to 10g database and start the listener...this will start all the listener
versions..!
Pls try this..and let me know..whether is helped to resolve the issue.
HTH,
Thiagu
drumil narayan <drumilnarayan@xxxxxxxxx> wrote:
Hi All,
Any clues please..thanks..drumil
--- drumil narayan wrote:
> I am able to connect to the instance from sql
> client,
> so listner is up, still why am receiving error in my
> alert log.
> The OS level write permission/space are already
> checked and no issues in it..
> there is no hangup session, lock observed from
> oem10g
>
> what could be the issue
>
> Errors in file
> /usr/oracle/admin/WHSE/bdump/whse1_arc0_30929.trc:
> ORA-12541: TNS:no listener
> Wed Aug 22 11:24:40 2007
> Errors in file
> /usr/oracle/admin/WHSE/bdump/whse1_arc0_30929.trc:
> ORA-12541: TNS:no listener
> Wed Aug 22 11:30:40 2007
> Errors in file
> /usr/oracle/admin/WHSE/bdump/whse1_arc0_30929.trc:
> ORA-12541: TNS:no listener
>
>
>
>
> 5, 50, 500, 5000 - Store N number of mails in
> your inbox. Go to
>
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html
>
>
Once upon a time there was 1 GB storage in your inbox. To know the happy ending
go to http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html
==================================================
Thanks & Best Regards,
Thiagu
==================================================
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on,
when.
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545433
Other related posts:
