problem with listener
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

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
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Different port for imm1

    Sameer

  3. #3
    Join Date
    Jul 2002
    Posts
    228
    Originally posted by Sameer
    Different port for imm1

    Sameer
    the port is same
    This is the tnsnames.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)
    )
    )

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If the first file is your listener.ora you are trying to configure 2 listeners which is why Sameer suggested that you must have two different port numbers.

    Are you trying to create two listeners? or do you want one listener for the two services?

    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
    Jul 2002
    Posts
    228
    Originally posted by jovery
    If the first file is your listener.ora you are trying to configure 2 listeners which is why Sameer suggested that you must have two different port numbers.

    Are you trying to create two listeners? or do you want one listener for the two services?

    Regards
    Now I've just one listener for two istances.
    must I create two listener necessarly??
    how can I create a new listener for istance imm1?

    Thanks
    raf

  6. #6
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Use different port as those genius said.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  7. #7
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If you only want the one listener your listener.ora should look something like this

    Code:
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
          )
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
          )
        )
      )
    
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
          (PROGRAM = extproc)
        )
    Your services should auto register.

    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!

  8. #8
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    I should have been more clear..forgot to write word "USE" two different ports

    Use Net8 or you can manually edit listener.ora file to add settings for new listener and then start it using listener control

    Sameer

  9. #9
    Join Date
    Jul 2002
    Posts
    228
    Originally posted by Sameer
    I should have been more clear..forgot to write word "USE" two different ports

    Use Net8 or you can manually edit listener.ora file to add settings for new listener and then start it using listener control

    Sameer
    sorry,
    I've create a new listener (listener2) with net8 on port 1522
    This is new listener.ora:
    # LISTENER.ORA Network Configuration File: C:\oracle\ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER2 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1522))
    )
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvimm)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = imm1)
    (ORACLE_HOME = C:\oracle\ora81)
    (SID_NAME = imm1)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = imm2)
    (ORACLE_HOME = C:\oracle\ora81)
    (SID_NAME = imm2)
    )
    )

    after I've changed tnsnames.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 = 1522))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = imm1)
    )
    )

    but when I tried to connect I get this error:
    ERROR:
    ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
    descriptor

    What I wrong??

    Thanks
    regards
    Raf

  10. #10
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Check if the service_name parameter specified in listener.ora is same as that of in init.ora (parameter service_names)

    If you haven't specified SERVICE_NAMES parameter in init.ora then change SERVICE_NAME of tnsnames.ora to SID

    Code:
    listener.ora
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = stmn)(PORT = 1521))
          )
        )
      )
    
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = orcl)
          (ORACLE_HOME = /opt/oracle/product/8.1.6)
        )
      )
    
    tnsnames.ora
    
    ora4 = 
    (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS =
          (COMMUNITY=TCP.world)
          (PROTOCOL=TCP)(Host=stmn)
          (Port=1521)
        )
     )
     (
      CONNECT_DATA=(SID=orcl)
     )
    )
    HTH

    Sameer
    Last edited by Sameer; 11-05-2002 at 08:25 AM.

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