Month: August 2016

ODI

ODI 10gR1: Connection to Repository Failed after Database Descriptor Change

 , , , ,

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”

Application | Middleware | GoldenGate, Errors and Bugs, ODI, Shell Scripts

Failure to create ODI schedule

 , ,

Hi,

Today, as in another normal days, I found a problem with ODI schedule in the newly created enviroment. While creating a schedule to scenario execution, then clicked in update schedule in Topology > Agents > OracleDIAgent, I received an exception:

ODI-1274: Agent Exception Caused by: Could not find the AgentScheduler instance in order to process 'OdiComputePlanning' request

 

Oracle support has a solution for this exception, but only for ODI 12c, it happens that my enviroment is ODI 11.1.1.6, in community oracle, has the same question, but, without answer.

More“Failure to create ODI schedule”

Community, Events

GUOB Tech Day 2016: Review!

 , , ,

Hi guys!

As you know, last week I was in 7th edition of GUOB Tech Day, in São Paulo/Brazil, part of OTN LA Tour. As it use to be, it was a great experience. As usual, after an opening with Oracle and OTN speech we had some parallel sessions, so I unfortunately had to choose only a few of them. But it think I made a good selection. Here is the list:

More“GUOB Tech Day 2016: Review!”

Database, Shell Scripts

ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases

 , , , , ,

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).

adr1

ADR Structure

More“ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases”

Database

Flashback – Part 6 (Flashback Database)

 ,

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)”