Home » RDBMS Server » Networking and Gateways » TNS-12541 TNS no listener issue (Oracle 11g)
TNS-12541 TNS no listener issue [message #654036] Tue, 26 July 2016 03:41 Go to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
Hi friends,

My production server got rebooted due to some unplanned activities.After that i am unable to connect to the database.There is some issue in listener.When i check the listener status i am getting the following error

C:\APLM\app\infodba\product\11.2.0\dbhome_1\BIN>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-JUL-2016 13:59
:26

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error

My listener service is already running.PFA for snapshot
./fa/13206/0/
./fa/13205/0/

I have given my listener.ora,TNSNAMES.ora and sqlnet.ora files here

LISTENER.ORA
# listener.ora Network Configuration File: C:\APLM\app\infodba\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\APLM\app\infodba\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\APLM\app\infodba\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEAMCENTER.amwasia.com)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\APLM\app\infodba

TNSNAMES.ORA
# tnsnames.ora Network Configuration File: C:\APLM\app\infodba\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PEP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEAMCENTER.amwasia.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PEP)
)
)
TCRA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEAMCENTER.amwasia.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TCRA)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

SQLNET.ORA
# 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 = (NONE)

Please tell me the solution

Thanks in advance
  • Attachment: serv.JPG
    (Size: 19.44KB, Downloaded 497 times)
