WIN10 Home version monitoring cannot start TNS-12560 TNS-00530

First WIN10 permissions issues,

Advanced startup Restart Now, update and security recovery, search settings-Advanced options-Startup settings-restart-select "4"

1. Press "Win+r" key combination, enter "control Userpasswords2",

   Properties-Group members-set your account as Administrator-ok

   Restart your computer

====================================================================================

  you have permission to modify the file

listener.ora# Listener.ora Network Configuration file:d:\app\oracle\product\12.1.0\dbhome_1\network\admin\ listener.ora# Generated by Oracle configuration Tools. sid_list_listener =  (sid_list =    (sid_desc =      (sid_name = clrextproc)       (oracle_home = D:\app\oracle\product\12.1.0\dbhome_1) & nbsp     (program = extproc)       (Envs = "extproc_dlls=only:d:\app\oracle\product\12.1.0\dbhome_1\ Bin\oraclr12.dll ")       (Sid_desc =         (global_dbname = ORCL)   & nbsp     (oracle_home = D:\app\oracle\product\12.1.0\dbhome_1)         (sid_name = ORCL) & nbsp;    )  )  listener =  (description_list =    (DESCRIPTION =    & nbsp (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))    )  )   =========================== =====  # Sqlnet.ora NetworkConfiguration file:d:\app\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora# Generated by Oracle Configuration tools. # This file was actually generated by NETCA. But if customers choose to # Install ' software only ', this file wont exist and without the native # Authenticati On, they won't is able to connect to the database on Nt. sqlnet. Authentication_services= (NTS)  names. Directory_path= (TNSNames, Ezconnect)     =================================================== =============================  # Tnsnames.ora Network Configuration file:d:\app\oracle\product\12.1.0\ dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration Tools. oraclr_connection_data =  ( DESCRIPTION =    (address_list =      (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))   &NBSP ; )     (Connect_data =      (SID = clrextproc)       (PRESENTATION = RO)     ) &NBsp )  orcl =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))     ( Connect_data =      (SERVER = dedicated)       (service_name = ORCL)    )  ) OR CL1 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.66) (PORT = 1521))     (Conne Ct_data =      (service_name = ORCL)    )  )

=====================================================================================

cmd into command, enter LSNRCTL

Start Listener Tips

Lsnrctl> Start Listener
Start Tnslsnr: Please wait ...

Tnslsnr for 64-bit windows:version 11.2.0.1.0-production
System parameter file is D:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
Log information written to D:\app\diag\tnslsnr\DESKTOP-OOQT5PK\listener\alert\log.xml
Monitoring: (Description= (Address= (protocol=tcp) (host=127.0.0.1) (port=1521)))
TNS-01155: In LISTENER. The Sid_list_listener parameter specified in ORA is incorrect
NL-00303:NV syntax error in string

The listener failed to start. See the error message above ...

Workaround:the host= red font, the original 127.0.0.1 modified to the computer name, you can start the normal

===================================================================--

Lsnrctl> Start Listener
Start Tnslsnr: Please wait ...

Tnslsnr for 64-bit windows:version 11.2.0.1.0-production
System parameter file is D:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
Log information written to D:\app\diag\tnslsnr\DESKTOP-OOQT5PK\listener\alert\log.xml
Monitoring: (Description= (Address= (protocol=tcp) (HOST=DESKTOP-OOQT5PK) (port=1521)))

Connecting to (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))
The STATUS of LISTENER
------------------------
Alias Listener
Version Tnslsnr for 64-bit windows:version 11.2.0.1.0-production
Start Date December-May-2018 16:21:30
Uptime 0 days 0 hours 0 minutes 3 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File D:\app\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener log File D:\app\diag\tnslsnr\DESKTOP-OOQT5PK\listener\alert\log.xml
Listener Endpoint Summary ...
(Description= (address= (protocol=tcp) (HOST=DESKTOP-OOQT5PK) (port=1521)))
Service Summary:
The service "Clrextproc" consists of 1 instances.
The instance "Clrextproc", State UNKNOWN, contains 1 handlers for this service ...
The service "ORCL" consists of 1 instances.
The instance "ORCL", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded
Lsnrctl>

===================================================================

SYSDBA Insufficient Permissions

=============== file name: Join Group Policy. CMD content is as follows ====================

@echo off

pushd "%~dp0"

Dir/b C:\windows\servicing\packages\microsoft-windows-grouppolicy-clientextensions-package~3*.mum >List.txt

Dir/b C:\windows\servicing\packages\microsoft-windows-grouppolicy-clienttools-package~3*.mum >>List.txt

for/f%%i in (' findstr/i. List.txt 2^>nul ') do dism/online/norestart/add-package: "C:\Windows\servicing\Packages\%%i"

Pause

==============================================================

Run as an administrative identity

Execution results

Deployment Image services and management tools
Version: 10.0.16299.15

Image version: 10.0.16299.98

Processing 1 (of 1)-Adding package microsoft-windows-grouppolicy-clientextensions-package~31bf3856ad364e35~amd64~zh-cn~ 10.0.16299.15
[==========================100.0%==========================]
The operation completed successfully.

Deployment Image services and management tools
Version: 10.0.16299.15

Image version: 10.0.16299.98

Processing 1 (of 1)-Adding package microsoft-windows-grouppolicy-clientextensions-package~31bf3856ad364e35~amd64~~10.0.16299.15
[==========================100.0%==========================]
The operation completed successfully.

Deployment Image services and management tools
Version: 10.0.16299.15

Image version: 10.0.16299.98

Processing 1 (of 1)-Adding package microsoft-windows-grouppolicy-clienttools-package~31bf3856ad364e35~amd64~zh-cn~10.0.16299.15
[==========================100.0%==========================]
The operation completed successfully.

Deployment Image services and management tools
Version: 10.0.16299.15

Image version: 10.0.16299.98

Processing 1 (of 1)-Adding package microsoft-windows-grouppolicy-clienttools-package~31bf3856ad364e35~amd64~~10.0.16299.15
[==========================100.0%==========================]
The operation completed successfully.
Please press any key to continue ...

Input: Gpedit.msc

====================== as a user group, the original is a group Policy, there is no way to add users ================================================================= =========

Win+r Control USERPASSWORDS2

Change to ORA_DBA

WIN10 Home version monitoring cannot start TNS-12560 TNS-00530