ORA-12541: TNS:no listener

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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..

[Former Member]

solved...

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

[Former Member]

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

[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,

[Former Member]

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.

[Former Member]

Dear All,

there is no Listener service in services.msc after 10.2.0.1 installation.now i installed its patch 10.2.0.4.0. i have to option for listener and SIDadm user.

1. i can create it manually

2. it will create automatically during installation of SAP

then both commands will work.

SQLPLUS "/@SID as sysdba" with administrator

SQLPLUS "/as sysdba" with SIDadm

fyi.... now error changed after installation of Oracle Patch 10.2.0.4

sqlplus "/@SID as sysdba" (OracleSID102iSQL*Plus , OracleSID102NSListener services are running)

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Mar 5 09:43:32 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:

why am i unable to login in sql mean why sql commands are not working after installation of ORACLE and its Patch?

while i am able to login in sql with sql both commands after sap installation

Regards,

[audunlea_hansen]

Hi!

Check Your tnsnames.ora. Seems like Your database note are configured there.

Try 'tnsping <SID>' to validate which tnsnames.ora/LDAP/ONAMES you are trying to use.

Regards

Audun

DBA

[Former Member]

Dear Audun,

the result of tnsping was :

>tnsping TST

TNS Ping Utility for 64-bit Windows: Version 10.2.0.1.0 
Used parameter files:
D:\oracle\TST\102\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP
.WORLD) (PROTOCOL = TCP) (HOST = Testing) (PORT = 1527))) (CONNECT_DATA = (SID =
 TST) (GLOBAL_NAME = TST.WORLD)))
TNS-12541: TNS:no listener

regards,

[audunlea_hansen]

Hi!

It seems like the listener doesn't run or runs but listening on wrong port on host = Testing (Is this the correct host name? or does your tnsnames.ora file point to wrong host for the entry?)

Go to the Testing-host and locate the listener.ora file, normally located in $ORACLE_HOME/network/admin

Check the file and verify port number it starts the listener on, are the same as in your tnsnames.ora.

Do a 'lsnrctl status listener' to check the listener.

Regards

Audun

DBA

[Former Member]

That's what I was looking for

Thanks !!

Tanaka

[Former Member]

Hi,

with administrator user and run

your are logging in as <SID>adm ??

Mark

[former_member266290]

Hi

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

lsnrctl start

Also update Oracle software patch.

[sunny_pahuja2]

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