ORACLE

http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX

01.게시판

게시판 [69]

02.File Book

		File 자료실 [95]
		Site Link [18]
		개인폴더 [194]

03.Field Book

		Altibase [19]
		Tibero [30]
		MS-SQL [18]
		MySQL [40]
		DB2 [79]
		ORACLE [2896]
		PostgreSQL [103]
		기타정보 [150]
		운영체제 [583]

04.Q/A Book

Q/A [53]

05.방명록

		방명록 [54]
		레벨업 [37]
		구인/구직 [2]

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: ORACLE

회원가입

10g, 12c, 19c upgrade filename /dev/raw -> /oradata/ -> +DATA/ [ awr 추가 update ]

최길호 [LIST]

2021-09-19 02:34:42, 조회 : 303

-- awrp 10g, 12c 제거

select host_name||' '||version from DBA_HIST_DATABASE_INSTANCE;

delete DBA_HIST_DATABASE_INSTANCE where version not in ('19.0.0.0.0');

-- awr filename update

update DBA_HIST_DATAFILE set filename =

(select file_name from dba_data_files where file_id=file#);

-- awr tempfile [ temp 데이터 있는거만 찾아서 저장 되면 나중에 자동 정리 될지도... ]

delete DBA_HIST_TEMPFILE;

insert into WRH$_TEMPFILE

select (select max(snap_id) from DBA_HIST_SNAPSHOT),(select dbid from v$database),FILE#,CREATION_CHANGE#,NAME,TS#,'TEMP',8192,(select dbid from v$database),0

from v$tempfile;

-- or

delete DBA_HIST_TEMPFILE where not exists ( select 1 from dba_temp_files where file_id=file#);

update DBA_HIST_TEMPFILE set FILENAME=(select file_name from dba_temp_files where file_id=file#);



commit;

18.207.157.152

LIST

	제목	작성자	작성일	조회
Install and Config	ASM Filter / asmcmd afd_label / asmcmd afd_lslbl / gridSetup.sh 설치전 asm disk	최길호	2021/10/07	288
Troubleshoot	sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found	최길호	2021/10/06	692
Troubleshoot	19c _optimizer_cost_based_transformation off bug [ SR 확인 ] lv:9	최길호	2021/10/05	889
Troubleshoot	ORA-12609: TNS: Receive timeout occurred	최길호	2021/10/03	1009
Troubleshoot	EXP-00083: The previous problem occurred when calling SYS.DBMS_AUTO_TASK_EXPORT.system_info_exp	최길호	2021/10/02	796
Troubleshoot	grid 19c crsctl start has / CRS-41053 / Infrastructure has 재구축	최길호	2021/10/01	834
Troubleshoot	ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT	최길호	2021/09/30	277
Admin	alter table add column large table [ 11gR2 부터 빠르다 ]	최길호	2021/09/29	261
Troubleshoot	ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1	최길호	2021/09/29	486
Troubleshoot	alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk	최길호	2021/09/28	3969
Install and Config	create diskgroup data1 normal redundancy failgroup fg1 disk	최길호	2021/09/28	311
Troubleshoot	[INS-30525] Insufficient number of failure groups specified for Normal Redundancy level.	최길호	2021/09/28	292
Troubleshoot	PRVG-11095 : The TCP system call "connect" failed with error "113"	최길호	2021/09/28	342
Troubleshoot	ORA-00600: internal error code, arguments: [tsdrv1-Bug#24841100]	최길호	2021/09/25	346
Install and Config	ORA-24247: network access denied by access control list (ACL)	최길호	2021/09/24	315
Troubleshoot	ORA-12805 Parallel Query Server Died	최길호	2021/09/23	370