windows xp 、oracle10g系统环境:
我将监听端口由1521改为1522,service和监听均能正常启动,sys用户在PL/SQL中能登陆,但在sqlplus中无法以sysdba身份登陆。命令行下提示协议适配器错误,在PL/SQL中修改了sys的密码后没有效果》。由于另外的一个数据库,监听端口1521均能正常使用。个人怀疑问题产生跟监听端口改变有关》望高手讲解讲解监听端口改变后需要注意的地方........
我将监听端口由1521改为1522,service和监听均能正常启动,sys用户在PL/SQL中能登陆,但在sqlplus中无法以sysdba身份登陆。命令行下提示协议适配器错误,在PL/SQL中修改了sys的密码后没有效果》。由于另外的一个数据库,监听端口1521均能正常使用。个人怀疑问题产生跟监听端口改变有关》望高手讲解讲解监听端口改变后需要注意的地方........
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = biddb)
(SID_NAME = biddb)
)
)SID_LIST_ORCL =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = ORCL)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hlzhou)(PORT = 1521))
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hlzhou)(PORT = 1522))
)# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = hlzhou)(PORT = 1522))BIDDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hlzhou)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = biddb)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hlzhou)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)sid 和 监听均为orcl
2. 在访问段修改 tnsnames.ora 文件中的端口3. 用tnsping SID 命令来确认下,如果能ping通,访问就没有问题了。 而且tnsping 命令也会显示出监听使用的端口。 ------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716