Default Oracle Passwords

Just a few default Oracle usernames and associated passwords to go with them:

(Note:-  You will need to place this file in the OAT/ OScanner directories as the default installation of these tools only checks for around 130 of the 600 quoted here).

_________________________________________________

#INTERNAL	ORACLE
#INTERNAL	SYS_STNT
ABM	ABM
ADAMS	WOOD
ADLDEMO	ADLDEMO
ADMIN	JETSPEED
ADMIN	WELCOME
ADMINISTRATOR	ADMIN
ADMINISTRATOR	ADMINISTRATOR
AHL	AHL
AHM	AHM
AK	AK
ALHRO	XXX
ALHRW	XXX
ALR	ALR
AMS	AMS
AMV	AMV
ANDY	SWORDFISH
ANONYMOUS	ANONYMOUS
ANONYMOUS	<INVALID>
AP	AP
APPLMGR	APPLMGR
APPLSYS	APPLSYS
APPLSYS	APPS
APPLSYS	FND
APPLSYSPUB	APPLSYSPUB
APPLSYSPUB	PUB
APPLSYSPUB	FNDPUB
APPLYSYSPUB	FNDPUB
APPLYSYSPUB	PUB
APPLYSYSPUB	<UNKNOWN>
APPS	APPS
APPS_MRC	APPS
APPUSER	APPPASSWORD
AQ	AQ
AQDEMO	AQDEMO
AQJAVA	AQJAVA
AQUSER	AQUSER
AR	AR
ASF	ASF
ASG	ASG
ASL	ASL
ASO	ASO
ASP	ASP
AST	AST
ATM	SAMPLEATM
AUDIOUSER	AUDIOUSER
AURORA$JIS$UTILITY$	<INVALID>
AURORA$JIS$UTILITY$	INVALID
AURORA$ORB$UNAUTHENTICATED	INVALID
AURORA$ORB$UNAUTHENTICATED	<INVALID>
AX	AX
AZ	AZ
BC4J	BC4J
BEN	BEN
BIC	BIC
BIL	BIL
BIM	BIM
BIS	BIS
BIV	BIV
BIX	BIX
BLAKE	PAPER
BLEWIS	BLEWIS
BOM	BOM
BRIO_ADMIN	BRIO_ADMIN
BRUGERNAVN	ADGANGSKODE
BRUKERNAVN	PASSWORD
BSC	BSC
BUG_REPORTS	BUG_REPORTS
CALVIN	HOBBES
CATALOG	CATALOG
CCT	CCT
CDEMO82	CDEMO82
CDEMO82	CDEMO83
CDEMO82	UNKNOWN
CDEMOCOR	CDEMOCOR
CDEMORID	CDEMORID
CDEMOUCB	CDEMOUCB
CDOUGLAS	CDOUGLAS
CE	CE
CENTRA	CENTRA
CENTRAL	CENTRAL
CIDS	CIDS
CIS	CIS
CIS	ZWERG
CISINFO	CISINFO
CISINFO	ZWERG
CLARK	CLOTH
CLKANA	<UNKNOWN>
CLKRT	<UNKNOWN>
CN	CN
COMPANY	COMPANY
COMPIERE	COMPIERE
CQSCHEMAUSER	PASSWORD
CQUSERDBUSER	PASSWORD
CRP	CRP
CS	CS
CSC	CSC
CSD	CSD
CSE	CSE
CSF	CSF
CSI	CSI
CSL	CSL
CSMIG	CSMIG
CSP	CSP
CSR	CSR
CSS	CSS
CTXDEMO	CTXDEMO
CTXSYS	<UNKNOWN>
CTXSYS	CHANGE_ON_INSTALL
CTXSYS	CTXSYS
CTXSYS	UNKNOWN
CUA	CUA
CUE	CUE
CUF	CUF
CUG	CUG
CUI	CUI
CUN	CUN
CUP	CUP
CUS	CUS
CZ	CZ
DATA_SCHEMA	LASKJDF098KSDAF09
DBI	MUMBLEFRATZ
DBSNMP	DBSNMP
DBVISION	DBVISION
DCM	<UNKNOWN>
DDIC	199220706
DEMO	DEMO
DEMO8	DEMO8
DEMO9	DEMO9
DES	DES
DES2K	DES2K
DEV2000_DEMOS	DEV2000_DEMOS
DIANE	PASSWO1
DIP	DIP
DISCOVERER_ADMIN	DISCOVERER_ADMIN
DISCOVERER5	<UNKNOWN>
DMSYS	DMSYS
DPF	DPFPASS
DSGATEWAY	<UNKNOWN>
DSGATEWAY	DSGATEWAY
DSSYS	DSSYS
DTSP	DTSP
EAA	EAA
EAM	EAM
EARLYWATCH	SUPPORT
EAST	EAST
EC	EC
ECX	ECX
EJB	EJB
EJSADMIN	EJSADMIN
EJSADMIN	EJSADMIN_PASSWORD
EMP	EMP
ENG	ENG
ENI	ENI
ESTOREUSER	ESTORE
EVENT	EVENT
EVM	EVM
EXAMPLE	EXAMPLE
EXFSYS	EXFSYS
EXTDEMO	EXTDEMO
EXTDEMO2	EXTDEMO2
FA	FA
FEM	FEM
FII	FII
FINANCE	FINANCE
FINPROD	FINPROD
FLM	FLM
FND	FND
FOO	BAR
FPT	FPT
FRM	FRM
FROSTY	SNOWMAN
FTE	FTE
FV	FV
GL	GL
GMA	GMA
GMD	GMD
GME	GME
GMF	GMF
GMI	GMI
GML	GML
GMP	GMP
GMS	GMS
GPFD	GPFD
GPLD	GPLD
GR	GR
HADES	HADES
HCPARK	HCPARK
HLW	HLW
HR	<UNKNOWN>
HR	CHANGE_ON_INSTALL
HR	HR
HR	UNKNOWN
HRI	HRI
HVST	HVST
HXC	HXC
HXT	HXT
IBA	IBA
IBE	IBE
IBP	IBP
IBU	IBU
IBY	IBY
ICDBOWN	ICDBOWN
ICX	ICX
IDEMO_USER	IDEMO_USER
IEB	IEB
IEC	IEC
IEM	IEM
IEO	IEO
IES	IES
IEU	IEU
IEX	IEX
IFSSYS	IFSSYS
IGC	IGC
IGF	IGF
IGI	IGI
IGS	IGS
IGW	IGW
IMAGEUSER	IMAGEUSER
IMC	IMC
IMEDIA	IMEDIA
IMT	IMT
INTERNAL	ORACLE
INTERNAL	SYS_STNT
INV	INV
IPA	IPA
IPD	IPD
IPLANET	IPLANET
ISC	ISC
ITG	ITG
JA	JA
JAKE	PASSWO4
JE	JE
JG	JG
JILL	PASSWO2
JL	JL
JMUSER	JMUSER
JOHN	JOHN
JONES	STEEL
JTF	JTF
JTM	JTM
JTS	JTS
JWARD	AIROPLANE
KWALKER	KWALKER
L2LDEMO	L2LDEMO
LBACSYS	LBACSYS
LIBRARIAN	SHELVES
MANPROD	MANPROD
MARK	PASSWO3
MASCARM	MANAGER
MASTER	PASSWORD
MDDATA	MDDATA
MDDEMO	MDDEMO
MDDEMO_CLERK	CLERK
MDDEMO_CLERK	MGR
MDDEMO_MGR	MDDEMO_MGR
MDDEMO_MGR	MGR
MDSYS	MDSYS
ME	ME
MFG	MFG
MGR	MGR
MGWUSER	MGWUSER
MIGRATE	MIGRATE
MILLER	MILLER
MMO2	MMO2
MMO2	MMO3
MMO2	UNKNOWN
MODTEST	YES
MOREAU	MOREAU
MRP	MRP
MSC	MSC
MSD	MSD
MSO	MSO
MSR	MSR
MTS_USER	MTS_PASSWORD
MTSSYS	MTSSYS
MWA	MWA
MXAGENT	MXAGENT
NAMES	NAMES
NEOTIX_SYS	NEOTIX_SYS
NNEUL	NNEULPASS
NOM_UTILISATEUR	MOT_DE_PASSE
NOME_UTILIZADOR	SENHA
NOMEUTENTE	PASSWORD
NUME_UTILIZATOR	PAROL
OAIHUB902	<UNKNOWN>
OAS_PUBLIC	OAS_PUBLIC
OAS_PUBLIC	<UNKNOWN>
OCITEST	OCITEST
OCM_DB_ADMIN	<UNKNOWN>
OCM_DB_ADMIN	OCM_DB_ADMIN
ODM	ODM
ODM_MTR	MTRPW
ODS	ODS
ODS_SERVER	ODS_SERVER
ODSCOMMON	ODSCOMMON
OE	CHANGE_ON_INSTALL
OE	UNKNOWN
OE	OE
OEM_REPOSITORY	<UNKNOWN>
OEMADM	OEMADM
OEMREP	OEMREP
OKB	OKB
OKC	OKC
OKE	OKE
OKI	OKI
OKO	OKO
OKR	OKR
OKS	OKS
OKX	OKX
OLAPDBA	OLAPDBA
OLAPSVR	INSTANCE
OLAPSVR	OLAPSVR
OLAPSYS	MANAGER
OLAPSYS	OLAPSYS
OMWB_EMULATION	ORACLE
ONT	ONT
OO	OO
OPENSPIRIT	OPENSPIRIT
OPI	OPI
ORACACHE	<UNKNOWN>
ORACACHE	ORACACHE
ORACLE	ORACLE
ORADBA	ORADBAPASS
ORANGE	<UNKNOWN>
ORAPROBE	ORAPROBE
ORAREGSYS	ORAREGSYS
ORASSO	ORASSO
ORASSO_DS	ORASSO_DS
ORASSO_PA	ORASSO_PA
ORASSO_PS	ORASSO_PS
ORASSO_PUBLIC	ORASSO_PUBLIC
ORASTAT	ORASTAT
ORCLADMIN	WELCOME
ORDCOMMON	ORDCOMMON
ORDPLUGINS	ORDPLUGINS
ORDSYS	ORDSYS
OSE$HTTP$ADMIN	Invalid password
OSE$HTTP$ADMIN	INVALID
OSM	OSM
OSP22	OSP22
OSSAQ_HOST	<UNKNOWN>
OSSAQ_PUB	<UNKNOWN>
OSSAQ_SUB	<UNKNOWN>
OTA	OTA
OUTLN	OUTLN
OWA	OWA
OWA_PUBLIC	OWA_PUBLIC
OWF_MGR	<UNKNOWN>
OWF_MGR	OWF_MGR
OWNER	OWNER
OZF	OZF
OZP	OZP
OZS	OZS
PA	PA
PANAMA	PANAMA
PATROL	PATROL
PAUL	PAUL
PERFSTAT	PERFSTAT
PERSTAT	PERSTAT
PJM	PJM
PLANNING	PLANNING
PLEX	PLEX
PLSQL	SUPERSECRET
PM	CHANGE_ON_INSTALL
PM	UNKNOWN
PM	PM
PMI	PMI
PN	PN
PO	PO
PO7	PO7
PO8	PO8
POA	POA
POM	POM
PORTAL	<UNKNOWN>
PORTAL_APP	<UNKNOWN>
PORTAL_DEMO	<UNKNOWN>
PORTAL_DEMO	PORTAL_DEMO
PORTAL_PUBLIC	<UNKNOWN>
PORTAL_SSO_PS	PORTAL_SSO_PS
PORTAL30	PORTAL30
PORTAL30	PORTAL31
PORTAL30_ADMIN	PORTAL30_ADMIN
PORTAL30_DEMO	PORTAL30_DEMO
PORTAL30_PS	PORTAL30_PS
PORTAL30_PUBLIC	PORTAL30_PUBLIC
PORTAL30_SSO	PORTAL30_SSO
PORTAL30_SSO_ADMIN	PORTAL30_SSO_ADMIN
PORTAL30_SSO_PS	PORTAL30_SSO_PS
PORTAL30_SSO_PUBLIC	PORTAL30_SSO_PUBLIC
POS	POS
POWERCARTUSER	POWERCARTUSER
PRIMARY	PRIMARY
PSA	PSA
PSB	PSB
PSP	PSP
PUBSUB	PUBSUB
PUBSUB1	PUBSUB1
PV	PV
QA	QA
QDBA	QDBA
QP	QP
QS	CHANGE_ON_INSTALL
QS	QS
QS	UNKNOWN
QS_ADM	CHANGE_ON_INSTALL
QS_ADM	QS_ADM
QS_ADM	UNKNOWN
QS_CB	CHANGE_ON_INSTALL
QS_CB	QS_CB
QS_CB	UNKNOWN
QS_CBADM	CHANGE_ON_INSTALL
QS_CBADM	QS_CBADM
QS_CBADM	UNKNOWN
QS_CS	CHANGE_ON_INSTALL
QS_CS	QS_CS
QS_CS	UNKNOWN
QS_ES	CHANGE_ON_INSTALL
QS_ES	QS_ES
QS_ES	UNKNOWN
QS_OS	CHANGE_ON_INSTALL
QS_OS	QS_OS
QS_OS	UNKNOWN
QS_WS	CHANGE_ON_INSTALL
QS_WS	QS_WS
QS_WS	UNKNOWN
RE	RE
REP_MANAGER	DEMO
REP_OWNER	DEMO
REP_OWNER	REP_OWNER
REP_USER	DEMO
REPADMIN	REPADMIN
REPORTS	REPORTS
REPORTS_USER	OEM_TEMP
RG	RG
RHX	RHX
RLA	RLA
RLM	RLM
RMAIL	RMAIL
RMAN	RMAN
RRS	RRS
SAMPLE	SAMPLE
SAP	SAPR3
SAP	6071992
SAPR3	SAP
SCOTT	TIGER
SCOTT	TIGGER
SDOS_ICSAP	SDOS_ICSAP
SECDEMO	SECDEMO
SERVICECONSUMER1	SERVICECONSUMER1
SH	CHANGE_ON_INSTALL
SH	SH
SH	UNKNOWN
SI_INFORMTN_SCHEMA	SI_INFORMTN_SCHEMA
SITEMINDER	SITEMINDER
SLIDE	SLIDEPW
SPIERSON	SPIERSON
SSP	SSP
STARTER	STARTER
STRAT_USER	STRAT_PASSWD
SWPRO	SWPRO
SWUSER	SWUSER
SYMPA	SYMPA
SYS	0RACLE8
SYS	0RACLE9
SYS	0RACLE8I
SYS	0RACL38
SYS	0RACL39
SYS	0RACL38I
SYS	CHANGE_ON_INSTALL
SYS	D_SYSPW
SYS	MANAGER
SYS	ORACLE
SYS	SYS
SYS	SYSPASS
SYS	MANAG3R
SYS	ORACL3
SYS	0RACLE
SYS	0RACL3
SYS	ORACLE8
SYS	ORACLE9
SYS	ORACLE8I
SYS	ORACLE9I
SYS	0RACLE9I
SYS	0RACL39I
SYSADM	SYSADM
SYSADMIN	<UNKNOWN>
SYSADMIN	SYSADMIN
SYSMAN	SYSMAN
SYSMAN	OEM_TEMP
SYSTEM	CHANGE_ON_INSTALL
SYSTEM	D_SYSPW
SYSTEM	MANAGER
SYSTEM	ORACLE
SYSTEM	SYSTEMPASS
SYSTEM	SYSTEM
SYSTEM	MANAG3R
SYSTEM	ORACL3
SYSTEM	0RACLE
SYSTEM	0RACL3
SYSTEM	ORACLE8
SYSTEM	ORACLE9
SYSTEM	ORACLE9I
SYSTEM	0RACLE9I
SYSTEM	0RACL39I
SYSTEM	D_SYSTPW
SYSTEM	ORACLE8I
SYSTEM	0RACLE8
SYSTEM	0RACLE9
SYSTEM	0RACLE8I
SYSTEM	0RACL38
SYSTEM	0RACL39
SYSTEM	0RACL38I
TAHITI	TAHITI
TALBOT	MT6CH5
TDOS_ICSAP	TDOS_ICSAP
TEC	TECTEC
TEST	PASSWD
TEST	TEST
TEST_USER	TEST_USER
TESTPILOT	TESTPILOT
THINSAMPLE	THINSAMPLEPW
TIBCO	TIBCO
TIP37	TIP37
TRACESVR	TRACE
TRAVEL	TRAVEL
TSDEV	TSDEV
TSUSER	TSUSER
TURBINE	TURBINE
UDDISYS	<UNKNOWN>
ULTIMATE	ULTIMATE
UM_ADMIN	UM_ADMIN
UM_CLIENT	UM_CLIENT
USER	USER
USER_NAME	PASSWORD
USER0	USER0
USER1	USER1
USER2	USER2
USER3	USER3
USER4	USER4
USER5	USER5
USER6	USER6
USER7	USER7
USER8	USER8
USER9	USER9
USUARIO	CLAVE
UTILITY	UTILITY
UTLBSTATU	UTLESTAT
VEA	VEA
VEH	VEH
VERTEX_LOGIN	VERTEX_LOGIN
VIDEOUSER	VIDEOUSER
VIF_DEVELOPER	VIF_DEV_PWD
VIRUSER	VIRUSER
VPD_ADMIN	AKF7D98S2
VRR1	VRR1
VRR1	VRR2
VRR1	UNKNOWN
WEBCAL01	WEBCAL01
WEBDB	WEBDB
WEBREAD	WEBREAD
WEBSYS	MANAGER
WEBUSER	YOUR_PASS
WEST	WEST
WFADMIN	WFADMIN
WH	WH
WIP	WIP
WIRELESS	<UNKNOWN>
WK_PROXY	<UNKNOWN>
WK_SYS	<UNKNOWN>
WK_TEST	WK_TEST
WKADMIN	WKADMIN
WKPROXY	WKPROXY
WKPROXY	CHANGE_ON_INSTALL
WKPROXY	UNKNOWN
WKSYS	CHANGE_ON_INSTALL
WKSYS	WKSYS
WKUSER	WKUSER
WMS	WMS
WMSYS	WMSYS
WOB	WOB
WPS	WPS
WSH	WSH
WSM	WSM
WWW	WWW
WWWUSER	WWWUSER
XADEMO	XADEMO
XDB	CHANGE_ON_INSTALL
XDP	XDP
XLA	XLA
XNC	XNC
XNI	XNI
XNM	XNM
XNP	XNP
XNS	XNS
XPRT	XPRT
XTR	XTR

ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

