急急,我改了数据库的IP怎么出现 没有监听器错误!! 把listener.ora和tnsnames.ora兩個文件中你電腦和ip相關的地方全部替換重啟机子就行了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 修改D:\Oracle\Ora81\network\ADMIN\listener.ora文件例:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.150.160.1)(PORT = 1521))--修改IP成你的IP ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = 130.150.160.1)(PORT = 2481))--修改IP ) )如果你要配置连接本地数据库的字符串可以修改D:\Oracle\Ora81\network\ADMIN\TNSNAMES。ORA文件,例test = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.150.160.1)(PORT = 1521))--修改IP ) (CONNECT_DATA = (SERVICE_NAME = oracle) ) ) 把listener.ora和tnsnames.ora兩個文件中HOST = 130.150.160.1改为机器名,不用ip地址 listener.ora修改完成后,要重新启动监听进程 求教 这个SQL的意思 如何用sql调用存储过程包里面的函数? xxx.nextval怎么保存? group可不可以实现这个种查询 求指正一个简单的oracle存储过程 在线等 PL\SQL, 用insert语句插入一条包含&的记录,实际插入内容不一致,怎么解决? HELP!谢谢 Oracle NLS 参数错误请教, 什么叫动态数据库,什么叫静态数据库啊? 什么叫做 parent key 数据库转换,急,在线等!!! 初学者,请问oracle8.16有没有可视化的建数据库和表的方法.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.150.160.1)(PORT = 1521))--修改IP成你的IP
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.150.160.1)(PORT = 2481))--修改IP
)
)
如果你要配置连接本地数据库的字符串可以修改D:\Oracle\Ora81\network\ADMIN\TNSNAMES。ORA文件,例test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.150.160.1)(PORT = 1521))--修改IP
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
HOST = 130.150.160.1
改为机器名,不用ip地址