hello everyone,
i have a database that i created two years ago,everything was working fine.
o forgot it about it for a while when i use busy trying something new like SQLlite,MS SQL, however when i tried to connect back to my oracle,DB , i could not
1st the SQL* Plus was not recognized i solved it tho by fixing the ORACLE_HOME then i thought there was a problem to login to my odb but when i used "as sysdba" it returen ORA-12560: TNS:protocol adapter error
here i found out that oracleservicesEX is not listed on the windows services
i reconfigured my LISTENER , removed SQLlITE & MS SQL
but the buttonhole, i still have this problem ORA-12560: TNS:protocol adapter error and oracleservicesEX not showing
i tired to start the services and here is the result:
C:\Users\Mans>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-APR-2020 08:21:49
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=D60)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 26-APR-2020 08:08:14
Uptime 0 days 0 hr. 13 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\Users\Mans\apps\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File c:\users\mans\apps\diag\tnslsnr\DESKTOP-C4GBD60\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-C4GBD60)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\Users\Mans>lsnrctl services
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-APR-2020 08:23:00
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=D60)(PORT=1521)))
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
The command completed successfully
i tried to solve it and i am trying to learn how to troubleshoot such an issue
thanks in advance