OraFAQ Forum: Networking and Gateways » ORA-12514: TNS:listener does not currently know of service requested in connect

Home » RDBMS Server » Networking and Gateways » ORA-12514: TNS:listener does not currently know of service requested in connect

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12514: TNS:listener does not currently know of service requested in connect [message #188273]

Thu, 17 August 2006 14:02

sivaparam
Messages: 16
Registered: March 2005

Junior Member

Hi
I have created four net service name for my oracle instance "orcl"
ie. ORCL, MKT, SAL and HRS
ORCL, MKT and SAL is configured under LISTENER
HRS is configured under LISTENER1

The net service name "HRS" is not working and throwing error "ORA-12514 ", rest all fine. The detailed error message is appended below.

Appreciate your help in addressing this issue.
Please help, I new and learning.

Below I have provided the following information.

- Exception:
- Listener Status:
- listener Service
- tnsnames.ora
- listener.ora
- tnsping of orcl
- listener.log and listener1.log

Exception:
=====================================
C:\Documents and Settings\HP_Administrator>sqlplus system/oracle@hrs

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 17 10:47:05 2006

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

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

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Listener Status:
=====================================
LSNRCTL> status listener
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias listener1
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 17-AUG-2006 10:43:11
Uptime 0 days 0 hr. 4 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_2\network\admin\listener.o
ra
Listener Log File C:\oracle\product\10.2.0\db_2\network\log\listener1.lo
g
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1524)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> l
NL-00853: undefined command "l". Try "help"
LSNRCTL>
LSNRCTL>

LSNRCTL> status listener1
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 17-AUG-2006 10:45:47
Uptime 0 days 0 hr. 1 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\db_2\network\admin\listener.o
ra
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1523)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>

listener Service
=====================================

LSNRCTL> services listener
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
LSNRCTL>
LSNRCTL>
LSNRCTL>

LSNRCTL> services listener1
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:43 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" 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:1002 state:ready
DISPATCHER <machine: PERI, pid: 2536>
(ADDRESS=(PROTOCOL=tcp)(HOST=peri)(PORT=1036))
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:43 refused:0 state:ready
LOCAL SERVER
The command completed successfully
LSNRCTL>

tnsnames.ora
=====================================
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

MKT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

SAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

HRS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102 )(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl )
)
)

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

listener.ora
=====================================

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1523))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1522))
)
)

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1524))
)
)

LOGGING_LISTENER = OFF

tnsping of orcl and hrs ie. tnsping orcl and tnsping hrs
=====================================
C:\Documents and Settings\HP_Administrator>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-AUG-2
006 10:56:13

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

Used parameter files:
C:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
1.102)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))
)
OK (20 msec)

C:\Documents and Settings\HP_Administrator>
C:\Documents and Settings\HP_Administrator>
C:\Documents and Settings\HP_Administrator>tnsping hrs

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-AUG-2
006 10:56:23

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

Used parameter files:
C:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
1.102)(PORT = 1524)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))
)
OK (10 msec)

C:\Documents and Settings\HP_Administrator>
C:\Documents and Settings\HP_Administrator>
C:\Documents and Settings\HP_Administrator>
C:\Documents and Settings\HP_Administrator>
C:\Documents and Settings\HP_Administrator>
C:\Documents and Settings\HP_Administrator>tnsping mkt

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-AUG-2
006 10:56:35

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

Used parameter files:
C:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
1.102)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))
)
OK (20 msec)

listener.log and listener1.log
=====================================

listener.log
---------------------

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-AUG-2006 11:25:16

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

System parameter file is C:\oracle\product\10.2.0\db_2\network\admin\listener.ora
Log messages written to C:\oracle\product\10.2.0\db_2\network\log\listener.log
Trace information written to C:\oracle\product\10.2.0\db_2\network\trace\listener.trc
Trace level is currently 0

