Hi All,
I have created a db on my local machine (windows) for 12.2
am getting ORA-12560: TNS:protocol adapter error if am trying to login as sysdba user
and ORA-12543: TNS: destination host un reachable if am trying to login as SYSTEM user
C:\Users\j1012968>sqlplus system@o12cr201
SQL*Plus: Release 12.2.0.1.0 Production on Thu May 17 12:06:47 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12543: TNS:destination host unreachable
both listener and db services are running. Sarched for some articles online, but none of them meeting my error (or) I would have missed some thing and so requesting for your help on the error am facing. Your help will be highly appreciated.
C:\Users\j1012968>sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu May 17 11:43:59 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
C:\Users\j1012968>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 17-MAY-2018 11:08:13
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias O12CR201
Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date 17-MAY-2018 10:17:53
Uptime 0 days 0 hr. 50 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\j1012968\virtual\product\12.2.0\dbhome_1\network\admin\listener.ora
Listener Log File C:\app\j1012968\virtual\diag\tnslsnr\H4GZKC2J\o12cr201\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=H4GZKC2J)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "O12CR201" has 1 instance(s).
Instance "O12CR201", status READY, has 2 handler(s) for this service...
The command completed successfully
C:\Users\j1012968>tnsping o12cr201
TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 17-MAY-2018 11:11:48
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
C:\app\j1012968\virtual\product\12.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = H4GZKC2J)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = O12CR201 SERVER=DEDICATED)))
OK (0 msec)
C:\Users\j1012968>ping H4GZKC2J
Pinging H4GZKC2J [10.49.206.109] with 32 bytes of data:
Reply from 10.49.206.109: bytes=32 time<1ms TTL=128
Reply from 10.49.206.109: bytes=32 time<1ms TTL=128
Reply from 10.49.206.109: bytes=32 time=1ms TTL=128
Reply from 10.49.206.109: bytes=32 time=1ms TTL=128
Ping statistics for 10.49.206.109:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 1ms, Average = 0ms
- Listener.ora
# listener.ora Network Configuration File: C:\app\j1012968\virtual\product\12.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
# (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
SID_LIST_O12CR201 =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\j1012968\virtual\product\12.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\j1012968\virtual\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
)
O12CR201 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = H4GZKC2J)(PORT = 1521))
)
)
- Sqlnet.ora
# 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=(TNSNAME, EZCONNECT)
- Tnsnames.ora
# tnsnames.ora Network Configuration File: C:\app\j1012968\virtual\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
O12CR201 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = H4GZKC2J)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = O12CR201)
)
)