Sample Header Ad - 728x90

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