*listener.ora*

# listener.ora Network Configuration File: c:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = Administrator)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = c:\oracle\product\11.2.0\dbhome_1)
  (PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:c:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

ADR_BASE_LISTENER = c:\oracle

-------------------------------------------------------------------------------------------------------------------------------------------------------

*sqlnet.ora*

# sqlnet.ora Network Configuration File: c:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# 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= (TNSNAMES,ONAMES,HOSTNAME)

-------------------------------------------------------------------------------------------------------------------------------------------------------

*tnsnames.ora *

# tnsnames.ora Network Configuration File: c:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA=
  (DESCRIPTION=
    (ADDRESS=
  (PROTOCOL=IPC)
  (KEY=EXTPROC1521)
    )
    (CONNECT_DATA=
  (PRESENTATION=RO)
  (SID=CLRExtProc)
    )
  )

SFSCDD=
  (DESCRIPTION=
    (ADDRESS=
  (PROTOCOL=TCP)
  (HOST=Administrator)
  (PORT=1521)
    )
    (CONNECT_DATA=
  (SERVER=dedicated)
  (SERVICE_NAME=orcl)
    )
  )


-------------------------------------------------------------------------------------------------------------------------------------------------------

로컬DB서버로 연결하려고하는데

ora-12514 에러가 뜨네요ㅠㅠ



CMD -> tnsping orcl 해줬더니

TNS-03505로 이어지는 상황입니다ㅠ


CMD -> lsnrctl status은 (첨부파일)로 올렸습니다


웃긴건 설치 첫날에는 아무런 이상없이 돌아갔는데;;

막상 써먹을라고 다시 재가동했더니 이런현상이 있네요;;

도움부탁드립니다