ODI-1400 and ODI-1545: Missing odi supervisor credentials in credential store map

Version:

ODI 11.1.1.7.0 64 bit

Issue:

The startManagedWeblogic log has following errors and OracleDIAgent status would be down in Enterprise Manager.

Unable to set the activation state to true for the application 'oraclediagent'.
weblogic.application.ModuleException: [HTTP:101216]Servlet: "AgentServlet" failed to preload on startup in Web application: "oraclediagent".

ODI-1400: Agent OracleDIAgent start failure: JDBC connection error occurs while connecting to the master repository.

Caused by: ODI-1545: Missing odi supervisor credentials in credential store map [oracle.odi.credmap] with key [SUPERVISOR].

Reason:

Security must be set up for the JAVA EE application to have access to the ODI repository. The entry will be created within the credential store, which will allow the JAVA EE Agent to authenticate itself to be able to use the required resources. The user is already set up in the ODI Security, in this case SUPERVISOR.

Action:

Execute Web Logic Scripting Tool (WLST), connect to our running Admin server and add the credential store

Steps:

1. Start WLST and connect

cd $ODI_HOME/common/bin

wlst.sh

wls:/offline> connect('weblogic','welcome1','t3://hostname.domain:7001')

2. Add the correct credential store for ODI Supervisor 

createCred (map="oracle.odi.credmap", key="SUPERVISOR", user="SUPERVISOR", password="SUNOPSIS", desc="ODI SUPERVISOR Credential")

Eg:
wls:/odi11g_domain/serverConfig> createCred(map="oracle.odi.credmap", key="SUPERVISOR", user="SUPERVISOR", password="sunopsis", desc="ODI SUPERVISOR Credential") 
Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root. 
For more help, use help(domainRuntime)

3. Add the correct credential store for the  ODI Domain

createCred (map="oracle.odi.credmap", key="ODI Domain Name", user="weblogic", password="welcome1", desc="ODI-DOMAIN Credential")

Eg:
createCred(map="oracle.odi.credmap", key="odi11g_domain", user="weblogic", password="welcome1", desc="ODI-DOMAIN Credential")


4. Restart the Managed Server

./startManagedServer.sh odi_server1

Note:

To delete the credentials you can use deleteCred function from wlst

Eg:

deleteCred(map="oracle.odi.credmap", key="SUPERVISOR")

Oracle 12c PDB: user_dump_dest and trace file location

Version

Oracle DB 12c

USER_DUMP_DEST in PDB

The parameter user_dump_dest is deprecated in 12c. It is replaced by diagnostic_dest parameter from 11g.

Also this parameter cannot be set at PDB level. Even if it is set it doesnt have any impact and will be ignored.

Location of trace files

By default the trace files would get generated under the CDB folders under
diagnostic_dest.

diagnostic_dest                      string      /data/app/oracle

To identify issue the following query from PDB or CDB

SQL>  select value from v$diag_info where name='Diag Trace';

VALUE
--------------------------------------------------------------------------------
/data/app/oracle/diag/rdbms/orcl/orcl/trace

where orcl is my CDB name.


Verify the Path

Connect to the PDB instance and do a sample trace

SQL>  alter session set tracefile_identifier=trace_location;

SQL>  alter session set events '10046 trace name context forever, level 12';

SQL>  show parameter user_dump_dest

SQL>  select value from v$diag_info where name='Diag Trace';

SQL>  select value from v$diag_info where name='Default Trace File';

SQL>  exit

The trace file with the trace_location would be created under the folder /data/app/oracle/diag/rdbms/orcl/orcl/trace

DB Upgrade failure: wallet is not open

Scenario:

A database for which wallet is configured is being upgraded from version 11.2.0.3.0 to 11.2.0.4.0.
DB upgrade is done using DBUA

Issue:

During the initial phase of upgrade process when the DB is stopped and restarted, the upgrade process halts throwing "wallet is not open" message. 

Reason:

When the upgrade process is initiated from the new DB Home it doesn't have details to provide for the wallet file location, without which the database cannot be opened.

Solution:

Copy the sqlnet.ora file from the existing 11.2.0.3.0 Home to 11.2.0.4.0 Home's network/admin folder. Re-initiate the upgrade process

This will make the DB aware of the wallet path and the database can be opened easily

Opatch Error: The patch directory area must be a number.

Situation:

Applying  Oct 2014 SPU to Oracle DB software using opatch utility

DB Version: 11.2.0.4.0


Error:

The patch directory area must be a number.

ERROR: OPatch failed because of problems in patch area.


Solution:

Upgraded opatch to latest version.

After upgrade the patch application went smooth.

It can happen for other reasons also like  if  we try to apply a wrong release patch or instead of "opatch napply" "opatch apply" is  tried etc