Solution for below information alert.

Alert log File information:

Mon Nov 28 22:00:10 2011

DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.

Errors in file /u01/oracle/admin/testdb/diag/rdbms/testdb/testdb/trace/testdb_j000_14552.trc:

ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

KUP-11024: This external table can only be accessed from within a Data Pump job.

 I have checked the alert log and respective trace files. On Trace files, I found some information alert.

Trace File Information:

DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"owner"','"tablename"','""', ...)
DBMS_STATS: ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists

I have checked metalink notes and got the solutions.

Why we getting this error everyday midnight?

1.    While nightly stats gather job (DBMS_STATS) is running and when trying to gather statistics for temporary data pump external tables, we are getting the above error.

2.    Temporary Datapump external tables have not been cleaned up properly. These should have been dropped when the DataPump jobs completed.

Note: while datapump running, oracle internally create master table for tracking and putting the datapump status. This master table helps to stop or start the datapump jobs.

Solutions:  To clean up the Orphaned datapump jobs.

1.    To ensure that there is no datapump jobs running at the same time as the dbms_stats job

2.    To Check and cleanup orphaned datapump jobs.

SELECT owner_name, job_name, operation, job_mode,

state, attached_sessions

FROM dba_datapump_jobs

WHERE job_name NOT LIKE 'BIN$%'