Re: TNS-12541 TNS no listener issue [message #654038 is a reply to message #654036] Tue, 26 July 2016 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 65200
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Try
lsnrctl start
Be sure "TEAMCENTER.amwasia.com" is your local host.

Please read How to use [code] tags and make your code easier to read.

Re: TNS-12541 TNS no listener issue [message #654049 is a reply to message #654036] Tue, 26 July 2016 06:55 Go to previous messageGo to next message
EdStevens
Messages: 848
Registered: September 2013
Senior Member
In addition to Michael's comment (he beat me to it !) please note that tnsnames.ora has nothing whatsoever to do with the listener. tnsnames.ora is an address book for client processes. The listener is the telephone switchboard. If the switchboard is not working (your case) then looking at your address book for clues (or asking others to look at it) is a waste of time.
Re: TNS-12541 TNS no listener issue [message #654078 is a reply to message #654038] Wed, 27 July 2016 00:37 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
Hi Michel
I had tried lsnrctl start
It is taking too much time and again returning TNS-12541 no listener issue.

Any other solution

Note:
I had used telnet command to see the port is working or not.

Sometimes it is working fine and again not working

what could be the issue

Re: TNS-12541 TNS no listener issue [message #654082 is a reply to message #654078] Wed, 27 July 2016 00:48 Go to previous messageGo to next message
Frank Naude
Messages: 4531
Registered: April 1998
Senior Member
If you have a firewall on the server, disable it.
Can your ping the server name: "ping TEAMCENTER.amwasia.com"?
Try with a different port number (for example, change 1521 to 1527 in listener.ora).
Re: TNS-12541 TNS no listener issue [message #654102 is a reply to message #654082] Wed, 27 July 2016 01:54 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
hi frank

I can able to ping teamcenter.amwasia.com
It is working fine..

Regarding port change I had changed port to 1523...
At that time listener started.
I had imported db after that
and restarted the server.

Then again listener is not working..with port 1523 also..

With my obeservations
listener is starting for some time and again it is not working regardless of port.
Re: TNS-12541 TNS no listener issue [message #654103 is a reply to message #654102] Wed, 27 July 2016 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 65200
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You didn't answer to this question:

Quote:
Be sure "TEAMCENTER.amwasia.com" is your local host.

Re: TNS-12541 TNS no listener issue [message #654106 is a reply to message #654102] Wed, 27 July 2016 02:04 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Disable your firewall.
Re: TNS-12541 TNS no listener issue [message #654109 is a reply to message #654103] Wed, 27 July 2016 02:27 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
hi michel,

teamcenter.amwasia.com is my locla host
Re: TNS-12541 TNS no listener issue [message #654110 is a reply to message #654106] Wed, 27 July 2016 02:31 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
My windows firewall is already disabled

./fa/13209/0/
Re: TNS-12541 TNS no listener issue [message #654112 is a reply to message #654110] Wed, 27 July 2016 02:50 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Try This:

Start windows cmd.exe as Administrator and execute command,

LSNRCTL start LISTENER

Did you change your hostname?
Did you install any other oracle software on your machine?
Re: TNS-12541 TNS no listener issue [message #654118 is a reply to message #654112] Wed, 27 July 2016 04:00 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
hi gazim

I tried the command lsnrctl start listener

and this is my result

./fa/13211/0/

now it is protocol adapter error

I didnt changed any hostname

I have only oracle 11g installed in my server

  • Attachment: 123.JPG
    (Size: 31.93KB, Downloaded 440 times)
Re: TNS-12541 TNS no listener issue [message #654121 is a reply to message #654118] Wed, 27 July 2016 04:14 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Can you please show value of your ORACLE_HOME variable?

Try as Administrator:

LSNRCTL stop
LSNRCTL start
Re: TNS-12541 TNS no listener issue [message #654123 is a reply to message #654121] Wed, 27 July 2016 04:26 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
I have set oracle_home in same cmd window.

and done LSNRCTL STOP AND LSNRCTL START

here is the result

./fa/13212/0/
  • Attachment: 4444.jpg
    (Size: 54.81KB, Downloaded 445 times)
Re: TNS-12541 TNS no listener issue [message #654129 is a reply to message #654123] Wed, 27 July 2016 04:57 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
What is your search path set to? Show these, please:

echo %PATH%
where lsnrctl
Re: TNS-12541 TNS no listener issue [message #654130 is a reply to message #654129] Wed, 27 July 2016 05:04 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
this is my result for echo %PATH%

./fa/13213/0/

my lsnrctl is in

My listener.ora,TNSNAMES.ora and sqlnet.ora files are in

c:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN
  • Attachment: 5555.JPG
    (Size: 34.92KB, Downloaded 407 times)
Re: TNS-12541 TNS no listener issue [message #654150 is a reply to message #654130] Wed, 27 July 2016 08:25 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
Windows Services for both database & listener must be started & running, before issuing lsnrctl start

https://www.google.com/search?q=64-bit+Windows+Error%3A+61%3A+Unknown+error
Re: TNS-12541 TNS no listener issue [message #654159 is a reply to message #654150] Wed, 27 July 2016 23:49 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
Both the services (OracledbconsolePEP and oracleoraDb11g_home1TNSListener) are already started in services.msc

./fa/13215/0/
  • Attachment: 666.JPG
    (Size: 67.76KB, Downloaded 373 times)
Re: TNS-12541 TNS no listener issue [message #654163 is a reply to message #654159] Thu, 28 July 2016 00:18 Go to previous messageGo to next message
qazims92
Messages: 37
Registered: July 2016
Location: Lahore Pakistan
Member
Can you please show the output of following command:

LSNRCTL show current_listener
Re: TNS-12541 TNS no listener issue [message #654165 is a reply to message #654163] Thu, 28 July 2016 00:22 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
This is the obtained result

./fa/13216/0/
  • Attachment: 7777.jpg
    (Size: 67.65KB, Downloaded 371 times)
Re: TNS-12541 TNS no listener issue [message #654174 is a reply to message #654165] Thu, 28 July 2016 01:06 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
I would stop and remove that service, which will also stop (but not remove) the listener. Then start the listener, which will re-create the service. For example,

sc stop OracleOraDb11g_home1TNSListener
sc delete OracleOraDb11g_home1TNSListener
lsnrctl start listener

I think you may have messed up the permissions, which is why you can't administer it.
Re: TNS-12541 TNS no listener issue [message #654179 is a reply to message #654174] Thu, 28 July 2016 01:42 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
hi john i had done the command which you said.Please refer the screenshot.Can you explain the lines which i highlighted within red box.Whether the listenerCLREExtProc is listening

./fa/13217/0/
  • Attachment: 8888.JPG
    (Size: 121.46KB, Downloaded 357 times)
Re: TNS-12541 TNS no listener issue [message #654180 is a reply to message #654179] Thu, 28 July 2016 01:45 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
I wish you would stop posting these screen shots. They are hard to read and some people won't/can't read them for security reasons. Rather use copy/paste and [code] tags as I did, How to use [code] tags and make your code easier to read
Re: TNS-12541 TNS no listener issue [message #654181 is a reply to message #654180] Thu, 28 July 2016 01:49 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
Ok thanks for that John.Here is my code

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>sc stop OracleOraDb11g
_home1TNSListener

SERVICE_NAME: OracleOraDb11g_home1TNSListener
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 3  STOP_PENDING
                                (STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>sc delete OracleOraDb1
1g_home1TNSListener
[SC] DeleteService SUCCESS

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl start listener


LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 28-JUL-2016 11:54
:30

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

Failed to open service <OracleOraDb11g_home1TNSListener>, error 1060.
TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADM
IN\listener.ora
Log messages written to c:\aplm\app\infodba\diag\tnslsnr\TEAMCENTER\listener\ale
rt\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                28-JUL-2016 11:55:22
Uptime                    0 days 0 hr. 5 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\AD
MIN\listener.ora
Listener Log File         c:\aplm\app\infodba\diag\tnslsnr\TEAMCENTER\listener\a
lert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TEAMCENTER.amwasia.com)(PORT=1521)))

Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TCRA" has 1 instance(s).
  Instance "TCRA", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>



This is my result..

[Updated on: Thu, 28 July 2016 01:50]

Report message to a moderator

Re: TNS-12541 TNS no listener issue [message #654182 is a reply to message #654181] Thu, 28 July 2016 01:51 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
Problem solved?
Re: TNS-12541 TNS no listener issue [message #654183 is a reply to message #654182] Thu, 28 July 2016 01:55 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
No when i again checked the lsnrctl status

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 28-JUL-2016 12:22
:04

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TEAMCENTER.amwasia.com)(
PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>

Re: TNS-12541 TNS no listener issue [message #654184 is a reply to message #654183] Thu, 28 July 2016 02:11 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
I would still like to see the output of
where lsnrctl
Also,
whoami /groups
And lastly, does the listener actually work OK? Can you connect through it?
Re: TNS-12541 TNS no listener issue [message #654186 is a reply to message #654184] Thu, 28 July 2016 02:16 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
the result for where lsnrctl


C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>where lsnrctl
C:\APLM\app\infodba\product\11.2.0\dbhome_1\BIN\LSNRCTL.EXE

and whoami /groups is


C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>whoami /groups

GROUP INFORMATION
-----------------

Group Name                                                    Type             S
ID                                          Attributes

============================================================= ================ =
=========================================== ====================================
===========================
Everyone                                                      Well-known group S
-1-1-0                                      Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\Local account and member of Administrators group Well-known group S
-1-5-114                                    Mandatory group, Enabled by default,
 Enabled group
TEAMCENTER\ora_dba                                            Alias            S
-1-5-21-1693983369-53828479-2588551842-1001 Mandatory group, Enabled by default,
 Enabled group
BUILTIN\Administrators                                        Alias            S
-1-5-32-544                                 Mandatory group, Enabled by default,
 Enabled group, Group owner
BUILTIN\Users                                                 Alias            S
-1-5-32-545                                 Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\REMOTE INTERACTIVE LOGON                         Well-known group S
-1-5-14                                     Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\INTERACTIVE                                      Well-known group S
-1-5-4                                      Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\Authenticated Users                              Well-known group S
-1-5-11                                     Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\This Organization                                Well-known group S
-1-5-15                                     Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\Local account                                    Well-known group S
-1-5-113                                    Mandatory group, Enabled by default,
 Enabled group
LOCAL                                                         Well-known group S
-1-2-0                                      Mandatory group, Enabled by default,
 Enabled group
NT AUTHORITY\NTLM Authentication                              Well-known group S
-1-5-64-10                                  Mandatory group, Enabled by default,
 Enabled group
Mandatory Label\High Mandatory Level                          Label            S
-1-16-12288                                 Mandatory group, Enabled by default,
 Enabled group

C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN>


my listener is started in services but it still showing no listener error
Re: TNS-12541 TNS no listener issue [message #654187 is a reply to message #654186] Thu, 28 July 2016 02:18 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
That all looks OK.

Second time: is the listener actually working? Can you connect through it?
Re: TNS-12541 TNS no listener issue [message #654188 is a reply to message #654187] Thu, 28 July 2016 02:20 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
I cant understand actually what you mean...

tell me any command to ensure whether it is actually working or not
Re: TNS-12541 TNS no listener issue [message #654190 is a reply to message #654188] Thu, 28 July 2016 02:21 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
If you do not know how to logon to your database, this whole "problem" is of no importance.
Re: TNS-12541 TNS no listener issue [message #654193 is a reply to message #654190] Thu, 28 July 2016 02:25 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
when i try sqlplus command now it is showing connected


C:\>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 28 12:51:41 2016

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

Enter user-name: infodba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> connect infodba/infodba as sysdba
Connected.
SQL>


bit listener status is still showing no listener error
Re: TNS-12541 TNS no listener issue [message #654194 is a reply to message #654193] Thu, 28 July 2016 02:32 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
Do you know how to logon through a listener? If not, the whole issue is not relevant to anything.
Re: TNS-12541 TNS no listener issue [message #654196 is a reply to message #654194] Thu, 28 July 2016 03:33 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
hi john,

I am teamcenter PLM administrator.I dont know much about db and listener..I dont have anybody to support about this.

So please tell me the procedure

Re: TNS-12541 TNS no listener issue [message #654200 is a reply to message #654196] Thu, 28 July 2016 04:43 Go to previous messageGo to next message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
What does this yield:
C:\> sqlplus infodba/infodba@pep as sysdba
Re: TNS-12541 TNS no listener issue [message #654202 is a reply to message #654200] Thu, 28 July 2016 05:05 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
hi gazzag, thanks for responding

this is what i am getting for the command you mentioned


C:\>sqlplus infodba/infodba@PEP as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 28 15:32:39 2016

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

ERROR:
ORA-12541: TNS:no listener


Enter user-name: infodba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:


Re: TNS-12541 TNS no listener issue [message #654203 is a reply to message #654202] Thu, 28 July 2016 05:14 Go to previous messageGo to next message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
Also:
C:\> set | sort
Re: TNS-12541 TNS no listener issue [message #654204 is a reply to message #654202] Thu, 28 July 2016 05:16 Go to previous messageGo to next message
John Watson
Messages: 7148
Registered: January 2010
Location: Global Village
Senior Member
This is looking hopeless: you do not appear to have the basic knowledge needed to address the problem. In this case, for example, it is pretty obvious that gazzag misread your post. You shopuld be using the tns names entry TCRA, not PEP.
You really do need to be able to fix that of thing yourself.
Re: TNS-12541 TNS no listener issue [message #654205 is a reply to message #654203] Thu, 28 July 2016 05:16 Go to previous messageGo to next message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
for set | sort the result came is


C:\>set | sort
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\infodba\AppData\Roaming
BOOKSHELF=C:\IFOR\WIN\BIN\EN_US
CLIENTNAME=AMW-WS-141
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=TEAMCENTER
ComSpec=C:\Windows\system32\cmd.exe
FMS_HOME=C:\APLM\Siemens\TEAMCE~1\fcc
FP_NO_HOST_CHECK=NO
HELP=C:\IFOR\WIN\BIN
HOMEDRIVE=C:
HOMEPATH=\Users\infodba
I4_INSTALL_DRIVE=C:
I4_LANG=EN_US
IPF_PATH32=C:\IFOR\WIN\BIN\EN_US
JAVA_HOME=C:\Program Files\Java\jdk1.6.0_07
LOCALAPPDATA=C:\Users\infodba\AppData\Local
LOGONSERVER=\\TEAMCENTER
NLSPATH=C:\IFOR\LS\MSG\%L\%N
NUMBER_OF_PROCESSORS=16
ORACLE_HOME=C:\APLM\app\infodba\product\11.2.0\dbhome_1
ORACLE_SID=PEP
OS=Windows_NT
Path=C:\APLM\app\infodba\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Wind
ows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\APLM
\Siemens\Teamcenter8.3\Visualization\Products\Mockup\ClearanceDB;C:\Program File
s\Java\jdk1.6.0_07\jre\bin;C:\Program Files (x86)\7-Zip;C:\APLM\Siemens\NX7.5\UG
II;C:\IFOR\WIN\BIN;C:\IFOR\WIN\BIN\EN_US;C:\Program Files (x86)\Dell\SysMgt\oma\
bin;C:\Program Files (x86)\Dell\SysMgt\idrac
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=2c02
ProgramData=C:\ProgramData
ProgramFiles(x86)=C:\Program Files (x86)
ProgramFiles=C:\Program Files
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC=C:\Users\Public
SESSIONNAME=RDP-Tcp#0
SystemDrive=C:
SystemRoot=C:\Windows
TC_ROOT=C:\APLM\Siemens\Teamcenter8
TCVIS_CLUSTER_PATH=C:\APLM\Siemens\Teamcenter8.3\Visualization\Products\Mockup\V
isView.exe
TEMP=C:\Users\infodba\AppData\Local\Temp\2
TMP=C:\Users\infodba\AppData\Local\Temp\2
TNS_ADMIN=C:\APLM\app\infodba\product\11.2.0\dbhome_1\NETWORK\ADMIN
UGII_BASE_DIR=C:\APLM\Siemens\NX7.5
UGII_LANG=english
UGII_ROOT_DIR=C:\APLM\Siemens\NX7.5\UGII\
UGS_LICENSE_BUNDLE=NX13300N;P1
UGS_LICENSE_SERVER=28000@amwnx,28000@TEAMCENTER,28000@amwcae
USER_FILE=C:\APLM\AMW_ENV\TC\AMWSave.dll
USERDOMAIN=TEAMCENTER
USERNAME=infodba
USERPROFILE=C:\Users\infodba
windir=C:\Windows

Re: TNS-12541 TNS no listener issue [message #654207 is a reply to message #654204] Thu, 28 July 2016 05:19 Go to previous messageGo to previous message
ganesh_sun87@yahoo.co.in
Messages: 22
Registered: July 2016
Location: Mumbai
Junior Member
john

my SID is PEP only which i used to connect it to my teamcenter application..

also i checked my port which is listening..

but i am getting TNS adapter error...

If you come across this problem,please answer me
Previous Topic: Need help regarding oracle database gateway for ODBC
Next Topic: SCAN Listener issue while connecting to two node RAC
Goto Forum:
  


Current Time: Tue Nov 21 02:15:12 CST 2017

Total time taken to generate the page: 0.01741 seconds