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

Read more

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

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

Read more

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

Read more

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

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

/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