The younger brother new one, according to the online tutorial local installation database, PLSQL can even not even sqldeveloper on death, drummed up three or four days to also can not find out the reason, a great god answer

Below is the tnsname. Ora
# tnsnames. Ora Network Configuration File: D: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1 \ Network \ admin \ tnsnames ora
# Generated by Oracle configuration tools.

LISTENER_ORCL=
(ADDRESS=(TCP) PROTOCOL=(HOST=localhost) (1521) PORT=)


ORACLR_CONNECTION_DATA=https://bbs.csdn.net/topics/
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SID=former)
(the PRESENTATION=RO)
)
)

Former=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=localhost) (1521) PORT=)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=former)
)
)

Below is the listener configuration file
# listener. Ora Network Configuration File: D: \ \ Administrator \ product \ app 11.2.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: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1)
(the PROGRAM=extproc)
(ENVS="EXTPROC_DLLS=ONLY: D: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1 \ bin \ oraclr11 DLL")
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
(ADDRESS=(TCP) PROTOCOL=(HOST=localhost) (1521) PORT=)
)
)

ADR_BASE_LISTENER=D: \ app \ Administrator

Below is the sqlnet. Ora
# sqlnet. Ora Network Configuration File: D: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1 \ Network \ admin \ sqlnet ora
# Generated by Oracle configuration tools.

# This file is later generated by netca. But if customers choose to
# the 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 EZCONNECT)

Global database instance name is the former

CodePudding user response:

[img=https://img-bbs.csdn.net/upload/201703/06/1488808679_94134.png] [/img thought is the network reason, out of all antivirus software not,,,,

CodePudding user response:

Tnsping former
LSNRCTL status
Confirm the listening state,
Is it plsqldev PLSQL, this can be connected?

CodePudding user response:

You put the file (D: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1 \ network \ admin \ tnsnames ora) copied to your client?