Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2006
    Posts
    6

    Unanswered: error message ora-12541:tns:no listener

    Hello:
    I am a new user of oracle. After I installed oracle. I started creating a repository. I launched Enterprise Manager Configuration Assistant. The first 6 steps were done. Then the 7 step - select database for repository, I got a error message as follows:

    ora-12541:tns:no listener

    I already have a database named DB01. which is the database I selected for repository. But it seems I could not connect to it. Please help . Thank you.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Is database up? Can you connect to it through SQL*Plus? Is listener running? What do you see when TNSNAMES.ORA entry is compared to the appropriate LISTENER.ORA file?

  3. #3
    Join Date
    Mar 2006
    Posts
    6
    I cant connect it thru SQL* plus. The oracle is located in localhost. Here is my tnsnames.ora file:
    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    OEMREP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = summer)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = OEMREP)
    )
    )

    DB01 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = summer)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DB01)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = summer)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    Here is my listener file :
    # LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
    # Generated by Oracle configuration tools.

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

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = DB01)
    (ORACLE_HOME = C:\oracle\ora92)
    (SID_NAME = DB01)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = OEMREP)
    (ORACLE_HOME = C:\oracle\ora92)
    (SID_NAME = OEMREP)
    )
    )

    I think they are the correct, isnt it?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What message do you get when trying to connect through SQL*Plus?

    > sqlplus system/its_password@db01

    What is the result of this command:

    > tnsping db01

    When you look at the OS services, what are status of the listener and database service?

  5. #5
    Join Date
    Mar 2006
    Posts
    4
    I am currently having the same error.
    Can anyone help me out?
    OS: Fedora Core 4
    DB: Oracle 10g XE

    Listener.ora file
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle-home/oracle/xe/app/oracle/product/10.2.0/server)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)

    tnsnames.ora
    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    can anyone help me out? i am fairly new to linux and oracle, the problem is, i have to have it up and running end of week

    Novice level help will truly be appreciated

  6. #6
    Join Date
    Mar 2006
    Posts
    4
    I am currently having the same error.
    Can anyone help me out?
    OS: Fedora Core 4
    DB: Oracle 10g XE

    Listener.ora file
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle-home/oracle/xe/app/oracle/product/10.2.0/server)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)

    tnsnames.ora
    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    can anyone help me out? i am fairly new to linux and oracle, the problem is, i have to have it up and running end of week

    Novice level help will truly be appreciated

  7. #7
    Join Date
    Mar 2006
    Posts
    6
    Thank you! I ve done. big help

  8. #8
    Join Date
    Mar 2006
    Posts
    4
    anyone?

    am not sure if the installer automatically created a default database for me

  9. #9
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Rewritten post #4:

    What message do you get when trying to connect through SQL*Plus?

    > sqlplus system/its_password@xe

    What is the result of this command:

    > tnsping xe

    When you look at the OS services, what is status of the listener and database service?

Posting Permissions

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