Home » RDBMS Server » Networking and Gateways » Unable to Connect to Local oracle DB (2 Merged) (11g)
Unable to Connect to Local oracle DB (2 Merged) [message #566858] Thu, 20 September 2012 06:50 Go to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Hello,
Facing issue in connecting to local oracle db.
Able to logon via cmd prompt "sqlplus owner/owner" but not using "sqlplus owner/owner@orcl".
It goes in hang state.Tried through SQL Developer,same issue..Testing Connection keeps on moving...

Request if anyone can suggest way forward

Configuration details below:

Tnsnames.ora
========

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.corp.comp.com)
)
)

Listener.ora
============
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = F:\app\oracle

sqlnet.ora
==========
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsping orcl
============

Used parameter files:
F:\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.corp.
comp.com)))
OK (0 msec)

lsnrctl status
==============
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-SEP-2012 19:41
:17

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 20-SEP-2012 19:40:12
Uptime 0 days 0 hr. 1 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File F:\app\oracle\product\11.2.0\dbhome_1\network\admin\li
stener.ora
Listener Log File f:\app\oracle\diag\tnslsnr\LT-1\listener\alert\log
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

lsnrctl services
================
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-SEP-2012 19:42
:01

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:11 refused:0 state:ready
LOCAL SERVER
Service "orclXDB.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: LT-1, pid: 844>
(ADDRESS=(PROTOCOL=tcp)(HOST=LT-1.corp.comp.com)(PORT=56323))
The command completed successfully

pfile:
=======
*.db_domain='corp.comp.com'
*.db_name='orcl'

Computer Name : LT-1
Full computer name : LT-1.corp.comp.com
Domain : corp.comp.com


Thanks in advance.

[Updated on: Thu, 20 September 2012 06:54]

Report message to a moderator

Unable to Connect to Local oracle DB [message #566859 is a reply to message #566858] Thu, 20 September 2012 06:52 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Hello,
Facing issue in connecting to local oracle db.
Able to logon via cmd prompt "sqlplus owner/owner" but not using "sqlplus owner/owner@orcl".
It goes in hang state.Tried through SQL Developer,same issue..Testing Connection keeps on moving...

Request if anyone can suggest way forward

Configuration details below:

Tnsnames.ora
========

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.corp.comp.com)
)
)

Listener.ora
============
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = F:\app\oracle

sqlnet.ora
==========
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsping orcl
============

Used parameter files:
F:\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.corp.
comp.com)))
OK (0 msec)

lsnrctl status
==============
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-SEP-2012 19:41
:17

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 20-SEP-2012 19:40:12
Uptime 0 days 0 hr. 1 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File F:\app\oracle\product\11.2.0\dbhome_1\network\admin\li
stener.ora
Listener Log File f:\app\oracle\diag\tnslsnr\LT-1\listener\alert\log
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

lsnrctl services
================
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-SEP-2012 19:42
:01

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:11 refused:0 state:ready
LOCAL SERVER
Service "orclXDB.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: LT-1, pid: 844>
(ADDRESS=(PROTOCOL=tcp)(HOST=LT-1.corp.comp.com)(PORT=56323))
The command completed successfully

pfile:
=======
*.db_domain='corp.comp.com'
*.db_name='orcl'

Computer Name : LT-1
Full computer name : LT-1.corp.comp.com
Domain : corp.comp.com