ORDER BY 1,2;

3.    To identify the external tables.

SQL> conn / as sysdba

Connected.

SQL>

set linesize 200 trimspool on

set pagesize 2000

col owner form a30

col created form a25

col last_ddl_time form a25

col object_name form a30

col object_type form a25

SQL>

select OWNER,OBJECT_NAME,OBJECT_TYPE, status,

to_char(CREATED,'dd-mon-yyyy hh24:mi:ss') created

,to_char(LAST_DDL_TIME , 'dd-mon-yyyy hh24:mi:ss') last_ddl_time

from dba_objects

where object_name like 'ET$%'

/

OWNER                          OBJECT_NAME                    OBJECT_TYPE               STATUS  CREATED                   LAST_DDL_TIME

------------------------------ ------------------------------ ------------------------- ------- ------------------------- -------------------------

PRAVEEN                         ET$001A18EF0001                TABLE                     VALID   18-may-2011 03:15:59      18-may-2013 03:15:59

PRAVEEN                         ET$009802870001                TABLE                     VALID   12-may-2011 09:26:44      12-may-2013 09:26:44

PRAVEEN                         ET$005800090001                TABLE                     VALID   12-may-2011 09:18:23      12-may-2013 09:18:23

PRAVEEN                         ET$005800070001                TABLE                     VALID   12-may-2011 09:16:42      12-may-2013 09:16:42

