Oracle基础一
一、启动oracle网络配置助手
开始--> 程序--> oracle-->application develop--> net configration assistant
二、选择本地服务名配置
![这里写图片描述](https://img-blog.csdn.net/20170226140509582?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
三、将远程服务器的服务添加为本地服务名
依次填写管理员提供的数据库**关键参数**
address: 10.1.5.12
sid: orcl
port: 1521
![这里写图片描述](https://img-blog.csdn.net/20170226142333889?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
![这里写图片描述](https://img-blog.csdn.net/20170226141739605?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
四、连接测试通过后填写自定义本地服务名
![这里写图片描述](https://img-blog.csdn.net/20170226142551642?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
![这里写图片描述](https://img-blog.csdn.net/20170226142627609?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
![这里写图片描述](https://img-blog.csdn.net/20170226161012974?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
![这里写图片描述](https://img-blog.csdn.net/20170226161932596?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
![这里写图片描述](https://img-blog.csdn.net/20170226162034832?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
五、利用sqlplus连接上服务器进行简单查询操作
select table_name from user_tables;
desc emp;
![这里写图片描述](https://img-blog.csdn.net/20170226142753797?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvd215b2xhbmRh/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)