oracle创服务图解.docVIP

创建oracle服务 用工具Oracle Net Manager创建服务 打开Net Manager软件 进入到Net Manager操作界面,选中本地下的”服务命名”,会出现 创建服务 点击,进入服务向导窗体,填写网络服务名,即给改服务起的名字,作为plsql登录的数据库,sqlplus登录的”主机字符串” 点击”下一步 ”,选择网络协议,选择默认的第一个”TCP/IP Internet ” 点击”下一步”,填写主机名,如果连接远程数据库,需要填写远程主机的ip如192.168.1.100,如果连接本地,则写自己的ip或者localhost 单击”下一步”,输入服务名.根据你数据库的版本,选择对应的按钮,输入服务器名,即本地或者远程主机的数据库名 点击”下一步”,会出现测试界面,可以点击”测试”,或者点击”完成” 点击”测试”,进入测试连接窗体 一进去可能测试不成功,所有点击更改登录,修改成自己数据库或者远程数据库的用户名和密码 点击”确定”,返回上一个界面,点击”测试”,显示测试成功 点击关闭,返回到测试窗体 点击完成,返回到首页,点击保存网络配置,服务就可以使用 二．直接手动修改 1. 找到F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN的tnsnames.ora文件,用记事本打开 2.对应如上图,进行复制,修改 之前文件需要备份 注意：如果有安装客户端的话，有时plsql登录保错, 所有要选择Oracle主目录 解决方法： 运行plsql,取消登录 点击”工具”,在点击”首选项” 会出现如下图的界面,选中oracle下的”连接” 选择Oracle主目录 of support and hanger. Cable hole plugging gaps should use qualified fireproof materials, block surface should have sufficient strength, surface appearance. When cables pass through the firewall, of lax structure of local fire safety clamps. Thermoplastics production, to comply with the process, no bubbles in the thermoplastics pipes, linear nose consistent with the core wire specifications, contact is good, no cracks, break. Tinned copper nose clean solder full exterior surface is smooth without burrs. Control cable Assembly should be fastened, dense, solid, clean, and beautiful. Secondary wiring the cable terminations should be arranged by the actual location of the device line cards, the wiring from the upper to the lower, from left to right in the order. Fixed to maintain consistent spacing between lines, flat, should be around the corner in the same location, same shape, to ensure that the wiring process neater and more elegant. 5 thermal process control measures for quality problems 5.1 control thermal duct system leakage measure to ensure that the use of electric door and actuator installation quality and equipment to the site to check its seal, acceptance, in order to fundamentally solve oil spill problems. Plant for local Panel after installation, in conjun