No Listener
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: No Listener

Hybrid View

  1. #1
    Join Date
    May 2001
    Posts
    41

    Lightbulb

    Hello,

    I have installed Oracle 9.0.1.0.0 on a Suse 7.2 and I can't get the listener
    to start. I have checked on listener.ora and Tnsnames.ora they have the same
    information, I checked and change /etc/services to include listener_name
    and port 1521......
    run dbastudio it comes back error message no listener, ORA-12541: TNS: no listener.
    run dbstart, the database open, few seconds later I get
    "Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0-production
    with the partitioning option Jserver Release 9.0.1.0.0-production"

    "Database "earth" warm started"
    run lsnrctl start, I get
    "message 1070 not found; no message file for prodct=network,
    facility=TNSTNS=12545:message 12545 not found:.........."


    Thanks,
    mn


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    make sure that you have set the PATH correctly. then do

    Code:
       lsnrctl status
       lsnrctl start
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Usually Oracle has errors like this:
    "message 1070 not found; no message file for prodct=network,
    facility=TNSTNS=12545:message 12545 not found:.........."
    when :
    $ORACLE_HOME don't set or not set correctly.

  4. #4
    Join Date
    May 2001
    Posts
    41

    No Listener

    PATH is correct, it include $ORACLE_HOME
    lsnrctl start see error message
    Moderator, please remove dual topic. This is urgent I need some help

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can you try this?

    Code:
     
          cd $ORACLE_HOME/bin
          ./lsnrctl status                      <-- What did this return?
          ./lsnrctl start
    What are the permissions on the listener.ora file and also if you don't mind could you post the listener.ora file. (make sure that you remove the IP/host addresses

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    May 2001
    Posts
    41

    No Listerner

    Prem. on Listener.ora ( -rw-rw-r--)
    . /lsnrctl status
    "Message 1053 not found, No message file for product=network, facility=TNSTNS=12541:message 12541 not found; No message file for product=network, facility=TNSTNS-12560..........................."

    Listener.ora ( File )
    Listener =
    (description_list =
    (description =
    (address_list =
    (address=(protocol=ipc)(key=extproc))
    )
    (address_list=
    (address=(protocal=tcp)(host=..........)(port=1521)
    )
    )
    )
    sid_list_listener=
    (sid_list=
    (sid_desc=
    (sid_name = earth
    (oracle_home= /home/mnaser/OraHome1)
    (programe = extproc)
    )
    (sid_desc=
    (global_dbname=earth)
    (oracle_home= /home/mnaser/orahome1)
    (sid_name= earth)
    )
    )


    I have include the Path in the ".profile", I used the "PATH= "
    and "export Path" commands to set the new path that included Oracle_home. Is this the correct command to update PATH in Linux?

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can you set
    Code:
    export ORACLE_HOME=/user/../app/oracle/product/...
    
    export PATH=$ORACLE_HOME/bin:$PATH
    
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    As said on one of the earlier posts, its the problem with the environment setup. Reset the envioment and if you use the profile, then check to confirm that it got loaded correctly by

    Code:
      env
    Else post your environment set up here

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    12545 is a TNSNAMES problem (host does not exist).
    12560 says the adapter is not present.

    If you are running locally, what are your BEQ protocol settings? (Again, in TNSNAMES.ORA).


    I have also seen these errors when the networking protocol is not installed, which would also explain why the messages could not be found.

    Is there a 'network' subdirectory in $ORACLE_HOME?

    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  9. #9
    Join Date
    May 2001
    Posts
    41

    No Listener

    Sam and others,

    Sorry about this,

    How to reset the enviorment?
    What is the BEQ protocol, the only protocol listed in the TNSNAMES is (TCP)? and yes there is a "Network" subdirectory.

  10. #10
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    About ur environment:

    It should be declare in ur .profile or .login or .bash_profile files,
    depend from shell that u use.
    How list ur environment variables:
    > env
    and u can see print like this:
    NLS_LANG=american_america.we8iso8859p1
    LD_LIBRARY_PATH=/opt/oracle/lib:/opt/home/sgene/perl/dbd/DBD-Oracle-1.06/blib/lib/auto/DBD/Oracle:/dbi/DBI-1.15/blib/arch/auto/DBI
    PERL_HOME=/opt/home/sgene/perl
    ORACLE_BASE=/opt/oracle
    PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/opt/oracle/bin:/usr/bin:/etc:/bin:/opt/oracle/lib:/opt/home/sgene/perl/dbd/DBD-Oracle-1.06/blib/lib/auto/DBD/Oracle:/dbi/DBI-1.15/blib/arch/auto/DBI:/usr/local/ActivePerl-5.6/bin
    DISPLAY=:0.0
    DBI_LIB=dbi/DBI-1.15/blib/arch/auto/DBI
    TNS_ADMIN=/opt/oracle/network/admin
    DBD_LIB=dbd/DBD-Oracle-1.06/blib/lib/auto/DBD/Oracle
    ..
    ORACLE_HOME=/opt/oracle/product/...
    PATH=...:/opt/oracle/product/.../bin:...
    CHECK :ORACLE_HOME, PATH ... other oracle variables

    About error messages:
    this messages may be if:
    -- ORACLE_HOME=/opt/o... don't set correctly (not PATH=)
    -- in $ORACLE_HOME/network/mesg u haven't *xx.msg files
    where xx should be US for english language or another for language that set
    in ur NLS_LANG= variable
    ---------------------------------------------
    reset environment:
    1 way :
    logout
    logon
    2 way
    su - oracle
    ---------------------------------------------
    BEQ-LOCAL protocol this is especial oracle protocol between oracle
    core software and client software on same box usually in nt(w2k) environment.








    [Edited by Shestakov on 03-26-2002 at 06:11 PM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width