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

회원가입

ORA-04045: errors during recompilation/revalidation of XSERVER.CO_NO_DROP

최길호 [LIST]

2021-09-15 19:43:55, 조회 : 360



SQL> @$ORACLE_HOME/rdbms/admin/catcmprm.sql ORDIM

SELECT dbms_registry_sys.removal_script('ORDIM')

       *

ERROR at line 1:

ORA-04045: errors during recompilation/revalidation of XSERVER.CO_NO_DROP

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 196

ORA-04045: errors during recompilation/revalidation of XSERVER.CO_NO_DROP

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 257

ORA-06512: at "SYS.DBMS_REGISTRY_SYS", line 1001



select

  lpad(' ', 2*level) || granted_role "User, his roles and privileges"

  from

  (

  select null grantee, username granted_role from dba_users

  where username like upper('XSERVER')

  union

  select grantee, granted_role

  from dba_role_privs

  union

  select grantee, privilege

  from dba_sys_privs

  )

  start with grantee is null

  connect by grantee = prior granted_role;



조치:

grant ADMINISTER DATABASE TRIGGER to XSERVER ;



출처: ORA-04045: errors during recompilation/revalidation of MDSYS.SDO_ST_SYN_CREATE, ORA-01031: insufficient privileges (Doc ID 2144698.1)

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