求助求助！oracle监听。

Alessandro_ 2011-02-15 09:30:07

win7 装了oracle11G，安装好了后，使用没有什么问题。

但是重启机子后，用PLSQL连接不上本机上的数据库，无法识别监听描述符。

但连接其他机子上的数据库能正常连接。

在网上搜索了下，说是加一段代码在配置文件中，

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME =D:\app\Smlier\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GROBAL_DBNAME = ORCL)
(ORACLE_HOME =D:\app\Smlier\product\11.1.0\db_1)
(SID_NAME=ORCL)
(PROGRAM = extproc)
)
)

但再次连接的时候出现了，无法连接服务器，可能是oracle NET 管理错误。

忘同学能帮我看看。

listener.ora文件
# listener.ora Network Configuration File: D:\app\Smlier\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME =D:\app\Smlier\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GROBAL_DBNAME = ORCL)
(ORACLE_HOME =D:\app\Smlier\product\11.1.0\db_1)
(SID_NAME=ORCL)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Smlier-PC)(PORT = 1521))
)
)

tnsnames.ora文件
# tnsnames.ora Network Configuration File: D:\app\Smlier\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

YYXCZJ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

150 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.150)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Smlier-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

...全文