ericwood73
Member
When trying to install a Deployment Server on Windows 2012 R2 I get the dreaded "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" error. Both the TNSListener and E1Local services are running. When I run lsnrctl status, I do not see E1Local:
I also noticed in the alert.log file, I do not see any service_register messages, though I did see these in the standalone client install. I also confirmed the services were present in the DB:
I have taken a number of steps to address this:
1. Ensuring that the TNS listener service is running. I can tnsping E1Local just fine:
2. Ensuring that the tnsnames.ora file has been copied to the 32 bit client bin directory.
3. Ensuring that the hostname is used in the tnsnames and listener.ora files
4. Attempting to force registration using alter system register.
5. Rebooted the TNSListener and E1Local services numerous times as well as manually starting these services.
6. Reinstalled both the E1Local database and the 32 bit changing the order of which one I installed first.
7. Set ORACLE_SID to E1Local
8. Added DBA_ORA group to my local user account (Administrator)
9. Followed the steps in this post https://www.jdelist.com/vb4/showthr...d-with-error-1?p=167628&viewfull=1#post167628
10. Used both 64 bit and 32 bit netmanagers to confirm settings and test connection (fails with same error)
11. Confirmed all my settings with my standalone client which has a working E1Local
At this point the only differences are that my standalone was installed using a domain user with admin rights, whereas my deployment server is installed by a local user with admin rights and the fact that I am installing a 9.1.0 deployment client versus a 9.2.0 standalone server, however I suspect the the E1Local setup is the same.
Can anyone tell me any other things to check or try beyond what I have already checked and tried?
Code:
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 22-SEP-2017 19:43
:09
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.18.249.242)(PORT=1521
)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Produ
ction
Start Date 22-SEP-2017 18:27:58
Uptime 0 days 1 hr. 15 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\Oracle\E1Local\network\admin\listener.ora
Listener Log File C:\Oracle\diag\tnslsnr\jdemultidp1\listener\alert\log.
xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.18.249.242)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Code:
SQL> select NAME from ALL_SERVICES;
NAME
----------------------------------------------------------------
SYS$BACKGROUND
SYS$USERS
E1LocalXDB
E1Local
I have taken a number of steps to address this:
1. Ensuring that the TNS listener service is running. I can tnsping E1Local just fine:
Code:
C:\Users\Administrator>tnsping E1Local
TNS Ping Utility for 32-bit Windows: Version 12.1.0.2.0 - Production on 22-SEP-2
017 19:42:08
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
C:\app\e1dbuser\product\12.1.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jdemulti
dp1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = E1Local)
))
OK (1150 msec)
3. Ensuring that the hostname is used in the tnsnames and listener.ora files
4. Attempting to force registration using alter system register.
5. Rebooted the TNSListener and E1Local services numerous times as well as manually starting these services.
6. Reinstalled both the E1Local database and the 32 bit changing the order of which one I installed first.
7. Set ORACLE_SID to E1Local
8. Added DBA_ORA group to my local user account (Administrator)
9. Followed the steps in this post https://www.jdelist.com/vb4/showthr...d-with-error-1?p=167628&viewfull=1#post167628
10. Used both 64 bit and 32 bit netmanagers to confirm settings and test connection (fails with same error)
11. Confirmed all my settings with my standalone client which has a working E1Local
At this point the only differences are that my standalone was installed using a domain user with admin rights, whereas my deployment server is installed by a local user with admin rights and the fact that I am installing a 9.1.0 deployment client versus a 9.2.0 standalone server, however I suspect the the E1Local setup is the same.
Can anyone tell me any other things to check or try beyond what I have already checked and tried?