使用图形界面建立Oracle的监听时,应该配置/etc/hosts文件
添加
192.168.9.100 database
如果修改linux的主机名
vi /etc/hosts
192.168.9.100 db
vi /app/oracle/product/11.2.0/db_1/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521))
)
) vi /app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)