oracle数据库软件和实例安装好以后的配置
来源:互联网 发布:js history 清除 编辑:程序博客网 时间:2024/05/29 19:16
=======tnsnames.ora:# tnsnames.ora Network Configuration File: H:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.#*****ORCL1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 60.*****)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.sunny.com) ) )#*****ORCL2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*****)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) #*****ORCL3= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*****)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.sunny) ) )========listener.ora:# listener.ora Network Configuration File: H:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = H:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:H:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 60.*****)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*****)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*****)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )ADR_BASE_LISTENER = H:\app\Administrator===================================================//2015-03-27熟悉oracle数据库的基本知识,熟悉plsql操作://查询当前数据库名:select name from v$database; //结果:ORCL//查询当前数据库实例名:(SID)//实例名指的是用于响应某个数据库操作的数据库管理系统的名称。它同时也叫SID。//数据库实例名(instance_name)用于对外部连接。在操作系统中要取得与数据库的联系,必须使用数据库实例名。//比如我们作开发,要连接数据库,就得连接数据库实例名://jdbc:oracle:thin:@localhost:1521:orcl(orcl就为数据库实例名)//一个数据库可以有多个实例,在作数据库服务集群的时候可以用到。select instance_name from v$instance; //结果:orcl,数据库实例名用于对外部连接,要连接数据库,就得连接数据库实例名。===========================================================================================================//scott用户访问表emp;select * from emp;//dept表select * from dept;//salgrade表select * from salgrade;===========================================================================================================//创建完数据库后,并不能立即在数据库中建表,必须先创建该数据库的用户,并且为该用户指定表空间。//安徽工情//1.创建表空间"ahdemo"select instance_name from v$instance; create tablespace ahdemo datafile 'H:\app\Administrator\oradata\orcl\ahdemo.dbf' size 500m autoextend on next 100m maxsize 2048m; //表空间最大2g//查看已经创建好的表空间select default_tablespace,temporary_tablespace,d.username from dba_users d where d.username like '%ah%' group by d.default_tablespace, d.temporary_tablespace, d.username. //查看所有表空间大小 select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;//2.创建用户"ahuser",并为之分配创建的表空间和临时表空间,并为之授权create user ahuser identified by "Sunny_123456]" default tablespace ahdemo temporary tablespace temp;//有了用户,要想使用用户账号管理自己的表空间,还得给它分权限:(ahuser已被授予了connect/resource/dba三种权限)grant connect to ahuser; grant resource to ahuser;grant dba to ahuser;//查看数据库用户select * from dba_users order by created desc;//=====================================================================================//操作表//==========================tb_users===select * from tb_users;//==========================tb_dept===select * from tb_dept;
0 0
- oracle数据库软件和实例安装好以后的配置
- 安装ubuntu后的配置和软件安装,留给自己以后用
- debian安装好以后终端的配置的修改
- oracle学习笔记 oracle软件安装和数据库的创建
- oracle数据库的安装和配置
- X86_64平台下Oracle 11g R2 X64 for Linux的软件安装、数据库安装、服务配置、数据库启动和停止、SQLPLus使用
- Oracle11g安装,配置监听和数据库实例
- oracle 数据库和数据库实例的区别
- 安装Oracle数据库软件
- oracle数据库软件安装
- MYSQL|ORACLE的数据库链接实例______软件开发-数据库
- Oracle数据库的安装配置过程和卸载步骤
- oracle数据库软件的静默安装
- 折腾好几天oracle数据库和plsql配置
- Oracle数据库安装、配置和卸载
- 【数据库】安装和配置Oracle客户端
- oracle 11G 软件克隆安装(单实例和RAC)
- Oracle实例和数据库
- python基础教程学习笔记 第二章 列表和元组
- mysql 远程连接
- easyui datagrid pagination 自定义分页
- HDU 1358 Period (next跳表找最小循环节)KMP
- Qt5中文显示
- oracle数据库软件和实例安装好以后的配置
- SQL : Join 与 union
- U-BOOT移植的前世今生
- jquery easui tabs注册完刷新另一个tabs
- Git 进阶之「设置别名」
- easyui messager show和confirm
- NRF52832NFC读写
- HashMap根据Value值的大小排序
- win7系统右键菜单没有新建word功能的解决方法