PRAVEEN                         ET$004300050001                TABLE                     VALID   12-may-2011 09:07:09      12-may-2013 09:07:09

PRAVEEN                         ET$004300030001                TABLE                     VALID   12-may-2011 09:06:07      12-may-2013 09:06:07

PRAVEEN                         ET$001802470001                TABLE                     VALID   12-may-2011 09:05:11      12-may-2011 09:05:11

PRAVEEN                         ET$000400390001                TABLE                     VALID   12-may-2011 09:02:55      12-may-2013 09:02:55

8 rows selected.

  

SQL> select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE

from dba_external_tables order by 1,2

 /

OWNER                          TABLE_NAME                     DEFAULT_DIRECTORY_NAME         ACCESS_

------------------------------ ------------------------------ ------------------------------ -------

PRAVEEN                         ET$000400390001                EXP_DIR1                       CLOB

PRAVEEN                         ET$001802470001                EXP_DIR1                       CLOB

PRAVEEN                         ET$001A18EF0001                EXP_DIR1                       CLOB

PRAVEEN                         ET$004300030001                EXP_DIR1                       CLOB

PRAVEEN                         ET$004300050001                EXP_DIR1                       CLOB

PRAVEEN                         ET$005800070001                EXP_DIR1                       CLOB

PRAVEEN                         ET$005800090001                EXP_DIR1                       CLOB