Started with pid=1956
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1523)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1522)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
17-AUG-2006 11:25:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=HP_Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169869568)) * status * 0
17-AUG-2006 11:25:32 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3725)) * establish * orcl * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
17-AUG-2006 11:25:47 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3726)) * establish * orcl * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
17-AUG-2006 11:25:52 * service_register * orcl * 0
17-AUG-2006 11:26:02 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3730)) * establish * orcl * 0
17-AUG-2006 11:26:18 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3732)) * establish * orcl * 0
17-AUG-2006 11:26:33 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3735)) * establish * orcl * 0
17-AUG-2006 11:26:34 * service_update * orcl * 0
17-AUG-2006 11:26:48 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3738)) * establish * orcl * 0
17-AUG-2006 11:26:49 * service_update * orcl * 0
17-AUG-2006 11:26:54 * ping * 0
17-AUG-2006 11:26:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.102)( PORT=1522)))(VERSION=169869568)) * status * 0
17-AUG-2006 11:27:01 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=PERI)(USER =SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3741)) * establish * orcl * 0
17-AUG-2006 11:27:04 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3745)) * establish * orcl * 0
17-AUG-2006 11:27:06 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\sqlplus.exe)(HOST=PERI)(USER=HP_Ad ministrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3746)) * establish * orcl * 0
17-AUG-2006 11:27:07 * service_update * orcl * 0
17-AUG-2006 11:27:19 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3748)) * establish * orcl * 0
17-AUG-2006 11:27:34 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3749)) * establish * orcl * 0
17-AUG-2006 11:27:49 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3752)) * establish * orcl * 0
17-AUG-2006 11:28:05 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3754)) * establish * orcl * 0
17-AUG-2006 11:28:20 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3757)) * establish * orcl * 0
17-AUG-2006 11:28:35 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3758)) * establish * orcl * 0
17-AUG-2006 11:28:50 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3761)) * establish * orcl * 0
17-AUG-2006 11:29:04 * service_update * orcl * 0
17-AUG-2006 11:29:06 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3764)) * establish * orcl * 0
17-AUG-2006 11:29:10 * service_update * orcl * 0
17-AUG-2006 11:29:21 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3768)) * establish * orcl * 0
17-AUG-2006 11:29:36 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3769)) * establish * orcl * 0
17-AUG-2006 11:29:52 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3772)) * establish * orcl * 0
17-AUG-2006 11:30:07 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3774)) * establish * orcl * 0
17-AUG-2006 11:30:22 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3777)) * establish * orcl * 0
17-AUG-2006 11:30:37 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3778)) * establish * orcl * 0
17-AUG-2006 11:30:53 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3782)) * establish * orcl * 0
17-AUG-2006 11:31:08 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3784)) * establish * orcl * 0
17-AUG-2006 11:31:10 * service_update * orcl * 0
17-AUG-2006 11:31:23 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3787)) * establish * orcl * 0
17-AUG-2006 11:31:38 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3788)) * establish * orcl * 0
17-AUG-2006 11:31:54 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3791)) * establish * orcl * 0
17-AUG-2006 11:31:54 * ping * 0
17-AUG-2006 11:31:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.102)( PORT=1522)))(VERSION=169869568)) * status * 0
17-AUG-2006 11:32:01 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=PERI)(USER =SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3794)) * establish * orcl * 0
17-AUG-2006 11:32:09 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3796)) * establish * orcl * 0
17-AUG-2006 11:32:24 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3799)) * establish * orcl * 0
17-AUG-2006 11:32:25 * service_update * orcl * 0
17-AUG-2006 11:32:39 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=PERI)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3800)) * establish * orcl * 0

listener1.log
----------------------------------------

17-AUG-2006 11:22:42 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\sqlplus.exe)(HOST=PERI)(USER=HP_Ad ministrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3685)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1524)))
Listener completed notification to CRS on stop
17-AUG-2006 11:24:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=HP_Administrator))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169869568)) * stop * 0

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-AUG-2006 11:26:45

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

System parameter file is C:\oracle\product\10.2.0\db_2\network\admin\listener.ora
Log messages written to C:\oracle\product\10.2.0\db_2\network\log\listener1.log
Trace information written to C:\oracle\product\10.2.0\db_2\network\trace\listener1.trc
Trace level is currently 0

Started with pid=2412
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=1524)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
17-AUG-2006 11:28:59 * ping * 0
17-AUG-2006 11:29:21 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_2\bin\sqlplus.exe)(HOST=PERI)(USER=HP_Ad ministrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=3767)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #188284 is a reply to message #188273]

Thu, 17 August 2006 15:56

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Sorry if I seem confused.
The tnsnames.ora file on the clients must match the servers tnsnames.ora.
Why do you want to use two listeners? Can you define hrs in the first listener.ora and the tnsnames.ora along with the others?
Why do you want to call the same instance by different names?

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
MKT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
SAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
HRS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102 )(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl )
)
)
Then lsnrctl reload and see if you can talk to hrs on port 1524 which, it looks like is the same database instance as the other 3, you just want to call it by different names? You will have to use the same username/password on all because it looks like you really only have one Oracle instance.
Or am I missing something?

[Updated on: Thu, 17 August 2006 15:56]

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #188285 is a reply to message #188273]

Thu, 17 August 2006 16:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The tnsnames.ora file on the clients must match the servers tnsnames.ora.
I disagree with the statement above.
The tnsnames.ora file on the client limits/controls to which remote databases the client can connect.
The tnsnames.ora file on the server limits/controls to which remote databases the server can connect.

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #188287 is a reply to message #188273]

Thu, 17 August 2006 16:58

sivaparam
Messages: 16
Registered: March 2005

Junior Member

Why do you want to use two listeners?
Siva> I am preaparing for the exam. You are correct, I have only one db instance , trying to connect with different name and also by creating additional listener.

Can you define hrs in the first listener.ora and the tnsnames.ora along with the others?
Siva> I did. It works fine.
Don't know, what is the issue in the current setup.
"tnsping hrs" seems to be working well.

