实验1 Orale10g数据库上机环境.docVIP

实验1 Oracle10g数据库上机 一、实验目的 认识Oracle数据库管理系统； 熟悉Oracle使用的基本环境； 了解并会使用SQL*Plus工具。 二、实验要求 启动SQLPLUS交互工具进行网络数据库的连接，以用户名System，口令ORACLE这个用户以dba角色登录进行远程连接。 使用，conn ,show 命令 启动SQL*Plus，以用户名System，口令ORACLE这个用户以dba角色登录进行远程连接。使用 select * form v$database; 以管理员用户SYS，正常关闭数据库 以管理员用户SYS，正常启动数据库 启动Oracle Enterprise Manager Database Control（简称OEM） 三、实验学时安排 课堂内1学时完成二中所列1、2、3三项内容，其余各项内容均自行上机练习完成。 四、实验内容与步骤 1、启动(”服务“-找到”oracle“的四个服务：将开头的四个服务分别启动： （1）OracleDBConsoleorcl（暂时无法启动） （2）右击“OracleOraDb10g_home1iSQL*Plus”行(”启动“； （3）右击“OracleServiceORCL….”行—”启动“ （4）OracleOraDb10g_home1TNSListener(必须启动)。 2、启动Oracle Enterprise Manager Database Control（简称OEM） 打开浏览器，输入网址为：http://1-67:5500/em 打开如图所示界 面：连接身份：NORMAL 填写入上信息可打开如图界面： 3、启动SQL*Plus 单击“开始”—找到”oracle”目录(“应用程序开发”(右击“SQL PLUS”发送到桌面快捷方式(然后在桌面上双击“SQL PLUS” ;在如图界面填写如下信息：用户名：system 口令：oracle 五、实验结果提交要求 本次实验需要提交上机实验报告，将上机所做的实验题目、操作步骤、实验现象和结果、实验结论形成实验报告。截图，多种方法。参考学习（百度） conferences, learned superiors policies; reports, you can learn to deal with problems, art, just wanted to learn, to learn at any time. To continuously expand the scope of the study. The complexity and comprehensiveness of our work, decided to not only do we want to be professionals, or if generalists, to dabble in different areas of knowledge. Mastery of knowledge not only to have knowledge to rational analysis. This on requirements we, not only to learning national of route, and approach, and policy, also to learning national of legal, and regulations; not only to with political theory armed mind, also to with economic theory guide work; not only to read history, also to read history; not only to absorption SM of mirror, also to gets is of road; not only to from local learn, also to to outside learn; not only to to books learn, also to field study learn. 　　Therefore, I would encourage you, and more to the outside world when I have time to take a look at, take a stroll, outside developments, learn other peopl