ucjmh

好好学习,天天向上

 » 2014 » Archive by month "December"
December 28 2014

ORA-01092:ORACLE instance terminated. Disconnection forced

SQL> ho oerr ora 01092
01092, 00000, “ORACLE instance terminated. Disconnection forced”
// *Cause:  The instance this process was connected to was[……]

Read more

Category: oracle | LEAVE A COMMENT
December 26 2014

oracle constraint check and default

CREATE TABLE test1
(
ID NUMBER,
NAME VARCHAR2(20),
sex CHAR(2)  DEFAULT ‘男’ CHECK(sex IN(‘男’,’女’)),
age NUMBER
)

CREATE TABLE test1
(
ID NUMBER,
NAME[……]

Read more

Category: oracle | LEAVE A COMMENT
December 26 2014

linux split file

[root@hebdb ~]# split –h
Usage: split [OPTION]… [INPUT [PREFIX]]
Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, …; default
size is 1000[……]

Read more

Category: linux | LEAVE A COMMENT
December 26 2014

weblogic 把日志每周备一次

[weblogic@hebapp ~]$ cat copylog.sh
#!/bin/sh
cp /opt/weblogic/wllogs/esf.log /opt/weblogic/wllogs/esflogfiles/esf`date “+%Y%m%d%H%M”`”.log”
echo ” &[……]

Read more

Category: linux | LEAVE A COMMENT
December 23 2014

ORA-00257 archiver error Connect internal only until freed

ORA-00257 archiver error Connect internal only until freed
00257, 00000, “archiver error. Connect internal only, until freed.”
// *Cause:  The archive[……]

Read more

Category: oracle | LEAVE A COMMENT
December 22 2014

ORA-00600: internal error code, arguments: [4194]

ORA-00600: internal error code, arguments: [4194]
SQL> create undo tablespace undotbs2 datafile ‘/u01/app/oracle/oradata/orcl/undotbs02.dbf’ size 1[……]

Read more

Category: oracle | LEAVE A COMMENT
December 22 2014

ora-00031

ora-00031:session marked for kill

00031, 00000, “session marked for kill”
// *Cause: The session specified in an ALTER SYSTEM KILL SESSION command
//[……]

Read more

Category: oracle | LEAVE A COMMENT
December 19 2014

RMAN-05541: no archived logs found in target database

RMAN-05541: no archived logs found in target database

[oracle@gsoracle admin]$ rman target sys/oracle@web auxiliary sys/oracle@webp

Recovery Manager[……]

Read more

Category: oracle | LEAVE A COMMENT
December 19 2014

linux sar

用来查看网络使用和流量

sar -n DEV 5 2

Usage: sar [ options ] [ <interval> [ <count> ] ]
Options are:
[ -A ] [ -b ] [ -B ] [ -C ] [ -d ] [ -h ] [ -m[……]

Read more

Category: linux | LEAVE A COMMENT
December 17 2014

Checking to see if Oracle CRS stack is already configured

/u01/crs_1/root.sh

如果在配置crs的时候不小心点了ctrl+c stop住了可以

ps -ef|grep root.sh

kill -9 进程

那就:rm /etc/oracle/scls_scr/node2/oracle/cssfatal

 

把两个节点的[……]

Read more

Category: oracle | LEAVE A COMMENT
1 2 Next page

  • about me
  • Welcome to ucjmh!

Recent Posts

  • lber.h: No such file or directory
  • library not found for -lssl
  • fatal error: ‘sasl.h’ file not found
  • mysql-statefulset.yaml
  • mysql 5.7 dockerfile
  • db tools
  • 定时生产audit的表
  • mysql mgr搭建
  • CRONTAB 不执行
  • mgr单主模式

Recent Comments

    Archives

    • April 2018 (1)
    • March 2018 (3)
    • February 2018 (1)
    • January 2018 (2)
    • December 2017 (3)
    • November 2017 (7)
    • October 2017 (1)
    • July 2017 (1)
    • June 2017 (2)
    • May 2017 (1)
    • February 2017 (2)
    • January 2017 (2)
    • October 2016 (5)
    • September 2016 (10)
    • August 2016 (11)
    • July 2016 (12)
    • June 2016 (4)
    • May 2016 (12)
    • April 2016 (7)
    • March 2016 (13)
    • February 2016 (11)
    • January 2016 (26)
    • December 2015 (26)
    • November 2015 (21)
    • October 2015 (11)
    • September 2015 (25)
    • August 2015 (6)
    • July 2015 (16)
    • June 2015 (16)
    • May 2015 (6)
    • April 2015 (10)
    • March 2015 (22)
    • February 2015 (12)
    • January 2015 (13)
    • December 2014 (20)
    • November 2014 (17)
    • October 2014 (15)
    • September 2014 (20)
    • August 2014 (17)
    • July 2014 (19)
    • June 2014 (19)
    • May 2014 (18)
    • April 2014 (8)
    • March 2014 (11)
    • February 2014 (10)
    • January 2014 (11)
    • December 2013 (6)
    • November 2013 (8)
    • October 2013 (5)
    • September 2013 (2)
    • August 2013 (2)

    Categories

    • linux (28)
    • 其它 (31)
      • python (17)
      • vm (2)
      • websphere (6)
    • 心情 (14)
    • 技术 (454)
      • cognos (7)
      • 数据库 (430)
        • db2 (3)
        • mongodb (5)
        • mysql (155)
        • oracle (255)
        • redis (4)
        • sqlserver (10)
        • sybase (1)
      • 编程语言 (17)
        • c# (5)
        • C语言 (1)
        • java (7)
        • javascript (4)
    • 未分类 (2)

    Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org

    this is technology blog of oracle/mysql if u have any question pls contact me,

    December 2014
    M T W T F S S
    « Nov   Jan »
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  

    Categories

    c# cognos C语言 db2 java javascript linux mongodb mysql oracle python redis sqlserver sybase vm websphere 其它 心情 技术 数据库 未分类 编程语言

    • lber.h: No such file or directory
    • library not found for -lssl
    • fatal error: ‘sasl.h’ file not found
    • mysql-statefulset.yaml
    • mysql 5.7 dockerfile
    • db tools



    Copyright 2019. All rights reserved.
    WordPress theme "Anarcho Notepad" by Space X-Chimp.
    34 queries in 0.579 seconds / 22.71 mb