在将Oracle安装成功后,在cmd命令下检测安装时使用tnsping orclc,报错如下:
发现C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN目录下面就只有一个sqlnet.ora文件,缺少了配置连接数据库的连接字符串的TNSNAMES.ORA文件
从C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\SAMPLE目录下面拷贝一个TNSNAMES.ORA文件修改里面的参数配置如下
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
再次执行tnsping orclc成功,如下