锐客网

  1. 首页 > 睿知 > it技术 > >

oracle怎么设置地址 oracle设置sga

IT技术Oracle

如何修改Linux环境下的Oracle的IP地址配置如何修改Linux环境下的Oracle的IP地址配置
新建配置文件tnsnames.orc，并将此文件放入
/usr/lib/oracle/11.2/client*****/network/admin下，具体文件配置信息如下：
#tnsnames.ora
Network
Configuration
File:
/usr/lib/oracle/11.2/client/network/admin/tnsnames.ora TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))(CONNECT_DATA =https://www.04ip.com/post/(SERVER = DEDICATED)(SERVICE_NAME = test)) )
EXTPROC_CONNECTION_DATA = https://www.04ip.com/post/(DESCRIPTION =(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)))
(CONNECT_DATA =https://www.04ip.com/post/(SID = PLSExtProc)(PRESENTATION = RO)) )
192.168.1.8标示字符串各自对应当前服务器的IP地址与全局数据库名
安装Oracle数据库的时候IP地址怎么配置了1、直接修改\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames的文件 ， 直接添加
TOPPROD =(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.15)(PORT = 1521)) )
(CONNECT_DATA =https://www.04ip.com/post/
(SERVICE_NAME = topprod) ) )
2、一种图形界面，在安装的时候，将oracle所在服务器或电脑的IP加入
如何修改Oracle服务IP地址你好，
oracle数据库所在的机器更改IP地址后，发现无法连接，
解决这个问题，需要修改一下对应的文件：
F:\app\zhaohe\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
F:\app\zhaohe\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
把其中对应的IP地址进行修改后再重新启动oracle就可以解决问题了；
注：重启实例服务、OracleOraDb11g_home1TNSListener后，稍等1分钟后即可 。
listener.ora
# listener.ora Network Configuration File: F:\app\zhaohe\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\zhaohe\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\zhaohe\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
)
ADR_BASE_LISTENER = F:\app\zhaohe
tnsnames.ora
# tnsnames.ora Network Configuration File: F:\app\zhaohe\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =https://www.04ip.com/post/
【oracle怎么设置地址 oracle设置sga】(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =https://www.04ip.com/post/
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =https://www.04ip.com/post/
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
注意：HOST位置要用机器名或机器的网络IP（如192.168.1.5）
oracle怎么设置地址的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于oracle设置sga、oracle怎么设置地址的信息别忘了在本站进行查找喔 。

    推荐阅读


    上一篇：mysql默认是升序还是降序 mysql默认级别是什么

    下一篇：如何在2008服务器上进行磁盘分区？ 2008服务器怎么分盘