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

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

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=CLRExtProc)
(the PRESENTATION=RO)
)
)

.
.
.

CodePudding user response:

TNS feel ok
Listen ok?

CodePudding user response:

The database server see listening state:
LSNRCTL status

CodePudding user response:

Listeners can't identify current connect descriptor request service,,,, suggest to delete the reshipment,,,

CodePudding user response:

Netca delete all the listener service to match,
Static registration, after your oracle service open, there will be a delay to register to the monitoring service,
But I generally prefer to dynamically register,
Don't know what I said these can you understand, I can direct messages,

CodePudding user response:

(1) computer management - & gt; Service - & gt; Open the oracleTNSlistener service,

(2) in F: \ PLSQL \ instantclient_12_1 \ NETWORK \ ADMIN \ listener ora: add
(SID_DESC=
(GLOBAL_DBNAME=former)
(ORACLE_HOME=E: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1)
(SID_NAME=former)

)

CodePudding user response:

I met this morning, it is such a solution

CodePudding user response:

I said that I also met, my problem is, inbound firewall port configuration didn't match, and port configuration can't pack in Oracle service after installation,

CodePudding user response:

I went to the post in March

CodePudding user response:

Problem solved, I also encountered such a problem, seek guidance