When trying to start or increase parallel of recover manager on datagauard (MRP):
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; * ERROR at line 1: ORA-01153: an incompatible media recovery is active
I simply happen because there already are a process runnning, let’s check:
Hi all!
It’s a recurrent subject, right? But no one is 100% sure to how figure this out… So, let me quickly show you my way:
– Physical CPUs (sockets):
[root@mysrvr ~]# grep -i "physical id" /proc/cpuinfo | sort -u | wc -l
2
[root@mysrvr ~]# dmidecode -t processor |grep CPU
Version: Intel(R) Xeon(R) CPU X5570 @ 2.93GHz
Version: Intel(R) Xeon(R) CPU X5570 @ 2.93GHz
So, 2 physical CPUs.
– Physical Cores
[root@mysrvr ~]# egrep -e "core id" -e ^physical /proc/cpuinfo|xargs -l2 echo|sort -u physical id : 0 core id : 0 physical id : 0 core id : 1 physical id : 0 core id : 2 physical id : 0 core id : 3 physical id : 1 core id : 0 physical id : 1 core id : 1 physical id : 1 core id : 2 physical id : 1 core id : 3
Each one of Physical Processors has 4 cores.
So, there is two quad-cores. This way, we have 8 cores at all.
– Logical CPUs
[root@mysrvr ~]# grep -i "processor" /proc/cpuinfo | sort -u | wc -l 16
Ok, so we have cores in double.
This means we have Hyper-Threading (technology by Intel Processors).
Not so hard, right?
Those links are similar and quite cool to understand the concepts:
https://access.redhat.com/discussions/480953
https://www.redhat.com/archives/redhat-list/2011-August/msg00009.html
http://www.intel.com/content/www/us/en/architecture-and-technology/hyper-threading/hyper-threading-technology.html
Matheus.
Hi all!
While selecting on x$kglob with DBA credentials hanging on:
SQL> select count(*) from sys.x$kglob; ERROR at line 1: ORA-00942: a tabela ou view não existe
But with sys it succeed. Ok, let’s grant privilege:
SQL> grant select on sys.x$kglob to dba; grant select on sys.x$kglob to dba * ERROR at line 1: ORA-02030: can only select from fixed tables/views
What a hell! I couldn’t grant it any way!
So the MCGayver solution was:
More“x$kglob: ORA-02030: can only select from fixed tables/views”
Hi all!
As the oldest readers know, someday I had to found some entries in the alertlog and I had a really big log. So I jerrry-ringed some scripts for grepping alert with auxiliar files and etc.
I can see the posts here: Grepping Alert by Day and Grepping Entries from Alert.log.
So… They are functional, but probably the worst ways to get it. I didn’t know and was innocent to not search by the view x$dbgalertext.
There is also possible to write on alert through the procedure SYS.DBMS_SYSTEM.KSDWRT.
Ok, so let me fix this situation with theese two good guys: @write_alert and @find_alert
When using PL/SQL Developer (Allround Automations), a internal query is taking a lot of cpu cycles on database server (100% of a CPU).
Is this your problem? Please check if the query is like this:
select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
It’s caused by the Describe Context Option of Code Assistant. To disable it:
Tools > Preferences > Code Assistant and disable the “Describe Context” option.
Hi all!
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:
More“ORA-02296: cannot enable (string.) – null values found”
Hi Guys!
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. 🙂
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
More“ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors”
Hi all!
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; Database altered. 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
More“After adding Datafile in Primary the MRP Stopped in Physical Standby (Dataguard)”
After migrating database to another host, port or SID, the error below started to happen when running a scenario.
“Of course” all mapped connection was right setted on Topology… But environment is complex, it’s possible something is missing…
java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:361) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:151) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595) at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java) at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java) at com.sunopsis.sql.h.run(h.java)
Ok, so something really is missing… But where?
Try to check this:
More“ODI 10gR1: Connection to Repository Failed after Database Descriptor Change”