Skip to Content
avatar image
Former Member

ORA-12541: TNS:no listener

Dear All,

I installed Oracle Software(10.2.0.1.0) and when i try to login with administrator user and run

SQLPLUS "/@SID as sysdba" then getting following error.

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 3 16:39:23 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12541: TNS:no listener

Enter user-name:

FYI...

1. There is only one file sqlnet.ora in Directory:\oracle\SID\Ora_Ver\NETWORK\ADMIN and consist following txt.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

2. the Net Manager --> Oracle Net Configuration --> Service Naming is blank mean there is nothing under it.

3. the OracleSID102iSQLPlus* service is running now

would anyone guide me about this error and how can i successful login.

Regards,

Diya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 11, 2011 at 05:46 AM

    Direct installation/upgrade is possible, you can directly install 10.2.0.4 on 10.2.0.1.

    And yes follow the Installation/Upgrade guide (10g) to perform the upgrade and post-upgrade activities.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 04, 2011 at 11:57 AM
    1. There is only one file sqlnet.ora in Directory:\oracle\SID\Ora_Ver\NETWORK\ADMIN and consist following txt.
    
    
    # This file is actually generated by netca. But if customers choose to 
    # install "Software Only", this file wont exist and without the native 
    # authentication, they will not be able to connect to the database on NT.
     
    SQLNET.AUTHENTICATION_SERVICES = (NTS)

    I installed Oracle Software(10.2.0.1.0) and when i try to login with administrator user and run

    I would suggest you to read the installation guide. [http://service.sap.com/instguides] and PAM at http://service.sap.com/pam for supported combinations. Your listener error is due to missing listener.ora, tnsnames.ora from that directory.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 05, 2011 at 08:38 AM

    Always follow the standard Installation guide, There is a point that says to install Oracle software and patch whenever SAPINST looks for and not before starting the SAPINST.

    I would suggest you to uninstall Oracle, Start a fresh installation of SAP (+Oracle) as process mentioned in Installation guide.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi Nick,

      would you confirm me about Oracle patch.. mean installation of Oracle and SAP is successfully completed. now i have to install Oracle patch and run upgrade commands or no need of oracle patch.

      and

      may i install directly oracle patch from 10.2.0.1 to 10.2.0.4 or first i have to go on 10.2.0.2 then on 10.2.0.4.

      Regards,

  • avatar image
    Former Member
    Mar 04, 2011 at 07:23 AM

    Hi,

    First of all, oracle 10.2.0.1 is not supported for SAP. Also, please start your listener with below command:

    lsnrctl start

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 04, 2011 at 07:47 AM

    Hi

    As suggested by Sunny, login as ora<SID> user and start linstener with command

    lsnrctl start

    Also update Oracle software patch.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 04, 2011 at 10:28 AM

    Hi,

    with administrator user and run

    your are logging in as <SID>adm ??

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2011 at 09:44 AM

    solved...

    Tested... we can't login in SQL after oracle installation. we can after sap installation because oracle server created during sap installation..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2011 at 09:44 AM

    thx to everyone

    Tested... we can't login in SQL after oracle installation while we can after sap installation because oracle server created during sap installation..

    Add comment
    10|10000 characters needed characters exceeded