Oracle remote connection does not reach DBA user

Http://www.111cn.net/database/Oracle/42484.htm

Open the Guest account on the server. Add the Guest account to the ORA_DBA user group

Server Configuration Listener.ora

# Listener.ora Network Configuration File:d:\app\user\product\11.2.0\dbhome_3\network\admin\listener.ora
# Generated by Oracle configuration tools.

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = ORCL)
(Oracle_home = D:\app\User\product\11.2.0\dbhome_3)
# (program = Extproc)
(Envs = "Extproc_dlls=only:d:\app\user\product\11.2.0\dbhome_3\bin\oraclr11.dll")
)
)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = ORCL))
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
)
)

Adr_base_listener = D:\app\User

Client Configuration Tnsnames.ora

Oraclr_connection_data =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(Connect_data =
(SID = Clrextproc)
(PRESENTATION = RO)
)
)
ORCL154 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.154) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

Client configuration Sqlnet.ora must have this, otherwise the link is not

# Sqlnet.ora Network Configuration File:d:\app\user\product\11.2.0\dbhome_3\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
# Authentication, they'll is not being able to connect to the database on NT.

Sqlnet. Authentication_services= (NTS)

NAMES. Directory_path= (TNSNames, Ezconnect)

Note that the client only need to install Sqlplus on the line, there is Tnsnames.ora configuration, ordinary users can log on

Oracle remote connection does not reach DBA user