Thanks in advance.
Re: Unable to Connect to Local oracle DB [message #566864 is a reply to message #566859] Thu, 20 September 2012 08:33 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
post content of "hosts" file
open Command Window & issue following OS commands

ping LT-1
ping LT-1.corp.comp.com
ping <IP# for above>

COPY the results from above then PASTE all back here
Re: Unable to Connect to Local oracle DB [message #566865 is a reply to message #566864] Thu, 20 September 2012 09:03 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Hosts
=====
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost




C:\Users\Administrator>ping LT-1

Pinging LT-1.corp.comp.com [fe80::e4b4:6ee4:9f0e:b142%13] with 32 bytes
of data:
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms

Ping statistics for fe80::e4b4:6ee4:9f0e:b142%13:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping LT-1.corp.comp.com

Pinging LT-1.corp.comp.com [fe80::e4b4:6ee4:9f0e:b142%13] with 32 bytes
of data:
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms
Reply from fe80::e4b4:6ee4:9f0e:b142%13: time<1ms

Ping statistics for fe80::e4b4:6ee4:9f0e:b142%13:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping 192.168.0.58

Pinging 192.168.0.58 with 32 bytes of data:
Reply from 192.168.0.58: bytes=32 time<1ms TTL=128
Reply from 192.168.0.58: bytes=32 time<1ms TTL=128
Reply from 192.168.0.58: bytes=32 time<1ms TTL=128
Reply from 192.168.0.58: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.58:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

Thanks for the prompt reply.Would like to add,the db was working properly 2 days back
until i restarted the system.
Re: Unable to Connect to Local oracle DB [message #566866 is a reply to message #566865] Thu, 20 September 2012 09:07 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
you need to make up your mind regarding hostname.
is it LT-1 or (HOST = localhost); since localhost is always 127.0.0.1
Re: Unable to Connect to Local oracle DB [message #566867 is a reply to message #566866] Thu, 20 September 2012 09:14 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
LT-1 is my computer's name.So should I be using LT-1 instead of localhost everywhere(tnsnames.ora and listener.ora)
Re: Unable to Connect to Local oracle DB [message #566868 is a reply to message #566867] Thu, 20 September 2012 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
>Would like to add,the db was working properly 2 days back until i restarted the system.

What changed?
Re: Unable to Connect to Local oracle DB [message #566869 is a reply to message #566868] Thu, 20 September 2012 09:26 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Don't remember having changed anything related to Oracle files.
Also my colleague's Local Db is working fine.After comparing found only 1 difference in the service name,instead of orcl.corp.comp.com, he is having only
orcl.Even that I changed in the pfile and spfile and tried with no success and hence reverted back.
Re: Unable to Connect to Local oracle DB [message #566879 is a reply to message #566869] Thu, 20 September 2012 10:44 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Blackswan, please do let me know if any more details required.Help me to get over this one.
Re: Unable to Connect to Local oracle DB [message #566880 is a reply to message #566879] Thu, 20 September 2012 11:01 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
Roses are red
Violet are blue
I am schizophrenic
& so am I

Am I LT-1
or
Am I localhost?

what results when hostname is LT-1 & listener is configured for localhost?

[Updated on: Thu, 20 September 2012 12:00]

Report message to a moderator

Re: Unable to Connect to Local oracle DB [message #566912 is a reply to message #566880] Thu, 20 September 2012 20:27 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member

ERROR:
ORA-12541: TNS:no listener
When Host = LT-1 in tnsnames.ora and Host= localhost in listener.ora.
Re: Unable to Connect to Local oracle DB [message #566913 is a reply to message #566912] Thu, 20 September 2012 20:43 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
no listener.ora file is required

lsnrctl stop
-- move, remove, rename, delete listener.ora file
lsnrctl start
-- wait 60+ seconds
lsnrctl status
lsnrctl service
sqlplus scott/tiger@orcl

COPY results from above then PASTE all back here
Re: Unable to Connect to Local oracle DB [message #566914 is a reply to message #566913] Thu, 20 September 2012 20:58 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
C:\Users\Administrator>lsnrctl stop

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2012 09:4
:53

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

C:\Users\Administrator>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2012 09:5
:00

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Log messages written to f:\app\oracle\diag\tnslsnr\LT-1\listener\alert\log.
ml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LT-1.corp.comp.
om)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 21-SEP-2012 09:50:04
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File f:\app\oracle\diag\tnslsnr\LT-1\listener\alert\lo
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LT-1.corp.comp.com)(PORT=15
1)))
The listener supports no services
The command completed successfully

C:\Users\Administrator>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2012 09:5
:32

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 21-SEP-2012 09:50:04
Uptime 0 days 0 hr. 3 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File f:\app\oracle\diag\tnslsnr\LT-1\listener\alert\lo
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LT-1.corp.comp.com)(PORT=15
1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "orcl.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Administrator>lsnrctl services

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 21-SEP-2012 09:5
:37

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "orcl.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:31 refused:0 state:ready
LOCAL SERVER
Service "orclXDB.corp.comp.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: LT-1, pid: 3256>
(ADDRESS=(PROTOCOL=tcp)(HOST=LT-1.corp.comp.com)(PORT=53219))
The command completed successfully

C:\Users\Administrator>sqlplus scott/tiger@orcl

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 21 09:54:01 2012

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



No response after this...
Re: Unable to Connect to Local oracle DB [message #566915 is a reply to message #566914] Thu, 20 September 2012 21:08 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
>ORCL =
>(DESCRIPTION =
>(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

modify tnsnames.ora change line above to be like below
ADDRESS = (PROTOCOL = TCP)(HOST =LT-1.corp.comp.com )(PORT = 1521))


>(CONNECT_DATA =
>(SERVER = DEDICATED)
>(SERVICE_NAME = orcl.corp.comp.com)
Re: Unable to Connect to Local oracle DB [message #566916 is a reply to message #566915] Thu, 20 September 2012 21:18 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Did as you mentioned,but still same...
Re: Unable to Connect to Local oracle DB [message #566923 is a reply to message #566916] Thu, 20 September 2012 22:55 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
post content of sqlnet.ora
Re: Unable to Connect to Local oracle DB [message #566924 is a reply to message #566923] Thu, 20 September 2012 23:04 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
# sqlnet.ora Network Configuration File: F:\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# 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)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Re: Unable to Connect to Local oracle DB [message #566925 is a reply to message #566924] Thu, 20 September 2012 23:09 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
issue the command below

sqlplus scott/tiger@'LT-1:1521/orcl'

COPY the results from command above
Re: Unable to Connect to Local oracle DB [message #566926 is a reply to message #566925] Thu, 20 September 2012 23:11 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Re: Unable to Connect to Local oracle DB [message #566927 is a reply to message #566926] Thu, 20 September 2012 23:14 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
Issue the command below

sqlplus scott/tiger@'LT-1:1521/orcl.corp.comp.com'

COPY the results from command above
Re: Unable to Connect to Local oracle DB [message #566928 is a reply to message #566927] Thu, 20 September 2012 23:20 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Nothing is coming...

C:\Users\Administrator>sqlplus scott/tiger@'LT-1:1521/orcl.corp.comp.com
'

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 21 12:18:17 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.
Re: Unable to Connect to Local oracle DB [message #566930 is a reply to message #566928] Thu, 20 September 2012 23:44 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
Log messages written to f:\app\oracle\diag\tnslsnr\LT-1\listener\alert\log.xml

post last 50 lines from file above
Re: Unable to Connect to Local oracle DB [message #566933 is a reply to message #566930] Fri, 21 September 2012 00:00 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
<msg time='2012-09-21T12:56:19.866+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=LT-1$))(SERVICE_NAME=orcl.corp.comp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61154)) * establish * orcl.corp.comp.com * 0
</txt>
</msg>
<msg time='2012-09-21T12:56:22.976+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:22 * service_update * orcl * 0
</txt>
</msg>
<msg time='2012-09-21T12:56:23.706+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=LT-1$))(SERVICE_NAME=orcl.corp.comp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61159)) * establish * orcl.corp.comp.com * 0
</txt>
</msg>
<msg time='2012-09-21T12:56:25.386+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=LT-1$))(SERVICE_NAME=orcl.corp.comp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61161)) * establish * orcl.corp.comp.com * 0
</txt>
</msg>
<msg time='2012-09-21T12:56:27.076+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:27 * ping * 0
</txt>
</msg>
<msg time='2012-09-21T12:56:27.206+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:27 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT =1521)))(VERSION=186646784)) * status * 0
</txt>
</msg>
<msg time='2012-09-21T12:56:35.346+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=LT-1$))(SERVICE_NAME=orcl.corp.comp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61167)) * establish * orcl.corp.comp.com * 0
</txt>
</msg>
<msg time='2012-09-21T12:56:39.196+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='LT-1'
host_addr='fe80::64db:71a:b70:1fe2%10'>
<txt>21-SEP-2012 12:56:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=LT-1$))(SERVICE_NAME=orcl.corp.comp.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61168)) * establish * orcl.corp.comp.com * 0
</txt>
</msg>
Re: Unable to Connect to Local oracle DB [message #566960 is a reply to message #566933] Fri, 21 September 2012 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
>Listening Endpoints Summary...
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LT-1.corp.comp.com)(PORT=1521)))
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
>Services Summary...
I am not sure how you managed to do above, but log file shows listener only responding on/to 127.0.0.1
Re: Unable to Connect to Local oracle DB [message #566961 is a reply to message #566960] Fri, 21 September 2012 09:21 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Don't know.Suggest some solution please.I tried lot many things, like changing spfile,pfile,checking memory utilization,port blockage.
Don't know where its going.
Re: Unable to Connect to Local oracle DB [message #566962 is a reply to message #566961] Fri, 21 September 2012 09:54 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
post results from like below


Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Windows\System32>hostname
bcm_laptop

C:\Windows\System32>
Re: Unable to Connect to Local oracle DB [message #566963 is a reply to message #566962] Fri, 21 September 2012 10:05 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
It pops up with a Error:
The procedure entry point s_perror could not be located in the dynamic link library MSWSOCK.dll
Re: Unable to Connect to Local oracle DB [message #566964 is a reply to message #566963] Fri, 21 September 2012 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
What version & edition of Windows is running this system?
Re: Unable to Connect to Local oracle DB [message #566965 is a reply to message #566964] Fri, 21 September 2012 10:11 Go to previous messageGo to next message
jb12
Messages: 17
Registered: September 2012
Junior Member
Windows 7 Enterprise
Service Pack 1,32-bit OS
Re: Unable to Connect to Local oracle DB [message #566967 is a reply to message #566965] Fri, 21 September 2012 11:42 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
http://www.youneedabudget.com/forum/ynab-f96/hostname-exe-entry-point-not-found-error-t17087.html
Re: Unable to Connect to Local oracle DB [message #566972 is a reply to message #566967] Fri, 21 September 2012 13:09 Go to previous message
jb12
Messages: 17
Registered: September 2012
Junior Member
BlackSwan,
Thanks a ton,It's working now.
After going through the link, realised that I had done a cleanup of the system using some software.
Would have caused some problem and when I restarted the system ,if took effect.
I did a system restore and now able to connect to db using sql developer.

Once again ,thanks for your time and expertise.
Previous Topic: Intel server board and application server help
Next Topic: Can same db runs on different hosts.
Goto Forum:
  


Current Time: Sun Dec 28 20:35:05 CST 2014

Total time taken to generate the page: 0.07977 seconds