problem with listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: problem with listener

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    problem with listener

    hi,
    I've installed oracle 8.1.7 server with two istance
    IMM1
    IMM2
    IMM2 run correctly, but when I started IMM1 I get this error:
    ORA-12541:TNS:NO LISTENER

    the listener is up (status listener is OK)
    this is the file listener.ora:
    IMM2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = imm2)
    )
    )

    IMM1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = imm1)
    )
    )

    tnsping imm1 run correctly

    How can I started imm1???

    Thanks
    Raf

  2. #2
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    Hi Raf,


    Make sure the tnsname.ora file is also under network/admin folder of the directory in which imm1 is located.

    C. K.
    AppsDBA 11i

  3. #3
    Join Date
    Nov 2002
    Location
    CA USA
    Posts
    4
    Is it OK to have same port no for two instances? From your listner.ora file HOST is same and even PORT no is also same.. Is it ok?? I think you need to change the port no and then try...

    Cheers !!

    Harshal

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Well, for one, that is not your listener.ora file. What you pasted in was all or part of your tnsnames.ora file.

    The listener.ora file looks like this:
    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = stecalpc)(PORT = 1521))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = db00)
    (ORACLE_HOME = d:\oracle\ora81)
    (SID_NAME = db00)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = cendb)
    (ORACLE_HOME = d:\oracle\ora81)
    (SID_NAME = cendb)
    )
    )

    Make sure your SID is listed in the listener.ora file. You can have a gazillion SIDs listed for the listener on port 1521. If your listener was okay, you would have seen both instances registered, so what did you mean by "the listener is up (status listener is OK)?"

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