Why do you want to call the same instance by different names?
Siva> Like I said, I am preparing for the exam. I just wants some hands on and build my confidence.

Appreciate your help.

thanks
siva

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #188478 is a reply to message #188273]

Fri, 18 August 2006 13:17

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Good luck on the exam! It is a tough one.
Neil.

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #188481 is a reply to message #188273]

Fri, 18 August 2006 13:21

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

anacedent's post is correct.

I should have been more specific. The tnsnames.ora on the client must match an entry on the server's tnsnames.

Good call anacedent.
Neil.

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #188562 is a reply to message #188481]

Sat, 19 August 2006 13:07

sivaparam
Messages: 16
Registered: March 2005

Junior Member

Thank you very much for your kind response. Every thing is started working. The magic is, the changes I have made to my LISTENER1. Just added the following

" (SID_DESC=
(SID_NAME=orcl)
(ORACLE_HOME= C:\oracle\product\10.2.0\db_2)
)
"

I have appended the following, just for the reference
- tnsnames.ora
- listener.ora
- sqlnet.ora

In this configration, I have created five net service name, two listener, pointing to the same oracle database instance.

- tnsnames.ora
=================================================
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

MKT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

SAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

HRS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105 )(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl )
)
)

LEG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105 )(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl )
)
)

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

- listener.ora
=================================================
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)

(SID_DESC=
(SID_NAME=orcl)
(ORACLE_HOME= C:\oracle\product\10.2.0\db_2)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1523))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1522))
)
)

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1524))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1525))
)

)

LOGGING_LISTENER = ON

- sqlnet.ora
=================================================

# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_2\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= (HOSTNAME, TNSNAMES, EZCONNECT)

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #382837 is a reply to message #188273]

Sun, 25 January 2009 12:47

sid78669
Messages: 1
Registered: January 2009
Location: Toronto, Canada

Junior Member

Hey,

I am a student of Database Design and recently installed Oracle 10g on my Laptop. I am experiencing the same problem, but nothing seems to work. Since there is only one database I have on my system, I cannot even get into the 'SQL>' prompt! Following are my log, listner and

Listner.log:
TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 23-JAN-2009 11:35:27

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

System parameter file is C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.1.0\Db_1\network\log\listener.log
Trace information written to C:\oracle\product\10.1.0\Db_1\network\trace\listener.trc
Trace level is currently 0

Started with pid=4208
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 23-JAN-2009 11:43:56

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

System parameter file is C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.1.0\Db_1\network\log\listener.log
Trace information written to C:\oracle\product\10.1.0\Db_1\network\trace\listener.trc
Trace level is currently 0

Started with pid=1148
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
23-JAN-2009 11:46:14 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49177)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 11:46:56 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49178)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 11:50:46 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49199)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 11:51:53 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\jdk\bin\java.exe)(HOST=SIDDHARTH-PC) (USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49214)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 11:54:09 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49215)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 11:56:45 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49217)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 12:14:27 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49257)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 12:18:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Siddharth))(COMMAND=services)(ARGUMENTS=64)(SERVICE=localhost)(VERSION=168821248)) * services * 0
23-JAN-2009 12:29:45 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49297)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 12:34:14 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49298)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 12:41:55 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\bin\sqlplus.exe)(HOST=SIDDHARTH-PC)( USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49391)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
23-JAN-2009 12:51:27 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49625)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
24-JAN-2009 16:54:39 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBS301)(CID=(PROGRAM=C:\oracle\product\10.1.0\Db_1\BIN\sqlplusw.exe)(HOST=SIDDHARTH-PC) (USER=Siddharth))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=62048)) * establish * DBS301 * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 24-JAN-2009 17:59:16

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

System parameter file is C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
Log messages written to C:\oracle\product\10.1.0\Db_1\network\log\listener.log
Trace information written to C:\oracle\product\10.1.0\Db_1\network\trace\listener.trc
Trace level is currently 0

Started with pid=2036
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

LISTNER.ORA
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = DBS301)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = DBS301)
)
)

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

TNSNAME.ORA
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DBS301 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBS301)
)
)

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

Please reply soon as my assignments are piling up and I can't figure how to make it work!

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #382838 is a reply to message #188273]

Sun, 25 January 2009 12:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Since you are logged onto the DB server system, SQL*Net is NOT required to access the database.
If/when you are logged onto the OS as the same user (oracle?) that owns the Oracle software directory tree, you can access the DB by:
sqlplus
/ as sysdba
SQL>

SQL*Net is required only when trying to access Oracle from a remote client.

Beside, AFAIK, localhost & 127.0.0.1 won't work as expected/desired; actual hostname & real IP# are needed.

[Updated on: Sun, 25 January 2009 14:10]

Report message to a moderator

Previous Topic:	shared server configuration
Next Topic:	wanting another user to manage lsnrctl

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 22:50:39 CST 2025