PRAVEEN                         ET$009802870001                EXP_DIR1                       CLOB

8 rows selected.

4.     To Drop the external temporary datapump tables.

SQL> drop table PRAVEEN.&tbl_name;

Enter value for tbl_name: ET$000400390001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$000400390001

Table dropped.

SQL> /

Enter value for tbl_name: ET$001802470001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$001802470001

Table dropped.

SQL> /

Enter value for tbl_name: ET$001A18EF0001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$001A18EF0001

Table dropped.

SQL> /

Enter value for tbl_name: ET$004300030001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$004300030001

Table dropped.

SQL> /

Enter value for tbl_name: ET$004300050001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$004300050001

Table dropped.

SQL> /

Enter value for tbl_name: ET$005800070001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$005800070001

Table dropped.

SQL> /

Enter value for tbl_name: ET$005800090001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$005800090001 

Table dropped.

SQL> /

Enter value for tbl_name: ET$009802870001

old   1: drop table PRAVEEN.&tbl_name

new   1: drop table PRAVEEN.ET$009802870001

Table dropped.

5.     To ensure there is no datapump temporary tables.

SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE, status,

to_char(CREATED,'dd-mon-yyyy hh24:mi:ss') created

,to_char(LAST_DDL_TIME , 'dd-mon-yyyy hh24:mi:ss') last_ddl_time

