plsql连不上数据库-白红宇

plsql连不上数据库

阅读量：4941 次

发布时间：2019-06-11

本文共 2846 字，大约阅读时间需要 9 分钟。

tnsnames文件 # tnsnames.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    ))ORCL_172.16.6.41=  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.41)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ORCL_172.16.6.41)    )EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))    )    (CONNECT_DATA =      (SID = PLSExtProc)      (PRESENTATION = RO)    )  ))

listener.ora文件

# listener.ora Network Configuration File: F:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)      (PROGRAM = extproc)    ) (SID_DESC =    (GLOBAL_DBNAME = ORCL)    (ORACLE_HOME = F:\oracle\product\10.1.0\Db_1)    (SID_NAME = ORCL)    )  )LISTENER =  (DESCRIPTION_LIST =       (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = orcl))      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    )  )

我的电脑-->右击管理-->服务-->oracle_

# listener.ora Network Configuration File: F:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = C:\oracle\product\10.2.0\client_1)      (PROGRAM = extproc)    )    (SID_DESC =      (GLOBAL_DBNAME = ORCL)      (ORACLE_HOME = C:\oracle\product\10.2.0\client_1)      (SID_NAME = ORCL)    )  )LISTENER =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  )

# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.SSFW_NEW =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.41)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ORCL)    )  )ORCL_172.16.6.41 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.6.41)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))    )    (CONNECT_DATA =      (SID = PLSExtProc)      (PRESENTATION = RO)    )  )

转载于:https://www.cnblogs.com/Peter-Youny/archive/2013/01/30/2882538.html

你可能感兴趣的文章

Xshell远程登录

查看>>

@RequestParam与@PathVariable的区别

LINQ to Entities 不支持 LINQ 表达式节点类型“ArrayIndex”。

查看>>