The day before yesterday installation of a library, 10 g tnsnames. Ora is such
ORACLE=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=zhuhui - PC) (1521) PORT=)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=oracle)
)
)

EXTPROC_CONNECTION_DATA=https://bbs.csdn.net/topics/
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1))
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SID=PLSExtProc)
(the PRESENTATION=RO)
)
)


Use tnsping oracle can ping, use up sqlplus sys/oracle as sysdba @ oracle can connect, but use up sqlplus DTZLS/DTZLS @ oracle is unable to connect, DTZLS for a dba user permissions, error ORA - 12154: TNS: could not resolve the connect identifier specified;
For what reason is this greatly, thank you!
Firewall has closed, the database in the machine, direct connection in the unit, use up sqlplus DTZLS DTZLS @ localhost/oracle can be connected,
Attach a listener. Ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=F: \ oracle \ product \ 10.2.0 \ db_1)
(the PROGRAM=extproc)
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1))
(ADDRESS=(TCP) PROTOCOL=(HOST=zhuhui - PC) (1521) PORT=)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=ORACLE.REGRESS.RDBMS.DEV.US.ORACLE.COM)
(ORACLE_HOME=F: \ oracle \ product \ 10.2.0 \ db_1)
(SID_NAME=oracle)
)
)

CodePudding user response:

You changed the host to the actual IP test under

CodePudding user response:

A line is added in the hosts file of the machine host name and IP