ORA-01841: (full) year must be between -4713 and +9999, and not be 0

the solution of this problem is simple;

before starting rman ; setting NLS_LANG  like the example below

ORA-00392

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 01/31/2012 11:30:04

ORA-00392: log 2 of thread 1 is being cleared, operation not allowed

ORA-00312: online log 2 thread 1: '/oradata2/database/onlinelog/redolog_22.log'

ORA-00312: online log 2 thread 1: '/oradata1/database/onlinelog/redolog_21.log' 

 

 

 

SQL> alter database clear logfile group 2;

Database altered.

 

SQL> alter database drop logfile group 2;

How to enable and disable ALL Jobs in ORACLE

u can use this query to disable or enable all jobs except EXFSYS,ORACLE_OCM,SYS.. u can simply chose in which owners should be not by adding user names at the end of script...

TO DISABLE
TO ENABLE


just run outputs...

Enterprise Manager (Emctl) Droping and Recreating..

First of all ; if its needed to set host;

u can drop by using

or recreating

how to handle with The listener supports no services problem

add these lines in listener.ora
dont forget to modify ORACLE_HOME,SID_NAME and HOST....

Creating DB_LINK with dbms_metadata.get_ddl

select dbms_metadata.get_ddl('DB_LINK','db_link_already_created',user) from dual;

dont forget to replace "db_link_already created"