Duplicate Command Failed: RMAN-05001: auxiliary filename %s conflicts with a file used by the target database


Error Description:
RMAN Duplicate database command failed with RMAN-05001 error message
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 21/10/2012 23:09:54
RMAN-05501: aborting duplication of target database

OC4J Connection Pool Error Message: java.sql.SQLException: ORA-01017: invalid username/password; logon denied


Error Description:
OC4J connection pool configuration testing to Oracle 11g database is giving following error.
OC4J Error message: Exception occurred testing connection. Exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied 

Fix ORA-02032: clustered tables cannot be used before the cluster index is built


Error Description:
Insert SQL statement fails with following error message.

SQL> insert into emp values (7369, 'smith', 'clerk', 7902,to_date('17-dec-1980', 'dd-mon-yyyy'), 800, null, 20);

Truncate Failed: ORA-03292: Table to be truncated is part of a cluster


Error Description:
Truncate table command failed with following error message.
SQL> TRUNCATE TABLE DEPT;
TRUNCATE TABLE DEPT
               *

Shell Script to Run RMAN Backup in Background with nohup

Step 1. Prepare a RMAN command file

vi bkup.cmd
run

Move Subpartition for an Interval Partitioned Table Failed: ORA-00600 [kkpod nextFrag]

Error Description:
Alter table move subpartition on an interval partitioned table is failed with following error. Also the session got disconnected.

Fix IMP-00013: only a DBA can import a file exported by another DBA


Error Description:
Import using imp utility is failing with following error.

Export file created by EXPORT:V11.02.00 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer