listener problem on aix
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: listener problem on aix

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    50

    listener problem on aix

    hello friends

    i have oracle 8i on aix and database is working properly
    but listener is not working

    when i say
    start listener
    the process gets hang my
    listener.ora is ok
    can any body help me

    any type of help will be well come


    bhushan

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Can you post you listener.ora and sqlnet.ora

    Also are there any errors reported in $ORACLE_HOME/network/log/listener.log

    regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2002
    Posts
    50

    LISTENER

    HELLO

    I AM SENDING MY FILES
    /***************
    listener.ora
    *^***************/

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = aix)(PORT = 1521))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = Oracle8)
    (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
    (SID_NAME = ORCL)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = hurtado.hurtado.com)
    (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
    (SID_NAME = hurtado)
    )
    )



    /***********************
    sqlnet.ora
    *************************/
    SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf



    regards
    bhushan

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Are there any errors reported in $ORACLE_HOME/network/log/listener.log

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Jan 2002
    Posts
    50

    my error is the listener.log

    hello
    i am sending .log file

    Trace level is currently 0

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aix)(PORT=1521)))
    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

    can u explan me
    what is the entry in the sqlnet.ora file


    regards
    bhushan

  6. #6
    Join Date
    Feb 2003
    Posts
    40
    Bhushan,

    SQLNET.CRYPTO_SEED
    Specifies the characters used when generating cryptographic keys. The more random the characters are, the stronger the keys are. This is required whenever encryption or checksumming is turned on
    ***********************************************************
    Check the listener process
    ps -ef|grep tns
    This will give the list if the listener is running.

    If it is running ,shut it down and restart.
    Sometimes it happens even lsnrctl status command will hang.
    You have to check the CPU consumption.

    If it is too much sometimes listener hangs .
    During that situation ,lsnrctl stop also willnot help.

    So give : kill - 9 listenerprocessid

    Then restart the listener.

    If that is not the situation,Check with the sysadmin for the portno . Jus' try to get a different portno which is not conflicting.

    Edit listener.ora accordingly and restart ..

    Hope this helps
    K.Chithra
    Oracle DBA

  7. #7
    Join Date
    Jan 2002
    Posts
    50

    LISTENER problem

    it is still having the same problem
    i did tryed the gerp and it shows the process for listener
    but for connection from win2000 i have the same
    ora-27101 prblem

    i am putting my ps -ef | grep tns output
    ************************************************
    @aix /oracle$ ps -ef | grep tns
    oracle 11444 9814 0 19:43:48 pts/1 0:00 grep tns
    oracle 12396 1 0 19:56:55 pts/0 0:00 /oracle/app/oracle/product/8.1.7/bin/tnslsnr listener -inherit




    bhushan
    Last edited by BHUSHAN; 03-07-2003 at 05:29 AM.

  8. #8
    Join Date
    Jan 2002
    Posts
    50
    hello
    friends

    with the help of all u i am able to solev
    this problem
    what i did is that
    just change the listener.ora
    in place of hostname i put ip address
    my listener was starting and stoping normal
    this sorted out my problem

    special thanks to
    k. chitra and mr. amar


    bhushan

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