- 博客(60)
- 资源 (35)
- 收藏
- 关注
转载 VCS双机改主机名
一. 单机改主机名需更改以下文件:/etc/hosts/etc/hostname.hme0(根据主网口更改)/etc/nodename/etc/net/ticots/hosts/etc/net/ticotsord/hosts/etc/net/tilts/h
2011-08-30 17:06:17 1230
原创 00058.Oracle重做日志配置
SQL> desc v$log; Name Null? Type ------------------------------------------------- --------------
2011-08-26 18:03:43 359
原创 00057.Oracle清理联机重做日志文件
SQL> alter database clear logfile group 3;SQL>alter database clear unarchived logfile group 3;
2011-08-26 18:02:46 323
原创 00056.Oracle管理联机重做日志成员(文件)
SQL> alter database add logfile member '/home/oracle/oracle/redo01b.log' to group1,'/home/oracle/oracle/redo02b.log' to group 2;SQL> alte
2011-08-26 18:02:17 305
原创 00055.Oracle管理联机重做日志文件组
SQL> select group#,sequence#,members,bytes,status,archived from v$log; GROUP# SEQUENCE# MEMBERS BYTES STATUS ARCH
2011-08-26 18:01:49 353
原创 00054.Oracle重做日志信息获取
SQL> desc v$log Name Null? Type ----------------------------------------- -----------------------
2011-08-26 18:01:11 344
原创 00053.Oracle控制文件备份
QL> alter database backup controlfile to '/home/oracle/oracle/backup/control.bak';Database altered. SQL> host ls -l-rw-r----- 1 orac
2011-08-26 18:00:14 301
原创 00052.Oracle控制文件移动
SQL> col namefor a40SQL> set line120SQL> select *from v$controlfile;STATUS NAME IS_RECBLOC
2011-08-26 17:59:37 368
原创 00051.Oracle控制文件信息获取及常用视图
SQL> select*from v$archived_log;SQL> select *fromv$backup; SQL> select*from v$database; SQL> select*from v$datafile; SQL> select*fro
2011-08-26 17:58:55 827
原创 00051.Oracle数据库的配置与结构信息获取
QL> set line 130SQL> select name,created,log_mode,open_mode from v$database; NAME CREATED LOG_MODE
2011-08-26 17:57:17 376
原创 00050.Oracle格式化输出
SQL> desc all_objects; Name Null? Type ------------------------------------------------- -------
2011-08-26 17:56:12 582
原创 00049.Oracle数据字典
SQL> descuser_objects Name Null? Type ------------------------------------------------- ---------
2011-08-26 17:55:29 540
原创 00048.Oracle诊断文件定位
SQL> col namefor a30SQL> col valuefor a45SQL> set line 1000SQL> set pagesize 30SQL> select name,value from v$parameter where name l
2011-08-26 17:54:57 321
原创 00046.Oracle用户进程杀死
SQL> descv$session;SQL> set line120SQL> col username for a30SQL> select sid,serial#,username,type from v$session; SID S
2011-08-26 17:53:36 482
原创 00045.Oracle启动数据库、设置数据库状态
racle@mdsps1:~/product/11.1.0/db_1/dbs>sqlplus "/as sysdba" SQL*Plus: Release11.2.0.1.0 Production on Wed Nov 17 20:49:42 2010 Copyr
2011-08-26 17:53:03 418
原创 00044.Oracle参数浏览
SQL> connect sys/oracle as sysdbaConnected.SQL> spool parameterSQL> show parameterSQL> spool off
2011-08-26 17:52:21 352
原创 00043.Oracle动态服务器参数文件创建
SQL> create pfile='pfileorac.ora' from spfile; File created. SQL> host lsc-615447911-20101110-000 init.ora orapwmdsp sp
2011-08-26 17:51:35 446
原创 00042.Oracle静态参数文件创建
oracle@mdsps1:~/product/11.1.0/db_1/dbs>cp init.ora $ORACLE_HOME/dbs/initorac.oraoracle@mdsps1:~/product/11.1.0/db_1/dbs>lsc-615447911-2
2011-08-26 17:50:55 430
原创 00041.Oracle 内存缓冲区信息获取
SQL> show sgaTotal System GlobalArea 835104768 bytesFixed Size 2217952 bytesVariable Size 629147680 byte
2011-08-26 17:50:18 369
原创 00040.Oracle数据库编码格式查看及乱码解决思路
SQL> select userenv('language') from dual; USERENV('LANGUAGE')----------------------------------------------------------------------
2011-08-26 17:46:01 1324
原创 00039.Oracle查询表空间文件大小
select sum(d.bytes)/1024/1024/1024||'G' as total_bytes, d.tablespace_name from dba_data_files d where d.tablespace_name = 'UNDOTBS03'
2011-08-26 17:44:41 528
原创 00038.Oracle清除已坏数据(非系统级)文件,恢复数据库
SQL>startup mount;SQL>alter databasedatafile ‘datafilename’ offline drop;SQL>alter database open;
2011-08-26 17:43:57 302
原创 00037.Oracle参数游标定义
语法:--定义:cursor cu_name(param1type,param2 type) is select xxx from tb where tb.name=param1 andtb.age=param2; 打开:open cu_name(1
2011-08-26 17:43:29 264
原创 00036.Oracle扩展表空间
Alter tablespace IMUSE01add datafile '/opt/oracle/oradata/orcl/imuse01_dat5' size 8GAlter tablespaceIMUSE01 add datafile '/opt/oracle/
2011-08-26 17:43:02 310
原创 00035.Oracle创建表空间
CREATE TABLESPACE tbs_03 DATAFILE 'tbs_f03.dbf' SIZE 20M MINIMUM EXTENT 5000K DEFAULT STORAGE (INITIAL 128K NEXT 128K) LOGGING
2011-08-26 17:42:29 253
原创 00034.Oracle字符集操作
查看select * from nls_database_parameters另外一种查看方式select userenv('language') from dual更新字符集方法 Startupnomount; Alter databas
2011-08-26 17:42:01 304
原创 00033.Oracle查询、更新临时表空间
select * from v$tablespacet where t.name like '%TEMP%'--ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp01; alter user bill_stat TEMPO
2011-08-26 17:40:59 289
原创 00031.Oracle强断电后,oracle无法启动解决方案
00031.1:SQL>create pfile='/opt/oracle/product/10.2/db_1/dbs/pfilemdsp.ora' from spfile切到 oracle用户下oracle$>vi /opt/oracle/product
2011-08-26 17:35:21 2144
原创 00030.Oracle设置强制启动参数
startup pfile='/opt/oracle/product/10.2/db_1/dbs/pfilemdsp.ora'nomount;用vi工具修改:_allow_resetlogs_corruption=true重构spfilecreate sp
2011-08-26 17:31:05 701
原创 00028.Oracle查询重做日志截断开关状态_allow_resetlogs_corruption
select name,valuefrom v$parameter v where v.name like '%_allow_resetlogs%'
2011-08-26 17:29:31 478
原创 00027.Oracle查看alter日志的位置方法二
select name,value from v$parameter v where v.name like '%background%';
2011-08-26 17:27:42 1449
原创 00023.Oracle数据导出、导入
实例:oracle@linux:~> exp report/report tables=(t1,t2) owner=report rows=y compress=nbuffer=10240000 feedback=10000000 file=report_2010003
2011-08-26 17:24:38 943
原创 00022.OracleUnion all 与union分析
Union all:select a from(select 'a' as a from dualunion allselect 'b' as a from dualunion allselect 'a' as a from dual)结果
2011-08-26 17:23:47 381
原创 00021.Oracle建表(指定表空间、索引空间)
create table temp_0001( Field1 varchar2(1000) not null,Fiels2 varchar2(10000)) tablespace data0001 pctfree 10 initrans 1 max
2011-08-26 17:22:45 3025
sourceinsight4安装文件及补丁(截止2019-08-14,win7下安装测试可用)
2019-08-14
利用Python进行数据分析[书籍+源码+数据]
2017-12-09
社交网站的数据挖掘与分析_第2版【2017-12-09下载验证完整后上传-53171KB】.pdf
2017-12-09
Hadoop in Action
2016-11-29
myeclipse PMD插件
2015-04-28
spring-objenesis-repack-2.1.jar
2015-04-27
Practical J2EE Application Architecture
2013-02-24
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人