from dba_objects where object_name like 'ET$%'

/

no rows selected

  

 SQL> select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE from dba_external_tables order by 1,2

 /

no rows selected

Issue is solved.

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

Steps for ORA-00600: internal error code, arguments: [kccpb_sanity_check_2] (CONTROLFILE):

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

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

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 1304728 bytes

Variable Size 188745576 bytes

Database Buffers 415236096 bytes

Redo Buffers 7081984 bytes

2. change the control file settings

SQL> alter system set control_files=’E:\APP\PRAVEEN\ORADATA\ORACLE\CONTROL01.CTL’ scope=spfile

3. Restart the database

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 1304728 bytes

Variable Size 188745576 bytes

Database Buffers 415236096 bytes

Redo Buffers 7081984 bytes

Database mounted.

ORA-01113: file 4 needs media recovery if it was restored from backup, or END

BACKUP if it was not

ORA-01110: data file 4:

‘E:\APP\PRAVEEN\ORADATA\ORACLE\EXAMPLE01.DBF’

Database did not opened. Above error message displayed.

4. Now recover the database

SQL> recover database;

Media recovery complete.

Then control file settings should change again as in step 2 using CONTROL02.CTL’ and do the 3 and 4 steps as above.

Database recovery complete. Now restart the database, database will start in open mode.

Invalid Objects on SYS and ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors

Some Objects invalid on SYS, then used catalog.sql, catproc.sql, that made error:

SELECT dbms_registry_sys.time_stamp('PATCH_BGN') AS timestamp FROM DUAL
*

ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors

BEGIN dbms_registry.check_server_instance; END;

*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REGISTRY"
ORA-06512: at line 1

