Found the error below?
greporadb> alter table TABLE_TEST modify COLUMN_TEST not null;
alter table TABLE_TEST modify COLUMN_TEST not null
ERROR at line 1:
ORA-02296: cannot enable (MATHEUSDBA.) - null values found
It happen basically because you have null values for this column. Let’s check:
Reset the AdminServer Password in WebLogic 11g and 12c:
mv data data-old
java weblogic.security.utils.AdminAccount weblogic .
Restart the AdminServer.
If the weblogic has the file boot.properties in $DOMAIN_HOME/servers/AdminServer/security/, should be adjusted the credentials of user and password, before restart the AdminServer.
OBS: Check the post on decrypt datasource password, which can also be used to decrypt the credentials of boot.properties file, avoiding making the above procedure, if this file exists.
That’s all for today.
Today the blog crossed the 10k accesses in 2016. In this year, every month have more access than the month before it. So, we are growing every day together. And it’s beeing a pleasure to us.
This post is here to thank you for all supporting, visiting and specially for keeping us motivated to sharing every week our experiences and discovers.
Here are some cute images about 10k, that a I searched and couldn’t choose just one. 🙂
In the latest post, I documented how to copy/move high table data volume using GoldenGate Initial Load (with SPECIALRUN option).
Sometimes, we (dba/sysadmins) need to move HIGH data (tables with billion rows), in shortest time possible.
So, sharing useful tips, that helps to reach this goal.
Making GoldenGate Initial load work as PARALLEL:
Due to ease in which we can go to the future or return to the past using Goldengate, it becomes increasingly necessary recover archives from backup, sometimes it is necessary to recover a several days.
To do it, generally we need large disk space, at this time, starts a searching for storage disks.
After finding a disk, is need to mount it, i performed with simply mount options in AIX.
ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors
A database is raising stack below on alertlog:
Errors in file /db/u7011/oracle/admin/MYDB/trace/MYDB_j002_22935.trc:
ORA-12012: error on auto execute of job "SYS"."DRA_REEVALUATE_OPEN_FAILURES"
ORA-48168: the ADR sub-system is not initialized
ORA-06512: at "SYS.DBMS_IR", line 522
After add a datafile in PRIMARY database, the STANDBY MRP stopped. An “ALTER DATABASE RECOVER MANAGED STANDBY DATABASE” does not solved te problem, as you see:
SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED 'YES' and SEQUENCE# ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
SQL> SELECT SEQUENCE#, Name, APPLIED FROM V$ARCHIVED_LOG where APPLIED 'YES' and SEQUENCE# < (select max(SEQUENCE#) -1 from V$ARCHIVED_LOG);
SEQUENCE# NAME APPLIED
---------- -------------------------------------------------------------------------------- ---------
15075 /db/u1004/oracle/admin/MYDB/arch/arch_1_823102978_15075.arc NO