1、服务器
1.1常用工具
em
netmgr
netca
1.2相关配置文件
listener.ora
tnsnames.ora
C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = dmt1306)(PORT = 1521))
)
)
PLSExtProc:调用外部过程的服务
XDB:针对XML数据库
XPT:为DataGuard提供服务
修改初始化参数 禁止 XDB和XPT
1.3
静态注册,listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = xxx)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)
动态注册:pmon,自动找监听器进行注册,端口要求
是默认1521
alter system register;
1.4 lsnrctl工具
lsnrctl
LSNRCTL> help
以下操作可用
星号 (*) 表示修改符或扩展命令:
start stop status
services version reload
save_config trace change_password
quit exit set*
show*
start: 启动监听器
stop: 停止监听器
status: 查看监听器状态
quit/exit:退出
1.5 配置非1521端口
1)修改listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = dmt1306)(PORT = 5555))
)
)
2)
修改配置文件tnsnames.ora
xxx =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dmt1306)(PORT = 5555))
)
修改数据库参数local_listener
alter system set local_listener=xxx;
alter system register;
2、客户端
命名解析
1)easy connect:
sqlplus test/test@127.0.0.1:1521/orcl
2)local naming
使用tnsnames.ora
qqq =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dmt1306)(PORT = 5555))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
3)directory naming
4)External naming