Some Objects invalid, we can recreate with scripts at ORACLE_HOME/rdbms/admin PATH
Example Object invalid:
DBMS_STATS_INTERNAL PACKAGE BODY ,DBMS_STATS PACKAGE BODY
We can recreate dbms_stats_internal & dbms_stats:

SQL> @?/rdbms/admin/prvtstas.plb
SQL> @?/rdbms/admin/prvtstat.plb

But Our Problem, we found many objects invalid on SYS, after used "catalog.sql", "catproc.sql"

SQL> startup migrate -- "backup database" before & if use RAC, should -- alter system set cluster_database=false scope=spfile -- before

SQL> startup upgrade -- If database is recently upgraded.
SQL> spool /tmp/catalog.log
SQL> @?/rdbms/admin/catalog.sql
SQL> spool off
SQL> spool /tmp/catproc.log
SQL> @?/rdbms/admin/catproc.sql
SQL> spool off

Below Error after used catproc.sql:

ORA-04063: package body "SYS.DBMS_REGISTRY" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REGISTRY"

Checked in spool file.

Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY DBMS_REGISTRY:

95/17 PL/SQL: Item ignored
95/21 PLS-00302: component 'REGISTRY$' must be declared

Checked objects invalid(Found many objects invalid):

select
decode( OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE || ' ' || OWNER||'.'||OBJECT_NAME || ' compile;' )
from
dba_objects a
where
STATUS = 'INVALID' and
OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE',
'TRIGGER', 'VIEW' )
and owner='SYS'
order by
OBJECT_TYPE,
OBJECT_NAME
/ 

What should we do ?
- recover database until time (if have backup & if necessary)
- check inconsistencies in the data dictionary(metalink 136697.1) hcheck package, then verify the reported inconsistency data dictionary + fix(manual)... and then run "catalog.sql", "catproc.sql" and "utlrp.sql" again.

Instructions:
1. Connect as SYS schema in sqlplus
2. Create package hout as described in Note:101468.1
3. Create package hcheck in SYS schema.
4. execute hcheck.full
5. verify the reported inconsistency

Then:

SQL> startup migrate
SQL> set serverout on
SQL> set echo on
SQL> spool report.txt
SQL> exec hcheck.full
SQL> spool off

Verifed(metalink 456468.1) the reported inconsistency data dictionary and fixed(manual), then:

SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql

No Error about DBMS_REGISTRY package.

Actually, we should solve a real problem, before use catalog/catproc.
The SYS.DBMS_REGISTRY problem, that made database couldn't do something (expdmp/exp, run utlrp.sql or ...)

By the way, Thank You Oracle Support for hcheck package.

For 10G +
$sqlplus "/as sysdba"
SQL> spool fix_cat_logfile.txt
SQL> startup upgrade
SQL> @?/rdbms/admin/catupgrd.sql
SQL> spool off

ORA-31634: job already exists

ORA-31634: job already exists

Error : Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORA-31634: job already exists
ORA-31664: unable to construct unique job name when defaulted

tail: cannot open input
Compressing exportfile..

Solution :
1. select owner_name,job_name,operation,state from DBA_DATAPUMP_JOBS ;
2. select owner_name,job_name,operation,state from DBA_DATAPUMP_JOBS where owner_name=’SCHEMA_NAME’; and output like
SCHEMA_NAME SYS_EXPORT_SCHEMA_60 EXPORT NOT RUNNING
SCHEMA_NAME SYS_EXPORT_SCHEMA_03 EXPORT NOT RUNNING
3. If output count of the above query Is 99 then
4. Either change the script and execute it using user "SYSTEM" instead of provided SCHEMA_NAME or connect to the provided schema and drop table SYS_EXPORT_SCHEMA_01; to drop table SYS_EXPORT_SCHEMA_99; (use the below script
5. select 'DROP TABLE '||owner||'.'||table_name||';'
from dba_tables
where table_name like '%SYS%EXPORT%';

'DROPTABLE'||OWNER||'.'||TABLE_NAME||';'
-------------------------------------------------------------------------
DROP TABLE TRINTA.SYS_EXPORT_FULL_01;

6. Re-execute the script.

The reason was : if the enteries in DBA_DATAPUMP_JOBS table become equals to 99 for any particular schema then "ORA-31634 : job already exists" occurs so make sure the entries must be below 99 in order to avoid above error .

How to find out failed jobs:

select job, what from dba_jobs where broken = 'Y' or failures > 0;