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 NEW_PASSWORD .
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
In weblogic 11G, there are several JFR files in /tmp directory:
root@app1wsora3 tmp]# pwd; find . -name *.jfr |xargs ls -tlhr
-rw——- 1 oracle oinstall 0 Aug 11 18:41 ./2016_06_02_13_50_22_4317/2016_08_11_18_41_43_4317.jfr
-rw——- 1 oracle oinstall 37M Aug 11 18:41 ./2016_06_02_13_50_22_4317/2016_08_01_11_22_51_4317.jfr
-rw——- 1 oracle oinstall 14M Aug 16 09:25 ./2016_06_02_13_50_15_4341/2016_08_16_03_24_12_4341.jfr
-rw——- 1 oracle oinstall 0 Aug 16 12:02 ./2016_06_02_13_50_15_4341/2016_08_16_12_02_02_4341.jfr
-rw——- 1 oracle oinstall 14M Aug 16 12:02 ./2016_06_02_13_50_15_4341/2016_08_16_09_25_39_4341.jfr
-rw——- 1 oracle oinstall 0 Aug 16 12:43 ./2016_06_02_13_50_24_4344/2016_08_16_12_43_28_4344.jfr
-rw——- 1 oracle oinstall 150M Aug 16 12:43 ./2016_06_02_13_50_24_4344/2016_08_16_12_17_36_4344.jfr
These files are from DMS (Dynamic Monitoring Service) and they are created when application server is running.
I was taking high workload with data load methods, so I decided to move out of comfort zone and fortunately discovered a excellent way to copy/move high data volume with GoldenGate Initial Load.
It’s well documented by Oracle and gavinsoorma.com (best and simple one).
# On source GoldenGate (ggsci>):
GGSCI> ADD EXTRACT load1, SOURCEISTABLE
GGSCI> EDIT PARAMS load1
RMTHOST target-mgr.grepora.com, MGRPORT 7809
RMTTASK replicat, GROUP load2 FORMAT LEVEL 4