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!
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
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”
Hey everyone,
Finally, the last part of our flashback posts, FLASHBACK DATA ARCHIVE! If you didn’t have a chance to check the previous posts, please do not hesitate to take a look if you need or if you just get curious.
Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 4 (Flashback Transaction Query)
Flashback – Part 5 (Flashback Table)
Flashback – Part 6 (Flashback Database)
Well, there we go then 🙂
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”
As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).
More“ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases”
Hi people,
We’re almost there to finish this Flashback Tutorial 🙂
To check the previous posts, please go through:
Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 4 (Flashback Transaction Query)
Flashback – Part 5 (Flashback Table)
Flashback – Part 7 (Flashback Data Archive)
Today’s post is gonna be about Flashback Database, a pretty good feature for non-production levels of your structure, I would say.
It’s very unlikely that you are going to rollback your entire production database to a point-in-time in the past, right? But if you need to, this facility is there.
Why do I say that it is great for non-production environments?
More“Flashback – Part 6 (Flashback Database)”
Sounds weird creating table does not raise any error, but inserting a correct tuple in this table raise a permission error, right? Just take a look:
SQL> create table matheusdba.table_test(a number) tablespace TEST_TABLESPACE; Table created. SQL> insert into matheusdba.table_test values (1); insert into matheusdba.table_test values (1) * ERROR at line 1: ORA-01950: no privileges on tablespace 'TEST_TABLESPACE'
Hi all!
Just a curiosity: Have you ever noticed in a database alert log the occourance of the following message for every logfile switch:
Thread 1 cannot allocate new log, sequence 9281 Private strand flush not complete Current log# 5 seq# 9280 mem# 0: /db/u5001/oradata/GREPORADB/redo05a.log Thread 1 advanced to log sequence 9281 (LGWR switch) Current log# 6 seq# 9281 mem# 0: /db/u5001/oradata/GREPORADB/redo06a.log
More“Alert Log: “Private Strand Flush Not Complete” on Logfile Switch”
