connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer
0
votes
1
answer
406
views
Hi I am trying to do DBA course that requires that I use Oracle database.
I am using my corporate pc to do it.
I set up the loopback adapter to enable localhost communication and setup the hosts file in system 32. When I start lsnrcrl
However when I try to connect I get an error.
27-JUL-2016 08:59:00 * (CONNECT_DATA=(SID=xe)(CID=(PROGRAM=SQLDeveloper)(HOST=__jdbc__)(USER=ABC))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50619)) * establish * xe * 12505
Extra info
1. Listener.ora is set to localhost.
2. hostsfile in system32 is set to 192.168.1.1/domain name.ABCDEF1212221/ ABCDEF1212221
The lstnrctrl status is here.
C:\Windows\system32> lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 27-JUL-2016 13:19:16
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 26-JUL-2016 15:30:00
Uptime 0 days 21 hr. 49 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\OLDKHQ133304\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=abcdefg1212221.corporate.corporate.net)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Asked by DavyGravy
(101 rep)
Jul 27, 2016, 07:24 AM
Last activity: Apr 15, 2025, 09:02 PM
Last activity: Apr 15, 2025, 09:02 PM