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)
)
)
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)
)
)
是不是连接的时候 写错了~
例程‘ORCL’ ,状态 UNKNOWN 。