orcl

9.2.0.8에서 DBCA를 통해 DB생성시 ora-29807에러 발생 ignore로 계속 진행하니..문제없이 종료됨. Note:239304.1 Creating Database Using DBCA Under 9.2.0.2.0 or 9.2.0.3.0 - ORA-29807 Is Encountered Problem While using Database Creation Assistant (DBCA) to create a database (custom or template) after patchset 9.2.0.2.0 or 9.2.0.3.0 has been applied, ORA-29807 'specified operator does not exist' is encountered during 'create dat..

shell script에서 oracle sqlplus를 실행하려니 syntax error at line 67 : `

ERP APPS의 접속통제로 조회용 유저에서 alter session set current_schema = apps ; 로 사용중인데 database link 부분에서 ora-2019 에러 발생 조회용 유저에 private database link를 생성해도 에러 발생 그래서 public database link를 생성하니 해결됨. ORA-02019: connection description for remote database not found [참고자료] Cause When an ALTER SESSION SET current_schema is executed from the current session, the dblink is searched as the PUBLIC user, but not as t..

00439, 00000, "feature not enabled: %s" // *Cause: The specified feature is not enabled. // *Action: Do not attempt to use this feature. To Verify if the Partitioning Option is enabled in the Database, do the following: - Initiate SQL*Plus and the logon banner will show: SQL*Plus: Release 8.1.7.0.0 - Production (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i En..

ORA-00600: internal error code, arguments: [13262], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [15056], [], [], [], [], [], [], [] 8.1.7.3 에서 발생 서비스 이상없음. Stack Trace :ksedmp ksfdmp kgeriv kgesiv ksesic0 kziaia kpolnb kpolon opiodr ttcpip opitsk opiino opiodr opidrv sou2o main WORKAROUND: Set audit_trail=false.