- 浏览: 582131 次
- 性别:
- 来自: 上海
文章分类
- 全部博客 (174)
- JBPM (3)
- WWF (0)
- JavaScript (11)
- J2EE (40)
- OperationSystem (11)
- 数据库 (12)
- CSS (1)
- Ajax (2)
- J2SE (30)
- Tools (10)
- 服务器中间件 (3)
- 异常 (0)
- Flex (5)
- jQuery (11)
- html (9)
- Ejb (1)
- HTML5 Shiv–让该死的IE系列支持HTML5吧 (1)
- Spring (9)
- Quartz (3)
- log4j (1)
- maven (1)
- cpdetector (1)
- JSON (1)
- log4jdbc (1)
- asm (8)
- FusionCharts (1)
- jqplot (1)
- highcharts (1)
- excanvas (1)
- html5 (1)
- jpcap介绍 (1)
- weblogic (3)
- URLURLClassLoader (0)
- URLClassLoader (1)
- ant (2)
- ivy (2)
- nexus (1)
- IT (0)
- LoadRunner (1)
- SCSS (1)
- ruby (1)
- webstorm (1)
- typescript (1)
- Jboss7 (1)
- wildfly (1)
- oracle (5)
- esb (0)
- dubbo (2)
- zookeeper (3)
- eclipse (1)
- Android (2)
- Studio (1)
- Google (1)
- 微信 (1)
- 企业号 (1)
- Linux (13)
- Oracle12c (1)
- Hadoop (1)
- InletexEMC (1)
- Windows (1)
- Netty (3)
- Marshalling (2)
- Protobuf (1)
- gcc (1)
- Git (1)
- GitLab (1)
- shell (2)
- java (3)
- Spring4 (1)
- hibernate4 (1)
- postgresql (1)
- ApacheServer (2)
- Tomcat (2)
- ApacheHttpServer (2)
- realvnc (1)
- redhat (7)
- vncviewer (1)
- LVS (4)
- LVS-DR (1)
- RedHat6.5 (5)
- LVS-NAT (1)
- LVS-IPTUNNEL (2)
- LVS-TUN (1)
- keepalived (2)
- yum (1)
- iso (1)
- VMware (1)
- redhat5 (1)
- ha (1)
- nginx (2)
- proguard (1)
- Mat (1)
- DTFJ (1)
- axis2 (1)
- web service (1)
- centos (1)
- random (1)
- urandom (1)
- apache (1)
- IBM (1)
- cve (1)
- 漏洞 (1)
- JDBC (1)
- DataSource (1)
- jdk (1)
- tuxedo (2)
- wtc (1)
最新评论
-
skying007:
好资料,谢谢分享给啊
FusionCharts在服务器端导出图片(J2EE版) -
cgnnzg:
大神好 可以发一份源码给我学习么 多谢了 978241085 ...
springmvc+dubbo+zookeeper -
jifengjianhao:
求源码:854606899@qq.com
springmvc+dubbo+zookeeper -
wdloyeu:
shihuan8@163.com邮箱网盘在哪,没找到。能给份源 ...
Java Socket长连接示例代码 -
huangshangyuanji:
求代码:45613032@qq.com
springmvc+dubbo+zookeeper
[oracle@pacollector ~]$ lsnrctl status
[oracle@pacollector ~]$ lsnrctl start
[oracle@pacollector ~]$ lsnrctl stop
[oracle@pacollector ~]$ sqlplus /nolog
SQL> conn /as sysdba
SQL> startup --"启动数据库实例"
SQL> shutdown immediate --"关闭数据库实例"
或者
[oracle@pacollector ~]$ sqlplus / as sysdba
SQL> startup --"启动数据库实例"
SQL> shutdown immediate --"关闭数据库实例"
sqlplus username/password as sysdba
select * from v$version;
select userenv('language') from dual;
select * from dba_data_files;
create tablespace pa_middleware_data logging datafile '/u01/app/oracle/oradata/paoracle/quest_middleware_data.dbf' size 2049M autoextend on next 101m maxsize 20480m extent management local;
create tablespace pa_middleware_index logging datafile '/u01/app/oracle/oradata/paoracle/quest_middleware_index.dbf' size 2049m autoextend on next 101m maxsize 20480m extent management local;
create tablespace pa_collector_data logging datafile '/u01/app/oracle/oradata/pacollorcl/quest_collector_data.dbf' size 2049M autoextend on next 101m maxsize 20480m extent management local;
create tablespace pa_collector_index logging datafile '/u01/app/oracle/oradata/pacollorcl/quest_collector_index.dbf' size 2049m autoextend on next 101m maxsize 20480m extent management local;
drop tablespace pa_collector_data including contents and datafiles cascade constraints;
drop tablespace pa_collector_index including contents and datafiles cascade constraints;
alter database datafile '/ora/oradata/radius/undo.dbf' resize 10240m;
http://www.cnblogs.com/siyunianhua/p/4004361.html?utm_source=tuicool&utm_medium=referral
create user c##quest identified by quest;
grant connect,resource,dba to c##quest;
select username from dba_users where username='C##QUEST';
或者
select * from v$version;
select name,cdb from v$database;
select sys_context('USERENV', 'CON_NAME') from dual;
show con_name;
select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
alter pluggable database PDBCOLLORCL open;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
alter session set container=PDBCOLLORCL;
select sys_context('USERENV', 'CON_NAME') from dual;
show con_name;
create user quest identified by quest;
grant connect,resource,dba to quest;
commit;
select username from dba_users where username='QUEST';
select instance_name from v$instance;
sqlplus username/password@net_service_name 如:sqlplus username/password@pacollorcl
sqlplus username/password@pdb_name 如:sqlplus username/password@pacollorcl
[oracle@pacollector /]$ cd /u01/app/oracle/product/12.1.0/dbhome_1/network/admin
[oracle@pacollector admin]$ vi listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pacollector)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = pacollorcl)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = pacollorcl)
)
(SID_DESC =
(GLOBAL_DBNAME = PDBCOLLORCL)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = pacollorcl)
)
)
[oracle@pacollector admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PACOLLORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pacollector)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pacollorcl)
)
)
PDBCOLLORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pacollector)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBCOLLORCL)
)
)
[oracle@pacollector /]$ sqlplus quest@PDBCOLLORCL
[oracle@pacollector ~]$ lsnrctl start
[oracle@pacollector ~]$ lsnrctl stop
[oracle@pacollector ~]$ sqlplus /nolog
SQL> conn /as sysdba
SQL> startup --"启动数据库实例"
SQL> shutdown immediate --"关闭数据库实例"
或者
[oracle@pacollector ~]$ sqlplus / as sysdba
SQL> startup --"启动数据库实例"
SQL> shutdown immediate --"关闭数据库实例"
sqlplus username/password as sysdba
select * from v$version;
select userenv('language') from dual;
select * from dba_data_files;
create tablespace pa_middleware_data logging datafile '/u01/app/oracle/oradata/paoracle/quest_middleware_data.dbf' size 2049M autoextend on next 101m maxsize 20480m extent management local;
create tablespace pa_middleware_index logging datafile '/u01/app/oracle/oradata/paoracle/quest_middleware_index.dbf' size 2049m autoextend on next 101m maxsize 20480m extent management local;
create tablespace pa_collector_data logging datafile '/u01/app/oracle/oradata/pacollorcl/quest_collector_data.dbf' size 2049M autoextend on next 101m maxsize 20480m extent management local;
create tablespace pa_collector_index logging datafile '/u01/app/oracle/oradata/pacollorcl/quest_collector_index.dbf' size 2049m autoextend on next 101m maxsize 20480m extent management local;
drop tablespace pa_collector_data including contents and datafiles cascade constraints;
drop tablespace pa_collector_index including contents and datafiles cascade constraints;
alter database datafile '/ora/oradata/radius/undo.dbf' resize 10240m;
http://www.cnblogs.com/siyunianhua/p/4004361.html?utm_source=tuicool&utm_medium=referral
create user c##quest identified by quest;
grant connect,resource,dba to c##quest;
select username from dba_users where username='C##QUEST';
或者
select * from v$version;
select name,cdb from v$database;
select sys_context('USERENV', 'CON_NAME') from dual;
show con_name;
select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
alter pluggable database PDBCOLLORCL open;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
alter session set container=PDBCOLLORCL;
select sys_context('USERENV', 'CON_NAME') from dual;
show con_name;
create user quest identified by quest;
grant connect,resource,dba to quest;
commit;
select username from dba_users where username='QUEST';
select instance_name from v$instance;
sqlplus username/password@net_service_name 如:sqlplus username/password@pacollorcl
sqlplus username/password@pdb_name 如:sqlplus username/password@pacollorcl
[oracle@pacollector /]$ cd /u01/app/oracle/product/12.1.0/dbhome_1/network/admin
[oracle@pacollector admin]$ vi listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pacollector)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = pacollorcl)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = pacollorcl)
)
(SID_DESC =
(GLOBAL_DBNAME = PDBCOLLORCL)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = pacollorcl)
)
)
[oracle@pacollector admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PACOLLORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pacollector)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pacollorcl)
)
)
PDBCOLLORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pacollector)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBCOLLORCL)
)
)
[oracle@pacollector /]$ sqlplus quest@PDBCOLLORCL
发表评论
-
Oracle清理所有内存中的数据源链接
2018-01-23 10:19 989在实际生产过程可能会遇到频繁的更改Oracle数据库的Pack ... -
Oracle修改内存使用情况
2015-12-15 10:49 960[oracle@pamiddle ~]$ sqlplus / ... -
RedHat6.4安装Oracle12c 12.1.0.2.0
2015-12-07 16:32 2094[root@pacollector ~]# vi /etc/h ... -
静态方式把oracle实例配置到监听文件里
2015-08-21 21:25 1453本例Oracle的实例名字为parep。 原始的listen ... -
RedHat6.4安装Oracle11g 11.2.0.4
2015-07-25 22:36 2855[root@foglight ~]# vi /etc/host ... -
mysql和Oracle在对clob和blob字段的处理
2012-08-25 18:50 30906一、MySQL与Oracle数据库如何处理Clob,Bl ... -
Oracle Flashback技术
2012-04-14 14:12 1198http://www.cnblogs.com/coohoo/a ... -
Oracle相关资料大礼包
2012-03-08 11:08 1231附件里Oracle学习资料。 -
Oracle自带连接池应用
2011-08-31 13:27 2061依赖ojdbc14.jar包 OraclePooled.ja ... -
Oracle的几个Function实例
2011-03-10 13:50 1949create or replace function str_ ... -
几个Oracle procedure实例
2011-03-10 13:43 1516create or replace procedure PC_ ... -
Toad for Oracle 10下载
2010-11-11 21:12 16115Toad Development Suite for Orac ...
相关推荐
在Oracle12C环境中,JDBC驱动扮演着桥梁的角色,将Java应用程序的SQL语句转化为Oracle数据库能够理解的命令,同时也将数据库的响应转换回Java对象。 Oracle JDBC驱动分为四种类型: 1. ** Thin Driver**:也称为...
"oracle12C依赖包.zip"提供的内容显然涵盖了这些必要的组件,适用于Oracle 12c以及11g等其他版本。 "oracled.tar.gz"是一个包含Oracle相关文件的压缩包,可能包含了Oracle数据库的二进制文件、库文件、配置文件等。...
oracle 12c 数据库常用操作语句,欢迎带走,如果可以 少给一点也行
1.1.1 优盘:用于存储操作系统安装包和Oracle 12C的安装文件。 1.1.2 操作系统安装包:这里使用的是中标麒麟服务器版V7.4的操作系统ISO镜像。 1.1.3 Oracle 12C服务端安装包:这是数据库服务的核心软件,需提前下载...
ojdbc7.jar是Oracle JDBC驱动程序的特定版本,支持Java 7(即JDK 7)及更高版本,适用于Oracle 12c数据库。 错误“ORA-28040: 没有匹配的验证协议”通常是由于缺少合适的Oracle JDBC驱动或驱动版本不兼容引起的。当...
在介绍Oracle数据库12c及更高版本中的统一审计功能时,我们需要首先理解Oracle审计的基本概念和审计的方式。Oracle审计指的是记录数据库活动的过程,以便跟踪和审查数据库中的操作和数据访问。这有助于维护数据的...
本文详细介绍了在Linux环境下安全卸载Oracle 12c的具体步骤,包括关闭数据库、停止监听器、使用deinstall工具卸载软件、删除配置文件、清理残留文件、删除安装目录以及删除用户组等关键操作。遵循这些步骤可以确保...
1. 解压RAR文件:使用unrar命令或者WinRAR等工具解压“oracle12C RPM完整依赖包.rar”,这将生成一系列RPM包。 2. 更改到解压后的目录:使用`cd`命令进入包含RPM包的目录。 3. 安装依赖:使用`yum install -y 文件名...
4. **安装依赖包**:这正是“oracle12c依赖包centos7.4.zip”发挥作用的地方。它包含了诸如`compat-libstdc++-33`, `libaio`, `glibc`, `openssl`, `kernel-headers`等关键依赖,这些都是Oracle数据库运行所必需的。...
管理Oracle 12c RAC环境涉及到许多命令,这些命令用于监控和控制集群的运行。下面将详细介绍ORACLE 12c RAC的常用管理命令: 1. RAC查询 RAC查询包括查询节点信息、群集状态和集群中资源的状态。 1.1 查询节点 ...
Oracle 12c 需要在 Linux 操作系统上运行,推荐使用 Oracle Certified 的 Linux 发行版,如 Oracle Linux、Red Hat Enterprise Linux 等。 安装准备 1. 虚拟机配置:在虚拟机上安装 Oracle 12c,需要配置虚拟机的...
下面将详细介绍一些关键的Oracle 12c RAC管理命令。 1. **crsctl**: Oracle Clusterware 的控制工具,用于管理集群资源和服务。例如,`crsctl start crs` 启动整个CRS服务,`crsctl stop crs` 关闭CRS,`crsctl ...
在Windows Server 2016环境下部署Oracle 12C数据库时,由于版本更新带来的变动较大,加之缺乏相关维护经验,可能会遇到一系列连接问题。本文将详细介绍如何解决低版本客户端无法连接数据库、远程登录Oracle 12C的sys...
本文档旨在提供一份详细的Oracle 12c DataGuard环境搭建与主从切换的指南,适用于Linux操作系统下的Oracle 12c单实例部署场景。通过本文档的学习与实践,读者将能够掌握如何构建一个稳定可靠的DataGuard架构,以及...
Oracle 12c 数据库是 Oracle 公司推出的一个企业级数据库管理系统,它提供了高性能、高可用性和安全性等特性。ojdbc7.jar 是 Oracle 数据库的 JDBC(Java Database Connectivity)驱动程序,它是 Java 应用程序连接...
确保你的系统满足Oracle 12C的硬件和软件要求,特别是操作系统版本。在这个例子中,使用的平台是Red Hat Enterprise Server 5.x。你需要确保你的系统已更新到最新补丁,并且安装了所有必要的依赖包。对于Linux 5,...
本教程将指导您如何在 CentOS 6.5 操作系统上安装 Oracle 12c 数据库管理系统,旨在帮助读者熟悉 Oracle 数据库安装和配置过程。 一、 安装图形化基础包 在安装 Oracle 12c 之前,需要安装图形化基础包,包括 xdm ...
Oracle 数据库的安装环境需要满足一定的硬件和软件要求,例如至少需要 1 GB RAM,RHEL6 及以上版本的操作系统等。同时,Oracle 数据库企业版需要至少 7.5 GB 的磁盘空间。 4. 启动数据库阶段 启动数据库有三个阶段...
【Linux7安装单节点Oracle 12c数据库详细配置操作】 在企业环境中,Linux操作系统由于其稳定性、多用户支持、高度可调控性以及强大的错误排查能力,常常被选作服务器平台,尤其是对于运行Oracle数据库这样的关键...